小白求助!谢谢各位大神~数据为2012年全球200多个国家双边贸易数据,想要根据i(出口国)、j(进口国)、k(商品编码)进行加总,最终得到各进口国(j)从全部出口国(i)分编码(k)的贸易总额(加总的v)
数据如下格式(总数据大概有700W条):
| t | i | j | k | v | q |
2012 | 4 | 8 | 610469 | 2.734 | 0.044 |
2012 | 4 | 12 | 91099 | 1.185 | 1.2 |
2012 | 4 | 24 | 80110 | 41.25777 | 4.67 |
2012 | 4 | 24 | 90412 | 1.394852 | 0.149 |
2012 | 4 | 24 | 90620 | 2.711423 | 0.299 |
2012 | 4 | 24 | 91099 | 14.73527 | 12.467 |
2012 | 4 | 24 | 843049 | 104.613 | 1.535 |
2012 | 4 | 24 | 848410 | 8.466 | 0.056 |
2012 | 4 | 24 | 890310 | 4.199 | 5.948 |
2012 | 4 | 32 | 392630 | 1.266145 | 0.123 |
2012 | 4 | 32 | 730729 | 2.018 | 0.1 |
2012 | 4 | 32 | 853400 | 5.53 | 0.028 |
2012 | 4 | 32 | 854140 | 1.168 | 0.069 |
2012 | 4 | 36 | 40310 | 12.44514 | 3.492 |
2012 | 4 | 36 | 80212 | 10.09012 | 4.12 |
2012 | 4 | 36 | 852510 | 3.494 | 0.033 |
2012 | 4 | 40 | 880330 | 5.072 | 0.118 |
2012 | 4 | 40 | 900211 | 1.201575 | 0.009 |
2012 | 4 | 40 | 903180 | 1.925 | 0.018 |
2012 | 8 | 112 | 620349 | 1.6 | 0.006 |
2012 | 8 | 112 | 640291 | 1.6 | 0.043 |
2012 | 8 | 112 | 640391 | 1.9 | 0.05 |
2012 | 8 | 112 | 640399 | 1.9 | 0.032 |
2012 | 8 | 120 | 841821 | 2.645 | 0.5 |
2012 | 8 | 120 | 870323 | 7.872 | 2 |
2012 | 8 | 120 | 940171 | 2.153 | 0.5 |
2012 | 8 | 124 | 70951 | 1.129838 | 0.016 |
2012 | 8 | 124 | 71080 | 3.181205 | 0.144069 |
2012 | 8 | 124 | 71230 | 3.283802 | 0.122 |
2012 | 8 | 124 | 71290 | 33.84065 | 8 |
2012 | 8 | 124 | 81340 | 18.50229 | 0.72 |
2012 | 8 | 124 | 90910 | 33.84271 | 4.542 |
2012 | 8 | 124 | 91099 | 141.2971 | 35.484 |
2012 | 8 | 124 | 121190 | 218.658 | 42.318 |