KAMP Rotor Vibration Data Migration

Last updated on 


Introducing the KAMP Rotor Vibration Data Migration

1. Check raw data

There are eight CSV files as shown below.

2. Set the Preprocessing Plan

  • Combine the data files.
    • Load the data files.
    • Convert to the format: Name, Time, Value.
  • Convert to UTC time.

Combine the data files

Load the CSV files from the directory, convert them to the format Name, Time, Value, and then merge the 8 transformed DataFrames into one.

Convert to UTC time

Change the time values based on UTC.

Once the data frame is restructured as shown in the image below, it will be ready for upload to Machbase Neo.

3. Data Upload

Finally, the data can be uploaded to Machbase Neo using the command below.

machbase-neo shell import --input ./datahub-2024-2-rotor.csv.gz --compress gzip --header --method append --timeformat ns rotor

Check the entire code.

datahub/dataset/2024/02.Rotor Vibration/conv/convert.py at main · machbase/datahub
All Industrial IoT DataHub with data visualization and AI source - machbase/datahub
GitHubmachbase

4. Check the results after uploading

Output when executing the following code in the Machbase Neo internal shell.

select * from v$rotor_stat;

※ Subsequent link to the AI training process: KAMP Rotor Vibration Data

Back to Top