pandas - DataFrame
1、 查看DataFram信息
def showDataFrameInfo():
"""
查看DataFram信息
:return:
"""
data = [
[11, 12, "col-3-1", False],
[21, 22, "col-3-2", True],
[31, 32, np.NaN, None],
[41, 42, np.NaN, False],
[51, 52, "col-3-5", np.NaN]
]
columns = ['col-1', 'col-2', 'col-3', 'col-4']
index = ['idx-1', 'idx-2', 'idx-3', 'idx-4', 'idx-5']
df = pd.DataFrame(data=data, index=index, columns=columns)
# DataFrame 属性信息
df_info = df.info()
print(df_info)
# 判断是否存在缺失值
df_isnull = df.isnull()
print(df_isnull)
# 判断是否存在非空
df_notnull = df.notnull()
print(df_notnull)
DataFrame 属性信息 返回结果:
<class 'pandas.core.frame.DataFrame'>
Index: 5 entries, idx-1 to idx-5
Data columns (total 4 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 col-1 5 non-null int64
1 col-2 5 non-null int64
2 col-3 3 non-null object
3 col-4 3 non-null object
dtypes: int64(2), object(2)
memory usage: 200.0+ bytes
None
DataFrame 判断是否存在缺失值 返回结果:
col-1 col-2 col-3 col-4
idx-1 False False False False
idx-2 False False False False
idx-3 False False True True
idx-4 False False True False
idx-5 False False False True
DataFrame 判断是否存在非空 返回结果:
col-1 col-2 col-3 col-4
idx-1 True True True True
idx-2 True True True True
idx-3 True True False False
idx-4 True True False True
idx-5 True True True False