Plot time-series data of various column

3 次查看（过去 30 天）
MAT NIZAM UTI
MAT NIZAM UTI 2021-12-2
评论： MAT NIZAM UTI 2021-12-2
% Read in data
%k = xlsread('ACTUAL DATA_WIND SPEED.csv');
k = xlsread('plot_try1.csv');
time = k(1,:); %sholud be row 1
% lats = k(1:end,1); % 2315 long
% lons = k(2:end,2); % 2314 long
speeds = k(3:end,3); % 2314 long %should be column A1-A7127 until column L2-L7127
whos k
whos time
% whos lats
% whos lons
whos speeds
subplot(3, 1, 1);
plot(speeds, 'b-')
% plot3(speeds vs time);
grid on;
xlabel('Wind speed', 'FontSize',fontSize);
ylabel('Month-Year', 'FontSize',fontSize)
title('Monthly wind speed', 'FontSize',fontSize)
Hi, I am trying to plot time-series data.
The arrangement of data
Row 1 is time (strings)
Column A2-A29 untill L2-L29 is the wind speed data
I want to produce a time-series like this, I can produce it using Excel, but due to Excel has limit of data, thus some of the data could not appear in the time-series graph.

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

采纳的回答

Chunru
Chunru 2021-12-2
Ran in:
% Read in data
%k = xlsread('ACTUAL DATA_WIND SPEED.csv');
k = readmatrix('plot_try1.csv');
k(1, :) = []; % remove the header
size(k)
ans = 1×2
7126 12
t = datetime(1993, [1:12], 1);
plot(t, k')
grid on;
ylabel('Wind speed');
xlabel('Month-Year')
title('Monthly wind speed');
% Too many data in the plot

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by