In [34]:

    

import pandas as pd
import requests
from sdipylib.censusextract import make_col_map # !pip install git+https://github.com/sandiegodata/sdipylib.git

url_params = {
    'base_url': 'http://extracts.census.civicknowledge.com',
    'year': 2014,
    'release': 5, 
    'summary_level': '155_state_place_county',
    'table': 'b01001'
}
template = '{base_url}/{year}/{release}/{summary_level}/{table}'
data_template = template+".csv"
schema_template = template+'-schema.csv'

df = pd.read_csv(data_template.format(**url_params))
schema_df = pd.read_csv(schema_template.format(**url_params))


    

In [45]:

    

# Create a column map from the original colum id names, to the colum titles.
# The new column values will be set with .rename() 
col_map = make_col_map(schema_df)

# The dataset has all of the tracts in the country, so select just San Diego county, which 
# is state FIPS code 6 and county FIPS code 73. You can find these values by searching for the
# geo name you want in the 'name' column. 
sd = df[(df.state == 6) & (df.county == 73)].rename(columns=col_map)

sd[['name','Total']].sort_values('Total',ascending=False)


    

    
Out[45]:






  

    

      

      
name
      
Total
    
  
  

    

      
7029
      
San Diego County (part), San Diego city, Calif...
      
1341510.0
    
    

      
6100
      
San Diego County (part), Chula Vista city, Cal...
      
253031.0
    
    

      
6823
      
San Diego County (part), Oceanside city, Calif...
      
171400.0
    
    

      
6286
      
San Diego County (part), Escondido city, Calif...
      
147603.0
    
    

      
6053
      
San Diego County (part), Carlsbad city, Califo...
      
109296.0
    
    

      
6258
      
San Diego County (part), El Cajon city, Califo...
      
101582.0
    
    

      
7275
      
San Diego County (part), Vista city, California
      
96181.0
    
    

      
7046
      
San Diego County (part), San Marcos city, Cali...
      
87808.0
    
    

      
6284
      
San Diego County (part), Encinitas city, Calif...
      
61008.0
    
    

      
6776
      
San Diego County (part), National City city, C...
      
59543.0
    
    

      
6560
      
San Diego County (part), La Mesa city, California
      
58239.0
    
    

      
7073
      
San Diego County (part), Santee city, California
      
55435.0
    
    

      
6930
      
San Diego County (part), Poway city, California
      
49040.0
    
    

      
6567
      
San Diego County (part), La Presa CDP, California
      
34739.0
    
    

      
6298
      
San Diego County (part), Fallbrook CDP, Califo...
      
31435.0
    
    

      
7145
      
