/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

0 vote185 views1 answer
How can I print all items in a tuple, separated by commas?
Python
31 votes188 views4 answers
Float to string python
Python
8 votes179 views2 answers
Python use functions from another file
Python
0 vote200 views1 answer
Battery status from whatsapp web
Python
1 vote180 views1 answer
Python tomorrow
Python
0 vote192 views1 answer
How to capture multiple screens with ImageGrab
Python
0 vote192 views1 answer
Read ms word with python
Python
0 vote150 views1 answer
Neo4j python
Python
0 vote167 views1 answer
How to save string json to json object python
Python
0 vote203 views1 answer
Urllib.error.HTTPError: HTTP Error 403: Forbidden
Python