{
"metadata": {
"name": "California_breathing"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "code",
"collapsed": false,
"input": [
"import pandas as pd\n",
"from pandas import DataFrame\n",
"#This is the 'Active Asthma Prevalence, All Ages, 2007' from\n",
"#http://www.californiabreathing.org/asthma-data/county-comparisons/active-asthma-prevalence\n",
"asth = open('asthma_prev_2007.csv')"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 3
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"asth_county = pd.read_csv(asth)\n",
"asth_county"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"
\n",
"
\n",
" \n",
" \n",
" | \n",
" \ufeff'COUNTY (OR GROUP)' | \n",
" 'Percent with Active Asthma' | \n",
" '95% Confidence Interval' | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" 'Merced' | \n",
" '14.4' | \n",
" '(9.3 - 19.6)' | \n",
"
\n",
" \n",
" 1 | \n",
" 'Tehama/Glenn/Colusa' | \n",
" '13.7' | \n",
" '(9.5 - 17.9)' | \n",
"
\n",
" \n",
" 2 | \n",
" 'Yuba' | \n",
" '12.7' | \n",
" '(8.9 - 16.6)' | \n",
"
\n",
" \n",
" 3 | \n",
" 'Kern' | \n",
" '11.9' | \n",
" '(8.6 - 15.2)' | \n",
"
\n",
" \n",
" 4 | \n",
" 'Fresno' | \n",
" '11.3' | \n",
" '(8.4 - 14.3)' | \n",
"
\n",
" \n",
" 5 | \n",
" 'Sacramento' | \n",
" '11.2' | \n",
" '(8.9 - 13.5)' | \n",
"
\n",
" \n",
" 6 | \n",
" 'Solano' | \n",
" '10.9' | \n",
" '(6.7 - 15.1)' | \n",
"
\n",
" \n",
" 7 | \n",
" 'San Joaquin' | \n",
" '10.8' | \n",
" '(7.5 - 14.2)' | \n",
"
\n",
" \n",
" 8 | \n",
" 'Santa Cruz' | \n",
" '10.6' | \n",
" '(6.6 - 14.5)' | \n",
"
\n",
" \n",
" 9 | \n",
" 'Kings' | \n",
" '10.1' | \n",
" '(7.4 - 12.9)' | \n",
"
\n",
" \n",
" 10 | \n",
" 'Sutter' | \n",
" '10.0' | \n",
" '(7.2 - 12.8)' | \n",
"
\n",
" \n",
" 11 | \n",
" 'Alameda' | \n",
" '9.8' | \n",
" '(7.5 - 12.2)' | \n",
"
\n",
" \n",
" 12 | \n",
" 'Lake' | \n",
" '9.8' | \n",
" '(6.9 - 12.7)' | \n",
"
\n",
" \n",
" 13 | \n",
" 'Napa' | \n",
" '9.8' | \n",
" '(6.8 - 12.7)' | \n",
"
\n",
" \n",
" 14 | \n",
" 'Butte' | \n",
" '9.7' | \n",
" '(7.2 - 12.2)' | \n",
"
\n",
" \n",
" 15 | \n",
" 'Shasta' | \n",
" '9.7' | \n",
" '(5.7 - 13.7)' | \n",
"
\n",
" \n",
" 16 | \n",
" 'Contra Costa' | \n",
" '9.6' | \n",
" '(7.2 - 11.9)' | \n",
"
\n",
" \n",
" 17 | \n",
" 'Imperial' | \n",
" '9.5' | \n",
" '(6.9 - 12.2)' | \n",
"
\n",
" \n",
" 18 | \n",
" 'Madera' | \n",
" '9.5' | \n",
" '(6.9 - 12.1)' | \n",
"
\n",
" \n",
" 19 | \n",
" 'Nevada' | \n",
" '9.4' | \n",
" '(6.6 - 12.1)' | \n",
"
\n",
" \n",
" 20 | \n",
" 'Del Norte/Siskiyou/Lassen/Trinity/Modoc/Pluma... | \n",
" '9.2' | \n",
" '(5.8 - 12.6)' | \n",
"
\n",
" \n",
" 21 | \n",
" 'San Mateo' | \n",
" '9.2' | \n",
" '(5.9 - 12.6)' | \n",
"
\n",
" \n",
" 22 | \n",
" 'Placer' | \n",
" '9.0' | \n",
" '(6.2 - 11.7)' | \n",
"
\n",
" \n",
" 23 | \n",
" 'San Bernardino' | \n",
" '9.0' | \n",
" '(7.5 - 10.5)' | \n",
"
\n",
" \n",
" 24 | \n",
" 'Stanislaus' | \n",
" '9.0' | \n",
" '(5.6 - 12.4)' | \n",
"
\n",
" \n",
" 25 | \n",
" 'Tulare' | \n",
" '8.8' | \n",
" '(6.2 - 11.3)' | \n",
"
\n",
" \n",
" 26 | \n",
" 'Yolo' | \n",
" '8.8' | \n",
" '(5.0 - 12.7)' | \n",
"
\n",
" \n",
" 27 | \n",
" 'Tuolumne/Calaveras/Amador/Inyo/Mariposa/Mono/... | \n",
" '8.7' | \n",
" '(5.8 - 11.6)' | \n",
"
\n",
" \n",
" 28 | \n",
" 'El Dorado' | \n",
" '8.3' | \n",
" '(5.9 - 10.6)' | \n",
"
\n",
" \n",
" 29 | \n",
" 'CALIFORNIA OVERALL' | \n",
" '8.1' | \n",
" '(7.7 - 8.4)' | \n",
"
\n",
" \n",
" 30 | \n",
" 'Ventura' | \n",
" '8.1' | \n",
" '(5.4 - 10.8)' | \n",
"
\n",
" \n",
" 31 | \n",
" 'Santa Barbara' | \n",
" '8.0' | \n",
" '(5.1 - 10.9)' | \n",
"
\n",
" \n",
" 32 | \n",
" 'Sonoma' | \n",
" '7.8' | \n",
" '(5.2 - 10.3)' | \n",
"
\n",
" \n",
" 33 | \n",
" 'San Luis Obispo' | \n",
" '7.5' | \n",
" '(4.4 - 10.6)' | \n",
"
\n",
" \n",
" 34 | \n",
" 'San Diego' | \n",
" '7.3' | \n",
" '(6.3 - 8.3)' | \n",
"
\n",
" \n",
" 35 | \n",
" 'Los Angeles' | \n",
" '7.2' | \n",
" '(6.5 - 7.8)' | \n",
"
\n",
" \n",
" 36 | \n",
" 'Humboldt' | \n",
" '7.0' | \n",
" '(4.9 - 9.2)' | \n",
"
\n",
" \n",
" 37 | \n",
" 'Mendocino' | \n",
" '6.9' | \n",
" '(4.6 - 9.3)' | \n",
"
\n",
" \n",
" 38 | \n",
" 'Monterey' | \n",
" '6.8' | \n",
" '(4.3 - 9.4)' | \n",
"
\n",
" \n",
" 39 | \n",
" 'Orange' | \n",
" '6.8' | \n",
" '(5.7 - 8.0)' | \n",
"
\n",
" \n",
" 40 | \n",
" 'Santa Clara' | \n",
" '6.8' | \n",
" '(5.3 - 8.4)' | \n",
"
\n",
" \n",
" 41 | \n",
" 'Marin' | \n",
" '6.5' | \n",
" '(3.4 - 9.6)' | \n",
"
\n",
" \n",
" 42 | \n",
" 'San Francisco' | \n",
" '6.0' | \n",
" '(3.4 - 8.6)' | \n",
"
\n",
" \n",
" 43 | \n",
" 'Riverside' | \n",
" '5.2' | \n",
" '(4.2 - 6.2)' | \n",
"
\n",
" \n",
"
\n",
"
"
],
"output_type": "pyout",
"prompt_number": 4,
"text": [
" \ufeff'COUNTY (OR GROUP)' \\\n",
"0 'Merced' \n",
"1 'Tehama/Glenn/Colusa' \n",
"2 'Yuba' \n",
"3 'Kern' \n",
"4 'Fresno' \n",
"5 'Sacramento' \n",
"6 'Solano' \n",
"7 'San Joaquin' \n",
"8 'Santa Cruz' \n",
"9 'Kings' \n",
"10 'Sutter' \n",
"11 'Alameda' \n",
"12 'Lake' \n",
"13 'Napa' \n",
"14 'Butte' \n",
"15 'Shasta' \n",
"16 'Contra Costa' \n",
"17 'Imperial' \n",
"18 'Madera' \n",
"19 'Nevada' \n",
"20 'Del Norte/Siskiyou/Lassen/Trinity/Modoc/Pluma... \n",
"21 'San Mateo' \n",
"22 'Placer' \n",
"23 'San Bernardino' \n",
"24 'Stanislaus' \n",
"25 'Tulare' \n",
"26 'Yolo' \n",
"27 'Tuolumne/Calaveras/Amador/Inyo/Mariposa/Mono/... \n",
"28 'El Dorado' \n",
"29 'CALIFORNIA OVERALL' \n",
"30 'Ventura' \n",
"31 'Santa Barbara' \n",
"32 'Sonoma' \n",
"33 'San Luis Obispo' \n",
"34 'San Diego' \n",
"35 'Los Angeles' \n",
"36 'Humboldt' \n",
"37 'Mendocino' \n",
"38 'Monterey' \n",
"39 'Orange' \n",
"40 'Santa Clara' \n",
"41 'Marin' \n",
"42 'San Francisco' \n",
"43 'Riverside' \n",
"\n",
" 'Percent with Active Asthma' '95% Confidence Interval' \n",
"0 '14.4' '(9.3 - 19.6)' \n",
"1 '13.7' '(9.5 - 17.9)' \n",
"2 '12.7' '(8.9 - 16.6)' \n",
"3 '11.9' '(8.6 - 15.2)' \n",
"4 '11.3' '(8.4 - 14.3)' \n",
"5 '11.2' '(8.9 - 13.5)' \n",
"6 '10.9' '(6.7 - 15.1)' \n",
"7 '10.8' '(7.5 - 14.2)' \n",
"8 '10.6' '(6.6 - 14.5)' \n",
"9 '10.1' '(7.4 - 12.9)' \n",
"10 '10.0' '(7.2 - 12.8)' \n",
"11 '9.8' '(7.5 - 12.2)' \n",
"12 '9.8' '(6.9 - 12.7)' \n",
"13 '9.8' '(6.8 - 12.7)' \n",
"14 '9.7' '(7.2 - 12.2)' \n",
"15 '9.7' '(5.7 - 13.7)' \n",
"16 '9.6' '(7.2 - 11.9)' \n",
"17 '9.5' '(6.9 - 12.2)' \n",
"18 '9.5' '(6.9 - 12.1)' \n",
"19 '9.4' '(6.6 - 12.1)' \n",
"20 '9.2' '(5.8 - 12.6)' \n",
"21 '9.2' '(5.9 - 12.6)' \n",
"22 '9.0' '(6.2 - 11.7)' \n",
"23 '9.0' '(7.5 - 10.5)' \n",
"24 '9.0' '(5.6 - 12.4)' \n",
"25 '8.8' '(6.2 - 11.3)' \n",
"26 '8.8' '(5.0 - 12.7)' \n",
"27 '8.7' '(5.8 - 11.6)' \n",
"28 '8.3' '(5.9 - 10.6)' \n",
"29 '8.1' '(7.7 - 8.4)' \n",
"30 '8.1' '(5.4 - 10.8)' \n",
"31 '8.0' '(5.1 - 10.9)' \n",
"32 '7.8' '(5.2 - 10.3)' \n",
"33 '7.5' '(4.4 - 10.6)' \n",
"34 '7.3' '(6.3 - 8.3)' \n",
"35 '7.2' '(6.5 - 7.8)' \n",
"36 '7.0' '(4.9 - 9.2)' \n",
"37 '6.9' '(4.6 - 9.3)' \n",
"38 '6.8' '(4.3 - 9.4)' \n",
"39 '6.8' '(5.7 - 8.0)' \n",
"40 '6.8' '(5.3 - 8.4)' \n",
"41 '6.5' '(3.4 - 9.6)' \n",
"42 '6.0' '(3.4 - 8.6)' \n",
"43 '5.2' '(4.2 - 6.2)' "
]
}
],
"prompt_number": 4
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#Clean up the columnames\n",
"asth_county\n",
"asth_county['percent_active'] = asth_county['\\'Percent with Active Asthma\\''].apply(lambda x: float(x[1:-1]))\n",
"asth_county['county_name'] = asth_county[asth_county.columns[0]].apply(lambda x: str(x[1:-1]))\n",
"asth_county['95_confidence'] = asth_county['\\'95% Confidence Interval\\''].apply(lambda x: str(x[1:-1]))"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 5
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#Delete old columns with messy names\n",
"del asth_county[asth_county.columns[0]]\n",
"del asth_county[asth_county.columns[0]]\n",
"del asth_county[asth_county.columns[0]]"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 6
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Some rows represent multiple counties, we got to undo this grouping"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"\n",
"new_rows = []\n",
"def unpack_group(row):\n",
" group = row['county_name']\n",
" if '/' in group:\n",
" counties = group.split('/')\n",
" for county in counties:\n",
" new_rows.append({'county_name': county, 'percent_active': row['percent_active'], '95_confidence': row['95_confidence']})\n",
" "
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 7
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#Apply said function\n",
"asth_county.apply(unpack_group, axis = 1)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "pyout",
"prompt_number": 8,
"text": [
"0 None\n",
"1 None\n",
"2 None\n",
"3 None\n",
"4 None\n",
"5 None\n",
"6 None\n",
"7 None\n",
"8 None\n",
"9 None\n",
"10 None\n",
"11 None\n",
"12 None\n",
"13 None\n",
"14 None\n",
"15 None\n",
"16 None\n",
"17 None\n",
"18 None\n",
"19 None\n",
"20 None\n",
"21 None\n",
"22 None\n",
"23 None\n",
"24 None\n",
"25 None\n",
"26 None\n",
"27 None\n",
"28 None\n",
"29 None\n",
"30 None\n",
"31 None\n",
"32 None\n",
"33 None\n",
"34 None\n",
"35 None\n",
"36 None\n",
"37 None\n",
"38 None\n",
"39 None\n",
"40 None\n",
"41 None\n",
"42 None\n",
"43 None"
]
}
],
"prompt_number": 8
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"new_df = DataFrame(new_rows)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 9
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#Join old dataframe and new rows\n",
"new_asth = pd.concat([new_df, asth_county], ignore_index=True)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 10
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"#Remove rows that are groups\n",
"isnt_group = lambda x: '/' not in x\n",
"\n"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 11
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"new_asth[new_asth['county_name'].apply(isnt_group)]"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" 95_confidence | \n",
" county_name | \n",
" percent_active | \n",
"
\n",
" \n",
" \n",
" \n",
" 0 | \n",
" (9.5 - 17.9) | \n",
" Tehama | \n",
" 13.7 | \n",
"
\n",
" \n",
" 1 | \n",
" (9.5 - 17.9) | \n",
" Glenn | \n",
" 13.7 | \n",
"
\n",
" \n",
" 2 | \n",
" (9.5 - 17.9) | \n",
" Colusa | \n",
" 13.7 | \n",
"
\n",
" \n",
" 3 | \n",
" (5.8 - 12.6) | \n",
" Del Norte | \n",
" 9.2 | \n",
"
\n",
" \n",
" 4 | \n",
" (5.8 - 12.6) | \n",
" Siskiyou | \n",
" 9.2 | \n",
"
\n",
" \n",
" 5 | \n",
" (5.8 - 12.6) | \n",
" Lassen | \n",
" 9.2 | \n",
"
\n",
" \n",
" 6 | \n",
" (5.8 - 12.6) | \n",
" Trinity | \n",
" 9.2 | \n",
"
\n",
" \n",
" 7 | \n",
" (5.8 - 12.6) | \n",
" Modoc | \n",
" 9.2 | \n",
"
\n",
" \n",
" 8 | \n",
" (5.8 - 12.6) | \n",
" Plumas | \n",
" 9.2 | \n",
"
\n",
" \n",
" 9 | \n",
" (5.8 - 12.6) | \n",
" Sierra | \n",
" 9.2 | \n",
"
\n",
" \n",
" 10 | \n",
" (5.8 - 11.6) | \n",
" Tuolumne | \n",
" 8.7 | \n",
"
\n",
" \n",
" 11 | \n",
" (5.8 - 11.6) | \n",
" Calaveras | \n",
" 8.7 | \n",
"
\n",
" \n",
" 12 | \n",
" (5.8 - 11.6) | \n",
" Amador | \n",
" 8.7 | \n",
"
\n",
" \n",
" 13 | \n",
" (5.8 - 11.6) | \n",
" Inyo | \n",
" 8.7 | \n",
"
\n",
" \n",
" 14 | \n",
" (5.8 - 11.6) | \n",
" Mariposa | \n",
" 8.7 | \n",
"
\n",
" \n",
" 15 | \n",
" (5.8 - 11.6) | \n",
" Mono | \n",
" 8.7 | \n",
"
\n",
" \n",
" 16 | \n",
" (5.8 - 11.6) | \n",
" Alpine | \n",
" 8.7 | \n",
"
\n",
" \n",
" 17 | \n",
" (9.3 - 19.6) | \n",
" Merced | \n",
" 14.4 | \n",
"
\n",
" \n",
" 19 | \n",
" (8.9 - 16.6) | \n",
" Yuba | \n",
" 12.7 | \n",
"
\n",
" \n",
" 20 | \n",
" (8.6 - 15.2) | \n",
" Kern | \n",
" 11.9 | \n",
"
\n",
" \n",
" 21 | \n",
" (8.4 - 14.3) | \n",
" Fresno | \n",
" 11.3 | \n",
"
\n",
" \n",
" 22 | \n",
" (8.9 - 13.5) | \n",
" Sacramento | \n",
" 11.2 | \n",
"
\n",
" \n",
" 23 | \n",
" (6.7 - 15.1) | \n",
" Solano | \n",
" 10.9 | \n",
"
\n",
" \n",
" 24 | \n",
" (7.5 - 14.2) | \n",
" San Joaquin | \n",
" 10.8 | \n",
"
\n",
" \n",
" 25 | \n",
" (6.6 - 14.5) | \n",
" Santa Cruz | \n",
" 10.6 | \n",
"
\n",
" \n",
" 26 | \n",
" (7.4 - 12.9) | \n",
" Kings | \n",
" 10.1 | \n",
"
\n",
" \n",
" 27 | \n",
" (7.2 - 12.8) | \n",
" Sutter | \n",
" 10.0 | \n",
"
\n",
" \n",
" 28 | \n",
" (7.5 - 12.2) | \n",
" Alameda | \n",
" 9.8 | \n",
"
\n",
" \n",
" 29 | \n",
" (6.9 - 12.7) | \n",
" Lake | \n",
" 9.8 | \n",
"
\n",
" \n",
" 30 | \n",
" (6.8 - 12.7) | \n",
" Napa | \n",
" 9.8 | \n",
"
\n",
" \n",
" 31 | \n",
" (7.2 - 12.2) | \n",
" Butte | \n",
" 9.7 | \n",
"
\n",
" \n",
" 32 | \n",
" (5.7 - 13.7) | \n",
" Shasta | \n",
" 9.7 | \n",
"
\n",
" \n",
" 33 | \n",
" (7.2 - 11.9) | \n",
" Contra Costa | \n",
" 9.6 | \n",
"
\n",
" \n",
" 34 | \n",
" (6.9 - 12.2) | \n",
" Imperial | \n",
" 9.5 | \n",
"
\n",
" \n",
" 35 | \n",
" (6.9 - 12.1) | \n",
" Madera | \n",
" 9.5 | \n",
"
\n",
" \n",
" 36 | \n",
" (6.6 - 12.1) | \n",
" Nevada | \n",
" 9.4 | \n",
"
\n",
" \n",
" 38 | \n",
" (5.9 - 12.6) | \n",
" San Mateo | \n",
" 9.2 | \n",
"
\n",
" \n",
" 39 | \n",
" (6.2 - 11.7) | \n",
" Placer | \n",
" 9.0 | \n",
"
\n",
" \n",
" 40 | \n",
" (7.5 - 10.5) | \n",
" San Bernardino | \n",
" 9.0 | \n",
"
\n",
" \n",
" 41 | \n",
" (5.6 - 12.4) | \n",
" Stanislaus | \n",
" 9.0 | \n",
"
\n",
" \n",
" 42 | \n",
" (6.2 - 11.3) | \n",
" Tulare | \n",
" 8.8 | \n",
"
\n",
" \n",
" 43 | \n",
" (5.0 - 12.7) | \n",
" Yolo | \n",
" 8.8 | \n",
"
\n",
" \n",
" 45 | \n",
" (5.9 - 10.6) | \n",
" El Dorado | \n",
" 8.3 | \n",
"
\n",
" \n",
" 46 | \n",
" (7.7 - 8.4) | \n",
" CALIFORNIA OVERALL | \n",
" 8.1 | \n",
"
\n",
" \n",
" 47 | \n",
" (5.4 - 10.8) | \n",
" Ventura | \n",
" 8.1 | \n",
"
\n",
" \n",
" 48 | \n",
" (5.1 - 10.9) | \n",
" Santa Barbara | \n",
" 8.0 | \n",
"
\n",
" \n",
" 49 | \n",
" (5.2 - 10.3) | \n",
" Sonoma | \n",
" 7.8 | \n",
"
\n",
" \n",
" 50 | \n",
" (4.4 - 10.6) | \n",
" San Luis Obispo | \n",
" 7.5 | \n",
"
\n",
" \n",
" 51 | \n",
" (6.3 - 8.3) | \n",
" San Diego | \n",
" 7.3 | \n",
"
\n",
" \n",
" 52 | \n",
" (6.5 - 7.8) | \n",
" Los Angeles | \n",
" 7.2 | \n",
"
\n",
" \n",
" 53 | \n",
" (4.9 - 9.2) | \n",
" Humboldt | \n",
" 7.0 | \n",
"
\n",
" \n",
" 54 | \n",
" (4.6 - 9.3) | \n",
" Mendocino | \n",
" 6.9 | \n",
"
\n",
" \n",
" 55 | \n",
" (4.3 - 9.4) | \n",
" Monterey | \n",
" 6.8 | \n",
"
\n",
" \n",
" 56 | \n",
" (5.7 - 8.0) | \n",
" Orange | \n",
" 6.8 | \n",
"
\n",
" \n",
" 57 | \n",
" (5.3 - 8.4) | \n",
" Santa Clara | \n",
" 6.8 | \n",
"
\n",
" \n",
" 58 | \n",
" (3.4 - 9.6) | \n",
" Marin | \n",
" 6.5 | \n",
"
\n",
" \n",
" 59 | \n",
" (3.4 - 8.6) | \n",
" San Francisco | \n",
" 6.0 | \n",
"
\n",
" \n",
" 60 | \n",
" (4.2 - 6.2) | \n",
" Riverside | \n",
" 5.2 | \n",
"
\n",
" \n",
"
\n",
"
"
],
"output_type": "pyout",
"prompt_number": 12,
"text": [
" 95_confidence county_name percent_active\n",
"0 (9.5 - 17.9) Tehama 13.7\n",
"1 (9.5 - 17.9) Glenn 13.7\n",
"2 (9.5 - 17.9) Colusa 13.7\n",
"3 (5.8 - 12.6) Del Norte 9.2\n",
"4 (5.8 - 12.6) Siskiyou 9.2\n",
"5 (5.8 - 12.6) Lassen 9.2\n",
"6 (5.8 - 12.6) Trinity 9.2\n",
"7 (5.8 - 12.6) Modoc 9.2\n",
"8 (5.8 - 12.6) Plumas 9.2\n",
"9 (5.8 - 12.6) Sierra 9.2\n",
"10 (5.8 - 11.6) Tuolumne 8.7\n",
"11 (5.8 - 11.6) Calaveras 8.7\n",
"12 (5.8 - 11.6) Amador 8.7\n",
"13 (5.8 - 11.6) Inyo 8.7\n",
"14 (5.8 - 11.6) Mariposa 8.7\n",
"15 (5.8 - 11.6) Mono 8.7\n",
"16 (5.8 - 11.6) Alpine 8.7\n",
"17 (9.3 - 19.6) Merced 14.4\n",
"19 (8.9 - 16.6) Yuba 12.7\n",
"20 (8.6 - 15.2) Kern 11.9\n",
"21 (8.4 - 14.3) Fresno 11.3\n",
"22 (8.9 - 13.5) Sacramento 11.2\n",
"23 (6.7 - 15.1) Solano 10.9\n",
"24 (7.5 - 14.2) San Joaquin 10.8\n",
"25 (6.6 - 14.5) Santa Cruz 10.6\n",
"26 (7.4 - 12.9) Kings 10.1\n",
"27 (7.2 - 12.8) Sutter 10.0\n",
"28 (7.5 - 12.2) Alameda 9.8\n",
"29 (6.9 - 12.7) Lake 9.8\n",
"30 (6.8 - 12.7) Napa 9.8\n",
"31 (7.2 - 12.2) Butte 9.7\n",
"32 (5.7 - 13.7) Shasta 9.7\n",
"33 (7.2 - 11.9) Contra Costa 9.6\n",
"34 (6.9 - 12.2) Imperial 9.5\n",
"35 (6.9 - 12.1) Madera 9.5\n",
"36 (6.6 - 12.1) Nevada 9.4\n",
"38 (5.9 - 12.6) San Mateo 9.2\n",
"39 (6.2 - 11.7) Placer 9.0\n",
"40 (7.5 - 10.5) San Bernardino 9.0\n",
"41 (5.6 - 12.4) Stanislaus 9.0\n",
"42 (6.2 - 11.3) Tulare 8.8\n",
"43 (5.0 - 12.7) Yolo 8.8\n",
"45 (5.9 - 10.6) El Dorado 8.3\n",
"46 (7.7 - 8.4) CALIFORNIA OVERALL 8.1\n",
"47 (5.4 - 10.8) Ventura 8.1\n",
"48 (5.1 - 10.9) Santa Barbara 8.0\n",
"49 (5.2 - 10.3) Sonoma 7.8\n",
"50 (4.4 - 10.6) San Luis Obispo 7.5\n",
"51 (6.3 - 8.3) San Diego 7.3\n",
"52 (6.5 - 7.8) Los Angeles 7.2\n",
"53 (4.9 - 9.2) Humboldt 7.0\n",
"54 (4.6 - 9.3) Mendocino 6.9\n",
"55 (4.3 - 9.4) Monterey 6.8\n",
"56 (5.7 - 8.0) Orange 6.8\n",
"57 (5.3 - 8.4) Santa Clara 6.8\n",
"58 (3.4 - 9.6) Marin 6.5\n",
"59 (3.4 - 8.6) San Francisco 6.0\n",
"60 (4.2 - 6.2) Riverside 5.2"
]
}
],
"prompt_number": 12
}
],
"metadata": {}
}
]
}