Hi,

I've district-level migration data of India.


Say-
State no district no migration type 1 (percentage share)
1 1 39.7
1 2 21.5
2 3 15.3
2 4 17.2

I want to make tables like-
migration type 1 (%) districts that fall under this
1-10 0
10-20 3,4
20-30 2
30-40 1
40-50 0


How can I do that?

Also, later I want to see which state is affected most.

In the above tables, you can see that in state 2, nearly 10-20 per cent of type 1 migration is seen.

If I understand this I can also do the same for migration type 2,3,4 & 5.

Please advise,