search

open-numbers / ddf--gapminder--population

Population of countries and territories
5 stars 2 forks source link

Europe population anomaly 2008->2009 and on #10

Open jheeffer opened 7 years ago

jheeffer commented 7 years ago 
europe  2008    1252323210
europe  2009    824532774

https://github.com/open-numbers/ddf--gapminder--population/blob/master/ddf--datapoints--population--by--world_4region--year.csv#L2454-L2469

Who remembers the great dissappearance of 1/3 of the European population in 2008?

@semio can you find out what's going wrong here?

semio commented 7 years ago

@jheeffer The problem is in Gapminder historic dataset https://github.com/open-numbers/ddf--gapminder--population_historic, in which there are datapoints for 67 europe countries before 2008 and 55 after 2008.

Countries missing after 2008 are

'Akrotiri and Dhekelia', 
'Czechoslovakia', 
'East Germany',
'Guernsey',
'Jersey', 
'Kosovo', 
'Serbia and Montenegro',
'Serbia excluding Kosovo', 
'Svalbard', 
'USSR',
'West Germany',
'Yugoslavia'

world_4region/world_6region and other entity sets aggregation are sum of country data, hence the big difference.

But I am thinking that, some datapoints shouldn't be taken into account for the aggregation, like USSR after 1991, right?