Hello,

Attached is my program, I have filtered some data from an extensive table
from excel. I have it running for two names:

ps_sol = ["Mauro Cavalheiro Junior", "Aline Oliveira"]
> for name in ps_sol:
> ....


At the end I am trying to export to another .xlsx file. But it is only
saving the info of the last name in the list.

I want it to save for all names that i list in my ps_sol


Help please (:




    | VIEW MY | <http://br.linkedin.com/pub/lucas-mascia/61/93/8b>

"It is not the strongest of the species that survives, nor the most
intelligent that survives. It is the one that is most adaptable to change."
 - Darwin.
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)
_______________________________________________
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
https://mail.python.org/mailman/listinfo/tutor

Reply via email to