I need to drop the leading zeros of lots of separate variables. I have data like this:
| days | a | b | c | d | e |
| 1 | 3 | 0 | 0 | 0 | 0 |
| 2 | 1 | 0 | 0 | 0 | 0 |
| 3 | 0 | 0 | 0 | 0 | 0 |
| 4 | 0 | 0 | 0 | 0 | 0 |
| 5 | 1 | 0 | 0 | 0 | 0 |
| 6 | 1 | 0 | 0 | 0 | 1 |
| 7 | 0 | 0 | 0 | 0 | 0 |
| 8 | 3 | 0 | 0 | 1 | 1 |
| 9 | 2 | 0 | 1 | 0 | 0 |
| 10 | 1 | 0 | 0 | 0 | 0 |
| 11 | 6 | 0 | 2 | 1 | 0 |
| 12 | 6 | 2 | 0 | 1 | 0 |
| 13 | 9 | 0 | 2 | 0 | 1 |
| 14 | 4 | 0 | 0 | 0 | 0 |
| 15 | 5 | 0 | 0 | 0 | 1 |
| 16 | 5 | 0 | 0 | 0 | 0 |
| 17 | 4 | 0 | 0 | 0 | 0 |
| 18 | 0 | 0 | 0 | 0 | 0 |
And I would like to have data like this:
| days | a | b | c | d | e |
| 1 | 3 | 2 | 1 | 1 | 1 |
| 2 | 1 | 0 | 0 | 0 | 0 |
| 3 | 0 | 0 | 2 | 0 | 1 |
| 4 | 0 | 0 | 0 | 1 | 0 |
| 5 | 1 | 0 | 2 | 1 | 0 |
| 6 | 1 | 0 | 0 | 0 | 0 |
| 7 | 0 | 0 | 0 | 0 | 0 |
| 8 | 3 | 0 | 0 | 1 | |
| 9 | 2 | 0 | 0 | 0 | |
| 10 | 1 | 0 | 0 | 1 | |
| 11 | 6 | 0 | 0 | ||
| 12 | 6 | 0 | |||
| 13 | 9 | 0 | |||
| 14 | 4 | ||||
| 15 | 5 | ||||
| 16 | 5 | ||||
| 17 | 4 | ||||
| 18 | 0 |
Please help!
0 Response to Dropping leading zero observations within several variables
Post a Comment