Setup
借用@MaxU的df
df = pd.DataFrame([
[1, 2, 3],
[4, None, 6],
[None, 7, 8],
[9, 10, 11]
], dtype=object)
Solution
你可以只使用pd.DataFrame.dropna https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.dropna.html as is
df.dropna()
0 1 2
0 1 2 3
3 9 10 11
假设你有None
像这样的字符串df
df = pd.DataFrame([
[1, 2, 3],
[4, 'None', 6],
['None', 7, 8],
[9, 10, 11]
], dtype=object)
然后结合dropna
with mask
df.mask(df.eq('None')).dropna()
0 1 2
0 1 2 3
3 9 10 11
您可以确保整个数据框是object
当你与.
df.mask(df.astype(object).eq('None')).dropna()
0 1 2
0 1 2 3
3 9 10 11