[R] Problem with combined two data frame.

Den d.kazakiewicz at gmail.com
Sun Jan 23 07:11:38 CET 2011


Hi 
So let's call first data frame df1 and second df2
#replace NA with 2.36
df2y <- lapply(df2, function(x) (ifelse( is.na(x), 2.36,x)))

#combibe
both <- rbind(df1, df2)

With best regards
Denis


У Няд, 23/01/2011 у 12:41 +0700, Jumlong Vongprasert піша:
> Dear All.
> I have some problem with combined two data frame.
> ....
> I have first data frame ..
> 
>      GPAX THAI MATH SCINCE SOCIAL HEALT  ART CAREER LANGUAGE
> 1227 2.99 3.32 2.50   2.64   3.05  3.60 3.72   3.57     2.62
> 1704 2.81 2.56 2.48   2.86   3.22  3.19 3.55   3.20     2.51
> 617  2.18 1.90 1.97   2.06   2.38  3.50 3.54   2.33     1.70
> 876  2.82 3.14 2.73   2.46   2.71  3.11 3.04   3.24     2.90
> 1699 3.00 2.61 2.50   2.71   3.52  3.82 3.51   3.79     2.71
> 1054 2.64 2.94 2.00   2.35   3.05  3.81 3.59   2.98     1.99
> 31   2.73 2.86 2.34   2.57   3.03  3.35 3.24   3.18     2.24
> 164  2.74 2.95 2.10   2.64   2.82  3.51 3.33   3.32     2.37
> 1742 2.24 2.43 1.82   1.65   2.53  3.35 2.51   2.40     2.05
> 436  2.63 2.58 2.11   2.17   2.74  3.44 3.67   3.31     2.90
> 453  2.67 2.46 1.90   2.44   3.10  3.74 3.38   3.11     1.92
> 
> and second data frame
> 
>     GPAX THAI MATH SCINCE SOCIAL HEALT  ART CAREER LANGUAGE
> 156   NA 3.38 2.78   3.01   3.49  3.83 3.67   3.73     2.92
> 
> and y = 2.36
> 
> 1. I want to replace NA with y in second data frame, how I can do.
> 2. I want to combined first and second data frame, how I can do.
> 
> Many Thanks



More information about the R-help mailing list