/Python/Astype float across columns pandas

Astype float across columns pandas

Set column datatype pandas

df = pd.read_csv("weather.tsv", sep="\t",  
                 dtype={'Day': str,'Wind':int64})
df.dtypes

Source: cmdlinetips.com

Astype float across columns pandas

In [273]: cols = df.columns.drop('id')

In [274]: df[cols] = df[cols].apply(pd.to_numeric, errors='coerce')

In [275]: df
Out[275]:
     id    a  b  c  d  e    f
0  id_3  NaN  6  3  5  8  1.0
1  id_9  3.0  7  5  7  3  NaN
2  id_7  4.0  2  3  5  4  2.0
3  id_0  7.0  3  5  7  9  4.0
4  id_0  2.0  4  6  4  0  2.0

In [276]: df.dtypes
Out[276]:
id     object
a     float64
b       int64
c       int64
d       int64
e       int64
f     float64
dtype: object

Source: stackoverflow.com

Astype float across columns pandas

cols = df.columns[df.dtypes.eq('object')]

Source: stackoverflow.com

Similar codes

1 vote317 views1 answer
Python discord how to get user variables
Python
2 votes286 views1 answer
Hide root window tkinter
Python
0 vote368 views2 answers
Django render template
Python Django
2 votes311 views2 answers
Replace nan numpy array
Python
0 vote358 views1 answer
How to insert a placeholder text in django modelform
Python Django
0 vote295 views1 answer
Create new dataframe from existing data frame python
Python
14 votes310 views3 answers
Terminal python version
Python
11 votes329 views2 answers
How to pause code for some time in python
Python
1 vote343 views1 answer
How to retrieve dictionary values in python by index
Python
0 vote313 views1 answer
Get key from value dictionary py
Python