convert_data.py

import csv
import json

data = {}
final = []
csvFilePath = 'h2_prod_ok.csv'
jsonFilePath = 'h2_prod_anomalies.json'

fieldnames = ('Series', 'Time', 'Value')

with open(csvFilePath) as csvFile:
    csvReader = csv.DictReader(csvFile, fieldnames, delimiter=';')
    for row in csvReader:
        # leave only every minute
        if '00+03:00' in row['Time']:
            digit = row['Value'].split('.', 1)[0]
            data = {'timestamp': row['Time'], 'value': digit}
            # print(row['Value'])
            final.append(data)
        
print(json.dumps(final))

# convert csv into json for anomaly detecttion
# json_data = '{"maxAnomalyRatio": 0.45, "granularity": "minutely", "sensitivity": 90, "series": ' + json.dumps(final) + '}'