|DataLab is a compact statistics package aimed at exploratory data analysis. Please visit the DataLab Web site for more information....|
|Home Introduction How to get data into DataLab|
|See also: Loading ASC Files, Loading IDT Files, Saving Data in IDT Format, Saving Data, ASC-Files from Clipboard
How to get data into DataLab
One of the major practical obstacles to use any program for data interpretation is the way how to import external data. In order to make easy and efficient use of a program, the data should be imported easily from a number commonly available data formats. DataLab therefore offers several ways to import data into the data matrix:
Load data from a proprietary DataLab format: this is the most convenient way to load data since not only the data are loaded but also the set-up of the windows and the system parameters (see Loading IDT Files). Of course this data format can only be used if the data have been previously saved using this format.
Import from a simply formatted text file: DataLab uses a simple text-based data format (ASC format) in order to input external data. ASC files may be loaded either directly or by using the Windows clipboard.
Import of Microsoft Excel files: DataLab supports the importing of single worksheets of Excel files.
Import of CSV files: DataLab is able to load "comma separated values" (CSV) files. (Remark: to our experience CSV files should be avoided as this format is by no way standardized and suffers from a plethora of different versions).
Copying data from the Windows clipboard. This is a convenient way to bring data into the numeric editor, although it is only useful for simply structured data as any additional data is lost (only the bare numbers are taken).
Enter the data manually using the built-in numeric data editor.
Generating artificial data. In addition to these methods of importing external data, DataLab offers the possibility of generating artificial data. This may sound strange, but in many circumstances (simulations, experimental design, random test data, etc.) artificial data would be of great help. Therefore DataLab provides a powerful yet simple mathematical formula interpreter which allows us to create virtually any data you can think of. In addition, a versatile random number generator provides a means of creating random numbers of almost arbitrary distributions.