NASA Lithium Battery Data Migration



Introducing the NASA Lithium Battery Data Migration

1. Check raw data

Discharge data files need to be merged, and metadata for each file, including battery type and capacity, needs to be added.

2. Set the Preprocessing Plan

  • Extract only the battery type and capacity values from the metadata and combine.
  • Convert to the format: Name, Time, Value & Convert to UTC time.
  • Merge the converted files into a single file.

Extract only the battery type and capacity values from the metadata and combine

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

Merge the converted files into a single file

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-16-NASA-Lithium_battery.csv.gz --compress gzip --header --method append --timeformat ns nasa_battery

Check the entire code.

datahub/dataset/2024/16.NASA Lithium Battery/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$nasa_battery_stat;

※ Subsequent link to the AI training process: NASA Lithium Battery Data

Back to Top