show_spending_group_details.py

""" show_group_spending_details.py

    From an input of spending data where each transaction has a category and a
    spending group, generate tables for each spending group that shows the
    annual spending by category
"""
import visualization_methods as vms
import webbrowser
import os

# Import the shared configuration file
import expenses_config as ec

# HTML report this module will generate
HTML_OUT = ec.REPORTS_PATH + "group-spending_details.html"
HTML_F = open(HTML_OUT, "w")

# Create a dataframe from the csv with all the spending transactions
df = vms.read_structured_transactions(
    ec.PATH_TO_SPENDING_DATA,
    ec.PATH_TO_YOUR_TRANSACTIONS,
    "Date",
    "spending transaction data",
)

# Loop through each of the spending groups and show the year over year details
for group in sorted(df["Spending Group"].unique()):
    filtered_df = df.filter(regex='Amount|Category|Spending Group')
    group_df = vms.build_category_details(filtered_df, group)
    group_df.drop("Spending Group", axis=1, inplace=True)
    print("<H2><center>Details for " + group + " spending<center></H2>", file=HTML_F)
    print(group_df.to_html(), file=HTML_F)

# Show the report in a webbrowser
HTML_F.close()
webbrowser.open(
    "file://" + os.path.realpath(HTML_OUT), new=2
)  # new=2: open in a new tab, if possible