[R] replace matrix values with names from a dataframe
Spencer Graves
spencer.graves at pdf.com
Fri Jul 29 18:03:27 CEST 2005
Does the following help:
> set.seed(1)
> Lvls <- factor(letters[1:4])
> A <- array(sample(4, 6, replace=TRUE), dim=c(2,3))
> A[] <- levels(Lvls)[A]
> A
[,1] [,2] [,3]
[1,] "b" "c" "a"
[2,] "b" "d" "d"
>
If not, PLEASE do read the posting guide!
"http://www.R-project.org/posting-guide.html" and submit another
question (if the process of working the posting guide does not itself
provide enlightenment).
spencer graves
jhainm at fas.harvard.edu wrote:
> Hi,
>
> I am looking for a way to replace matrix values with names from a dataframe.
>
> Let me do this by example: I have a dataframe:
>
>
>>data
>
> city.name
> 1 munich
> 2 paris
> 3 tokio
> 4 london
> 5 boston
>
> each city name corresponds to only one index number (there is only one
> observation for each city). After doing some matching I end up with a matrix
> that looks something like this:
>
>
>>X
>
> [,1] [,2]
> [1,] 2 4
> [2,] 5 1
> [3,] 5 3
> [4,] 12 217
> [5,] 16 13
>
> Here the numbers in the matrix are the index numbers from my original dataset,
> each row is a matched pair (so e.g. the first row tells me that obs. number 2
> (i.e. Paris) was matched to obs number 4 (i.e. London)).
>
> Now I am looking for a quick way to transform the index numbers back to city
> names, so that at the end I have a matrix that looks something like this:
>
>
>>X.transformed
>
> [,1] [,2]
> [1,] paris london
> [2,] boston munich
> [3,] boston tokio
> [4,] 12 217
> [5,] 16 13
>
> etc. So instead of the index number, the matrix should contain the names that
> corresponds to it. In my real data, I have many many names and replacing each
> value by hand would take too long. Any help is highly appreciated.
>
> Thank you.
>
> Regards,
> Jens
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
--
Spencer Graves, PhD
Senior Development Engineer
PDF Solutions, Inc.
333 West San Carlos Street Suite 700
San Jose, CA 95110, USA
spencer.graves at pdf.com
www.pdf.com <http://www.pdf.com>
Tel: 408-938-4420
Fax: 408-280-7915
More information about the R-help
mailing list