{"cells":[{"metadata":{"trusted":true},"cell_type":"code","source":"import pandas as pd\n\ndf0 = pd.read_csv(\"https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_daily_reports/03-24-2020.csv\");\n\n\n","execution_count":3,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"df=df0.loc[(df0['Province_State'] == 'Washington')]\ndfs=df[['Admin2','Confirmed','Deaths']]\ndfs=dfs.rename(columns={\"Admin2\": \"County\"})\ndfs","execution_count":4,"outputs":[{"output_type":"execute_result","execution_count":4,"data":{"text/plain":" County Confirmed Deaths\n18 Adams 1 0\n94 Asotin 0 0\n188 Benton 9 3\n468 Chelan 6 0\n516 Clallam 4 0\n530 Clark 13 4\n611 Columbia 1 0\n649 Cowlitz 3 0\n816 Douglas 1 0\n927 Ferry 0 0\n980 Franklin 5 0\n1018 Garfield 0 0\n1093 Grant 23 1\n1101 Grays Harbor 1 0\n1357 Island 25 1\n1423 Jefferson 8 0\n1506 King 1170 87\n1520 Kitsap 18 0\n1521 Kittitas 5 0\n1525 Klickitat 4 0\n1652 Lewis 2 0\n1684 Lincoln 1 0\n1836 Mason 1 0\n2126 Okanogan 0 0\n2190 Pacific 0 0\n2221 Pend Oreille 0 0\n2265 Pierce 138 1\n2515 San Juan 1 0\n2625 Skagit 45 1\n2627 Skamania 0 0\n2634 Snohomish 614 16\n2651 Spokane 29 0\n2705 Stevens 1 0\n2797 Thurston 11 0\n2875 Unassigned 112 0\n2936 Wahkiakum 0 0\n2943 Walla Walla 1 0\n3057 Whatcom 48 2\n3073 Whitman 2 0\n3143 Yakima 25 0","text/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
CountyConfirmedDeaths
18Adams10
94Asotin00
188Benton93
468Chelan60
516Clallam40
530Clark134
611Columbia10
649Cowlitz30
816Douglas10
927Ferry00
980Franklin50
1018Garfield00
1093Grant231
1101Grays Harbor10
1357Island251
1423Jefferson80
1506King117087
1520Kitsap180
1521Kittitas50
1525Klickitat40
1652Lewis20
1684Lincoln10
1836Mason10
2126Okanogan00
2190Pacific00
2221Pend Oreille00
2265Pierce1381
2515San Juan10
2625Skagit451
2627Skamania00
2634Snohomish61416
2651Spokane290
2705Stevens10
2797Thurston110
2875Unassigned1120
2936Wahkiakum00
2943Walla Walla10
3057Whatcom482
3073Whitman20
3143Yakima250
\n
"},"metadata":{}}]},{"metadata":{"trusted":true},"cell_type":"code","source":"dfs.to_json(orient='split')","execution_count":5,"outputs":[{"output_type":"execute_result","execution_count":5,"data":{"text/plain":"'{\"columns\":[\"County\",\"Confirmed\",\"Deaths\"],\"index\":[18,94,188,468,516,530,611,649,816,927,980,1018,1093,1101,1357,1423,1506,1520,1521,1525,1652,1684,1836,2126,2190,2221,2265,2515,2625,2627,2634,2651,2705,2797,2875,2936,2943,3057,3073,3143],\"data\":[[\"Adams\",1,0],[\"Asotin\",0,0],[\"Benton\",9,3],[\"Chelan\",6,0],[\"Clallam\",4,0],[\"Clark\",13,4],[\"Columbia\",1,0],[\"Cowlitz\",3,0],[\"Douglas\",1,0],[\"Ferry\",0,0],[\"Franklin\",5,0],[\"Garfield\",0,0],[\"Grant\",23,1],[\"Grays Harbor\",1,0],[\"Island\",25,1],[\"Jefferson\",8,0],[\"King\",1170,87],[\"Kitsap\",18,0],[\"Kittitas\",5,0],[\"Klickitat\",4,0],[\"Lewis\",2,0],[\"Lincoln\",1,0],[\"Mason\",1,0],[\"Okanogan\",0,0],[\"Pacific\",0,0],[\"Pend Oreille\",0,0],[\"Pierce\",138,1],[\"San Juan\",1,0],[\"Skagit\",45,1],[\"Skamania\",0,0],[\"Snohomish\",614,16],[\"Spokane\",29,0],[\"Stevens\",1,0],[\"Thurston\",11,0],[\"Unassigned\",112,0],[\"Wahkiakum\",0,0],[\"Walla Walla\",1,0],[\"Whatcom\",48,2],[\"Whitman\",2,0],[\"Yakima\",25,0]]}'"},"metadata":{}}]},{"metadata":{"trusted":false},"cell_type":"code","source":"","execution_count":null,"outputs":[]}],"metadata":{"kernelspec":{"name":"python3","display_name":"Python 3","language":"python"},"language_info":{"name":"python","version":"3.7.6","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"}},"nbformat":4,"nbformat_minor":4}