# <span style="background-color:#fbbb43;color:white">Data preparation</span> 
This flow zone is dedicated to prepare the data to have a model-ready dataset.
![data_preparation_zone.png](af7D9B1f2XKE)
In the [data preparation](flow_zone:o6qBXmX) zone, we:
 1. Stack and prepare the data from the 3 factories:
- Dates preparation and components extraction will need to be updated according to your own input data
- Filtering rows where electricity consumption is negative
 
 2. Aggregate 2 meters in Evry. This last step shows how you can create a 'soft sensor' meter that aggregates consumptions from different meters.
 
 3. Restack the data to have a finalized dataset with all the consumptions from the 3 factories (Dates information, electricity consumption, site and meter name).

![DailyConsumptionRestacked.png](iqNYIQ7PO0Vs)


