Insert blank/NaN rows in a column

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?

Answer 1

[Rik]

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

[Mahrukh Farooq]

By separate line objects you mean? I mean how?

[Rik]

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.

[Mahrukh Farooq]

Thanks a lot what i needed was a graph like this below and your first method worked. Actually i have not been using matlab for a year or two and have nearly forgotten everything even how small codes (like the one you gave) work :D I wanted some small changes in my older codes. So your idea to use Dheeraj's method by looping is a bit lengthy and complicated for me right now. Ill be needing help in future

Thanks again.

Answer 2

[Alex Mcaulley]

Do you mean this?

A = rand(288,1);
A = reshape(A,[24,12])
B = reshape(1:numel(A),[24,12])

plot(B,A)

Answer 3

[Dheeraj Singh]

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!!!

[Mahrukh Farooq]

Thanks Dheeraj but i needed a continuous graph not overlapping like the one i have shared above. Thanks for your efforts