这是我的第一张表（如下），是上市公司10-18年度的csr得分
| stkcd | year | csrf |
2 | 2010 | 64.2 |
2 | 2011 | 84.56 |
2 | 2012 | 86.71 |
2 | 2013 | 83.73 |
2 | 2014 | 70.74 |
2 | 2015 | 90 |
2 | 2016 | 76.43 |
2 | 2017 | 42.03 |
2 | 2018 | 40.25 |
4 | 2010 | 13.5 |
4 | 2011 | 19.64 |
4 | 2012 | 19.68 |
4 | 2013 | 19.38 |
4 | 2014 | 17.99 |
4 | 2015 | 18.52 |
4 | 2016 | 20.66 |
4 | 2017 | 20.48 |
4 | 2018 | 7.92 |
7 | 2011 | 15.41 |
7 | 2012 | 9.43 |
7 | 2013 | 15.22 |
7 | 2014 | -8.4 |
7 | 2015 | 7.25 |
7 | 2016 | 9.27 |
7 | 2017 | 20.84 |
7 | 2018 | 0.85 |
表2是违规上市公司，如下图
| stkcd | year | fraudtype | fraud_dummy |
4 | 2010 | 1 | 1 |
4 | 2013 | 3 | 1 |
4 | 2015 | 3 | 1 |
4 | 2017 | 3 | 1 |
4 | 2018 | 3 | 1 |
4 | 2019 | 3 | 1 |
7 | 2014 | 2 | 1 |
7 | 2015 | 3 | 1 |
7 | 2016 | 2 | 1 |
7 | 2019 | 2 | 1 |
黄老师说考虑表1和表2merge，但这只能得到违规公司的csr得分。我要的是整个上市公司的违规情况和csr得分，也即怎么处理两张表使得在保留表1主体的情况下能够使表2的内容替换和表1重复的部分？蓝色版主说的考虑用append的话，结果如下：
| stkcd | year | csrf | fraudtype | fraud_dummy |
2 | 2010 | 64.2 | | |
2 | 2011 | 84.56 | | |
2 | 2012 | 86.71 | | |
2 | 2013 | 83.73 | | |
2 | 2014 | 70.74 | | |
2 | 2015 | 90 | | |
2 | 2016 | 76.43 | | |
2 | 2017 | 42.03 | | |
2 | 2018 | 40.25 | | |
4 | 2010 | 13.5 | | |
4 | 2011 | 19.64 | | |
4 | 2012 | 19.68 | | |
4 | 2013 | 19.38 | | |
4 | 2014 | 17.99 | | |
4 | 2015 | 18.52 | | |
4 | 2016 | 20.66 | | |
4 | 2017 | 20.48 | | |
4 | 2018 | 7.92 | | |
7 | 2011 | 15.41 | | |
7 | 2012 | 9.43 | | |
7 | 2013 | 15.22 | | |
7 | 2014 | -8.4 | | |
7 | 2015 | 7.25 | | |
7 | 2016 | 9.27 | | |
7 | 2017 | 20.84 | | |
7 | 2018 | 0.85 | | |
4 | 2010 | | 1 | 1 |
4 | 2013 | | 3 | 1 |
4 | 2015 | | 3 | 1 |
4 | 2017 | | 3 | 1 |
4 | 2018 | | 3 | 1 |
4 | 2019 | | 3 | 1 |
7 | 2014 | | 2 | 1 |
7 | 2015 | | 3 | 1 |
7 | 2016 | | 2 | 1 |
7 | 2019 | | 2 | 1 |
即如何处理才能得到以下结果？？
| stkcd | year | csrf | fraudtype | fraud_dummy |
2 | 2010 | 64.2 | | |
2 | 2011 | 84.56 | | |
2 | 2012 | 86.71 | | |
2 | 2013 | 83.73 | | |
2 | 2014 | 70.74 | | |
2 | 2015 | 90 | | |
2 | 2016 | 76.43 | | |
2 | 2017 | 42.03 | | |
2 | 2018 | 40.25 | | |
4 | 2010 | 13.5 | 1 | 1 |
4 | 2011 | 19.64 | | |
4 | 2012 | 19.68 | | |
4 | 2013 | 19.38 | 3 | 1 |
4 | 2014 | 17.99 | | |
4 | 2015 | 18.52 | 3 | 1 |
4 | 2016 | 20.66 | | |
4 | 2017 | 20.48 | 3 | 1 |
4 | 2018 | 7.92 | 3 | 1 |
7 | 2011 | 15.41 | | |
7 | 2012 | 9.43 | | |
7 | 2013 | 15.22 | | |
7 | 2014 | -8.4 | 2 | 1 |
7 | 2015 | 7.25 | 3 | 1 |
7 | 2016 | 9.27 | 2 | 1 |
7 | 2017 | 20.84 | | |
7 | 2018 | 0.85 | | |
扫码加好友，拉您进群
全部版块
我的主页
收藏
