MATLAB Answers

Convert table and plot dates

51 views (last 30 days)
Tim W.
Tim W. on 5 Jun 2019
Commented: Peter Perkins on 19 Jun 2019
I am kinda struggeling with a simple problem. I am trying plot the data of a table; but i can't get seem to conver the data into numbers and plot them.
The table looks like this.
Date Data1 Data2
________________ _____________ ____________
'12-07-2018 21:45' '-233.05' '-221.68'
'12-07-2018 22:00' '-233.33' '-231.18'
'12-07-2018 22:15' '-232.67' '-227.91'
'12-07-2018 22:30' '-232.95' '-226.35'
'12-07-2018 22:45' '-233.18' '-226.14'
'12-07-2018 23:00' '-233.02' '-228.94'
I tried using str2num etc. but nothing works.


Peter Perkins
Peter Perkins on 7 Jun 2019
Kojiro answered the question per se, but the real question is how you ended up with that table to begin with. If you have a CSV file, or a spreadsheet, you should use readtable (or in recent versions readtimetable). That would typically give you a table with a datetime and two doubles.
There may be something funny in your file, though.
Tim W.
Tim W. on 7 Jun 2019
You are correct, normaly it should give me one row with a datetime and x-number of collums as numbers. The Problem is just that I am having multiple csv files and they all start at the same date, but certain instruments did start their measurments. This means some files have no number for the first thousands rows or so (just the date).
If there is no number in the first row Matlab seems to think the whole collum must be characters.
Peter Perkins
Peter Perkins on 19 Jun 2019
If you are using readtable, use detectimportoptions and force the column to be read in as numeric. A simpler version is to specify the Format parameter.

Sign in to comment.

Accepted Answer

Kojiro Saito
Kojiro Saito on 5 Jun 2019
You can convert cell arrays which contain characters using str2double. Here is a sample code.
% Convert to datetime
data2.Date = datetime(data2.Date, 'InputFormat', 'MM-dd-yyyy HH:mm');
% Convert to double
data2.Data1 = str2double(data2.Data1);
data2.Data2 = str2double(data2.Data2);
hold on;
hold off;

  1 Comment

Tim W.
Tim W. on 5 Jun 2019
You Sir are my hero,
worked like a charm

Sign in to comment.

More Answers (0)

Sign in to answer this question.

Translated by