Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Pandas printing ALL dtypes

This seems like a very simple problem, however it's driving me round the bend. I'm sure it should be solved by RTFM, but I've looked at the options and I can see the one to fix it.

I just want to print the dtypes of all columns, currently I'm getting:

print df.dtypes #> Date         object Selection    object Result       object ... profit    float64 PL        float64 cumPL     float64 Length: 11, dtype: object 

I've tried setting options display.max_row, display.max_info_row, display.max_info_columns all to no avail.

What am i doing wrong?

Pandas version = 0.13.1


Update:

Turns out I was being and idiot and hadn't set display.max_row to a high enough value.

Solution was:

pd.set_option('display.max_rows', 20) 
like image 946
SColvin Avatar asked Apr 19 '14 09:04

SColvin


People also ask

How do you get the data types of all columns in pandas?

To check the data type in pandas DataFrame we can use the “dtype” attribute. The attribute returns a series with the data type of each column. And the column names of the DataFrame are represented as the index of the resultant series object and the corresponding data types are returned as values of the series object.

How many Dtypes are in pandas?

pandas. Series has one data type dtype and pandas. DataFrame has a different data type dtype for each column. You can specify dtype when creating a new object with a constructor or reading from a CSV file, etc., or cast it with the astype() method.

What does Dtypes do in pandas?

The dtypes property returns data type of each column in the DataFrame.


1 Answers

I tried this and worked:

df.info(verbose=True) 
like image 152
chok68 Avatar answered Oct 09 '22 02:10

chok68