Accounting Automation

run.py

import pandas as pd

# Dictionnary of filenames 
list_files = ['DC-JAN-2017.xlsx', 'DC-FEB-2017.xlsx', 'DC-MAR-2017.xlsx','DC-APR-2017.xlsx', 'DC-MAY-2017.xlsx', 'DC-JUN-2017.xlsx',
             'DC-JUL-2017.xlsx', 'DC-AUG-2017.xlsx', 'DC-SEP-2017.xlsx','DC-OCT-2017.xlsx', 'DC-NOV-2017.xlsx', 'DC-DEC-2017.xlsx']
zip_loop = zip(list_files, [i[3:6] for i in list_files])

# Final report DataFrame
df_report = pd.DataFrame()

for file_name, month in zip_loop:
    # Import and Clean Data
    df_clean = clean(file_raw, month)
    # Build Monthly report
    df_month = process_month(df_clean, month)
    # Merge with previous Months report
    if df_report.empty
        df_report = df_month
    else:
        df_report = df_report.merge(df_month, on = 'index')
        
# Save Final Report
df_report.to_excel('Final Report.xlsx')