Solution/Day_12_Solution_v2.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"12 Answer.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.6.5"}},"cells":[{"cell_type":"markdown","metadata":{"id":"P6xk2_jLsvFF"},"source":["# [作業目標]\n","\n","1. 根據給定的 DataFrame 中取出索引為 3, 4, 8 的 animal 和 age 欄位。\n","2. 請將 dataFrame 所有字串都變成是大寫開頭。\n"]},{"cell_type":"markdown","metadata":{"id":"uXGll28asvFS"},"source":["# 作業 "]},{"cell_type":"code","metadata":{"id":"mA8LUbRKPG0C"},"source":["# 記得先 Import 正確的套件\n","\n","import numpy as np\n","import pandas as pd\n"],"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"gerj2A9rPG0D"},"source":["### 1. 根據給定的 DataFrame 中取出索引為 3, 4, 8 的 animal 和 age 欄位。\n"]},{"cell_type":"code","metadata":{"id":"5QrYoyNWsvFS","outputId":"08c0c342-1867-4dee-c8c4-e8c2a19ccd7d"},"source":["data = {'animal': ['cat', 'cat', 'snake', 'dog', 'dog', 'cat', 'snake', 'cat', 'dog', 'dog'],\n","        'age': [2.5, 3, 0.5, np.nan, 5, 2, 4.5, np.nan, 7, 3],\n","        'visits': [1, 3, 2, 3, 2, 3, 1, 1, 2, 1],\n","        'priority': ['yes', 'yes', 'no', 'yes', 'no', 'no', 'no', 'yes', 'no', 'no']}\n","\n","labels = ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j']\n","\n","df = pd.DataFrame(data, index=labels)\n","df\n"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>animal</th>\n","      <th>age</th>\n","      <th>visits</th>\n","      <th>priority</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>a</th>\n","      <td>cat</td>\n","      <td>2.5</td>\n","      <td>1</td>\n","      <td>yes</td>\n","    </tr>\n","    <tr>\n","      <th>b</th>\n","      <td>cat</td>\n","      <td>3.0</td>\n","      <td>3</td>\n","      <td>yes</td>\n","    </tr>\n","    <tr>\n","      <th>c</th>\n","      <td>snake</td>\n","      <td>0.5</td>\n","      <td>2</td>\n","      <td>no</td>\n","    </tr>\n","    <tr>\n","      <th>d</th>\n","      <td>dog</td>\n","      <td>NaN</td>\n","      <td>3</td>\n","      <td>yes</td>\n","    </tr>\n","    <tr>\n","      <th>e</th>\n","      <td>dog</td>\n","      <td>5.0</td>\n","      <td>2</td>\n","      <td>no</td>\n","    </tr>\n","    <tr>\n","      <th>f</th>\n","      <td>cat</td>\n","      <td>2.0</td>\n","      <td>3</td>\n","      <td>no</td>\n","    </tr>\n","    <tr>\n","      <th>g</th>\n","      <td>snake</td>\n","      <td>4.5</td>\n","      <td>1</td>\n","      <td>no</td>\n","    </tr>\n","    <tr>\n","      <th>h</th>\n","      <td>cat</td>\n","      <td>NaN</td>\n","      <td>1</td>\n","      <td>yes</td>\n","    </tr>\n","    <tr>\n","      <th>i</th>\n","      <td>dog</td>\n","      <td>7.0</td>\n","      <td>2</td>\n","      <td>no</td>\n","    </tr>\n","    <tr>\n","      <th>j</th>\n","      <td>dog</td>\n","      <td>3.0</td>\n","      <td>1</td>\n","      <td>no</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["  animal  age  visits priority\n","a    cat  2.5       1      yes\n","b    cat  3.0       3      yes\n","c  snake  0.5       2       no\n","d    dog  NaN       3      yes\n","e    dog  5.0       2       no\n","f    cat  2.0       3       no\n","g  snake  4.5       1       no\n","h    cat  NaN       1      yes\n","i    dog  7.0       2       no\n","j    dog  3.0       1       no"]},"metadata":{"tags":[]},"execution_count":11}]},{"cell_type":"code","metadata":{"id":"AoJ99IKmPG0E","outputId":"e5810881-4b8f-4ea2-c45b-7c456b0c4429"},"source":["df.loc[df.index[[3, 4, 8]], ['animal', 'age']]\n"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>animal</th>\n","      <th>age</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>d</th>\n","      <td>dog</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>e</th>\n","      <td>dog</td>\n","      <td>5.0</td>\n","    </tr>\n","    <tr>\n","      <th>i</th>\n","      <td>dog</td>\n","      <td>7.0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["  animal  age\n","d    dog  NaN\n","e    dog  5.0\n","i    dog  7.0"]},"metadata":{"tags":[]},"execution_count":12}]},{"cell_type":"markdown","metadata":{"id":"rgTTtk5SPG0F"},"source":["### 2. 請將 dataFrame 所有字串都變成是大寫開頭。\n","\n"]},{"cell_type":"code","metadata":{"id":"e1gVI0tvsvFY","outputId":"2c838218-3627-4ff6-ed33-a150deeb0fb9"},"source":["df = pd.DataFrame([\n","    ['tom', 'mark', 'mary'],\n","    ['bob', 'alice', 'john']\n","])\n","df"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>0</th>\n","      <th>1</th>\n","      <th>2</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>tom</td>\n","      <td>mark</td>\n","      <td>mary</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>bob</td>\n","      <td>alice</td>\n","      <td>john</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["     0      1     2\n","0  tom   mark  mary\n","1  bob  alice  john"]},"metadata":{"tags":[]},"execution_count":13}]},{"cell_type":"code","metadata":{"id":"e8m2dsecPG0G","outputId":"6a90a7f9-4e9c-4907-bf7f-16b5667545b5"},"source":["df.applymap(lambda x: x.title())\n"],"execution_count":null,"outputs":[{"output_type":"execute_result","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>0</th>\n","      <th>1</th>\n","      <th>2</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Tom</td>\n","      <td>Mark</td>\n","      <td>Mary</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Bob</td>\n","      <td>Alice</td>\n","      <td>John</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["     0      1     2\n","0  Tom   Mark  Mary\n","1  Bob  Alice  John"]},"metadata":{"tags":[]},"execution_count":14}]},{"cell_type":"code","metadata":{"id":"MHREhv9FPG0H"},"source":[""],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"id":"Os_NZSr5PG0H"},"source":[""],"execution_count":null,"outputs":[]}]}