3-1 Pandas 檔案輸入與輸出.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "868197df",
   "metadata": {},
   "source": [
    "# 有關檔案編碼的部分，請參考這個連結\n",
    "[standard-encodings](https://docs.python.org/3/library/codecs.html#standard-encodings)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "da4e9e76",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 安裝套件\n",
    "!pip install pandas openpyxl"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "0aa8cc86",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 匯入套件\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ba1bde58",
   "metadata": {},
   "source": [
    "# 讀寫 csv 檔\n",
    "- CSV: Comma-Separated Values\n",
    "  - pd.read_csv(): 讀取 csv 檔\n",
    "  - df.to_csv(): 寫入 csv 檔\n",
    "- 請另存下載 [csv檔: 垃圾車點位路線資訊](https://data.taipei/api/frontstage/tpeod/dataset/resource.download?rid=a6e90031-7ec4-4089-afb5-361a4efe7202) 到專案目錄當中。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "773ed123",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>行政區</th>\n",
       "      <th>里別</th>\n",
       "      <th>分隊</th>\n",
       "      <th>局編</th>\n",
       "      <th>車號</th>\n",
       "      <th>路線</th>\n",
       "      <th>車次</th>\n",
       "      <th>抵達時間</th>\n",
       "      <th>離開時間</th>\n",
       "      <th>地點</th>\n",
       "      <th>緯度</th>\n",
       "      <th>經度</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>中山區</td>\n",
       "      <td>力行里</td>\n",
       "      <td>長安分隊</td>\n",
       "      <td>100-021</td>\n",
       "      <td>119-BQ</td>\n",
       "      <td>長安-3</td>\n",
       "      <td>第1車</td>\n",
       "      <td>1630</td>\n",
       "      <td>1638</td>\n",
       "      <td>臺北市中山區建國北路一段69號前</td>\n",
       "      <td>121.536944</td>\n",
       "      <td>25.051111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>中山區</td>\n",
       "      <td>力行里</td>\n",
       "      <td>長安分隊</td>\n",
       "      <td>100-021</td>\n",
       "      <td>119-BQ</td>\n",
       "      <td>長安-3</td>\n",
       "      <td>第1車</td>\n",
       "      <td>1640</td>\n",
       "      <td>1649</td>\n",
       "      <td>臺北市中山區南京東路三段176號前(遼寧街口)</td>\n",
       "      <td>121.542222</td>\n",
       "      <td>25.051944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>中山區</td>\n",
       "      <td>力行里</td>\n",
       "      <td>長安分隊</td>\n",
       "      <td>100-021</td>\n",
       "      <td>119-BQ</td>\n",
       "      <td>長安-3</td>\n",
       "      <td>第1車</td>\n",
       "      <td>1650</td>\n",
       "      <td>1658</td>\n",
       "      <td>臺北市中山區南京東路三段214號前</td>\n",
       "      <td>121.543385</td>\n",
       "      <td>25.051725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>中山區</td>\n",
       "      <td>力行里</td>\n",
       "      <td>長安分隊</td>\n",
       "      <td>100-021</td>\n",
       "      <td>119-BQ</td>\n",
       "      <td>長安-3</td>\n",
       "      <td>第1車</td>\n",
       "      <td>1700</td>\n",
       "      <td>1709</td>\n",
       "      <td>臺北市中山區復興北路66號</td>\n",
       "      <td>121.543853</td>\n",
       "      <td>25.050820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>中山區</td>\n",
       "      <td>力行里</td>\n",
       "      <td>長安分隊</td>\n",
       "      <td>100-021</td>\n",
       "      <td>119-BQ</td>\n",
       "      <td>長安-3</td>\n",
       "      <td>第1車</td>\n",
       "      <td>1710</td>\n",
       "      <td>1716</td>\n",
       "      <td>臺北市中山區復興北路28號前</td>\n",
       "      <td>121.543813</td>\n",
       "      <td>25.048861</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4043</th>\n",
       "      <td>萬華區</td>\n",
       "      <td>新起里</td>\n",
       "      <td>漢中分隊</td>\n",
       "      <td>110-G01</td>\n",
       "      <td>KEJ-0038</td>\n",
       "      <td>漢中-1</td>\n",
       "      <td>第3車</td>\n",
       "      <td>2141</td>\n",
       "      <td>2145</td>\n",
       "      <td>臺北市萬華區內江街110號前</td>\n",
       "      <td>121.503430</td>\n",
       "      <td>25.041577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4044</th>\n",
       "      <td>萬華區</td>\n",
       "      <td>新起里</td>\n",
       "      <td>漢中分隊</td>\n",
       "      <td>110-G01</td>\n",
       "      <td>KEJ-0038</td>\n",
       "      <td>漢中-1</td>\n",
       "      <td>第3車</td>\n",
       "      <td>2146</td>\n",
       "      <td>2150</td>\n",
       "      <td>臺北市萬華區內江街74之1號前</td>\n",
       "      <td>121.504185</td>\n",
       "      <td>25.041492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4045</th>\n",
       "      <td>萬華區</td>\n",
       "      <td>西門里</td>\n",
       "      <td>漢中分隊</td>\n",
       "      <td>110-G01</td>\n",
       "      <td>KEJ-0038</td>\n",
       "      <td>漢中-1</td>\n",
       "      <td>第3車</td>\n",
       "      <td>2151</td>\n",
       "      <td>2155</td>\n",
       "      <td>臺北市萬華區昆明街160號前</td>\n",
       "      <td>121.504607</td>\n",
       "      <td>25.042125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4046</th>\n",
       "      <td>萬華區</td>\n",
       "      <td>西門里</td>\n",
       "      <td>漢中分隊</td>\n",
       "      <td>110-G01</td>\n",
       "      <td>KEJ-0038</td>\n",
       "      <td>漢中-1</td>\n",
       "      <td>第3車</td>\n",
       "      <td>2156</td>\n",
       "      <td>2200</td>\n",
       "      <td>臺北市萬華區昆明街134之2號前</td>\n",
       "      <td>121.504724</td>\n",
       "      <td>25.042720</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4047</th>\n",
       "      <td>萬華區</td>\n",
       "      <td>西門里</td>\n",
       "      <td>漢中分隊</td>\n",
       "      <td>110-G01</td>\n",
       "      <td>KEJ-0038</td>\n",
       "      <td>漢中-1</td>\n",
       "      <td>第3車</td>\n",
       "      <td>2201</td>\n",
       "      <td>2205</td>\n",
       "      <td>臺北市萬華區成都路105號前</td>\n",
       "      <td>121.504207</td>\n",
       "      <td>25.043244</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4048 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      行政區   里別    分隊       局編        車號    路線   車次  抵達時間  離開時間   \n",
       "0     中山區  力行里  長安分隊  100-021    119-BQ  長安-3  第1車  1630  1638  \\\n",
       "1     中山區  力行里  長安分隊  100-021    119-BQ  長安-3  第1車  1640  1649   \n",
       "2     中山區  力行里  長安分隊  100-021    119-BQ  長安-3  第1車  1650  1658   \n",
       "3     中山區  力行里  長安分隊  100-021    119-BQ  長安-3  第1車  1700  1709   \n",
       "4     中山區  力行里  長安分隊  100-021    119-BQ  長安-3  第1車  1710  1716   \n",
       "...   ...  ...   ...      ...       ...   ...  ...   ...   ...   \n",
       "4043  萬華區  新起里  漢中分隊  110-G01  KEJ-0038  漢中-1  第3車  2141  2145   \n",
       "4044  萬華區  新起里  漢中分隊  110-G01  KEJ-0038  漢中-1  第3車  2146  2150   \n",
       "4045  萬華區  西門里  漢中分隊  110-G01  KEJ-0038  漢中-1  第3車  2151  2155   \n",
       "4046  萬華區  西門里  漢中分隊  110-G01  KEJ-0038  漢中-1  第3車  2156  2200   \n",
       "4047  萬華區  西門里  漢中分隊  110-G01  KEJ-0038  漢中-1  第3車  2201  2205   \n",
       "\n",
       "                           地點          緯度         經度  \n",
       "0            臺北市中山區建國北路一段69號前  121.536944  25.051111  \n",
       "1     臺北市中山區南京東路三段176號前(遼寧街口)  121.542222  25.051944  \n",
       "2           臺北市中山區南京東路三段214號前  121.543385  25.051725  \n",
       "3               臺北市中山區復興北路66號  121.543853  25.050820  \n",
       "4              臺北市中山區復興北路28號前  121.543813  25.048861  \n",
       "...                       ...         ...        ...  \n",
       "4043           臺北市萬華區內江街110號前  121.503430  25.041577  \n",
       "4044          臺北市萬華區內江街74之1號前  121.504185  25.041492  \n",
       "4045           臺北市萬華區昆明街160號前  121.504607  25.042125  \n",
       "4046         臺北市萬華區昆明街134之2號前  121.504724  25.042720  \n",
       "4047           臺北市萬華區成都路105號前  121.504207  25.043244  \n",
       "\n",
       "[4048 rows x 12 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 讀取 csv 格式檔案\n",
    "'''\n",
    "pd.read_csv(\n",
    "    filepath_or_buffer=\"你的檔案路徑\", \n",
    "    sep=\"分隔符號\", \n",
    "    header=True或False, \n",
    "    index=True或False, \n",
    "    encoding=None, \n",
    "    ...\n",
    ")\n",
    "\n",
    "說明:\n",
    "- 引數 filepath_or_buffer不一定要寫: \n",
    "  - df = pd.read_csv(\"./output.csv\")\n",
    "- 近年許多檔案或資料，都使用 UTF-8 進行編碼\n",
    "  - 一般來說，只要是 utf-8 編碼格式儲存的檔案，讀取成 dataframe 時候，不用特別指定編碼。\n",
    "  - 然而本例使用的 csv 檔，需要用 ANSI 編碼來開啟。\n",
    "'''\n",
    "df = pd.read_csv(\"./files/垃圾車點位資訊.csv\", encoding=\"big5\"); df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "12b22911",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 寫入 csv 檔案\n",
    "'''\n",
    "預設是 row number 和 column name 都包括進去，不習慣加進 csv 檔的話，可以這樣寫:\n",
    "df.to_csv(path_or_buf=\"./output.csv\", index=False, header=False)\n",
    "\n",
    "另外，引數 path_or_buf 不一定要寫:\n",
    "df.to_csv(\"./output.csv\", index=False, header=False)\n",
    "'''\n",
    "df.to_csv(\"./output.csv\", index=False, encoding=\"big5\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "51ac8806",
   "metadata": {},
   "source": [
    "# 讀寫 json 檔\n",
    "- JSON（JavaScript Object Notation）\n",
    "  - pd.read_json(): 讀取 json 檔\n",
    "  - df.to_json(): 寫入 json 檔\n",
    "- 使用 [Cafe Nomad](https://cafenomad.tw/developers/docs/v1.2) 的資料來測試。\n",
    "  - 請另存下載: [https://cafenomad.tw/api/v1.2/cafes/taipei](https://cafenomad.tw/api/v1.2/cafes/taipei)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "e1e7bd3c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>city</th>\n",
       "      <th>wifi</th>\n",
       "      <th>seat</th>\n",
       "      <th>quiet</th>\n",
       "      <th>tasty</th>\n",
       "      <th>cheap</th>\n",
       "      <th>music</th>\n",
       "      <th>url</th>\n",
       "      <th>address</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>limited_time</th>\n",
       "      <th>socket</th>\n",
       "      <th>standing_desk</th>\n",
       "      <th>mrt</th>\n",
       "      <th>open_time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>000703fe-cf8a-43c8-bd83-c90cfd61915f</td>\n",
       "      <td>蜂巢咖啡</td>\n",
       "      <td>taipei</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.5</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>https://www.facebook.com/honeycombcafe2016/</td>\n",
       "      <td>新北市永和區永貞路214號</td>\n",
       "      <td>25.004097</td>\n",
       "      <td>121.515287</td>\n",
       "      <td>no</td>\n",
       "      <td>no</td>\n",
       "      <td>yes</td>\n",
       "      <td>永安市場站</td>\n",
       "      <td>雙週四公休，有變更另外公告</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0022fc3b-598f-4bb5-bb69-1b7d1b9b5202</td>\n",
       "      <td>(暫停營業) The Kaffa Lovers</td>\n",
       "      <td>taipei</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>https://www.facebook.com/thekaffalovers/?fref=ts</td>\n",
       "      <td>台北市中正區金山北路3號</td>\n",
       "      <td>25.044354</td>\n",
       "      <td>121.530456</td>\n",
       "      <td>no</td>\n",
       "      <td>maybe</td>\n",
       "      <td>yes</td>\n",
       "      <td>忠孝新生</td>\n",
       "      <td>週二至週五 10:00-19:00            六日09:00-19:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>005a5ee9-7460-4f8a-b965-8b9565ee1e4e</td>\n",
       "      <td>一杯咖啡士林店</td>\n",
       "      <td>taipei</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>https://www.facebook.com/acupofcoffeeshilin/</td>\n",
       "      <td>台北市士林區中山北路五段505巷36號</td>\n",
       "      <td>25.093021</td>\n",
       "      <td>121.526678</td>\n",
       "      <td>no</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>00971781-cad6-4a6f-8a38-b597d8a1488b</td>\n",
       "      <td>Full of Beans 充滿豆豆咖啡館</td>\n",
       "      <td>taipei</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>https://www.facebook.com/FOBcafe.gallery/</td>\n",
       "      <td>台北市中山區龍江路21巷9-6號</td>\n",
       "      <td>25.047838</td>\n",
       "      <td>121.541138</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>00b6ce2b-d92e-44e5-b1cb-daaa925a5135</td>\n",
       "      <td>良食究好市集餐廳WONMI</td>\n",
       "      <td>taipei</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>http://www.wonmi.com.tw/home.php</td>\n",
       "      <td>台北市八德路四段138號 (京華城 Living Mall 10 F)</td>\n",
       "      <td>25.048354</td>\n",
       "      <td>121.562300</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1652</th>\n",
       "      <td>ff53abc4-7a89-43db-8d0b-43e5b00dff5f</td>\n",
       "      <td>喜穗咖啡蘭花生活館（永久停業）</td>\n",
       "      <td>taipei</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td></td>\n",
       "      <td>242新北市新莊區中原東路206號</td>\n",
       "      <td>25.054470</td>\n",
       "      <td>121.460515</td>\n",
       "      <td></td>\n",
       "      <td>maybe</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1653</th>\n",
       "      <td>ff582eb9-3f83-4f65-98b2-c38a4ef511db</td>\n",
       "      <td>自然產</td>\n",
       "      <td>taipei</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>https://www.facebook.com/greenday209/</td>\n",
       "      <td>新北市板橋區重慶路209號</td>\n",
       "      <td>25.001575</td>\n",
       "      <td>121.462947</td>\n",
       "      <td>maybe</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1654</th>\n",
       "      <td>ff973c43-9474-46dc-bb24-0d1947143ba1</td>\n",
       "      <td>金獅取水</td>\n",
       "      <td>taipei</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>https://www.facebook.com/goldenlionkafe</td>\n",
       "      <td>台北市中山區民生東路2段151號</td>\n",
       "      <td>25.058156</td>\n",
       "      <td>121.535403</td>\n",
       "      <td>maybe</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1655</th>\n",
       "      <td>ffd780fe-9d33-4a4b-90dd-74d7d9de31f7</td>\n",
       "      <td>The Tuckaway Taipei</td>\n",
       "      <td>taipei</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>IG FB tuckawaytaipei</td>\n",
       "      <td>台北市文山區木柵路三段48巷1弄6號1樓</td>\n",
       "      <td>24.987979</td>\n",
       "      <td>121.565233</td>\n",
       "      <td>no</td>\n",
       "      <td>maybe</td>\n",
       "      <td>no</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1656</th>\n",
       "      <td>fff8267f-3235-4eb5-95c1-36015a59b229</td>\n",
       "      <td>豆工場精品咖啡館</td>\n",
       "      <td>taipei</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td></td>\n",
       "      <td>新北市中和區中和路400巷31號</td>\n",
       "      <td>25.002081</td>\n",
       "      <td>121.512065</td>\n",
       "      <td>maybe</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>永安市場</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1657 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        id                     name    city   \n",
       "0     000703fe-cf8a-43c8-bd83-c90cfd61915f                     蜂巢咖啡  taipei  \\\n",
       "1     0022fc3b-598f-4bb5-bb69-1b7d1b9b5202  (暫停營業) The Kaffa Lovers  taipei   \n",
       "2     005a5ee9-7460-4f8a-b965-8b9565ee1e4e                  一杯咖啡士林店  taipei   \n",
       "3     00971781-cad6-4a6f-8a38-b597d8a1488b    Full of Beans 充滿豆豆咖啡館  taipei   \n",
       "4     00b6ce2b-d92e-44e5-b1cb-daaa925a5135            良食究好市集餐廳WONMI  taipei   \n",
       "...                                    ...                      ...     ...   \n",
       "1652  ff53abc4-7a89-43db-8d0b-43e5b00dff5f          喜穗咖啡蘭花生活館（永久停業）  taipei   \n",
       "1653  ff582eb9-3f83-4f65-98b2-c38a4ef511db                      自然產  taipei   \n",
       "1654  ff973c43-9474-46dc-bb24-0d1947143ba1                     金獅取水  taipei   \n",
       "1655  ffd780fe-9d33-4a4b-90dd-74d7d9de31f7     The Tuckaway Taipei   taipei   \n",
       "1656  fff8267f-3235-4eb5-95c1-36015a59b229                 豆工場精品咖啡館  taipei   \n",
       "\n",
       "      wifi  seat  quiet  tasty  cheap  music   \n",
       "0      0.0   4.5    3.0    5.0    4.0    4.0  \\\n",
       "1      5.0   5.0    5.0    5.0    4.0    5.0   \n",
       "2      0.0   0.0    0.0    0.0    0.0    0.0   \n",
       "3      0.0   0.0    0.0    0.0    0.0    0.0   \n",
       "4      5.0   3.0    3.0    5.0    0.0    5.0   \n",
       "...    ...   ...    ...    ...    ...    ...   \n",
       "1652   0.0   0.0    0.0    0.0    0.0    0.0   \n",
       "1653   3.0   5.0    4.0    4.0    3.0    3.0   \n",
       "1654   0.0   0.0    0.0    0.0    0.0    0.0   \n",
       "1655   5.0   5.0    5.0    5.0    5.0    4.0   \n",
       "1656   4.0   4.0    4.0    4.0    4.0    4.0   \n",
       "\n",
       "                                                   url   \n",
       "0          https://www.facebook.com/honeycombcafe2016/  \\\n",
       "1     https://www.facebook.com/thekaffalovers/?fref=ts   \n",
       "2         https://www.facebook.com/acupofcoffeeshilin/   \n",
       "3            https://www.facebook.com/FOBcafe.gallery/   \n",
       "4                     http://www.wonmi.com.tw/home.php   \n",
       "...                                                ...   \n",
       "1652                                                     \n",
       "1653             https://www.facebook.com/greenday209/   \n",
       "1654           https://www.facebook.com/goldenlionkafe   \n",
       "1655                              IG FB tuckawaytaipei   \n",
       "1656                                                     \n",
       "\n",
       "                                   address   latitude   longitude   \n",
       "0                            新北市永和區永貞路214號  25.004097  121.515287  \\\n",
       "1                             台北市中正區金山北路3號  25.044354  121.530456   \n",
       "2                      台北市士林區中山北路五段505巷36號  25.093021  121.526678   \n",
       "3                         台北市中山區龍江路21巷9-6號  25.047838  121.541138   \n",
       "4     台北市八德路四段138號 (京華城 Living Mall 10 F)   25.048354  121.562300   \n",
       "...                                    ...        ...         ...   \n",
       "1652                     242新北市新莊區中原東路206號  25.054470  121.460515   \n",
       "1653                         新北市板橋區重慶路209號  25.001575  121.462947   \n",
       "1654                      台北市中山區民生東路2段151號  25.058156  121.535403   \n",
       "1655                  台北市文山區木柵路三段48巷1弄6號1樓  24.987979  121.565233   \n",
       "1656                      新北市中和區中和路400巷31號  25.002081  121.512065   \n",
       "\n",
       "     limited_time socket standing_desk    mrt   \n",
       "0              no     no           yes  永安市場站  \\\n",
       "1              no  maybe           yes   忠孝新生   \n",
       "2              no    yes           yes          \n",
       "3                                               \n",
       "4                                               \n",
       "...           ...    ...           ...    ...   \n",
       "1652               maybe            no          \n",
       "1653        maybe    yes            no          \n",
       "1654        maybe    yes           yes          \n",
       "1655           no  maybe            no          \n",
       "1656        maybe    yes           yes   永安市場   \n",
       "\n",
       "                                        open_time  \n",
       "0                                   雙週四公休，有變更另外公告  \n",
       "1     週二至週五 10:00-19:00            六日09:00-19:00   \n",
       "2                                                  \n",
       "3                                                  \n",
       "4                                                  \n",
       "...                                           ...  \n",
       "1652                                               \n",
       "1653                                               \n",
       "1654                                               \n",
       "1655                                               \n",
       "1656                                               \n",
       "\n",
       "[1657 rows x 18 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 讀取 json 格式檔案\n",
    "'''\n",
    "參考連結:\n",
    "[1] pandas.read_json\n",
    "https://pandas.pydata.org/docs/reference/api/pandas.read_json.html\n",
    "[2] pandas.json_normalize\n",
    "https://pandas.pydata.org/docs/reference/api/pandas.json_normalize.html\n",
    "'''\n",
    "df = pd.read_json('./files/taipei.json'); df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "39dc90ce",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 寫入 json 檔案\n",
    "'''\n",
    "參考連結:\n",
    "[1] pandas.DataFrame.to_json\n",
    "https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_json.html\n",
    "'''\n",
    "df.to_json(\n",
    "    './output.json', \n",
    "    indent=None, \n",
    "    orient='records', \n",
    "    lines=False, \n",
    "    force_ascii=False\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7b1cbd38",
   "metadata": {},
   "source": [
    "# 讀寫 xml\n",
    "- eXtensible Markup Language\n",
    "  - pd.read_xml(): 讀取 xml 檔\n",
    "  - df.to_xml(): 寫入 xml 檔\n",
    "- 使用 [臺北市政府求職徵才職缺資訊](https://data.taipei/dataset/detail?id=f2f3f0d3-9e84-4fc5-af4d-5814563e17b3) 的資料來測試\n",
    "  - 請另存下載: [https://dop.blob.core.windows.net/ipsnworkcontainer/jobs.xml](https://dop.blob.core.windows.net/ipsnworkcontainer/jobs.xml)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "6c8e2f2c",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>No</th>\n",
       "      <th>dept_code</th>\n",
       "      <th>dept_name</th>\n",
       "      <th>Job_no</th>\n",
       "      <th>Modify_date</th>\n",
       "      <th>tel</th>\n",
       "      <th>level</th>\n",
       "      <th>job_Kind_Name</th>\n",
       "      <th>title</th>\n",
       "      <th>pop_Kind_Name</th>\n",
       "      <th>...</th>\n",
       "      <th>apply_rule</th>\n",
       "      <th>job_desc</th>\n",
       "      <th>job_location_Name</th>\n",
       "      <th>job_address</th>\n",
       "      <th>official_rule</th>\n",
       "      <th>is_duty</th>\n",
       "      <th>Special_rule</th>\n",
       "      <th>contact</th>\n",
       "      <th>File_Path</th>\n",
       "      <th>Note</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>379590000E</td>\n",
       "      <td>臺北市政府文化局</td>\n",
       "      <td>62120</td>\n",
       "      <td>112/04/06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280薪點，月支報酬新臺幣36,316元</td>\n",
       "      <td>無</td>\n",
       "      <td>約僱科員</td>\n",
       "      <td>約僱人員</td>\n",
       "      <td>...</td>\n",
       "      <td>一、中華民國國民並無雙重國籍者。&lt;br&gt;二、大專以上畢業者。&lt;br&gt;三、具土木、建築、營建工...</td>\n",
       "      <td>一、古蹟、歷史建築等文化資產修復及文化設施之委託技術服務招標、工程招標、施工監督及驗收等相關...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>臺北市政府文化局(11008 臺北市信義區市府路一號四樓)</td>\n",
       "      <td>否</td>\n",
       "      <td>無需輪值</td>\n",
       "      <td>歡迎身心障礙、歡迎原住民族</td>\n",
       "      <td>報名應繳文件：\\n一、個人履歷表。\\n二、最高學歷畢業證書等資料影本（國內外學歷須經教育部認...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>379670000G</td>\n",
       "      <td>臺北市政府產業發展局</td>\n",
       "      <td>62119</td>\n",
       "      <td>112/04/06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280薪點</td>\n",
       "      <td>無</td>\n",
       "      <td>約僱辦事員</td>\n",
       "      <td>約僱人員</td>\n",
       "      <td>...</td>\n",
       "      <td>1、國內外之公、私立大專以上學校畢業。&lt;br&gt;2、具中華民國國籍，無公務人員任用法第26、2...</td>\n",
       "      <td>1.辦理工廠設立登記、動產擔保交易登記。&lt;br&gt;2.工廠管理輔導法相關法規與專案性質業務與查...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>臺北市信義區市府路1號北區10樓</td>\n",
       "      <td>否</td>\n",
       "      <td>無需輪值</td>\n",
       "      <td>歡迎身心障礙、歡迎原住民族</td>\n",
       "      <td>1、本職缺⽉薪280薪點，折合為新臺幣36,316元，尚需扣除勞、健保及勞退個⼈⾃付等費⽤。...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>379040300E</td>\n",
       "      <td>臺北市立圖書館</td>\n",
       "      <td>62118</td>\n",
       "      <td>112/04/06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>280薪點</td>\n",
       "      <td>無</td>\n",
       "      <td>政風室約僱課員</td>\n",
       "      <td>約僱人員</td>\n",
       "      <td>...</td>\n",
       "      <td>(一)國內外專科以上學校畢業者。&lt;br&gt;  (二)高級中等學校畢業，並具有與擬任工作性質相當...</td>\n",
       "      <td>（一）廉政宣導。&lt;br&gt;（二）安全維護業務。&lt;br&gt;（三）錄影監視系統管理。&lt;br&gt;（四）採...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>臺北市立圖書館政風室(106210 臺北市大安區建國南路二段125號7樓)</td>\n",
       "      <td>否</td>\n",
       "      <td>無需輪值</td>\n",
       "      <td>歡迎身心障礙、歡迎原住民族</td>\n",
       "      <td>(一)意者請檢具履歷、自傳及相關學歷畢業證書影本，如具政風、工程或建築管理及與本職務相關之實...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>379490000A</td>\n",
       "      <td>臺北市文山區公所</td>\n",
       "      <td>62117</td>\n",
       "      <td>112/04/06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>約僱5等280薪點(約新台幣36,316元)</td>\n",
       "      <td>無</td>\n",
       "      <td>約僱人員</td>\n",
       "      <td>約僱人員</td>\n",
       "      <td>...</td>\n",
       "      <td>1.國內外大專以上學校畢業，或高級中等學校畢業，並具有與擬任工作性質相當之訓練6個月以上或2...</td>\n",
       "      <td>1.總收文及相關公文處理等業務。&lt;br&gt;2.協助檔案管理相關作業。&lt;br&gt;3.每日郵局寄信及...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>116008臺北市文山區木柵路３段220號8、9樓</td>\n",
       "      <td>否</td>\n",
       "      <td>無需輪值</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(一)網路報名者：請於公告日期截止前至行政院人事行政總處「事求人」網頁－本職缺公告點選「我要...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>379064100X</td>\n",
       "      <td>臺北市立北政國民中學</td>\n",
       "      <td>62116</td>\n",
       "      <td>112/04/06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>委任第5職等至薦任第7職等</td>\n",
       "      <td>綜合行政</td>\n",
       "      <td>事務組長</td>\n",
       "      <td>一般人員</td>\n",
       "      <td>...</td>\n",
       "      <td>一、經銓敘合格實授委任第五職等(含)以上，並具綜合行政職系任用資格之&lt;br&gt;公務人員，且無特...</td>\n",
       "      <td>一、大額工程發包、大額財物招標、大額勞物招標。&lt;br&gt;二、各招標合約製作及採購案之擴充續約等...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>臺北市立北政國民中學總務處(臺北市文山區指南路三段 2 巷 14 號)。</td>\n",
       "      <td>是</td>\n",
       "      <td>無需輪值</td>\n",
       "      <td>NaN</td>\n",
       "      <td>(02)29393651轉12，聯絡人：劉主任。</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>145</td>\n",
       "      <td>379700300A</td>\n",
       "      <td>臺北市建成地政事務所</td>\n",
       "      <td>61824</td>\n",
       "      <td>112/04/06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>委任第5職等或薦任第6職等至第7職等</td>\n",
       "      <td>地政</td>\n",
       "      <td>課員</td>\n",
       "      <td>一般人員</td>\n",
       "      <td>...</td>\n",
       "      <td>1.教育部認可之國內外大專以上學歷，且具地政職系任用資格者。&lt;br&gt;2.熟稔地政業務，具審查...</td>\n",
       "      <td>1.辦理土地登記案件審查。&lt;br&gt;2.承辦相關公文業務。&lt;br&gt;3.土地登記法令諮詢服務。&lt;...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>臺北市建成地政事務所(臺北市萬華區和平西路3段120號7~9樓)</td>\n",
       "      <td>是</td>\n",
       "      <td>無需輪值</td>\n",
       "      <td>歡迎身心障礙、歡迎原住民族</td>\n",
       "      <td>(一)\\t本職缺採線上作業方式，意者請於112年4月6日前進入行政院人事行政總處「事求人」徵...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>146</td>\n",
       "      <td>379145700I</td>\n",
       "      <td>臺北市中山區健康服務中心</td>\n",
       "      <td>61806</td>\n",
       "      <td>112/04/06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>無</td>\n",
       "      <td>無</td>\n",
       "      <td>技工</td>\n",
       "      <td>技工</td>\n",
       "      <td>...</td>\n",
       "      <td>1.需為臺北市政府所屬各機關現職技工、工友或駕駛，並符合下列資格條件：&lt;br&gt;(1)國民小學...</td>\n",
       "      <td>1.公文交換。&lt;br&gt;2.辦公機具簡易維護。&lt;br&gt;3.環境清潔及維護。&lt;br&gt;4.協助庶務...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>臺北市中山區健康服務中心（臺北市中山區松江路367號7樓）</td>\n",
       "      <td>否</td>\n",
       "      <td>無需輪值</td>\n",
       "      <td>歡迎身心障礙、歡迎原住民族</td>\n",
       "      <td>1.請將「調僱意願表」親自簽章後，併同履歷表（亦可採用公務人員簡式履歷表）、畢業證書影本、身...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>147</td>\n",
       "      <td>379023300A</td>\n",
       "      <td>臺北市中山區戶政事務所</td>\n",
       "      <td>61770</td>\n",
       "      <td>112/04/06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>無</td>\n",
       "      <td>無</td>\n",
       "      <td>工友</td>\n",
       "      <td>工友</td>\n",
       "      <td>...</td>\n",
       "      <td>需為臺北市政府所屬各機關學校現職職工，並符合下列資格條件：&lt;br&gt;1.國小以上畢業或具有同等...</td>\n",
       "      <td>1.行政庶務（市府公文交換及繳款外勤工作等）。&lt;br&gt;2.勞務工作（辦公廳舍打掃清潔等）。&lt;...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>臺北市中山區戶政事務所（臺北市中山區松江路367號2樓）</td>\n",
       "      <td>否</td>\n",
       "      <td>無需輪值</td>\n",
       "      <td>歡迎身心障礙、歡迎原住民族</td>\n",
       "      <td>一、符合資格條件且有意願者，請填妥事務工友甄選履歷表及職工調僱意願表後由當事人簽章，並檢附(...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>148</td>\n",
       "      <td>379091000Y</td>\n",
       "      <td>臺北市中山區濱江國民小學</td>\n",
       "      <td>61758</td>\n",
       "      <td>112/04/06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>無</td>\n",
       "      <td>無</td>\n",
       "      <td>代理教師</td>\n",
       "      <td>代理教師</td>\n",
       "      <td>...</td>\n",
       "      <td>凡中華民國國民，且身心健康、品德優良，無現行教師法第14條、109年6月30日施行之教師法第...</td>\n",
       "      <td>幼兒園教學工作(詳見簡章)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>臺北市中山區濱江國民小學(臺北市中山區樂群二路266巷99號)</td>\n",
       "      <td>否</td>\n",
       "      <td>無需輪值</td>\n",
       "      <td>歡迎身心障礙、歡迎原住民族</td>\n",
       "      <td>一、甄選類別與員額：\\n代理教師職缺(幼兒園差假代理教師，詳見簡章11-20招)\\n二、報考...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>149</td>\n",
       "      <td>379110300G</td>\n",
       "      <td>臺北市政府工務局公園路燈工程管理處</td>\n",
       "      <td>61726</td>\n",
       "      <td>112/04/06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>聘用7等-支328薪點(約新台幣42,541元/每月)</td>\n",
       "      <td>無</td>\n",
       "      <td>職務代理約僱人員(A620087)</td>\n",
       "      <td>聘用人員</td>\n",
       "      <td>...</td>\n",
       "      <td>1.具中華民國國籍，且未具雙重國籍者。&lt;br&gt;2.無公務人員任用法第26條、28條所列各款情...</td>\n",
       "      <td>1.綜理大安區所轄公園維護相關業務。&lt;br&gt;2.綜理大安區公文彙辦、會勘、陳情業務。&lt;br&gt;...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>臺北市政府工務局公園路燈工程管理處\\n青年公園管理所</td>\n",
       "      <td>否</td>\n",
       "      <td>無需輪值</td>\n",
       "      <td>歡迎身心障礙、歡迎原住民族</td>\n",
       "      <td>1.配合行政院人事行政總處(下稱人事總處)推動線上徵才作業，本職缺應徵作業一律採線上方式辦理...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>149 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      No   dept_code          dept_name  Job_no Modify_date  tel   \n",
       "0      1  379590000E           臺北市政府文化局   62120   112/04/06  NaN  \\\n",
       "1      2  379670000G         臺北市政府產業發展局   62119   112/04/06  NaN   \n",
       "2      3  379040300E            臺北市立圖書館   62118   112/04/06  NaN   \n",
       "3      4  379490000A           臺北市文山區公所   62117   112/04/06  NaN   \n",
       "4      5  379064100X         臺北市立北政國民中學   62116   112/04/06  NaN   \n",
       "..   ...         ...                ...     ...         ...  ...   \n",
       "144  145  379700300A         臺北市建成地政事務所   61824   112/04/06  NaN   \n",
       "145  146  379145700I       臺北市中山區健康服務中心   61806   112/04/06  NaN   \n",
       "146  147  379023300A        臺北市中山區戶政事務所   61770   112/04/06  NaN   \n",
       "147  148  379091000Y       臺北市中山區濱江國民小學   61758   112/04/06  NaN   \n",
       "148  149  379110300G  臺北市政府工務局公園路燈工程管理處   61726   112/04/06  NaN   \n",
       "\n",
       "                           level job_Kind_Name              title   \n",
       "0           280薪點，月支報酬新臺幣36,316元             無               約僱科員  \\\n",
       "1                          280薪點             無              約僱辦事員   \n",
       "2                          280薪點             無            政風室約僱課員   \n",
       "3         約僱5等280薪點(約新台幣36,316元)             無               約僱人員   \n",
       "4                  委任第5職等至薦任第7職等          綜合行政               事務組長   \n",
       "..                           ...           ...                ...   \n",
       "144           委任第5職等或薦任第6職等至第7職等            地政                 課員   \n",
       "145                            無             無                 技工   \n",
       "146                            無             無                 工友   \n",
       "147                            無             無               代理教師   \n",
       "148  聘用7等-支328薪點(約新台幣42,541元/每月)             無  職務代理約僱人員(A620087)   \n",
       "\n",
       "    pop_Kind_Name  ...                                         apply_rule   \n",
       "0            約僱人員  ...  一、中華民國國民並無雙重國籍者。<br>二、大專以上畢業者。<br>三、具土木、建築、營建工...  \\\n",
       "1            約僱人員  ...  1、國內外之公、私立大專以上學校畢業。<br>2、具中華民國國籍，無公務人員任用法第26、2...   \n",
       "2            約僱人員  ...  (一)國內外專科以上學校畢業者。<br>  (二)高級中等學校畢業，並具有與擬任工作性質相當...   \n",
       "3            約僱人員  ...  1.國內外大專以上學校畢業，或高級中等學校畢業，並具有與擬任工作性質相當之訓練6個月以上或2...   \n",
       "4            一般人員  ...  一、經銓敘合格實授委任第五職等(含)以上，並具綜合行政職系任用資格之<br>公務人員，且無特...   \n",
       "..            ...  ...                                                ...   \n",
       "144          一般人員  ...  1.教育部認可之國內外大專以上學歷，且具地政職系任用資格者。<br>2.熟稔地政業務，具審查...   \n",
       "145            技工  ...  1.需為臺北市政府所屬各機關現職技工、工友或駕駛，並符合下列資格條件：<br>(1)國民小學...   \n",
       "146            工友  ...  需為臺北市政府所屬各機關學校現職職工，並符合下列資格條件：<br>1.國小以上畢業或具有同等...   \n",
       "147          代理教師  ...  凡中華民國國民，且身心健康、品德優良，無現行教師法第14條、109年6月30日施行之教師法第...   \n",
       "148          聘用人員  ...  1.具中華民國國籍，且未具雙重國籍者。<br>2.無公務人員任用法第26條、28條所列各款情...   \n",
       "\n",
       "                                              job_desc job_location_Name   \n",
       "0    一、古蹟、歷史建築等文化資產修復及文化設施之委託技術服務招標、工程招標、施工監督及驗收等相關...               NaN  \\\n",
       "1    1.辦理工廠設立登記、動產擔保交易登記。<br>2.工廠管理輔導法相關法規與專案性質業務與查...               NaN   \n",
       "2    （一）廉政宣導。<br>（二）安全維護業務。<br>（三）錄影監視系統管理。<br>（四）採...               NaN   \n",
       "3    1.總收文及相關公文處理等業務。<br>2.協助檔案管理相關作業。<br>3.每日郵局寄信及...               NaN   \n",
       "4    一、大額工程發包、大額財物招標、大額勞物招標。<br>二、各招標合約製作及採購案之擴充續約等...               NaN   \n",
       "..                                                 ...               ...   \n",
       "144  1.辦理土地登記案件審查。<br>2.承辦相關公文業務。<br>3.土地登記法令諮詢服務。<...               NaN   \n",
       "145  1.公文交換。<br>2.辦公機具簡易維護。<br>3.環境清潔及維護。<br>4.協助庶務...               NaN   \n",
       "146  1.行政庶務（市府公文交換及繳款外勤工作等）。<br>2.勞務工作（辦公廳舍打掃清潔等）。<...               NaN   \n",
       "147                                      幼兒園教學工作(詳見簡章)               NaN   \n",
       "148  1.綜理大安區所轄公園維護相關業務。<br>2.綜理大安區公文彙辦、會勘、陳情業務。<br>...               NaN   \n",
       "\n",
       "                               job_address official_rule is_duty   \n",
       "0            臺北市政府文化局(11008 臺北市信義區市府路一號四樓)             否    無需輪值  \\\n",
       "1                         臺北市信義區市府路1號北區10樓             否    無需輪值   \n",
       "2    臺北市立圖書館政風室(106210 臺北市大安區建國南路二段125號7樓)             否    無需輪值   \n",
       "3                116008臺北市文山區木柵路３段220號8、9樓             否    無需輪值   \n",
       "4     臺北市立北政國民中學總務處(臺北市文山區指南路三段 2 巷 14 號)。             是    無需輪值   \n",
       "..                                     ...           ...     ...   \n",
       "144       臺北市建成地政事務所(臺北市萬華區和平西路3段120號7~9樓)             是    無需輪值   \n",
       "145          臺北市中山區健康服務中心（臺北市中山區松江路367號7樓）             否    無需輪值   \n",
       "146           臺北市中山區戶政事務所（臺北市中山區松江路367號2樓）             否    無需輪值   \n",
       "147        臺北市中山區濱江國民小學(臺北市中山區樂群二路266巷99號)             否    無需輪值   \n",
       "148             臺北市政府工務局公園路燈工程管理處\\n青年公園管理所             否    無需輪值   \n",
       "\n",
       "      Special_rule                                            contact   \n",
       "0    歡迎身心障礙、歡迎原住民族  報名應繳文件：\\n一、個人履歷表。\\n二、最高學歷畢業證書等資料影本（國內外學歷須經教育部認...  \\\n",
       "1    歡迎身心障礙、歡迎原住民族  1、本職缺⽉薪280薪點，折合為新臺幣36,316元，尚需扣除勞、健保及勞退個⼈⾃付等費⽤。...   \n",
       "2    歡迎身心障礙、歡迎原住民族  (一)意者請檢具履歷、自傳及相關學歷畢業證書影本，如具政風、工程或建築管理及與本職務相關之實...   \n",
       "3              NaN  (一)網路報名者：請於公告日期截止前至行政院人事行政總處「事求人」網頁－本職缺公告點選「我要...   \n",
       "4              NaN                           (02)29393651轉12，聯絡人：劉主任。   \n",
       "..             ...                                                ...   \n",
       "144  歡迎身心障礙、歡迎原住民族  (一)\\t本職缺採線上作業方式，意者請於112年4月6日前進入行政院人事行政總處「事求人」徵...   \n",
       "145  歡迎身心障礙、歡迎原住民族  1.請將「調僱意願表」親自簽章後，併同履歷表（亦可採用公務人員簡式履歷表）、畢業證書影本、身...   \n",
       "146  歡迎身心障礙、歡迎原住民族  一、符合資格條件且有意願者，請填妥事務工友甄選履歷表及職工調僱意願表後由當事人簽章，並檢附(...   \n",
       "147  歡迎身心障礙、歡迎原住民族  一、甄選類別與員額：\\n代理教師職缺(幼兒園差假代理教師，詳見簡章11-20招)\\n二、報考...   \n",
       "148  歡迎身心障礙、歡迎原住民族  1.配合行政院人事行政總處(下稱人事總處)推動線上徵才作業，本職缺應徵作業一律採線上方式辦理...   \n",
       "\n",
       "    File_Path Note  \n",
       "0         NaN  NaN  \n",
       "1         NaN  NaN  \n",
       "2         NaN  NaN  \n",
       "3         NaN  NaN  \n",
       "4         NaN  NaN  \n",
       "..        ...  ...  \n",
       "144       NaN  NaN  \n",
       "145       NaN  NaN  \n",
       "146       NaN  NaN  \n",
       "147       NaN  NaN  \n",
       "148       NaN  NaN  \n",
       "\n",
       "[149 rows x 24 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 讀取 xml 格式檔案\n",
    "'''\n",
    "參考連結:\n",
    "[1] pandas.read_xml\n",
    "https://pandas.pydata.org/docs/reference/api/pandas.read_xml.html\n",
    "'''\n",
    "df = pd.read_xml(\"./files/jobs.xml\"); df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "9f0b5649",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 寫入 xml 檔案\n",
    "'''\n",
    "參考連結:\n",
    "[1] pandas.DataFrame.to_xml\n",
    "https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_xml.html\n",
    "'''\n",
    "df.to_xml(\"./output.xml\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5fe3cbe7",
   "metadata": {},
   "source": [
    "# 讀寫 excel\n",
    "- 語法: \n",
    "  - pd.read_excel(): 讀取 excel 檔\n",
    "  - df.to_excel(): 寫入 excel 檔\n",
    "- 記得先安裝套件: `pip install openpyxl`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "f16823c7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>中文姓名</th>\n",
       "      <th>電話</th>\n",
       "      <th>英文名稱</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>楊○○</td>\n",
       "      <td>978000000</td>\n",
       "      <td>Darren</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>林○○</td>\n",
       "      <td>910000000</td>\n",
       "      <td>Lin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>江○○</td>\n",
       "      <td>939000000</td>\n",
       "      <td>Jiang</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  中文姓名         電話    英文名稱\n",
       "0  楊○○  978000000  Darren\n",
       "1  林○○  910000000     Lin\n",
       "2  江○○  939000000   Jiang"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 讀取 excel 格式檔案\n",
    "'''\n",
    "參考連結:\n",
    "[1] openpyxl - A Python library to read/write Excel 2010 xlsx/xlsm files\n",
    "https://openpyxl.readthedocs.io/en/stable/\n",
    "[2] pandas.read_excel\n",
    "https://pandas.pydata.org/docs/reference/api/pandas.read_excel.html\n",
    "'''\n",
    "\n",
    "df = pd.read_excel(\"./files/通訊錄.xlsx\"); df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "82d25004",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 寫入 excel 檔案\n",
    "'''\n",
    "參考連結:\n",
    "[1] pandas.DataFrame.to_excel\n",
    "https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_excel.html\n",
    "'''\n",
    "df.to_excel(\"./output.xlsx\", index=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "python3@nlp",
   "language": "python",
   "name": "k_nlp"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}