Insert blank/NaN rows in a column
6 views (last 30 days)
Show older comments
I actually want to plot yearly graphs 12 curves for 12 months each with a set of 24 values. I have acess the data from excel files and reshaped them in one cloumn 288 rows in total. What I want is gap between is each month with no connecting points between the curves. My solution is to introduce blank rows after 24th in each month. How can i do that?
0 Comments
Accepted Answer
Rik
on 21 May 2019
Edited: Rik
on 21 May 2019
This example should work. Don't forget to add NaN values to your x-parameter as well.
Alternatively, you could plot them as separate line objects so you don't have to mess around with NaN values.
data=(1:12*24)';
x_vals=reshape(repmat((1:24)',1,12),[],1);
%strategy 1: insert NaNs
y1=reshape(data,24,[]);
y1(end+1,:)=NaN;
y1=y1(:);
x1=reshape(x_vals,24,[]);
x1(end+1,:)=NaN;
x1=x1(:);
%strategy 2: plot separately
y2=reshape(data,24,[]);
x2=reshape(x_vals,24,[]);
%show plots
figure(1),clf(1)%only use clf for debugging
subplot(1,2,1)
plot(x1,y1)
xlim([0 35])
legend%show legend to show effect
subplot(1,2,2)
plot(x2,y2)
xlim([0 35])
legend%show legend to show effect
3 Comments
Rik
on 21 May 2019
You can use the strategy like Dheeraj described. Providing a matrix as input to plot is equivalent to looping over the columns of your matrix and calling plot repeatedly (with hold on).
I'll edit my answer to illustrate the two methods. You can then make the choice you prefer.
More Answers (2)
Alex Mcaulley
on 21 May 2019
Do you mean this?
A = rand(288,1);
A = reshape(A,[24,12])
B = reshape(1:numel(A),[24,12])
plot(B,A)
0 Comments
Dheeraj Singh
on 21 May 2019
Hi,
You can reshape the matrix into a 24x12 matrix and directly plot
%suppose this is your data
val=rand(24*12,1)
%reshape this to 24x12
val=reshape(val,24,12);
plot(val);
I got the result for 12 months .....Since the plot seems very clutterred for 12 months, i'll show you the plot for 3 months instead of 12...
I got the following result for 3 months....
I hope this helps!!!
See Also
Categories
Find more on Assembly in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!