Data Analysis from Excel File

7 次查看（过去 30 天）
Arnab Das
Arnab Das 2020-11-4
回答： Walter Roberson 2020-11-4
Hello, I have written the following code in order to plot a graph from an 8760x4 excel table. The graph is between a 8760x1 row which contains time and a 8760x1 row that contains numerical values.I am attaching the code , please let me know what is the mistake as my plot function is not working.
xlsfinfo('C:\Users\sayan\OneDrive\Desktop\energytransition\Paderborn_2019_Quiz')
paderSolar=readtable('C:\Users\sayan\OneDrive\Desktop\energytransition\Paderborn_2019_Quiz');
paderSolar=table2timetable(paderSolar)
Timestamp=paderSolar(:,2)
GlobIrrad=paderSolar(:,3)
figure(1)
plot(TimeStamp,GlobIrrad)
when I run this particular code the error :
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 'PreserveVariableNames' to true to use the original column headers as table variable names.
and its suggesting to use stackedplot in that case I am getting the output of entire table but that is not what I need I need the graph between two columns.
any lead in these scenario will be appriciated,
thank you
regards
sayantan
  1 个评论
Walter Roberson
Walter Roberson 2020-11-4
Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating
That is a warning not an error. You can ignore it because you never use the variable names.

请先登录，再进行评论。

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

回答（1 个）

Walter Roberson
Walter Roberson 2020-11-4
Timestamp=paderSolar{:,2} ;
GlobIrrad=paderSolar{:,3} ;

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by