Application of Python and Node-Red in Energy Data Collection and Enterprise Energy Management in Vehicle Manufacturing Factories
Faced with increasingly strict energy-saving and environmental protection standards,automobile manufacturing enterprises must finely monitor the energy consumption of production equipment.Taking the Beijing Benz Shunyi factory as an example,an automatic energy consumption data collection and uploading system based on Python and Node-Red is demonstrated.The system first uses Node-Red to obtain real-time electricity and gas consumption data of various equipment PLCs in the workshop and stores it in the database.Secondly,the data is integrated and stored in Excel through Python.Finally,after calculating the energy consumption difference in the past 2 days,it is uploaded to the enterprise energy forum.If there are any abnormalities in data extraction or upload,the system will automatically send an email to remind the user.At present,the system has been successfully applied to automatically obtain and upload electrical energy data in the painting workshop and final assembly workshop,and the monitored data types will also be expanded to include various energy consumption such as water consumption,steam consumption,and compressed gas consumption.Through this approach,automobile manufacturing companies can more effectively meet energy conservation and environmental protection requirements,contributing to sustainable development.In addition,the application of this system further highlights the crucial role of Python and Node-Red in energy management,providing new perspectives and tools for energy management in the automotive manufacturing industry.