{"id":2486,"date":"2023-07-22T01:51:33","date_gmt":"2023-07-22T01:51:33","guid":{"rendered":"https:\/\/statorials.org\/id\/kolom-jumlah-spesifik-panda\/"},"modified":"2023-07-22T01:51:33","modified_gmt":"2023-07-22T01:51:33","slug":"kolom-jumlah-spesifik-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kolom-jumlah-spesifik-panda\/","title":{"rendered":"Cara menambahkan kolom tertentu di pandas (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk menemukan jumlah kumpulan kolom tertentu di pandas DataFrame:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Temukan jumlah semua kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#find sum of all columns<\/span>\ndf[' <span style=\"color: #ff0000;\">sum<\/span> '] = df. <span style=\"color: #3366ff;\">sum<\/span> (axis= <span style=\"color: #008000;\">1<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Temukan jumlah kolom tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#specify the columns to sum\n<\/span>cols = [' <span style=\"color: #ff0000;\">col1<\/span> ', ' <span style=\"color: #ff0000;\">col4<\/span> ', ' <span style=\"color: #ff0000;\">col5<\/span> ']\n\n<span style=\"color: #008080;\">#find sum of columns specified \n<\/span>df[' <span style=\"color: #ff0000;\">sum<\/span> '] = df[cols]. <span style=\"color: #3366ff;\">sum<\/span> (axis= <span style=\"color: #008000;\">1<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dalam praktik dengan pandas DataFrame berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd<\/span>\n\n#createDataFrame\n<\/span>df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">points<\/span> ': [18, 22, 19, 14, 14, 11, 20, 28],\n                   ' <span style=\"color: #ff0000;\">assists<\/span> ': [5, 7, 7, 9, 12, 9, 9, 4],\n                   ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [11, 8, 10, 6, 6, 5, 9, 12]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n   points assists rebounds\n0 18 5 11\n1 22 7 8\n2 19 7 10\n3 14 9 6\n4 14 12 6\n5 11 9 5\n6 20 9 9\n7 28 4 12\n<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Temukan jumlah semua kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menambahkan nilai baris di seluruh kolom di DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#define new column that contains sum of all columns<\/span>\ndf[' <span style=\"color: #ff0000;\">sum_stats<\/span> '] = df. <span style=\"color: #3366ff;\">sum<\/span> (axis= <span style=\"color: #008000;\">1<\/span> )\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span>df\n\n\tpoints assists rebounds sum_stats\n0 18 5 11 34\n1 22 7 8 37\n2 19 7 10 36\n3 14 9 6 29\n4 14 12 6 32\n5 11 9 5 25\n6 20 9 9 38\n7 28 4 12 44\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kolom <strong>sum_stats<\/strong> berisi jumlah nilai baris di semua kolom.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, berikut cara menghitung nilainya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Jumlah baris 0: 18 + 5 + 11 = <strong>34<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah baris 1: 22 + 7 + 8 = <strong>37<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah baris 2: 19 + 7 + 10 = <strong>36<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Temukan jumlah kolom tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menambahkan nilai baris di seluruh kolom di DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#specify the columns to sum\n<span style=\"color: #000000;\">cols = [' <span style=\"color: #ff0000;\">points<\/span> ', ' <span style=\"color: #ff0000;\">assists<\/span> ']<\/span>\n\n#define new column that contains sum of specific columns\n<\/span>df[' <span style=\"color: #ff0000;\">sum_stats<\/span> '] = df[cols]. <span style=\"color: #3366ff;\">sum<\/span> (axis= <span style=\"color: #008000;\">1<\/span> )\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span>df\n\n\tpoints assists rebounds sum_stats\n0 18 5 11 23\n1 22 7 8 29\n2 19 7 10 26\n3 14 9 6 23\n4 14 12 6 26\n5 11 9 5 20\n6 20 9 9 29\n7 28 4 12 32\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kolom <strong>sum_stats<\/strong> berisi jumlah nilai baris pada kolom \u201cpoin\u201d dan \u201cbantuan\u201d.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, berikut cara menghitung nilainya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Jumlah baris 0: 18 + 5 + 11 = <strong>23<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah baris 1: 22 + 7 = <strong>29<\/strong><\/span><\/li>\n<li> <span style=\"color: #000000;\">Jumlah baris 2: 19 + 7 = <strong>26<\/strong><\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/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-panda\/\" target=\"_blank\" rel=\"noopener\">Cara menjalankan fungsi SUMIF di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-jumlah\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan penjumlahan GroupBy di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kolom-jumlah-panda-dengan-syarat\/\" target=\"_blank\" rel=\"noopener\">Cara menjumlahkan kolom berdasarkan kondisi di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk menemukan jumlah kumpulan kolom tertentu di pandas DataFrame: Metode 1: Temukan jumlah semua kolom #find sum of all columns df[&#8216; sum &#8216;] = df. sum (axis= 1 ) Metode 2: Temukan jumlah kolom tertentu #specify the columns to sum cols = [&#8216; col1 &#8216;, &#8216; col4 &#8216;, &#8216; col5 [&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>Cara Menambahkan Kolom Tertentu di Pandas (dengan Contoh) \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan kolom tertentu di pandas DataFrame, dengan beberapa contoh.\" \/>\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\/kolom-jumlah-spesifik-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menambahkan Kolom Tertentu di Pandas (dengan Contoh) \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan kolom tertentu di pandas DataFrame, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kolom-jumlah-spesifik-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T01:51:33+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\/kolom-jumlah-spesifik-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/kolom-jumlah-spesifik-panda\/\",\"name\":\"Cara Menambahkan Kolom Tertentu di Pandas (dengan Contoh) \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T01:51:33+00:00\",\"dateModified\":\"2023-07-22T01:51:33+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan kolom tertentu di pandas DataFrame, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kolom-jumlah-spesifik-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kolom-jumlah-spesifik-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kolom-jumlah-spesifik-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menambahkan kolom tertentu di pandas (dengan contoh)\"}]},{\"@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":"Cara Menambahkan Kolom Tertentu di Pandas (dengan Contoh) \u2013 Statorial","description":"Tutorial ini menjelaskan cara menambahkan kolom tertentu di pandas DataFrame, dengan beberapa contoh.","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\/kolom-jumlah-spesifik-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menambahkan Kolom Tertentu di Pandas (dengan Contoh) \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menambahkan kolom tertentu di pandas DataFrame, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/kolom-jumlah-spesifik-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-22T01:51:33+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\/kolom-jumlah-spesifik-panda\/","url":"https:\/\/statorials.org\/id\/kolom-jumlah-spesifik-panda\/","name":"Cara Menambahkan Kolom Tertentu di Pandas (dengan Contoh) \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T01:51:33+00:00","dateModified":"2023-07-22T01:51:33+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan kolom tertentu di pandas DataFrame, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kolom-jumlah-spesifik-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kolom-jumlah-spesifik-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kolom-jumlah-spesifik-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menambahkan kolom tertentu di pandas (dengan contoh)"}]},{"@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\/2486"}],"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=2486"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2486\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}