필터 지우기
필터 지우기

How to add arbitrary rows of zeroes in matrices/excel spreadsheet?

조회 수: 2 (최근 30일)
Hi, I made this program were the user can type in a year between 2009 and 2011 and get snow depth and air temperature data for the chosen year displayed on a graph.
I have one xls file for the temperature for each day from day 1 to day 365. I also have another xls file for snow depth from day 1 to day 212. So some days they didn't bother to measure snow depth because it was summer anyways. Between 30. april to 1. october they didn't measure snow depth. I want to add 153 zeroes with code between 30. april and 1. oct so it adds up to 365 days.
day 121 = 30. april
chosenyear = input('Type in year: ');
snowdepth = xlsread('snow2009_2011.xls');
snowdepth2009 = snowdepth(:,1);
snowdepth2010 = snowdepth(:,2);
snowdepth2011 = snowdepth(:,3);
airtemp = xlsread('airtemp2009_2011.xls');
airtemp2009 = airtemp(:,1);
airtemp2010 = airtemp(:,2);
airtemp2011 = airtemp(:,3);
if chosenyear == 2009
figure(1);
plot(snowdepth2009, 'b');
title(['Snowdepth/airtemp ' num2str(chosenyear)]);
xlabel('Days/months');
ylabel('data');
grid on
datetick('x','m');
hold on
plot(airtemp2009, 'r');
legend('snow depth in cm','air temp in Celsius');
elseif chosenyear == 2010
figure(2);
plot(snowdepth2010, 'b');
title(['Snowdepth/airtemp ' num2str(chosenyear)]);
xlabel('Days/months');
ylabel('data');
grid on
datetick('x','m');
hold on
plot(airtemp2010, 'r');
legend('snow depth in cm','air temp in Celsius');
elseif chosenyear == 2011
figure(3);
plot(snowdepth2011, 'b');
title(['Snowdepth/airtemp ' num2str(chosenyear)]);
xlabel('Days/months');
ylabel('data');
grid on
datetick('x','m');
hold on
plot(airtemp2011, 'r');
legend('snow depth in cm','air temp in Celsius');
else
disp('NB! Type in 2009, 2010 or 2011');
filename.m
end

채택된 답변

Image Analyst
Image Analyst 2012년 11월 23일
But in your other post, I told you how to insert rows - did you see that answer?
  댓글 수: 2
andrew_cup
andrew_cup 2012년 11월 23일
yes, but when I run the program it stops at 212 days and doesn't display all 12 months. I can upload xls files.

댓글을 달려면 로그인하십시오.

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by