按流式数据固定周分组，统计周起止日期与达标Precipitation需求

现有一份气象数据集，其中第一列为日期（timestamp），倒数第二列为降水量（Precipitation）。需按以下规则分组统计：

• 第1周包含前7条数据，第2周包含接下来7条数据，以此类推
• 每组需输出：周起始日期（Week_start）、周结束日期（Week_end），以及该周内降水量≥3英寸的统计结果

示例数据 #

01/01/2014  USW00023234 SAN FRANCISCO INTERNATIONAL AIRPORT, CA US  49  41  56  0.89    0.00    0
02/01/2014  USW00023234 SAN FRANCISCO INTERNATIONAL AIRPORT, CA US  51  43  62  1.12    0.00    0
03/01/2014  USW00023234 SAN FRANCISCO INTERNATIONAL AIRPORT, CA US  52  44  64  4.03    0.00    0
04/01/2014  USW00023234 SAN FRANCISCO INTERNATIONAL AIRPORT, CA US  53  43  66  2.24    0.00    0
05/01/2014  USW00023234 SAN FRANCISCO INTERNATIONAL AIRPORT, CA US  55  44  66  4.92    0.00    0
06/01/2014  USW00023234 SAN FRANCISCO INTERNATIONAL AIRPORT, CA US  52  44  60  2.24    0.00    8
07/01/2014  USW00023234 SAN FRANCISCO INTERNATIONAL AIRPORT, CA US  53  46  61  4.47    0.00    8
08/01/2014  USW00023234 SAN FRANCISCO INTERNATIONAL AIRPORT, CA US  55  52  59  9.40    0.01    1
09/01/2014  USW00023234 SAN FRANCISCO INTERNATIONAL AIRPORT, CA US  54  52  60  11.63   0.00    1
10/01/2014  USW00023234 SAN FRANCISCO INTERNATIONAL AIRPORT, CA US  53  48  60  5.82    0.00    0
11/01/2014  USW00023234 SAN FRANCISCO INTERNATIONAL AIRPORT, CA US  51  46  58  6.49    0.00    0
12/01/2014  USW00023234 SAN FRANCISCO INTERNATIONAL AIRPORT, CA US  52  46  60  6.71    0.00    1
13/01/2014  USW00023234 SAN FRANCISCO INTERNATIONAL AIRPORT, CA US  55  42  67  2.68    0.00    0
14/01/2014  USW00023234 SAN FRANCISCO INTERNATIONAL AIRPORT, CA US  56  44  72  2.24    0.00    0
15/01/2014  USW00023234 SAN FRANCISCO INTERNATIONAL AIRPORT, CA US  58  48  73  2.68    0.00    0
16/01/2014  USW00023234 SAN FRANCISCO INTERNATIONAL AIRPORT, CA US  58  46  73  2.01    0.00    0

示例输出 #

Week_start  Week_end    Precipitation
01/01/2014  07/01/2014  3.1

内容的提问来源于stack exchange，提问作者Mainul Hasan