MATLAB: How to load CSV file with space

csvloadspace

I have a csv file that loads very perfectly from 2nd column onwards.

data = csvread('filename.csv',1,1);

However, in the first column of my data I have date:

the format of the date is

2012/09/15 00:00:00,0,-13.654,…

2012/09/15 00:00:01,0,-18.654,…

2012/09/15 00:00:02,0,-166.654,…

2012/09/15 00:00:03,0,-178.654,…

…

Here, date is space separated with time. This creates error in loading the file using

data = csvread('filename.csv',1,0);

Can anyone suggest what to do?

Best Answer

What happens when you use

readtable()

because they are capable of reading dates by default

Related Solutions

MATLAB: Trouble importing multiple .csv files with strings in first row

csvread (and dlmread) can't read the headers of csv files. You can tell them to skip the header:

data(i)=csvread(l(i).name, 1, 0);  %skip 1st row

But better would be to use the modern tools of matlab and use readtable to actually parse the header and use it to name the variables (columns) of the table:

data(i) = readtable(l(i).name);  %why not call the variable csvlist instead of l? It's instantaneously clearer what its purpose is?

MATLAB: Merge two column in the table

One approach:

T1 = readtable('test.txt');
T1.Var1 = datetime(T1.Var1, 'InputFormat','yyyy/MM/dd');
T1.Var1 = T1.Var1 + T1.Var2;
T1.Var2 = [];

producing:

T1 =
  4×2 table
            Var1             Var3 
    ____________________    ______
    24-Feb-2020 00:00:00    3.4578
    24-Feb-2020 00:00:01    3.4578
    24-Feb-2020 00:00:02    3.4578
    24-Feb-2020 00:00:03    3.4578

Best Answer

Related Solutions

MATLAB: Trouble importing multiple .csv files with strings in first row

MATLAB: Merge two column in the table

Related Question