Error- Not enough input arguments when tried to plot data extracted from a table

N/A
2018 12 27
1 个回答
更新时间：2018 12 27
5 次查看（30 天）

0 个投票

Hi,
I tried importing data from excel into a variable of datatype table
from that I extracted two different columns using bewlo commands
Freq= Data{2:121,3}
ExpectedPow= Data{ 2:121,6}
when I tried to plot Freq v/s Expected Pow its throwing an error 'Not enough input arguments'
In the workspace I can see it took Expected pow as 120*1 categorical and Freq as 120*1 string.
Can you please help on how to plot this?

4 个评论
显示 2更早的评论 隐藏 2更早的评论

N/A
N/A 2018-12-27
编辑：N/A 2018-12-27
Each line of this data is of below format
'2' "" "18550" '3' "" '23.0'
'2' "" "18576" '3' "" '23.0'
where 18550 is freq and 23.0 is expected power
I have taken all frq's into one variable and exopected pow into one variable using above mentioned commands. I am facing error when I tried to plot freq v/s expected power.

请先登录，再进行评论。

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

回答（1 个）

madhan ravi
madhan ravi 2018-12-27

0 个投票

Just a guess:
Freq = str2double(Data{2:121,3});
ExpectedPow = str2double(Data{2:121,6});
plot(Freq,ExpectedPow)

6 个评论
显示 4更早的评论 隐藏 4更早的评论

N/A
N/A 2018-12-27
Thanks madhan. It worked . I am able to see the plot but the range of x-axis and y-axis is 0 to 1. Wheras, Here frequency range(i.e x axis ) is from 18550 to 19050 and Expected power(i.e y axis) from 20 to 30. How can I change the axis limits in the figure?
N/A
N/A 2018-12-27
I have given the limts as per data but still unable to see the values in the figure .It is blank. PFA figure.
madhan ravi
madhan ravi 2018-12-27
编辑：madhan ravi 2018-12-27
Here you go!
T=readtable('data.xlsx');
a=T{:,end};
Freq=T{:,3};
ExpectedPower = str2double(strrep(a, '''', ''));
plot(Freq,ExpectedPower)
xlim([18550 19050]) % alter the limits according to your needs
ylim([20 30])
Note: Matlab modifies the variable names a bit in order to make it a valid name.
Not a surpise that you will get a graph with horizontal line because the y values are constant (only 2 points are there in the file).

请先登录，再进行评论。

类别

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

标签

提问:

N/A
N/A
2018-12-27

编辑：

madhan ravi
madhan ravi
2018-12-27

Community Treasure Hunt

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

Start Hunting!

Translated by