I have a database that looks like:
> database
[,1] [,2] [,3] [,4]
[1,] 1 2 1 1
[2,] 2 2 3 4
[3,] 4 4 4 1
And a correspondance table, which is a dataframe:
> corresp
number name
1 1 name1
2 2 name2
3 3 name3
4 4 name4
How can I replace the numbers by the corresponding names in my database without using a loop?
(For replication:)
database <- rbind(c(1, 2, 1, 1),
c(2, 2, 3, 4),
c(4, 4, 4, 1))
corresp <- data.frame(number = c(1, 2, 3, 4),
name = c("name1","name2","name3","name4"))
No loops, not even apply
:
database[] <- as.character(corresp$name)[match(database, corresp$number)]
database
# [,1] [,2] [,3] [,4]
#[1,] "name1" "name2" "name1" "name1"
#[2,] "name2" "name2" "name3" "name4"
#[3,] "name4" "name4" "name4" "name1"
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With