Output data from all columns in a dataframe in pandas
pandas, python
Solution
There is too much data to be displayed on the screen, therefore a summary is displayed instead.
If you want to output the data anyway (it won't probably fit on a screen and does not look very well):
print paramdata.values
converts the dataframe to its numpy-array matrix representation.
paramdata.columns
stores the respective column names and
paramdata.index
stores the respective index (row names).
Problem
I have a csv file with the name `params.csv`. I opened up `ipython qtconsole` and created a pandas `dataframe` using: ``` import pandas paramdata = pandas.read_csv('params.csv', names=paramnames) ``` where, `paramnames` is a python list of string objects. Example of `paramnames` (the length of actual list is 22): ``` paramnames = ["id", "fc", "mc", "markup", "asplevel", "aspreview", "reviewpd"] ``` At the ipython prompt if I type `paramdata` and press enter then I do not get the dataframe with columns and values as shown in examples on Pandas website. Instead, I get information about the dataframe. I get: ``` In[35]: paramdata Out[35]: <class 'pandas.core.frame.DataFrame'> Int64Index: 59 entries, 0 to 58 Data columns: id 59 non-null values fc 59 non-null values mc 59 non-null values markup 59 non-null values asplevel 59 non-null values aspreview 59 non-null values reviewpd 59 non-null values ``` If I type `paramdata['mc']` then I do get the values as expected for the `mc` column. I have two questions: (1) In the examples on the pandas website (see, for example, the output of `df` here: http://pandas.sourceforge.net/indexing.html#additional-column-access) typing the name of the dataframe gives the actual data. Why am I getting information about the dataframe as shown above instead of the actual data? Do I need to set some output options somewhere? (2) How do I output all columns in the dataframe to the screen without having to type their names, i.e., without having to type something like `paramdata[['id','fc','mc']]`. I am using pandas version 0.8. Thank you.