{"id":12977,"date":"2022-10-02T15:33:53","date_gmt":"2022-10-02T10:03:53","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/"},"modified":"2022-10-02T15:33:53","modified_gmt":"2022-10-02T10:03:53","slug":"solved-taking-values-from-two-multiple-matrices-in-r","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/","title":{"rendered":"[Solved] Taking values from two\/multiple matrices in R?"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

Re-arranging your data into matrices with rownames makes this more convenient, as the row names are not a column, and therefore do not force a mode of character for the numeric data. Here are how the matrices would look. I created meaningless column names for this example, in order to show which columns are used for the products in the result.<\/p>\n

> tab\n       a   b    c    d\nval1 210 201 2001 2020\nval2 302 200 2919 3030\nval3 839 939 8383 8383\n\n> tab2\n       e   f\nval1 2.3 3.4\nval2 3.4 8.3\nval3 7.3 8.3\n<\/code><\/pre>\n
First, iterate over the intersection of the row names with sapply<\/code>.  This will run one iteration per row name.  Here they all match, but that isn’t necessary.  It also isn’t necessary that they be in the same order, but it is necessary that the row names be unique.<\/p>\n
Then, to create each row, you can use the outer<\/code> function.  sapply<\/code> returns the transpose of what you seem to want, so t<\/code> is used to transpose it back.  Column names could be applied to this result, if desired.<\/p>\n
result <- t(sapply(intersect(rownames(tab), rownames(tab2)), \n      function(x) outer(as.matrix(tab[x, ]), as.matrix(tab2[x, ])))\n    )\n\nresult\n##        [,1]   [,2]    [,3]    [,4]   [,5]   [,6]    [,7]    [,8]\n## val1  483.0  462.3  4602.3  4646.0  714.0  683.4  6803.4  6868.0\n## val2 1026.8  680.0  9924.6 10302.0 2506.6 1660.0 24227.7 25149.0\n## val3 6124.7 6854.7 61195.9 61195.9 6963.7 7793.7 69578.9 69578.9\n<\/code><\/pre>\n
To assign column names based on the column names of the original set, use outer<\/code> again on the names, this time passing to paste<\/code>.  This ensures that the same order is used for the name computation as was used for the numeric computation.<\/p>\n
colnames(result) <- outer(colnames(tab), colnames(tab2), FUN=paste, sep='*')\nresult\n##         a*e    b*e     c*e     d*e    a*f    b*f     c*f     d*f\n## val1  483.0  462.3  4602.3  4646.0  714.0  683.4  6803.4  6868.0\n## val2 1026.8  680.0  9924.6 10302.0 2506.6 1660.0 24227.7 25149.0\n## val3 6124.7 6854.7 61195.9 61195.9 6963.7 7793.7 69578.9 69578.9\n<\/code><\/pre>\n
This shows which columns in the inputs create columns in the output.<\/p>\n<\/p><\/div>\n
<\/div>\n<\/div>\n
            2<\/span> <\/p><\/div>\n<\/div>\n
[ad_2]<\/p>\n
solved Taking values from two\/multiple matrices in R? <\/p>\n","protected":false},"excerpt":{"rendered":"
[ad_1] Re-arranging your data into matrices with rownames makes this more convenient, as the row names are not a column, and therefore do not force a mode of character for the numeric data. Here are how the matrices would look. I created meaningless column names for this example, in order to show which columns are … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[1331,321],"class_list":["post-12977","post","type-post","status-publish","format-standard","hentry","category-solved","tag-matrix","tag-r"],"yoast_head":"\n[Solved] Taking values from two\/multiple matrices in R? - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Taking values from two\/multiple matrices in R? - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Re-arranging your data into matrices with rownames makes this more convenient, as the row names are not a column, and therefore do not force a mode of character for the numeric data. Here are how the matrices would look. I created meaningless column names for this example, in order to show which columns are ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-02T10:03:53+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Taking values from two\/multiple matrices in R?\",\"datePublished\":\"2022-10-02T10:03:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/\"},\"wordCount\":219,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"matrix\",\"r\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/\",\"name\":\"[Solved] Taking values from two\/multiple matrices in R? - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-10-02T10:03:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Taking values from two\/multiple matrices in R?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Taking values from two\/multiple matrices in R? - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Taking values from two\/multiple matrices in R? - JassWeb","og_description":"[ad_1] Re-arranging your data into matrices with rownames makes this more convenient, as the row names are not a column, and therefore do not force a mode of character for the numeric data. Here are how the matrices would look. I created meaningless column names for this example, in order to show which columns are ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/","og_site_name":"JassWeb","article_published_time":"2022-10-02T10:03:53+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Taking values from two\/multiple matrices in R?","datePublished":"2022-10-02T10:03:53+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/"},"wordCount":219,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["matrix","r"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/","url":"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/","name":"[Solved] Taking values from two\/multiple matrices in R? - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-10-02T10:03:53+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-taking-values-from-two-multiple-matrices-in-r\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Taking values from two\/multiple matrices in R?"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/12977","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=12977"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/12977\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=12977"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=12977"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=12977"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}