search

mit-jp / mit-climate-data-viz

Plotting climate data for the MIT Joint Program on the Science and Policy of Global Change
https://cypressf.shinyapps.io/eppa-dashboard/
0 stars 0 forks source link

fix population and gdp per capita data #280

Open cypressf opened 2 years ago

cypressf commented 2 years ago

The raw population and gdp per capita data seem to be wrong.

Population shortage

I downloaded the "Population" data and found the sum was ~120M, which is less than half the current 329M. I'm curious what's going on with that as well. I see that it only contains population data for 2827 counties, whereas we have 3223 counties on our map. Perhaps the missing counties account for the missing population. I have a todo item in github to add population data for different years. Perhaps the new population data for different years contains data for every county.

Difference between "GDP per capita" and "GDP / Population"

This one flummoxes me. Our GDP per capita statistic is ~400x GDP / Population. I don't know why this would be. I think it's worth looking into further. Shelli would you mind investigating that? I don't think the GDP per capita on the website right now is the same as personal income because we have both, and they differ.

cypressf commented 2 years ago

@sorzach could you let me know which filenames and columns I should upload for

cypressf commented 2 years ago

For population, I'm going to use the POPESTIMATE2019 column from Population.csv in the data cleaning repo.