{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {},
      "source": [
        "# Teknik Impor & Ekspor Data\n",
        "\n",
        "Dalam pekerjaan sains data nyata, data hampir selalu dimuat dari sumber file eksternal seperti CSV, Excel (.xlsx), atau format JSON."
      ],
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {},
      "source": [
        "## 1. Membaca & Menulis File CSV (`pd.read_csv` & `df.to_csv`)\n",
        "CSV (*Comma Separated Values*) adalah format penyimpanan data tabular yang paling universal."
      ],
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {},
      "source": [
        "import pandas as pd\n",
        "\n",
        "# Membuat data sampel\n",
        "df_sampel = pd.DataFrame({\n",
        "    'Kode': ['A01', 'A02', 'A03', 'A04'],\n",
        "    'Produk': ['Laptop Pro', 'Mouse Wireless', 'Keyboard Mekanikal', 'Monitor 4K'],\n",
        "    'Harga': [14500000, 250000, 850000, 4200000],\n",
        "    'Stok': [12, 45, 28, 15]\n",
        "})\n",
        "\n",
        "# Ekspor ke file CSV lokal\n",
        "df_sampel.to_csv('daftar_produk.csv', index=False)\n",
        "print(\"File CSV berhasil disimpan!\")\n",
        "\n",
        "# Membaca kembali file CSV\n",
        "df_baca = pd.read_csv('daftar_produk.csv')\n",
        "print(\"\n",
        "Hasil Baca File CSV:\n",
        "\", df_baca)"
      ],
      "outputs": [],
      "execution_count": null
    },
    {
      "cell_type": "markdown",
      "metadata": {},
      "source": [
        "## 2. Membaca & Menulis Format JSON (`pd.read_json` & `df.to_json`)"
      ],
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {},
      "source": [
        "# Ekspor ke file JSON\n",
        "df_sampel.to_json('daftar_produk.json', orient='records', indent=2)\n",
        "\n",
        "# Membaca kembali dari JSON\n",
        "df_json = pd.read_json('daftar_produk.json')\n",
        "print(\"Hasil Baca JSON:\n",
        "\", df_json)"
      ],
      "outputs": [],
      "execution_count": null
    },
    {
      "cell_type": "markdown",
      "metadata": {},
      "source": [
        "## 3. Tips Penanganan Delimiter dan Encoding\n",
        "- Gunakan parameter `delimiter=';'` atau `sep='\\t'` jika file menggunakan pemisah titik koma atau tab.\n",
        "- Gunakan `encoding='utf-8'` untuk mendukung karakter khusus atau non-ASCII."
      ],
      "outputs": []
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "name": "python",
      "version": "3.11.0"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 2
}