Plotting precip and time data

Question

Natasha Sekhon 2017-4-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/334744-plotting-precip-and-time-data

评论： Natasha Sekhon 2017-4-12

NCEI_CDO.xls

Hi There, This is going to come across as a very simple question but i want to plot time on the x-axis in 'yyyy/mm/dd' format and precipitation on the y axis. I'm reading files from an excel data sheet but when i plot it using attached code, the x-axis looks weird. I know it has to do with the formatting but i'm not sure what... Any help is much appreciated! Thanks, Natasha

prcp_hope = xlsread('NCEI_CDO.xlsx','Hope','G:G'); prcp_hope(prcp_hope == -9999) = NaN;
datem_hope = xlsread('NCEI_CDO.xlsx','Hope','F:F');
plot(datem_hope,prcp_hope)

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

KSSV 2017-4-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/334744-plotting-precip-and-time-data#answer_262569

NCEI_CDO.xls

You check your file's date for the row number 29 and 620..it is not correct. I think it should be corrected. Try the code with attached file.

3 个评论
显示 1更早的评论隐藏 1更早的评论

KSSV 2017-4-12

在 MATLAB Online 中打开

prcp_hope = xlsread('NCEI_CDO.xls','Hope','G:G'); 
prcp_hope(prcp_hope == -9999) = NaN;
datem_hope = xlsread('NCEI_CDO.xls','Hope','F:F');
dates = datestr(datem_hope) ;
date = num2str(datem_hope) ;
date = strcat(date(:,1:4),'/',date(:,5:6),'/',date(:,6:end)) ;
thedatenum = datenum(date) ;
plot(thedatenum,prcp_hope)
datetick('x','yyyy/mm/dd')

Natasha Sekhon 2017-4-12

Figure1.jpg

Thank you so much! One last question, i've attached the computed figure and something seems to be off with the placement of the data. For example, if you look closely to 1980's there is criss cross of the line which shouldn't happen if each time has one corresponding precip value.

请先登录，再进行评论。

Answer 2

Peter Perkins 2017-4-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/334744-plotting-precip-and-time-data#answer_262783

编辑：Peter Perkins 2017-4-12

在 MATLAB Online 中打开

If you are using a fairly recent version of MATLAB, use readtable, not xlsread. To make your life easier, you'll want to move those column headers in your Excel file to be above the data, not alongside the data. It looks like your dates are numbers of the form yyymmdd, so call datetime with 'Convert','yyyymmdd' to get a datetime variable in the table. Then just call plot with that datetime and whatever data you want to plot. Something like

>> t = readtable('NCEI_CDO.xls');
>> t.DATE = datetime(t.DATE,'ConvertFrom','yyyymmdd');
>> plot(t.DATE,t.PRCP);

except that you have some work to do between lines 2 and 3, because you have some dates that are in the 900's, rather than the 1900's, and some PRCP values that are -9999. There are simple tools like standardizeMissing to handle the latter.

Hope this helps.