coa-project / pycoa

pycoa Python source code
MIT License
18 stars 0 forks source link

France population from world DB point of view #123

Open odadoun opened 2 years ago

odadoun commented 2 years ago

In the geo module, for population we use

https://www.worldometers.info/world-population/population-by-country/

For France all the DROM are not included. So France population is = 65x10e6 instead of 67x10e6. May be we need to add them by hand ? I check this is the regions names we need to add DROM=['Guadeloupe','French Guiana','Martinique','Réunion','Mayotte'] But I don't know how to handdle the geometry ... using national db ?

tjbtjbtjb commented 2 years ago

Working on it…

tjbtjbtjb commented 2 years ago

Not true.

image

The full french population is 67 332 971 in GeoCountry('FRA').

About Outre-Mer :

image

About COM (collectivités d'Outre-mer) :

image

And about Métropole :

image

odadoun commented 2 years ago

the problem is coming from the add_field functions where you use the data from https://www.worldometers.info/world-population/population-by-country The population taken is not the owid population neither from geo class is something else

                self._data_population = pd.read_html(get_local_from_url('https://www.worldometers.info/world-population/population-by-country/',30e5) ) [0].iloc[:,[x[0] for x in field_descr]]
tjbtjbtjb commented 2 years ago

Well… it's not compatible with INSEE statistics, indeed. Nevertheless, OWID data are similar with worldometers one. See : https://ourworldindata.org/grapher/population?tab=table : 65,43 M in 2021 (what is wrong). At that time, no need to change the db for population. Need to find a better one !

odadoun commented 2 years ago

You don't want to add by hand DROM for France in the add_field function ?