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.

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()


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 Conan Air 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 Conan Air 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/