"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"