from functools import partial
import pandas as pd
 
ufv_name = ['CB1', 'CB2', 'CB3', 'GM1', 'IM1', 'JD2', 'PIU', 'STR']
 
def readxlsx(ufv, d, m):
  return (pd.read_excel(f'{d}PR_{ufv}_{m}.xlsx'), ufv)
 
def unir(dir, mes):
  f = partial(readxlsx, d=dir, m=mes)
  planilhas = list(map(f, ufv_name))
  with pd.ExcelWriter(f'{dir}Relatorio_total.xlsx', engine='xlsxwriter') as writer:
    for p in planilhas:
      p[0].to_excel(writer, sheet_name=p[1], index = False)

ZnJvbSBmdW5jdG9vbHMgaW1wb3J0IHBhcnRpYWwKaW1wb3J0IHBhbmRhcyBhcyBwZAoKdWZ2X25hbWUgPSBbJ0NCMScsICdDQjInLCAnQ0IzJywgJ0dNMScsICdJTTEnLCAnSkQyJywgJ1BJVScsICdTVFInXQoKZGVmIHJlYWR4bHN4KHVmdiwgZCwgbSk6CiAgcmV0dXJuIChwZC5yZWFkX2V4Y2VsKGYne2R9UFJfe3Vmdn1fe219Lnhsc3gnKSwgdWZ2KQoKZGVmIHVuaXIoZGlyLCBtZXMpOgogIGYgPSBwYXJ0aWFsKHJlYWR4bHN4LCBkPWRpciwgbT1tZXMpCiAgcGxhbmlsaGFzID0gbGlzdChtYXAoZiwgdWZ2X25hbWUpKQogIHdpdGggcGQuRXhjZWxXcml0ZXIoZid7ZGlyfVJlbGF0b3Jpb190b3RhbC54bHN4JywgZW5naW5lPSd4bHN4d3JpdGVyJykgYXMgd3JpdGVyOgogICAgZm9yIHAgaW4gcGxhbmlsaGFzOgogICAgICBwWzBdLnRvX2V4Y2VsKHdyaXRlciwgc2hlZXRfbmFtZT1wWzFdLCBpbmRleCA9IEZhbHNlKQ==