how to import data from csv and plot?

Question

Ani Asoyan 2022-11-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1846793-how-to-import-data-from-csv-and-plot

评论： Ani Asoyan 2022-11-9

采纳的回答： Arif Hoq

baseline.csv

在 MATLAB Online 中打开

Hi everyone!

I want to import excel dataset (csv file) to matlab and plot.

The first column includes string variables like "2022Q1" , "2022Q2", etc.

The second column is regular data. How can I import that csv and plot 2nd column with respect to 1st column (so the strings be the horizontal axis).

I've tried something like this but doesn't work.

[Array, str, raw]=xlsread('baseline.csv');
Error using xlsread
Unable to open file 'baseline.csv'.
File '/users/mss.system.fjCCc6/baseline.csv' not found.
y= Array(:, 2);
x= Array (:, 1);
plot(x,y)

I'm attaching excel file also.

Thank you

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Arif Hoq 2022-11-9

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1846793-how-to-import-data-from-csv-and-plot#answer_1094838

在 MATLAB Online 中打开

baseline.csv

A=readtable('baseline.csv','VariableNamingRule','preserve');

xaxis=table2array(A(:,1));

datavalue=table2array(A(:,2));

C=categorical(xaxis);

plot(C,datavalue)

xtickangle(90)

3 个评论
显示 1更早的评论隐藏 1更早的评论

Arif Hoq 2022-11-9

在 MATLAB Online 中打开

just use this syntax

datavalue=A.d_qoil_t;

Ani Asoyan 2022-11-9

thank you so much !

请先登录，再进行评论。

Answer 2

KSSV 2022-11-9

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1846793-how-to-import-data-from-csv-and-plot#answer_1094818

在 MATLAB Online 中打开

T=readtable('https://in.mathworks.com/matlabcentral/answers/uploaded_files/1186578/baseline.csv');

Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.

X=T.(1);

Y=T.(2);

plot(Y)

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Ani Asoyan 2022-11-9

Thank you for the answer. However I would like to put the string data in the horizontal axis, so it appears 2022Q1, 2022Q2 instead of numbers. Also, did you change the column headers in the excel file?

请先登录，再进行评论。