Data_Info

Description

This API checks the necessary information required for data loading from the specified Tag Table. This step is essential before loading data and is therefore performed first in the EDA process.

The output results are as follows:

  • Tag List
  • Total number of data points
  • Start and end time of the data
  • Number of missing values
  • Data time interval
  • Data sampling rate

API module path

from api.v2.eda.Data_Info import Data_Info

Parameters

URL

  • Specifies the URL address where the Mahabase Neo DB is installed.
  • Example

Table

  • Specifies the name of the table that contains the data. Only a single table can be specified.
  • Example
    • table=home (O)
    • table=home.rotor (X)

Timeformat

  • specifies the time format.
  • The time format follows the KST (Korean Standard Time) notation.
  • Option
    • 'default'
      • Use the system's default time format.
    • '2006-01-02 15:04:05.000000'
      • The time format of the system's default time format that includes nanoseconds.
  • Example
    • Timeformat = 'default'
    • Timeformat = '2006-01-02 15:04:05.000000'

Resample_freq

  • Specifies the resampling unit.
  • By default, the calculation is done using the mean.
  • Option
    • 'S'
      • Second
    • 'T'
      • Minute
    • 'H'
      • Hour
    • 'D'
      • Day
    • 'W'
      • Week
    • 'M'
      • Month
    • 'Q'
      • Quarter
    • 'Y'
      • Year
  • Example
    • Resample_freq = '10T'
      • Resampling at 10-minute intervals.

Example Sample Code (Python)

Results

Check the entire module code.

datahub/api/v2/eda/Data_Info.py at main · machbase/datahub
All Industrial IoT DataHub with data visualization and AI source - machbase/datahub

Back to Top