{"id":901,"date":"2023-07-28T09:19:31","date_gmt":"2023-07-28T09:19:31","guid":{"rendered":"https:\/\/statorials.org\/id\/kerangka-data-json-ke-pandas\/"},"modified":"2023-07-28T09:19:31","modified_gmt":"2023-07-28T09:19:31","slug":"kerangka-data-json-ke-pandas","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kerangka-data-json-ke-pandas\/","title":{"rendered":"Cara mengonversi file json ke pandas dataframe"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Terkadang Anda mungkin ingin mengonversi file JSON menjadi pandas DataFrame. Untungnya, hal ini mudah dilakukan menggunakan fungsi pandas <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.read_json.html\" target=\"_blank\" rel=\"noopener noreferrer\">read_json()<\/a> , yang menggunakan sintaks berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>read_json(&#8216;jalur&#8217;, orientasi=&#8217;indeks&#8217;)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>jalur:<\/strong> jalur ke file JSON Anda.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>orient:<\/strong> orientasi file JSON. Standarnya adalah &#8220;indeks&#8221;, tetapi Anda dapat menentukan &#8220;split&#8221;, &#8220;records&#8221;, &#8220;columns&#8221;, atau &#8220;values&#8221;.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini untuk berbagai string JSON yang berbeda.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Mengonversi file JSON dengan format \u201cRecords\u201d.<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki file JSON bernama <strong>my_file.json<\/strong> dalam format berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 14px;\"> <strong>[<\/strong><span style=\"color: #000000;\"><strong>\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><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat memuat file JSON ini ke dalam pandas DataFrame hanya dengan menentukan jalur dengan orient=&#8217; <strong>Records<\/strong> &#8216; sebagai berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 14px;\"> <strong><span style=\"color: #000000;\"><span style=\"color: #008080;\">#load JSON file into pandas DataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">read_json<\/span> ('C:\/Users\/Zach\/Desktop\/json_file.json',<\/span> orient=' <span style=\"color: #008000;\">records<\/span> ')\n\n<span style=\"color: #008080;\">#view DataFrame\n<span style=\"color: #000000;\">df\n\n        assist points\n0 5 25\n1 7 12\n2 7 15\n3 12 19\n<\/span><\/span><\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Mengonversi file JSON dengan format \u201cIndeks\u201d.<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki file JSON bernama <strong>my_file.json<\/strong> dalam format berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 14px;\"> <strong>{\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<p> <span style=\"color: #000000;\">Kita dapat memuat file JSON ini ke dalam pandas DataFrame hanya dengan menentukan jalur dengan orient=&#8217; <strong>index<\/strong> &#8216; sebagai berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 14px;\"> <strong><span style=\"color: #000000;\"><span style=\"color: #008080;\">#load JSON file into pandas DataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">read_json<\/span> ('C:\/Users\/Zach\/Desktop\/json_file.json',<\/span> orient=' <span style=\"color: #008000;\">index<\/span> ')\n\n<span style=\"color: #008080;\">#view DataFrame\n<span style=\"color: #000000;\">df\n\n        assist points\n0 5 25\n1 7 12\n2 7 15\n3 12 19\n<\/span><\/span><\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Mengonversi file JSON dengan format \u201cKolom\u201d.<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki file JSON bernama <strong>my_file.json<\/strong> dalam format berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 14px;\"> <strong>{\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}<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat memuat file JSON ini ke dalam pandas DataFrame hanya dengan menentukan jalur dengan orient=&#8217; <strong>kolom<\/strong> &#8216; sebagai berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 14px;\"> <strong><span style=\"color: #000000;\"><span style=\"color: #008080;\">#load JSON file into pandas DataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">read_json<\/span> ('C:\/Users\/Zach\/Desktop\/json_file.json',<\/span> orient=' <span style=\"color: #008000;\">columns<\/span> ')\n\n<span style=\"color: #008080;\">#view DataFrame\n<span style=\"color: #000000;\">df\n\n        assist points\n0 5 25\n1 7 12\n2 7 15\n3 12 19<\/span><\/span><\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 4: Mengonversi file JSON dengan format \u201cNilai\u201d.<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki file JSON bernama <strong>my_file.json<\/strong> dalam format berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 14px;\"> <strong>[\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<p> <span style=\"color: #000000;\">Kita dapat memuat file JSON ini ke dalam pandas DataFrame hanya dengan menentukan jalur dengan orient=&#8217; <strong>values<\/strong> &#8216; sebagai berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 14px;\"> <strong><span style=\"color: #000000;\"><span style=\"color: #008080;\">#load JSON file into pandas DataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">read_json<\/span> ('C:\/Users\/Zach\/Desktop\/json_file.json',<\/span> orient=' <span style=\"color: #008000;\">values<\/span> ')\n\n<span style=\"color: #008080;\">#view DataFrame\n<span style=\"color: #000000;\">df\n\n        0<\/span> <span style=\"color: #000000;\">1\n0 25 5\n1 12 7\n2 15 7\n3 19 12\n3 12 19<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><em>Anda dapat menemukan dokumentasi lengkap fungsi read_json() <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.read_json.html\" target=\"_blank\" rel=\"noopener noreferrer\">di sini<\/a> .<\/em><\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/panda-membaca-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara membaca file Excel dengan Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-membaca-csv\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara membaca file CSV dengan Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Terkadang Anda mungkin ingin mengonversi file JSON menjadi pandas DataFrame. Untungnya, hal ini mudah dilakukan menggunakan fungsi pandas read_json() , yang menggunakan sintaks berikut: read_json(&#8216;jalur&#8217;, orientasi=&#8217;indeks&#8217;) Emas: jalur: jalur ke file JSON Anda. orient: orientasi file JSON. Standarnya adalah &#8220;indeks&#8221;, tetapi Anda dapat menentukan &#8220;split&#8221;, &#8220;records&#8221;, &#8220;columns&#8221;, atau &#8220;values&#8221;. Contoh berikut menunjukkan cara menggunakan fungsi [&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 file JSON ke Pandas DataFrame - Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara mengonversi file JSON menjadi pandas DataFrame.\" \/>\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\/kerangka-data-json-ke-pandas\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengonversi file JSON ke Pandas DataFrame - Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara mengonversi file JSON menjadi pandas DataFrame.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kerangka-data-json-ke-pandas\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T09:19:31+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\/kerangka-data-json-ke-pandas\/\",\"url\":\"https:\/\/statorials.org\/id\/kerangka-data-json-ke-pandas\/\",\"name\":\"Cara mengonversi file JSON ke Pandas DataFrame - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T09:19:31+00:00\",\"dateModified\":\"2023-07-28T09:19:31+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara mengonversi file JSON menjadi pandas DataFrame.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kerangka-data-json-ke-pandas\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kerangka-data-json-ke-pandas\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kerangka-data-json-ke-pandas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengonversi file json ke pandas dataframe\"}]},{\"@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 file JSON ke Pandas DataFrame - Statorials","description":"Penjelasan sederhana tentang cara mengonversi file JSON menjadi pandas DataFrame.","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\/kerangka-data-json-ke-pandas\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengonversi file JSON ke Pandas DataFrame - Statorials","og_description":"Penjelasan sederhana tentang cara mengonversi file JSON menjadi pandas DataFrame.","og_url":"https:\/\/statorials.org\/id\/kerangka-data-json-ke-pandas\/","og_site_name":"Statorials","article_published_time":"2023-07-28T09:19:31+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\/kerangka-data-json-ke-pandas\/","url":"https:\/\/statorials.org\/id\/kerangka-data-json-ke-pandas\/","name":"Cara mengonversi file JSON ke Pandas DataFrame - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T09:19:31+00:00","dateModified":"2023-07-28T09:19:31+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara mengonversi file JSON menjadi pandas DataFrame.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kerangka-data-json-ke-pandas\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kerangka-data-json-ke-pandas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kerangka-data-json-ke-pandas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengonversi file json ke pandas dataframe"}]},{"@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\/901"}],"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=901"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/901\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=901"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=901"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}