- Thread Author
- #1
I have the below DF
Expected Output
I HAVE CREATED THE COULUMN INDEX FOR SUMMING BUT I COULDN'T ABLE TO LOOP EACH COLUMNS INDED AND GET THE INTENTED OUTPUT.
A | B | C | D | COLUMNS |
---|---|---|---|---|
1 | ABC | ABC | 2,3 | |
DEF | ABC | DEF | 2,4 | |
LSD | LSD | LSD | 2,4 | |
ERR | ERR | 2,3 | ||
ERR | ABC | LSD | 2,4 |
A-1 | B-2 | C-3 | D-4 | F-5 | COLUMNS INDEX | ABC | DEF | ERR | LSD |
---|---|---|---|---|---|---|---|---|---|
1 | ABC | ABC | 2,3 | 2 | 0 | 0 | 0 | ||
DEF | ABC | DEF | DEF | 2,4 | 1 | 2 | 0 | 0 | |
LSD | LSD | LSD | LSD | 2,3 | 0 | 0 | 0 | 2 | |
ERR | ERR | 2,3 | 0 | 0 | 2 | 0 | |||
ERR | ABC | LSD | LSD | 2,4 | 1 | 0 | 1 | 1 |