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

0 vote361 views1 answer
Django retrieveupdatedestroyapiview
Python Django
0 vote343 views1 answer
Diamond shape alphabatical pattern program in python
Python
0 vote343 views1 answer
DRF: get ip address
Python
0 vote350 views1 answer
How to get height of 2d array in python
Python
1 vote346 views1 answer
Error: command 'x86_64-linux-gnu-g++' failed with exit status 1 ---------------------------------------- ERROR: Failed building wheel for OpenEXR
Python
0 vote360 views3 answers
Get operator as input in python
Python
0 vote339 views1 answer
Delete dataframe from memory python
Python
21 votes335 views5 answers
How to open a website using python
Python
85 votes377 views4 answers
Create python executable
Python
1 vote338 views1 answer
Left join outer apply
Python