This is an old revision of the document!
The import module reads data from data sources.
The module has support for
Limitations:
Data files may consist of numeral, categorical (text) or date/time columns. There is a color-based indication of column types:
Column names are allowed but not required. GMDH Shell does not provide tools for file editing but allows a user to keep data file opened for editing. It is not required to close the editor (Excel, Notepad, etc) before clicking at the Import or the Start button. You can modify data file using your editor, save changes and immediately start recalculation of results in GMDH Shell.
If your project folder contains several data files, the Import module makes all of them available in the Data manager. Selection of just one file points importer module to the whole directory.
The file selected during the import procedure receives a special status Current
in the Data manager. Only variables from the Current file can be used as model inputs or targets without filename prefixes, for example, var1
instead of filename.var1
required for other files.
Current file path will appear in the title bar of GMDH Shell window:
Reads column names from the first row of data file(s). The number of elements in the first row is used for detection of data table width.
If you have unique data row identifiers, for example, calendar dates then you can tell the Importer in which column they are located and use them for visualization instead of default ID marks. For example, row labels serve as timestamps for time series charts.
In case of multiple data files, the row labels will be taken from the Current
data file.
Quite often datasets have date marks such as year and month or week located in separate columns. Then you can compose timestamps from several columns using the option Compose ID from several columns. In this case all aggregated columns in the dataset must be neighboring and the option Read row lables from column N must point to the first of them.
Sets a delimiter type. Applicable to CSV files only.
Import module is responsible for detection of missing values. It replaces various cells that fall into missing value conditions with regular NULL values and thus allows Preprocessor module to handle missing values appropriately.
Replaces any non-numeric values with regular NULL values.
ODBC/OLEDB Import allows GMDH Shell to access data stored in databases.
1. First of all select the import module: Menu > File > ODBC/OLEDB import
2. In the appeared dialog select directory where all settings and quires will be stored.
The import module can be selected in the toolbar
~~UP~~