Pandas Check Column Is Float and Convert If Not

February 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'
This work is licensed under a
Creative Commons Attribution-NonCommercial 4.0 International License.