How can I load this file?
1 view (last 30 days)
Show older comments
Hi everyone,
I should load this file.
I tried in this way but I can't plot data because I have text and number together.
data = readtable('casestudy.csv', 'ReadVariableNames', true)
Can anyone help me kindly?
Thank you in advance!
2 Comments
Scott MacKenzie
on 23 Apr 2021
Yes, your table contains text and numeric data. What are you trying to plot? The 2nd column (S_Dev) contains numeric data. Here's a plot:
T = readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/593980/casestudy.csv')
plot(T.S_Dev);
Accepted Answer
Scott MacKenzie
on 23 Apr 2021
How about this:
T = readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/593980/casestudy.csv', 'ReadVariableNames', true)
plot(T.S_Dev);
ax = gca;
ax.XLabel.String = 'Timee';
ax.YLabel.String = 'S Dev';
ax.XTickLabels = T.Timee;
f = gcf;
f.Color = 'w';
f.Units = 'normalized';
f.Position = [.2 .2 .6 .5]; % widen a bit, so tick labels can be read
3 Comments
Scott MacKenzie
on 23 Apr 2021
Well, text is text. You can't convert "2009-2010" to numeric data. You could divide the text into character arrays for each part and then convert:
>> c = cell2mat(T.Timee)
c =
7×9 char array
'2009-2010'
'2010-2011'
'2011-2012'
'2012-2013'
'2013-2014'
'2014-2015'
'2015-2018'
>> n = [str2num(c(:,1:4)) str2num(c(:,6:9))]
n =
2009 2010
2010 2011
2011 2012
2012 2013
2013 2014
2014 2015
2015 2018
More Answers (0)
See Also
Categories
Find more on Axis Labels in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!