pythoncsv数据类型_Python-如何获取CSV文件中所有列的数据类型？

I am trying to get all data types from a CSV file for each column.

There is no documentation about data types in a file and manually checking will take a long time (it has 150 columns).

Started using this approach:

df = pd.read_csv('/tmp/file.csv')

>>> df.dtypes

a int64

b int64

c object

d float64

Is above approach good enough or there is a better approach to figure out data types?

Also - file has 150 columns. When I type df.types - I can see only 15 or so columns. How to see them all?

解决方案

Depending on the size of your file, you might be able to save some time by only reading in the first few rows, using the nrows argument of pd.read_csv:

df = pd.read_csv('/tmp/file.csv', nrows=25)

This is only useful if you know for sure