Hello,
I have a matrix of meteorological data in foll. format, with 1st column is for the year (1993 to 2014), 2nd column is month, 3rd column is day, 4th is hour, and the last column is value. The value of 4th column varies from 0 to 23 hr, making a full day. An winter period is defined as from previous year's month of October to next year March. Since it's hourly data, the total number of rows for each season should have 26064 rows (= 24 hr*6 months* 182 days) for nonleap years and 26352 rows (24 hr*6 months* 183 days) for leap years. I need to check whether the winter period of successive years has more than 25% of data (or 6516 for nonleap years/ 6588 for leap years) available. In case data is less than 25%, I have to check in which half of year more number of data are missing (for example in present case it is the year 1993) and exclude that year's rows completely from the output file while retaining the next year's row. Likewise, I have to check for all successive years from 1993 to 2014.
1993 10 1 0 2.441993 10 1 1 2.041993 10 1 2 1.791993 10 1 3 1.721993 10 1 4 1.3951993 10 1 5 1.1541993 10 1 6 0.9131993 10 1 7 0.6721993 10 1 8 0.4311993 10 1 9 0.191993 10 1 10 2.441993 10 1 11 2.041993 10 1 12 Nan1993 10 1 13 Nan1993 10 1 14 Nan1993 10 1 15 Nan1993 10 1 16 Nan1993 10 1 17 Nan1993 10 1 18 Nan1993 10 1 19 Nan1993 10 1 20 Nan1993 10 1 21 Nan1993 10 1 22 Nan1993 10 1 23 Nan................................... ................................... 1994 3 31 23 3.821994 3 31 23 3.91994 3 31 23 3.66
Best Answer