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

2 votes223 views1 answer
How to make exe from.py file
Python
1 vote176 views1 answer
Python read entire file as string
Python
0 vote176 views1 answer
Visualizzare csv in pycharm pandas read_csv
Python
0 vote189 views1 answer
Convert to ascii
Python
0 vote163 views1 answer
Install matplotlib on nvidia jetson nx
Python
15 votes267 views4 answers
Django python install
Python Django
2 votes171 views1 answer
Python cv2 screen capture
Python
39 votes181 views3 answers
ModuleNotFoundError: No module named 'matplotlib'
Python
1 vote178 views1 answer
How to aggregate multiple columns in pyspark
Python
0 vote174 views1 answer
How to output index of list python without braquets
Python