Find and prepare metheorological data from the meter location

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

Find and prepare metheorological data from the meter location #2

Closed antonroman closed 3 years ago

antonroman commented 3 years ago

We need to download and prepare weather data from a station as close as possible to the meters. The more interesting variable for us will be the temperature which, according to other papers, is the variable with a highest correlation to the power consumption behind previous load data.

gbarreiro commented 3 years ago

This can be done through the AEMET Open Data platform, where I already have an account created. I'll start working on this right now.

gbarreiro commented 3 years ago

Done! I've created a script that finds the closest AEMET station to our meters and then downloads the daily weather data from 1st May 2019 to 1st April 2021 and stores the highest, lowest and average temperature in a CSV file. Check the "weather_data" folder from the last commit, both the script and the CSV file have been uploaded there.