求助:下表中,如何编程得出y的值?
规则如下:
1、若同一编号中所有年份的x值全为0,则所有y值等于该编号第一年的年份值,如编号2所示;
2、若同一编号中所有年份的x值全为1,则所有y值等于该编号第一年的年份值,如编号2808所示;
3、若同一编号中前一部分x值为0,后面的全为1,则所有y值等于该编号首次x值为1的年份值,如编号21所示;
4、若同一编号中前一部分x值为0,接着部分值为1,最后部分值为0,则y值如编号4所示,即前一部分y值为该编号首次x值为1的年份值,后部分的y值等于x再次为0时的年份值。
| 编号 | 年份 | x | y |
| 2 | 2018 | 0 | 2018 |
| 2 | 2019 | 0 | 2018 |
| 4 | 2013 | 0 | 2015 |
| 4 | 2014 | 0 | 2015 |
| 4 | 2015 | 1 | 2015 |
| 4 | 2016 | 1 | 2015 |
| 4 | 2017 | 1 | 2015 |
| 4 | 2018 | 0 | 2018 |
| 4 | 2019 | 0 | 2018 |
| 21 | 2013 | 0 | 2017 |
| 21 | 2014 | 0 | 2017 |
| 21 | 2015 | 0 | 2017 |
| 21 | 2016 | 0 | 2017 |
| 21 | 2017 | 1 | 2017 |
| 21 | 2018 | 1 | 2017 |
| 21 | 2019 | 1 | 2017 |
| 2808 | 2016 | 1 | 2016 |
| 2808 | 2017 | 1 | 2016 |
| 2808 | 2018 | 1 | 2016 |
| 2808 | 2019 | 1 | 2016 |
| 21 | 2013 | 0 | 2017 |
| 21 | 2014 | 0 | 2017 |
| 21 | 2015 | 0 | 2017 |
| 21 | 2016 | 0 | 2017 |
| 21 | 2017 | 1 | 2017 |
| 21 | 2018 | 1 | 2017 |
| 21 | 2019 | 1 | 2017 |
| 26 | 2013 | 0 | 2013 |
| 26 | 2014 | 0 | 2013 |
| 26 | 2015 | 0 | 2013 |
| 26 | 2016 | 0 | 2013 |
| 26 | 2017 | 0 | 2013 |
| 26 | 2018 | 0 | 2013 |
| 26 | 2019 | 0 | 2013 |
| 38 | 2016 | 0 | 2016 |
| 38 | 2017 | 0 | 2016 |
| 38 | 2018 | 0 | 2016 |
| 38 | 2019 | 0 | 2016 |
| 39 | 2013 | 1 | 2013 |
| 39 | 2014 | 1 | 2013 |
| 39 | 2015 | 1 | 2013 |
| 39 | 2016 | 0 | 2016 |
| 39 | 2017 | 0 | 2016 |
| 39 | 2018 | 0 | 2016 |
| 39 | 2019 | 0 | 2016 |
| 39 | 2020 | 0 | 2016 |
| 40 | 2016 | 0 | 2016 |
| 40 | 2017 | 0 | 2016 |
| 40 | 2018 | 0 | 2016 |
| 40 | 2019 | 0 | 2016 |