United Nations Population Division Department of Economic and Social Affairs: Difference between revisions
Jump to navigation
Jump to search
Norah.Shamin (talk | contribs) |
Norah.Shamin (talk | contribs) |
||
| Line 25: | Line 25: | ||
# The indicator is "Average household size (number of members)" | # The indicator is "Average household size (number of members)" | ||
## Change Reference date (dd/mm/yyyy) to an actual date format so it will be read by a code correctly '''or''' to use =YEAR(__). [[File:UN DESA .png|none|thumb|600x600px]] | ## Change Reference date (dd/mm/yyyy) to an actual date format so it will be read by a code correctly '''or''' to use =YEAR(__). [[File:UN DESA .png|none|thumb|600x600px]] | ||
#If you create a separate column for year using =YEAR(), you cam use this code to pull: | #If you create a separate column for year using =YEAR(), you cam use this code to pull:https://github.com/n1shamin/UN-DESA-Household-Data/tree/main | ||
##We need to divide the data from UN DESA with SeriesPopulation. The script included in the repo. | |||
#After this, blend the data with SeriesHouseholdsITU2014. | |||
= Notes = | = Notes = | ||
* In Source Ext Definition state: Most data points up to 2014 are based on SeriesHouseholdsITU2014, with some values before and after 2014 are filled by UNPD | |||
Revision as of 18:40, 19 November 2025
Summary
Tables In IFs
| Variable | Definition | Extended Source Defn | Last IFs Update | UsedInPreprocessor | UsedInPreprocessorFileName |
|---|---|---|---|---|---|
| SeriesHouseholds | Number of households (SeriesPopulation/average household size (number of members) | Most data points up to 2014 are based on SeriesHouseholdsITU2014, with some values before and after 2014 are filled by UNPD | 2025/11/19 | 1 | INFRASTRUCTURE, POPULATION |
Data Pulling Instructions
- Navigate to https://www.un.org/development/desa/pd/household-size-and-composition
- Scroll to Data and click Dataset
- The indicator is "Average household size (number of members)"
- Change Reference date (dd/mm/yyyy) to an actual date format so it will be read by a code correctly or to use =YEAR(__).
- If you create a separate column for year using =YEAR(), you cam use this code to pull:https://github.com/n1shamin/UN-DESA-Household-Data/tree/main
- We need to divide the data from UN DESA with SeriesPopulation. The script included in the repo.
- After this, blend the data with SeriesHouseholdsITU2014.
Notes
- In Source Ext Definition state: Most data points up to 2014 are based on SeriesHouseholdsITU2014, with some values before and after 2014 are filled by UNPD