{"id":894,"date":"2023-07-28T09:54:10","date_gmt":"2023-07-28T09:54:10","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-ke-json\/"},"modified":"2023-07-28T09:54:10","modified_gmt":"2023-07-28T09:54:10","slug":"panda-ke-json","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-ke-json\/","title":{"rendered":"Cara mengonversi pandas dataframe ke json"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin tertarik untuk mengonversi pandas DataFrame ke format JSON.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan menggunakan<\/span> fungsi <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.DataFrame.to_json.html\" target=\"_blank\" rel=\"noopener\">to_json()<\/a> <span style=\"color: #000000;\">, yang memungkinkan Anda mengonversi DataFrame menjadi string JSON dengan salah satu format berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>&#8216;split&#8217;:<\/strong> dict seperti {&#8216;index&#8217; -&gt; [index], &#8216;columns&#8217; -&gt; [columns], &#8216;data&#8217; -&gt; [values]}<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>&#8216;catatan&#8217;:<\/strong> daftar seperti [{kolom -&gt; nilai}, &#8230;, {kolom -&gt; nilai}]<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>&#8216;indeks&#8217;:<\/strong> dict seperti {index -&gt; {column -&gt; value}}<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>&#8216;kolom&#8217;:<\/strong> dict seperti {kolom -&gt; {index -&gt; value}}<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>&#8216;nilai&#8217;:<\/strong> hanya serangkaian nilai<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>&#8216;tabel&#8217;:<\/strong> dict seperti {&#8216;skema&#8217;: {skema}, &#8216;data&#8217;: {data}}<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tutorial ini menunjukkan cara mengonversi DataFrame ke masing-masing enam format menggunakan pandas DataFrame berikut:<\/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.DataFrame({'points': [25, 12, 15, 19],\n                   'assists': [5, 7, 7, 12]})  \n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n        assist points\n0 25 5\n1 12 7\n2 15 7\n3 19 12\n<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Metode 1: \u201cBagi\u201d<\/strong><\/span><\/h3>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">to_json<\/span> (orient=' <span style=\"color: #008000;\">split<\/span> ')\n\n{\n   \"columns\": [\n      \"points\",\n      \"assists\"\n   ],\n   \"index\": [\n      0,\n      1,\n      2,\n      3\n   ],\n   \"data\": [\n      [\n         25,\n         5\n      ],\n      [\n         12,\n         7\n      ],\n      [\n         15,\n         7\n      ],\n      [\n         19,\n         12\n      ]\n   ]\n}\n<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Metode 2: \u201cRekaman\u201d<\/strong><\/span><\/h3>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">to_json<\/span> (orient=' <span style=\"color: #008000;\">records<\/span> ')\n\n[\n   {\n      \"points\": 25,\n      \u201cassists\u201d: 5\n   },\n   {\n      \"points\": 12,\n      \u201cassists\u201d: 7\n   },\n   {\n      \"points\": 15,\n      \u201cassists\u201d: 7\n   },\n   {\n      \"points\": 19,\n      \u201cassists\u201d: 12\n   }\n]<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Metode 3: \u201cIndeks\u201d<\/strong><\/span><\/h3>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">to_json<\/span> (orient=' <span style=\"color: #008000;\">index<\/span> ') \n\n{\n   \"0\": {\n      \"points\": 25,\n      \u201cassists\u201d: 5\n   },\n   \"1\": {\n      \"points\": 12,\n      \u201cassists\u201d: 7\n   },\n   \"2\": {\n      \"points\": 15,\n      \u201cassists\u201d: 7\n   },\n   \"3\": {\n      \"points\": 19,\n      \u201cassists\u201d: 12\n   }\n}<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Metode 4: \u201cKolom\u201d<\/strong><\/span><\/h3>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">to_json<\/span> (orient=' <span style=\"color: #008000;\">columns<\/span> ') \n\n{\n   \"dots\": {\n      \"0\": 25,\n      \"1\": 12,\n      \"2\": 15,\n      \"3\": 19\n   },\n   \"assists\": {\n      \"0\": 5,\n      \"1\": 7,\n      \"2\": 7,\n      \"3\": 12\n   }\n}\n<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Metode 5: \u201cNilai\u201d<\/strong><\/span><\/h3>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">to_json<\/span> (orient=' <span style=\"color: #008000;\">values<\/span> ') \n\n[\n   [\n      25,\n      5\n   ],\n   [\n      12,\n      7\n   ],\n   [\n      15,\n      7\n   ],\n   [\n      19,\n      12\n   ]\n]<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Metode 6: \u201cMeja\u201d<\/strong><\/span><\/h3>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">to_json<\/span> (orient=' <span style=\"color: #008000;\">table<\/span> ') \n\n{\n   \"plan\": {\n      \"fields\": [\n         {\n            \"name\": \"index\",\n            \"type\": \"integer\"\n         },\n         {\n            \"name\": \"points\",\n            \"type\": \"integer\"\n         },\n         {\n            \"name\": \"assists\",\n            \"type\": \"integer\"\n         }\n      ],\n      \"primaryKey\": [\n         \"index\"\n      ],\n      \"pandas_version\": \"0.20.0\"\n   },\n   \"data\": [\n      {\n         \"index\": 0,\n         \"points\": 25,\n         \u201cassists\u201d: 5\n      },\n      {\n         \"index\": 1,\n         \"points\": 12,\n         \u201cassists\u201d: 7\n      },\n      {\n         \"index\": 2,\n         \"points\": 15,\n         \u201cassists\u201d: 7\n      },\n      {\n         \"index\": 3,\n         \"points\": 19,\n         \u201cassists\u201d: 12\n      }\n   ]\n}<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Cara mengekspor file JSON<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk mengekspor file JSON ke jalur file tertentu di komputer Anda:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#create JSON file<\/span> \njson_file = df. <span style=\"color: #3366ff;\">to_json<\/span> (orient=' <span style=\"color: #008000;\">records<\/span> ') \n\n<span style=\"color: #008080;\">#export JSON file<\/span>\nwith open('my_data.json', 'w') as f:\n    f.write(json_file)\n<\/strong><\/pre>\n<p> <em><span style=\"color: #000000;\">Anda dapat menemukan dokumentasi lengkap fungsi pandas to_json()<\/span> <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.DataFrame.to_json.html\" target=\"_blank\" rel=\"noopener\">di sini<\/a> <span style=\"color: #000000;\">.<\/span><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin tertarik untuk mengonversi pandas DataFrame ke format JSON. Untungnya, hal ini mudah dilakukan menggunakan fungsi to_json() , yang memungkinkan Anda mengonversi DataFrame menjadi string JSON dengan salah satu format berikut: &#8216;split&#8217;: dict seperti {&#8216;index&#8217; -&gt; [index], &#8216;columns&#8217; -&gt; [columns], &#8216;data&#8217; -&gt; [values]} &#8216;catatan&#8217;: daftar seperti [{kolom -&gt; nilai}, &#8230;, {kolom -&gt; nilai}] [&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 mengonversi Pandas DataFrame ke JSON - Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara mengonversi pandas DataFrame ke format JSON.\" \/>\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\/panda-ke-json\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengonversi Pandas DataFrame ke JSON - Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara mengonversi pandas DataFrame ke format JSON.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-ke-json\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T09:54:10+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\/panda-ke-json\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-ke-json\/\",\"name\":\"Cara mengonversi Pandas DataFrame ke JSON - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T09:54:10+00:00\",\"dateModified\":\"2023-07-28T09:54:10+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara mengonversi pandas DataFrame ke format JSON.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-ke-json\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-ke-json\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-ke-json\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengonversi pandas dataframe ke json\"}]},{\"@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 mengonversi Pandas DataFrame ke JSON - Statorials","description":"Penjelasan sederhana tentang cara mengonversi pandas DataFrame ke format JSON.","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\/panda-ke-json\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengonversi Pandas DataFrame ke JSON - Statorials","og_description":"Penjelasan sederhana tentang cara mengonversi pandas DataFrame ke format JSON.","og_url":"https:\/\/statorials.org\/id\/panda-ke-json\/","og_site_name":"Statorials","article_published_time":"2023-07-28T09:54:10+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\/panda-ke-json\/","url":"https:\/\/statorials.org\/id\/panda-ke-json\/","name":"Cara mengonversi Pandas DataFrame ke JSON - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T09:54:10+00:00","dateModified":"2023-07-28T09:54:10+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara mengonversi pandas DataFrame ke format JSON.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-ke-json\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-ke-json\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-ke-json\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengonversi pandas dataframe ke json"}]},{"@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\/894"}],"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=894"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/894\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=894"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}