Import Data.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"Import Data.ipynb","provenance":[],"collapsed_sections":[],"toc_visible":true,"authorship_tag":"ABX9TyPz4uddkIro6i8W+Rp8jNmE"},"kernelspec":{"name":"python3","display_name":"Python 3"}},"cells":[{"cell_type":"code","metadata":{"id":"piXlMqoHdl5b","colab_type":"code","outputId":"f3ee89aa-1928-412c-f2f3-fde513d1d3fc","executionInfo":{"status":"ok","timestamp":1582444037579,"user_tz":-120,"elapsed":21870,"user":{"displayName":"Ran Kremer","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mB2_ZiPPU7rQBIvIt172EuazLz5955iIqYS5NAMAQ=s64","userId":"05457805718113099013"}},"colab":{"base_uri":"https://localhost:8080/","height":122}},"source":["from google.colab import drive\n","drive.mount('/content/drive')"],"execution_count":0,"outputs":[{"output_type":"stream","text":["Go to this URL in a browser: https://accounts.google.com/o/oauth2/auth?client_id=947318989803-6bn6qk8qdgf4n4g3pfee6491hc0brc4i.apps.googleusercontent.com&redirect_uri=urn%3aietf%3awg%3aoauth%3a2.0%3aoob&response_type=code&scope=email%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdocs.test%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdrive%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdrive.photos.readonly%20https%3a%2f%2fwww.googleapis.com%2fauth%2fpeopleapi.readonly\n","\n","Enter your authorization code:\n","··········\n","Mounted at /content/drive\n"],"name":"stdout"}]},{"cell_type":"markdown","metadata":{"id":"f1S90bdBVIaK","colab_type":"text"},"source":["# CoronaVirus Prediction"]},{"cell_type":"code","metadata":{"id":"qHa4dZtoAV09","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":224},"outputId":"921e72b1-caac-491b-fab9-c26f54c1e411","executionInfo":{"status":"ok","timestamp":1582445342591,"user_tz":-120,"elapsed":1667,"user":{"displayName":"Ran Kremer","photoUrl":"https://lh3.googleusercontent.com/a-/AAuE7mB2_ZiPPU7rQBIvIt172EuazLz5955iIqYS5NAMAQ=s64","userId":"05457805718113099013"}}},"source":["# Get data from Github\n","import numpy as np\n","from math import sqrt\n","from sklearn.metrics import mean_squared_error\n","import pandas as pd\n","#url = 'https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_19-covid-Confirmed.csv'\n","url = 'https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_19-covid-Confirmed.csv'\n","confirmed = pd.read_csv(url, error_bad_lines=False)\n","url = 'https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_19-covid-Deaths.csv'\n","death = pd.read_csv(url, error_bad_lines=False)\n","url = 'https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_19-covid-Recovered.csv'\n","recover = pd.read_csv(url, error_bad_lines=False)\n","\n","# fix region names\n","confirmed['Country/Region']= confirmed['Country/Region'].str.replace(\"Mainland China\", \"China\")\n","confirmed['Country/Region']= confirmed['Country/Region'].str.replace(\"US\", \"Unites States\")\n","death['Country/Region']= death['Country/Region'].str.replace(\"Mainland China\", \"China\")\n","death['Country/Region']= death['Country/Region'].str.replace(\"US\", \"Unites States\")\n","recover['Country/Region']= recover['Country/Region'].str.replace(\"Mainland China\", \"China\")\n","recover['Country/Region']= recover['Country/Region'].str.replace(\"US\", \"Unites States\")\n","confirmed.iloc[:5,:]"],"execution_count":1,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>Province/State</th>\n","      <th>Country/Region</th>\n","      <th>Lat</th>\n","      <th>Long</th>\n","      <th>1/22/20</th>\n","      <th>1/23/20</th>\n","      <th>1/24/20</th>\n","      <th>1/25/20</th>\n","      <th>1/26/20</th>\n","      <th>1/27/20</th>\n","      <th>1/28/20</th>\n","      <th>1/29/20</th>\n","      <th>1/30/20</th>\n","      <th>1/31/20</th>\n","      <th>2/1/20</th>\n","      <th>2/2/20</th>\n","      <th>2/3/20</th>\n","      <th>2/4/20</th>\n","      <th>2/5/20</th>\n","      <th>2/6/20</th>\n","      <th>2/7/20</th>\n","      <th>2/8/20</th>\n","      <th>2/9/20</th>\n","      <th>2/10/20</th>\n","      <th>2/11/20</th>\n","      <th>2/12/20</th>\n","      <th>2/13/20</th>\n","      <th>2/14/20</th>\n","      <th>2/15/20</th>\n","      <th>2/16/20</th>\n","      <th>2/17/20</th>\n","      <th>2/18/20</th>\n","      <th>2/19/20</th>\n","      <th>2/20/20</th>\n","      <th>2/21/20</th>\n","      <th>2/22/20</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Anhui</td>\n","      <td>China</td>\n","      <td>31.82571</td>\n","      <td>117.2264</td>\n","      <td>1</td>\n","      <td>9</td>\n","      <td>15</td>\n","      <td>39</td>\n","      <td>60</td>\n","      <td>70</td>\n","      <td>106</td>\n","      <td>152</td>\n","      <td>200</td>\n","      <td>237</td>\n","      <td>297</td>\n","      <td>340</td>\n","      <td>408</td>\n","      <td>480</td>\n","      <td>530</td>\n","      <td>591</td>\n","      <td>665</td>\n","      <td>733</td>\n","      <td>779</td>\n","      <td>830</td>\n","      <td>860</td>\n","      <td>889</td>\n","      <td>910</td>\n","      <td>934</td>\n","      <td>950</td>\n","      <td>962</td>\n","      <td>973</td>\n","      <td>982</td>\n","      <td>986</td>\n","      <td>987</td>\n","      <td>988</td>\n","      <td>989</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Beijing</td>\n","      <td>China</td>\n","      <td>40.18238</td>\n","      <td>116.4142</td>\n","      <td>14</td>\n","      <td>22</td>\n","      <td>36</td>\n","      <td>41</td>\n","      <td>68</td>\n","      <td>80</td>\n","      <td>91</td>\n","      <td>111</td>\n","      <td>114</td>\n","      <td>139</td>\n","      <td>168</td>\n","      <td>191</td>\n","      <td>212</td>\n","      <td>228</td>\n","      <td>253</td>\n","      <td>274</td>\n","      <td>297</td>\n","      <td>315</td>\n","      <td>326</td>\n","      <td>337</td>\n","      <td>342</td>\n","      <td>352</td>\n","      <td>366</td>\n","      <td>372</td>\n","      <td>375</td>\n","      <td>380</td>\n","      <td>381</td>\n","      <td>387</td>\n","      <td>393</td>\n","      <td>395</td>\n","      <td>396</td>\n","      <td>399</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>Chongqing</td>\n","      <td>China</td>\n","      <td>30.05718</td>\n","      <td>107.8740</td>\n","      <td>6</td>\n","      <td>9</td>\n","      <td>27</td>\n","      <td>57</td>\n","      <td>75</td>\n","      <td>110</td>\n","      <td>132</td>\n","      <td>147</td>\n","      <td>182</td>\n","      <td>211</td>\n","      <td>247</td>\n","      <td>300</td>\n","      <td>337</td>\n","      <td>366</td>\n","      <td>389</td>\n","      <td>411</td>\n","      <td>426</td>\n","      <td>428</td>\n","      <td>468</td>\n","      <td>486</td>\n","      <td>505</td>\n","      <td>518</td>\n","      <td>529</td>\n","      <td>537</td>\n","      <td>544</td>\n","      <td>551</td>\n","      <td>553</td>\n","      <td>555</td>\n","      <td>560</td>\n","      <td>567</td>\n","      <td>572</td>\n","      <td>573</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Fujian</td>\n","      <td>China</td>\n","      <td>26.07783</td>\n","      <td>117.9895</td>\n","      <td>1</td>\n","      <td>5</td>\n","      <td>10</td>\n","      <td>18</td>\n","      <td>35</td>\n","      <td>59</td>\n","      <td>80</td>\n","      <td>84</td>\n","      <td>101</td>\n","      <td>120</td>\n","      <td>144</td>\n","      <td>159</td>\n","      <td>179</td>\n","      <td>194</td>\n","      <td>205</td>\n","      <td>215</td>\n","      <td>224</td>\n","      <td>239</td>\n","      <td>250</td>\n","      <td>261</td>\n","      <td>267</td>\n","      <td>272</td>\n","      <td>279</td>\n","      <td>281</td>\n","      <td>285</td>\n","      <td>287</td>\n","      <td>290</td>\n","      <td>292</td>\n","      <td>293</td>\n","      <td>293</td>\n","      <td>293</td>\n","      <td>293</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Gansu</td>\n","      <td>China</td>\n","      <td>36.06110</td>\n","      <td>103.8343</td>\n","      <td>0</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>4</td>\n","      <td>7</td>\n","      <td>14</td>\n","      <td>19</td>\n","      <td>24</td>\n","      <td>26</td>\n","      <td>29</td>\n","      <td>40</td>\n","      <td>51</td>\n","      <td>55</td>\n","      <td>57</td>\n","      <td>62</td>\n","      <td>62</td>\n","      <td>67</td>\n","      <td>79</td>\n","      <td>83</td>\n","      <td>83</td>\n","      <td>86</td>\n","      <td>87</td>\n","      <td>90</td>\n","      <td>90</td>\n","      <td>90</td>\n","      <td>90</td>\n","      <td>91</td>\n","      <td>91</td>\n","      <td>91</td>\n","      <td>91</td>\n","      <td>91</td>\n","      <td>91</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["  Province/State Country/Region       Lat  ...  2/20/20  2/21/20  2/22/20\n","0          Anhui          China  31.82571  ...      987      988      989\n","1        Beijing          China  40.18238  ...      395      396      399\n","2      Chongqing          China  30.05718  ...      567      572      573\n","3         Fujian          China  26.07783  ...      293      293      293\n","4          Gansu          China  36.06110  ...       91       91       91\n","\n","[5 rows x 36 columns]"]},"metadata":{"tags":[]},"execution_count":1}]},{"cell_type":"code","metadata":{"id":"hSdScotoF5IO","colab_type":"code","colab":{}},"source":[""],"execution_count":0,"outputs":[]}]}