Plot time-series data of various column

3 次查看(过去 30 天)
% 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
% 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 CenterFile Exchange 中查找有关 Time Series 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by