MATLAB: How to import csv-file with headlines (type text) to matrix? – only numbers are needed

csvcsvreadfilehelpimportimportdataMATLABnumerical valuestextscan

Hello community,

I've got a csv-file with first row as headline (type text). But I want to write a script, so the import tool cannot help. I've tried 'importData', csvread (but it supports sheets with numbers only) and textscan. It would be the best when i could choose the range – I only need the numbers.

My csv-file has the following composition:

1 31-10-19 12:31:14 14,2342 15,1234 ….

2 31-10-19 12:31:15 16,4442 15,6283 ….

3 31-10-19 12:31:16 14,8552 15,8294 ….

I only need the temperature values, therefore i want to choose the range. Or is there anothers opportunity to import the numerical values?

Thanks for your help!

Michael

Best Answer

Both readtable and readmatrix will handle this file without issue. I would have thought that importdata would delegate to readtable so I'm surprise it didn't work for you.

readtable will label the columns according to the header.

Related Solutions

MATLAB: Import data from text file

use readtable which should be able to figure out the format of your file on its own. It will probably fail for your time column and import it as text instead. This can be fixed either beforehand by overriding the import options or afterward with:

yourtable.yourfirstcolumn = datetime(yourtable.yourfirstcolumn, 'InputFormat', 'HH:mm.ss.S', 'Format', 'HH:mm.ss.SSS');

MATLAB: Datetime from csv: format change from 2017b to 2018 and higher

Hi Emma,

I haven't checked between releases but I noticed that the 'readtable' function has a 'DatetimeType' name-value pair option:

'DatetimeType'  The output type of datetime variables. The possible values
                           are:
                               'datetime'     - Return dates as MATLAB datetimes.
                               'text'         - Return dates as text.
                               'exceldatenum' - Return dates as Excel serial day date numbers.

Therefore I suggest trying:

scenariodata = readtable(filename, 'delimiter', ',', 'DatetimeType', 'text');

Otherwise you could call:

whos scenariodata{3,8}

in the command line to see what data type is being used and handle it accordingly.

HTH,

Ben

Best Answer

Related Solutions

MATLAB: Import data from text file

MATLAB: Datetime from csv: format change from 2017b to 2018 and higher

Related Question