Skip to content

Instantly share code, notes, and snippets.

@rs6000

rs6000/exchange_TaiwanBank.ipynb

Last active November 17, 2019 02:58
Show Gist options
  • Save rs6000/544edf629a0ee5c4bce29682738c0548 to your computer and use it in GitHub Desktop.
Save rs6000/544edf629a0ee5c4bce29682738c0548 to your computer and use it in GitHub Desktop.
Download ZIP
台灣銀行牌告匯率
Display the source blob
Display the rendered blob
Raw
exchange_TaiwanBank.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"scrolled": false
},
"outputs": [],
"source": [
"#\n",
"#抓取台灣銀行牌告匯率 by 大數學堂\n",
"#http://www.largitdata.com\n",
"\n",
"import pandas as pd\n",
"from datetime import datetime\n",
"import sqlite3\n",
"\n",
"#source\n",
"url=\"http://rate.bot.com.tw/xrt?Lang=zh-TW\"\n",
"\n",
"#讀取網頁\n",
"dfs=pd.read_html(url)\n",
"\n",
"#測試\n",
"#type(dfs)\n",
"#len(dfs)\n",
"\n",
"#資料呈現\n",
"#dfs[0]\n",
"\n",
"currency=dfs[0]\n",
"\n"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {
"scrolled": true
},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/home/smile_hsu/.local/lib/python3.5/site-packages/ipykernel_launcher.py:18: FutureWarning: currently extract(expand=None) means expand=False (return Index/Series/DataFrame) but in a future version of pandas this will be changed to expand=True (return DataFrame)\n"
]
},
{
"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",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>USD</td>\n",
" <td>29.555</td>\n",
" <td>30.097</td>\n",
" <td>29.855</td>\n",
" <td>29.955</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>HKD</td>\n",
" <td>3.664</td>\n",
" <td>3.854</td>\n",
" <td>3.779</td>\n",
" <td>3.839</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>GBP</td>\n",
" <td>39.32</td>\n",
" <td>41.25</td>\n",
" <td>40.19</td>\n",
" <td>40.61</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>AUD</td>\n",
" <td>22.16</td>\n",
" <td>22.82</td>\n",
" <td>22.35</td>\n",
" <td>22.58</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>CAD</td>\n",
" <td>22.96</td>\n",
" <td>23.7</td>\n",
" <td>23.23</td>\n",
" <td>23.45</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>SGD</td>\n",
" <td>21.77</td>\n",
" <td>22.55</td>\n",
" <td>22.19</td>\n",
" <td>22.37</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>CHF</td>\n",
" <td>29.22</td>\n",
" <td>30.28</td>\n",
" <td>29.75</td>\n",
" <td>30.04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>JPY</td>\n",
" <td>0.2613</td>\n",
" <td>0.2723</td>\n",
" <td>0.2677</td>\n",
" <td>0.2717</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>ZAR</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" <td>2.34</td>\n",
" <td>2.42</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>SEK</td>\n",
" <td>3.04</td>\n",
" <td>3.55</td>\n",
" <td>3.38</td>\n",
" <td>3.48</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>NZD</td>\n",
" <td>20.32</td>\n",
" <td>20.95</td>\n",
" <td>20.56</td>\n",
" <td>20.76</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>THB</td>\n",
" <td>0.8272</td>\n",
" <td>0.9702</td>\n",
" <td>0.9157</td>\n",
" <td>0.9557</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>PHP</td>\n",
" <td>0.4978</td>\n",
" <td>0.6308</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>IDR</td>\n",
" <td>0.00178</td>\n",
" <td>0.00248</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>EUR</td>\n",
" <td>34.63</td>\n",
" <td>35.78</td>\n",
" <td>35.13</td>\n",
" <td>35.53</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>KRW</td>\n",
" <td>0.02598</td>\n",
" <td>0.02988</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>VND</td>\n",
" <td>0.00094</td>\n",
" <td>0.00144</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>MYR</td>\n",
" <td>6.44</td>\n",
" <td>8.07</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>CNY</td>\n",
" <td>4.604</td>\n",
" <td>4.766</td>\n",
" <td>4.676</td>\n",
" <td>4.726</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" 幣別 現金匯率-本行買入 現金匯率-本行賣出 即期匯率-本行買入 即期匯率-本行賣出\n",
"0 USD 29.555 30.097 29.855 29.955\n",
"1 HKD 3.664 3.854 3.779 3.839\n",
"2 GBP 39.32 41.25 40.19 40.61\n",
"3 AUD 22.16 22.82 22.35 22.58\n",
"4 CAD 22.96 23.7 23.23 23.45\n",
"5 SGD 21.77 22.55 22.19 22.37\n",
"6 CHF 29.22 30.28 29.75 30.04\n",
"7 JPY 0.2613 0.2723 0.2677 0.2717\n",
"8 ZAR - - 2.34 2.42\n",
"9 SEK 3.04 3.55 3.38 3.48\n",
"10 NZD 20.32 20.95 20.56 20.76\n",
"11 THB 0.8272 0.9702 0.9157 0.9557\n",
"12 PHP 0.4978 0.6308 - -\n",
"13 IDR 0.00178 0.00248 - -\n",
"14 EUR 34.63 35.78 35.13 35.53\n",
"15 KRW 0.02598 0.02988 - -\n",
"16 VND 0.00094 0.00144 - -\n",
"17 MYR 6.44 8.07 - -\n",
"18 CNY 4.604 4.766 4.676 4.726"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#檢查\n",
"#type(currency)\n",
"\n",
"#擷取需要的欄位\n",
"currency_fix=currency.ix[:,0:5]\n",
"\n",
"#檢查\n",
"#currency_fix\n",
"\n",
"#自訂欄位名稱\n",
"currency_fix.columns=[u'幣別',u'現金匯率-本行買入',u'現金匯率-本行賣出',u'即期匯率-本行買入',u'即期匯率-本行賣出']\n",
"\n",
"#檢查\n",
"#currency_fix\n",
"\n",
"#清除幣別欄重複字元\n",
"currency_fix[u'幣別']=currency_fix[u'幣別'].str.extract('\\((\\w+)\\)')\n",
"\n",
"#檢查\n",
"currency_fix\n",
"\n",
"#存檔\n",
"#currency_fix.to_excel('currency.xlsx')\n",
"#currency_fix.to_csv('currency.csv')"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"<class 'pandas.core.frame.DataFrame'>\n",
"RangeIndex: 19 entries, 0 to 18\n",
"Data columns (total 6 columns):\n",
"幣別 19 non-null object\n",
"現金匯率-本行買入 19 non-null object\n",
"現金匯率-本行賣出 19 non-null object\n",
"即期匯率-本行買入 19 non-null object\n",
"即期匯率-本行賣出 19 non-null object\n",
"Date 19 non-null object\n",
"dtypes: object(6)\n",
"memory usage: 992.0+ bytes\n"
]
}
],
"source": [
"#將資料存到Sqlite\n",
"\n",
"#新增日期欄位&使用今天的日期\n",
"currency_fix['Date']=datetime.now().strftime('%Y-%m-%d')\n",
"#檢查格式\n",
"currency_fix.info()"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [],
"source": [
"#將Data欄位用pandas轉成日期的資料型態\n",
"currency_fix['Date']=pd.to_datetime(currency_fix['Date'])"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"<class 'pandas.core.frame.DataFrame'>\n",
"RangeIndex: 19 entries, 0 to 18\n",
"Data columns (total 6 columns):\n",
"幣別 19 non-null object\n",
"現金匯率-本行買入 19 non-null object\n",
"現金匯率-本行賣出 19 non-null object\n",
"即期匯率-本行買入 19 non-null object\n",
"即期匯率-本行賣出 19 non-null object\n",
"Date 19 non-null datetime64[ns]\n",
"dtypes: datetime64[ns](1), object(5)\n",
"memory usage: 992.0+ bytes\n"
]
}
],
"source": [
"#檢查格式\n",
"currency_fix.info()"
]
},
{
"cell_type": "code",
"execution_count": 7,
"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>Date</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>USD</td>\n",
" <td>29.555</td>\n",
" <td>30.097</td>\n",
" <td>29.855</td>\n",
" <td>29.955</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>HKD</td>\n",
" <td>3.664</td>\n",
" <td>3.854</td>\n",
" <td>3.779</td>\n",
" <td>3.839</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>GBP</td>\n",
" <td>39.32</td>\n",
" <td>41.25</td>\n",
" <td>40.19</td>\n",
" <td>40.61</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>AUD</td>\n",
" <td>22.16</td>\n",
" <td>22.82</td>\n",
" <td>22.35</td>\n",
" <td>22.58</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>CAD</td>\n",
" <td>22.96</td>\n",
" <td>23.7</td>\n",
" <td>23.23</td>\n",
" <td>23.45</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>SGD</td>\n",
" <td>21.77</td>\n",
" <td>22.55</td>\n",
" <td>22.19</td>\n",
" <td>22.37</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>CHF</td>\n",
" <td>29.22</td>\n",
" <td>30.28</td>\n",
" <td>29.75</td>\n",
" <td>30.04</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>JPY</td>\n",
" <td>0.2613</td>\n",
" <td>0.2723</td>\n",
" <td>0.2677</td>\n",
" <td>0.2717</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>ZAR</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" <td>2.34</td>\n",
" <td>2.42</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>SEK</td>\n",
" <td>3.04</td>\n",
" <td>3.55</td>\n",
" <td>3.38</td>\n",
" <td>3.48</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>NZD</td>\n",
" <td>20.32</td>\n",
" <td>20.95</td>\n",
" <td>20.56</td>\n",
" <td>20.76</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>THB</td>\n",
" <td>0.8272</td>\n",
" <td>0.9702</td>\n",
" <td>0.9157</td>\n",
" <td>0.9557</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>PHP</td>\n",
" <td>0.4978</td>\n",
" <td>0.6308</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>IDR</td>\n",
" <td>0.00178</td>\n",
" <td>0.00248</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>EUR</td>\n",
" <td>34.63</td>\n",
" <td>35.78</td>\n",
" <td>35.13</td>\n",
" <td>35.53</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>KRW</td>\n",
" <td>0.02598</td>\n",
" <td>0.02988</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>VND</td>\n",
" <td>0.00094</td>\n",
" <td>0.00144</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>MYR</td>\n",
" <td>6.44</td>\n",
" <td>8.07</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>CNY</td>\n",
" <td>4.604</td>\n",
" <td>4.766</td>\n",
" <td>4.676</td>\n",
" <td>4.726</td>\n",
" <td>2018-05-20</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" 幣別 現金匯率-本行買入 現金匯率-本行賣出 即期匯率-本行買入 即期匯率-本行賣出 Date\n",
"0 USD 29.555 30.097 29.855 29.955 2018-05-20\n",
"1 HKD 3.664 3.854 3.779 3.839 2018-05-20\n",
"2 GBP 39.32 41.25 40.19 40.61 2018-05-20\n",
"3 AUD 22.16 22.82 22.35 22.58 2018-05-20\n",
"4 CAD 22.96 23.7 23.23 23.45 2018-05-20\n",
"5 SGD 21.77 22.55 22.19 22.37 2018-05-20\n",
"6 CHF 29.22 30.28 29.75 30.04 2018-05-20\n",
"7 JPY 0.2613 0.2723 0.2677 0.2717 2018-05-20\n",
"8 ZAR - - 2.34 2.42 2018-05-20\n",
"9 SEK 3.04 3.55 3.38 3.48 2018-05-20\n",
"10 NZD 20.32 20.95 20.56 20.76 2018-05-20\n",
"11 THB 0.8272 0.9702 0.9157 0.9557 2018-05-20\n",
"12 PHP 0.4978 0.6308 - - 2018-05-20\n",
"13 IDR 0.00178 0.00248 - - 2018-05-20\n",
"14 EUR 34.63 35.78 35.13 35.53 2018-05-20\n",
"15 KRW 0.02598 0.02988 - - 2018-05-20\n",
"16 VND 0.00094 0.00144 - - 2018-05-20\n",
"17 MYR 6.44 8.07 - - 2018-05-20\n",
"18 CNY 4.604 4.766 4.676 4.726 2018-05-20"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#印出&檢查內容\n",
"currency_fix"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [],
"source": [
"#寫檔\n",
"with sqlite3.connect('currency.sqlite') as db:\n",
" currency_fix.to_sql('currency',con=db,if_exists='append')"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {
"scrolled": true
},
"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>index</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>0</td>\n",
" <td>USD</td>\n",
" <td>29.555</td>\n",
" <td>30.097</td>\n",
" <td>29.855</td>\n",
" <td>29.955</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>1</td>\n",
" <td>HKD</td>\n",
" <td>3.664</td>\n",
" <td>3.854</td>\n",
" <td>3.779</td>\n",
" <td>3.839</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2</td>\n",
" <td>GBP</td>\n",
" <td>39.32</td>\n",
" <td>41.25</td>\n",
" <td>40.19</td>\n",
" <td>40.61</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>3</td>\n",
" <td>AUD</td>\n",
" <td>22.16</td>\n",
" <td>22.82</td>\n",
" <td>22.35</td>\n",
" <td>22.58</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>4</td>\n",
" <td>CAD</td>\n",
" <td>22.96</td>\n",
" <td>23.7</td>\n",
" <td>23.23</td>\n",
" <td>23.45</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>5</td>\n",
" <td>SGD</td>\n",
" <td>21.77</td>\n",
" <td>22.55</td>\n",
" <td>22.19</td>\n",
" <td>22.37</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>6</td>\n",
" <td>CHF</td>\n",
" <td>29.22</td>\n",
" <td>30.28</td>\n",
" <td>29.75</td>\n",
" <td>30.04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>7</td>\n",
" <td>JPY</td>\n",
" <td>0.2613</td>\n",
" <td>0.2723</td>\n",
" <td>0.2677</td>\n",
" <td>0.2717</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>8</td>\n",
" <td>ZAR</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" <td>2.34</td>\n",
" <td>2.42</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>9</td>\n",
" <td>SEK</td>\n",
" <td>3.04</td>\n",
" <td>3.55</td>\n",
" <td>3.38</td>\n",
" <td>3.48</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>10</td>\n",
" <td>NZD</td>\n",
" <td>20.32</td>\n",
" <td>20.95</td>\n",
" <td>20.56</td>\n",
" <td>20.76</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>11</td>\n",
" <td>THB</td>\n",
" <td>0.8272</td>\n",
" <td>0.9702</td>\n",
" <td>0.9157</td>\n",
" <td>0.9557</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>12</td>\n",
" <td>PHP</td>\n",
" <td>0.4978</td>\n",
" <td>0.6308</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>13</td>\n",
" <td>IDR</td>\n",
" <td>0.00178</td>\n",
" <td>0.00248</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>14</td>\n",
" <td>EUR</td>\n",
" <td>34.63</td>\n",
" <td>35.78</td>\n",
" <td>35.13</td>\n",
" <td>35.53</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>15</td>\n",
" <td>KRW</td>\n",
" <td>0.02598</td>\n",
" <td>0.02988</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>16</td>\n",
" <td>VND</td>\n",
" <td>0.00094</td>\n",
" <td>0.00144</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>17</td>\n",
" <td>MYR</td>\n",
" <td>6.44</td>\n",
" <td>8.07</td>\n",
" <td>-</td>\n",
" <td>-</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>18</td>\n",
" <td>CNY</td>\n",
" <td>4.604</td>\n",
" <td>4.766</td>\n",
" <td>4.676</td>\n",
" <td>4.726</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" index 幣別 現金匯率-本行買入 現金匯率-本行賣出 即期匯率-本行買入 即期匯率-本行賣出\n",
"0 0 USD 29.555 30.097 29.855 29.955\n",
"1 1 HKD 3.664 3.854 3.779 3.839\n",
"2 2 GBP 39.32 41.25 40.19 40.61\n",
"3 3 AUD 22.16 22.82 22.35 22.58\n",
"4 4 CAD 22.96 23.7 23.23 23.45\n",
"5 5 SGD 21.77 22.55 22.19 22.37\n",
"6 6 CHF 29.22 30.28 29.75 30.04\n",
"7 7 JPY 0.2613 0.2723 0.2677 0.2717\n",
"8 8 ZAR - - 2.34 2.42\n",
"9 9 SEK 3.04 3.55 3.38 3.48\n",
"10 10 NZD 20.32 20.95 20.56 20.76\n",
"11 11 THB 0.8272 0.9702 0.9157 0.9557\n",
"12 12 PHP 0.4978 0.6308 - -\n",
"13 13 IDR 0.00178 0.00248 - -\n",
"14 14 EUR 34.63 35.78 35.13 35.53\n",
"15 15 KRW 0.02598 0.02988 - -\n",
"16 16 VND 0.00094 0.00144 - -\n",
"17 17 MYR 6.44 8.07 - -\n",
"18 18 CNY 4.604 4.766 4.676 4.726"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#讀檔(在jupyter上直接看)\n",
"with sqlite3.connect('currency.sqlite') as db:\n",
" df=pd.read_sql_query('select * from currency', con=db)\n",
"df"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"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.5.2"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment