关于不匹配数据如何并表的问题？有难度，希望高手帮忙

表1 dmu	year	gdzc	fz	fzygdqy	zczz	fzper
2	2000	3.38E+08	2.66E+09	5.62E+09	5.62E+09	0.472516
2	2001	3.10E+08	3.36E+09	6.48E+09	6.48E+09	0.517797
2	2002	3.49E+08	4.79E+09	8.22E+09	8.22E+09	0.582944
2	2003	2.68E+08	5.80E+09	1.06E+10	1.06E+10	0.549243
2	2004	2.31E+08	9.23E+09	1.55E+10	1.55E+10	0.594163
2	2005	2.36E+08	1.34E+10	2.20E+10	2.20E+10	0.60981
3	2000	7.11E+08	2.99E+09	2.49E+09	2.49E+09	1.199893
3	2001	2.30E+08	2.21E+09	1.21E+09	1.21E+09	1.819934
4	2000	79800000	3.87E+08	5.08E+08	5.08E+08	0.7621
4	2001	47200000	1.02E+08	2.22E+08	2.22E+08	0.460723
4	2002	45300000	1.40E+08	2.64E+08	2.64E+08	0.529541
4	2003	44700000	1.09E+08	2.38E+08	2.38E+08	0.46014
4	2004	40300000	91600000	2.14E+08	2.14E+08	0.427696
4	2005	32600000	55900000	1.56E+08	1.56E+08	0.358844
5	2000	6.92E+08	1.18E+09	2.02E+09	2.02E+09	0.58385
5	2001	7.52E+08	8.33E+08	1.92E+09	1.92E+09	0.432965
5	2002	7.25E+08	8.44E+08	1.82E+09	1.82E+09	0.463339
5	2003	7.21E+08	8.54E+08	1.78E+09	1.78E+09	0.479576
5	2004	6.11E+08	9.22E+08	1.81E+09	1.81E+09	0.509352
5	2005	5.95E+08	9.84E+08	1.64E+09	1.64E+09	0.598387
6	2000	3.42E+08	2.52E+09	3.79E+09	3.79E+09	0.666313
6	2001	2.22E+08	2.89E+09	4.22E+09	4.22E+09	0.684009
6	2002	1.92E+08	3.10E+09	4.49E+09	4.49E+09	0.690936
6	2003	1.87E+08	2.89E+09	3.97E+09	3.97E+09	0.727631
6	2004	2.24E+08	2.89E+09	4.02E+09	4.02E+09	0.718999
6	2005	1.05E+08	1.42E+09	2.55E+09	2.55E+09	0.557579
7	2000	3.47E+08	8.14E+08	9.52E+08	9.52E+08	0.855058
7	2001	3.76E+08	9.15E+08	1.10E+09	1.10E+09	0.82979
7	2002	4.82E+08	8.90E+08	1.15E+09	1.15E+09	0.773324
7	2003	5.00E+08	8.53E+08	1.12E+09	1.12E+09	0.763461
7	2004	4.30E+08	9.53E+08	1.05E+09	1.05E+09	0.909256
7	2005	3.98E+08	7.46E+08	8.54E+08	8.54E+08	0.872991
8	2000	61700000	1.67E+08	2.91E+08	2.91E+08	0.572953
8	2001	60800000	1.42E+08	1.08E+08	1.08E+08	1.321407
8	2002	55700000	1.03E+08	70600000	70600000	1.462868
8	2003	55000000	29900000	60500000	60500000	0.494502
8	2004	41900000	17900000	90800000	90800000	0.197632
8	2005	65300000	22600000	90600000	90600000	0.249367
9	2000	4.47E+08	3.27E+09	4.66E+09	4.66E+09	0.700563
9	2001	4.41E+08	2.75E+09	4.05E+09	4.05E+09	0.678623
9	2002	4.75E+08	2.84E+09	4.11E+09	4.11E+09	0.691098
9	2003	4.65E+08	2.95E+09	4.26E+09	4.26E+09	0.692499
9	2004	8.91E+08	3.30E+09	4.97E+09	4.97E+09	0.663205
9	2005	8.85E+08	3.18E+09	4.89E+09	4.89E+09	0.649825
10	2000	51500000	1.85E+08	3.52E+08	3.52E+08	0.525425
10	2001	25600000	1.29E+08	2.94E+08	2.94E+08	0.436982
10	2002	1.26E+08	3.40E+08	6.50E+08	6.50E+08	0.522747
10	2003	1.44E+08	5.22E+08	8.67E+08	8.67E+08	0.602121
10	2004	1.90E+08	5.16E+08	8.62E+08	8.62E+08	0.598615
10	2005	44500000	2.80E+08	3.53E+08	3.53E+08	0.791249
11	2000	2.19E+08	2.37E+09	2.67E+09	2.67E+09	0.887544
11	2001	1.98E+08	2.14E+09	2.45E+09	2.45E+09	0.873626
11	2002	2.88E+08	2.27E+09	2.61E+09	2.61E+09	0.870435
11	2003	2.90E+08	1.96E+09	2.44E+09	2.44E+09	0.805425
11	2004	2.78E+08	1.74E+09	2.30E+09	2.30E+09	0.753737
11	2005	2.48E+08	1.14E+09	1.79E+09	1.79E+09	0.637241
12	2000	1.73E+09	9.35E+08	2.82E+09	2.82E+09	0.330891
12	2001	1.82E+09	8.18E+08	2.70E+09	2.70E+09	0.30314
12	2002	2.16E+09	1.00E+09	2.99E+09	2.99E+09	0.335463
12	2003	2.64E+09	1.31E+09	3.52E+09	3.52E+09	0.373424
12	2004	3.67E+09	2.28E+09	4.74E+09	4.74E+09	0.481675
12	2005	4.49E+09	2.81E+09	5.52E+09	5.52E+09	0.508313

