Pandas Read CSV various datatypes
Example with a few more column-types (e.g. the column with the title MyBool contains True and False values and it is recognized as bool)
examples/pandas/mixed.csv
MyText,MyInteger,MyFloat,MyBool,MyExit Joe,12,3.4,True,0 Jane,3,4,False,1 Mary,7,2.3,False,3
examples/pandas/mixed.py
import pandas as pd df = pd.read_csv('mixed.csv') print( df.dtypes ) print( df.describe() )
MyText object MyInteger int64 MyFloat float64 MyBool bool MyExit int64 dtype: object MyInteger MyFloat MyExit count 3.000000 3.000000 3.000000 mean 7.333333 3.233333 1.333333 std 4.509250 0.862168 1.527525 min 3.000000 2.300000 0.000000 25% 5.000000 2.850000 0.500000 50% 7.000000 3.400000 1.000000 75% 9.500000 3.700000 2.000000 max 12.000000 4.000000 3.000000