Create Methode of State Spending

[ouslan]

Objective

Create a method that will read the data in the .csv containing the historical data then insert it to the database.

• Read the .csv using polars
• Pivot the table so that the data is in the following format shown in the table below.
• Insert the clean data into the database as "StateSpendingTable"

date	account num	revenue	expendenture
01-01-2020	123456	123456	123456
01-02-2020	123456	123456	123456

• Insert the clean data into the database as "StateSpendingTable"

Note

You Might need to do 2 pivot one for revenues and one for expenses. Then merge them using the account number (the account number is the column name. Example you have the column name r123. r would indicate revenue and 123 would be the account number.