I'm havinf a problem with a simple file
i have the following data
State 1960 1970 1980 1990
1 All India 35988.70 37346.00 39707.30 42321.00
2 Andhra Pradesh 3431.03 3163.27 3687.23 3695.63
3 Assam 1902.93 2001.60 2278.47 2525.33
4 Bihar 5277.07 5133.80 5138.70 4662.57
5 Gujarat 538.13 456.10 484.23 590.47
6 Haryana 169.33 283.67 489.00 698.67
7 Himachal Pradesh 99.38 99.30 97.07 82.50
8 Jammu & Kashmir 226.97 221.83 267.83 275.50
9 Karnataka 1084.37 1096.80 1126.43 1319.73
10 Kerala 802.97 874.57 795.67 528.97
11 Madhya Pradesh 4258.87 4495.97 4857.37 5170.73
12 Maharashtra 1352.57 1324.07 1501.77 1555.10
13 Orissa 4359.63 4544.33 4136.10 4515.53
14 Punjab 262.93 438.47 1255.67 2106.00
15 Rajasthan 111.83 129.57 142.80 140.87
16 Tamil Nadu 2640.90 2742.60 2195.40 2202.87
17 Uttar Pradesh 4358.80 4553.03 5248.03 5419.23
18 West Bengal 4549.07 5005.47 5082.57 5763.07
i have to find out the percentage in area under rice cultivation from 1960
and 1990 for all india and for each of the states
but for some reason when i am using the command
(1990-1960)/1990*100-> ricefile1$areachange
the areachange column is showing the following (it is showing the area
change only for all india and replicating itt for all the states as well
State 1960 1970 1980 1990 areachange
1 All India 35988.70 37346.00 39707.30 42321.00 1.507538
2 Andhra Pradesh 3431.03 3163.27 3687.23 3695.63 1.507538
3 Assam 1902.93 2001.60 2278.47 2525.33 1.507538
4 Bihar 5277.07 5133.80 5138.70 4662.57 1.507538
5 Gujarat 538.13 456.10 484.23 590.47 1.507538
6 Haryana 169.33 283.67 489.00 698.67 1.507538
7 Himachal Pradesh 99.38 99.30 97.07 82.50 1.507538
8 Jammu & Kashmir 226.97 221.83 267.83 275.50 1.507538
9 Karnataka 1084.37 1096.80 1126.43 1319.73 1.507538
10 Kerala 802.97 874.57 795.67 528.97 1.507538
11 Madhya Pradesh 4258.87 4495.97 4857.37 5170.73 1.507538
12 Maharashtra 1352.57 1324.07 1501.77 1555.10 1.507538
13 Orissa 4359.63 4544.33 4136.10 4515.53 1.507538
14 Punjab 262.93 438.47 1255.67 2106.00 1.507538
15 Rajasthan 111.83 129.57 142.80 140.87 1.507538
16 Tamil Nadu 2640.90 2742.60 2195.40 2202.87 1.507538
17 Uttar Pradesh 4358.80 4553.03 5248.03 5419.23 1.507538
18 West Bengal 4549.07 5005.47 5082.57 5763.07 1.507538
please help!
--
--
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
