Re: [R] subset dataframe

Mon, 22 Apr 2013 17:14:14 -0700 

Thanks Arun,

Jorge,s idea worked... I can't believe I lost so much time with this...

 
mike


>________________________________
> From:arun <smartpink...@yahoo.com>
>To: Mihai Nica <mihain...@yahoo.com> 
>Cc: R help <r-help@r-project.org> 
>Sent: Monday, April 22, 2013 4:57 PM
>Subject:Re: [R] subset dataframe
> 
>
>HI,
>Could you provide an example dataset?
>
>set.seed(15)
>agoa<- data.frame(X.1=rep(c("AGOA","GSP","CST"),3),X1996= 
>sample(1:20000,9,replace=TRUE),X2000=sample(40:30000,9,replace=TRUE))
> str(agoa)
>#'data.frame':    9 obs. of  3 variables:
># $ X.1  : Factor w/ 3 levels "AGOA","CST","GSP": 1 3 2 1 3 2 1 3 2
># $ X1996: int  12043 3901 19330 13019 7342 19778 16304 5080 13745
># $ X2000: int  24950 3175 19399 15292 21211 25875 25260 13445 28942
>
>
> subset(agoa,X.1=="AGOA")
> #  X.1 X1996 X2000
>#1 AGOA 12043 24950
>#4 AGOA 13019 15292
>#7 AGOA 16304 25260
>agoa[agoa$X.1=="AGOA",]
> #  X.1 X1996 X2000
>#1 AGOA 12043 24950
>#4 AGOA 13019 15292
>#7 AGOA 16304 25260
>A.K.
>
>
>________________________________
>From: Mihai Nica <mihain...@yahoo.com>
>To: "r-help@r-project.org" <r-help@r-project.org> 
>Sent: Monday, April 22, 2013 5:14 PM
>Subject: [R] subset dataframe
>
>
>I can't understand what is happening. This is the code and results:
>
>> agoa <- read.table(file = 
>>"C:/Users/HTPC/Documents/_Documents/Research/WithDidia/AGOAUSImports.txt", 
>>header = T, sep = "\t", dec = ".", na.strings = "NA", stringsAsFactors = 
>>T)#
>> str(agoa); names(agoa)
>
>'data.frame':109 obs. of  19 variables:
> $ X    : Factor w/ 39 levels "Angola ","Benin ",..: 1 1 1 2 2 3 3 3 4 4 ...
> $ X.1  : Factor w/ 3 levels "AGOA ","GSP ",..: 3 1 2 3 2 3 1 2 3 1 ...
> $ X1996: int  2687143 0 2 18084 70 23356 0 3624 3835 0 ...
> $ X1997: int  2427824 0 356492 4303 3437 18758 0 5882 930 0 ...
> $ X1998: int  1205545 0 1045996 1335 2269 14010 0 5660 503 0 ...
> $ X1999: int  1596052 0 828761 6042 11788 12071 0 4824 2695 0 ...
> $ X2000: int  2178246 0 1378777 1026 1414 38024 0 2922 502 0 ...
> $ X2001: int  464083 0 2635482 1108 178 19429 0 1221 4919 0 ...
> $ X2002: int  386118 0 2728387 680 0 25014 3707 871 2862 0 ...
> $ X2003: int  441647 0 3822701 602 0 7293 6343 0 788 0 ...
> $ X2004: int  471009 1349411 2700750 1310 215 52840 20119 7 474 0 ...
> $ X2005: int  1081143 3662774 3740324 509 4 148102 30044 7 1962 0 ...
> $ X2006: int  1670746 4127605 5920870 531 24 224382 27688 27 954 6 ...
> $ X2007: int  2346392 3898345 6262784 5076 0 155818 31331 304 1415 0 ...
> $ X2008: int  8151345 8119377 2639949 31010 0 202938 15803 104 495 0 ...
> $ X2009: int  5257573 3018965 1062246 425 16 119540 12362 8 2096 0 ...
> $ X2010: int  6542843 4741574 662450 271 4 158147 11559 8 2368 2 ...
> $ X2011: int  8423316 5174087 70 1957 14 276223 15479 1585 3599 2 ...
> $ X2012: int  8017601 1761068 45196 2625 49 204337 10427 1757 2233 5 ...
>
> [1] "X"     "X.1"   "X1996" "X1997" "X1998" "X1999" "X2000" "X2001" 
>"X2002"
>[10] "X2003" "X2004" "X2005" "X2006" "X2007" "X2008" "X2009" "X2010" "X2011"
>[19] "X2012"
>
>> agoa.AGOA <- subset(agoa, agoa$X.1 == "AGOA")
>> str(agoa.AGOA)
>
>'data.frame':0 obs. of  19 variables:
> $ X    : Factor w/ 39 levels "Angola ","Benin ",..: 
> $ X.1  : Factor w/ 3 levels "AGOA ","GSP ",..: 
> $ X1996: int 
> $ X1997: int 
> $ X1998: int 
> $ X1999: int 
> $ X2000: int 
> $ X2001: int 
> $ X2002: int 
> $ X2003: int 
> $ X2004: int 
> $ X2005: int 
> $ X2006: int 
> $ X2007: int 
> $ X2008: int 
> $ X2009: int 
> $ X2010: int 
> $ X2011: int 
> $ X2012: int 
>> 
>> 
>​I did try :
>
>agoa.AGOA = agoa[X.1 == AGOA,]
>
>with similar results.  All the help I looked over gives these as solutions...
> 
>mike
>    [[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.
>
>
        [[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.

Reply via email to