{"id":3396,"date":"2023-07-17T17:23:18","date_gmt":"2023-07-17T17:23:18","guid":{"rendered":"https:\/\/statorials.org\/id\/pencocokan-fuzzy-di-excel\/"},"modified":"2023-07-17T17:23:18","modified_gmt":"2023-07-17T17:23:18","slug":"pencocokan-fuzzy-di-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pencocokan-fuzzy-di-excel\/","title":{"rendered":"Cara melakukan fuzzy matching di excel (beserta contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin menggabungkan dua kumpulan data di Excel berdasarkan string yang tidak cocok secara sempurna. Hal ini kadang-kadang disebut <strong>pencocokan fuzzy<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Cara termudah untuk melakukannya adalah dengan menggunakan <strong>add-in Fuzzy Lookup<\/strong> untuk Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara menggunakan add-in ini untuk melakukan pencocokan fuzzy.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Unduh Add-on Pencarian Fuzzy<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, kita perlu mengunduh <strong>add-in Fuzzy Lookup<\/strong> dari Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini sepenuhnya gratis dan dapat diunduh hanya dalam beberapa detik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengunduh add-in ini, buka <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=15011\" target=\"_blank\" rel=\"noopener\">halaman Microsoft ini<\/a> dan klik <strong>Unduh<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28482 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/flou1.jpg\" alt=\"\" width=\"624\" height=\"357\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik file <strong>.exe<\/strong> dan ikuti petunjuk untuk menyelesaikan pengunduhan.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Masukkan kedua kumpulan data<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, buka Excel dan masukkan informasi berikut untuk dua kumpulan data:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28483 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/flou2.jpg\" alt=\"\" width=\"465\" height=\"427\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami akan melakukan pencocokan fuzzy untuk mencocokkan nama tim dari dataset pertama dengan nama tim dari dataset kedua.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Buat tabel dari kumpulan data<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Sebelum kita dapat melakukan pencocokan fuzzy, terlebih dahulu kita harus mengubah setiap dataset menjadi sebuah tabel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, sorot rentang sel <strong>A1:B6<\/strong> , lalu tekan <strong>Ctrl+L<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28484 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/flou3.jpg\" alt=\"\" width=\"445\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dataset tersebut akan diubah menjadi tabel dengan nama <strong>Table1<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28485 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/flou4.jpg\" alt=\"\" width=\"417\" height=\"485\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ulangi langkah yang sama untuk mengubah kumpulan data kedua menjadi tabel bernama <strong>Tabel2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28486 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/flou5.jpg\" alt=\"\" width=\"475\" height=\"512\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Lakukan pencocokan fuzzy<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Untuk melakukan pencocokan fuzzy, klik tab <strong>Pencarian Fuzzy<\/strong> di sepanjang pita atas:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28487 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/flou6.jpg\" alt=\"\" width=\"621\" height=\"282\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik ikon <strong>Fuzzy Search<\/strong> pada tab ini untuk menampilkan panel <strong>Fuzzy Search<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pilih Tabel1 untuk <strong>tabel kiri<\/strong> dan Tabel2 untuk <strong>tabel kanan<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian sorot Tim untuk <strong>kolom kiri<\/strong> dan Tim untuk <strong>kolom kanan<\/strong> dan klik ikon gabung di antara kotak, lalu klik <strong>Buka<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28488 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/flou8.jpg\" alt=\"\" width=\"511\" height=\"704\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hasil pencocokan fuzzy akan ditampilkan di sel yang sedang aktif di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28490 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/flou9.jpg\" alt=\"\" width=\"481\" height=\"445\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari hasilnya, kita dapat melihat bahwa Excel mampu mencocokkan nama setiap tim di antara dua kumpulan data tersebut, kecuali Kings.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Excel juga menampilkan skor <strong>kesamaan<\/strong> , yang mewakili kesamaan antara 0 dan 1 dari dua nama yang cocok.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jangan ragu untuk menyesuaikan skor kesamaan minimum di panel <strong>Pencarian Fuzzy<\/strong> untuk memungkinkan pencocokan nilai teks dengan skor kesamaan lebih rendah.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/menghitung-frekuensi-teks-di-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung frekuensi teks di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-memeriksa-apakah-sel-berisi-teks-daftar\/\" target=\"_blank\" rel=\"noopener\">Cara memeriksa apakah sel berisi teks daftar di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-excel-jika-sel-berisi-teks\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung rata-rata jika sel berisi teks di Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin menggabungkan dua kumpulan data di Excel berdasarkan string yang tidak cocok secara sempurna. Hal ini kadang-kadang disebut pencocokan fuzzy . Cara termudah untuk melakukannya adalah dengan menggunakan add-in Fuzzy Lookup untuk Excel. Contoh langkah demi langkah berikut menunjukkan cara menggunakan add-in ini untuk melakukan pencocokan fuzzy. Langkah 1: Unduh Add-on Pencarian [&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 Melakukan Fuzzy Matching di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan pencocokan fuzzy di Excel, dengan contoh langkah demi langkah.\" \/>\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\/pencocokan-fuzzy-di-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Fuzzy Matching di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan pencocokan fuzzy di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pencocokan-fuzzy-di-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T17:23:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/flou1.jpg\" \/>\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\/pencocokan-fuzzy-di-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/pencocokan-fuzzy-di-excel\/\",\"name\":\"Cara Melakukan Fuzzy Matching di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T17:23:18+00:00\",\"dateModified\":\"2023-07-17T17:23:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan pencocokan fuzzy di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pencocokan-fuzzy-di-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pencocokan-fuzzy-di-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pencocokan-fuzzy-di-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan fuzzy matching di excel (beserta 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 Melakukan Fuzzy Matching di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara melakukan pencocokan fuzzy di Excel, dengan contoh langkah demi langkah.","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\/pencocokan-fuzzy-di-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Fuzzy Matching di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara melakukan pencocokan fuzzy di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/pencocokan-fuzzy-di-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-17T17:23:18+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/flou1.jpg"}],"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\/pencocokan-fuzzy-di-excel\/","url":"https:\/\/statorials.org\/id\/pencocokan-fuzzy-di-excel\/","name":"Cara Melakukan Fuzzy Matching di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T17:23:18+00:00","dateModified":"2023-07-17T17:23:18+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan pencocokan fuzzy di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pencocokan-fuzzy-di-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pencocokan-fuzzy-di-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pencocokan-fuzzy-di-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan fuzzy matching di excel (beserta 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\/3396"}],"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=3396"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3396\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3396"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3396"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}