| no. | id | year | var1 | var2 | var3 |
| 1 | 1 | 2000 | 50 | . | . |
| 2 | 1 | 2000 | . | . | 10 |
| 3 | 2 | 2001 | . | . | 500 |
| 4 | 2 | 2001 | 200 | . | . |
| 5 | 3 | 2002 | . | 300 | . |
| 6 | 3 | 2002 | . | . | 100 |
| no. | id | year | var1 | var2 | var3 |
| 1 | 1 | 2000 | 50 | . | 10 |
| 2 | 2 | 2001 | 200 | . | 500 |
| 3 | 3 | 2002 | . | 300 | 100 |
Combining observations with the same year and id in a single dataset
I have some data that looks like this:
I want to combine all observations which share an id and year so that the data looks like this:
Any help is appreciated.
0 Response to Combining observations with the same year and id in a single dataset
Post a Comment