None, nan辨析
type(None)
$ NoneType
None == None
$ True
type(np.nan)
$ float
np.nan == np.nan
$ False
$ nothing equals to np.nan
$ 所以不要想着用==判断是不是空值呀!!!
pd.Series([np.nan]).sum()
$ 0.0
去掉nan值
df = pd.DataFrame({'age': [5, 6, np.NaN],
'born': [pd.NaT, pd.Timestamp('1939-05-27'),
pd.Timestamp('1940-04-25')],
'name': ['Alfred', 'Batman', ''],
'toy': [None, 'Batmobile', 'Joker']})
df.dropna()
df.dropna(axis=1)
Tips:
空值不是nan,不是null