"name": "all",
"cnt": len(df_filtered)
})
df_db = pd.DataFrame(result,
columns=[
"region", "lon", "lat", "date",
"absolute_value", "reference_value",
"score_value", "name", "cnt"
])
q = """
INSERT INTO scores (ags) VALUES (%s)
"""
data = [("01234345", )]
db_aws.execute_many(q, data)
print(len(df_db))
with open(os.path.join(summary_path, date_string + ".json"),
"w+") as f:
json.dump(summary, f, indent=2)
break
except:
pass
# UPLOAD JSON TO AMAZON
j = json.loads(df.to_json(orient="records"))
client_s3 = boto3.client("s3" #region_name="eu-central-1"
