I think drop 2021 from the data as it was not complete at the time of collection/downloading for your project
There are only 43 states in the data (drop the total row for US) - just be sure to make this clear
Added some cells showing how to merge these data in with the us map geojson and do a plot.
Plot was just the sum totals but you could focus on individual years or do an increase/decrease analysis
probably can drop alaska and hawaii to get a mainland plot
And here might be some interesting/useful background for selecting some example states - obviously your focus goes towards CT but could be a good transition to compare to similar and higher and lower states
Notebook:
data_analysis/drug_overdose_death_analysis_Jonah.ipynbGood work so far here
I think drop 2021 from the data as it was not complete at the time of collection/downloading for your project
There are only 43 states in the data (drop the total row for
US) - just be sure to make this clearAdded some cells showing how to merge these data in with the us map geojson and do a plot.
Plot was just the sum totals but you could focus on individual years or do an increase/decrease analysis
probably can drop alaska and hawaii to get a mainland plot