storing csv file in table variable in Python

Rayne
Rayne used Ask the Experts™
on
Hi All,

As we know that in R language you can store a  data file into a data.table and can do all kinds of data manipulations to the table variable. data.table has got a lot of built in methods that could be used to do data manipulations on that table object....

Can i do similar - like read and store a csv file into a data.table (how to do it in python)? so that i can do all kinds of manupulation to it,? can you show me some sample python code example.
Does python can got something similar...like a table object that I can use? or anything close?

Thank you
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Commented:
There is no standard module/functionality similar to R data.table in Python. I do not have a first hand experience, but you may want to use the pandas library, its pandas.DataFrame, and the functions pandas.read_csv and the pandas.DataFrame.to_csv.
Rayne

Author

Commented:
Thank you Pepr, Pandas the way to go, confirmed :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial