Importtool: Difference between revisions

From Eigenvector Research Documentation Wiki
Jump to navigation Jump to search
imported>Mathias
No edit summary
 
(10 intermediate revisions by 2 users not shown)
Line 19: Line 19:




==Examples==
===Examples===


Here we import a csv file by dragging the file into the browse window. 
Taking a look at the file we are attempting to import, we see that we have 4 lines of meta data + blank lines, so we set the 'header rows' field to 4 in the text import settings window.  The automatic delimiter detection is being used in this example, however the user may force the use of a specific delimiter by selecting it in this window.   
[[Image:csv_examp.jpg||460px|]]
[[Image:Text_import1.jpg||360px|]]
The importool will attempt to automatically detect label columns.  Here the first column containing the names of beers has been automatically detected as a label column.  The third column, containing class information of either 'ale' or 'lager' has also been automatically detected as a label column.  To set this column to a class column, click where it says 'label' underneath C2 and select class.  The importer will now populate the datasets'class field with the information contained within this second column.
[[Image:importtool1.jpg||420px|]]


Here we import a csv file by dragging the file into the browse window. 


====Important Note====


[[Image:csv_examp.jpg||420px|]]
The importtool view will show the first rows from the text file, up to a maximum of 50 rows. The entire file will be imported when you click the "Ok" button to complete importing the file, regardless of how many lines are in the file. There is no hard-coded limit to the number of lines which can be imported from a text file.
[[Image:Text_import1.jpg||300px|]]
[[Image:importtool1.jpg||380px|]]





Latest revision as of 22:57, 9 May 2021

Purpose

GUI for designating column/row data types in incoming data. Allows user to specify a column or row as labels, class sets, or axisscale or data.

Synopsis

[ctypes, rtypes] = importtool(data);
[ctypes, rtypes] = importtool(data,options);

Description

Allows user to identify data type (data, class, axisscale, include, and ignore) fields (row and columns) in a data matrix.

Options

options = a structure array with the following fields:

  • fields: Nx2 cell array, first column is field name, second column is color to use.


Examples

Here we import a csv file by dragging the file into the browse window.

Taking a look at the file we are attempting to import, we see that we have 4 lines of meta data + blank lines, so we set the 'header rows' field to 4 in the text import settings window. The automatic delimiter detection is being used in this example, however the user may force the use of a specific delimiter by selecting it in this window.


Csv examp.jpg Text import1.jpg


The importool will attempt to automatically detect label columns. Here the first column containing the names of beers has been automatically detected as a label column. The third column, containing class information of either 'ale' or 'lager' has also been automatically detected as a label column. To set this column to a class column, click where it says 'label' underneath C2 and select class. The importer will now populate the datasets'class field with the information contained within this second column.


Importtool1.jpg


Important Note

The importtool view will show the first rows from the text file, up to a maximum of 50 rows. The entire file will be imported when you click the "Ok" button to complete importing the file, regardless of how many lines are in the file. There is no hard-coded limit to the number of lines which can be imported from a text file.


See Also

parsemixed