原数据中空值并没有留空,而是用“\“,”-“,”无“等字符标注,有什么好办法可以处理?
import pandas as pd
data = [[100], ['/'], ['无'], [99]]
columns = ['成绩']
df = pd.DataFrame(data = data, columns = columns)
df
df['新成绩'] = pd.to_numeric(df.成绩.astype(str).str.replace(',', ''), errors = 'coerce').fillna(0).astype(int)
df