Unable to read csv correctly using pandas in ipython

This is the place for queries that don't fit in any of the other categories.

Unable to read csv correctly using pandas in ipython

Postby AEA » Sun Sep 01, 2013 12:11 am

Hey guys,

I have been following the tutorial
Code: Select all
http://www.youtube.com/watch?v=p8hle-ni-DM
in order to try and manipulate some of my own data. However when I attempt to manipulate my data using the following code:
Image
then it returns the following
Image
in the tutorial it returns a simple organised table of the data. Can anyone tell me why this isn't achieved for my data? I have attached a csv containing my data.

Any help or advice regarding this would be greatly appreciated.

Kind regards

AEA
Attachments
main.csv
(2.97 KiB) Downloaded 29 times
AEA
 
Posts: 32
Joined: Thu Apr 18, 2013 11:37 am

Re: Unable to read csv correctly using pandas in ipython

Postby stranac » Sun Sep 01, 2013 8:58 am

You should post your code in code tags, rather than posting screenshots. You should know that by now...

By default, if it can not fit all the data inside the width of the output display, pandas prints a summary like that.
But you can make it print as much data as you want.
This should make it print all of your columns:
Code: Select all
pandas.set_option('display.max_columns', 38)
Friendship is magic!

R.I.P. Tracy M. You will be missed.
User avatar
stranac
 
Posts: 1144
Joined: Thu Feb 07, 2013 3:42 pm


Return to General Coding Help

Who is online

Users browsing this forum: W3C [Linkcheck] and 4 guests

cron