def populate(json, df, dftype):
json[dftype] = {}
json[dftype]['locations'] = []
tmp_latest = int(df.sum(axis=0)[-1])
for index, row in df.iterrows():
tmp_element = {}
tmp_province = str(row['Province/State'])
tmp_country_name = row['Country/Region']
tmp_country_code = country_code(tmp_country_name)
tmp_country_latest = row[-1]
tmp_country_position = {}
if not math.isnan(row['Lat']):
tmp_country_position['latitude'] = row['Lat']
if not math.isnan(row['Long']):
tmp_country_position['longitude'] = row['Long']
tmp_country_history = {}
for i in range(4, df.shape[1]):
tmp_country_history[list(df.columns.values)[i]] = row[i]
tmp_element['coordinates'] = tmp_country_position
tmp_element['country'] = tmp_country_name
tmp_element['country_code'] = tmp_country_code
tmp_element['history'] = tmp_country_history
tmp_element['latest'] = tmp_country_latest
tmp_element['province'] = tmp_province
json[dftype]['locations'].append(tmp_element)
json[dftype]['latest'] = tmp_latest
return json
def update():
s=requests.get(url_confirmed).content
df_confirmed=pd.read_csv(io.StringIO(s.decode('utf-8')))
s=requests.get(url_deaths).content
df_deaths=pd.read_csv(io.StringIO(s.decode('utf-8')))
s=requests.get(url_recovered).content
df_recovered=pd.read_csv(io.StringIO(s.decode('utf-8')))
json_data_final = {}
json_data_final_countries = {}
#json_data_list = []
json_data_final['confirmed'] = {}
json_data_final['confirmed']['locations'] = []
json_data_final['deaths'] = {}
json_data_final['deaths']['locations'] = []
json_data_final['recovered'] = {}
json_data_final['recovered']['locations'] = []
# Confirmed
tmp_latest_confirmed = int(df_confirmed.sum(axis=0)[-1])
for index, row in df_confirmed.iterrows():
tmp_element = {}
tmp_province = str(row['Province/State'])
tmp_country_name = row['Country/Region']
if(tmp_country_name == 'Brunei'):
tmp_country_name = 'Brunei Darussalam'
elif(tmp_country_name == 'Taiwan*'):
tmp_country_name = 'Taiwan, Province of China'
elif(tmp_country_name == 'Moldova'):
tmp_country_name = 'Moldova, Republic of'
elif(tmp_country_name == 'Venezuala'):
tmp_country_name = 'Venezuela, Bolivarian Republic of'
elif(tmp_country_name == 'Bolivia'):
tmp_country_name = 'Bolivia, Plurinational State of'
elif(tmp_country_name == 'The Bahamas'):
tmp_country_name = 'Bahamas'
elif(tmp_country_name == 'Congo (Kinshasa)' or tmp_country_name == 'Congo (Brazzaville)' ):
tmp_country_name = 'Congo'
elif(tmp_country_name == 'Tanzania'):
tmp_country_name = 'Tanzania, United Republic of'
elif(tmp_country_name == 'Republic of the Congo'):
tmp_country_name = 'Congo, the Democratic Republic of the'
elif(tmp_country_name == "Cote d'Ivoire"):
tmp_country_name = "Côte d'Ivoire"
elif(tmp_country_name == "Holy See"):
tmp_country_name = "Holy See (Vatican City State)"
elif(tmp_country_name == "occupied Palestinian territory"):
tmp_country_name = "Palestine, State of"
tmp_country_code = country_code(tmp_country_name)
tmp_country_latest = row[-1]
tmp_country_position = {}
tmp_country_position['latitude'] = row['Lat']
tmp_country_position['longitude'] = row['Long']
tmp_country_history = {}
for i in range (4,df_confirmed.shape[1]):
tmp_country_history[list(df_confirmed.columns.values)[i]] = row[i]
tmp_element['coordinates'] = tmp_country_position
tmp_element['country'] = tmp_country_name
tmp_element['country_code'] = tmp_country_code
tmp_element['history'] = tmp_country_history
tmp_element['latest'] = tmp_country_latest
tmp_element['province'] = tmp_province
json_data_final['confirmed']['locations'].append(tmp_element)
############
json_data_final_countries[tmp_country_code] = {}
json_data_final_countries[tmp_country_code]['country'] = {}
json_data_final_countries[tmp_country_code]['country']['name'] = tmp_country_name
json_data_final_countries[tmp_country_code]['country']['position'] = tmp_country_position
json_data_final_countries[tmp_country_code]['confirmed'] = {}
json_data_final_countries[tmp_country_code]['confirmed']['history'] = tmp_country_history
json_data_final_countries[tmp_country_code]['confirmed']['latest'] = tmp_country_latest
############
json_data_final['confirmed']['latest'] = tmp_latest_confirmed
# Deaths
tmp_latest_deaths = int(df_deaths.sum(axis=0)[-1])
for index, row in df_deaths.iterrows():
tmp_element = {}
tmp_province = str(row['Province/State'])
tmp_country_name = row['Country/Region']
if(tmp_country_name == 'Brunei'):
tmp_country_name = 'Brunei Darussalam'
elif(tmp_country_name == 'Taiwan*'):
tmp_country_name = 'Taiwan, Province of China'
elif(tmp_country_name == 'Moldova'):
tmp_country_name = 'Moldova, Republic of'
elif(tmp_country_name == 'Venezuala'):
tmp_country_name = 'Venezuela, Bolivarian Republic of'
elif(tmp_country_name == 'Bolivia'):
tmp_country_name = 'Bolivia, Plurinational State of'
elif(tmp_country_name == 'The Bahamas'):
tmp_country_name = 'Bahamas'
elif(tmp_country_name == 'Congo (Kinshasa)' or tmp_country_name == 'Congo (Brazzaville)' ):
tmp_country_name = 'Congo'
elif(tmp_country_name == 'Tanzania'):
tmp_country_name = 'Tanzania, United Republic of'
elif(tmp_country_name == 'Republic of the Congo'):
tmp_country_name = 'Congo, the Democratic Republic of the'
elif(tmp_country_name == "Cote d'Ivoire"):
tmp_country_name = "Côte d'Ivoire"
elif(tmp_country_name == "Holy See"):
tmp_country_name = "Holy See (Vatican City State)"
elif(tmp_country_name == "occupied Palestinian territory"):
tmp_country_name = "Palestine, State of"
tmp_country_code = country_code(tmp_country_name)
tmp_country_latest = row[-1]
tmp_country_position = {}
tmp_country_position['latitude'] = row['Lat']
tmp_country_position['longitude'] = row['Long']
tmp_country_history = {}
for i in range (4,df_deaths.shape[1]):
tmp_country_history[list(df_deaths.columns.values)[i]] = row[i]
tmp_element['coordinates'] = tmp_country_position
tmp_element['country'] = tmp_country_name
tmp_element['country_code'] = tmp_country_code
tmp_element['history'] = tmp_country_history
tmp_element['latest'] = tmp_country_latest
tmp_element['province'] = tmp_province
json_data_final['deaths']['locations'].append(tmp_element)
############
json_data_final_countries[tmp_country_code]['deaths'] = {}
json_data_final_countries[tmp_country_code]['deaths']['history'] = tmp_country_history
json_data_final_countries[tmp_country_code]['deaths']['latest'] = tmp_country_latest
############
json_data_final['deaths']['latest'] = tmp_latest_deaths
# Recovered
tmp_latest_recovered = int(df_recovered.sum(axis=0)[-1])
for index, row in df_recovered.iterrows():
tmp_element = {}
tmp_province = str(row['Province/State'])
tmp_country_name = row['Country/Region']
if(tmp_country_name == 'Brunei'):
tmp_country_name = 'Brunei Darussalam'
elif(tmp_country_name == 'Taiwan*'):
tmp_country_name = 'Taiwan, Province of China'
elif(tmp_country_name == 'Moldova'):
tmp_country_name = 'Moldova, Republic of'
elif(tmp_country_name == 'Venezuala'):
tmp_country_name = 'Venezuela, Bolivarian Republic of'
elif(tmp_country_name == 'Bolivia'):
tmp_country_name = 'Bolivia, Plurinational State of'
elif(tmp_country_name == 'The Bahamas'):
tmp_country_name = 'Bahamas'
elif(tmp_country_name == 'Congo (Kinshasa)' or tmp_country_name == 'Congo (Brazzaville)' ):
tmp_country_name = 'Congo'
elif(tmp_country_name == 'Tanzania'):
tmp_country_name = 'Tanzania, United Republic of'
elif(tmp_country_name == 'Republic of the Congo'):
tmp_country_name = 'Congo, the Democratic Republic of the'
elif(tmp_country_name == "Cote d'Ivoire"):
tmp_country_name = "Côte d'Ivoire"
elif(tmp_country_name == "Holy See"):
tmp_country_name = "Holy See (Vatican City State)"
elif(tmp_country_name == "occupied Palestinian territory"):
tmp_country_name = "Palestine, State of"
tmp_country_code = country_code(tmp_country_name)
tmp_country_latest = row[-1]
tmp_country_position = {}
tmp_country_position['latitude'] = row['Lat']
tmp_country_position['longitude'] = row['Long']
tmp_country_history = {}
for i in range (4,df_recovered.shape[1]):
tmp_country_history[list(df_recovered.columns.values)[i]] = row[i]
tmp_element['coordinates'] = tmp_country_position
tmp_element['country'] = tmp_country_name
tmp_element['country_code'] = tmp_country_code
tmp_element['history'] = tmp_country_history
tmp_element['latest'] = tmp_country_latest
tmp_element['province'] = tmp_province
json_data_final['recovered']['locations'].append(tmp_element)
############
json_data_final_countries[tmp_country_code]['recovered'] = {}
json_data_final_countries[tmp_country_code]['recovered']['history'] = tmp_country_history
json_data_final_countries[tmp_country_code]['recovered']['latest'] = tmp_country_latest
############
json_data_final['recovered']['latest'] = tmp_latest_recovered
# Latest
json_data_final['latest'] = {}
json_data_final['latest']['confirmed'] = tmp_latest_confirmed
json_data_final['latest']['deaths'] = tmp_latest_deaths
json_data_final['latest']['recovered'] = tmp_latest_recovered
with open('data.json', 'w') as f:
json.dump(json_data_final, f)
sys.stdout.flush()
print("Data Updated !")
with open('dataCountry.json', 'w') as f:
json.dump(json_data_final_countries, f)
sys.stdout.flush()
print("Data Updated !")
return 0
def update():
s = requests.get(url_confirmed).content
df_confirmed = pd.read_csv(io.StringIO(s.decode("utf-8")))
s = requests.get(url_deaths).content
df_deaths = pd.read_csv(io.StringIO(s.decode("utf-8")))
s = requests.get(url_recovered).content
df_recovered = pd.read_csv(io.StringIO(s.decode("utf-8")))
json_data_final = {}
# json_data_list = []
json_data_final["confirmed"] = {}
json_data_final["confirmed"]["locations"] = []
json_data_final["deaths"] = {}
json_data_final["deaths"]["locations"] = []
json_data_final["recovered"] = {}
json_data_final["recovered"]["locations"] = []
# Confirmed
tmp_latest_confirmed = int(df_confirmed.sum(axis=0)[-1])
for index, row in df_confirmed.iterrows():
tmp_element = {}
tmp_province = str(row["Province/State"])
tmp_country_name = row["Country/Region"]
if tmp_country_name == "Brunei":
tmp_country_name = "Brunei Darussalam"
elif tmp_country_name == "Taiwan*":
tmp_country_name = "Taiwan, Province of China"
elif tmp_country_name == "Moldova":
tmp_country_name = "Moldova, Republic of"
elif tmp_country_name == "Venezuala":
tmp_country_name = "Venezuela, Bolivarian Republic of"
elif tmp_country_name == "Bolivia":
tmp_country_name = "Bolivia, Plurinational State of"
elif tmp_country_name == "The Bahamas":
tmp_country_name = "Bahamas"
elif (tmp_country_name == "Congo (Kinshasa)"
or tmp_country_name == "Congo (Brazzaville)"):
tmp_country_name = "Congo"
elif tmp_country_name == "Tanzania":
tmp_country_name = "Tanzania, United Republic of"
elif tmp_country_name == "Republic of the Congo":
tmp_country_name = "Congo, the Democratic Republic of the"
elif tmp_country_name == "Cote d'Ivoire":
tmp_country_name = "Côte d'Ivoire"
elif tmp_country_name == "Holy See":
tmp_country_name = "Holy See (Vatican City State)"
elif tmp_country_name == "occupied Palestinian territory":
tmp_country_name = "Palestine, State of"
tmp_country_code = country_code(tmp_country_name)
tmp_country_latest = row[-1]
tmp_country_position = {}
tmp_country_position["latitude"] = row["Lat"]
tmp_country_position["longitude"] = row["Long"]
tmp_country_history = {}
for i in range(4, df_confirmed.shape[1]):
tmp_country_history[list(df_confirmed.columns.values)[i]] = row[i]
tmp_element["coordinates"] = tmp_country_position
tmp_element["country"] = tmp_country_name
tmp_element["country_code"] = tmp_country_code
tmp_element["history"] = tmp_country_history
tmp_element["latest"] = tmp_country_latest
tmp_element["province"] = tmp_province
json_data_final["confirmed"]["locations"].append(tmp_element)
json_data_final["confirmed"]["latest"] = tmp_latest_confirmed
# Deaths
tmp_latest_deaths = int(df_deaths.sum(axis=0)[-1])
for index, row in df_deaths.iterrows():
tmp_element = {}
tmp_province = str(row["Province/State"])
tmp_country_name = row["Country/Region"]
if tmp_country_name == "Brunei":
tmp_country_name = "Brunei Darussalam"
elif tmp_country_name == "Taiwan*":
tmp_country_name = "Taiwan, Province of China"
elif tmp_country_name == "Moldova":
tmp_country_name = "Moldova, Republic of"
elif tmp_country_name == "Venezuala":
tmp_country_name = "Venezuela, Bolivarian Republic of"
elif tmp_country_name == "Bolivia":
tmp_country_name = "Bolivia, Plurinational State of"
elif tmp_country_name == "The Bahamas":
tmp_country_name = "Bahamas"
elif (tmp_country_name == "Congo (Kinshasa)"
or tmp_country_name == "Congo (Brazzaville)"):
tmp_country_name = "Congo"
elif tmp_country_name == "Tanzania":
tmp_country_name = "Tanzania, United Republic of"
elif tmp_country_name == "Republic of the Congo":
tmp_country_name = "Congo, the Democratic Republic of the"
elif tmp_country_name == "Cote d'Ivoire":
tmp_country_name = "Côte d'Ivoire"
elif tmp_country_name == "Holy See":
tmp_country_name = "Holy See (Vatican City State)"
elif tmp_country_name == "occupied Palestinian territory":
tmp_country_name = "Palestine, State of"
tmp_country_code = country_code(tmp_country_name)
tmp_country_latest = row[-1]
tmp_country_position = {}
tmp_country_position["latitude"] = row["Lat"]
tmp_country_position["longitude"] = row["Long"]
tmp_country_history = {}
for i in range(4, df_deaths.shape[1]):
tmp_country_history[list(df_deaths.columns.values)[i]] = row[i]
tmp_element["coordinates"] = tmp_country_position
tmp_element["country"] = tmp_country_name
tmp_element["country_code"] = tmp_country_code
tmp_element["history"] = tmp_country_history
tmp_element["latest"] = tmp_country_latest
tmp_element["province"] = tmp_province
json_data_final["deaths"]["locations"].append(tmp_element)
json_data_final["deaths"]["latest"] = tmp_latest_deaths
# Recovered
tmp_latest_recovered = int(df_recovered.sum(axis=0)[-1])
for index, row in df_recovered.iterrows():
tmp_element = {}
tmp_province = str(row["Province/State"])
tmp_country_name = row["Country/Region"]
if tmp_country_name == "Brunei":
tmp_country_name = "Brunei Darussalam"
elif tmp_country_name == "Taiwan*":
tmp_country_name = "Taiwan, Province of China"
elif tmp_country_name == "Moldova":
tmp_country_name = "Moldova, Republic of"
elif tmp_country_name == "Venezuala":
tmp_country_name = "Venezuela, Bolivarian Republic of"
elif tmp_country_name == "Bolivia":
tmp_country_name = "Bolivia, Plurinational State of"
elif tmp_country_name == "The Bahamas":
tmp_country_name = "Bahamas"
elif (tmp_country_name == "Congo (Kinshasa)"
or tmp_country_name == "Congo (Brazzaville)"):
tmp_country_name = "Congo"
elif tmp_country_name == "Tanzania":
tmp_country_name = "Tanzania, United Republic of"
elif tmp_country_name == "Republic of the Congo":
tmp_country_name = "Congo, the Democratic Republic of the"
elif tmp_country_name == "Cote d'Ivoire":
tmp_country_name = "Côte d'Ivoire"
elif tmp_country_name == "Holy See":
tmp_country_name = "Holy See (Vatican City State)"
elif tmp_country_name == "occupied Palestinian territory":
tmp_country_name = "Palestine, State of"
tmp_country_code = country_code(tmp_country_name)
tmp_country_latest = row[-1]
tmp_country_position = {}
tmp_country_position["latitude"] = row["Lat"]
tmp_country_position["longitude"] = row["Long"]
tmp_country_history = {}
for i in range(4, df_recovered.shape[1]):
tmp_country_history[list(df_recovered.columns.values)[i]] = row[i]
tmp_element["coordinates"] = tmp_country_position
tmp_element["country"] = tmp_country_name
tmp_element["country_code"] = tmp_country_code
tmp_element["history"] = tmp_country_history
tmp_element["latest"] = tmp_country_latest
tmp_element["province"] = tmp_province
json_data_final["recovered"]["locations"].append(tmp_element)
json_data_final["recovered"]["latest"] = tmp_latest_recovered
# Latest
json_data_final["latest"] = {}
json_data_final["latest"]["confirmed"] = tmp_latest_confirmed
json_data_final["latest"]["deaths"] = tmp_latest_deaths
json_data_final["latest"]["recovered"] = tmp_latest_recovered
with open("/var/www/coronaApp/api/data.json", "w") as f:
json.dump(json_data_final, f)
sys.stdout.flush()
print("Data Updated !")
return 0