{"id":2384,"date":"2023-07-22T12:34:04","date_gmt":"2023-07-22T12:34:04","guid":{"rendered":"https:\/\/statorials.org\/id\/kolom-pergeseran-panda\/"},"modified":"2023-07-22T12:34:04","modified_gmt":"2023-07-22T12:34:04","slug":"kolom-pergeseran-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kolom-pergeseran-panda\/","title":{"rendered":"Cara mengimbangi kolom di pandas: dengan contoh"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan fungsi shift()<\/strong> untuk menggeser nilai ke atas atau ke bawah kolom di pandas DataFrame:<\/span><\/p>\n

 #shift values down by 1<\/span>\ndf[' column1<\/span> '] = df[' column1<\/span> ']. shift<\/span> (1)\n\n#shift values up by 1<\/span>\ndf[' column1<\/span> '] = df[' column1<\/span> ']. shift<\/span> (-1)\n<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktik dengan pandas DataFrame berikut:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame\n<\/span>df = pd. DataFrame<\/span> ({' product<\/span> ': ['A', 'B', 'C', 'D', 'E', 'F'],\n                   ' sales<\/span> ': [4, 7, 8, 12, 15, 19]})\n\n#view DataFrame\n<\/span>df\n\n        product sales\n0 to 4\n1 B 7\n2 C 8\n3 D 12\n4 E 15\n5 F 19<\/strong><\/pre>\n
 Contoh 1: Memindahkan kolom ke atas atau ke bawah<\/strong><\/span><\/h3>\n
 Kode berikut menunjukkan cara menggeser semua nilai pada kolom “produk” ke bawah sebanyak 1:<\/span><\/p>\n
 #shift all 'product' values down by 1\n<\/span>df[' product<\/span> '] = df[' product<\/span> ']. shift<\/span> (1)\n\n#view updated DataFrame\n<\/span>df\n\n\tproduct sales\n0 NaN 4\n1 to 7\n2 B 8\n3 C 12\n4 D 15\n5 E 19\n<\/span><\/span><\/strong><\/pre>\n
 Perhatikan bahwa setiap nilai pada kolom \u201cproduk\u201d telah digeser sebesar 1 dan nilai pertama pada kolom tersebut telah diubah menjadi NaN.<\/span><\/p>\n
 Perhatikan juga bahwa nilai terakhir di kolom Produk (“F”) telah dihapus seluruhnya dari DataFrame.<\/span><\/p>\n
 Untuk mempertahankan nilai \u201cF\u201d di DataFrame, pertama-tama kita perlu menambahkan baris kosong di bagian bawah DataFrame dan kemudian melakukan offset:<\/span><\/p>\n
 import<\/span> numpy as<\/span> np\n\n#add empty row to bottom of DataFrame\n<\/span>df. loc<\/span> [len(df. index<\/span> )] = [np. nah<\/span> , np. no<\/span> ]\n\n#shift all 'product' values down by 1\n<\/span>df[' product<\/span> '] = df[' product<\/span> ']. shift<\/span> (1)\n\n#view updated DataFrame\n<\/span>df\n\n\tproduct sales\n0 NaN 4.0\n1 to 7.0\n2B 8.0\n3C 12.0\n4 D 15.0\n5 E 19.0\n6 F NaN\n<\/span><\/span><\/strong><\/pre>\n
 Perhatikan bahwa nilai \u201cF\u201d disimpan sebagai nilai terakhir di kolom \u201cproduk\u201d.<\/span><\/p>\n
 Contoh 2: Pindahkan beberapa kolom ke atas atau ke bawah<\/strong><\/span><\/h3>\n
 Kode berikut menunjukkan cara menggeser semua nilai pada kolom “produk” dan “penjualan” ke atas sebanyak 2:<\/span><\/p>\n
 #shift all 'product' and 'sales' values up by 2\n<\/span>df[[' product<\/span> ', ' sales<\/span> ']] = df[[' product<\/span> ', ' sales<\/span> ']]. shift<\/span> (-2)\n\n#view updated DataFrame\n<\/span>df\n\n        product sales\n0 C 8.0\n1 D 12.0\n2 E 15.0\n3 F 19.0\n4 NaN NaN\n5 NaN NaN\n<\/span><\/span><\/strong><\/pre>\n
 Perhatikan bahwa setiap nilai di kolom “produk” dan “penjualan” telah digeser ke atas sebanyak 2, dan dua nilai terbawah di setiap kolom telah diubah menjadi NaN.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi shift()<\/strong> di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di panda:<\/span><\/p>\n
 Bagaimana cara menambahkan baris ke Pandas DataFrame<\/a>
 Bagaimana cara menambahkan kolom ke Pandas DataFrame
 Bagaimana cara menambahkan baris header ke Pandas DataFrame<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan fungsi shift() untuk menggeser nilai ke atas atau ke bawah kolom di pandas DataFrame: #shift values down by 1 df[‘ column1 ‘] = df[‘ column1 ‘]. shift (1) #shift values up by 1 df[‘ column1 ‘] = df[‘ column1 ‘]. shift (-1) Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktik dengan […]<\/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":"\nCara Mengimbangi Kolom di Pandas (dengan Contoh) \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengimbangi kolom 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-pergeseran-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengimbangi Kolom di Pandas (dengan Contoh) \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengimbangi kolom di pandas DataFrame, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kolom-pergeseran-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T12:34:04+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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/kolom-pergeseran-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/kolom-pergeseran-panda\/\",\"name\":\"Cara Mengimbangi Kolom di Pandas (dengan Contoh) \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T12:34:04+00:00\",\"dateModified\":\"2023-07-22T12:34:04+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengimbangi kolom di pandas DataFrame, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kolom-pergeseran-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kolom-pergeseran-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kolom-pergeseran-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengimbangi kolom 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 Mengimbangi Kolom di Pandas (dengan Contoh) \u2013 Statorial","description":"Tutorial ini menjelaskan cara mengimbangi kolom 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-pergeseran-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengimbangi Kolom di Pandas (dengan Contoh) \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara mengimbangi kolom di pandas DataFrame, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/kolom-pergeseran-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-22T12:34:04+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/kolom-pergeseran-panda\/","url":"https:\/\/statorials.org\/id\/kolom-pergeseran-panda\/","name":"Cara Mengimbangi Kolom di Pandas (dengan Contoh) \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T12:34:04+00:00","dateModified":"2023-07-22T12:34:04+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengimbangi kolom di pandas DataFrame, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kolom-pergeseran-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kolom-pergeseran-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kolom-pergeseran-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengimbangi kolom 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\/2384"}],"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=2384"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2384\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2384"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2384"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2384"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}