{ "metadata": { "name": "", "signature": "sha256:e53782a79deb8e851f5521a05e8ecbeb7af9d8911710752287dbc6d09d2c4026" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "#Flu Data & Immunization Data Exploring the Data\n", "To convert the IPython Notebook to Markdown\n", "\n", " IPython nbconvert 01-read-in-source-data-for-all-sources.ipynb --to markdown\n", " \n", "##Setup Pandas and the input files" ] }, { "cell_type": "code", "collapsed": false, "input": [ "import pandas as pd\n", "\n", "pd.options.display.max_columns = 5200\n", "pd.options.display.max_rows = 5200\n", "\n", "inFluCDC = '/Users/danielmsheehan/GitHub/d3-presentation/data/flu/cdc/StateData.csv' #http://www.cdc.gov/flu/weekly/fluactivitysurv.htm\n", "inFluGoo = '/Users/danielmsheehan/GitHub/d3-presentation/data/flu/google/data_20150210.txt'\n", "inFluGoo = 'https://www.google.org/flutrends/us/data.txt'\n", "inImmCal = '/Users/danielmsheehan/GitHub/d3-presentation/data/immunization/schools/ca/2014-2015 CA Seventh Grade Data.xls'\n", "\n", "dfFluCDC = pd.read_csv(inFluCDC)\n", "dfFluGoo = pd.read_csv(inFluGoo, header=11)\n", "inImmCal = pd.io.excel.read_excel(inImmCal, 'SA1415', header=3)" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 7 }, { "cell_type": "markdown", "metadata": {}, "source": [ "##The CDC Flu Data \n", "from [FluView](http://gis.cdc.gov/grasp/fluview/main.html)" ] }, { "cell_type": "code", "collapsed": false, "input": [ "dfFluCDC.head(2)" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
STATENAMEURLWEBSITEACTIVITY LEVELACTIVITY LEVEL LABELWEEKENDWEEKSEASON
0 Alabama http://adph.org/influenza/ Influenza Surveillance Level 1 Minimal Oct-04-2008 40 2008-09
1 Alabama http://adph.org/influenza/ Influenza Surveillance Level 1 Minimal Oct-11-2008 41 2008-09
\n", "
" ], "metadata": {}, "output_type": "pyout", "prompt_number": 5, "text": [ " STATENAME URL WEBSITE \\\n", "0 Alabama http://adph.org/influenza/ Influenza Surveillance \n", "1 Alabama http://adph.org/influenza/ Influenza Surveillance \n", "\n", " ACTIVITY LEVEL ACTIVITY LEVEL LABEL WEEKEND WEEK SEASON \n", "0 Level 1 Minimal Oct-04-2008 40 2008-09 \n", "1 Level 1 Minimal Oct-11-2008 41 2008-09 " ] } ], "prompt_number": 5 }, { "cell_type": "markdown", "metadata": {}, "source": [ "##California Immunization for 7th Grade School Children\n", "From [California Immunization Rates for School children](http://www.cdph.ca.gov/programs/immunize/pages/immunizationlevels.aspx)" ] }, { "cell_type": "code", "collapsed": false, "input": [ "inImmCal.head(1) #Keep around for Dr. R. " ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
SCHOOL CODECOUNTYPUBLIC/ PRIVATEPUBLIC SCHOOL DISTRICTCITYSCHOOL NAMEENROLLMENTUP-TO-DATE\u2020Unnamed: 8PME**Unnamed: 10PBE\u00a7 Unnamed: 12HEALTH CARE PRACTITIONER COUNSELED PBE\u00a7\u00a7 Unnamed: 14RELIGIOUS PBE\u00a7\u00a7\u00a7 Unnamed: 16REPORTED\u00a7\u00a7\u00a7\u00a7
0 NaN NaN NaN NaN NaN NaN NaN # % # % # % # % # % NaN
\n", "
" ], "metadata": {}, "output_type": "pyout", "prompt_number": 6, "text": [ " SCHOOL CODE COUNTY PUBLIC/ PRIVATE PUBLIC SCHOOL DISTRICT CITY SCHOOL NAME \\\n", "0 NaN NaN NaN NaN NaN NaN \n", "\n", " ENROLLMENT UP-TO-DATE\u2020 Unnamed: 8 PME** Unnamed: 10 PBE\u00a7 Unnamed: 12 \\\n", "0 NaN # % # % # % \n", "\n", " HEALTH CARE PRACTITIONER COUNSELED PBE\u00a7\u00a7 Unnamed: 14 RELIGIOUS PBE\u00a7\u00a7\u00a7 \\\n", "0 # % # \n", "\n", " Unnamed: 16 REPORTED\u00a7\u00a7\u00a7\u00a7 \n", "0 % NaN " ] } ], "prompt_number": 6 }, { "cell_type": "markdown", "metadata": {}, "source": [ "##The Google Flu Data\n", "From [here](https://www.google.org/flutrends/us/data.txt) at this [site](https://www.google.org/flutrends/us/#US)" ] }, { "cell_type": "code", "collapsed": false, "input": [ "dfFluGoo.head(10)" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
DateUnited StatesAlabamaAlaskaArizonaArkansasCaliforniaColoradoConnecticutDelawareDistrict of ColumbiaFloridaGeorgiaHawaiiIdahoIllinoisIndianaIowaKansasKentuckyLouisianaMaineMarylandMassachusettsMichiganMinnesotaMississippiMissouriMontanaNebraskaNevadaNew HampshireNew JerseyNew MexicoNew YorkNorth CarolinaNorth DakotaOhioOklahomaOregonPennsylvaniaRhode IslandSouth CarolinaSouth DakotaTennesseeTexasUtahVermontVirginiaWashingtonWest VirginiaWisconsinWyomingHHS Region 1 (CT, ME, MA, NH, RI, VT)HHS Region 2 (NJ, NY)HHS Region 3 (DE, DC, MD, PA, VA, WV)HHS Region 4 (AL, FL, GA, KY, MS, NC, SC, TN)HHS Region 5 (IL, IN, MI, MN, OH, WI)HHS Region 6 (AR, LA, NM, OK, TX)HHS Region 7 (IA, KS, MO, NE)HHS Region 8 (CO, MT, ND, SD, UT, WY)HHS Region 9 (AZ, CA, HI, NV)HHS Region 10 (AK, ID, OR, WA)Anchorage, AKBirmingham, ALLittle Rock, ARMesa, AZPhoenix, AZScottsdale, AZTempe, AZTucson, AZBerkeley, CAFresno, CAIrvine, CALos Angeles, CAOakland, CASacramento, CASan Diego, CASan Francisco, CASan Jose, CASanta Clara, CASunnyvale, CAColorado Springs, CODenver, COWashington, DCGainesville, FLJacksonville, FLMiami, FLOrlando, FLTampa, FLAtlanta, GARoswell, GAHonolulu, HIDes Moines, IABoise, IDChicago, ILIndianapolis, INWichita, KSLexington, KYBaton Rouge, LANew Orleans, LABoston, MASomerville, MABaltimore, MDGrand Rapids, MISt Paul, MNKansas City, MOSpringfield, MOSt Louis, MOJackson, MSCary, NCCharlotte, NCDurham, NCGreensboro, NCRaleigh, NCLincoln, NEOmaha, NENewark, NJAlbuquerque, NMLas Vegas, NVReno, NVAlbany, NYBuffalo, NYNew York, NYRochester, NYCleveland, OHColumbus, OHDayton, OHOklahoma City, OKTulsa, OKBeaverton, OREugene, ORPortland, ORPhiladelphia, PAPittsburgh, PAState College, PAProvidence, RIColumbia, SCGreenville, SCKnoxville, TNMemphis, TNNashville, TNAustin, TXDallas, TXFt Worth, TXHouston, TXIrving, TXLubbock, TXPlano, TXSan Antonio, TXSalt Lake City, UTArlington, VANorfolk, VAReston, VARichmond, VABellevue, WASeattle, WASpokane, WAMadison, WIMilwaukee, WI
0 2003-09-28 902 477NaN 606NaN 929 233 223NaN 927 587 514 NaNNaN 677 544 303 272 420 1017NaN 1268 344 685 484NaN 349NaN NaN NaN NaN 695NaN 649 565NaN 616 1040 409 1186NaN 462NaN 551 1398 NaNNaN 1112 588NaN 466NaN 322 666 1366 631 690 1385 385 266 878 624NaN 407NaNNaN 757NaN 585 598NaNNaNNaN 901 848 448 562 1003 731 990 602NaN 235 1153 NaNNaN 373 609 461 519 NaN 794NaNNaN 731 641NaNNaNNaN 1154 314 332 1505NaN 426 330NaN 391NaNNaN 561 521NaN 503NaN 314 540 NaN 843NaN 505 NaN 579 406 466 437 NaN 924 1034NaNNaN 444 1204 1122NaNNaNNaNNaNNaNNaN 425 1150 1200NaN 1412 1122NaNNaN 986 261 1066 948NaN 1035 NaN 668NaN 622 452
1 2003-10-05 952 501NaN 663NaN 849 251 243NaN 993 582 532 NaNNaN 732 607 303 270 442 1096NaN 1374 362 748 514NaN 359NaN NaN NaN NaN 716NaN 725 660NaN 699 1065 409 1176NaN 478NaN 597 1517 NaNNaN 1198 624NaN 504NaN 381 711 1335 652 775 1613 400 271 853 688NaN 402NaNNaN 796NaN 608 674NaNNaNNaN 891 888 436 840 1115 740 915 594NaN 270 1310 NaNNaN 386 663 581 484 NaN 877NaNNaN 850 657NaNNaNNaN 1162 323 375 1535NaN 423 316NaN 397NaNNaN 673 536NaN 586NaN 331 549 NaN 831NaN 508 NaN 730 483 535 415 NaN 894 1042NaNNaN 471 1124 1193NaNNaNNaNNaNNaNNaN 468 1331 1487NaN 2057 1208NaNNaN 989 249 1249 963NaN 1135 NaN 787NaN 626 449
2 2003-10-12 1092 492NaN 700NaN 1032 283 261NaN 1033 606 557 NaNNaN 799 637 312 280 460 1144NaN 1445 372 791 588NaN 381NaN NaN NaN NaN 815NaN 739 861NaN 729 1122 428 1340NaN 521NaN 670 2010 NaNNaN 1343 777NaN 538NaN 410 819 1411 735 760 2089 422 285 1102 791NaN 428NaNNaN 766NaN 629 731NaNNaNNaN 1165 839 468 938 1311 826 989 609NaN 257 1309 641NaN 370 615 567 497 NaN 1030NaNNaN 799 685NaNNaNNaN 1274 369 447 1549NaN 457 343NaN 408NaNNaN 738 521NaN 838NaN 373 575 1068 824NaN 555 NaN 652 476 671 442 NaN 922 1089NaNNaN 574 1249 1306NaNNaNNaNNaNNaNNaN 497 1492 1869NaN 3770 1191NaNNaN 1463 295 1289 970NaN 1170 NaN 994NaN 661 437
3 2003-10-19 1209 533NaN 819NaN 1084 310 268NaN 1089 698 608 NaNNaN 841 680 342 292 485 1308NaN 1432 367 829 692NaN 431NaN NaN NaN NaN 831NaN 874 852NaN 759 1199 467 1424NaN 529NaN 666 2786 NaNNaN 1448 866NaN 595NaN 397 839 1444 822 803 2583 498 338 1086 852NaN 494NaNNaN 820NaN 649 778NaNNaNNaN 1158 794 495 1045 1429 958 1020 604NaN 314 1151 680NaN 380 679 628 563 NaN 1012NaNNaN 852 697NaNNaNNaN 1488 321 440 1466NaN 440 358NaN 426NaNNaN 799 563NaN 866NaN 382 584 1092 834NaN 604 548 831 498 703 485 NaN 1024 1089NaNNaN 683 1279 1343NaNNaNNaNNaNNaNNaN 544 2696 1897NaN 6618 1516NaNNaN 2095 292 1308 1011NaN 1342 NaN 999NaN 649 487
4 2003-10-26 1249 594NaN 959NaN 989 344 334NaN 1177 708 745 NaNNaN 978 765 368 313 496 1936NaN 1426 370 803 701NaN 452NaN NaN NaN NaN 901NaN 865 857NaN 847 1278 510 1514NaN 556NaN 717 2917 NaNNaN 1556 1026NaN 653NaN 444 917 1608 797 931 2955 530 387 1028 1012NaN 531NaNNaN 908NaN 658 1167NaNNaNNaN 922 908 525 988 1377 1123 1070 640NaN 354 1285 679NaN 412 664 593 845 NaN 910NaNNaN 1051 715NaNNaNNaN 2229 346 464 1460NaN 445 384NaN 448NaNNaN 925 573NaN 831NaN 421 626 1089 872NaN 629 557 776 662 794 522 NaN 1191 1095NaNNaN 735 1537 1484NaNNaNNaNNaNNaNNaN 554 3918 2029NaN 6412 1559NaNNaN 3282 328 1426 1009NaN 1354 NaN 1297NaN 657 499
5 2003-11-02 1374 715NaN 1167NaN 1284 569 394NaN 1270 746 767 936NaN 1102 773 399 323 505 2791NaN 1495 404 898 708NaN 450NaN NaN NaN NaN 897NaN 1005 922NaN 830 1437 576 1448NaN 621NaN 733 3177 NaNNaN 1640 1053NaN 688NaN 457 997 1616 850 938 3202 509 653 1394 1160NaN 548NaNNaN 1109NaN 810 1584NaNNaNNaN 1306 930 643 1021 1423 1035 1322 728NaN 845 1522 736NaN 445 797 699 771 NaN 946NaNNaN 1137 681NaNNaNNaN 3288 395 487 1501NaN 462 405NaN 464NaNNaN 975 601NaN 1065NaN 431 658 1194 1028NaN 678 653 1030 1008 928 546 NaN 1232 1187NaNNaN 866 1542 1445NaNNaNNaNNaNNaNNaN 603 3840 2647NaN 6046 1891NaNNaN 3554 355 1419 1032NaN 1446 NaN 1100NaN 707 521
6 2003-11-09 1702 840NaN 1655NaN 1741 2053 459NaN 1377 917 803 993NaN 1091 831 444 360 563 3975NaN 1653 474 939 776NaN 514NaN 400 NaN NaN 994NaN 1059 1135NaN 880 2082 780 1720NaN 758NaN 931 3344 291NaN 1931 1605NaN 813NaN 558 1067 1995 1153 1062 3581 619 1692 1779 2383NaN 579NaNNaN 1422NaN 908 2305NaNNaNNaN 1628 1044 908 990 2644 1084 1361 1120NaN 2559 1705 867NaN 486 984 712 705 NaN 1159NaNNaN 1157 700NaNNaNNaN 3838 449 539 1456NaN 564 428NaN 648NaNNaN 966 739NaN 1132NaN 622 707 1278 1096NaN 825 694 957 1099 929 591 NaN 1407 2024NaNNaN 1142 1638 1734NaNNaNNaNNaNNaNNaN 655 3064 3387NaN 4379 2514NaNNaN 3706 482 1565 1150NaN 1927 NaN 1969NaN 821 566
7 2003-11-16 2148 1064NaN 2662NaN 2110 3669 538NaN 1538 1095 1236 994NaN 1374 1143 519 449 673 4796NaN 2156 782 1061 829NaN 684NaN 611 NaN NaN 1281NaN 1559 1536NaN 1040 3888 978 2423NaN 844NaN 1152 4287 438NaN 2575 2881NaN 1169NaN 852 1543 2596 1479 1427 4506 1094 2633 2173 2548NaN 856NaNNaN 3004NaN 1076 4575NaNNaNNaN 1859 1648 1350 1508 2531 1187 1846 1861NaN 3653 2182 1251NaN 603 980 912 1527 NaN 1239NaNNaN 1493 807NaNNaNNaN 3874 692 659 1806NaN 602 548NaN 724NaNNaN 986 1130NaN 1200NaN 915 818 1982 1408NaN 1003 817 1639 1483 1079 830 NaN 4436 3250NaNNaN 1553 1628 2653NaNNaNNaNNaNNaNNaN 902 7201 5723NaN 3925 3314NaNNaN 4888 973 1584 1330NaN 2186 NaN 2880NaN 1364 725
8 2003-11-23 2968 1458NaN 4935NaN 3138 5731 635NaN 1867 1404 1526 1039NaN 2367 1560 727 647 928 4722NaN 3197 1117 1340 954NaN 1211NaN 1096 1058 NaN 1731NaN 2246 2363NaN 1837 8199 1480 2737NaN 1074NaN 1650 4828 1055NaN 3290 4817NaN 1504NaN 1148 2176 3341 2182 2020 5272 2041 4226 3382 4223NaN 1538NaNNaN 5004NaN 2674 5240NaNNaNNaN 2876 2351 2494 2512 4837 2244 3223 2990NaN 7435 2608 1610NaN 634 1288 1089 2198 725 1448NaNNaN 2306 1098NaNNaNNaN 4118 852 714 2466NaN 678 953NaN 1183NaNNaN 1298 1436NaN 1884NaN 2691 1049 3367 2071NaN 1253 986 2519 1527 1100 1060 641 10155 7148NaNNaN 2452 1958 3085NaNNaNNaNNaNNaNNaN 1098 7259 7441NaN 4054 3417NaNNaN 6983 2594 1824 1713NaN 2552 NaN 4152NaN 1627 837
9 2003-11-30 3524 3202NaN 8265NaN 5406 5741 1070NaN 2630 1972 2922 1204NaN 3248 2868 1304 1892 1364 4756NaN 4095 1673 2146 1768NaN 2593NaN 4633 1916 426 2803NaN 2723 4095NaN 2960 14183 2682 3569NaN 1652NaN 3295 3747 3471NaN 4593 7193NaN 2968NaN 1904 2631 4046 3192 2554 4485 2943 4864 5467 5791NaN 3218NaNNaN 9722NaN 7541 6753NaNNaNNaN 5390 6276 3518 6873 7840 5849 7470 10110NaN 5903 3214 1960NaN 1031 2072 1409 3417 1098 1459NaNNaN 3406 5137NaNNaNNaN 3970 1382 1777 4309NaN 1367 2407NaN 2862NaNNaN 2439 3034NaN 3785NaN 6672 1501 10548 5093NaN 2879 1327 2831 2356 2136 3419 1179 13958 13264NaNNaN 4071 3074 4696NaNNaNNaNNaNNaNNaN 2578 7392 8642NaN 5553 5002NaNNaN 7940 4086 2860 3102NaN 3484 1571 7445NaN 2969 1314
\n", "
" ], "metadata": {}, "output_type": "pyout", "prompt_number": 9, "text": [ " Date United States Alabama Alaska Arizona Arkansas California \\\n", "0 2003-09-28 902 477 NaN 606 NaN 929 \n", "1 2003-10-05 952 501 NaN 663 NaN 849 \n", "2 2003-10-12 1092 492 NaN 700 NaN 1032 \n", "3 2003-10-19 1209 533 NaN 819 NaN 1084 \n", "4 2003-10-26 1249 594 NaN 959 NaN 989 \n", "5 2003-11-02 1374 715 NaN 1167 NaN 1284 \n", "6 2003-11-09 1702 840 NaN 1655 NaN 1741 \n", "7 2003-11-16 2148 1064 NaN 2662 NaN 2110 \n", "8 2003-11-23 2968 1458 NaN 4935 NaN 3138 \n", "9 2003-11-30 3524 3202 NaN 8265 NaN 5406 \n", "\n", " Colorado Connecticut Delaware District of Columbia Florida Georgia \\\n", "0 233 223 NaN 927 587 514 \n", "1 251 243 NaN 993 582 532 \n", "2 283 261 NaN 1033 606 557 \n", "3 310 268 NaN 1089 698 608 \n", "4 344 334 NaN 1177 708 745 \n", "5 569 394 NaN 1270 746 767 \n", "6 2053 459 NaN 1377 917 803 \n", "7 3669 538 NaN 1538 1095 1236 \n", "8 5731 635 NaN 1867 1404 1526 \n", "9 5741 1070 NaN 2630 1972 2922 \n", "\n", " Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine \\\n", "0 NaN NaN 677 544 303 272 420 1017 NaN \n", "1 NaN NaN 732 607 303 270 442 1096 NaN \n", "2 NaN NaN 799 637 312 280 460 1144 NaN \n", "3 NaN NaN 841 680 342 292 485 1308 NaN \n", "4 NaN NaN 978 765 368 313 496 1936 NaN \n", "5 936 NaN 1102 773 399 323 505 2791 NaN \n", "6 993 NaN 1091 831 444 360 563 3975 NaN \n", "7 994 NaN 1374 1143 519 449 673 4796 NaN \n", "8 1039 NaN 2367 1560 727 647 928 4722 NaN \n", "9 1204 NaN 3248 2868 1304 1892 1364 4756 NaN \n", "\n", " Maryland Massachusetts Michigan Minnesota Mississippi Missouri \\\n", "0 1268 344 685 484 NaN 349 \n", "1 1374 362 748 514 NaN 359 \n", "2 1445 372 791 588 NaN 381 \n", "3 1432 367 829 692 NaN 431 \n", "4 1426 370 803 701 NaN 452 \n", "5 1495 404 898 708 NaN 450 \n", "6 1653 474 939 776 NaN 514 \n", "7 2156 782 1061 829 NaN 684 \n", "8 3197 1117 1340 954 NaN 1211 \n", "9 4095 1673 2146 1768 NaN 2593 \n", "\n", " Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York \\\n", "0 NaN NaN NaN NaN 695 NaN 649 \n", "1 NaN NaN NaN NaN 716 NaN 725 \n", "2 NaN NaN NaN NaN 815 NaN 739 \n", "3 NaN NaN NaN NaN 831 NaN 874 \n", "4 NaN NaN NaN NaN 901 NaN 865 \n", "5 NaN NaN NaN NaN 897 NaN 1005 \n", "6 NaN 400 NaN NaN 994 NaN 1059 \n", "7 NaN 611 NaN NaN 1281 NaN 1559 \n", "8 NaN 1096 1058 NaN 1731 NaN 2246 \n", "9 NaN 4633 1916 426 2803 NaN 2723 \n", "\n", " North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania \\\n", "0 565 NaN 616 1040 409 1186 \n", "1 660 NaN 699 1065 409 1176 \n", "2 861 NaN 729 1122 428 1340 \n", "3 852 NaN 759 1199 467 1424 \n", "4 857 NaN 847 1278 510 1514 \n", "5 922 NaN 830 1437 576 1448 \n", "6 1135 NaN 880 2082 780 1720 \n", "7 1536 NaN 1040 3888 978 2423 \n", "8 2363 NaN 1837 8199 1480 2737 \n", "9 4095 NaN 2960 14183 2682 3569 \n", "\n", " Rhode Island South Carolina South Dakota Tennessee Texas Utah \\\n", "0 NaN 462 NaN 551 1398 NaN \n", "1 NaN 478 NaN 597 1517 NaN \n", "2 NaN 521 NaN 670 2010 NaN \n", "3 NaN 529 NaN 666 2786 NaN \n", "4 NaN 556 NaN 717 2917 NaN \n", "5 NaN 621 NaN 733 3177 NaN \n", "6 NaN 758 NaN 931 3344 291 \n", "7 NaN 844 NaN 1152 4287 438 \n", "8 NaN 1074 NaN 1650 4828 1055 \n", "9 NaN 1652 NaN 3295 3747 3471 \n", "\n", " Vermont Virginia Washington West Virginia Wisconsin Wyoming \\\n", "0 NaN 1112 588 NaN 466 NaN \n", "1 NaN 1198 624 NaN 504 NaN \n", "2 NaN 1343 777 NaN 538 NaN \n", "3 NaN 1448 866 NaN 595 NaN \n", "4 NaN 1556 1026 NaN 653 NaN \n", "5 NaN 1640 1053 NaN 688 NaN \n", "6 NaN 1931 1605 NaN 813 NaN \n", "7 NaN 2575 2881 NaN 1169 NaN \n", "8 NaN 3290 4817 NaN 1504 NaN \n", "9 NaN 4593 7193 NaN 2968 NaN \n", "\n", " HHS Region 1 (CT, ME, MA, NH, RI, VT) HHS Region 2 (NJ, NY) \\\n", "0 322 666 \n", "1 381 711 \n", "2 410 819 \n", "3 397 839 \n", "4 444 917 \n", "5 457 997 \n", "6 558 1067 \n", "7 852 1543 \n", "8 1148 2176 \n", "9 1904 2631 \n", "\n", " HHS Region 3 (DE, DC, MD, PA, VA, WV) \\\n", "0 1366 \n", "1 1335 \n", "2 1411 \n", "3 1444 \n", "4 1608 \n", "5 1616 \n", "6 1995 \n", "7 2596 \n", "8 3341 \n", "9 4046 \n", "\n", " HHS Region 4 (AL, FL, GA, KY, MS, NC, SC, TN) \\\n", "0 631 \n", "1 652 \n", "2 735 \n", "3 822 \n", "4 797 \n", "5 850 \n", "6 1153 \n", "7 1479 \n", "8 2182 \n", "9 3192 \n", "\n", " HHS Region 5 (IL, IN, MI, MN, OH, WI) HHS Region 6 (AR, LA, NM, OK, TX) \\\n", "0 690 1385 \n", "1 775 1613 \n", "2 760 2089 \n", "3 803 2583 \n", "4 931 2955 \n", "5 938 3202 \n", "6 1062 3581 \n", "7 1427 4506 \n", "8 2020 5272 \n", "9 2554 4485 \n", "\n", " HHS Region 7 (IA, KS, MO, NE) HHS Region 8 (CO, MT, ND, SD, UT, WY) \\\n", "0 385 266 \n", "1 400 271 \n", "2 422 285 \n", "3 498 338 \n", "4 530 387 \n", "5 509 653 \n", "6 619 1692 \n", "7 1094 2633 \n", "8 2041 4226 \n", "9 2943 4864 \n", "\n", " HHS Region 9 (AZ, CA, HI, NV) HHS Region 10 (AK, ID, OR, WA) \\\n", "0 878 624 \n", "1 853 688 \n", "2 1102 791 \n", "3 1086 852 \n", "4 1028 1012 \n", "5 1394 1160 \n", "6 1779 2383 \n", "7 2173 2548 \n", "8 3382 4223 \n", "9 5467 5791 \n", "\n", " Anchorage, AK Birmingham, AL Little Rock, AR Mesa, AZ Phoenix, AZ \\\n", "0 NaN 407 NaN NaN 757 \n", "1 NaN 402 NaN NaN 796 \n", "2 NaN 428 NaN NaN 766 \n", "3 NaN 494 NaN NaN 820 \n", "4 NaN 531 NaN NaN 908 \n", "5 NaN 548 NaN NaN 1109 \n", "6 NaN 579 NaN NaN 1422 \n", "7 NaN 856 NaN NaN 3004 \n", "8 NaN 1538 NaN NaN 5004 \n", "9 NaN 3218 NaN NaN 9722 \n", "\n", " Scottsdale, AZ Tempe, AZ Tucson, AZ Berkeley, CA Fresno, CA \\\n", "0 NaN 585 598 NaN NaN \n", "1 NaN 608 674 NaN NaN \n", "2 NaN 629 731 NaN NaN \n", "3 NaN 649 778 NaN NaN \n", "4 NaN 658 1167 NaN NaN \n", "5 NaN 810 1584 NaN NaN \n", "6 NaN 908 2305 NaN NaN \n", "7 NaN 1076 4575 NaN NaN \n", "8 NaN 2674 5240 NaN NaN \n", "9 NaN 7541 6753 NaN NaN \n", "\n", " Irvine, CA Los Angeles, CA Oakland, CA Sacramento, CA San Diego, CA \\\n", "0 NaN 901 848 448 562 \n", "1 NaN 891 888 436 840 \n", "2 NaN 1165 839 468 938 \n", "3 NaN 1158 794 495 1045 \n", "4 NaN 922 908 525 988 \n", "5 NaN 1306 930 643 1021 \n", "6 NaN 1628 1044 908 990 \n", "7 NaN 1859 1648 1350 1508 \n", "8 NaN 2876 2351 2494 2512 \n", "9 NaN 5390 6276 3518 6873 \n", "\n", " San Francisco, CA San Jose, CA Santa Clara, CA Sunnyvale, CA \\\n", "0 1003 731 990 602 \n", "1 1115 740 915 594 \n", "2 1311 826 989 609 \n", "3 1429 958 1020 604 \n", "4 1377 1123 1070 640 \n", "5 1423 1035 1322 728 \n", "6 2644 1084 1361 1120 \n", "7 2531 1187 1846 1861 \n", "8 4837 2244 3223 2990 \n", "9 7840 5849 7470 10110 \n", "\n", " Colorado Springs, CO Denver, CO Washington, DC Gainesville, FL \\\n", "0 NaN 235 1153 NaN \n", "1 NaN 270 1310 NaN \n", "2 NaN 257 1309 641 \n", "3 NaN 314 1151 680 \n", "4 NaN 354 1285 679 \n", "5 NaN 845 1522 736 \n", "6 NaN 2559 1705 867 \n", "7 NaN 3653 2182 1251 \n", "8 NaN 7435 2608 1610 \n", "9 NaN 5903 3214 1960 \n", "\n", " Jacksonville, FL Miami, FL Orlando, FL Tampa, FL Atlanta, GA \\\n", "0 NaN 373 609 461 519 \n", "1 NaN 386 663 581 484 \n", "2 NaN 370 615 567 497 \n", "3 NaN 380 679 628 563 \n", "4 NaN 412 664 593 845 \n", "5 NaN 445 797 699 771 \n", "6 NaN 486 984 712 705 \n", "7 NaN 603 980 912 1527 \n", "8 NaN 634 1288 1089 2198 \n", "9 NaN 1031 2072 1409 3417 \n", "\n", " Roswell, GA Honolulu, HI Des Moines, IA Boise, ID Chicago, IL \\\n", "0 NaN 794 NaN NaN 731 \n", "1 NaN 877 NaN NaN 850 \n", "2 NaN 1030 NaN NaN 799 \n", "3 NaN 1012 NaN NaN 852 \n", "4 NaN 910 NaN NaN 1051 \n", "5 NaN 946 NaN NaN 1137 \n", "6 NaN 1159 NaN NaN 1157 \n", "7 NaN 1239 NaN NaN 1493 \n", "8 725 1448 NaN NaN 2306 \n", "9 1098 1459 NaN NaN 3406 \n", "\n", " Indianapolis, IN Wichita, KS Lexington, KY Baton Rouge, LA \\\n", "0 641 NaN NaN NaN \n", "1 657 NaN NaN NaN \n", "2 685 NaN NaN NaN \n", "3 697 NaN NaN NaN \n", "4 715 NaN NaN NaN \n", "5 681 NaN NaN NaN \n", "6 700 NaN NaN NaN \n", "7 807 NaN NaN NaN \n", "8 1098 NaN NaN NaN \n", "9 5137 NaN NaN NaN \n", "\n", " New Orleans, LA Boston, MA Somerville, MA Baltimore, MD \\\n", "0 1154 314 332 1505 \n", "1 1162 323 375 1535 \n", "2 1274 369 447 1549 \n", "3 1488 321 440 1466 \n", "4 2229 346 464 1460 \n", "5 3288 395 487 1501 \n", "6 3838 449 539 1456 \n", "7 3874 692 659 1806 \n", "8 4118 852 714 2466 \n", "9 3970 1382 1777 4309 \n", "\n", " Grand Rapids, MI St Paul, MN Kansas City, MO Springfield, MO \\\n", "0 NaN 426 330 NaN \n", "1 NaN 423 316 NaN \n", "2 NaN 457 343 NaN \n", "3 NaN 440 358 NaN \n", "4 NaN 445 384 NaN \n", "5 NaN 462 405 NaN \n", "6 NaN 564 428 NaN \n", "7 NaN 602 548 NaN \n", "8 NaN 678 953 NaN \n", "9 NaN 1367 2407 NaN \n", "\n", " St Louis, MO Jackson, MS Cary, NC Charlotte, NC Durham, NC \\\n", "0 391 NaN NaN 561 521 \n", "1 397 NaN NaN 673 536 \n", "2 408 NaN NaN 738 521 \n", "3 426 NaN NaN 799 563 \n", "4 448 NaN NaN 925 573 \n", "5 464 NaN NaN 975 601 \n", "6 648 NaN NaN 966 739 \n", "7 724 NaN NaN 986 1130 \n", "8 1183 NaN NaN 1298 1436 \n", "9 2862 NaN NaN 2439 3034 \n", "\n", " Greensboro, NC Raleigh, NC Lincoln, NE Omaha, NE Newark, NJ \\\n", "0 NaN 503 NaN 314 540 \n", "1 NaN 586 NaN 331 549 \n", "2 NaN 838 NaN 373 575 \n", "3 NaN 866 NaN 382 584 \n", "4 NaN 831 NaN 421 626 \n", "5 NaN 1065 NaN 431 658 \n", "6 NaN 1132 NaN 622 707 \n", "7 NaN 1200 NaN 915 818 \n", "8 NaN 1884 NaN 2691 1049 \n", "9 NaN 3785 NaN 6672 1501 \n", "\n", " Albuquerque, NM Las Vegas, NV Reno, NV Albany, NY Buffalo, NY \\\n", "0 NaN 843 NaN 505 NaN \n", "1 NaN 831 NaN 508 NaN \n", "2 1068 824 NaN 555 NaN \n", "3 1092 834 NaN 604 548 \n", "4 1089 872 NaN 629 557 \n", "5 1194 1028 NaN 678 653 \n", "6 1278 1096 NaN 825 694 \n", "7 1982 1408 NaN 1003 817 \n", "8 3367 2071 NaN 1253 986 \n", "9 10548 5093 NaN 2879 1327 \n", "\n", " New York, NY Rochester, NY Cleveland, OH Columbus, OH Dayton, OH \\\n", "0 579 406 466 437 NaN \n", "1 730 483 535 415 NaN \n", "2 652 476 671 442 NaN \n", "3 831 498 703 485 NaN \n", "4 776 662 794 522 NaN \n", "5 1030 1008 928 546 NaN \n", "6 957 1099 929 591 NaN \n", "7 1639 1483 1079 830 NaN \n", "8 2519 1527 1100 1060 641 \n", "9 2831 2356 2136 3419 1179 \n", "\n", " Oklahoma City, OK Tulsa, OK Beaverton, OR Eugene, OR Portland, OR \\\n", "0 924 1034 NaN NaN 444 \n", "1 894 1042 NaN NaN 471 \n", "2 922 1089 NaN NaN 574 \n", "3 1024 1089 NaN NaN 683 \n", "4 1191 1095 NaN NaN 735 \n", "5 1232 1187 NaN NaN 866 \n", "6 1407 2024 NaN NaN 1142 \n", "7 4436 3250 NaN NaN 1553 \n", "8 10155 7148 NaN NaN 2452 \n", "9 13958 13264 NaN NaN 4071 \n", "\n", " Philadelphia, PA Pittsburgh, PA State College, PA Providence, RI \\\n", "0 1204 1122 NaN NaN \n", "1 1124 1193 NaN NaN \n", "2 1249 1306 NaN NaN \n", "3 1279 1343 NaN NaN \n", "4 1537 1484 NaN NaN \n", "5 1542 1445 NaN NaN \n", "6 1638 1734 NaN NaN \n", "7 1628 2653 NaN NaN \n", "8 1958 3085 NaN NaN \n", "9 3074 4696 NaN NaN \n", "\n", " Columbia, SC Greenville, SC Knoxville, TN Memphis, TN Nashville, TN \\\n", "0 NaN NaN NaN NaN 425 \n", "1 NaN NaN NaN NaN 468 \n", "2 NaN NaN NaN NaN 497 \n", "3 NaN NaN NaN NaN 544 \n", "4 NaN NaN NaN NaN 554 \n", "5 NaN NaN NaN NaN 603 \n", "6 NaN NaN NaN NaN 655 \n", "7 NaN NaN NaN NaN 902 \n", "8 NaN NaN NaN NaN 1098 \n", "9 NaN NaN NaN NaN 2578 \n", "\n", " Austin, TX Dallas, TX Ft Worth, TX Houston, TX Irving, TX Lubbock, TX \\\n", "0 1150 1200 NaN 1412 1122 NaN \n", "1 1331 1487 NaN 2057 1208 NaN \n", "2 1492 1869 NaN 3770 1191 NaN \n", "3 2696 1897 NaN 6618 1516 NaN \n", "4 3918 2029 NaN 6412 1559 NaN \n", "5 3840 2647 NaN 6046 1891 NaN \n", "6 3064 3387 NaN 4379 2514 NaN \n", "7 7201 5723 NaN 3925 3314 NaN \n", "8 7259 7441 NaN 4054 3417 NaN \n", "9 7392 8642 NaN 5553 5002 NaN \n", "\n", " Plano, TX San Antonio, TX Salt Lake City, UT Arlington, VA Norfolk, VA \\\n", "0 NaN 986 261 1066 948 \n", "1 NaN 989 249 1249 963 \n", "2 NaN 1463 295 1289 970 \n", "3 NaN 2095 292 1308 1011 \n", "4 NaN 3282 328 1426 1009 \n", "5 NaN 3554 355 1419 1032 \n", "6 NaN 3706 482 1565 1150 \n", "7 NaN 4888 973 1584 1330 \n", "8 NaN 6983 2594 1824 1713 \n", "9 NaN 7940 4086 2860 3102 \n", "\n", " Reston, VA Richmond, VA Bellevue, WA Seattle, WA Spokane, WA \\\n", "0 NaN 1035 NaN 668 NaN \n", "1 NaN 1135 NaN 787 NaN \n", "2 NaN 1170 NaN 994 NaN \n", "3 NaN 1342 NaN 999 NaN \n", "4 NaN 1354 NaN 1297 NaN \n", "5 NaN 1446 NaN 1100 NaN \n", "6 NaN 1927 NaN 1969 NaN \n", "7 NaN 2186 NaN 2880 NaN \n", "8 NaN 2552 NaN 4152 NaN \n", "9 NaN 3484 1571 7445 NaN \n", "\n", " Madison, WI Milwaukee, WI \n", "0 622 452 \n", "1 626 449 \n", "2 661 437 \n", "3 649 487 \n", "4 657 499 \n", "5 707 521 \n", "6 821 566 \n", "7 1364 725 \n", "8 1627 837 \n", "9 2969 1314 " ] } ], "prompt_number": 9 }, { "cell_type": "code", "collapsed": false, "input": [ "#Split into States, HHS Regions and Cities and Rtoate dataframe 90 with Transpose\n", "\n", "statesList = ['Alabama','Alaska','Arizona','Arkansas','California','Colorado','Connecticut','Delaware','District of Columbia','Florida','Georgia','Hawaii','Idaho','Illinois','Indiana','Iowa','Kansas','Kentucky','Louisiana','Maine','Maryland','Massachusetts','Michigan','Minnesota','Mississippi','Missouri','Montana','Nebraska','Nevada','New Hampshire','New Jersey','New Mexico','New York','North Carolina','North Dakota','Ohio','Oklahoma','Oregon','Pennsylvania','Rhode Island','South Carolina','South Dakota','Tennessee','Texas','Utah','Vermont','Virginia','Washington','West Virginia','Wisconsin','Wyoming']\n", "hhsList = ['HHS Region 1 (CT, ME, MA, NH, RI, VT)','HHS Region 2 (NJ, NY)','HHS Region 3 (DE, DC, MD, PA, VA, WV)','HHS Region 4 (AL, FL, GA, KY, MS, NC, SC, TN)','HHS Region 5 (IL, IN, MI, MN, OH, WI)','HHS Region 6 (AR, LA, NM, OK, TX)','HHS Region 7 (IA, KS, MO, NE)','HHS Region 8 (CO, MT, ND, SD, UT, WY)','HHS Region 9 (AZ, CA, HI, NV)','HHS Region 10 (AK, ID, OR, WA)']\n", "citiesList = ['Anchorage, AK','Birmingham, AL','Little Rock, AR','Mesa, AZ','Phoenix, AZ','Scottsdale, AZ','Tempe, AZ','Tucson, AZ','Berkeley, CA','Fresno, CA','Irvine, CA','Los Angeles, CA','Oakland, CA','Sacramento, CA','San Diego, CA','San Francisco, CA','San Jose, CA','Santa Clara, CA','Sunnyvale, CA','Colorado Springs, CO','Denver, CO','Washington, DC','Gainesville, FL','Jacksonville, FL','Miami, FL','Orlando, FL','Tampa, FL','Atlanta, GA','Roswell, GA','Honolulu, HI','Des Moines, IA','Boise, ID','Chicago, IL','Indianapolis, IN','Wichita, KS','Lexington, KY','Baton Rouge, LA','New Orleans, LA','Boston, MA','Somerville, MA','Baltimore, MD','Grand Rapids, MI','St Paul, MN','Kansas City, MO','Springfield, MO','St Louis, MO','Jackson, MS','Cary, NC','Charlotte, NC','Durham, NC','Greensboro, NC','Raleigh, NC','Lincoln, NE','Omaha, NE','Newark, NJ','Albuquerque, NM','Las Vegas, NV','Reno, NV','Albany, NY','Buffalo, NY','New York, NY','Rochester, NY','Cleveland, OH','Columbus, OH','Dayton, OH','Oklahoma City, OK','Tulsa, OK','Beaverton, OR','Eugene, OR','Portland, OR','Philadelphia, PA','Pittsburgh, PA','State College, PA','Providence, RI','Columbia, SC','Greenville, SC','Knoxville, TN','Memphis, TN','Nashville, TN','Austin, TX','Dallas, TX','Ft Worth, TX','Houston, TX','Irving, TX','Lubbock, TX','Plano, TX','San Antonio, TX','Salt Lake City, UT','Arlington, VA','Norfolk, VA','Reston, VA','Richmond, VA','Bellevue, WA','Seattle, WA','Spokane, WA','Madison, WI','Milwaukee, WI']\n", "\n", "dfS = dfFluGoo[['Date']+statesList]\n", "dfS = dfS.T\n", "dfH = dfFluGoo[['Date']+hhsList]\n", "dfH = dfH.T\n", "dfC = dfFluGoo[['Date']+citiesList]\n", "dfC = dfC.T\n", "\n", "StatesFlu = '/Users/danielmsheehan/GitHub/d3-presentation/data/flu/google/states_flu_data.csv'\n", "HHSFlu = '/Users/danielmsheehan/GitHub/d3-presentation/data/flu/google/hhs_flu_data.csv'\n", "CitiesFlu = '/Users/danielmsheehan/GitHub/d3-presentation/data/flu/google/cities_flu_data.csv'\n", "\n", "dfS.to_csv(StatesFlu, index=True, header = False) \n", "dfH.to_csv(HHSFlu, index=True, header = False) \n", "dfC.to_csv(CitiesFlu, index=True, header = False) " ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 60 }, { "cell_type": "code", "collapsed": false, "input": [ "dfS = pd.read_csv(StatesFlu)\n", "dfC = pd.read_csv(CitiesFlu)\n", "\n", "dfS = dfS.rename(columns=lambda x: x.replace('Date', 'state'))\n", "#dfH = dfH.rename(columns=lambda x: x.replace('Date', 'State'))\n", "dfC = dfC.rename(columns=lambda x: x.replace('Date', 'City'))\n", "\n", "#print dfS.head(10)\n", "#print dfC.head(10)\n", "\n", "dfS.to_csv(StatesFlu, index=False)\n", "dfC.to_csv(CitiesFlu, index=False)" ], "language": "python", "metadata": {}, "outputs": [ { "ename": "NameError", "evalue": "name 'pd' is not defined", "output_type": "pyerr", "traceback": [ "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m\n\u001b[0;31mNameError\u001b[0m Traceback (most recent call last)", "\u001b[0;32m\u001b[0m in \u001b[0;36m\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdfS\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mStatesFlu\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m 2\u001b[0m \u001b[0mdfC\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mCitiesFlu\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 3\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 4\u001b[0m \u001b[0mdfS\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdfS\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mrename\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mlambda\u001b[0m \u001b[0mx\u001b[0m\u001b[0;34m:\u001b[0m \u001b[0mx\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mreplace\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'Date'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m'state'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 5\u001b[0m \u001b[0;31m#dfH = dfH.rename(columns=lambda x: x.replace('Date', 'State'))\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n", "\u001b[0;31mNameError\u001b[0m: name 'pd' is not defined" ] } ], "prompt_number": 1 }, { "cell_type": "code", "collapsed": false, "input": [ "#Download Shapefile \n", "import urllib\n", "\n", "zipLoc = \"/Users/danielmsheehan/GitHub/d3-presentation/data/census/states/cb_2013_us_state_20m.zip\"\n", "urllib.urlretrieve (\"http://www2.census.gov/geo/tiger/GENZ2013/cb_2013_us_state_20m.zip\", zipLoc)\n", "\n", "import zipfile \n", " \n", "zip = zipfile.ZipFile(zipLoc) \n", "zip.extractall(\"/Users/danielmsheehan/GitHub/d3-presentation/data/census/states/\") " ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 44 }, { "cell_type": "markdown", "metadata": {}, "source": [ "States Shapefile in [QGIS](http://www2.qgis.org/)\n", "\n", "![states](https://raw.githubusercontent.com/stat4701-edav-d3/d3-presentation/master/img/states_qgis.png)\n", "\n", "And now the date table associated with the shapefile (in the .dbf). Note: data or columns in GIS files is often referred to as an 'attribute table.'\n", "\n", "![state attributes](https://raw.githubusercontent.com/stat4701-edav-d3/d3-presentation/master/img/states_attribute.png)\n", "\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "##GDAL/OGR\n", "\n", "Using [GDAL/OGR](http://www.gdal.org/) convert the Shapefile to JSON. \n", "\n", " ogr2ogr -f GeoJSON /Users/danielmsheehan/GitHub/d3-presentation/data/census/states/states.json /Users/danielmsheehan/GitHub/d3-presentation/data/census/states/cb_2013_us_state_20m.shp\n", "\n", "Then, after installing node.js, we can create TopoJson\n", " \n", " topojson /Users/danielmsheehan/GitHub/d3-presentation/data/census/states/states.topo.json /Users/danielmsheehan/GitHub/d3-presentation/data/census/states/states.json\n", "\n", "More simply:\n", " topojson states_cln.topo.json states.json\n", " \n", "[So here's this TopoJSON file in a simple plot](http://stat4701-edav-d3.github.io/viz/plot_json_1.html) \n", " \n", "![plot json](https://raw.githubusercontent.com/stat4701-edav-d3/d3-presentation/master/img/plot_json.png) \n" ] }, { "cell_type": "code", "collapsed": false, "input": [ "#Need to get US State Population Dataset to create a Flu Rate. \n", "dfPop = pd.io.json.read_json('http://api.census.gov/data/2010/sf1?key=30699f15ab4d04a1e0943715b539d256c9a3ee44&get=P0010001&for=state')\n", "\n", "#dfPop = dfPop.header(1)\n", "dfPop = dfPop.ix[1:]\n", "\n", "dfPop.columns = ['pop', 'fips']\n", "\n", "print dfPop.head(5)\n", "\n", "dfFIPS = pd.read_csv('/Users/danielmsheehan/GitHub/data/census/state_fips.csv', dtype={'fips':object})\n", "\n", "print dfFIPS.head(5)\n" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ " pop fips\n", "1 4779736 01\n", "2 710231 02\n", "3 6392017 04\n", "4 2915918 05\n", "5 37253956 06\n", " state abbrev fips info\n", "0 Alabama AL 01 State; counties\n", "1 Alaska AK 02 State; boroughs\n", "2 American Samoa AS 60 Outlying area under U.S. sovereignty\n", "3 American Samoa * NaN 03 (FIPS 5-1 reserved code)\n", "4 Arizona AZ 04 State; counties\n" ] } ], "prompt_number": 139 }, { "cell_type": "code", "collapsed": false, "input": [ "df = dfS.merge(dfFIPS, how='left', on='state')\n", "\n", "df = df.merge(dfPop, how='left', on='fips')\n", "\n", "df.head(10)\n", "\n", "df.to_csv('/Users/danielmsheehan/GitHub/d3-presentation/data/flu/google/states_pop_week.csv', index=False)\n", "#print list(df.columns.values)" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 140 }, { "cell_type": "code", "collapsed": false, "input": [ "df = pd.read_csv('/Users/danielmsheehan/GitHub/d3-presentation/data/flu/google/states_pop_week.csv', dtype={'fips':object})\n", "\n", "#df['pop'] = df['pop'].astype(float)\n", "\n", "#print df.types\n", "\n", "for i in weekList:\n", " df['rate'+i] = df[i]/df['pop'] * 10000\n", " \n", "df = df.drop(weekList, axis=1)\n", "\n", "df.head(53)\n", "\n", "df.to_csv('/Users/danielmsheehan/GitHub/d3-presentation/data/flu/google/states_pop_week_rate_state.csv', index=False)\n" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 148 }, { "cell_type": "code", "collapsed": false, "input": [ "#Get a list of County FIPS\n", "dfCounties = pd.read_csv('http://www2.census.gov/geo/docs/reference/codes/files/national_county.txt', header=None, dtype={1:object,2:object})\n", "dfCounties.columns = ['state_abbrev', 'state_fips','county_fips','fullname','note']\n", "\n", "dfCounties['fips'] = dfCounties['state_fips']\n", "\n", "dfCounties.head(5)" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
state_abbrevstate_fipscounty_fipsfullnamenotefips
0 AL 01 001 Autauga County H1 01
1 AL 01 003 Baldwin County H1 01
2 AL 01 005 Barbour County H1 01
3 AL 01 007 Bibb County H1 01
4 AL 01 009 Blount County H1 01
\n", "
" ], "metadata": {}, "output_type": "pyout", "prompt_number": 142, "text": [ " state_abbrev state_fips county_fips fullname note fips\n", "0 AL 01 001 Autauga County H1 01\n", "1 AL 01 003 Baldwin County H1 01\n", "2 AL 01 005 Barbour County H1 01\n", "3 AL 01 007 Bibb County H1 01\n", "4 AL 01 009 Blount County H1 01" ] } ], "prompt_number": 142 }, { "cell_type": "code", "collapsed": false, "input": [ "dfAll = dfCounties.merge(df, on='fips', how='left')\n", "\n", "dfAll['id'] = dfAll.state_fips.map(str) + dfAll.county_fips.map(str)\n", "\n", "dfAll['id'] = dfAll['id'].astype(int)\n", "\n", "dfAll.head(10)\n", "\n", "dfAll.to_csv('/Users/danielmsheehan/GitHub/d3-presentation/data/flu/google/states_pop_week_rates_county.csv', index=False)\n", "\n", "weekList = ['2003-09-28','2003-10-05','2003-10-12','2003-10-19','2003-10-26','2003-11-02','2003-11-09','2003-11-16','2003-11-23','2003-11-30','2003-12-07','2003-12-14','2003-12-21','2003-12-28','2004-01-04','2004-01-11','2004-01-18','2004-01-25','2004-02-01','2004-02-08','2004-02-15','2004-02-22','2004-02-29','2004-03-07','2004-03-14','2004-03-21','2004-03-28','2004-04-04','2004-04-11','2004-04-18','2004-04-25','2004-05-02','2004-05-09','2004-05-16','2004-05-23','2004-05-30','2004-06-06','2004-06-13','2004-06-20','2004-06-27','2004-07-04','2004-07-11','2004-07-18','2004-07-25','2004-08-01','2004-08-08','2004-08-15','2004-08-22','2004-08-29','2004-09-05','2004-09-12','2004-09-19','2004-09-26','2004-10-03','2004-10-10','2004-10-17','2004-10-24','2004-10-31','2004-11-07','2004-11-14','2004-11-21','2004-11-28','2004-12-05','2004-12-12','2004-12-19','2004-12-26','2005-01-02','2005-01-09','2005-01-16','2005-01-23','2005-01-30','2005-02-06','2005-02-13','2005-02-20','2005-02-27','2005-03-06','2005-03-13','2005-03-20','2005-03-27','2005-04-03','2005-04-10','2005-04-17','2005-04-24','2005-05-01','2005-05-08','2005-05-15','2005-05-22','2005-05-29','2005-06-05','2005-06-12','2005-06-19','2005-06-26','2005-07-03','2005-07-10','2005-07-17','2005-07-24','2005-07-31','2005-08-07','2005-08-14','2005-08-21','2005-08-28','2005-09-04','2005-09-11','2005-09-18','2005-09-25','2005-10-02','2005-10-09','2005-10-16','2005-10-23','2005-10-30','2005-11-06','2005-11-13','2005-11-20','2005-11-27','2005-12-04','2005-12-11','2005-12-18','2005-12-25','2006-01-01','2006-01-08','2006-01-15','2006-01-22','2006-01-29','2006-02-05','2006-02-12','2006-02-19','2006-02-26','2006-03-05','2006-03-12','2006-03-19','2006-03-26','2006-04-02','2006-04-09','2006-04-16','2006-04-23','2006-04-30','2006-05-07','2006-05-14','2006-05-21','2006-05-28','2006-06-04','2006-06-11','2006-06-18','2006-06-25','2006-07-02','2006-07-09','2006-07-16','2006-07-23','2006-07-30','2006-08-06','2006-08-13','2006-08-20','2006-08-27','2006-09-03','2006-09-10','2006-09-17','2006-09-24','2006-10-01','2006-10-08','2006-10-15','2006-10-22','2006-10-29','2006-11-05','2006-11-12','2006-11-19','2006-11-26','2006-12-03','2006-12-10','2006-12-17','2006-12-24','2006-12-31','2007-01-07','2007-01-14','2007-01-21','2007-01-28','2007-02-04','2007-02-11','2007-02-18','2007-02-25','2007-03-04','2007-03-11','2007-03-18','2007-03-25','2007-04-01','2007-04-08','2007-04-15','2007-04-22','2007-04-29','2007-05-06','2007-05-13','2007-05-20','2007-05-27','2007-06-03','2007-06-10','2007-06-17','2007-06-24','2007-07-01','2007-07-08','2007-07-15','2007-07-22','2007-07-29','2007-08-05','2007-08-12','2007-08-19','2007-08-26','2007-09-02','2007-09-09','2007-09-16','2007-09-23','2007-09-30','2007-10-07','2007-10-14','2007-10-21','2007-10-28','2007-11-04','2007-11-11','2007-11-18','2007-11-25','2007-12-02','2007-12-09','2007-12-16','2007-12-23','2007-12-30','2008-01-06','2008-01-13','2008-01-20','2008-01-27','2008-02-03','2008-02-10','2008-02-17','2008-02-24','2008-03-02','2008-03-09','2008-03-16','2008-03-23','2008-03-30','2008-04-06','2008-04-13','2008-04-20','2008-04-27','2008-05-04','2008-05-11','2008-05-18','2008-05-25','2008-06-01','2008-06-08','2008-06-15','2008-06-22','2008-06-29','2008-07-06','2008-07-13','2008-07-20','2008-07-27','2008-08-03','2008-08-10','2008-08-17','2008-08-24','2008-08-31','2008-09-07','2008-09-14','2008-09-21','2008-09-28','2008-10-05','2008-10-12','2008-10-19','2008-10-26','2008-11-02','2008-11-09','2008-11-16','2008-11-23','2008-11-30','2008-12-07','2008-12-14','2008-12-21','2008-12-28','2009-01-04','2009-01-11','2009-01-18','2009-01-25','2009-02-01','2009-02-08','2009-02-15','2009-02-22','2009-03-01','2009-03-08','2009-03-15','2009-03-22','2009-03-29','2009-04-05','2009-04-12','2009-04-19','2009-04-26','2009-05-03','2009-05-10','2009-05-17','2009-05-24','2009-05-31','2009-06-07','2009-06-14','2009-06-21','2009-06-28','2009-07-05','2009-07-12','2009-07-19','2009-07-26','2009-08-02','2009-08-09','2009-08-16','2009-08-23','2009-08-30','2009-09-06','2009-09-13','2009-09-20','2009-09-27','2009-10-04','2009-10-11','2009-10-18','2009-10-25','2009-11-01','2009-11-08','2009-11-15','2009-11-22','2009-11-29','2009-12-06','2009-12-13','2009-12-20','2009-12-27','2010-01-03','2010-01-10','2010-01-17','2010-01-24','2010-01-31','2010-02-07','2010-02-14','2010-02-21','2010-02-28','2010-03-07','2010-03-14','2010-03-21','2010-03-28','2010-04-04','2010-04-11','2010-04-18','2010-04-25','2010-05-02','2010-05-09','2010-05-16','2010-05-23','2010-05-30','2010-06-06','2010-06-13','2010-06-20','2010-06-27','2010-07-04','2010-07-11','2010-07-18','2010-07-25','2010-08-01','2010-08-08','2010-08-15','2010-08-22','2010-08-29','2010-09-05','2010-09-12','2010-09-19','2010-09-26','2010-10-03','2010-10-10','2010-10-17','2010-10-24','2010-10-31','2010-11-07','2010-11-14','2010-11-21','2010-11-28','2010-12-05','2010-12-12','2010-12-19','2010-12-26','2011-01-02','2011-01-09','2011-01-16','2011-01-23','2011-01-30','2011-02-06','2011-02-13','2011-02-20','2011-02-27','2011-03-06','2011-03-13','2011-03-20','2011-03-27','2011-04-03','2011-04-10','2011-04-17','2011-04-24','2011-05-01','2011-05-08','2011-05-15','2011-05-22','2011-05-29','2011-06-05','2011-06-12','2011-06-19','2011-06-26','2011-07-03','2011-07-10','2011-07-17','2011-07-24','2011-07-31','2011-08-07','2011-08-14','2011-08-21','2011-08-28','2011-09-04','2011-09-11','2011-09-18','2011-09-25','2011-10-02','2011-10-09','2011-10-16','2011-10-23','2011-10-30','2011-11-06','2011-11-13','2011-11-20','2011-11-27','2011-12-04','2011-12-11','2011-12-18','2011-12-25','2012-01-01','2012-01-08','2012-01-15','2012-01-22','2012-01-29','2012-02-05','2012-02-12','2012-02-19','2012-02-26','2012-03-04','2012-03-11','2012-03-18','2012-03-25','2012-04-01','2012-04-08','2012-04-15','2012-04-22','2012-04-29','2012-05-06','2012-05-13','2012-05-20','2012-05-27','2012-06-03','2012-06-10','2012-06-17','2012-06-24','2012-07-01','2012-07-08','2012-07-15','2012-07-22','2012-07-29','2012-08-05','2012-08-12','2012-08-19','2012-08-26','2012-09-02','2012-09-09','2012-09-16','2012-09-23','2012-09-30','2012-10-07','2012-10-14','2012-10-21','2012-10-28','2012-11-04','2012-11-11','2012-11-18','2012-11-25','2012-12-02','2012-12-09','2012-12-16','2012-12-23','2012-12-30','2013-01-06','2013-01-13','2013-01-20','2013-01-27','2013-02-03','2013-02-10','2013-02-17','2013-02-24','2013-03-03','2013-03-10','2013-03-17','2013-03-24','2013-03-31','2013-04-07','2013-04-14','2013-04-21','2013-04-28','2013-05-05','2013-05-12','2013-05-19','2013-05-26','2013-06-02','2013-06-09','2013-06-16','2013-06-23','2013-06-30','2013-07-07','2013-07-14','2013-07-21','2013-07-28','2013-08-04','2013-08-11','2013-08-18','2013-08-25','2013-09-01','2013-09-08','2013-09-15','2013-09-22','2013-09-29','2013-10-06','2013-10-13','2013-10-20','2013-10-27','2013-11-03','2013-11-10','2013-11-17','2013-11-24','2013-12-01','2013-12-08','2013-12-15','2013-12-22','2013-12-29','2014-01-05','2014-01-12','2014-01-19','2014-01-26','2014-02-02','2014-02-09','2014-02-16','2014-02-23','2014-03-02','2014-03-09','2014-03-16','2014-03-23','2014-03-30','2014-04-06','2014-04-13','2014-04-20','2014-04-27','2014-05-04','2014-05-11','2014-05-18','2014-05-25','2014-06-01','2014-06-08','2014-06-15','2014-06-22','2014-06-29','2014-07-06','2014-07-13','2014-07-20','2014-07-27','2014-08-03','2014-08-10','2014-08-17','2014-08-24','2014-08-31','2014-09-07','2014-09-14','2014-09-21','2014-09-28','2014-10-05','2014-10-12','2014-10-19','2014-10-26','2014-11-02','2014-11-09','2014-11-16','2014-11-23','2014-11-30','2014-12-07','2014-12-14','2014-12-21','2014-12-28','2015-01-04','2015-01-11','2015-01-18','2015-01-25','2015-02-01','2015-02-08','2015-02-15','2015-02-22','2015-03-01']\n", "\n", "for i in weekList:\n", " #print i\n", " dfSamp = dfAll[['id','rate'+i]]\n", " dfSamp.columns = ['id', 'rate']\n", " dfSamp.to_csv('/Users/danielmsheehan/GitHub/stat4701-edav-d3.github.com/viz/choropleth/pages/data/rate-'+i+'.tsv', index=False, sep='\\t')\n", "\n", " \n" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "2003-09-28\n", "2003-10-05\n", "2003-10-12\n", "2003-10-19\n", "2003-10-26\n", "2003-11-02\n", "2003-11-09\n", "2003-11-16\n", "2003-11-23\n", "2003-11-30" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2003-12-07\n", "2003-12-14\n", "2003-12-21\n", "2003-12-28\n", "2004-01-04\n", "2004-01-11\n", "2004-01-18\n", "2004-01-25\n", "2004-02-01" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2004-02-08\n", "2004-02-15\n", "2004-02-22\n", "2004-02-29\n", "2004-03-07\n", "2004-03-14\n", "2004-03-21\n", "2004-03-28\n", "2004-04-04" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2004-04-11\n", "2004-04-18\n", "2004-04-25\n", "2004-05-02\n", "2004-05-09\n", "2004-05-16\n", "2004-05-23\n", "2004-05-30\n", "2004-06-06" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2004-06-13\n", "2004-06-20\n", "2004-06-27\n", "2004-07-04\n", "2004-07-11\n", "2004-07-18\n", "2004-07-25\n", "2004-08-01" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2004-08-08\n", "2004-08-15\n", "2004-08-22\n", "2004-08-29\n", "2004-09-05\n", "2004-09-12\n", "2004-09-19\n", "2004-09-26" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2004-10-03\n", "2004-10-10\n", "2004-10-17\n", "2004-10-24\n", "2004-10-31\n", "2004-11-07\n", "2004-11-14" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2004-11-21\n", "2004-11-28\n", "2004-12-05\n", "2004-12-12\n", "2004-12-19\n", "2004-12-26\n", "2005-01-02\n", "2005-01-09" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2005-01-16\n", "2005-01-23\n", "2005-01-30\n", "2005-02-06\n", "2005-02-13\n", "2005-02-20\n", "2005-02-27\n", "2005-03-06" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2005-03-13\n", "2005-03-20\n", "2005-03-27\n", "2005-04-03\n", "2005-04-10\n", "2005-04-17\n", "2005-04-24\n", "2005-05-01" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2005-05-08\n", "2005-05-15\n", "2005-05-22\n", "2005-05-29\n", "2005-06-05\n", "2005-06-12\n", "2005-06-19\n", "2005-06-26" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2005-07-03\n", "2005-07-10\n", "2005-07-17\n", "2005-07-24\n", "2005-07-31\n", "2005-08-07\n", "2005-08-14" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2005-08-21\n", "2005-08-28\n", "2005-09-04\n", "2005-09-11\n", "2005-09-18\n", "2005-09-25\n", "2005-10-02\n", "2005-10-09" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2005-10-16\n", "2005-10-23\n", "2005-10-30\n", "2005-11-06\n", "2005-11-13\n", "2005-11-20\n", "2005-11-27\n", "2005-12-04" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2005-12-11\n", "2005-12-18\n", "2005-12-25\n", "2006-01-01\n", "2006-01-08\n", "2006-01-15\n", "2006-01-22\n", "2006-01-29" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2006-02-05\n", "2006-02-12\n", "2006-02-19\n", "2006-02-26\n", "2006-03-05\n", "2006-03-12\n", "2006-03-19\n", "2006-03-26" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2006-04-02\n", "2006-04-09\n", "2006-04-16\n", "2006-04-23\n", "2006-04-30\n", "2006-05-07\n", "2006-05-14" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2006-05-21\n", "2006-05-28\n", "2006-06-04\n", "2006-06-11\n", "2006-06-18\n", "2006-06-25\n", "2006-07-02" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2006-07-09\n", "2006-07-16\n", "2006-07-23\n", "2006-07-30\n", "2006-08-06\n", "2006-08-13\n", "2006-08-20" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2006-08-27\n", "2006-09-03\n", "2006-09-10\n", "2006-09-17\n", "2006-09-24\n", "2006-10-01\n", "2006-10-08" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2006-10-15\n", "2006-10-22\n", "2006-10-29\n", "2006-11-05\n", "2006-11-12\n", "2006-11-19\n", "2006-11-26" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2006-12-03\n", "2006-12-10\n", "2006-12-17\n", "2006-12-24\n", "2006-12-31\n", "2007-01-07\n", "2007-01-14" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2007-01-21\n", "2007-01-28\n", "2007-02-04\n", "2007-02-11\n", "2007-02-18\n", "2007-02-25\n", "2007-03-04" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2007-03-11\n", "2007-03-18\n", "2007-03-25\n", "2007-04-01\n", "2007-04-08\n", "2007-04-15\n", "2007-04-22" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2007-04-29\n", "2007-05-06\n", "2007-05-13\n", "2007-05-20\n", "2007-05-27\n", "2007-06-03\n", "2007-06-10" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2007-06-17\n", "2007-06-24\n", "2007-07-01\n", "2007-07-08\n", "2007-07-15\n", "2007-07-22\n", "2007-07-29" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2007-08-05\n", "2007-08-12\n", "2007-08-19\n", "2007-08-26\n", "2007-09-02\n", "2007-09-09\n", "2007-09-16" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2007-09-23\n", "2007-09-30\n", "2007-10-07\n", "2007-10-14\n", "2007-10-21\n", "2007-10-28\n", "2007-11-04\n", "2007-11-11" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2007-11-18\n", "2007-11-25\n", "2007-12-02\n", "2007-12-09\n", "2007-12-16\n", "2007-12-23\n", "2007-12-30" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2008-01-06\n", "2008-01-13\n", "2008-01-20\n", "2008-01-27\n", "2008-02-03\n", "2008-02-10" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2008-02-17\n", "2008-02-24\n", "2008-03-02\n", "2008-03-09\n", "2008-03-16\n", "2008-03-23" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2008-03-30\n", "2008-04-06\n", "2008-04-13\n", "2008-04-20\n", "2008-04-27\n", "2008-05-04" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2008-05-11\n", "2008-05-18\n", "2008-05-25\n", "2008-06-01\n", "2008-06-08\n", "2008-06-15\n", "2008-06-22" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2008-06-29\n", "2008-07-06\n", "2008-07-13\n", "2008-07-20\n", "2008-07-27\n", "2008-08-03\n", "2008-08-10" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2008-08-17\n", "2008-08-24\n", "2008-08-31\n", "2008-09-07\n", "2008-09-14\n", "2008-09-21\n", "2008-09-28" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2008-10-05\n", "2008-10-12\n", "2008-10-19\n", "2008-10-26\n", "2008-11-02\n", "2008-11-09" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2008-11-16\n", "2008-11-23\n", "2008-11-30\n", "2008-12-07\n", "2008-12-14\n", "2008-12-21\n", "2008-12-28" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2009-01-04\n", "2009-01-11\n", "2009-01-18\n", "2009-01-25\n", "2009-02-01\n", "2009-02-08\n", "2009-02-15" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2009-02-22\n", "2009-03-01\n", "2009-03-08\n", "2009-03-15\n", "2009-03-22\n", "2009-03-29" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2009-04-05\n", "2009-04-12\n", "2009-04-19\n", "2009-04-26\n", "2009-05-03\n", "2009-05-10" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2009-05-17\n", "2009-05-24\n", "2009-05-31\n", "2009-06-07\n", "2009-06-14\n", "2009-06-21" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2009-06-28\n", "2009-07-05\n", "2009-07-12\n", "2009-07-19\n", "2009-07-26\n", "2009-08-02\n", "2009-08-09" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2009-08-16\n", "2009-08-23\n", "2009-08-30\n", "2009-09-06\n", "2009-09-13\n", "2009-09-20\n", "2009-09-27" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2009-10-04\n", "2009-10-11\n", "2009-10-18\n", "2009-10-25\n", "2009-11-01\n", "2009-11-08" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2009-11-15\n", "2009-11-22\n", "2009-11-29\n", "2009-12-06\n", "2009-12-13\n", "2009-12-20\n", "2009-12-27" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2010-01-03\n", "2010-01-10\n", "2010-01-17\n", "2010-01-24\n", "2010-01-31\n", "2010-02-07\n", "2010-02-14" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2010-02-21\n", "2010-02-28\n", "2010-03-07\n", "2010-03-14\n", "2010-03-21\n", "2010-03-28\n", "2010-04-04" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2010-04-11\n", "2010-04-18\n", "2010-04-25\n", "2010-05-02\n", "2010-05-09\n", "2010-05-16\n", "2010-05-23" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2010-05-30\n", "2010-06-06\n", "2010-06-13\n", "2010-06-20\n", "2010-06-27\n", "2010-07-04\n", "2010-07-11" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2010-07-18\n", "2010-07-25\n", "2010-08-01\n", "2010-08-08\n", "2010-08-15\n", "2010-08-22\n", "2010-08-29" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2010-09-05\n", "2010-09-12\n", "2010-09-19\n", "2010-09-26\n", "2010-10-03\n", "2010-10-10\n", "2010-10-17" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2010-10-24\n", "2010-10-31\n", "2010-11-07\n", "2010-11-14\n", "2010-11-21\n", "2010-11-28\n", "2010-12-05" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2010-12-12\n", "2010-12-19\n", "2010-12-26\n", "2011-01-02\n", "2011-01-09\n", "2011-01-16\n", "2011-01-23" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2011-01-30\n", "2011-02-06\n", "2011-02-13\n", "2011-02-20\n", "2011-02-27\n", "2011-03-06" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2011-03-13\n", "2011-03-20\n", "2011-03-27\n", "2011-04-03\n", "2011-04-10\n", "2011-04-17\n", "2011-04-24" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2011-05-01\n", "2011-05-08\n", "2011-05-15\n", "2011-05-22\n", "2011-05-29\n", "2011-06-05\n", "2011-06-12" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2011-06-19\n", "2011-06-26\n", "2011-07-03\n", "2011-07-10\n", "2011-07-17\n", "2011-07-24\n", "2011-07-31" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2011-08-07\n", "2011-08-14\n", "2011-08-21\n", "2011-08-28\n", "2011-09-04\n", "2011-09-11\n", "2011-09-18" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2011-09-25\n", "2011-10-02\n", "2011-10-09\n", "2011-10-16\n", "2011-10-23\n", "2011-10-30\n", "2011-11-06" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2011-11-13\n", "2011-11-20\n", "2011-11-27\n", "2011-12-04\n", "2011-12-11\n", "2011-12-18\n", "2011-12-25" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2012-01-01\n", "2012-01-08\n", "2012-01-15\n", "2012-01-22\n", "2012-01-29\n", "2012-02-05\n", "2012-02-12" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2012-02-19\n", "2012-02-26\n", "2012-03-04\n", "2012-03-11\n", "2012-03-18\n", "2012-03-25\n", "2012-04-01" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2012-04-08\n", "2012-04-15\n", "2012-04-22\n", "2012-04-29\n", "2012-05-06\n", "2012-05-13" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2012-05-20\n", "2012-05-27\n", "2012-06-03\n", "2012-06-10\n", "2012-06-17\n", "2012-06-24\n", "2012-07-01" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2012-07-08\n", "2012-07-15\n", "2012-07-22\n", "2012-07-29\n", "2012-08-05\n", "2012-08-12\n", "2012-08-19" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2012-08-26\n", "2012-09-02\n", "2012-09-09\n", "2012-09-16\n", "2012-09-23\n", "2012-09-30\n", "2012-10-07" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2012-10-14\n", "2012-10-21\n", "2012-10-28\n", "2012-11-04\n", "2012-11-11\n", "2012-11-18\n", "2012-11-25\n", "2012-12-02" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2012-12-09\n", "2012-12-16\n", "2012-12-23\n", "2012-12-30\n", "2013-01-06\n", "2013-01-13\n", "2013-01-20\n", "2013-01-27" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2013-02-03\n", "2013-02-10\n", "2013-02-17\n", "2013-02-24\n", "2013-03-03\n", "2013-03-10\n", "2013-03-17\n", "2013-03-24" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2013-03-31\n", "2013-04-07\n", "2013-04-14\n", "2013-04-21\n", "2013-04-28\n", "2013-05-05\n", "2013-05-12" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2013-05-19\n", "2013-05-26\n", "2013-06-02\n", "2013-06-09\n", "2013-06-16" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2013-06-23\n", "2013-06-30\n", "2013-07-07\n", "2013-07-14\n", "2013-07-21\n", "2013-07-28\n", "2013-08-04" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2013-08-11\n", "2013-08-18\n", "2013-08-25\n", "2013-09-01\n", "2013-09-08\n", "2013-09-15\n", "2013-09-22" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2013-09-29\n", "2013-10-06\n", "2013-10-13\n", "2013-10-20\n", "2013-10-27\n", "2013-11-03\n", "2013-11-10" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2013-11-17\n", "2013-11-24\n", "2013-12-01\n", "2013-12-08\n", "2013-12-15\n", "2013-12-22\n", "2013-12-29" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2014-01-05\n", "2014-01-12\n", "2014-01-19\n", "2014-01-26\n", "2014-02-02\n", "2014-02-09\n", "2014-02-16" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2014-02-23\n", "2014-03-02\n", "2014-03-09\n", "2014-03-16\n", "2014-03-23\n", "2014-03-30\n", "2014-04-06" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2014-04-13\n", "2014-04-20\n", "2014-04-27\n", "2014-05-04\n", "2014-05-11\n", "2014-05-18" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2014-05-25\n", "2014-06-01\n", "2014-06-08\n", "2014-06-15\n", "2014-06-22\n", "2014-06-29\n", "2014-07-06" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2014-07-13\n", "2014-07-20\n", "2014-07-27\n", "2014-08-03\n", "2014-08-10\n", "2014-08-17" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2014-08-24\n", "2014-08-31\n", "2014-09-07\n", "2014-09-14\n", "2014-09-21\n", "2014-09-28\n", "2014-10-05" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2014-10-12\n", "2014-10-19\n", "2014-10-26\n", "2014-11-02\n", "2014-11-09\n", "2014-11-16" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2014-11-23\n", "2014-11-30\n", "2014-12-07\n", "2014-12-14\n", "2014-12-21\n", "2014-12-28\n", "2015-01-04" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2015-01-11\n", "2015-01-18\n", "2015-01-25\n", "2015-02-01\n", "2015-02-08\n", "2015-02-15\n", "2015-02-22" ] }, { "output_type": "stream", "stream": "stdout", "text": [ "\n", "2015-03-01\n" ] } ], "prompt_number": 146 }, { "cell_type": "code", "collapsed": false, "input": [], "language": "python", "metadata": {}, "outputs": [] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Lat Long's in Google Source HTML code: \n", "\n", "![latlngsinxcode](https://raw.githubusercontent.com/stat4701-edav-d3/stat4701-edav-d3.github.com/master/remark-develop/img/seeing-latlngs-in-xcode.png)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Next step is to grab this html file, regex maybe Albequerue to Z. \n" ] } ], "metadata": {} } ] }