transgenesis
New Member
- Joined
- May 11, 2018
- Messages
- 3
Hello,
I have a dataset corresponding to snowfall sum per day, for a number of years (30+). There are often blanks for certain days. Where there is a blank day in a month, I wish to set the entire month (every day in the month) a value M (for missing) or set the entire month blank, either is fine. The data looks as such, days and years are received sequentially. Any ideas on where to start?
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
I have a dataset corresponding to snowfall sum per day, for a number of years (30+). There are often blanks for certain days. Where there is a blank day in a month, I wish to set the entire month (every day in the month) a value M (for missing) or set the entire month blank, either is fine. The data looks as such, days and years are received sequentially. Any ideas on where to start?
Month | Day | Year | Snowfall |
12 | 1 | 2010 | 0 |
12 | 2 | 2010 | 0 |
12 | 3 | 2010 | 0 |
12 | 4 | 2010 | 0 |
12 | 5 | 2010 | 0 |
12 | 6 | 2010 | 0 |
12 | 7 | 2010 | 0 |
12 | 8 | 2010 | 0 |
12 | 9 | 2010 | 0 |
12 | 10 | 2010 | 0 |
12 | 11 | 2010 | 0.2 |
12 | 12 | 2010 | 0 |
12 | 13 | 2010 | 0 |
12 | 14 | 2010 | 0 |
12 | 15 | 2010 | 0 |
12 | 16 | 2010 | 0 |
12 | 17 | 2010 | 0 |
12 | 18 | 2010 | 0 |
12 | 19 | 2010 | 0 |
12 | 20 | 2010 | 0 |
12 | 21 | 2010 | 0 |
12 | 22 | 2010 | 0 |
12 | 23 | 2010 | 0 |
12 | 24 | 2010 | 0 |
12 | 25 | 2010 | 0 |
12 | 26 | 2010 | 0 |
12 | 27 | 2010 | 4 |
12 | 28 | 2010 | 2.2 |
12 | 29 | 2010 | 0 |
12 | 30 | 2010 | 0 |
12 | 31 | 2010 | 0 |
1 | 1 | 2011 | |
1 | 2 | 2011 | |
1 | 3 | 2011 | |
1 | 4 | 2011 | |
1 | 5 | 2011 | |
1 | 6 | 2011 | |
1 | 7 | 2011 | |
1 | 8 | 2011 | 1.5 |
1 | 9 | 2011 | 1 |
1 | 10 | 2011 | |
1 | 11 | 2011 | |
1 | 12 | 2011 | 9 |
1 | 13 | 2011 | 4.5 |
1 | 14 | 2011 | |
1 | 15 | 2011 | |
1 | 16 | 2011 | 0.4 |
1 | 17 | 2011 | |
1 | 18 | 2011 | 1.8 |
1 | 19 | 2011 | 3 |
1 | 20 | 2011 | 0 |
1 | 21 | 2011 | 4.5 |
1 | 22 | 2011 | 0 |
1 | 23 | 2011 | |
1 | 24 | 2011 | |
1 | 25 | 2011 | 1.5 |
1 | 26 | 2011 | 0.3 |
1 | 27 | 2011 | 4 |
1 | 28 | 2011 | |
1 | 29 | 2011 | 0.2 |
1 | 30 | 2011 | |
1 | 31 | 2011 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>