Automation of Energy Management Analysis in Automotive Engineering with Python
Resumo
This paper presents the development and implementation of an automated application for the analysis of Energy Management tests in the automotive industry, using Python as the primary tool. The application automates the processing of data acquired from various test types, including Coast Down, Parasitic Losses, Full Load, Acceleration Metrics, and Fuel Consumption. By transforming data into dataframes and utilizing Python functions, the application achieves a significant reduction in the time required for data analysis, surpassing traditional methods reliant on Excel spreadsheets. The automation improves efficiency and enhances the precision of engineering calculations, making the process more dynamic and less prone to human errors. The results demonstrate a reduction of over 70% in data analysis time, with the potential for further improvements as all engineering calculations are fully transitioned to Python. This approach offers a competitive advantage for automotive companies, optimizing their processes and accelerating product development.
Referências
D. Wetzel, A. Reindl, H. Meier, M. Niemetz and M. Farmbauer, "A Customized Python Interface for Windows OS for a Low Budget USB-to-CAN-Adapter," 2022 International Conference on Electrical, Computer and Energy Technologies (ICECET), Prague, Czech Republic, 2022, pp. 1-5, DOI: 10.1109/ICECET55527.2022.9872574.
G. Andria, F. Attivissimo, A. Di Nisio, A. M. L. Lanzolla, and A. Pellegrino, "Development of an automotive data acquisition platform for analysis of driving behavior," Measurement, vol. 93, pp. 278-287, 2016. DOI: 10.1016/j.measurement.2016.07.035.
TDMS File Format Internal Structure National Instruments, 21 de setembro de 2022. Available: [link].
INCA V7.5 | Getting Started R01 EN | 03.2024," ETAS GmbH, 2024.
DATA SHEET catman: Universal data acquisition and analysis software," Hottinger Brüel & Kjaer GmbH, Darmstadt, Germany, Jul. 7, 2023
A. Reeve, npTDMS, stable version. Available: [link].
A. Rateau, "mdfreader: A library for reading MDF (Measurement Data Format) files, version 0.1.8," PyPI, Sep. 16, 2017. Available: [link].
MDF Big Data Support," ETAS GmbH, versão V0.5 R01 EN, Stuttgart, Germany, Nov. 2020.
L. Bohmann and H. Line, APReader, versão 1.1.2, Zenodo, 2024. DOI: 10.5281/zenodo.8369804. Available: [link].
A. Ronacher, Flask, versão 2.0.1, 21 de maio de 2021. Available: [link].
M. S. Bonney, M. de Angelis, M. Dal Borgo, L. Andrade, S. Beregi, N. Jamia, and D. J. Wagg, "Development of a digital twin operational platform using Python Flask" Data-Centric Engineering, vol. 3, p. e1, Jan. 2022. DOI: 10.1017/dce.2022.1.
P. Paigude, V. Gajul, J. Mishra, e S. Katkar, "Software Integration Test Report Analysis Automation Using Python" in Proceedings of the 2021 Asian Conference on Innovation in Technology (ASIANCON), PUNE, India, 27-29 August 2021, ISBN:978-1-7281-8402-9. DOI: 10.1109/ASIANCON51346.2021.9544984.