0805-3.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[92, 80, 79, 86, 75],\n",
       "       [58, 58, 70, 76, 52],\n",
       "       [80, 57, 71, 50, 93],\n",
       "       [77, 59, 99, 57, 80],\n",
       "       [87, 80, 73, 72, 85],\n",
       "       [76, 88, 75, 55, 73],\n",
       "       [53, 76, 53, 90, 95],\n",
       "       [97, 59, 62, 88, 78],\n",
       "       [91, 92, 79, 55, 73],\n",
       "       [88, 62, 74, 63, 59]])"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import numpy as np\n",
    "np.random.randint(50,100,size=(10,5))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "學生1     212\n",
       "學生2     220\n",
       "學生3     282\n",
       "學生4     276\n",
       "學生5     219\n",
       "學生6     207\n",
       "學生7     264\n",
       "學生8     264\n",
       "學生9     211\n",
       "學生10    248\n",
       "dtype: int64"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/plain": [
       "array([212, 220, 282, 276, 219, 207, 264, 264, 211, 248])"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/plain": [
       "Index(['學生1', '學生2', '學生3', '學生4', '學生5', '學生6', '學生7', '學生8', '學生9', '學生10'], dtype='object')"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "#安裝套件 pip install --upguade pandas\n",
    "#\n",
    "\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "n1 = np.random.randint(200,300,size=(10,))\n",
    "# comprehension : [f'學生{i+1}' for i in range(10)]\n",
    "s1 = pd.Series(data=n1,index=[f'學生{i+1}' for i in range(10)])\n",
    "\n",
    "display(s1)\n",
    "display(s1.values)\n",
    "display(s1.index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "郭雅慧、姜怡君、陳雅婷、邵怡君、張雅雯、丁兆友、周舒婷、邱俊桂、陳建綸、鄭雅文、傅維木、畢惠美、羅廷林、陳建安、劉隆其、張育旭、陳欣雨、郭旭達、黃信喜、邱幸仁、朱俊翔、張奇桓、翁秀娟、簡瑩甫、韓浩為、王秉鴻、陳姿彥、林宜亨、王郁惟、黃子昀、陳嘉文、汪立伯、江志添、陳淑貞、王正秀、曹怡君、謝意瑄、陳瑩慧、溫秀美、陳思善、陳永妃、楊淑貞、王靜芳、黃舒涵、魏俊安、宋懿美、黃盈如、洪慧茹、洪必雅、李美珠、陳家綺、陳宗翰、洪又方、黃昱定、陳容方、張懿冰、閔雅惠、吳元光、劉玉郁、黃文旭、鄭志銘、楊宜臻、王亭璇、李偉慧、鐘靖美、曾淑任、林明憲、林雲凡、蘇婉婷、黃聿鴻、賴旺康、邱耀德、卓均毓、許家瑋、賴俐月、盧柏南、謝珊漢、林玉侑、葉鈺林、林佩珊、戈君玫、陳麗娟、黃翔盛、陳竹諭、陳右君、陳麗青、姜向佐、徐軍愛、林憶賢、羅治江、倪靜雯、陳淑媛、張上志、王呈云、傅佳霖、洪卓生、林�琝Q、陳昱宣、沈興琦、王素貞\n"
     ]
    }
   ],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "\n",
    "# 設定time為獲取中文姓名100筆的倍數。time=3，就是300筆的意思。\n",
    "times = 1\n",
    "cnames = []\n",
    "for x in range(times):\n",
    "    url = 'http://www.richyli.com/name/index.asp'\n",
    "    r = requests.get(url)\n",
    "    r.encoding = 'big5'\n",
    "    \n",
    "    # 將網頁中的資料以分行的方式存成文字檔\n",
    "    result = r.text.splitlines()\n",
    "    \n",
    "    # 114是中文姓名開始的列，找到最後一個「、」，設定成為字串的切片位置。\n",
    "    char_index = result[114].rfind(\"、\")\n",
    "    temp = result[114][:char_index]\n",
    "    \n",
    "    # 將temp的100筆姓名新增到cnames中\n",
    "    cnames.append(temp)\n",
    "\n",
    "# 將每100筆姓名的list加一個「、」，再組合成字串存到my_names中\n",
    "my_names = \"、\".join(str(x) for x in cnames)\n",
    "print(my_names)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'str'>\n"
     ]
    }
   ],
   "source": [
    "import requests\n",
    "def getNames(num):\n",
    "    times = 1\n",
    "    cnames = []\n",
    "    for x in range(times):\n",
    "        url = 'http://www.richyli.com/name/index.asp'\n",
    "        r = requests.get(url)\n",
    "        r.encoding = 'big5'\n",
    "        \n",
    "        # 將網頁中的資料以分行的方式存成文字檔\n",
    "        result = r.text.splitlines()\n",
    "        \n",
    "        # 114是中文姓名開始的列，找到最後一個「、」，設定成為字串的切片位置。\n",
    "        char_index = result[114].rfind(\"、\")\n",
    "        temp = result[114][:char_index]\n",
    "        \n",
    "        # 將temp的100筆姓名新增到cnames中\n",
    "        cnames.append(temp)\n",
    "    print(type(cnames[0]))\n",
    "    names = cnames[0].split('、')\n",
    "    return names[:num]\n",
    "\n",
    "\n",
    "names = getNames(100)  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>鄧志杰</th>\n",
       "      <td>90</td>\n",
       "      <td>52</td>\n",
       "      <td>55</td>\n",
       "      <td>65</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>彭雅名</th>\n",
       "      <td>79</td>\n",
       "      <td>66</td>\n",
       "      <td>87</td>\n",
       "      <td>89</td>\n",
       "      <td>71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>江昌純</th>\n",
       "      <td>52</td>\n",
       "      <td>61</td>\n",
       "      <td>92</td>\n",
       "      <td>72</td>\n",
       "      <td>62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>林佩君</th>\n",
       "      <td>73</td>\n",
       "      <td>52</td>\n",
       "      <td>95</td>\n",
       "      <td>71</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>陳慧玲</th>\n",
       "      <td>89</td>\n",
       "      <td>67</td>\n",
       "      <td>66</td>\n",
       "      <td>81</td>\n",
       "      <td>98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李佳玲</th>\n",
       "      <td>83</td>\n",
       "      <td>90</td>\n",
       "      <td>52</td>\n",
       "      <td>92</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>陳曉諭</th>\n",
       "      <td>68</td>\n",
       "      <td>67</td>\n",
       "      <td>87</td>\n",
       "      <td>83</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>謝麗娟</th>\n",
       "      <td>74</td>\n",
       "      <td>53</td>\n",
       "      <td>66</td>\n",
       "      <td>70</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>孫彥安</th>\n",
       "      <td>67</td>\n",
       "      <td>58</td>\n",
       "      <td>73</td>\n",
       "      <td>87</td>\n",
       "      <td>59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>楊茜禎</th>\n",
       "      <td>85</td>\n",
       "      <td>62</td>\n",
       "      <td>68</td>\n",
       "      <td>52</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>涂青桓</th>\n",
       "      <td>61</td>\n",
       "      <td>99</td>\n",
       "      <td>78</td>\n",
       "      <td>77</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>王孟璇</th>\n",
       "      <td>96</td>\n",
       "      <td>96</td>\n",
       "      <td>61</td>\n",
       "      <td>99</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>鄭學念</th>\n",
       "      <td>54</td>\n",
       "      <td>84</td>\n",
       "      <td>85</td>\n",
       "      <td>58</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>陳珮宣</th>\n",
       "      <td>95</td>\n",
       "      <td>90</td>\n",
       "      <td>85</td>\n",
       "      <td>66</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>吳思以</th>\n",
       "      <td>59</td>\n",
       "      <td>94</td>\n",
       "      <td>78</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>吳文芳</th>\n",
       "      <td>82</td>\n",
       "      <td>90</td>\n",
       "      <td>60</td>\n",
       "      <td>66</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>梁嬌珮</th>\n",
       "      <td>59</td>\n",
       "      <td>72</td>\n",
       "      <td>78</td>\n",
       "      <td>70</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>伊漢韻</th>\n",
       "      <td>94</td>\n",
       "      <td>61</td>\n",
       "      <td>79</td>\n",
       "      <td>58</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>黃安琪</th>\n",
       "      <td>61</td>\n",
       "      <td>71</td>\n",
       "      <td>61</td>\n",
       "      <td>58</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李添善</th>\n",
       "      <td>61</td>\n",
       "      <td>79</td>\n",
       "      <td>91</td>\n",
       "      <td>59</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>鄭雅雯</th>\n",
       "      <td>54</td>\n",
       "      <td>80</td>\n",
       "      <td>61</td>\n",
       "      <td>79</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李銘均</th>\n",
       "      <td>93</td>\n",
       "      <td>53</td>\n",
       "      <td>59</td>\n",
       "      <td>56</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>林玉元</th>\n",
       "      <td>83</td>\n",
       "      <td>58</td>\n",
       "      <td>69</td>\n",
       "      <td>52</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>陳雅慧</th>\n",
       "      <td>79</td>\n",
       "      <td>88</td>\n",
       "      <td>93</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>蘇苡瑋</th>\n",
       "      <td>91</td>\n",
       "      <td>96</td>\n",
       "      <td>58</td>\n",
       "      <td>82</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>陳胤駿</th>\n",
       "      <td>90</td>\n",
       "      <td>80</td>\n",
       "      <td>85</td>\n",
       "      <td>64</td>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>黃涵樂</th>\n",
       "      <td>96</td>\n",
       "      <td>99</td>\n",
       "      <td>87</td>\n",
       "      <td>60</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>郭佳慧</th>\n",
       "      <td>93</td>\n",
       "      <td>57</td>\n",
       "      <td>74</td>\n",
       "      <td>59</td>\n",
       "      <td>69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>林家豪</th>\n",
       "      <td>98</td>\n",
       "      <td>54</td>\n",
       "      <td>91</td>\n",
       "      <td>87</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>蔡宜瑞</th>\n",
       "      <td>68</td>\n",
       "      <td>50</td>\n",
       "      <td>78</td>\n",
       "      <td>83</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>謝怡君</th>\n",
       "      <td>70</td>\n",
       "      <td>83</td>\n",
       "      <td>76</td>\n",
       "      <td>82</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李哲榮</th>\n",
       "      <td>59</td>\n",
       "      <td>57</td>\n",
       "      <td>73</td>\n",
       "      <td>92</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>陳奕淳</th>\n",
       "      <td>76</td>\n",
       "      <td>79</td>\n",
       "      <td>88</td>\n",
       "      <td>71</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>吳佳穎</th>\n",
       "      <td>99</td>\n",
       "      <td>89</td>\n",
       "      <td>90</td>\n",
       "      <td>60</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>王柏舜</th>\n",
       "      <td>70</td>\n",
       "      <td>69</td>\n",
       "      <td>59</td>\n",
       "      <td>88</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>宋佳純</th>\n",
       "      <td>83</td>\n",
       "      <td>92</td>\n",
       "      <td>99</td>\n",
       "      <td>88</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>謝瑋婷</th>\n",
       "      <td>51</td>\n",
       "      <td>91</td>\n",
       "      <td>52</td>\n",
       "      <td>82</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>謝嘉珮</th>\n",
       "      <td>98</td>\n",
       "      <td>57</td>\n",
       "      <td>86</td>\n",
       "      <td>69</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>蔡雯婷</th>\n",
       "      <td>60</td>\n",
       "      <td>91</td>\n",
       "      <td>50</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>魏靜怡</th>\n",
       "      <td>57</td>\n",
       "      <td>74</td>\n",
       "      <td>69</td>\n",
       "      <td>89</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>黃昱瑞</th>\n",
       "      <td>87</td>\n",
       "      <td>64</td>\n",
       "      <td>60</td>\n",
       "      <td>59</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>毛幸方</th>\n",
       "      <td>92</td>\n",
       "      <td>71</td>\n",
       "      <td>75</td>\n",
       "      <td>79</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>陳冠成</th>\n",
       "      <td>55</td>\n",
       "      <td>89</td>\n",
       "      <td>54</td>\n",
       "      <td>60</td>\n",
       "      <td>79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李淑珍</th>\n",
       "      <td>67</td>\n",
       "      <td>57</td>\n",
       "      <td>58</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>郭淑光</th>\n",
       "      <td>87</td>\n",
       "      <td>52</td>\n",
       "      <td>68</td>\n",
       "      <td>96</td>\n",
       "      <td>94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>梁為恭</th>\n",
       "      <td>90</td>\n",
       "      <td>77</td>\n",
       "      <td>89</td>\n",
       "      <td>72</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>簡志迪</th>\n",
       "      <td>52</td>\n",
       "      <td>66</td>\n",
       "      <td>78</td>\n",
       "      <td>87</td>\n",
       "      <td>85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>蔡冠儒</th>\n",
       "      <td>74</td>\n",
       "      <td>93</td>\n",
       "      <td>53</td>\n",
       "      <td>78</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>葉奎雨</th>\n",
       "      <td>91</td>\n",
       "      <td>68</td>\n",
       "      <td>62</td>\n",
       "      <td>96</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>吳昌彥</th>\n",
       "      <td>67</td>\n",
       "      <td>61</td>\n",
       "      <td>95</td>\n",
       "      <td>55</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     國文  英文  數學  地理  歷史\n",
       "鄧志杰  90  52  55  65  58\n",
       "彭雅名  79  66  87  89  71\n",
       "江昌純  52  61  92  72  62\n",
       "林佩君  73  52  95  71  52\n",
       "陳慧玲  89  67  66  81  98\n",
       "李佳玲  83  90  52  92  55\n",
       "陳曉諭  68  67  87  83  54\n",
       "謝麗娟  74  53  66  70  89\n",
       "孫彥安  67  58  73  87  59\n",
       "楊茜禎  85  62  68  52  52\n",
       "涂青桓  61  99  78  77  75\n",
       "王孟璇  96  96  61  99  78\n",
       "鄭學念  54  84  85  58  56\n",
       "陳珮宣  95  90  85  66  88\n",
       "吳思以  59  94  78  54  54\n",
       "吳文芳  82  90  60  66  55\n",
       "梁嬌珮  59  72  78  70  55\n",
       "伊漢韻  94  61  79  58  56\n",
       "黃安琪  61  71  61  58  56\n",
       "李添善  61  79  91  59  95\n",
       "鄭雅雯  54  80  61  79  68\n",
       "李銘均  93  53  59  56  64\n",
       "林玉元  83  58  69  52  64\n",
       "陳雅慧  79  88  93  94  94\n",
       "蘇苡瑋  91  96  58  82  85\n",
       "陳胤駿  90  80  85  64  76\n",
       "黃涵樂  96  99  87  60  78\n",
       "郭佳慧  93  57  74  59  69\n",
       "林家豪  98  54  91  87  95\n",
       "蔡宜瑞  68  50  78  83  92\n",
       "謝怡君  70  83  76  82  51\n",
       "李哲榮  59  57  73  92  67\n",
       "陳奕淳  76  79  88  71  87\n",
       "吳佳穎  99  89  90  60  80\n",
       "王柏舜  70  69  59  88  97\n",
       "宋佳純  83  92  99  88  64\n",
       "謝瑋婷  51  91  52  82  66\n",
       "謝嘉珮  98  57  86  69  85\n",
       "蔡雯婷  60  91  50  66  66\n",
       "魏靜怡  57  74  69  89  53\n",
       "黃昱瑞  87  64  60  59  83\n",
       "毛幸方  92  71  75  79  79\n",
       "陳冠成  55  89  54  60  79\n",
       "李淑珍  67  57  58  61  61\n",
       "郭淑光  87  52  68  96  94\n",
       "梁為恭  90  77  89  72  82\n",
       "簡志迪  52  66  78  87  85\n",
       "蔡冠儒  74  93  53  78  64\n",
       "葉奎雨  91  68  62  96  53\n",
       "吳昌彥  67  61  95  55  83"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "\n",
    "n2 = np.random.randint(50,100,size=(50,5))\n",
    "dataFrame = pd.DataFrame(data=n2,\n",
    "             index=names[:50],\n",
    "             columns=[\"國文\",\"英文\",\"數學\",\"地理\",\"歷史\"]\n",
    "             )\n",
    "dataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>鄧志杰</th>\n",
       "      <td>90</td>\n",
       "      <td>52</td>\n",
       "      <td>55</td>\n",
       "      <td>65</td>\n",
       "      <td>58</td>\n",
       "      <td>320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>彭雅名</th>\n",
       "      <td>79</td>\n",
       "      <td>66</td>\n",
       "      <td>87</td>\n",
       "      <td>89</td>\n",
       "      <td>71</td>\n",
       "      <td>392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>江昌純</th>\n",
       "      <td>52</td>\n",
       "      <td>61</td>\n",
       "      <td>92</td>\n",
       "      <td>72</td>\n",
       "      <td>62</td>\n",
       "      <td>339</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>林佩君</th>\n",
       "      <td>73</td>\n",
       "      <td>52</td>\n",
       "      <td>95</td>\n",
       "      <td>71</td>\n",
       "      <td>52</td>\n",
       "      <td>343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>陳慧玲</th>\n",
       "      <td>89</td>\n",
       "      <td>67</td>\n",
       "      <td>66</td>\n",
       "      <td>81</td>\n",
       "      <td>98</td>\n",
       "      <td>401</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李佳玲</th>\n",
       "      <td>83</td>\n",
       "      <td>90</td>\n",
       "      <td>52</td>\n",
       "      <td>92</td>\n",
       "      <td>55</td>\n",
       "      <td>372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>陳曉諭</th>\n",
       "      <td>68</td>\n",
       "      <td>67</td>\n",
       "      <td>87</td>\n",
       "      <td>83</td>\n",
       "      <td>54</td>\n",
       "      <td>359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>謝麗娟</th>\n",
       "      <td>74</td>\n",
       "      <td>53</td>\n",
       "      <td>66</td>\n",
       "      <td>70</td>\n",
       "      <td>89</td>\n",
       "      <td>352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>孫彥安</th>\n",
       "      <td>67</td>\n",
       "      <td>58</td>\n",
       "      <td>73</td>\n",
       "      <td>87</td>\n",
       "      <td>59</td>\n",
       "      <td>344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>楊茜禎</th>\n",
       "      <td>85</td>\n",
       "      <td>62</td>\n",
       "      <td>68</td>\n",
       "      <td>52</td>\n",
       "      <td>52</td>\n",
       "      <td>319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>涂青桓</th>\n",
       "      <td>61</td>\n",
       "      <td>99</td>\n",
       "      <td>78</td>\n",
       "      <td>77</td>\n",
       "      <td>75</td>\n",
       "      <td>390</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>王孟璇</th>\n",
       "      <td>96</td>\n",
       "      <td>96</td>\n",
       "      <td>61</td>\n",
       "      <td>99</td>\n",
       "      <td>78</td>\n",
       "      <td>430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>鄭學念</th>\n",
       "      <td>54</td>\n",
       "      <td>84</td>\n",
       "      <td>85</td>\n",
       "      <td>58</td>\n",
       "      <td>56</td>\n",
       "      <td>337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>陳珮宣</th>\n",
       "      <td>95</td>\n",
       "      <td>90</td>\n",
       "      <td>85</td>\n",
       "      <td>66</td>\n",
       "      <td>88</td>\n",
       "      <td>424</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>吳思以</th>\n",
       "      <td>59</td>\n",
       "      <td>94</td>\n",
       "      <td>78</td>\n",
       "      <td>54</td>\n",
       "      <td>54</td>\n",
       "      <td>339</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>吳文芳</th>\n",
       "      <td>82</td>\n",
       "      <td>90</td>\n",
       "      <td>60</td>\n",
       "      <td>66</td>\n",
       "      <td>55</td>\n",
       "      <td>353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>梁嬌珮</th>\n",
       "      <td>59</td>\n",
       "      <td>72</td>\n",
       "      <td>78</td>\n",
       "      <td>70</td>\n",
       "      <td>55</td>\n",
       "      <td>334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>伊漢韻</th>\n",
       "      <td>94</td>\n",
       "      <td>61</td>\n",
       "      <td>79</td>\n",
       "      <td>58</td>\n",
       "      <td>56</td>\n",
       "      <td>348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>黃安琪</th>\n",
       "      <td>61</td>\n",
       "      <td>71</td>\n",
       "      <td>61</td>\n",
       "      <td>58</td>\n",
       "      <td>56</td>\n",
       "      <td>307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李添善</th>\n",
       "      <td>61</td>\n",
       "      <td>79</td>\n",
       "      <td>91</td>\n",
       "      <td>59</td>\n",
       "      <td>95</td>\n",
       "      <td>385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>鄭雅雯</th>\n",
       "      <td>54</td>\n",
       "      <td>80</td>\n",
       "      <td>61</td>\n",
       "      <td>79</td>\n",
       "      <td>68</td>\n",
       "      <td>342</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李銘均</th>\n",
       "      <td>93</td>\n",
       "      <td>53</td>\n",
       "      <td>59</td>\n",
       "      <td>56</td>\n",
       "      <td>64</td>\n",
       "      <td>325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>林玉元</th>\n",
       "      <td>83</td>\n",
       "      <td>58</td>\n",
       "      <td>69</td>\n",
       "      <td>52</td>\n",
       "      <td>64</td>\n",
       "      <td>326</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>陳雅慧</th>\n",
       "      <td>79</td>\n",
       "      <td>88</td>\n",
       "      <td>93</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>蘇苡瑋</th>\n",
       "      <td>91</td>\n",
       "      <td>96</td>\n",
       "      <td>58</td>\n",
       "      <td>82</td>\n",
       "      <td>85</td>\n",
       "      <td>412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>陳胤駿</th>\n",
       "      <td>90</td>\n",
       "      <td>80</td>\n",
       "      <td>85</td>\n",
       "      <td>64</td>\n",
       "      <td>76</td>\n",
       "      <td>395</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>黃涵樂</th>\n",
       "      <td>96</td>\n",
       "      <td>99</td>\n",
       "      <td>87</td>\n",
       "      <td>60</td>\n",
       "      <td>78</td>\n",
       "      <td>420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>郭佳慧</th>\n",
       "      <td>93</td>\n",
       "      <td>57</td>\n",
       "      <td>74</td>\n",
       "      <td>59</td>\n",
       "      <td>69</td>\n",
       "      <td>352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>林家豪</th>\n",
       "      <td>98</td>\n",
       "      <td>54</td>\n",
       "      <td>91</td>\n",
       "      <td>87</td>\n",
       "      <td>95</td>\n",
       "      <td>425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>蔡宜瑞</th>\n",
       "      <td>68</td>\n",
       "      <td>50</td>\n",
       "      <td>78</td>\n",
       "      <td>83</td>\n",
       "      <td>92</td>\n",
       "      <td>371</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>謝怡君</th>\n",
       "      <td>70</td>\n",
       "      <td>83</td>\n",
       "      <td>76</td>\n",
       "      <td>82</td>\n",
       "      <td>51</td>\n",
       "      <td>362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李哲榮</th>\n",
       "      <td>59</td>\n",
       "      <td>57</td>\n",
       "      <td>73</td>\n",
       "      <td>92</td>\n",
       "      <td>67</td>\n",
       "      <td>348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>陳奕淳</th>\n",
       "      <td>76</td>\n",
       "      <td>79</td>\n",
       "      <td>88</td>\n",
       "      <td>71</td>\n",
       "      <td>87</td>\n",
       "      <td>401</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>吳佳穎</th>\n",
       "      <td>99</td>\n",
       "      <td>89</td>\n",
       "      <td>90</td>\n",
       "      <td>60</td>\n",
       "      <td>80</td>\n",
       "      <td>418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>王柏舜</th>\n",
       "      <td>70</td>\n",
       "      <td>69</td>\n",
       "      <td>59</td>\n",
       "      <td>88</td>\n",
       "      <td>97</td>\n",
       "      <td>383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>宋佳純</th>\n",
       "      <td>83</td>\n",
       "      <td>92</td>\n",
       "      <td>99</td>\n",
       "      <td>88</td>\n",
       "      <td>64</td>\n",
       "      <td>426</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>謝瑋婷</th>\n",
       "      <td>51</td>\n",
       "      <td>91</td>\n",
       "      <td>52</td>\n",
       "      <td>82</td>\n",
       "      <td>66</td>\n",
       "      <td>342</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>謝嘉珮</th>\n",
       "      <td>98</td>\n",
       "      <td>57</td>\n",
       "      <td>86</td>\n",
       "      <td>69</td>\n",
       "      <td>85</td>\n",
       "      <td>395</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>蔡雯婷</th>\n",
       "      <td>60</td>\n",
       "      <td>91</td>\n",
       "      <td>50</td>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "      <td>333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>魏靜怡</th>\n",
       "      <td>57</td>\n",
       "      <td>74</td>\n",
       "      <td>69</td>\n",
       "      <td>89</td>\n",
       "      <td>53</td>\n",
       "      <td>342</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>黃昱瑞</th>\n",
       "      <td>87</td>\n",
       "      <td>64</td>\n",
       "      <td>60</td>\n",
       "      <td>59</td>\n",
       "      <td>83</td>\n",
       "      <td>353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>毛幸方</th>\n",
       "      <td>92</td>\n",
       "      <td>71</td>\n",
       "      <td>75</td>\n",
       "      <td>79</td>\n",
       "      <td>79</td>\n",
       "      <td>396</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>陳冠成</th>\n",
       "      <td>55</td>\n",
       "      <td>89</td>\n",
       "      <td>54</td>\n",
       "      <td>60</td>\n",
       "      <td>79</td>\n",
       "      <td>337</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>李淑珍</th>\n",
       "      <td>67</td>\n",
       "      <td>57</td>\n",
       "      <td>58</td>\n",
       "      <td>61</td>\n",
       "      <td>61</td>\n",
       "      <td>304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>郭淑光</th>\n",
       "      <td>87</td>\n",
       "      <td>52</td>\n",
       "      <td>68</td>\n",
       "      <td>96</td>\n",
       "      <td>94</td>\n",
       "      <td>397</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>梁為恭</th>\n",
       "      <td>90</td>\n",
       "      <td>77</td>\n",
       "      <td>89</td>\n",
       "      <td>72</td>\n",
       "      <td>82</td>\n",
       "      <td>410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>簡志迪</th>\n",
       "      <td>52</td>\n",
       "      <td>66</td>\n",
       "      <td>78</td>\n",
       "      <td>87</td>\n",
       "      <td>85</td>\n",
       "      <td>368</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>蔡冠儒</th>\n",
       "      <td>74</td>\n",
       "      <td>93</td>\n",
       "      <td>53</td>\n",
       "      <td>78</td>\n",
       "      <td>64</td>\n",
       "      <td>362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>葉奎雨</th>\n",
       "      <td>91</td>\n",
       "      <td>68</td>\n",
       "      <td>62</td>\n",
       "      <td>96</td>\n",
       "      <td>53</td>\n",
       "      <td>370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>吳昌彥</th>\n",
       "      <td>67</td>\n",
       "      <td>61</td>\n",
       "      <td>95</td>\n",
       "      <td>55</td>\n",
       "      <td>83</td>\n",
       "      <td>361</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     國文  英文  數學  地理  歷史   總分\n",
       "鄧志杰  90  52  55  65  58  320\n",
       "彭雅名  79  66  87  89  71  392\n",
       "江昌純  52  61  92  72  62  339\n",
       "林佩君  73  52  95  71  52  343\n",
       "陳慧玲  89  67  66  81  98  401\n",
       "李佳玲  83  90  52  92  55  372\n",
       "陳曉諭  68  67  87  83  54  359\n",
       "謝麗娟  74  53  66  70  89  352\n",
       "孫彥安  67  58  73  87  59  344\n",
       "楊茜禎  85  62  68  52  52  319\n",
       "涂青桓  61  99  78  77  75  390\n",
       "王孟璇  96  96  61  99  78  430\n",
       "鄭學念  54  84  85  58  56  337\n",
       "陳珮宣  95  90  85  66  88  424\n",
       "吳思以  59  94  78  54  54  339\n",
       "吳文芳  82  90  60  66  55  353\n",
       "梁嬌珮  59  72  78  70  55  334\n",
       "伊漢韻  94  61  79  58  56  348\n",
       "黃安琪  61  71  61  58  56  307\n",
       "李添善  61  79  91  59  95  385\n",
       "鄭雅雯  54  80  61  79  68  342\n",
       "李銘均  93  53  59  56  64  325\n",
       "林玉元  83  58  69  52  64  326\n",
       "陳雅慧  79  88  93  94  94  448\n",
       "蘇苡瑋  91  96  58  82  85  412\n",
       "陳胤駿  90  80  85  64  76  395\n",
       "黃涵樂  96  99  87  60  78  420\n",
       "郭佳慧  93  57  74  59  69  352\n",
       "林家豪  98  54  91  87  95  425\n",
       "蔡宜瑞  68  50  78  83  92  371\n",
       "謝怡君  70  83  76  82  51  362\n",
       "李哲榮  59  57  73  92  67  348\n",
       "陳奕淳  76  79  88  71  87  401\n",
       "吳佳穎  99  89  90  60  80  418\n",
       "王柏舜  70  69  59  88  97  383\n",
       "宋佳純  83  92  99  88  64  426\n",
       "謝瑋婷  51  91  52  82  66  342\n",
       "謝嘉珮  98  57  86  69  85  395\n",
       "蔡雯婷  60  91  50  66  66  333\n",
       "魏靜怡  57  74  69  89  53  342\n",
       "黃昱瑞  87  64  60  59  83  353\n",
       "毛幸方  92  71  75  79  79  396\n",
       "陳冠成  55  89  54  60  79  337\n",
       "李淑珍  67  57  58  61  61  304\n",
       "郭淑光  87  52  68  96  94  397\n",
       "梁為恭  90  77  89  72  82  410\n",
       "簡志迪  52  66  78  87  85  368\n",
       "蔡冠儒  74  93  53  78  64  362\n",
       "葉奎雨  91  68  62  96  53  370\n",
       "吳昌彥  67  61  95  55  83  361"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataFrame[\"國文\"]\n",
    "dataFrame[[\"國文\",\"英文\"]]\n",
    "total = dataFrame[\"國文\"] + dataFrame[\"英文\"] + dataFrame[\"數學\"] + dataFrame[\"地理\"] + dataFrame[\"歷史\"]\n",
    "dataFrame[\"總分\"] = total \n",
    "dataFrame"
   ]
  }
 ],
 "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.10.12"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}