how to plot from .csv file?

Question

ramya 2024-8-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2145714-how-to-plot-from-csv-file

编辑： Walter Roberson 2024-8-16

baseline.csv

i hv to find percentage difference values for columns 3,6,9,12 for 2 pol HH and VV separatelyand find out difference at each frequency

later at x axis frequency and y axis these indivdual percentage values has to be plotted in bar chart

A=csvread('baseline.csv',1,0)
Error using dlmread (line 144)
Unable to parse a "Numeric" field when reading row 2, field 1.
   Actual Text: "HH,2,1.407356125,HH,2,4.037356125,HH,2,5.037356125,HH,2,7.337356125"
   Expected: A number or literal "NaN", "Inf". (possibly signed, case insensitive)

Error in csvread (line 53)
    m=dlmread(filename, ',', r, c); %#ok<*DLMRD> 
freq=A(1:6,2);
A_1_PE_HH=A(1:6,3);
B_2_PE_HH=A(1:6,9);
A_1_fre_HH=A(1:6,6);
B_2_fre_HH=A(1:6,12);
HH_1st_example=((A_1_PE_HH(2,1)-B_2_PE_HH(2,1))/A_1_PE_HH(2,1))*100 %finding percentage differnce between 3 and 6 columns
HH_2nd_example=((A_1_PE_HH(2,1)-B_2_fre_HH(2,1))A_1_PE_HH(2,1))*100 %finding percentage differnce between 3 and 12 columns
Invalid expression. Check for missing multiplication operator, missing or unbalanced delimiters, or other syntax error. To construct matrices, use brackets instead of parentheses.
HH_3rd_example=((A_1_fre_HH(2,1)-B_2_PE_HH(2,1))/A_1_fre_HH(2,1))*100 %finding percentage differnce between 6 and 9 columns
HH_4th_example=((A_1_fre_HH(2,1)-B_2_fre_HH(2,1))/A_1_PE_HH(2,1))*100 %finding percentage differnce between 6 and 12 columns

same i have to find for VV also i m getting stuck at this place

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2024-8-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2145714-how-to-plot-from-csv-file#answer_1499959

编辑：Walter Roberson 2024-8-16

csvread() requires that all of the fields are numeric, with the possible exception of leading rows or leading columns (provided that you pass in appropriate numeric parameters to call for the leading rows and columns to be skipped.) csvread() is completely unable to deal with text after a column that is being read, even if you set the range to exclude the text column .

Use readtable to deal with the file.

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

请先登录，再进行评论。

Answer 2

KSSV 2024-8-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2145714-how-to-plot-from-csv-file#answer_1499794

在 MATLAB Online 中打开

T=readtable('https://in.mathworks.com/matlabcentral/answers/uploaded_files/1753899/baseline.csv') ; 
freq=T.(2)(1:6);
A_1_PE_HH=T.(3)(1:6) ; 
B_2_PE_HH=T.(9)(1:6) ;
A_1_fre_HH=T.(6)(1:6);
B_2_fre_HH=T.(12)(1:6);
% 
HH_1st_example=(A_1_PE_HH(2,1)-B_2_PE_HH(2,1))/A_1_PE_HH(2,1)*100; %finding percentage differnce between 3 and 6 columns
HH_2nd_example=(A_1_PE_HH(2,1)-B_2_fre_HH(2,1))/A_1_PE_HH(2,1)*100; %finding percentage differnce between 3 and 12 columns
HH_3rd_example=(A_1_fre_HH(2,1)-B_2_PE_HH(2,1))/A_1_fre_HH(2,1)*100; %finding percentage differnce between 6 and 9 columns
HH_4th_example=(A_1_fre_HH(2,1)-B_2_fre_HH(2,1))/A_1_PE_HH(2,1)*100; %finding percentage differnce between 6 and 12 columns