jeimmyvalderrama/proyectoebsa ? reverse-engineered prompt

Build me a project for EBSA that analyzes customer electricity consumption and turns it into something usable month by month.

I want a pipeline that reads the monthly TC2 files and the file of customers served by other commercializers, keeps the raw source files untouched, and produces three things for the business. One should flag customers whose consumption is falling, estimate how much that loss is worth, and predict whether they keep dropping or recover next month. Another should forecast each customer’s consumption for the next 6 months. The last should rank customers most likely to leave for another commercializer in the next 6 months, and show who already left.

Please include a simple way to run the whole monthly process at once, plus a small web page to review the results. Use the glossary labels and business names in the outputs, and make sure the workflow can also show the results by consumption group. If you need to check current docs or package details online, do that.