search

antonroman / smart_meter_data_analysis

This repository contains all the code developed to analyze the smart meter data with HTM and LSTM
2 stars 0 forks source link

Generate S04 files from the original JSON files #8

Closed antonroman closed 3 years ago

antonroman commented 3 years ago

The JSON meter files also include the S04 values. We should generate files as we did for S02 and S05.

S04: this report provides monthly power consumption information. It includes both the Absolute value (the absolute energy reading the meter is showing at the moment of the report generation) as well as the incremental value since the last S04 was issued (usually 1 month, but there are exceptions). Values are in kWh.

Thanks!

gbarreiro commented 3 years ago

In the following sample from the S04 records from a random meter, what do "Fx" and "Mx" mean?:

Screen Shot 2021-06-04 at 15 53 19

gbarreiro commented 3 years ago

Regarding the "Pt" field, with the S02 and S05 records we were querying only the records with "Pt=0". In the S04 records, I've noticed that for each date, the row with Pt=0 is the sum of the rows with Pt≠0, but with a small error, as you can see below: Screen Shot 2021-06-04 at 16 08 27 Should I take only the rows with Pt=0, as we were doing with S02 and S05?

gbarreiro commented 3 years ago

Done! Now the extract_reactive_values.py script extracts also the S04 values.