Pandas converters example

In [3]:    
df = pd.read_csv(io.StringIO(t), dtype=object).info()

<class 'pandas.core.frame.DataFrame'>
Int64Index: 1 entries, 0 to 0
Data columns (total 4 columns):
int      1 non-null object
float    1 non-null object
date     1 non-null object
str      1 non-null object
dtypes: object(4)
memory usage: 40.0+ bytes

Source: stackoverflow.com

Pandas converters example

In [6]:
pd.read_csv(io.StringIO(t), dtype={'int':'object'}, parse_dates=['date']).info()

<class 'pandas.core.frame.DataFrame'>
Int64Index: 1 entries, 0 to 0
Data columns (total 4 columns):
int      1 non-null object
float    1 non-null float64
date     1 non-null datetime64[ns]
str      1 non-null int64
dtypes: datetime64[ns](1), float64(1), int64(1), object(1)
memory usage: 40.0+ bytes

Source: stackoverflow.com

Pandas converters example

In [5]:
pd.read_csv(io.StringIO(t), converters={'date':pd.to_datetime}).info()

<class 'pandas.core.frame.DataFrame'>
Int64Index: 1 entries, 0 to 0
Data columns (total 4 columns):
int      1 non-null int64
float    1 non-null float64
date     1 non-null datetime64[ns]
str      1 non-null int64
dtypes: datetime64[ns](1), float64(1), int64(2)
memory usage: 40.0 bytes

Source: stackoverflow.com

Similar codes

1 vote103 views2 answers
'Sequential' object has no attribute 'predict_classes'
Python
-1 vote99 views2 answers
Dd-mm-yy to yyyy-mm-dd in python
Python
1 vote114 views2 answers
Python socket check if still connected
Python
2 votes111 views3 answers
Pytorch check if using gpu
Python
0 vote114 views1 answer
Pandas read csv skip rows
Python
0 vote92 views1 answer
Python find first char index from a string stackoverflow
Python
3 votes98 views2 answers
Resize numpy array image
Python
9 votes105 views6 answers
Python absolute path
Python
8 votes117 views6 answers
AttributeError: type object 'datetime.datetime' has no attribute 'datetime'
Python
0 vote108 views1 answer
How to alight and place ipywidgets
Python