有一个数据框有 1w行,20列,想把其中的一些列相加后生成新的数据框,用R怎么实现:
比如说已有数据是这样的
| ID | CF | ZW | MT | FIX | RD | ND | CB | ICS |
1000189916 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
1000305179 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 0 |
1001642890 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
1001642915 | 1185517 | 0 | 0 | 0 | 0 | 12430.339 | 0 | 0 |
1001642917 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
1001642935 | 13084537 | 0 | 0 | 0 | 10052.6 | 0 | 0 | 0 |
1001643005 | 5812329 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
想得到一个这样的数据
| ID | CF+ZW | MT+FIX+RD | ND | CB | ICS |
1E+09 | 0 | 0 | 0 | 0 | 0 |
1E+09 | 0 | 0 | 0 | 100 | 0 |
1E+09 | 0 | 0 | 0 | 0 | 0 |
1E+09 | 1185517 | 0 | 12430.34 | 0 | 0 |
1E+09 | 0 | 0 | 0 | 0 | 0 |
1E+09 | 13084537 | 10052.6 | 0 | 0 | 0 |
1E+09 | 5812329 | 0 | 0 | 0 | 0 |