根据多个空单元格删除Pandas中的行？

Question

因此，这里我有一个关于我试图实现的示例数据框架。该行将删除的标题value1、value2和value3下的三个单元格值为空

import pandas as pd
import xldd
from pandas import ExcelWriter
from pandas import ExcelFile

data = [[‘tom’, 10], [‘nick’], [‘juli’]]
df = pd.DataFrame(data, columns = [‘Name’, ‘Value1’, ‘Value2’, 
‘Value3’])

df.dropna(subset=[‘value1’, ‘value2’, ‘value3’], 
how=‘all’).head()

df.to_excel(‘ReportList.xlsx’, index=False)

此代码中没有错误，但在运行代码时不会发生任何事情

Answer 1

正如@datasnool所提到的，您需要将dataframe分配给新的dataframe，或者使用inplace参数并将其设置为true

In [138]: data = [['tom', 10,None,None], ['nick',None,None,None], ['juli',None,None,None]]
     ...: df = pd.DataFrame(data, columns = ['Name', 'Value1', 'Value2',
     ...: 'Value3'])

In [139]: df
Out[139]:
   Name  Value1 Value2 Value3
0   tom    10.0   None   None
1  nick     NaN   None   None
2  juli     NaN   None   None

In [140]: df.dropna(subset=['Value1','Value2','Value3'], how='all',inplace=True)

In [141]: df
Out[141]:
  Name  Value1 Value2 Value3
0  tom    10.0   None   None