On 02/28/2011 07:49 PM, Muzna Alvi wrote:
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
Hi Muzna,
Try quoting those column names, otherwise the interpreter will think you
are asking it to do simple arithmetic:
ricefile1$areachange<-
100*(ricefile1$'1990'-ricefile1$'1960')/ricefile1$'1990'
Jim
______________________________________________
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.
