Ptyhon Pandas常用的操作

# print(data.isnull().any())
# print(data[data.isnull().values==True])

import pandas as pd
import numpy as np
data={
    'a':[1,2,3,4],
    'b':[3,5,np.nan,np.nan],
    'c':[np.nan,0,np.nan,0],
}

df=pd.DataFrame(data)
print(df)

   a    b    c
0  1  3.0  NaN
1  2  5.0  0.0
2  3  NaN  NaN
3  4  NaN  0.0

print(df.isnull())

       a      b      c
0  False  False   True
1  False  False  False
2  False   True   True
3  False   True  False

print(df.isnull().astype(int).sum())
print(df.shape[0]-df.count())

a    0
b    2
c    2
dtype: int64
a    0
b    2
c    2
dtype: int64

DataFrame.drop_duplicates(subset=None, keep='first', inplace=False)

df.rename(columns={'oldName1': 'newName1', 'oldName2': 'newName2'})