{"id":4309,"date":"2023-07-12T02:48:52","date_gmt":"2023-07-12T02:48:52","guid":{"rendered":"https:\/\/statorials.org\/id\/kueri-panda-dengan-variabel\/"},"modified":"2023-07-12T02:48:52","modified_gmt":"2023-07-12T02:48:52","slug":"kueri-panda-dengan-variabel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kueri-panda-dengan-variabel\/","title":{"rendered":"Pandas: cara menggunakan variabel dalam fungsi query()"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menggunakan fungsi <strong>query()<\/strong> di panda dan mereferensikan nama variabel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">query<\/span> (' <span style=\"color: #ff0000;\">team == @team_name<\/span> ')<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kueri khusus ini mencari baris dalam pandas DataFrame yang kolom <strong>teamnya<\/strong> sama dengan nilai yang disimpan dalam variabel bernama <strong>team_name<\/strong> .<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara menggunakan variabel dalam query Pandas<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki pandas DataFrame berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #107d3f;\">import<\/span> pandas <span style=\"color: #107d3f;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['A', 'A', 'A', 'B', 'B', 'B', 'B', 'C', 'C', 'C', 'C '],\n                   ' <span style=\"color: #ff0000;\">position<\/span> ':['G', 'G', 'F', 'G', 'F', 'F', 'F', 'G', 'G', 'F', 'F'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [22, 25, 24, 39, 34, 20, 18, 17, 20, 19, 22]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n   team position points\n0 AG 22\n1 AG 25\n2 AF 24\n3 BG 39\n4 BF 34\n5 BF 20\n6 BF 18\n7 GC 17\n8 GC 20\n9 CF 19\n10 CF 22\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita ingin mencari baris yang nilai pada kolom <strong>tim<\/strong> sama dengan C.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk membuat variabel bernama <strong>nama_tim<\/strong> yang sama dengan &#8220;C&#8221;, lalu mereferensikan variabel ini dalam fungsi <strong>query()<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#specify team name to search for\n<\/span>team_name = ' <span style=\"color: #ff0000;\">C<\/span> '\n\n<span style=\"color: #008080;\">#query for rows where team is equal to team_name\n<\/span>df. <span style=\"color: #3366ff;\">query<\/span> (' <span style=\"color: #ff0000;\">team == @team_name<\/span> ')\n\n        team position points\n7 C G 17\n8 C G 20\n9 C F 19\n10 C F 22<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa fungsi <strong>query()<\/strong> mengembalikan semua baris yang nilai dalam kolom <strong>tim<\/strong> sama dengan C.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan juga bahwa kita bisa mereferensikan beberapa variabel dalam fungsi <strong>query()<\/strong> jika kita mau.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kode berikut menunjukkan cara menggunakan fungsi <strong>query()<\/strong> untuk mengembalikan semua baris yang nilai dalam kolom <strong>tim<\/strong> sama dengan nilai variabel yang disebut <strong>team_A<\/strong> <em>atau<\/em> variabel yang disebut <strong>team_C<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#create two variables\n<span style=\"color: #000000;\">team_A = ' <span style=\"color: #ff0000;\">A<\/span> ' \n<\/span><\/span>team_C = ' <span style=\"color: #ff0000;\">C<\/span> '\n\n<span style=\"color: #008080;\">#query for rows where team is equal to either of the two variables\n<\/span>df. <span style=\"color: #3366ff;\">query<\/span> (' <span style=\"color: #ff0000;\">team == @team_A | team == @team_C<\/span> ')\n\n        team position points\n0 A G 22\n1 A G 25\n2 A F 24\n7 C G 17\n8 C G 20\n9 C F 19\n10 C F 22\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kueri mengembalikan semua baris di DataFrame dengan <strong>tim<\/strong> sama dengan nilai yang disimpan di salah satu dari dua variabel yang kami tentukan.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas <strong>query()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.DataFrame.query.html\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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 panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/panda-memfilter-garis-berdasarkan-panjang-string\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara memfilter baris berdasarkan panjang string<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-dengan-syarat\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menghapus baris berdasarkan kondisi<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tidak-ada-panda\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menggunakan filter \u201cNO IN\u201d.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk menggunakan fungsi query() di panda dan mereferensikan nama variabel: df. query (&#8216; team == @team_name &#8216;) Kueri khusus ini mencari baris dalam pandas DataFrame yang kolom teamnya sama dengan nilai yang disimpan dalam variabel bernama team_name . Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: Cara menggunakan [&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 menggunakan variabel dalam fungsi query() - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan variabel dalam fungsi pandas query(), dengan sebuah 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\/kueri-panda-dengan-variabel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara menggunakan variabel dalam fungsi query() - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan variabel dalam fungsi pandas query(), dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kueri-panda-dengan-variabel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T02:48:52+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\/kueri-panda-dengan-variabel\/\",\"url\":\"https:\/\/statorials.org\/id\/kueri-panda-dengan-variabel\/\",\"name\":\"Pandas: Cara menggunakan variabel dalam fungsi query() - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T02:48:52+00:00\",\"dateModified\":\"2023-07-12T02:48:52+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan variabel dalam fungsi pandas query(), dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kueri-panda-dengan-variabel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kueri-panda-dengan-variabel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kueri-panda-dengan-variabel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menggunakan variabel dalam fungsi query()\"}]},{\"@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 menggunakan variabel dalam fungsi query() - Statorial","description":"Tutorial ini menjelaskan cara menggunakan variabel dalam fungsi pandas query(), dengan sebuah 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\/kueri-panda-dengan-variabel\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menggunakan variabel dalam fungsi query() - Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan variabel dalam fungsi pandas query(), dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/kueri-panda-dengan-variabel\/","og_site_name":"Statorials","article_published_time":"2023-07-12T02:48:52+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\/kueri-panda-dengan-variabel\/","url":"https:\/\/statorials.org\/id\/kueri-panda-dengan-variabel\/","name":"Pandas: Cara menggunakan variabel dalam fungsi query() - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T02:48:52+00:00","dateModified":"2023-07-12T02:48:52+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan variabel dalam fungsi pandas query(), dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kueri-panda-dengan-variabel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kueri-panda-dengan-variabel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kueri-panda-dengan-variabel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menggunakan variabel dalam fungsi query()"}]},{"@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\/4309"}],"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=4309"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4309\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}