Jeju Island Wind Power Plant Data Migration



Introducing the Jeju Island Wind Power Plant Data Migration

1. Check raw data

Power generation data and weather data are separately available as shown below.
Each dataset was pre-merged into a single DataFrame separately.

2. Set the Preprocessing Plan

Merge the datasets after preprocessing each one.

  • Convert to the format: Name, Time, Value.
  • Convert to UTC time.

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-4-wind_elec_gen_1.csv.gz --compress gzip --header --method append --timeformat ns wind_elec_gen
machbase-neo shell import --input ./datahub-2024-4-wind_elec_gen_2.csv.gz --compress gzip --header --method append --timeformat ns wind_elec_gen

Check the entire code.

datahub/dataset/2024/04.Wind Electricity Generation/conv 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$wind_elec_gen_stat;

※ Subsequent link to the AI training process: Jeju Island Wind Power Plant Data

Back to Top