Rotating Shaft Vibration Data Migration



Introducing the Rotating Shaft Vibration Data Migration

1. Check raw data

8 files in the same format as the image below.

2. Set the Preprocessing Plan

  • Remove data with mismatched sample rates.
  • Add an unbalance factor column.
  • Modified Data.
  • Convert to the format: Name, Time, Value & Convert to UTC time.

Remove data with mismatched sample rates

Add an unbalance factor column

Modified Data

Convert to the format: Name, Time, Value & Convert to UTC time

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-08-vibration_unbalance.csv.gz --compress gzip --header --method append --timeformat ns vibe_unbal

Check the entire code.

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

4. Check the results after uploading

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

select * from v$vibe_unbal_stat;

※ Subsequent link to the AI training process: Rotating Shaft Vibration Data

Back to Top