Skip to content

Instantly share code, notes, and snippets.

@aivuk

aivuk/concat.py

Last active November 24, 2015 01:32
Show Gist options
  • Save aivuk/fe614d32bc77abb8c9cb to your computer and use it in GitHub Desktop.
Save aivuk/fe614d32bc77abb8c9cb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
concat.py
import pandas as pd
# Carrega planilha A
planilha_A = pd.read_excel('basedadosexecucao2003.xls')
# Carrega planilha B
planilha_B = pd.read_excel('basedadosexecucao2004.xls')
# Gera nova planilha concatenando planilha A e B
planilha_agrupada = pd.concat([planilha_A, planilha_B])
# Salva no arquivo 'agrupada.xls'
planilha_agrupada.to_excel('agrupada.xls')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment