Difference between revisions of "Importing Data"

From Eigenvector Research Documentation Wiki
Jump to navigation Jump to search
imported>Jeremy
(High-Level File and Source Readers)
 
(23 intermediate revisions by 4 users not shown)
Line 1: Line 1:
In addition to the Matlab functions to read various file types, PLS_Toolbox provides various functions for reading common data formats into DataSet Objects. Also see the [[editds DataSet Editor]].
+
In addition to the Matlab functions to read various file types, PLS_Toolbox provides various functions for reading common data formats into DataSet Objects. Also see the [[editds|DataSet Editor]].
+
 
+
===High-Level File and Source Readers===
 
:[[areadr]] - Reads ascii data and strips header.
 
:[[areadr]] - Reads ascii data and strips header.
 
:[[autoimport]] - Automatically reads specified file. Handles all standard filetypes.
 
:[[autoimport]] - Automatically reads specified file. Handles all standard filetypes.
:[[asfreadr]] - Reads Hamilton Sundstrand ASF files.
+
:[[asdreadr]] - Imports data from Analytical Spectral Devices (ASD) Indico (Versions 6 and 7) data files.
 +
:[[asfreadr]] - Reads AIT ASF files.
 +
:[[brukerxrpdreadr]] - Reads Bruker XRPD RAW files into a DataSet object.
 +
:[[cytospecreadr]] - Reads CytoSpec .cyt files into a Dataset object.
 +
:[[envireadr]] - Reads ENVI image files.
 +
:[[experimentreadr]] - Read an Experiment file and import corresponding files.
 +
:[[getpidata]] - Uses the current PI connection to construct a DSO from 'taglist'.
 +
:[[hitachieemreadr]] - Reads Hitachi EEM files with Rayleigh removal.
 +
:[[hjyreadr]] - Reads HORIBA Jobin Yvon files.
 +
:[[hrmethodreadr]] - Converts HoloReact method into preprocessing structure.
 +
:[[jcampreadr]] - Reads a JCAMP file into a DataSet object.
 
:[[mtfreadr]] - Read AdventaCT Multi-Trace Format (MTF) files.
 
:[[mtfreadr]] - Read AdventaCT Multi-Trace Format (MTF) files.
 +
:[[netcdfreadr]] - Reads in netCDF files and outputs a DataSet and or structure.
 +
:[[omnicreadr]] - Reads OMNICix HDF5 image files.
 +
:[[opusreadr]] - Read Bruker OPUS files.
 
:[[parsexml]] - Convert XML file to a MATLAB structure.
 
:[[parsexml]] - Convert XML file to a MATLAB structure.
 +
:[[pltreadr]] - Imports a Vision AIr .PLT model file as an EVRI model object.
 +
:[[querydb]] - Executes a query on a database defined by connection string.
 +
:[[pereadr]] - Read PerkinElmer files.
 +
:[[rdareadr]] - Read Siemens RDA files.
 +
:[[shimadzueemreadr]] - Reads Shimadzu EEM Files (TXT).
 
:[[spcreadr]] - Reads a Galactic SPC file.
 
:[[spcreadr]] - Reads a Galactic SPC file.
 +
:[[spereadr]] - Reads a Princeton Instruments SPE file.
 +
:[[snabsreadr]] - Reads Stellarnet ABS XY files.
 +
:[[spgreadr]] - Reads Thermo Fischer SPG files.
 +
:[[visionairxmlreadr]] - Reads Vision Air XML Data Files (XML).
 
:[[xclgetdata]] - Extracts matrix from an Excel spreadsheet.
 
:[[xclgetdata]] - Extracts matrix from an Excel spreadsheet.
 
:[[xclputdata]] - Write matrix to an Excel spreadsheet.
 
:[[xclputdata]] - Write matrix to an Excel spreadsheet.
Line 13: Line 35:
 
:[[xlsreadr]] - Reads .XLS files from MS Excel and other spreadsheets.
 
:[[xlsreadr]] - Reads .XLS files from MS Excel and other spreadsheets.
 
:[[xyreadr]]  - Reads one or more ASCII XY or XY... files into a DataSet object.
 
:[[xyreadr]]  - Reads one or more ASCII XY or XY... files into a DataSet object.
+
 
+
===Other Reading and Writing Utilities===
 +
:[[autoexport]] - Exports a DataSet object to a file of the specified format.
 +
:[[importtool]] - GUI for designating column/row data types in incoming data.
 
