{"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 | County | \nConfirmed | \nDeaths | \n
---|---|---|---|
18 | \nAdams | \n1 | \n0 | \n
94 | \nAsotin | \n0 | \n0 | \n
188 | \nBenton | \n9 | \n3 | \n
468 | \nChelan | \n6 | \n0 | \n
516 | \nClallam | \n4 | \n0 | \n
530 | \nClark | \n13 | \n4 | \n
611 | \nColumbia | \n1 | \n0 | \n
649 | \nCowlitz | \n3 | \n0 | \n
816 | \nDouglas | \n1 | \n0 | \n
927 | \nFerry | \n0 | \n0 | \n
980 | \nFranklin | \n5 | \n0 | \n
1018 | \nGarfield | \n0 | \n0 | \n
1093 | \nGrant | \n23 | \n1 | \n
1101 | \nGrays Harbor | \n1 | \n0 | \n
1357 | \nIsland | \n25 | \n1 | \n
1423 | \nJefferson | \n8 | \n0 | \n
1506 | \nKing | \n1170 | \n87 | \n
1520 | \nKitsap | \n18 | \n0 | \n
1521 | \nKittitas | \n5 | \n0 | \n
1525 | \nKlickitat | \n4 | \n0 | \n
1652 | \nLewis | \n2 | \n0 | \n
1684 | \nLincoln | \n1 | \n0 | \n
1836 | \nMason | \n1 | \n0 | \n
2126 | \nOkanogan | \n0 | \n0 | \n
2190 | \nPacific | \n0 | \n0 | \n
2221 | \nPend Oreille | \n0 | \n0 | \n
2265 | \nPierce | \n138 | \n1 | \n
2515 | \nSan Juan | \n1 | \n0 | \n
2625 | \nSkagit | \n45 | \n1 | \n
2627 | \nSkamania | \n0 | \n0 | \n
2634 | \nSnohomish | \n614 | \n16 | \n
2651 | \nSpokane | \n29 | \n0 | \n
2705 | \nStevens | \n1 | \n0 | \n
2797 | \nThurston | \n11 | \n0 | \n
2875 | \nUnassigned | \n112 | \n0 | \n
2936 | \nWahkiakum | \n0 | \n0 | \n
2943 | \nWalla Walla | \n1 | \n0 | \n
3057 | \nWhatcom | \n48 | \n2 | \n
3073 | \nWhitman | \n2 | \n0 | \n
3143 | \nYakima | \n25 | \n0 | \n