D10 Pandas 資料索引操作 (資料過濾、選擇與合併) pandas_select_merge_hw題目.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "Uf6dEaWpP3lo"
   },
   "source": [
    "作業目標:<br>\n",
    "1. 運用索引找出需要資料<br>\n",
    "2. 合併資料的分法應用"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "3rP6NOVVQZuB"
   },
   "source": [
    "作業重點:<br>\n",
    "1. 分辨索引loc、iloc差別\n",
    "2. 分辨合併資料方法的不同，因應不同情況使用Merge, join, concatenate"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "02Ld_89FP-4N"
   },
   "source": [
    "題目:<br>\n",
    "讀取STOCK_DAY_0050_202009.csv串聯STOCK_DAY_0050_202010.csv，並且找出open小於close的資料\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "id": "ysjY4kR5P4rA"
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "id": "hsEDbEogG4DG"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "09 欄位 Index(['date', 'open', 'high', 'low', 'close'], dtype='object')\n",
      "09 筆數 22\n"
     ]
    }
   ],
   "source": [
    "#讀取STOCK_DAY_0050_202009.csv、STOCK_DAY_0050_202010.csv\n",
    "\n",
    "data1 = pd.read_csv(\"STOCK_DAY_0050_202009.csv\")\n",
    "print(\"09 欄位\", data1.columns)\n",
    "print(\"09 筆數\", data1.shape[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "10 欄位 Index(['date', 'open', 'high', 'low', 'close'], dtype='object')\n",
      "10 筆數 19\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>date</th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>close</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>109/10/05</td>\n",
       "      <td>103.45</td>\n",
       "      <td>104.05</td>\n",
       "      <td>103.00</td>\n",
       "      <td>103.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>109/10/06</td>\n",
       "      <td>104.00</td>\n",
       "      <td>104.35</td>\n",
       "      <td>103.85</td>\n",
       "      <td>104.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>109/10/07</td>\n",
       "      <td>104.00</td>\n",
       "      <td>105.00</td>\n",
       "      <td>103.50</td>\n",
       "      <td>104.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>109/10/08</td>\n",
       "      <td>105.45</td>\n",
       "      <td>106.35</td>\n",
       "      <td>105.30</td>\n",
       "      <td>106.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>109/10/12</td>\n",
       "      <td>106.70</td>\n",
       "      <td>107.70</td>\n",
       "      <td>106.70</td>\n",
       "      <td>107.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>109/10/13</td>\n",
       "      <td>107.35</td>\n",
       "      <td>107.60</td>\n",
       "      <td>106.20</td>\n",
       "      <td>107.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>109/10/14</td>\n",
       "      <td>107.05</td>\n",
       "      <td>107.20</td>\n",
       "      <td>106.45</td>\n",
       "      <td>106.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>109/10/15</td>\n",
       "      <td>106.50</td>\n",
       "      <td>106.50</td>\n",
       "      <td>105.10</td>\n",
       "      <td>105.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>109/10/16</td>\n",
       "      <td>105.70</td>\n",
       "      <td>106.30</td>\n",
       "      <td>105.10</td>\n",
       "      <td>105.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>109/10/19</td>\n",
       "      <td>105.65</td>\n",
       "      <td>106.60</td>\n",
       "      <td>105.60</td>\n",
       "      <td>106.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>109/10/20</td>\n",
       "      <td>106.40</td>\n",
       "      <td>106.45</td>\n",
       "      <td>106.00</td>\n",
       "      <td>106.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>109/10/21</td>\n",
       "      <td>106.00</td>\n",
       "      <td>106.55</td>\n",
       "      <td>105.65</td>\n",
       "      <td>105.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>109/10/22</td>\n",
       "      <td>105.70</td>\n",
       "      <td>106.10</td>\n",
       "      <td>105.50</td>\n",
       "      <td>106.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>109/10/23</td>\n",
       "      <td>106.50</td>\n",
       "      <td>106.65</td>\n",
       "      <td>105.65</td>\n",
       "      <td>106.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>109/10/26</td>\n",
       "      <td>106.10</td>\n",
       "      <td>106.60</td>\n",
       "      <td>105.80</td>\n",
       "      <td>106.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>109/10/27</td>\n",
       "      <td>105.75</td>\n",
       "      <td>105.75</td>\n",
       "      <td>105.15</td>\n",
       "      <td>105.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>109/10/28</td>\n",
       "      <td>105.50</td>\n",
       "      <td>105.50</td>\n",
       "      <td>104.80</td>\n",
       "      <td>105.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>109/10/29</td>\n",
       "      <td>104.00</td>\n",
       "      <td>104.10</td>\n",
       "      <td>103.25</td>\n",
       "      <td>103.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>109/10/30</td>\n",
       "      <td>103.55</td>\n",
       "      <td>103.60</td>\n",
       "      <td>102.70</td>\n",
       "      <td>103.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         date    open    high     low   close\n",
       "0   109/10/05  103.45  104.05  103.00  103.05\n",
       "1   109/10/06  104.00  104.35  103.85  104.25\n",
       "2   109/10/07  104.00  105.00  103.50  104.80\n",
       "3   109/10/08  105.45  106.35  105.30  106.20\n",
       "4   109/10/12  106.70  107.70  106.70  107.05\n",
       "5   109/10/13  107.35  107.60  106.20  107.10\n",
       "6   109/10/14  107.05  107.20  106.45  106.70\n",
       "7   109/10/15  106.50  106.50  105.10  105.70\n",
       "8   109/10/16  105.70  106.30  105.10  105.25\n",
       "9   109/10/19  105.65  106.60  105.60  106.60\n",
       "10  109/10/20  106.40  106.45  106.00  106.00\n",
       "11  109/10/21  106.00  106.55  105.65  105.95\n",
       "12  109/10/22  105.70  106.10  105.50  106.10\n",
       "13  109/10/23  106.50  106.65  105.65  106.10\n",
       "14  109/10/26  106.10  106.60  105.80  106.10\n",
       "15  109/10/27  105.75  105.75  105.15  105.50\n",
       "16  109/10/28  105.50  105.50  104.80  105.00\n",
       "17  109/10/29  104.00  104.10  103.25  103.85\n",
       "18  109/10/30  103.55  103.60  102.70  103.00"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data2 = pd.read_csv(\"STOCK_DAY_0050_202010.csv\")\n",
    "print(\"10 欄位\", data2.columns)\n",
    "print(\"10 筆數\", data2.shape[0])\n",
    "data2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "id": "cw3OMgQgG4DG"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "all 欄位 Index(['date', 'open', 'high', 'low', 'close'], dtype='object')\n",
      "all 筆數 41\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>date</th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>close</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>109/09/01</td>\n",
       "      <td>102.45</td>\n",
       "      <td>103.35</td>\n",
       "      <td>101.85</td>\n",
       "      <td>103.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>109/09/02</td>\n",
       "      <td>103.65</td>\n",
       "      <td>104.05</td>\n",
       "      <td>102.30</td>\n",
       "      <td>103.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>109/09/03</td>\n",
       "      <td>103.70</td>\n",
       "      <td>104.30</td>\n",
       "      <td>103.20</td>\n",
       "      <td>103.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>109/09/04</td>\n",
       "      <td>102.00</td>\n",
       "      <td>102.70</td>\n",
       "      <td>101.90</td>\n",
       "      <td>102.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>109/09/07</td>\n",
       "      <td>102.55</td>\n",
       "      <td>103.05</td>\n",
       "      <td>101.90</td>\n",
       "      <td>102.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>109/09/08</td>\n",
       "      <td>102.75</td>\n",
       "      <td>103.10</td>\n",
       "      <td>102.45</td>\n",
       "      <td>103.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>109/09/09</td>\n",
       "      <td>101.75</td>\n",
       "      <td>102.35</td>\n",
       "      <td>101.15</td>\n",
       "      <td>102.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>109/09/10</td>\n",
       "      <td>102.80</td>\n",
       "      <td>103.35</td>\n",
       "      <td>102.60</td>\n",
       "      <td>103.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>109/09/11</td>\n",
       "      <td>103.20</td>\n",
       "      <td>103.35</td>\n",
       "      <td>102.80</td>\n",
       "      <td>103.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>109/09/14</td>\n",
       "      <td>103.50</td>\n",
       "      <td>104.55</td>\n",
       "      <td>103.25</td>\n",
       "      <td>104.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>109/09/15</td>\n",
       "      <td>104.45</td>\n",
       "      <td>105.20</td>\n",
       "      <td>104.25</td>\n",
       "      <td>104.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>109/09/16</td>\n",
       "      <td>106.55</td>\n",
       "      <td>107.00</td>\n",
       "      <td>106.35</td>\n",
       "      <td>106.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>109/09/17</td>\n",
       "      <td>106.05</td>\n",
       "      <td>106.35</td>\n",
       "      <td>105.10</td>\n",
       "      <td>105.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>109/09/18</td>\n",
       "      <td>105.40</td>\n",
       "      <td>105.70</td>\n",
       "      <td>104.85</td>\n",
       "      <td>105.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>109/09/21</td>\n",
       "      <td>105.20</td>\n",
       "      <td>105.90</td>\n",
       "      <td>104.35</td>\n",
       "      <td>104.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>109/09/22</td>\n",
       "      <td>104.30</td>\n",
       "      <td>104.30</td>\n",
       "      <td>102.95</td>\n",
       "      <td>103.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>109/09/23</td>\n",
       "      <td>103.50</td>\n",
       "      <td>103.50</td>\n",
       "      <td>102.40</td>\n",
       "      <td>102.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>109/09/24</td>\n",
       "      <td>101.55</td>\n",
       "      <td>101.80</td>\n",
       "      <td>100.25</td>\n",
       "      <td>100.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>109/09/25</td>\n",
       "      <td>100.75</td>\n",
       "      <td>101.45</td>\n",
       "      <td>100.05</td>\n",
       "      <td>100.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>109/09/28</td>\n",
       "      <td>101.35</td>\n",
       "      <td>102.30</td>\n",
       "      <td>101.00</td>\n",
       "      <td>102.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>109/09/29</td>\n",
       "      <td>102.75</td>\n",
       "      <td>103.50</td>\n",
       "      <td>102.15</td>\n",
       "      <td>102.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>109/09/30</td>\n",
       "      <td>102.75</td>\n",
       "      <td>103.45</td>\n",
       "      <td>102.60</td>\n",
       "      <td>103.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>109/10/05</td>\n",
       "      <td>103.45</td>\n",
       "      <td>104.05</td>\n",
       "      <td>103.00</td>\n",
       "      <td>103.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>109/10/06</td>\n",
       "      <td>104.00</td>\n",
       "      <td>104.35</td>\n",
       "      <td>103.85</td>\n",
       "      <td>104.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>109/10/07</td>\n",
       "      <td>104.00</td>\n",
       "      <td>105.00</td>\n",
       "      <td>103.50</td>\n",
       "      <td>104.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>109/10/08</td>\n",
       "      <td>105.45</td>\n",
       "      <td>106.35</td>\n",
       "      <td>105.30</td>\n",
       "      <td>106.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>109/10/12</td>\n",
       "      <td>106.70</td>\n",
       "      <td>107.70</td>\n",
       "      <td>106.70</td>\n",
       "      <td>107.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>109/10/13</td>\n",
       "      <td>107.35</td>\n",
       "      <td>107.60</td>\n",
       "      <td>106.20</td>\n",
       "      <td>107.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>109/10/14</td>\n",
       "      <td>107.05</td>\n",
       "      <td>107.20</td>\n",
       "      <td>106.45</td>\n",
       "      <td>106.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>109/10/15</td>\n",
       "      <td>106.50</td>\n",
       "      <td>106.50</td>\n",
       "      <td>105.10</td>\n",
       "      <td>105.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>109/10/16</td>\n",
       "      <td>105.70</td>\n",
       "      <td>106.30</td>\n",
       "      <td>105.10</td>\n",
       "      <td>105.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>109/10/19</td>\n",
       "      <td>105.65</td>\n",
       "      <td>106.60</td>\n",
       "      <td>105.60</td>\n",
       "      <td>106.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>109/10/20</td>\n",
       "      <td>106.40</td>\n",
       "      <td>106.45</td>\n",
       "      <td>106.00</td>\n",
       "      <td>106.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>109/10/21</td>\n",
       "      <td>106.00</td>\n",
       "      <td>106.55</td>\n",
       "      <td>105.65</td>\n",
       "      <td>105.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>109/10/22</td>\n",
       "      <td>105.70</td>\n",
       "      <td>106.10</td>\n",
       "      <td>105.50</td>\n",
       "      <td>106.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>109/10/23</td>\n",
       "      <td>106.50</td>\n",
       "      <td>106.65</td>\n",
       "      <td>105.65</td>\n",
       "      <td>106.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>109/10/26</td>\n",
       "      <td>106.10</td>\n",
       "      <td>106.60</td>\n",
       "      <td>105.80</td>\n",
       "      <td>106.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>109/10/27</td>\n",
       "      <td>105.75</td>\n",
       "      <td>105.75</td>\n",
       "      <td>105.15</td>\n",
       "      <td>105.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>109/10/28</td>\n",
       "      <td>105.50</td>\n",
       "      <td>105.50</td>\n",
       "      <td>104.80</td>\n",
       "      <td>105.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>109/10/29</td>\n",
       "      <td>104.00</td>\n",
       "      <td>104.10</td>\n",
       "      <td>103.25</td>\n",
       "      <td>103.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>109/10/30</td>\n",
       "      <td>103.55</td>\n",
       "      <td>103.60</td>\n",
       "      <td>102.70</td>\n",
       "      <td>103.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         date    open    high     low   close\n",
       "0   109/09/01  102.45  103.35  101.85  103.35\n",
       "1   109/09/02  103.65  104.05  102.30  103.00\n",
       "2   109/09/03  103.70  104.30  103.20  103.30\n",
       "3   109/09/04  102.00  102.70  101.90  102.55\n",
       "4   109/09/07  102.55  103.05  101.90  102.40\n",
       "5   109/09/08  102.75  103.10  102.45  103.00\n",
       "6   109/09/09  101.75  102.35  101.15  102.30\n",
       "7   109/09/10  102.80  103.35  102.60  103.20\n",
       "8   109/09/11  103.20  103.35  102.80  103.25\n",
       "9   109/09/14  103.50  104.55  103.25  104.55\n",
       "10  109/09/15  104.45  105.20  104.25  104.95\n",
       "11  109/09/16  106.55  107.00  106.35  106.55\n",
       "12  109/09/17  106.05  106.35  105.10  105.40\n",
       "13  109/09/18  105.40  105.70  104.85  105.30\n",
       "14  109/09/21  105.20  105.90  104.35  104.45\n",
       "15  109/09/22  104.30  104.30  102.95  103.10\n",
       "16  109/09/23  103.50  103.50  102.40  102.95\n",
       "17  109/09/24  101.55  101.80  100.25  100.45\n",
       "18  109/09/25  100.75  101.45  100.05  100.65\n",
       "19  109/09/28  101.35  102.30  101.00  102.30\n",
       "20  109/09/29  102.75  103.50  102.15  102.55\n",
       "21  109/09/30  102.75  103.45  102.60  103.00\n",
       "0   109/10/05  103.45  104.05  103.00  103.05\n",
       "1   109/10/06  104.00  104.35  103.85  104.25\n",
       "2   109/10/07  104.00  105.00  103.50  104.80\n",
       "3   109/10/08  105.45  106.35  105.30  106.20\n",
       "4   109/10/12  106.70  107.70  106.70  107.05\n",
       "5   109/10/13  107.35  107.60  106.20  107.10\n",
       "6   109/10/14  107.05  107.20  106.45  106.70\n",
       "7   109/10/15  106.50  106.50  105.10  105.70\n",
       "8   109/10/16  105.70  106.30  105.10  105.25\n",
       "9   109/10/19  105.65  106.60  105.60  106.60\n",
       "10  109/10/20  106.40  106.45  106.00  106.00\n",
       "11  109/10/21  106.00  106.55  105.65  105.95\n",
       "12  109/10/22  105.70  106.10  105.50  106.10\n",
       "13  109/10/23  106.50  106.65  105.65  106.10\n",
       "14  109/10/26  106.10  106.60  105.80  106.10\n",
       "15  109/10/27  105.75  105.75  105.15  105.50\n",
       "16  109/10/28  105.50  105.50  104.80  105.00\n",
       "17  109/10/29  104.00  104.10  103.25  103.85\n",
       "18  109/10/30  103.55  103.60  102.70  103.00"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#串聯\n",
    "all_data = pd.concat([data1, data2], axis=0)\n",
    "print(\"all 欄位\", all_data.columns)\n",
    "print(\"all 筆數\", all_data.shape[0])\n",
    "all_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "executionInfo": {
     "elapsed": 957,
     "status": "ok",
     "timestamp": 1610348842287,
     "user": {
      "displayName": "献竤黃",
      "photoUrl": "",
      "userId": "07529243043474362942"
     },
     "user_tz": -480
    },
    "id": "LBBLV7TaG4DH",
    "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>date</th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>close</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>109/09/01</td>\n",
       "      <td>102.45</td>\n",
       "      <td>103.35</td>\n",
       "      <td>101.85</td>\n",
       "      <td>103.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>109/09/04</td>\n",
       "      <td>102.00</td>\n",
       "      <td>102.70</td>\n",
       "      <td>101.90</td>\n",
       "      <td>102.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>109/09/08</td>\n",
       "      <td>102.75</td>\n",
       "      <td>103.10</td>\n",
       "      <td>102.45</td>\n",
       "      <td>103.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>109/09/09</td>\n",
       "      <td>101.75</td>\n",
       "      <td>102.35</td>\n",
       "      <td>101.15</td>\n",
       "      <td>102.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>109/09/10</td>\n",
       "      <td>102.80</td>\n",
       "      <td>103.35</td>\n",
       "      <td>102.60</td>\n",
       "      <td>103.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>109/09/11</td>\n",
       "      <td>103.20</td>\n",
       "      <td>103.35</td>\n",
       "      <td>102.80</td>\n",
       "      <td>103.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>109/09/14</td>\n",
       "      <td>103.50</td>\n",
       "      <td>104.55</td>\n",
       "      <td>103.25</td>\n",
       "      <td>104.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>109/09/15</td>\n",
       "      <td>104.45</td>\n",
       "      <td>105.20</td>\n",
       "      <td>104.25</td>\n",
       "      <td>104.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>109/09/28</td>\n",
       "      <td>101.35</td>\n",
       "      <td>102.30</td>\n",
       "      <td>101.00</td>\n",
       "      <td>102.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>109/09/30</td>\n",
       "      <td>102.75</td>\n",
       "      <td>103.45</td>\n",
       "      <td>102.60</td>\n",
       "      <td>103.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>109/10/06</td>\n",
       "      <td>104.00</td>\n",
       "      <td>104.35</td>\n",
       "      <td>103.85</td>\n",
       "      <td>104.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>109/10/07</td>\n",
       "      <td>104.00</td>\n",
       "      <td>105.00</td>\n",
       "      <td>103.50</td>\n",
       "      <td>104.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>109/10/08</td>\n",
       "      <td>105.45</td>\n",
       "      <td>106.35</td>\n",
       "      <td>105.30</td>\n",
       "      <td>106.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>109/10/12</td>\n",
       "      <td>106.70</td>\n",
       "      <td>107.70</td>\n",
       "      <td>106.70</td>\n",
       "      <td>107.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>109/10/19</td>\n",
       "      <td>105.65</td>\n",
       "      <td>106.60</td>\n",
       "      <td>105.60</td>\n",
       "      <td>106.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>109/10/22</td>\n",
       "      <td>105.70</td>\n",
       "      <td>106.10</td>\n",
       "      <td>105.50</td>\n",
       "      <td>106.10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         date    open    high     low   close\n",
       "0   109/09/01  102.45  103.35  101.85  103.35\n",
       "3   109/09/04  102.00  102.70  101.90  102.55\n",
       "5   109/09/08  102.75  103.10  102.45  103.00\n",
       "6   109/09/09  101.75  102.35  101.15  102.30\n",
       "7   109/09/10  102.80  103.35  102.60  103.20\n",
       "8   109/09/11  103.20  103.35  102.80  103.25\n",
       "9   109/09/14  103.50  104.55  103.25  104.55\n",
       "10  109/09/15  104.45  105.20  104.25  104.95\n",
       "19  109/09/28  101.35  102.30  101.00  102.30\n",
       "21  109/09/30  102.75  103.45  102.60  103.00\n",
       "1   109/10/06  104.00  104.35  103.85  104.25\n",
       "2   109/10/07  104.00  105.00  103.50  104.80\n",
       "3   109/10/08  105.45  106.35  105.30  106.20\n",
       "4   109/10/12  106.70  107.70  106.70  107.05\n",
       "9   109/10/19  105.65  106.60  105.60  106.60\n",
       "12  109/10/22  105.70  106.10  105.50  106.10"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#找出open小於close的資料\n",
    "\n",
    "all_data.loc[all_data.open < all_data.close]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "id": "tZaFA68VG4DH"
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "colab": {
   "collapsed_sections": [],
   "name": "pandas_select_merge_hw題目.ipynb",
   "provenance": []
  },
  "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}