Data cleanup 

This data visualization will compare the male and female population in the Bay Area. To generate the circle visualization, we can rename and eliminate unnecessary columns using Geopandas' dataframe manipulation:

tract_points['Total Population'] = tract_points['ACS_15_5YR_S0101_with_ann_Total; Estimate; Total population']
tract_points['Male Population'] = tract_points['ACS_15_5YR_S0101_with_ann_Male; Estimate; Total population']
tract_points['Female Population'] = tract_points['ACS_15_5YR_S0101_with_ann_Female; Estimate; Total population']
tract_points = tract_points[['Total Population',
'Male Population','Female Population',
'centroids' ]]

This code created three new columns from three existing columns, by passing the name of the new columns and assigning the data values to be equal to the existing column. Then, the entire GeoDataFrame is rewritten (in memory) to only contain the three new columns and the centroids column, eliminating unwanted columns. Exploring the first five rows of the new GeoDataFrame allows us to see the new data structure:

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset