Unable to plot data from .xlsx
显示 更早的评论
I want to plot data from .xlsx (or .csv) file. I have used the following code. earlier I had also used round braces in line 2 and 3 but that didn't work as well. It gave the error message "Tables and timetables do not have a plot method. To plot a table or a timetable, use the stackedplot function. As an alternative, extract table or timetable variables using dot or brace subscripting, and then pass the variables as input arguments to the plot function." After using curly braces now the error message is "Error using plot Invalid data argument." The data file has around 2 Million *22 enteries. Any function that converts it into a matrix would be helpful. Thanks in advance
T =readtable('PuneAQMNew_22.xlsx');
Time=T{:,16};
AirQuality= T{:,2};
plot(AirQuality,Time,'r')
legend('Airquality')
9 个评论
Walter Roberson
2022-8-17
The code you have now should work, provided that column 2 and 16 are numeric (such as double), or are categorical, or are duration objects, or are datetime objects.
whos Time AirQuality
Shweta Kiran
2022-8-17
Walter Roberson
2022-8-17
Is Time duration objects, or datetime objects, or cell array of character vectors?
Shweta Kiran
2022-8-17
移动：Voss
2022-8-19
Walter Roberson
2022-8-17
移动：Voss
2022-8-19
What shows up for
class(Time)
Shweta Kiran
2022-8-18
移动：Voss
2022-8-19
Walter Roberson
2022-8-18
移动：Voss
2022-8-19
Earlier you indicated that AirQuality is integer; now you say it is cell. Does that mean that each entry in the table for AirQuality is a cell array containing a single integer in numeric form (class double)?
If so, at the moment I cannot think of any way that readtable() could have produced such a table. I can think of cases in which it could have produced a table in which the column was a cell array in which each entry was a character vector that represented a number. That can happen if there are extra headers in the file; there are a couple of possible work-arounds for that. It can also happen if somewhere in the column there is text other than "NaN" -- for example if there is an entry saying "missing" or "N/A", or if there is some kind of summary area at the bottom of the file.
Shweta Kiran
2022-8-19
移动：Voss
2022-8-19
Walter Roberson
2022-8-19
移动：Voss
2022-8-19
Please attach a short extract of the file, including any headers that are present.
回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息
2022-8-17
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
