readdatafile#
[data] = readdatafile(file_name, column_delimiter, skip_beginning_rows, skip_beginning_columns, nan_values, file_directory)
Description#
Read and extract data from ASCII, text, Comma Separated Values (CSV), Matlab .mat file
Inputs#
- file_name
- Name of data file between ‘ ‘ mark, example: ‘data.csv’Acceptable file types are:ASCII file, example: ‘data.xyz’Files without extension is considered as ASCIIAll values in ASCII file except for values in header lines should be numberText file, example: ‘data.txt’All values in text file except for values in header lines should be numberComma Separated Values (CSV) file, example: ‘data.csv’All values in CSV file except for values in header lines and skiped columns should be numberMatlab file with .mat extension, example: ‘data.mat’All values in .mat file should be number
- file_directory=pwd;
Location of data file between ‘ ‘ mark, example: ‘C:'
- column_delimiter=’default’;
- Character (delimiter) that separates column from each other between ‘ ‘ mark, example: ‘,’For column_delimiter=’default’, it uses default delimiterFor ASCII or text file, if data are separated by a single space, use ‘ ‘For ASCII or text file, if data are separated by tab, use ‘t’For ASCII or text file, if data are separated by comma, use ‘,’For CSV (comma-separated values) file, use ‘,’For .mat file, it is not required
- skip_beginning_rows=0;
- Number of rows to be skipped at the beginning of the fileFor skip_beginning_rows=0, no line will be skippedFor skip_beginning_rows=1, first line will be skippedFor skip_beginning_rows=2, first and second lines will be skippedFor skip_beginning_rows=n, first n lines will be skippedIs not applied for .mat file
- skip_beginning_columns=0;
- Number of column to be skipped from the starting column in a fileFor skip_beginning_columns=0, no column will be skippedFor skip_beginning_columns=1, first column will be skippedFor skip_beginning_columns=2, first and second columns will be skippedFor skip_beginning_columns=n, first n columns will be skippedIs not applied for .mat file
- nan_values=’none’;
- Value to be considered as NaN‘none’: No value will be considede as NaN‘empty’: it replace empty value with NaNExample: nan_values=-99
Outputs#
- data
date extracted from input data file
Examples#
[data]=readdatafile('data.csv');
file_name='data.csv';
file_directory=pwd;
column_delimiter='default';
skip_beginning_rows=0;
skip_beginning_columns=0;
nan_values='none';
[data]=readdatafile(file_name,file_directory,column_delimiter,skip_beginning_rows,skip_beginning_columns,nan_values);