NaN
),您可以使用df.dropna
:df = df.dropna(axis=0, subset=['Charge_Per_Line'])
如果这些值真的是-
,那么您可以用np.nan
替换它们,然后使用df.dropna
:
如果这些值确实是“-”,则可以将它们替换为“np.nan”,然后使用“df.dropna”:
import numpy as np
df['Charge_Per_Line'] = df['Charge_Per_Line'].replace('-', np.nan)
df = df.dropna(axis=0, subset=['Charge_Per_Line'])
多种方式
Use str.contains to find rows containing '-'
df[~df['Charge_Per_Line'].str.contains('-')]
Replace '-' by nan and use dropna()
df.replace('-', np.nan, inplace = True)
df = df.dropna()