Thread: CSV viewer?
View Single Post
robthebold is offline robthebold
2021-02-11 , 17:05
Posts: 1,038 | Thanked: 3,981 times | Joined on Nov 2010 @ USA
#3
SFOS has python support, and python has a csv module. If you want to get your hands (a little) dirty you could adapt the examples here to do the job for you. . . . Ooh, it looks like there's higher level library, too, called "pandas".

This script:

Code:
import pandas
df = pandas.read_csv('hrdata.csv')
print(df)
Turns this csv file:

Code:
Name,Hire Date,Salary,Sick Days remaining
Graham Chapman,03/15/14,50000.00,10
John Cleese,06/01/15,65000.00,8
Eric Idle,05/12/14,45000.00,10
Terry Jones,11/01/13,70000.00,3
Terry Gilliam,08/12/14,48000.00,7
Michael Palin,05/23/13,66000.00,8
Into this output:

Code:
             Name Hire Date   Salary  Sick Days remaining
0  Graham Chapman  03/15/14  50000.0                   10
1     John Cleese  06/01/15  65000.0                    8
2       Eric Idle  05/12/14  45000.0                   10
3     Terry Jones  11/01/13  70000.0                    3
4   Terry Gilliam  08/12/14  48000.0                    7
5   Michael Palin  05/23/13  66000.0                    8
Wow, not bad for three lines of code.

p.s. The mighty N900 had gnumeric . . . I miss that.
 

The Following 5 Users Say Thank You to robthebold For This Useful Post: