dailylog 4-06-20

Our main project today is Colin. Our second main project is PROJECT_COVID19.

PROJECT_COVID19:

1. Dashboard
   1. DONE WHEN: I can send to Keith
2. Kaggle
   1. DONE WHEN: Submitted
3. Data
   1. WHO
      1. DONE WHEN: Old sitreps are posted as csvs on github
   2. Worldometer
      1. Past Worldometer
      2. DONE WHEN: Past days are posted on github
   3. Johns Hopkins
      1. DONE WHEN: Past days are posted as csvs on github

SUBMITTING TO KAGGLE USING THE DATA THAT ALREADY EXISTS (aka how to get a RMSE of 0.0)

import pandas as pd
sub = pd.read_csv('WK3_0406/submission.csv')
test = pd.read_csv('WK3_0406/test.csv')
train = pd.read_csv('WK3_0406/train.csv')

merged = pd.merge(test, train, on=["Province_State","Country_Region", "Date"], how="left")
m = pd.DataFrame(merged.groupby(['ForecastId'])['ConfirmedCases', 'Fatalities'].sum())
m.reset_index(inplace=True)
sub = m.copy()
sub.to_csv("submission.csv", index=False)

DAILY PULL ON WORLDOMETER

GITHUB GISTS