I want to import an excel spread sheet into Python so I can then manipulate the data, how do I got about this?
Asked
Active
Viewed 554 times
0
-
3When I had to do this I had to create a .csv file from the spreadsheet and then learn to use the csv import. As an example, I had questions such as http://stackoverflow.com/questions/20981936/python-dictread-of-csv-file-with-nul-bytes-in-data The question as you ask it is too broad. – sabbahillel Jan 29 '16 at 16:50
-
I'd probably read in the csv as a pandas dataframe, using ipython / jupyter, and go from there. A good place to start: http://pandas.pydata.org/pandas-docs/stable/tutorials.html – samthebrand Jan 29 '16 at 17:21