2019 Population by County and Sub-County

The dataset details population figures, gender distribution, household counts, and land area for counties and sub-counties.
It includes metrics like average household size and population density, offering insights into living conditions and land use.
The total population for the entire dataset (47,564,296) is present as the first row, with null values for county and sub_county, indicating an aggregate national total.
There's a significant range in population density, from 0 to 68,941, suggesting highly varied urbanization or land use across areas.
The 'intersex' column has 11% null values, and 'sub_county' has 12% nulls, indicating incomplete demographic or geographical data for some entries.
The maximum values for male, female, and population are extremely high, corresponding to the national aggregate row, which acts as an outlier compared to individual county/sub-county data.
What is the average population density across all sub-counties, excluding the national aggregate?
Which counties have the highest average household size?
How does the male-to-female ratio vary between urban (high density) and rural (low density) sub-counties?

Column	Type	Nulls	Unique	Stats / Top values
county	string	—	48	Kitui (19)Meru (14)Kiambu (14)Kakamega (14)Bungoma (13)
sub_county	string	12%	341	Mt Kenya Forest* (5)Aberdare Forest* (2)Changamwe (1)Jomvu (1)Kisauni (1)
male	number	—	392	mean 179756.1527 · min 11 · max 23548056 · median 67715
female	number	—	390	mean 183318.4427 · min 3 · max 24014716 · median 68782
intersex	number	11%	43	mean 13.1379 · min 1 · max 1524 · median 4
population	number	—	393	mean 363086.229 · min 15 · max 47564296 · median 136035
number_of_households	number	—	393	mean 92701.626 · min 11 · max 12143913 · median 33025
average_household_size	number	—	53	mean 4.1883 · min 1 · max 7.7 · median 4.2
land_area_sq_km	number	—	388	mean 4431.3794 · min 10.5 · max 580876.3 · median 507.9
population_density	number	—	307	mean 956.43 · min 0 · max 68941 · median 306

Insights