申明：本系列文章是自己在学习《利用Python进行数据分析》这本书的过程中，为了方便后期自己巩固知识而整理。

1 读取excel数据

import pandas as pd

import numpy as np

file = 'D:\example.xls'

df = pd.DataFrame(pd.read_excel(file))

df

2 检测缺失值

import pandas as pd

import numpy as np

file = 'D:\example.xls'

df = pd.DataFrame(pd.read_excel(file))

df = df.isnull()

df

import pandas as pd

import numpy as np

file = 'D:\example.xls'

df = pd.DataFrame(pd.read_excel(file))

df = df.notnull()

df

df.dropna()

df.dropna(thresh=4)

DataFrame.fillna(value=None, method=None, axis=None, inplace=False, limit=None, downcast=None, **kwargs)

df.fillna(0)或df.fillna(value=0)

df.fillna(method='ffill')

df.fillna(method='bfill')

df.fillna({'起息日':'2018-12-11','评级得分':''})

df.fillna(method='ffill',axis=1)