Data Utilization Guide for Engineers: From CSV Export to Python Analysis

Data Utilization Guide for Engineers: From CSV Export to Python Analysis

"The Data belongs to you." Supporting Free and Flexible Analysis.

Is it possible to freely analyze and utilize vibration data from conanair using Python or in-house systems?

[Conclusion] Yes, it is completely possible. conanair is designed with an open-data philosophy, ensuring vibration data is never black-boxed. Raw acceleration data (96,000 points per measurement) can be exported as CSV, and trend CSV files for long-term monitoring are automatically generated. This allows engineers to easily perform custom FFT analysis with Python or integrate the data into existing in-house maintenance systems and AI training models.

Technical & Selection Guide: Resolving Field Doubts and Concerns

conanair insists on an open specification that allows engineers to freely utilize acquired vibration data, without black-boxing it.
Here, we introduce the conanair data flow and analysis examples using the included trend data (CSV).


1. conanair Data Flow (Mechanism)

conanair acquires 10 seconds of vibration data per measurement and saves it as a proprietary compressed file (.cna).
This .cna file contains 96,000 points of raw acceleration data, which can be converted to "waveform data" in CSV format using the included app.


[Automatic Mode & Trend Data]
In Automatic Mode, measurement data (.cna) is automatically sent to the PC, and "Trend Data (CSV)" required for trend management is automatically generated and appended simultaneously.

This means engineers can visualize "equipment health" in Excel or Python immediately without tedious data organization.


2. Content of Trend Data (CSV)

The automatically generated trend CSV (e.g., conanair-1.csv) records key parameters in time series as follows:


Tag, MeasureTime, VelRms3D, HAccPk3D, Dev_Tmp ...

conanair-1, 2022/06/09 10:38:59, 0.243, 1.680, 25.5

conanair-1, 2022/06/09 10:40:00, 0.247, 1.039, 25.7

conanair-1, 2022/06/09 10:40:59, 0.246, 0.892, 25.8

...

*VelRms3D: Velocity RMS (The most common management indicator showing vibration energy amount).


3. Plotting Trend Graphs with Python

By reading the accumulated CSV data with Python, you can instantly create "Vibration Trend Graphs" like the one below.


A line graph generated using Python's matplotlib library, showing the time-series trend of Velocity RMS (vibration energy) based on conanair's trend data (CSV).


Below is the sample Python code to plot this graph.


import pandas as pd
import matplotlib.pyplot as plt
# 1. Load Trend CSVdf = pd.read_csv('conanair-1.csv')
df['MeasureTime'] = pd.to_datetime(df['MeasureTime'])
# 2. Plot Graph (Velocity RMS Trend)plt.figure(figsize=(10, 6))
plt.plot(df['MeasureTime'], df['VelRms3D'], marker='o', label='Velocity RMS (3D)')
plt.title('Vibration Trend')
plt.xlabel('Date/Time')
plt.ylabel('Velocity RMS (mm/s)')
plt.grid(True)
plt.legend()
plt.show()

4. Advanced AI Analysis and System Integration via Raw CSV

Going beyond simple trend management, combining the 96,000-point raw waveform data with Python's data science libraries (such as SciPy and TensorFlow) allows you to build custom frequency analysis (FFT) tools and machine learning AI models that learn the unique failure patterns of your equipment.
Furthermore, the universal CSV format ensures seamless integration with existing production management systems and BI tools (e.g., Tableau, Looker Studio). By providing an open data foundation that can be freely expanded by engineers without being tied to expensive proprietary software, conanair enables true predictive maintenance DX while completely avoiding vendor lock-in.


As shown, conanair prioritizes "returning data to the hands of engineers." It is ideal for integration into in-house maintenance systems or as training data for AI predictive maintenance.


30-Day Free Trial & Inquiry

Try conanair for free for 30 days. Here is what our users are saying:
  • Easy installation for immediate use
  • No app required; operate via web browser
  • No cloud required for fully automatic measurement
  • Affordable, including dedicated software
Free Trial
Try equipment anomaly detection and predictive maintenance for free. Please feel free to contact us.

30-Day Free Trial & Inquiry

Try conanair for free for 30 days. Here is what our users are saying:
  • Easy installation for immediate use
  • No app required; operate via web browser
  • No cloud required for fully automatic measurement
  • Affordable, including dedicated software
Try equipment anomaly detection and predictive maintenance for free. Please feel free to contact us. Free Trial

 

Please contact NSXe for any issues regarding facility maintenance

Company Name NSXe Co.Ltd - Nakayama Hydrothermal Industry Co., Ltd.
Head Office 7686-10 Hirano-cho, Suzuka, Mie513-0835, Japan zip code 513-0835
Phone +81-90-2189-1398
FAX +81-59-379-4704
Business Hours 8:00~17:00
Office Regular
Holiday
Saturday afternoons, Sundays and public holidays
URL https://conanair.com/

Please contact NSXe for any issues regarding facility maintenance

Company Name NSXe Co.Ltd - Nakayama Hydrothermal Industry Co., Ltd.
Head Office 7686-10 Hirano-cho, Suzuka, Mie513-0835, Japan zip code 513-0835
TEL +81-90-2189-1398
FAX +81-59-379-4704
Business Hours 8:00~17:00
Office Regular
Holiday
Saturday afternoons, Sundays and public holidays
URL https://conanair.com/