how to import data from csv and plot?

2022 11 9
3 个回答
回答已采纳
更新时间：2022 11 9
96 次查看（30 天）
Ran in:

0 个投票

Ran in:
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

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

 采纳的回答

Arif Hoq
Arif Hoq 2022-11-9
Ran in:

1 个投票

Ran in:
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更早的评论

Ani Asoyan
Ani Asoyan 2022-11-9
Thank you for the answer ! can I plot based on header name and not the column number?
So instead of calling 2nd column how can I plot based on its heading name?
datavalue=table2array(A(:,2));
Arif Hoq
Arif Hoq 2022-11-9
just use this syntax
datavalue=A.d_qoil_t;
Ani Asoyan
Ani Asoyan 2022-11-9
thank you so much !

请先登录，再进行评论。

更多回答（2 个）

KSSV
KSSV 2022-11-9
Ran in:

1 个投票

Ran in:
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
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?

请先登录，再进行评论。

Kalpesh Bagmar
Kalpesh Bagmar 2022-11-9

1 个投票

Hello Ani,
May be you can try following code snippet
[a]=readcell('baseline.csv')
a=a(4:end,:) % removing unwanted headings from data
b = cell2mat(a(:,2))
c = a(:,1)
bar(b)
set(gca,'xticklabel',c)

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

Ani Asoyan
Ani Asoyan 2022-11-9
Thank you for your answer! I already accepted the prevous answer, but will also try your method. Thanks

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by