现有数据集如表1和表2，数据单元并不匹配，就是说表1中的相同公司的年数可能表2的数据长，现希望如果数据年相同和公司相同的并到一行，而如果表1中年数多，而表2中年数少则将表2中的同一公司相同年的数据贴补空白，就是将数据1和数据2的长度达到相同，请问这个怎么并表呢？

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：不匹配 数据集 数据 高手 帮忙 难度

表1

dmu	year	gdzc	fz	fzygdqy	zczz	fzper
2	2000	3.38E+08	2.66E+09	5.62E+09	5.62E+09	0.472516
2	2001	3.10E+08	3.36E+09	6.48E+09	6.48E+09	0.517797
2	2002	3.49E+08	4.79E+09	8.22E+09	8.22E+09	0.582944
2	2003	2.68E+08	5.80E+09	1.06E+10	1.06E+10	0.549243
2	2004	2.31E+08	9.23E+09	1.55E+10	1.55E+10	0.594163
2	2005	2.36E+08	1.34E+10	2.20E+10	2.20E+10	0.60981
3	2000	7.11E+08	2.99E+09	2.49E+09	2.49E+09	1.199893
3	2001	2.30E+08	2.21E+09	1.21E+09	1.21E+09	1.819934
4	2000	79800000	3.87E+08	5.08E+08	5.08E+08	0.7621
4	2001	47200000	1.02E+08	2.22E+08	2.22E+08	0.460723
4	2002	45300000	1.40E+08	2.64E+08	2.64E+08	0.529541
4	2003	44700000	1.09E+08	2.38E+08	2.38E+08	0.46014
4	2004	40300000	91600000	2.14E+08	2.14E+08	0.427696
4	2005	32600000	55900000	1.56E+08	1.56E+08	0.358844
5	2000	6.92E+08	1.18E+09	2.02E+09	2.02E+09	0.58385
5	2001	7.52E+08	8.33E+08	1.92E+09	1.92E+09	0.432965
5	2002	7.25E+08	8.44E+08	1.82E+09	1.82E+09	0.463339
5	2003	7.21E+08	8.54E+08	1.78E+09	1.78E+09	0.479576
5	2004	6.11E+08	9.22E+08	1.81E+09	1.81E+09	0.509352
5	2005	5.95E+08	9.84E+08	1.64E+09	1.64E+09	0.598387
6	2000	3.42E+08	2.52E+09	3.79E+09	3.79E+09	0.666313
6	2001	2.22E+08	2.89E+09	4.22E+09	4.22E+09	0.684009
6	2002	1.92E+08	3.10E+09	4.49E+09	4.49E+09	0.690936
6	2003	1.87E+08	2.89E+09	3.97E+09	3.97E+09	0.727631
6	2004	2.24E+08	2.89E+09	4.02E+09	4.02E+09	0.718999
6	2005	1.05E+08	1.42E+09	2.55E+09	2.55E+09	0.557579
7	2000	3.47E+08	8.14E+08	9.52E+08	9.52E+08	0.855058
7	2001	3.76E+08	9.15E+08	1.10E+09	1.10E+09	0.82979
7	2002	4.82E+08	8.90E+08	1.15E+09	1.15E+09	0.773324
7	2003	5.00E+08	8.53E+08	1.12E+09	1.12E+09	0.763461
7	2004	4.30E+08	9.53E+08	1.05E+09	1.05E+09	0.909256
7	2005	3.98E+08	7.46E+08	8.54E+08	8.54E+08	0.872991
8	2000	61700000	1.67E+08	2.91E+08	2.91E+08	0.572953
8	2001	60800000	1.42E+08	1.08E+08	1.08E+08	1.321407
8	2002	55700000	1.03E+08	70600000	70600000	1.462868
8	2003	55000000	29900000	60500000	60500000	0.494502
8	2004	41900000	17900000	90800000	90800000	0.197632
8	2005	65300000	22600000	90600000	90600000	0.249367
9	2000	4.47E+08	3.27E+09	4.66E+09	4.66E+09	0.700563
9	2001	4.41E+08	2.75E+09	4.05E+09	4.05E+09	0.678623
9	2002	4.75E+08	2.84E+09	4.11E+09	4.11E+09	0.691098
9	2003	4.65E+08	2.95E+09	4.26E+09	4.26E+09	0.692499
9	2004	8.91E+08	3.30E+09	4.97E+09	4.97E+09	0.663205
9	2005	8.85E+08	3.18E+09	4.89E+09	4.89E+09	0.649825
10	2000	51500000	1.85E+08	3.52E+08	3.52E+08	0.525425
10	2001	25600000	1.29E+08	2.94E+08	2.94E+08	0.436982
10	2002	1.26E+08	3.40E+08	6.50E+08	6.50E+08	0.522747
10	2003	1.44E+08	5.22E+08	8.67E+08	8.67E+08	0.602121
10	2004	1.90E+08	5.16E+08	8.62E+08	8.62E+08	0.598615
10	2005	44500000	2.80E+08	3.53E+08	3.53E+08	0.791249
11	2000	2.19E+08	2.37E+09	2.67E+09	2.67E+09	0.887544
11	2001	1.98E+08	2.14E+09	2.45E+09	2.45E+09	0.873626
11	2002	2.88E+08	2.27E+09	2.61E+09	2.61E+09	0.870435
11	2003	2.90E+08	1.96E+09	2.44E+09	2.44E+09	0.805425
11	2004	2.78E+08	1.74E+09	2.30E+09	2.30E+09	0.753737
11	2005	2.48E+08	1.14E+09	1.79E+09	1.79E+09	0.637241
12	2000	1.73E+09	9.35E+08	2.82E+09	2.82E+09	0.330891
12	2001	1.82E+09	8.18E+08	2.70E+09	2.70E+09	0.30314
12	2002	2.16E+09	1.00E+09	2.99E+09	2.99E+09	0.335463
12	2003	2.64E+09	1.31E+09	3.52E+09	3.52E+09	0.373424
12	2004	3.67E+09	2.28E+09	4.74E+09	4.74E+09	0.481675
12	2005	4.49E+09	2.81E+09	5.52E+09	5.52E+09	0.508313

表2

dmu	year	国家股	法人股	管理人股	流通股
2	2003	0.075714	0.082857	0	0.665
2	2004	0.069604	0.076212	0	0.696035
2	2005	0.096505	0	0.000649	0.717742
2	2006	0.090428	0	0.000609	0.735516
3	2000	0	0	0	0.576577
4	2006	0.347619	0	0.000649	0.619048
5	2000	0	0.010555	0	0.473684
5	2001	0	0.009228	0	0.527504
7	2006	0.038551	0	0	0.654054
8	2003	0.082974	0.341927	0	0.478969
8	2005	0	0	1.22E-06	0.573948
9	2000	0.228363	0	0	0.604797
12	2001	0	0.04195	0	0.15805
12	2005	0.128431	0.041765	0.000136	0.157843

就是如何将2-12这些数据都对齐，并在空白出添上数据

help merge

 谢谢，我试试先

有空能不能先看看那本医学统计的书啊

上面这些基础的都讲了。

https://bbs.pinggu.org/thread-188730-1-1.html&page=1

不是没找到书么。。。。。

这边这么贵买不起，到学校图书馆借不到。。。。。。。。。。