用Python导出过滤后的Excel表

Question

Python3.4.3 |水蟒2.3 |熊猫

我已经从一个广泛的excel中筛选了一些数据。我有两个名字：

import pandas as pd
import sys


#file loc
R1 = input('Data do Relatório desejado  (dd.mm) --->  ')
loc = r'C:\Users\lucas.mascia\Downloads\relatorio-{0}.xlsx'.format(R1)

######################################################################

#Solicitantes
ps_sol = ["Mauro Cavalheiro Junior", "Aline Oliveira"]


#Aplicando filtros
for name in ps_sol:

    #opening file
    df = pd.read_excel(loc)
    dfps = df[[2,15,16,17]]

    #apply filter
    f1 = dfps[(dfps['Cliente']=="POSTAL SAUDE")
        & (dfps['Nome do solicitante']==name)]

    #print info
    print ('''
    =============================================================
    Relatorio do dia:   {}
    Cliente:            POSTAL SAUDE
    Solicitante:        {}
    =============================================================
    '''.format(R1, name))

    print (f1)

    f1.to_excel('C:/Users/lucas.mascia/Downloads/ps_sol.xlsx', sheet_name=name)

最后，我试图导出到另一个.xlsx文件。但它只是保存列表中姓氏的信息。你知道吗

我想把它保存在我的ps\ U sol中列出的所有名字中

请帮忙（：