python - 从 Pandas 导出到 excel 时遇到问题

Question

我刚开始学习 Python 并有一个我正在尝试解决的现实世界的活动。即从excel文件中提取和报告数据。我已经导入了一个文件，创建了一个数据框，提取了行并且可以很好地打印输出，但是现在尝试将其导出时遇到问题 - 我得到一个“AttributeError：'tuple'对象没有属性'to_excel'” .

任何帮助，将不胜感激。

data = pd.read_excel(r'Z:\RAW_DATA_JUNE_2021.xlsx')
df=pd.DataFrame(data, columns=['Host','CVSS v2.0 Base Score','Name'])
host1 = ('10.10.1.12')
host2 = ('10.10.1.251')
host3 = ('10.10.1.252')
host4 = ('10.10.1.254')
host5 = ('10.10.1.53')
rslt_df1=df[df["Host"]== host1]
rslt_df2=df[df["Host"]== host2]
rslt_df3=df[df["Host"]== host3]
rslt_df4=df[df["Host"]== host4]
rslt_df5=df[df["Host"]== host5]
df_writer=(('\nResult df:\n',rslt_df1),
      ('\nResult df:\n',rslt_df2),
      ('\nResult df:\n',rslt_df3),
      ('\nResult df:\n',rslt_df4),
      ('\nResult df:\n',rslt_df5))
writer=pd.ExcelWriter(r'Z:\DMZ.xlsx')
df_writer.to_excel(writer, sheet_name='Sheet1', index=False)
workbook=writer.book
worksheet=writer.sheets['Sheet1']
writer.save()

标签： pythonexcelpandasdataframetuples