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)
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.
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.
The dtypes property returns data type of each column in the DataFrame.
I tried this and worked:
df.info(verbose=True)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With