{"id":2032,"date":"2023-07-24T00:23:35","date_gmt":"2023-07-24T00:23:35","guid":{"rendered":"https:\/\/statorials.org\/id\/pencarian-panda\/"},"modified":"2023-07-24T00:23:35","modified_gmt":"2023-07-24T00:23:35","slug":"pencarian-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pencarian-panda\/","title":{"rendered":"Bagaimana melakukan vlookup di pandas"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk melakukan VLOOKUP (mirip dengan Excel) di panda:<\/span><\/p>\n

 p.d. merge<\/span> (df1,\n         df2,\n         on = ' column_name<\/span> ',\n         how = ' left<\/span> ')\n<\/strong><\/pre>\n
 Contoh langkah demi langkah berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Langkah 1: Buat dua DataFrame<\/strong><\/span><\/h3>\n
 Pertama, mari impor panda dan buat dua panda DataFrames:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#define first DataFrame\n<\/span>df1 = pd. DataFrame<\/span> ({' player<\/span> ': ['A', 'B', 'C', 'D', 'E', 'F'],\n                    ' team<\/span> ': ['Mavs', 'Mavs', 'Mavs', 'Mavs', 'Nets', 'Nets']})\n\n#define second DataFrame\n<\/span>df2 = pd. DataFrame<\/span> ({' player<\/span> ': ['A', 'B', 'C', 'D', 'E', 'F'],\n                    ' points<\/span> ': [22, 29, 34, 20, 15, 19]})\n\n#view df1\n<\/span>print<\/span> (df1)\n\n  player team\n0 A Mavs\n1 B Mavs\n2C Mavs\n3 D Mavs\n4 E Nets\n5 F Nets\n\n#view df2\n<\/span>print<\/span> (df2)\n\n  player points\n0 to 22\n1 B 29\n2 C 34\n3 D 20\n4 E 15\n5 F 19\n<\/strong><\/pre>\n
 Langkah 2: Jalankan fungsi VLOOKUP<\/strong><\/span><\/h3>\n
 Fungsi VLOOKUP<\/strong> di Excel memungkinkan Anda menemukan nilai dalam tabel dengan mencocokkannya pada kolom.<\/span><\/p>\n
 Kode berikut menunjukkan cara menemukan tim pemain menggunakan pd.merge()<\/strong> untuk mencocokkan nama pemain di antara dua tabel dan mengembalikan tim pemain:<\/span><\/p>\n
 #perform VLOOKUP<\/span>\njoined_df = pd. merge<\/span> (df1,\n                     df2,\n                     we = ' player<\/span> ',\n                     how = ' left<\/span> ')\n\n#view results\n<\/span>joined_df\n\n\tplayer team points\n0 A Mavs 22\n1 B Mavs 29\n2 C Mavs 34\n3D Mavs 20\n4 E Nets 15\n5 F Nets 19<\/strong><\/pre>\n
 Perhatikan bahwa pandas DataFrame yang dihasilkan berisi informasi tentang pemain, timnya, dan poin yang dicetak.<\/span><\/p>\n
 Anda dapat menemukan dokumentasi online lengkap tentang fungsi pandas merge()<\/strong> di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan operasi umum lainnya dengan Python:<\/span><\/p>\n
 Cara Membuat PivotTable dengan Python
 Cara menghitung korelasi dengan Python<\/a>
 Cara menghitung persentil dengan Python<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk melakukan VLOOKUP (mirip dengan Excel) di panda: p.d. merge (df1, df2, on = ‘ column_name ‘, how = ‘ left ‘) Contoh langkah demi langkah berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Langkah 1: Buat dua DataFrame Pertama, mari impor panda dan buat dua panda DataFrames: import […]<\/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":"\nBagaimana melakukan VLOOKUP di Pandas - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan VLOOKUP (mirip dengan Excel) di panda, 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\/pencarian-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana melakukan VLOOKUP di Pandas - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan VLOOKUP (mirip dengan Excel) di panda, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pencarian-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T00:23:35+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\/pencarian-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/pencarian-panda\/\",\"name\":\"Bagaimana melakukan VLOOKUP di Pandas - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T00:23:35+00:00\",\"dateModified\":\"2023-07-24T00:23:35+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan VLOOKUP (mirip dengan Excel) di panda, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pencarian-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pencarian-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pencarian-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana melakukan vlookup di pandas\"}]},{\"@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":"Bagaimana melakukan VLOOKUP di Pandas - Statorials","description":"Tutorial ini menjelaskan cara melakukan VLOOKUP (mirip dengan Excel) di panda, 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\/pencarian-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana melakukan VLOOKUP di Pandas - Statorials","og_description":"Tutorial ini menjelaskan cara melakukan VLOOKUP (mirip dengan Excel) di panda, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/pencarian-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-24T00:23:35+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\/pencarian-panda\/","url":"https:\/\/statorials.org\/id\/pencarian-panda\/","name":"Bagaimana melakukan VLOOKUP di Pandas - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T00:23:35+00:00","dateModified":"2023-07-24T00:23:35+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan VLOOKUP (mirip dengan Excel) di panda, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pencarian-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pencarian-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pencarian-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana melakukan vlookup di pandas"}]},{"@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\/2032"}],"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=2032"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2032\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2032"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2032"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2032"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}