:[[lddlgpls]] - Dialog to load variable from workspace or MAT file.
 
:[[lddlgpls]] - Dialog to load variable from workspace or MAT file.
 
:[[svdlgpls]] - Dialog to save variable to workspace or MAT file.
 
:[[svdlgpls]] - Dialog to save variable to workspace or MAT file.
 
:[[builddbstr]] - Builds a database connection string.
 
:[[builddbstr]] - Builds a database connection string.
:[[querydb]] - Executes a query on a database defined by connection string.
 
:[[getpidata]] - Uses the current PI connection to construct a DSO from 'taglist'.
 
 
:[[parsemixed]] - Parse numerical and text data into a DataSet Object.
 
:[[parsemixed]] - Parse numerical and text data into a DataSet Object.
 +
:[[table2dataset]] - Convert Matlab Table Array to DatasetObject.
 
:[[writecsv]] - Export a DataSet object to a comma-separated values (CSV) file.
 
:[[writecsv]] - Export a DataSet object to a comma-separated values (CSV) file.
+
:[[writespc]] - Export a DataSet object to a Galactic SPC file.
 +
:[[writeplt]] - Exports an EVRI model object to a Vision AIr .PLT model file.
 +
 
 
(Sub topic of [[Import_View_Data|Import_View_Data]])
 
(Sub topic of [[Import_View_Data|Import_View_Data]])

Latest revision as of 10:17, 13 August 2019

In addition to the Matlab functions to read various file types, PLS_Toolbox provides various functions for reading common data formats into DataSet Objects. Also see the DataSet Editor.

High-Level File and Source Readers

areadr - Reads ascii data and strips header.
autoimport - Automatically reads specified file. Handles all standard filetypes.
asdreadr - Imports data from Analytical Spectral Devices (ASD) Indico (Versions 6 and 7) data files.
asfreadr - Reads AIT ASF files.
brukerxrpdreadr - Reads Bruker XRPD RAW files into a DataSet object.
cytospecreadr - Reads CytoSpec .cyt files into a Dataset object.
envireadr - Reads ENVI image files.
experimentreadr - Read an Experiment file and import corresponding files.
getpidata - Uses the current PI connection to construct a DSO from 'taglist'.
hitachieemreadr - Reads Hitachi EEM files with Rayleigh removal.
hjyreadr - Reads HORIBA Jobin Yvon files.
hrmethodreadr - Converts HoloReact method into preprocessing structure.
jcampreadr - Reads a JCAMP file into a DataSet object.
mtfreadr - Read AdventaCT Multi-Trace Format (MTF) files.
netcdfreadr - Reads in netCDF files and outputs a DataSet and or structure.
omnicreadr - Reads OMNICix HDF5 image files.
opusreadr - Read Bruker OPUS files.
parsexml - Convert XML file to a MATLAB structure.
pltreadr - Imports a Vision AIr .PLT model file as an EVRI model object.
querydb - Executes a query on a database defined by connection string.
pereadr - Read PerkinElmer files.
rdareadr - Read Siemens RDA files.
shimadzueemreadr - Reads Shimadzu EEM Files (TXT).
spcreadr - Reads a Galactic SPC file.
spereadr - Reads a Princeton Instruments SPE file.
snabsreadr - Reads Stellarnet ABS XY files.
spgreadr - Reads Thermo Fischer SPG files.
visionairxmlreadr - Reads Vision Air XML Data Files (XML).
xclgetdata - Extracts matrix from an Excel spreadsheet.
xclputdata - Write matrix to an Excel spreadsheet.
xclreadr - Reads an ASCII or .XLS file in as a DataSet Object.
xlsreadr - Reads .XLS files from MS Excel and other spreadsheets.
xyreadr - Reads one or more ASCII XY or XY... files into a DataSet object.

Other Reading and Writing Utilities

autoexport - Exports a DataSet object to a file of the specified format.
importtool - GUI for designating column/row data types in incoming data.
lddlgpls - Dialog to load variable from workspace or MAT file.
svdlgpls - Dialog to save variable to workspace or MAT file.
builddbstr - Builds a database connection string.
parsemixed - Parse numerical and text data into a DataSet Object.
table2dataset - Convert Matlab Table Array to DatasetObject.
writecsv - Export a DataSet object to a comma-separated values (CSV) file.
writespc - Export a DataSet object to a Galactic SPC file.
writeplt - Exports an EVRI model object to a Vision AIr .PLT model file.

(Sub topic of Import_View_Data)