I am trying to add individual information in few rows so that to have one row per individual.
The unique id for each individual can get using the first four columns: district, cluster, household, and person Ser no.
My file looks like this. ( I am giving an example for three individuals)
District | Cluster | household | Person Serial no. | No of labors | Acres | output value | cost | Income |
3 | 2 | 1 | 2 | 1 | 1 | 12000 | 6400 | 5600 |
3 | 2 | 1 | 2 | 4 | 2 | 11300 | 3200 | 8100 |
3 | 2 | 1 | 2 | 7 | 5 | 14700 | 1100 | 13600 |
5 | 12 | 3 | 1 | 6 | 2 | 5000 | 2000 | 3000 |
5 | 12 | 3 | 1 | 5 | 3 | 7800 | 4500 | 3300 |
7 | 4 | 2 | 2 | 4 | 1 | 8000 | 650 | 7350 |
7 | 4 | 2 | 2 | 3 | 1 | 8500 | 870 | 7630 |
7 | 4 | 2 | 2 | 2 | 2 | 3200 | 500 | 2700 |
7 | 4 | 2 | 2 | 1 | 1 | 4525 | 750 | 3775 |
Can anybody kindly help me, please?
Thank you very much in advance.
District | Cluster | household | Person Serial no. | No of labors | Acres own | out put value | cost | Income |
3 | 2 | 1 | 2 | 12 | 8 | 38000 | 10700 | 27300 |
5 | 12 | 3 | 1 | 11 | 5 | 12800 | 6500 | 6300 |
7 | 4 | 2 | 2 | 10 | 5 | 24225 | 2770 | 21455 |
0 Response to Add rows within the group
Post a Comment