问Python Pandas:如何删除数据类型为'Object‘的行？

EN

import pandas as pd 
df1 = pd.DataFrame({'A' : [0,1,2,3,'?'], 
             'B' : [2,4,5,'?',9],
             'C' : [0,'?',2,3,4]})

print(df1)

   A  B  C
0  0  2  0
1  1  4  ?
2  2  5  2
3  3  ?  3
4  ?  9  4

print(df1.loc[~df1.eq('?').any(1)])

   A  B  C
0  0  2  0
2  2  5  2

df1.select_dtypes('object').eq('?').any(1)

0    False
1     True
2    False
3     True
4     True
dtype: bool

df1 = pd.DataFrame({'A' : [0,1,2,3,'?'], 
             'B' : [2,4,5,' ?',9],
             'C' : [0,'? ',2,3,4]})

df1.eq('?').any(1)
0    False
1    False
2    False
3    False
4     True
dtype: bool

df1.replace('(\s+\?)|(\?\s+)',r'?',regex=True).eq('?').any(1)

0    False
1     True
2    False
3     True
4     True
dtype: bool

str_cols = df1.select_dtypes('object').columns
df1[str_cols] = df1[str_cols].apply(lambda x : x.str.strip())

df1.eq('?').any(1)

0    False
1     True
2    False
3     True
4     True
dtype: bool