policy-design-lab / data-import

Programs used to convert raw CSV files into JSON files for various PDL programs
0 stars 0 forks source link

Create EQIP IRA output #97

Closed ywkim312 closed 3 months ago

ywkim312 commented 3 months ago

Create EQIP IRA output. There are three csv input files. These are the capture of the dialogues for this process

We will create a separate page for this EQIP IRA 2023 in frontend, right? or, do we want to add this 2023 data to existing EQIP data, so the frontend will have just newer value without any new page for this? if we add to the existing years, we need to discuss how to add since the practice names are different in the year part, there are two values in the column, one for year 2023, and the other is for total. How do we handle this? what is total anyway? Is it 2023 total? Then what is the difference between 2023 and total? if we make the output json format based on state base, we can make it little more easily giving the values of 2023 and total under the state current eqip endpoint is just showing the sum of 2018-2022 then states are under this, so maybe we want to create two entities, unlike the current one that only has 2018-2022, like 2023 and total? What is State v. County v. CD? this column has sub column named state, and I don't see any column for County or CD should we ignore this in our api endpoint?

Yes, this will be on a new page under the Policy Lab Menu. Please note that these are "practice names", which are different from the "practice categories" that we are currently displaying for EQIP. Total is the total amount allocated under this policy for the reported years. This is a recent policy, and hence only the 2023 data is present, which is the same as the total. We need a way to compare actual data vs predicted data (the other CSVs in the IRA Box folder). So, the JSON format needs to provide an easy way to make this comparison. I think the format of map endpoints may be closer to what we need. We can further discuss on the JSON format. I think we can ignore that column.

what do you mean by the 2-a. So I need to work on the other files in the folder and somehow include the information from there to the output json?

what do you mean by the 2-a. So I need to work on the other files in the folder and somehow include the information from there to the output json?