利用Python进行数据分析_Panda

import pandas as pd
import numpy as np
file = 'D:\example.xls'
df = pd.DataFrame(pd.read_excel(file))
df

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','评级得分':'100'})

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