Loading text or .csv files
|
NOTE: this will NOT import complex Excel worksheets. If you want to load data in Excel format into LabAnalyst, save a copy as a tab-delimited text file or a .csv file, which LabAnalyst can read.
After you specify the input file, the program attempts to figure out the correct delimiters and shows the first 10 or 11 rows of data. You can specify a row that contains channel labels, and which row to start reading data from (to avoid text headers, etc.). If the spreadsheet doesn't contain variable names, you can add them later -- but it is vital to keep track of which columns correspond to particular variables! You can also select which variables to read and which to ignore (if some contain unnecessary data). The text file import window looks like this: This example contains 21 variables (only 20 of which are used; the first is blank and is ignored). Data input will begin at line 2, line 1 will be used as variable names, and the user has specified a sample interval of 5 seconds (the latter can be changed later in the 'Edit File Data' option in the EDIT menu ). Since many text files don’t contain most of the file information embedded within a Warthog or Sable-format file, you’ll need to enter appropriate variable names, start times, mass, etc.
|