Pandas Check Column Is Float and Convert If Not

Feb 21, 2021
import pandas as pd items = [  {'name': 'Desmond', 'score': 1.5},  {'name': 'Jack', 'score': '0.369'},  {'name': 'Elon', 'score': 5}]df = pd.DataFrame(items) for index, row in df.iterrows():  print(row['name'], type(row['score']))
Desmond <class 'float'>
Jack <class 'str'>
Elon <class 'int'>
if df.score.dtype != 'float64':    df['score'] = df['score'].astype(float)for index, row in df.iterrows():  print(row['name'], type(row['score']))
Desmond <class 'float'>
Jack <class 'float'>
Elon <class 'float'

❤️ Is this article helpful?

Buy me a coffee ☕ or support my work via PayPal to keep this space 🖖 and ad-free.

Do send some 💖 to @d_luaz or share this article.

✨ By Desmond Lua

A dream boy who enjoys making apps, travelling and making youtube videos. Follow me on @d_luaz

👶 Apps I built

Travelopy - discover travel places in Malaysia, Singapore, Taiwan, Japan.