San Diego County (part), Spring Valley CDP (Sa...
      
29841.0
    
    

      
6461
      
San Diego County (part), Imperial Beach city, ...
      
26857.0
    
    

      
6588
      
San Diego County (part), Lemon Grove city, Cal...
      
25963.0
    
    

      
6144
      
San Diego County (part), Coronado city, Califo...
      
24333.0
    
    

      
6941
      
San Diego County (part), Ramona CDP, California
      
21578.0
    
    

      
6948
      
San Diego County (part), Rancho San Diego CDP,...
      
21514.0
    
    

      
6556
      
San Diego County (part), Lakeside CDP, California
      
21079.0
    
    

      
6065
      
San Diego County (part), Casa de Oro-Mount Hel...
      
21076.0
    
    

      
7336
      
San Diego County (part), Winter Gardens CDP, C...
      
20346.0
    
    

      
5987
      
San Diego County (part), Bostonia CDP, California
      
16460.0
    
    

      
5866
      
San Diego County (part), Alpine CDP, California
      
14580.0
    
    

      
5979
      
San Diego County (part), Bonita CDP, California
      
13864.0
    
    

      
7122
      
San Diego County (part), Solana Beach city, Ca...
      
13146.0
    
    

      
6045
      
San Diego County (part), Camp Pendleton South ...
      
12691.0
    
    

      
7030
      
San Diego County (part), San Diego Country Est...
      
10191.0
    
    

      
7255
      
San Diego County (part), Valley Center CDP, Ca...
      
9872.0
    
    

      
6044
      
San Diego County (part), Camp Pendleton North ...
      
6436.0
    
    

      
6483
      
San Diego County (part), Jamul CDP, California
      
5445.0
    
    

      
6289
      
San Diego County (part), Eucalyptus Hills CDP,...
      
5352.0
    
    

      
6554
      
San Diego County (part), Lake San Marcos CDP, ...
      
4679.0
    
    

      
6411
      
San Diego County (part), Harbison Canyon CDP, ...
      
4577.0
    
    

      
6190
      
San Diego County (part), Del Mar city, California
      
4242.0
    
    

      
5981
      
San Diego County (part), Bonsall CDP, California
      
4138.0
    
    

      
6380
      
San Diego County (part), Granite Hills CDP, Ca...
      
3438.0
    
    

      
6431
      
San Diego County (part), Hidden Meadows CDP, C...
      
3283.0
    
    

      
6292
      
San Diego County (part), Fairbanks Ranch CDP, ...
      
3245.0
    
    

      
6043
      
San Diego County (part), Campo CDP, California
      
3031.0
    
    

      
6949
      
San Diego County (part), Rancho Santa Fe CDP, ...
      
2838.0
    
    

      
6161
      
San Diego County (part), Crest CDP, California
      
2393.0
    
    

      
5986
      
San Diego County (part), Borrego Springs CDP, ...
      
2359.0
    
    

      
6939
      
San Diego County (part), Rainbow CDP, California
      
1678.0
    
    

      
6897
      
San Diego County (part), Pine Valley CDP, Cali...
      
1554.0
    
    

      
6490
      
San Diego County (part), Julian CDP, California
      
1345.0
    
    

      
6197
      
San Diego County (part), Descanso CDP, California
      
1305.0
    
    

      
6928
      
San Diego County (part), Potrero CDP, California
      
693.0
    
    

      
5989
      
San Diego County (part), Boulevard CDP, Califo...
      
434.0
    
    

      
6481
      
San Diego County (part), Jacumba CDP, California
      
77.0
    
    

      
6767
      
San Diego County (part), Mount Laguna CDP, Cal...
      
12.0
    
  

In [47]:

    

list(sd.columns)


    

    
Out[47]:





['stusab',
 'logrecno',
 'geoid',
 'state',
 'county',
 'place',
 'name',
 'chariter',
 'Total',
 'Margin for Total',
 'Male',
 'Margin for Male',
 'Male Under 5 years',
 'Margin for Male Under 5 years',
 'Male 5 to 9 years',
 'Margin for Male 5 to 9 years',
 'Male 10 to 14 years',
 'Margin for Male 10 to 14 years',
 'Male 15 to 17 years',
 'Margin for Male 15 to 17 years',
 'Male 18 and 19 years',
 'Margin for Male 18 and 19 years',
 'Male 20 years',
 'Margin for Male 20 years',
 'Male 21 years',
 'Margin for Male 21 years',
 'Male 22 to 24 years',
 'Margin for Male 22 to 24 years',
 'Male 25 to 29 years',
 'Margin for Male 25 to 29 years',
 'Male 30 to 34 years',
 'Margin for Male 30 to 34 years',
 'Male 35 to 39 years',
 'Margin for Male 35 to 39 years',
 'Male 40 to 44 years',
 'Margin for Male 40 to 44 years',
 'Male 45 to 49 years',
 'Margin for Male 45 to 49 years',
 'Male 50 to 54 years',
 'Margin for Male 50 to 54 years',
 'Male 55 to 59 years',
 'Margin for Male 55 to 59 years',
 'Male 60 and 61 years',
 'Margin for Male 60 and 61 years',
 'Male 62 to 64 years',
 'Margin for Male 62 to 64 years',
 'Male 65 and 66 years',
 'Margin for Male 65 and 66 years',
 'Male 67 to 69 years',
 'Margin for Male 67 to 69 years',
 'Male 70 to 74 years',
 'Margin for Male 70 to 74 years',
 'Male 75 to 79 years',
 'Margin for Male 75 to 79 years',
 'Male 80 to 84 years',
 'Margin for Male 80 to 84 years',
 'Male 85 years and over',
 'Margin for Male 85 years and over',
 'Female',
 'Margin for Female',
 'Female Under 5 years',
 'Margin for Female Under 5 years',
 'Female 5 to 9 years',
 'Margin for Female 5 to 9 years',
 'Female 10 to 14 years',
 'Margin for Female 10 to 14 years',
 'Female 15 to 17 years',
 'Margin for Female 15 to 17 years',
 'Female 18 and 19 years',
 'Margin for Female 18 and 19 years',
 'Female 20 years',
 'Margin for Female 20 years',
 'Female 21 years',
 'Margin for Female 21 years',
 'Female 22 to 24 years',
 'Margin for Female 22 to 24 years',
 'Female 25 to 29 years',
 'Margin for Female 25 to 29 years',
 'Female 30 to 34 years',
 'Margin for Female 30 to 34 years',
 'Female 35 to 39 years',
 'Margin for Female 35 to 39 years',
 'Female 40 to 44 years',
 'Margin for Female 40 to 44 years',
 'Female 45 to 49 years',
 'Margin for Female 45 to 49 years',
 'Female 50 to 54 years',
 'Margin for Female 50 to 54 years',
 'Female 55 to 59 years',
 'Margin for Female 55 to 59 years',
 'Female 60 and 61 years',
 'Margin for Female 60 and 61 years',
 'Female 62 to 64 years',
 'Margin for Female 62 to 64 years',
 'Female 65 and 66 years',
 'Margin for Female 65 and 66 years',
 'Female 67 to 69 years',
 'Margin for Female 67 to 69 years',
 'Female 70 to 74 years',
 'Margin for Female 70 to 74 years',
 'Female 75 to 79 years',
 'Margin for Female 75 to 79 years',
 'Female 80 to 84 years',
 'Margin for Female 80 to 84 years',
 'Female 85 years and over',
 'Margin for Female 85 years and over']

In [ ]: