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
- URL = 'http://127.0.0.1:5654' (Local)
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.
- 'default'
- 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
- 'S'
- Example
- Resample_freq = '10T'
- Resampling at 10-minute intervals.
- Resample_freq = '10T'
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