Characterization of Demand Profiles for Medium-Voltage Substations in Bogotá Using a Python Interface

Abstract

This document presents a comprehensive methodology for analyzing operational demand forecast data from XM’s website using a Python script executed in Google Colaboratory (Colab). The script is designed to process text files containing forecast data, which are compressed in a zip file and uploaded to the Colab environment for processing. The key functions of the script include decompressing and organizing files, filtering data based on specified keywords, calculating average power values, and normalizing these averages. The script is structured into several sections: first, it describes various libraries and functions used, and then it presents a main script that implements these functions. Finally, the obtained vectors are utilized to plot normalized active and reactive curves, facilitating the visualization of demand patterns over a 24-hour period. This provides insights into the operational dynamics of Colombia's National Interconnected System (SIN). The analysis focuses on forecast data from May 2023 to May 2024, which includes both reactive and active power. The integration of this script into the data processing workflow aims to streamline the analysis of XM’s operational demand forecasts, supporting more informed decision-making for energy management and planning. By transforming raw forecast data into actionable insights, this approach improves understanding of demand patterns, contributing to the effective management of Colombia’s energy resources.