<div dir="ltr"><div>Quite frankly, a rather intimidating request! A bit too much information.</div><div><br></div><div>NCL has a suite of functions: <b><a href="http://www.ncl.ucar.edu/Document/Functions/Contributed/calculate_daily_values.shtml" target="_blank">calculate_daily_values</a></b>, <b><a href="http://www.ncl.ucar.edu/Document/Functions/Contributed/calculate_monthly_values.shtml" target="_blank">calculate_monthly_values , </a><a href="http://www.ncl.ucar.edu/Document/Functions/Contributed/calculate_segment_values.shtml" target="_blank">calculate_segment_values</a><br></b></div><div><br></div><div>A companion function which for some reason was never distributed is:<b> calculate_hourly_values</b></div><div>Attached is a stripped down version. It may not be quite what you want but it may be a start. <b><br></b></div><div>This allows the user to set some minimum number of values for a returned value. The default is one.</div><div>opt = True</div><div>opt@nval_crit = 5 ; this would require 5 or more hourly values for a mean to be returned <br></div><div><b><br></b></div><div>Using the 1st 1500 data lines ...<b><br></b></div><div><br></div><div>Variable: <b>slwHourAvgMax</b><br>Type: float<br>Total Size: 112 bytes<br> 28 values<br>Number of Dimensions: 1<br>Dimensions and sizes: <b>[ob_time | 28] <=== 28 hourly means</b><br>Coordinates: <br> ob_time: [56.80763888889002..57.91666666666666]<br>Number Of Attributes: 2<br> _FillValue : 9.96921e+36<br> NCL_tag : calculate_hourly_values: arith=avg<br>(0) min=0.000818031 max=0.198065<br>(0) ------</div><div> <b>yyyymmddhh</b><br></div><div>(0) 2008122719 0.0306192<br>(1) 2008122720 0.0442881<br>(2) 2008122721 0.0436597<br>(3) 2008122722 0.0160423<br>(4) 2008122723 0.0122796<br>(5) 2008122800 0.0332206<br>(6) 2008122801 0.0570931<br>(7) 2008122802 0.0539767<br>(8) 2008122803 0.067338<br>(9) 2008122804 0.0339982<br>(10) 2008122805 0.0131879<br>(11) 2008122806 0.0279825<br>(12) 2008122807 0.0184872<br>(13) 2008122808 0.0301441<br>(14) 2008122809 0.0453946<br>(15) 2008122810 0.0330844<br>(16) 2008122811 0.0905933<br>(17) 2008122812 0.198065<br>(18) 2008122813 0.158521<br>(19) 2008122814 0.181076<br>(20) 2008122815 0.11006<br>(21) 2008122816 0.071633<br>(22) 2008122817 0.0585721<br>(23) 2008122818 0.0293247<br>(24) 2008122819 0.0349052<br>(25) 2008122820 0.0120921<br>(26) 2008122821 0.00302336<br>(27) 2008122822 0.000818031<b><br></b></div><div><b><br></b></div><div><b>---<br></b></div><div>Also: a non-starter for people who might look ... there are many:<br></div><div><b><br></b></div><div><b>warning:tofloat</b>: A bad value was passed to (string) tofloat, input strings must contain numeric digits, replacing with missing value<b><br></b></div><div>Why? One example ... note the '<span style="color:rgb(0,0,255)"><b>e</b></span>' . Maybe Excel or some other tool recognizes the but NCL does not. NCL return an _FillValue.</div><div> <br></div><div>2008,12,28,22,38,52,270.5,0,0,1.27150982867121<span style="color:rgb(0,0,255)"><b>e</b></span>,5,,,</div><div><br></div><div>Other lines also have some ?hidden? not recognized values.</div><div><br></div><div><b>%></b> ncl import.ncl <br></div><div><br></div><div>===</div><div><br></div><div><b></b></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Jun 22, 2019 at 5:27 PM Zach Rieck via ncl-talk <<a href="mailto:ncl-talk@ucar.edu" target="_blank">ncl-talk@ucar.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">To Whom it May Concern-<div><br></div><div>I'm having a great deal of trouble sorting out how to deal with the times on this data file (attached). The times provided are by the minute and need to be converted into hourly averages for slw. The biggest issues are that both the 1st data value and last data value occur during the middle of the day in the middle of an hour. So
I'm needing to skip a number of lines so the data starts and ends on an even hour. </div><div><br></div><div>Further complicating things is the fact that the WRF data I'm using is Oct-Mar (with Oct skipped), but April is included in this file. So if I include the WRF file for Apr-June, I will have to skip 2 additional months for every year.</div><div><br></div><div> Please advise on the easiest way to deal with these issues. I've attached my code as well, which works for a general import of the data, but none of the times match up yet.</div><div><br></div><div>Thanks in advance, and please let me know if anything isn't clear or can be explained better.</div><div><br></div><div>Respectfully,</div><div class="gmail_chip gmail_drive_chip" style="width:396px;height:18px;max-height:18px;background-color:rgb(245,245,245);padding:5px;font-family:arial;font-weight:bold;font-size:13px;border:1px solid rgb(221,221,221);line-height:1"><a href="https://drive.google.com/file/d/1f9Mv5gV4BCadRzAOtAr1YXUODcawlYPx/view?usp=drive_web" style="display:inline-block;max-width:366px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;text-decoration-line:none;padding:1px 0px;border:medium none" target="_blank"><img style="vertical-align: bottom; border: medium none;" src="https://ssl.gstatic.com/docs/doclist/images/icon_10_generic_list.png"> <span dir="ltr" style="vertical-align:bottom;text-decoration:none">Cedar_Creek_Radiometer.csv</span></a><img style="opacity: 0.55; float: right; display: none;"></div><div><br clear="all"><div><div dir="ltr" class="gmail-m_1887727328475818066gmail-m_3675809510345508291gmail-m_5414925937260266773gmail_signature"><div dir="ltr">-Zach Rieck<div><a href="mailto:zrr817@gmail.com" target="_blank">zrr817@gmail.com</a></div><div>(513)-502-5652</div></div></div></div></div></div>
_______________________________________________<br>
ncl-talk mailing list<br>
<a href="mailto:ncl-talk@ucar.edu" target="_blank">ncl-talk@ucar.edu</a><br>
List instructions, subscriber options, unsubscribe:<br>
<a href="http://mailman.ucar.edu/mailman/listinfo/ncl-talk" rel="noreferrer" target="_blank">http://mailman.ucar.edu/mailman/listinfo/ncl-talk</a><br>
</blockquote></div>