{"id":2920,"date":"2023-07-20T02:21:24","date_gmt":"2023-07-20T02:21:24","guid":{"rendered":"https:\/\/statorials.org\/id\/pandas-mengelompokkan-dengan-menggabungkan-string\/"},"modified":"2023-07-20T02:21:24","modified_gmt":"2023-07-20T02:21:24","slug":"pandas-mengelompokkan-dengan-menggabungkan-string","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pandas-mengelompokkan-dengan-menggabungkan-string\/","title":{"rendered":"Pandas: cara menggabungkan string menggunakan groupby"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menggabungkan string dari GroupBy di panda:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">groupby<\/span> ([' <span style=\"color: #ff0000;\">group_var<\/span> '], as_index= <span style=\"color: #008000;\">False<\/span> ). <span style=\"color: #3366ff;\">agg<\/span> ({' <span style=\"color: #ff0000;\">string_var<\/span> ': ' ' <span style=\"color: #3366ff;\">.join<\/span> })\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini mengelompokkan baris berdasarkan kolom <strong>group_var<\/strong> , lalu menggabungkan string di kolom <strong>string_var<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Cara menggabungkan string menggunakan GroupBy<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki panda DataFrame berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">store<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'],\n                   ' <span style=\"color: #ff0000;\">quarter<\/span> ': [1, 1, 2, 2, 1, 1, 2, 2],\n                   ' <span style=\"color: #ff0000;\">employee<\/span> ': ['Andy', 'Bob', 'Chad', 'Diane',\n                                'Elana', 'Frank', 'George', 'Hank']})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk mengelompokkan baris DataFrame berdasarkan <strong>penyimpanan<\/strong> dan <strong>kuartal<\/strong> , lalu menggabungkan string di kolom <strong>karyawan<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#group by store and quarter, then concatenate employee strings\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">groupby<\/span> ([' <span style=\"color: #ff0000;\">store<\/span> ', ' <span style=\"color: #ff0000;\">quarter<\/span> '], as_index= <span style=\"color: #008000;\">False<\/span> ). <span style=\"color: #3366ff;\">agg<\/span> ({' <span style=\"color: #ff0000;\">employee<\/span> ':''. <span style=\"color: #3366ff;\">join<\/span> })\n\n\tstore quarter employee\n0 To 1 Andy Bob\n1 A 2 Chad Diane\n2 B 1 Elana Frank\n3 B 2 George Hank<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Hasilnya adalah DataFrame yang dikelompokkan berdasarkan <strong>toko<\/strong> dan <strong>kuartal<\/strong> dengan string kolom <strong>karyawan<\/strong> digabungkan dengan spasi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita juga dapat menggabungkan string menggunakan pemisah yang berbeda seperti simbol <strong>&amp;<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#group by store and quarter, then concatenate employee strings\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">groupby<\/span> ([' <span style=\"color: #ff0000;\">store<\/span> ', ' <span style=\"color: #ff0000;\">quarter<\/span> '], as_index= <span style=\"color: #008000;\">False<\/span> ). <span style=\"color: #3366ff;\">agg<\/span> ({' <span style=\"color: #ff0000;\">employee<\/span> ':' <span style=\"color: #ff0000;\">&amp;<\/span> '. <span style=\"color: #3366ff;\">join<\/span> })\n\n\tstore quarter employee\n0 To 1 Andy &amp; Bob\n1 A 2 Chad &amp; Diane\n2 B 1 Elana &amp; Frank\n3 B 2 George &amp; Hank<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa string di kolom karyawan sekarang dipisahkan dengan simbol <strong>&amp;<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap operasi GroupBy di pandas <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.DataFrame.groupby.html\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di panda:<\/span><\/p>\n<p><a href=\"https:\/\/statorials.org\/id\/jumlah-kumulatif-panda-per-grup\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara menghitung jumlah kumulatif per kelompok<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-dikelompokkan-berdasarkan-jumlah-unik\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara menghitung nilai unik berdasarkan kelompok<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-korelasi\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara menghitung korelasi berdasarkan kelompok<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menggabungkan string dari GroupBy di panda: df. groupby ([&#8216; group_var &#8216;], as_index= False ). agg ({&#8216; string_var &#8216;: &#8216; &#8216; .join }) Rumus khusus ini mengelompokkan baris berdasarkan kolom group_var , lalu menggabungkan string di kolom string_var . Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: [&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":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Pandas: Cara menggabungkan string menggunakan GroupBy - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggabungkan string menjadi DataFrame pandas dari GroupBy.\" \/>\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\/id\/pandas-mengelompokkan-dengan-menggabungkan-string\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara menggabungkan string menggunakan GroupBy - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggabungkan string menjadi DataFrame pandas dari GroupBy.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pandas-mengelompokkan-dengan-menggabungkan-string\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T02:21:24+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/pandas-mengelompokkan-dengan-menggabungkan-string\/\",\"url\":\"https:\/\/statorials.org\/id\/pandas-mengelompokkan-dengan-menggabungkan-string\/\",\"name\":\"Pandas: Cara menggabungkan string menggunakan GroupBy - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T02:21:24+00:00\",\"dateModified\":\"2023-07-20T02:21:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggabungkan string menjadi DataFrame pandas dari GroupBy.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pandas-mengelompokkan-dengan-menggabungkan-string\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pandas-mengelompokkan-dengan-menggabungkan-string\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pandas-mengelompokkan-dengan-menggabungkan-string\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menggabungkan string menggunakan groupby\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pandas: Cara menggabungkan string menggunakan GroupBy - Statorials","description":"Tutorial ini menjelaskan cara menggabungkan string menjadi DataFrame pandas dari GroupBy.","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\/id\/pandas-mengelompokkan-dengan-menggabungkan-string\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menggabungkan string menggunakan GroupBy - Statorials","og_description":"Tutorial ini menjelaskan cara menggabungkan string menjadi DataFrame pandas dari GroupBy.","og_url":"https:\/\/statorials.org\/id\/pandas-mengelompokkan-dengan-menggabungkan-string\/","og_site_name":"Statorials","article_published_time":"2023-07-20T02:21:24+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/pandas-mengelompokkan-dengan-menggabungkan-string\/","url":"https:\/\/statorials.org\/id\/pandas-mengelompokkan-dengan-menggabungkan-string\/","name":"Pandas: Cara menggabungkan string menggunakan GroupBy - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T02:21:24+00:00","dateModified":"2023-07-20T02:21:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggabungkan string menjadi DataFrame pandas dari GroupBy.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pandas-mengelompokkan-dengan-menggabungkan-string\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pandas-mengelompokkan-dengan-menggabungkan-string\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pandas-mengelompokkan-dengan-menggabungkan-string\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menggabungkan string menggunakan groupby"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2920"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2920"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2920\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2920"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2920"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2920"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}