How can I load this file?

Question

Pul 2021-4-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/810870-how-can-i-load-this-file

评论： Pul 2021-4-23

采纳的回答： Scott MacKenzie

casestudy.csv

在 MATLAB Online 中打开

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 个评论
显示无隐藏无

Scott MacKenzie 2021-4-23

在 MATLAB Online 中打开

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);

Pul 2021-4-23

I should plot the 1st column (Timee) and the 2nd column (S_Dev).

Thank you

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Scott MacKenzie 2021-4-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/810870-how-can-i-load-this-file#answer_682680

在 MATLAB Online 中打开

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 个评论
显示 1更早的评论隐藏 1更早的评论

Scott MacKenzie 2021-4-23

在 MATLAB Online 中打开

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