Updated for imported data format

[covid19.git] / data_import.py

diff --git a/data_import.py b/data_import.py
index 20593c7219c8ebb614626b4f3a297bd8d38323f8..df35ce6cb0da2b002afe04da9ed906739ff5db92 100644 (file)
--- a/data_import.py
+++ b/data_import.py
@@ -64,11 +64,24 @@ raw_data.fillna(0, inplace=True)
 
 
 # %%
+COUNTRIES_ALL
+
+# %%
+# raw_data.rename(columns={'dateRep':'report_date', 'geoId': 'geo_id',
+#                         'countriesAndTerritories': 'country_name',
+#                         'countryterritoryCode': 'country_territory_code',
+#                         'popData2019': 'population_2019',
+#                         'continentExp': 'continent'}, inplace=True)
 raw_data.rename(columns={'dateRep':'report_date', 'geoId': 'geo_id',
                         'countriesAndTerritories': 'country_name',
                         'countryterritoryCode': 'country_territory_code',
+                        'cases': 'cases_weekly',
+                        'deaths': 'deaths_weekly',
                         'popData2019': 'population_2019',
-                        'continentExp': 'continent'}, inplace=True)
+                        'continentExp': 'continent',
+                        'Cumulative_number_for_14_days_of_COVID-19_cases_per_100000': 'notification_rate_per_100000_population_14-days'
+                        }, 
+                inplace=True)
 
 
 # %%