{"id":1634,"date":"2023-07-25T14:10:30","date_gmt":"2023-07-25T14:10:30","guid":{"rendered":"https:\/\/statorials.org\/id\/korelasi-panda-antara-dua-kolom\/"},"modified":"2023-07-25T14:10:30","modified_gmt":"2023-07-25T14:10:30","slug":"korelasi-panda-antara-dua-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/korelasi-panda-antara-dua-kolom\/","title":{"rendered":"Cara menghitung korelasi antara dua kolom di pandas"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menghitung korelasi antara dua kolom di pandas DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[' <span style=\"color: #ff0000;\">column1<\/span> ']. <span style=\"color: #3366ff;\">corr<\/span> (df[' <span style=\"color: #ff0000;\">column2<\/span> '])\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <strong>Contoh 1: Hitung korelasi antara dua kolom<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menghitung korelasi antar kolom di pandas DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame\n<\/span>df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">points<\/span> ': [25, 12, 15, 14, 19, 23, 25, 29],\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 first five rows of DataFrame\n<\/span>df. <span style=\"color: #3366ff;\">head<\/span> ()\n\n        points assists rebounds\n0 25 5 11\n1 12 7 8\n2 15 7 10\n3 14 9 6\n4 19 12 6\n\n<span style=\"color: #008080;\">#calculate correlation between points and assists\n<\/span>df[' <span style=\"color: #ff0000;\">points<\/span> ']. <span style=\"color: #3366ff;\">corr<\/span> (df[' <span style=\"color: #ff0000;\">assists<\/span> '])\n\n-0.359384\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Koefisien korelasinya sebesar <strong>-0,359<\/strong> . Karena korelasi ini negatif, hal ini menunjukkan bahwa poin dan assist berkorelasi negatif.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dengan kata lain, seiring bertambahnya nilai pada kolom poin, maka nilai pada kolom assist cenderung menurun.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Hitung Signifikansi Korelasi<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk menentukan apakah koefisien korelasi signifikan secara statistik atau tidak, Anda dapat menggunakan fungsi <strong>pearsonr(x, y)<\/strong> dari perpustakaan <a href=\"https:\/\/docs.scipy.org\/doc\/scipy\/reference\/generated\/scipy.stats.pearsonr.html\" target=\"_blank\" rel=\"noopener\">SciPy<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n<span style=\"color: #008000;\">from<\/span> scipy. <span style=\"color: #3366ff;\">stats<\/span> <span style=\"color: #008000;\">import<\/span> pearsonr\n\n<span style=\"color: #008080;\">#createDataFrame\n<\/span>df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">points<\/span> ': [25, 12, 15, 14, 19, 23, 25, 29],\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;\">#calculate p-value of correlation coefficient between points and assists\n<\/span>pearsonr(df[' <span style=\"color: #ff0000;\">points<\/span> '], df[' <span style=\"color: #ff0000;\">assists<\/span> '])\n\n(-0.359384, 0.38192)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Nilai keluaran pertama menampilkan koefisien korelasi (-0,359384) dan nilai kedua menampilkan nilai p (0,38192) yang terkait dengan koefisien korelasi tersebut.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena <a href=\"https:\/\/statorials.org\/id\/p-menghargai-signifikansi-statistik\/\" target=\"_blank\" rel=\"noopener\">nilai p<\/a> tidak kurang dari \u03b1 = 0,05, kami menyimpulkan bahwa korelasi antara poin dan assist tidak signifikan secara statistik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/korelasi-spearman-python\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Korelasi Peringkat Spearman dengan Python<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/python-korelasi-parsial\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung korelasi parsial dengan Python<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/korelasi-silang-dengan-python\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Korelasi Silang dengan Python<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk menghitung korelasi antara dua kolom di pandas DataFrame: df[&#8216; column1 &#8216;]. corr (df[&#8216; column2 &#8216;]) Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh 1: Hitung korelasi antara dua kolom Kode berikut menunjukkan cara menghitung korelasi antar kolom di pandas DataFrame: import pandas as pd #createDataFrame df = [&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 menghitung korelasi antara dua kolom di Pandas<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung korelasi antara dua 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\/korelasi-panda-antara-dua-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung korelasi antara dua kolom di Pandas\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung korelasi antara dua kolom di pandas DataFrame, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/korelasi-panda-antara-dua-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T14:10:30+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\/korelasi-panda-antara-dua-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/korelasi-panda-antara-dua-kolom\/\",\"name\":\"Cara menghitung korelasi antara dua kolom di Pandas\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T14:10:30+00:00\",\"dateModified\":\"2023-07-25T14:10:30+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung korelasi antara dua kolom di pandas DataFrame, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/korelasi-panda-antara-dua-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/korelasi-panda-antara-dua-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/korelasi-panda-antara-dua-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung korelasi antara dua kolom 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":"Cara menghitung korelasi antara dua kolom di Pandas","description":"Tutorial ini menjelaskan cara menghitung korelasi antara dua 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\/korelasi-panda-antara-dua-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung korelasi antara dua kolom di Pandas","og_description":"Tutorial ini menjelaskan cara menghitung korelasi antara dua kolom di pandas DataFrame, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/korelasi-panda-antara-dua-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-25T14:10:30+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\/korelasi-panda-antara-dua-kolom\/","url":"https:\/\/statorials.org\/id\/korelasi-panda-antara-dua-kolom\/","name":"Cara menghitung korelasi antara dua kolom di Pandas","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T14:10:30+00:00","dateModified":"2023-07-25T14:10:30+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung korelasi antara dua kolom di pandas DataFrame, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/korelasi-panda-antara-dua-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/korelasi-panda-antara-dua-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/korelasi-panda-antara-dua-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung korelasi antara dua kolom 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\/1634"}],"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=1634"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1634\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}