导包
import numpy as np
import pandas as pd
from pandas import DataFrame
数据
columns = ['a1','a2','a3','a4']
index = ['b1','b2','b3']
data = np.random.randint(0,100,size=(3,4))
df = DataFrame(columns=columns, index=index, data=data)
df.loc['b2','a2'] = np.nan
df.loc['b3','a1'] = ''
df.loc['b4','a2'] = ''
df
方法一
该方法只能删除np.nan的空行
df.dropna(subset=['a2'], inplace=True)
df
方法二
该方法可以根据任意值进行删除
df = df[~df['a1'].isin([''])] # isin([np.nan])就是删除NaN值,该列表中可以放多个指定值
df