-
Notifications
You must be signed in to change notification settings - Fork 0
/
app.py
42 lines (33 loc) · 1.22 KB
/
app.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
from flask import Flask, jsonify, render_template
import requests
import pandas as pd
import os
import urllib
app = Flask(__name__)
@app.route('/updatedata')
def update():
temp_df = pd.read_csv('https://raw.githubusercontent.com/owid/covid-19-data/master/public/data/owid-covid-data.csv')
temp_df.to_csv('data.csv', index=False)
global df
df = temp_df
return {'msg': 'Data updated'}
if not os.path.exists('data.csv'):
update()
df = pd.read_csv('data.csv')
@app.route('/', defaults={'path':''})
@app.route('/<path:path>')
def index(path):
return render_template("index.html")
@app.route('/locations')
def locations():
return pd.DataFrame(df.loc[:,'location'].unique()).to_json(orient='values')
@app.route('/data/<string:location>/<string:datemonth>')
def country_data(location, datemonth):
# Fix encoded string issue for country names with spaces
location = urllib.parse.unquote(location)
print(datemonth)
months = datemonth.split(',')
print(months)
return df.loc[(df['location']==location) & (df['date'].str.slice(0,7)>=months[0]) & (df['date'].str.slice(0,7)<=months[1])].loc[:,['date','total_cases','new_cases','total_deaths','new_deaths']].to_json(orient = 'values')
if __name__== "__main__":
app.run(debug=True)