arnaud gaboury
2015-Feb-13 11:46 UTC
[R] replace values in one df by values from key pairs in another df
I have been searching for a while now, but can't put all pieces of the
puzzle together.
Goal : I want to replace all these kinds of patterns <@U032FHV3S> by
this <@agreenmamba>. In a more generic way, it is replacing 'id'
by
user 'name'.
I have two df:
The first, 'history', is some message history where I want to do the
replacement. It is a chat history log,
The second one, idName, is a list of id:name. All are unique. This df
rows are exctracted from a bigger one called 'users' this way :
users[users$id %in% ext].
Please find below my two data.frames:
-------------------------------------------------------------------------
history <- structure(list(name = c("xaeth",
"agreenmamba", "poisonivy",
"agreenmamba", "cruzecontrol", "poisonivy",
"poisonivy", "vairis",
"vairis", "poisonivy"), text = c("and people told that
agent their
geocities experience would never amount to anything (the convo
yesterday) ",
"<@U032FHV3S> <http://youtu.be/oGIFublvDes>", "for me
there is no such
question",
"<@U03AEKWTL|agreenmamba> uploaded a file:
<https://enlightened.slack.com/files/agreenmamba/F03KGRF3W/screenshot_2015-02-09-14-31-15.png|regarding:
should I stay or should I go?>",
"Lol.", "ha ha sorry", "some testing with my irc
client", "anybody
knows how does \"Passcode circuitry too hot. Wait for cool down to
enter another passcode.\" works?",
"what is the cooldown time or how does it work...;",
"<@U03AEKYL4>:
what app are you talking about ?"
)), .Names = c("name", "text"), class =
c("data.table", "data.frame"
), row.names = c(NA, -10L)
--------------------------------------------------------------
idName <- structure(list(id = c("U03AEKWTL", "U032FHV3S",
"U03AEKYL4"),
name = c("agreenmamba", "poisonivy",
"vairis")), .Names = c("id",
"name"), sorted = "name", class = c("data.table",
"data.frame"
), row.names = c(NA, -3L))
--------------------------------------------------------------------
1- I can find the pattern to be replaced in history this way :
ext <-
regmatches(history$text,regexpr('(?<=<@)[^|]{9}(?=>|)',history$text,
perl = T)> ext
[1] "U032FHV3S" "U03AEKWTL" "U03AEKYL4"
2- I can select the pairs id:name in my 'users' df:
> idName=users[users$id %in% ext]
id name
1: U03AEKWTL agreenmamba
2: U032FHV3S poisonivy
3: U03AEKYL4 vairis
3- i can write a loop to make the changes:
> hist.txt <- history$text
> for (i in 1:3){hist.txt <- gsub(ext[i],idName[[2]][i], hist.txt, perl =
T)}
But this will not work because of two things:
- 'idName' is not ordered the same way as 'ext'
- if a users speak twice it will leave with with some NA
May you have some hints how to process ?
I was thinking of maybe using sapply(myFun) to my 'history' df where
myFun would be the replacement process.
OR something like with assigning in my env each 'id' to its
corresponding 'name'
Thank you for help
arnaud gaboury
2015-Feb-13 12:02 UTC
[R] replace values in one df by values from key pairs in another df
This is the wrong part of my code.> >> idName=users[users$id %in% ext] > id name > 1: U03AEKWTL agreenmamba > 2: U032FHV3S poisonivy > 3: U03AEKYL4 vairis >Best is to use: idNames <- users[pmatch(ext, users$id, duplicates.ok = T)]. This leave me with an ordered and duplicate entries :> idNames <- users[pmatch(ext, users$id, duplicates.ok = T)]id name 1: U03AEKYL4 vairis 2: U03AEKYL4 vairis 3: U03AEKWTL agreenmamba 4: U032FHV3S poisonivy