{"id":23543,"date":"2024-03-16T01:34:27","date_gmt":"2024-03-16T01:34:27","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/"},"modified":"2024-03-22T01:31:32","modified_gmt":"2024-03-22T01:31:32","slug":"how-can-r-convert-a-data-frame-into-a-table","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/","title":{"rendered":"How can R convert a data frame into a table?"},"content":{"rendered":"<p>In R language, you can use the melt() function from the reshape2 package to convert a data frame into a table.<\/p>\n<p>First, you need to install and load the reshape2 package.<\/p>\n<pre class=\"post-pre\"><code>install.packages<span class=\"hljs-punctuation\">(<\/span><span class=\"hljs-string\">\"reshape2\"<\/span><span class=\"hljs-punctuation\">)<\/span>\r\nlibrary<span class=\"hljs-punctuation\">(<\/span>reshape2<span class=\"hljs-punctuation\">)<\/span>\r\n<\/code><\/pre>\n<p>Assuming there is a data frame named df:<\/p>\n<pre class=\"post-pre\"><code>df <span class=\"hljs-operator\">&lt;-<\/span> data.frame<span class=\"hljs-punctuation\">(<\/span>\r\n  ID <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-built_in\">c<\/span><span class=\"hljs-punctuation\">(<\/span><span class=\"hljs-number\">1<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-number\">2<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-number\">3<\/span><span class=\"hljs-punctuation\">)<\/span><span class=\"hljs-punctuation\">,<\/span>\r\n  Fruit <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-built_in\">c<\/span><span class=\"hljs-punctuation\">(<\/span><span class=\"hljs-string\">\"Apple\"<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-string\">\"Banana\"<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-string\">\"Orange\"<\/span><span class=\"hljs-punctuation\">)<\/span><span class=\"hljs-punctuation\">,<\/span>\r\n  Price <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-built_in\">c<\/span><span class=\"hljs-punctuation\">(<\/span><span class=\"hljs-number\">1.2<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-number\">0.8<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-number\">0.5<\/span><span class=\"hljs-punctuation\">)<\/span><span class=\"hljs-punctuation\">,<\/span>\r\n  Quantity <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-built_in\">c<\/span><span class=\"hljs-punctuation\">(<\/span><span class=\"hljs-number\">5<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-number\">3<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-number\">4<\/span><span class=\"hljs-punctuation\">)<\/span>\r\n<span class=\"hljs-punctuation\">)<\/span>\r\n\r\ndf\r\n<span class=\"hljs-comment\">#   ID  Fruit Price Quantity<\/span>\r\n<span class=\"hljs-comment\"># 1  1  Apple   1.2        5<\/span>\r\n<span class=\"hljs-comment\"># 2  2 Banana   0.8        3<\/span>\r\n<span class=\"hljs-comment\"># 3  3 Orange   0.5        4<\/span>\r\n<\/code><\/pre>\n<p>Next, use the melt() function to transform the data frame into a table.<\/p>\n<pre class=\"post-pre\"><code>melted_df <span class=\"hljs-operator\">&lt;-<\/span> melt<span class=\"hljs-punctuation\">(<\/span>df<span class=\"hljs-punctuation\">,<\/span> id.vars <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">\"ID\"<\/span><span class=\"hljs-punctuation\">,<\/span> measure.vars <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-built_in\">c<\/span><span class=\"hljs-punctuation\">(<\/span><span class=\"hljs-string\">\"Fruit\"<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-string\">\"Price\"<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-string\">\"Quantity\"<\/span><span class=\"hljs-punctuation\">)<\/span><span class=\"hljs-punctuation\">)<\/span>\r\n\r\nmelted_df\r\n<span class=\"hljs-comment\">#   ID variable   value<\/span>\r\n<span class=\"hljs-comment\"># 1  1    Fruit   Apple<\/span>\r\n<span class=\"hljs-comment\"># 2  2    Fruit  Banana<\/span>\r\n<span class=\"hljs-comment\"># 3  3    Fruit Orange<\/span>\r\n<span class=\"hljs-comment\"># 4  1    Price     1.2<\/span>\r\n<span class=\"hljs-comment\"># 5  2    Price     0.8<\/span>\r\n<span class=\"hljs-comment\"># 6  3    Price     0.5<\/span>\r\n<span class=\"hljs-comment\"># 7  1 Quantity       5<\/span>\r\n<span class=\"hljs-comment\"># 8  2 Quantity       3<\/span>\r\n<span class=\"hljs-comment\"># 9  3 Quantity       4<\/span>\r\n<\/code><\/pre>\n<p>In the transformed table, variable names are stored in the variable column and their corresponding values are stored in the value column. The id.vars parameter specifies the columns to be kept unchanged, while the measure.vars parameter specifies the columns to be transformed into the table. In the example above, the ID column is kept unchanged, while the Fruit, Price, and Quantity columns are transformed into the table.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In R language, you can use the melt() function from the reshape2 package to convert a data frame into a table. First, you need to install and load the reshape2 package. install.packages(&#8220;reshape2&#8221;) library(reshape2) Assuming there is a data frame named df: df &lt;- data.frame( ID = c(1, 2, 3), Fruit = c(&#8220;Apple&#8221;, &#8220;Banana&#8221;, &#8220;Orange&#8221;), Price [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-23543","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How can R convert a data frame into a table? - Blog - Silicon Cloud<\/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:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can R convert a data frame into a table?\" \/>\n<meta property=\"og:description\" content=\"In R language, you can use the melt() function from the reshape2 package to convert a data frame into a table. First, you need to install and load the reshape2 package. install.packages(&quot;reshape2&quot;) library(reshape2) Assuming there is a data frame named df: df &lt;- data.frame( ID = c(1, 2, 3), Fruit = c(&quot;Apple&quot;, &quot;Banana&quot;, &quot;Orange&quot;), Price [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T01:34:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T01:31:32+00:00\" \/>\n<meta name=\"author\" content=\"Noah Thompson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Noah Thompson\" \/>\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:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/\"},\"author\":{\"name\":\"Noah Thompson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\"},\"headline\":\"How can R convert a data frame into a table?\",\"datePublished\":\"2024-03-16T01:34:27+00:00\",\"dateModified\":\"2024-03-22T01:31:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/\"},\"wordCount\":131,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/\",\"name\":\"How can R convert a data frame into a table? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T01:34:27+00:00\",\"dateModified\":\"2024-03-22T01:31:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How can R convert a data frame into a table?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\",\"name\":\"Noah Thompson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"caption\":\"Noah Thompson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How can R convert a data frame into a table? - Blog - Silicon Cloud","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:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/","og_locale":"en_US","og_type":"article","og_title":"How can R convert a data frame into a table?","og_description":"In R language, you can use the melt() function from the reshape2 package to convert a data frame into a table. First, you need to install and load the reshape2 package. install.packages(\"reshape2\") library(reshape2) Assuming there is a data frame named df: df &lt;- data.frame( ID = c(1, 2, 3), Fruit = c(\"Apple\", \"Banana\", \"Orange\"), Price [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T01:34:27+00:00","article_modified_time":"2024-03-22T01:31:32+00:00","author":"Noah Thompson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Noah Thompson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/"},"author":{"name":"Noah Thompson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a"},"headline":"How can R convert a data frame into a table?","datePublished":"2024-03-16T01:34:27+00:00","dateModified":"2024-03-22T01:31:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/"},"wordCount":131,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/","name":"How can R convert a data frame into a table? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T01:34:27+00:00","dateModified":"2024-03-22T01:31:32+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-r-convert-a-data-frame-into-a-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How can R convert a data frame into a table?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a","name":"Noah Thompson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","caption":"Noah Thompson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/23543","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=23543"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/23543\/revisions"}],"predecessor-version":[{"id":57526,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/23543\/revisions\/57526"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=23543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=23543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=23543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}