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