import pandas as pd
import datetime

entries_csv = "C:\Users\Pops\Desktop\Entries.csv"
listofaccounts_csv = "C:\Users\Pops\Desktop\List of Accounts.csv"

data_entries = pd.read_csv(entries_csv)
data_listofaccounts = pd.read_csv(listofaccounts_csv)

#summary_name = [0]*len(data_listofaccounts)
summary_amount = [0]*(len(data_listofaccounts) + 1)
summary = (('DEBIT ACCOUNT', 'DEBIT AMOUNT'),)

start_date = datetime.date(2018, 4, 1)
end_date = datetime.date(2018, 4, 30)

for i in range(0, len(data_listofaccounts)):
    for j in range(0, len(data_entries)):
        if start_date <= data_entries.iloc[j, 1] <= end_date:
            if data_listofaccounts.iloc[i, 0] == data_entries.iloc[j, 4]
                    and (data_listofaccounts.iloc[i, 1] == "CURRENT ASSET" or "FIXED ASSET" or "EXPENSE"):
                summary_amount[i] += data_entries.iloc[j, 5]
            elif data_listofaccounts.iloc[i, 0] == data_entries.iloc[j, 4]
                    and (data_listofaccounts.iloc[i, 1] == "CURRENT LIABILITY" or "LONG TERM LIABILITY" or "EQUITY"):
                summary_amount[i] -= data_entries.iloc[j, 5]
    summary += ((data_listofaccounts.iloc[i, 0], "{:,}".format(round(summary_amount[i], 2))),)