{"id":4150,"date":"2023-07-13T06:30:37","date_gmt":"2023-07-13T06:30:37","guid":{"rendered":"https:\/\/statorials.org\/pt\/tabela-de-dados-r-dcast\/"},"modified":"2023-07-13T06:30:37","modified_gmt":"2023-07-13T06:30:37","slug":"tabela-de-dados-r-dcast","status":"publish","type":"post","link":"https:\/\/statorials.org\/pt\/tabela-de-dados-r-dcast\/","title":{"rendered":"Como usar a fun\u00e7\u00e3o dcast de data.table em r"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Voc\u00ea pode usar a fun\u00e7\u00e3o <strong>dcast<\/strong> do pacote <strong>data.table<\/strong> em R para remodelar um quadro de dados de um <a href=\"https:\/\/statorials.org\/pt\/dados-longos-versus-dados-amplos\/\" target=\"_blank\" rel=\"noopener\">formato longo<\/a> para um formato amplo.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Esta fun\u00e7\u00e3o \u00e9 particularmente \u00fatil quando se deseja resumir vari\u00e1veis espec\u00edficas em um data frame, agrupadas por outras vari\u00e1veis.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Os exemplos a seguir mostram como usar a fun\u00e7\u00e3o <strong>dcast<\/strong> na pr\u00e1tica com o seguinte quadro de dados em R:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">library<\/span> (data.table)\n\n<span style=\"color: #008080;\">#create data frame\n<\/span>df &lt;- data. <span style=\"color: #3366ff;\">frame<\/span> (team=c('A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'),\n                 position=c('G', 'G', 'F', 'F', 'G', 'G', 'F', 'F'),\n                 points=c(18, 13, 10, 12, 16, 25, 24, 31),\n                 assists=c(9, 8, 8, 5, 12, 15, 10, 7))\n\n<span style=\"color: #008080;\">#convert data frame to data table\n<\/span>dt &lt;- setDT(df)\n\n<span style=\"color: #008080;\">#view data table\n<\/span>dt\n\n   team position points assists\n1: AG 18 9\n2: AG 13 8\n3:AF 10 8\n4:AF 12 5\n5: BG 16 12\n6: BG 25 15\n7: BF 24 10\n8: BF 31 7<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Exemplo 1: Calcular a m\u00e9trica para uma vari\u00e1vel, agrupada por outras vari\u00e1veis<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">O c\u00f3digo a seguir mostra como usar a fun\u00e7\u00e3o <strong>dcast<\/strong> para calcular o valor m\u00e9dio <strong>de pontos<\/strong> , agrupados por vari\u00e1veis de <strong>equipe<\/strong> e <strong>posi\u00e7\u00e3o<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">library<\/span> (data.table)\n\n<span style=\"color: #008080;\">#calculate mean points value by team and position\n<\/span>dt_new &lt;- dcast(dt,\n                team + position ~.,\n                fun. <span style=\"color: #3366ff;\">aggregate<\/span> = mean, \n                value. <span style=\"color: #3366ff;\">var<\/span> = ' <span style=\"color: #ff0000;\">points<\/span> ')\n\n<span style=\"color: #008080;\">#view results\n<\/span>dt_new\n\n   team position.\n1:AF 11.0\n2: AG 15.5\n3: BF 27.5\n4: BG 20.5\n<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Exemplo 2:<\/strong><\/span> <span style=\"color: #000000;\"><strong>Calcular m\u00faltiplas m\u00e9tricas para uma vari\u00e1vel, agrupadas por outras vari\u00e1veis<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">O c\u00f3digo a seguir mostra como usar a fun\u00e7\u00e3o <strong>dcast<\/strong> para calcular o valor m\u00e9dio <strong>de pontos<\/strong> e o valor m\u00e1ximo <strong>de pontos<\/strong> , agrupados por vari\u00e1veis de <strong>equipe<\/strong> e <strong>posi\u00e7\u00e3o<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">library<\/span> (data.table)\n\n<span style=\"color: #008080;\">#calculate mean and max points values by team and position\n<\/span>dt_new &lt;- dcast(dt,\n                team + position ~.,\n                fun. <span style=\"color: #3366ff;\">aggregate<\/span> = list(mean, max), \n                value. <span style=\"color: #3366ff;\">var<\/span> = ' <span style=\"color: #ff0000;\">points<\/span> ')\n\n<span style=\"color: #008080;\">#view results\n<\/span>dt_new\n\n   team position points_mean points_max\n1:AF 11.0 12\n2: AG 15.5 18\n3: BF 27.5 31\n4: BG 20.5 25<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Exemplo 3:<\/strong><\/span> <span style=\"color: #000000;\"><strong>Calcular a m\u00e9trica para m\u00faltiplas vari\u00e1veis, agrupadas por outras vari\u00e1veis<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">O c\u00f3digo a seguir mostra como usar a fun\u00e7\u00e3o <strong>dcast<\/strong> para calcular o valor m\u00e9dio <strong>de pontos<\/strong> e o valor m\u00e9dio <strong>de assist\u00eancias<\/strong> , agrupados por vari\u00e1veis de <strong>equipe<\/strong> e <strong>posi\u00e7\u00e3o<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">library<\/span> (data.table)\n\n<span style=\"color: #008080;\">#calculate mean and max points values by team and position\n<\/span>dt_new &lt;- dcast(dt,\n                team + position ~.,\n                fun. <span style=\"color: #3366ff;\">aggregate<\/span> = mean, \n                value. <span style=\"color: #3366ff;\">var<\/span> = c(' <span style=\"color: #ff0000;\">points<\/span> ', ' <span style=\"color: #ff0000;\">assists<\/span> '))\n\n<span style=\"color: #008080;\">#view results\n<\/span>dt_new\n\n   team position points assists\n1:AF 11.0 6.5\n2: AG 15.5 8.5\n3: BF 27.5 8.5\n4: BG 20.5 13.5<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Recursos adicionais<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Os tutoriais a seguir fornecem informa\u00e7\u00f5es adicionais sobre tabelas de dados:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/pt\/tabela-de-dados-vs-quadro-de-dados-em-r\/\" target=\"_blank\" rel=\"noopener\">data.table vs data frame em R: tr\u00eas diferen\u00e7as principais<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/filtrar-tabela-de-dados-em-r\/\" target=\"_blank\" rel=\"noopener\">Como filtrar um data.table em R<\/a><br \/> <a href=\"https:\/\/statorials.org\/pt\/listarbind\/\" target=\"_blank\" rel=\"noopener\">Como usar o rbindlist em R para criar uma tabela de dados a partir de v\u00e1rios<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Voc\u00ea pode usar a fun\u00e7\u00e3o dcast do pacote data.table em R para remodelar um quadro de dados de um formato longo para um formato amplo. Esta fun\u00e7\u00e3o \u00e9 particularmente \u00fatil quando se deseja resumir vari\u00e1veis espec\u00edficas em um data frame, agrupadas por outras vari\u00e1veis. Os exemplos a seguir mostram como usar a fun\u00e7\u00e3o dcast na [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4150","post","type-post","status-publish","format-standard","hentry","category-guia"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como usar a fun\u00e7\u00e3o data.table dcast em R - Estatoriais<\/title>\n<meta name=\"description\" content=\"Este tutorial explica como usar a fun\u00e7\u00e3o dcast do pacote data.table em R para remodelar um bloco de dados de formato longo para formato amplo.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/pt\/tabela-de-dados-r-dcast\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como usar a fun\u00e7\u00e3o data.table dcast em R - Estatoriais\" \/>\n<meta property=\"og:description\" content=\"Este tutorial explica como usar a fun\u00e7\u00e3o dcast do pacote data.table em R para remodelar um bloco de dados de formato longo para formato amplo.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/pt\/tabela-de-dados-r-dcast\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T06:30:37+00:00\" \/>\n<meta name=\"author\" content=\"Dr. benjamim anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr. benjamim anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/pt\/tabela-de-dados-r-dcast\/\",\"url\":\"https:\/\/statorials.org\/pt\/tabela-de-dados-r-dcast\/\",\"name\":\"Como usar a fun\u00e7\u00e3o data.table dcast em R - Estatoriais\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/pt\/#website\"},\"datePublished\":\"2023-07-13T06:30:37+00:00\",\"dateModified\":\"2023-07-13T06:30:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\"},\"description\":\"Este tutorial explica como usar a fun\u00e7\u00e3o dcast do pacote data.table em R para remodelar um bloco de dados de formato longo para formato amplo.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/pt\/tabela-de-dados-r-dcast\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/pt\/tabela-de-dados-r-dcast\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/pt\/tabela-de-dados-r-dcast\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/statorials.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como usar a fun\u00e7\u00e3o dcast de data.table em r\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/pt\/#website\",\"url\":\"https:\/\/statorials.org\/pt\/\",\"name\":\"Statorials\",\"description\":\"O seu guia para a literacia estat\u00edstica!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/pt\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666\",\"name\":\"Dr. benjamim anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/statorials.org\/pt\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr. benjamim anderson\"},\"description\":\"Ol\u00e1, sou Benjamin, um professor aposentado de estat\u00edstica que se tornou professor dedicado na Statorials. Com vasta experi\u00eancia e conhecimento na \u00e1rea de estat\u00edstica, estou empenhado em compartilhar meu conhecimento para capacitar os alunos por meio de Statorials. Saber mais\",\"sameAs\":[\"https:\/\/statorials.org\/pt\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como usar a fun\u00e7\u00e3o data.table dcast em R - Estatoriais","description":"Este tutorial explica como usar a fun\u00e7\u00e3o dcast do pacote data.table em R para remodelar um bloco de dados de formato longo para formato amplo.","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:\/\/statorials.org\/pt\/tabela-de-dados-r-dcast\/","og_locale":"pt_PT","og_type":"article","og_title":"Como usar a fun\u00e7\u00e3o data.table dcast em R - Estatoriais","og_description":"Este tutorial explica como usar a fun\u00e7\u00e3o dcast do pacote data.table em R para remodelar um bloco de dados de formato longo para formato amplo.","og_url":"https:\/\/statorials.org\/pt\/tabela-de-dados-r-dcast\/","og_site_name":"Statorials","article_published_time":"2023-07-13T06:30:37+00:00","author":"Dr. benjamim anderson","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dr. benjamim anderson","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/pt\/tabela-de-dados-r-dcast\/","url":"https:\/\/statorials.org\/pt\/tabela-de-dados-r-dcast\/","name":"Como usar a fun\u00e7\u00e3o data.table dcast em R - Estatoriais","isPartOf":{"@id":"https:\/\/statorials.org\/pt\/#website"},"datePublished":"2023-07-13T06:30:37+00:00","dateModified":"2023-07-13T06:30:37+00:00","author":{"@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666"},"description":"Este tutorial explica como usar a fun\u00e7\u00e3o dcast do pacote data.table em R para remodelar um bloco de dados de formato longo para formato amplo.","breadcrumb":{"@id":"https:\/\/statorials.org\/pt\/tabela-de-dados-r-dcast\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/pt\/tabela-de-dados-r-dcast\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/pt\/tabela-de-dados-r-dcast\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/statorials.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como usar a fun\u00e7\u00e3o dcast de data.table em r"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/pt\/#website","url":"https:\/\/statorials.org\/pt\/","name":"Statorials","description":"O seu guia para a literacia estat\u00edstica!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/pt\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/e08f98e8db95e0aa9c310e1b27c9c666","name":"Dr. benjamim anderson","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/statorials.org\/pt\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/pt\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr. benjamim anderson"},"description":"Ol\u00e1, sou Benjamin, um professor aposentado de estat\u00edstica que se tornou professor dedicado na Statorials. Com vasta experi\u00eancia e conhecimento na \u00e1rea de estat\u00edstica, estou empenhado em compartilhar meu conhecimento para capacitar os alunos por meio de Statorials. Saber mais","sameAs":["https:\/\/statorials.org\/pt"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/4150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/comments?post=4150"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/posts\/4150\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/media?parent=4150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/categories?post=4150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/pt\/wp-json\/wp\/v2\/tags?post=4150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}