我有一个数据框,其中包含许多NoneType
值,我想要删除所有行值和列名都为None
的列。我无法找到一种方法来实现这个目标。在下面的MWE中,我要么删除所有行都为None
的列,要么删除所有列名为None
的列。
from __future__ import annotations
import pandas as pd
d = [[1, 2, None, None, None], [4, 5, None, None, 7]]
cols = ['a', 'b', 'c', None, None]
df = pd.DataFrame(data=d, columns=cols)
print("Original: \n", df)
#Original:
# a b c NaN NaN
#0 1 2 None None NaN
#1 4 5 None None 7.0
print("\nDropped how = all: \n", df.dropna(axis=1, how="all")) # Drops column 'c'
#Dropped how = all:
# a b NaN
#0 1 2 NaN
#1 4 5 7.0
print("\nDropped None columns: \n", df[df.columns.dropna()])
#Dropped None columns:
# a b c
#0 1 2 None
#1 4 5 None
我如何只删除我想要删除的列并获得这样的结果?
#Wanted:
# a b c NaN
#0 1 2 None NaN
#1 4 5 None 7.0