In my career as an aeronautical engineer, I never solved a differential equation by hand on a real project. The specialized software — SAMCEF, ABAQUS, NASTRAN — took care of that. We defined the geometry, the materials, the boundary conditions, and the software calculated the natural frequencies and modes. But understanding what the software does…
In an aeronautical predictive maintenance project, the goal was to predict filter clogging based on current consumption measurements. The idea was simple: as the filter becomes clogged, the pump compensates by consuming more power. By monitoring this consumption, it should be possible to anticipate filter replacement before a failure occurs. In theory, it’s elegant. In…
For years, my go-to tool was Excel. Pivot tables, nested formulas, a bit of VBA whenever things got truly repetitive. It was tedious and fragile – one misnamed file or a moved column, and the whole thing would fall apart. But since everyone around me was doing it, I kept at it. In 2020, I…
In the previous article, we saw how to automatically create a PDF report from 3 test reports. The process works perfectly; you automatically generate: Everything seems perfect. But a few months later, a new problem arises. You have to deal with: And a simple question becomes a nightmare; imagine your manager asking you: “Find all…
We’ve made it! In just six articles, you’ve learned to tame the chaos of files, clean up noisy signals, automate complex calculations, and create interactive dashboards. But for your client, your manager, or your team, work only exists if it’s deliverable. This final step is about value creation. We will learn how to automatically generate…
In the previous episode, we finalized our interactive diagnostic cockpit. It’s a victory: we analyze an engine test with surgical precision. But in real life, the engineer doesn’t process just one test. Imagine this scenario: you return from vacation and a colleague drops off a folder containing 150 CSV files. They need the summary by…
From detection to exploration In the previous article, we took a crucial step: Aggregation. We learned to stop drowning in raw data and instead extract strategic indicators. It was thanks to this method that we unmasked the “traitor” in our test: Cycle 3. Remember, its average of 30.77 seemed perfect, but its peak of 37.02…
The Problem: Synthesizing Big Data In the previous section on Vectorized Computation, we saw how to transform raw signals (torque, rotational speed) into physical quantities (power) at lightning speed. You now have a complete, precise, but… enormous table.Having 200,000 calculation points is a technological victory, but for a test report or design validation, it’s unusable….
The Problem: The “stretched” cell syndrome In the previous article, we saw the power of Python for sorting our data (removing noise). But clean data is just the beginning. The real work of the engineer begins when these noisy readings need to be transformed into physical indicators.In Excel, this often means writing a complex formula…
It’s Monday morning, 9:00 AM and the test bench has been running all weekend. You receive a folder containing 50 CSV files. Your mission? Compile them into a single spreadsheet to identify measurement deviations and generate the summary report for the 11:00 AM meeting. The classic scenario: You open the first file, select the data,…
