Hi Valerie
One way would be to use the match function.
# Your Data
u =data.frame(coe=c(0,0,0,0,0,0,0,0),
name=c("Time","Poten","AdvExp","Share","Change","Accounts","Work","Rating"))
v = data.frame(coeff=c(0.7272727,0.3211112,0.0500123),
enter=c("Accounts","Time","Poten"))
# Match Function
updates = v[match(u$name,v$enter),"coeff"]
u$coe = ifelse(!is.na(updates), updates, u$coe)
HTH
Pete
valerie wrote
>
> Hi,
>
> I have two data frames (u and v).
>> u
> coe nam
> 1 0 Time
> 2 0 Poten
> 3 0 AdvExp
> 4 0 Share
> 5 0 Change
> 6 0 Accounts
> 7 0 Work
> 8 0 Rating
>
>> v
> coeff enter
> 1 0.7272727 Accounts
> 2 0.3211112 Time
> 3 0.0500123 Poten
>
> I want to update the values of coe in u by using the values of coeff in v.
> That is, I want to get the following result
>
>> u
> coe nam
> 1 0.3211112 Time
> 2 0.0500123 Poten
> 3 0 AdvExp
> 4 0 Share
> 5 0 Change
> 6 0.7272727 Accounts
> 7 0 Work
> 8 0 Rating
>
>
> OR the following result is also acceptable:
>
> 0.3211112 0.0500123 0 0 0 0.7272727 0 0
>
>
> I tried the following, but the result is not right.
> replace(coe,colnames,coeff)
> [1] 0.7272727 0.0500123 0.3211112 0.0000000 0.0000000 0.0000000 0.0000000
> [8] 0.0000000
>
> PLEASE HELP ME.
> THANK YOU VERY MUCH.
>
--
View this message in context:
http://r.789695.n4.nabble.com/replace-some-values-of-a-column-with-diffrent-values-tp4360035p4360249.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
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.
