{"id":4150,"date":"2023-07-13T06:30:37","date_gmt":"2023-07-13T06:30:37","guid":{"rendered":"https:\/\/statorials.org\/tr\/r-dcast-veri-tablosu\/"},"modified":"2023-07-13T06:30:37","modified_gmt":"2023-07-13T06:30:37","slug":"r-dcast-veri-tablosu","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/r-dcast-veri-tablosu\/","title":{"rendered":"R'de data.table'\u0131n dcast i\u015flevi nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"

<\/p>\n

\n

Bir veri \u00e7er\u00e7evesini uzun formattan<\/a> geni\u015f formata yeniden \u015fekillendirmek i\u00e7in R’deki data.table<\/strong> paketinin dcast<\/strong> fonksiyonunu kullanabilirsiniz.<\/span><\/p>\n

Bu i\u015flev \u00f6zellikle belirli de\u011fi\u015fkenleri bir veri \u00e7er\u00e7evesinde di\u011fer de\u011fi\u015fkenlere g\u00f6re grupland\u0131r\u0131lm\u0131\u015f \u015fekilde \u00f6zetlemek istedi\u011finizde kullan\u0131\u015fl\u0131d\u0131r.<\/span><\/p>\n

A\u015fa\u011f\u0131daki \u00f6rnekler, R’de a\u015fa\u011f\u0131daki veri \u00e7er\u00e7evesiyle dcast<\/strong> i\u015flevinin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span><\/p>\n

 library<\/span> (data.table)\n\n#create data frame\n<\/span>df <- data. 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#convert data frame to data table\n<\/span>dt <- setDT(df)\n\n#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
 \u00d6rnek 1: Di\u011fer de\u011fi\u015fkenlere g\u00f6re grupland\u0131r\u0131lm\u0131\u015f bir de\u011fi\u015fkene ili\u015fkin metri\u011fi hesaplama<\/strong><\/span><\/h2>\n
 A\u015fa\u011f\u0131daki kod, tak\u0131m<\/strong> ve konum<\/strong> de\u011fi\u015fkenlerine g\u00f6re grupland\u0131r\u0131lm\u0131\u015f ortalama puan<\/strong> de\u011ferini hesaplamak i\u00e7in dcast<\/strong> i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span><\/p>\n
 library<\/span> (data.table)\n\n#calculate mean points value by team and position\n<\/span>dt_new <- dcast(dt,\n                team + position ~.,\n                fun. aggregate<\/span> = mean, \n                value. var<\/span> = ' points<\/span> ')\n\n#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
 \u00d6rnek 2:<\/strong><\/span> Bir de\u011fi\u015fken i\u00e7in di\u011fer de\u011fi\u015fkenlere g\u00f6re grupland\u0131r\u0131lm\u0131\u015f birden \u00e7ok metri\u011fi hesaplama<\/strong><\/span><\/h2>\n
 A\u015fa\u011f\u0131daki kod, tak\u0131m<\/strong> ve konum<\/strong> de\u011fi\u015fkenlerine g\u00f6re grupland\u0131r\u0131lm\u0131\u015f ortalama puan<\/strong> de\u011ferini ve maksimum puan<\/strong> de\u011ferini hesaplamak i\u00e7in dcast<\/strong> i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span><\/p>\n
 library<\/span> (data.table)\n\n#calculate mean and max points values by team and position\n<\/span>dt_new <- dcast(dt,\n                team + position ~.,\n                fun. aggregate<\/span> = list(mean, max), \n                value. var<\/span> = ' points<\/span> ')\n\n#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
 \u00d6rnek 3:<\/strong><\/span> Di\u011fer de\u011fi\u015fkenlere g\u00f6re grupland\u0131r\u0131lm\u0131\u015f birden fazla de\u011fi\u015fken i\u00e7in metri\u011fi hesaplama<\/strong><\/span><\/h2>\n
 A\u015fa\u011f\u0131daki kod, tak\u0131m<\/strong> ve konum<\/strong> de\u011fi\u015fkenlerine g\u00f6re grupland\u0131r\u0131lm\u0131\u015f ortalama puan<\/strong> de\u011ferini ve ortalama destek<\/strong> de\u011ferini hesaplamak i\u00e7in dcast<\/strong> i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span><\/p>\n
 library<\/span> (data.table)\n\n#calculate mean and max points values by team and position\n<\/span>dt_new <- dcast(dt,\n                team + position ~.,\n                fun. aggregate<\/span> = mean, \n                value. var<\/span> = c(' points<\/span> ', ' assists<\/span> '))\n\n#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
 Ek kaynaklar<\/strong><\/span><\/h2>\n
 A\u015fa\u011f\u0131daki e\u011fitimler veri tablolar\u0131 hakk\u0131nda ek bilgi sa\u011flar:<\/span><\/p>\n
 R’deki data.table ve veri \u00e7er\u00e7evesi: \u00fc\u00e7 temel fark<\/a>
 R’de bir data.table nas\u0131l filtrelenir<\/a>
 Birden \u00e7ok veri tablosu olu\u015fturmak i\u00e7in R’de rbindlist nas\u0131l kullan\u0131l\u0131r?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Bir veri \u00e7er\u00e7evesini uzun formattan geni\u015f formata yeniden \u015fekillendirmek i\u00e7in R’deki data.table paketinin dcast fonksiyonunu kullanabilirsiniz. Bu i\u015flev \u00f6zellikle belirli de\u011fi\u015fkenleri bir veri \u00e7er\u00e7evesinde di\u011fer de\u011fi\u015fkenlere g\u00f6re grupland\u0131r\u0131lm\u0131\u015f \u015fekilde \u00f6zetlemek istedi\u011finizde kullan\u0131\u015fl\u0131d\u0131r. A\u015fa\u011f\u0131daki \u00f6rnekler, R’de a\u015fa\u011f\u0131daki veri \u00e7er\u00e7evesiyle dcast i\u015flevinin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir: library (data.table) #create data frame df <- data. frame (team=c(‘A’, ‘A’, […]<\/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-rehber"],"yoast_head":"\nR - Statorials'de data.table dcast i\u015flevi nas\u0131l kullan\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, bir veri blo\u011funu uzun formattan geni\u015f formata yeniden \u015fekillendirmek i\u00e7in R'deki data.table paketinin dcast fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\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\/tr\/r-dcast-veri-tablosu\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"R - Statorials'de data.table dcast i\u015flevi nas\u0131l kullan\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, bir veri blo\u011funu uzun formattan geni\u015f formata yeniden \u015fekillendirmek i\u00e7in R'deki data.table paketinin dcast fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/r-dcast-veri-tablosu\/\" \/>\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.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/r-dcast-veri-tablosu\/\",\"url\":\"https:\/\/statorials.org\/tr\/r-dcast-veri-tablosu\/\",\"name\":\"R - Statorials'de data.table dcast i\u015flevi nas\u0131l kullan\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-13T06:30:37+00:00\",\"dateModified\":\"2023-07-13T06:30:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, bir veri blo\u011funu uzun formattan geni\u015f formata yeniden \u015fekillendirmek i\u00e7in R'deki data.table paketinin dcast fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/r-dcast-veri-tablosu\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/r-dcast-veri-tablosu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/r-dcast-veri-tablosu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"R'de data.table'\u0131n dcast i\u015flevi nas\u0131l kullan\u0131l\u0131r?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"R - Statorials'de data.table dcast i\u015flevi nas\u0131l kullan\u0131l\u0131r?","description":"Bu e\u011fitimde, bir veri blo\u011funu uzun formattan geni\u015f formata yeniden \u015fekillendirmek i\u00e7in R'deki data.table paketinin dcast fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","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\/tr\/r-dcast-veri-tablosu\/","og_locale":"tr_TR","og_type":"article","og_title":"R - Statorials'de data.table dcast i\u015flevi nas\u0131l kullan\u0131l\u0131r?","og_description":"Bu e\u011fitimde, bir veri blo\u011funu uzun formattan geni\u015f formata yeniden \u015fekillendirmek i\u00e7in R'deki data.table paketinin dcast fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/r-dcast-veri-tablosu\/","og_site_name":"Statorials","article_published_time":"2023-07-13T06:30:37+00:00","author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/r-dcast-veri-tablosu\/","url":"https:\/\/statorials.org\/tr\/r-dcast-veri-tablosu\/","name":"R - Statorials'de data.table dcast i\u015flevi nas\u0131l kullan\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-13T06:30:37+00:00","dateModified":"2023-07-13T06:30:37+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, bir veri blo\u011funu uzun formattan geni\u015f formata yeniden \u015fekillendirmek i\u00e7in R'deki data.table paketinin dcast fonksiyonunun nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/r-dcast-veri-tablosu\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/r-dcast-veri-tablosu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/r-dcast-veri-tablosu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"R'de data.table'\u0131n dcast i\u015flevi nas\u0131l kullan\u0131l\u0131r?"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=4150"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4150\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=4150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=4150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=4150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}