Sample Code/Day_15_SampleCode.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"範例.ipynb","provenance":[],"collapsed_sections":[]},"kernelspec":{"name":"python3","display_name":"Python 3"}},"cells":[{"cell_type":"markdown","metadata":{"id":"fC7DcJzBrr3D"},"source":["範例目標:<br>\r\n","1. 實做 groupby 函式實現資料科學的 Split-Apply-Combine 策略\r\n"]},{"cell_type":"markdown","metadata":{"id":"q-roEAK7rvls"},"source":["範例重點:<br>\r\n","1. Groupby可以同時針對多個欄位做 Group，並在Group中做運算\r\n","2. Split：將大的數據集拆成可獨立計算的小數據集\r\n","3. Apply：獨立計算各個小數據集\r\n","4. Combine：將小數據集運算結果合併\r\n","\r\n"]},{"cell_type":"code","metadata":{"id":"ffWyrOxprv_9"},"source":["import pandas as pd"],"execution_count":null,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":390},"id":"joeJhyVfRkj2","executionInfo":{"status":"ok","timestamp":1608453172680,"user_tz":-480,"elapsed":1145,"user":{"displayName":"献竤黃","photoUrl":"","userId":"07529243043474362942"}},"outputId":"332aacae-12d7-42b2-97a5-4ced365fd1e1"},"source":["score_df = pd.DataFrame([[1,50,80,70,'boy'], \r\n","              [2,60,45,50,'boy'],\r\n","              [3,98,43,55,'boy'],\r\n","              [4,70,69,89,'boy'],\r\n","              [5,56,79,60,'girl'],\r\n","              [6,60,68,55,'girl'],\r\n","              [7,45,70,77,'girl'],\r\n","              [8,55,77,76,'girl'],\r\n","              [9,25,57,60,'girl'],\r\n","              [10,88,40,43,'girl']],columns=['student_id','math_score','english_score','chinese_score','sex'])\r\n","score_df = score_df.set_index('student_id')\r\n","score_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>math_score</th>\n","      <th>english_score</th>\n","      <th>chinese_score</th>\n","      <th>sex</th>\n","    </tr>\n","    <tr>\n","      <th>student_id</th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>1</th>\n","      <td>50</td>\n","      <td>80</td>\n","      <td>70</td>\n","      <td>boy</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>60</td>\n","      <td>45</td>\n","      <td>50</td>\n","      <td>boy</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>98</td>\n","      <td>43</td>\n","      <td>55</td>\n","      <td>boy</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>70</td>\n","      <td>69</td>\n","      <td>89</td>\n","      <td>boy</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>56</td>\n","      <td>79</td>\n","      <td>60</td>\n","      <td>girl</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>60</td>\n","      <td>68</td>\n","      <td>55</td>\n","      <td>girl</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>45</td>\n","      <td>70</td>\n","      <td>77</td>\n","      <td>girl</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>55</td>\n","      <td>77</td>\n","      <td>76</td>\n","      <td>girl</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>25</td>\n","      <td>57</td>\n","      <td>60</td>\n","      <td>girl</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>88</td>\n","      <td>40</td>\n","      <td>43</td>\n","      <td>girl</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["            math_score  english_score  chinese_score   sex\n","student_id                                                \n","1                   50             80             70   boy\n","2                   60             45             50   boy\n","3                   98             43             55   boy\n","4                   70             69             89   boy\n","5                   56             79             60  girl\n","6                   60             68             55  girl\n","7                   45             70             77  girl\n","8                   55             77             76  girl\n","9                   25             57             60  girl\n","10                  88             40             43  girl"]},"metadata":{"tags":[]},"execution_count":4}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"8dT-54MVRyp-","executionInfo":{"status":"ok","timestamp":1608453272459,"user_tz":-480,"elapsed":693,"user":{"displayName":"献竤黃","photoUrl":"","userId":"07529243043474362942"}},"outputId":"7b7a5f08-b535-42fc-fe76-b1783335b8e4"},"source":["#運用索引將資料分開再取平均\r\n","boy_score_df = score_df.loc[score_df.sex=='boy']\r\n","girl_score_df = score_df.loc[score_df.sex=='girl']\r\n","print(boy_score_df.mean())\r\n","print(girl_score_df.mean())"],"execution_count":null,"outputs":[{"output_type":"stream","text":["math_score       69.50\n","english_score    59.25\n","chinese_score    66.00\n","dtype: float64\n","math_score       54.833333\n","english_score    65.166667\n","chinese_score    61.833333\n","dtype: float64\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":142},"id":"9AH0aUCcSIVN","executionInfo":{"status":"ok","timestamp":1608453628523,"user_tz":-480,"elapsed":1078,"user":{"displayName":"献竤黃","photoUrl":"","userId":"07529243043474362942"}},"outputId":"5598dce2-1986-4365-bf62-83f2a7cf5029"},"source":["#運用groupby方法值接取平均\r\n","score_df.groupby('sex').mean()"],"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>math_score</th>\n","      <th>english_score</th>\n","      <th>chinese_score</th>\n","    </tr>\n","    <tr>\n","      <th>sex</th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>boy</th>\n","      <td>69.500000</td>\n","      <td>59.250000</td>\n","      <td>66.000000</td>\n","    </tr>\n","    <tr>\n","      <th>girl</th>\n","      <td>54.833333</td>\n","      <td>65.166667</td>\n","      <td>61.833333</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["      math_score  english_score  chinese_score\n","sex                                           \n","boy    69.500000      59.250000      66.000000\n","girl   54.833333      65.166667      61.833333"]},"metadata":{"tags":[]},"execution_count":9}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":390},"id":"-0QpppgwTptB","executionInfo":{"status":"ok","timestamp":1608454572773,"user_tz":-480,"elapsed":1181,"user":{"displayName":"献竤黃","photoUrl":"","userId":"07529243043474362942"}},"outputId":"b38dec48-25ef-467f-bc4c-5a135ee99d2a"},"source":["#新增欄位class\r\n","score_df['class'] = [1,2,1,2,1,2,1,2,1,2]\r\n","score_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>math_score</th>\n","      <th>english_score</th>\n","      <th>chinese_score</th>\n","      <th>sex</th>\n","      <th>class</th>\n","    </tr>\n","    <tr>\n","      <th>student_id</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>1</th>\n","      <td>50</td>\n","      <td>80</td>\n","      <td>70</td>\n","      <td>boy</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>60</td>\n","      <td>45</td>\n","      <td>50</td>\n","      <td>boy</td>\n","      <td>2</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>98</td>\n","      <td>43</td>\n","      <td>55</td>\n","      <td>boy</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>70</td>\n","      <td>69</td>\n","      <td>89</td>\n","      <td>boy</td>\n","      <td>2</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>56</td>\n","      <td>79</td>\n","      <td>60</td>\n","      <td>girl</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>60</td>\n","      <td>68</td>\n","      <td>55</td>\n","      <td>girl</td>\n","      <td>2</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>45</td>\n","      <td>70</td>\n","      <td>77</td>\n","      <td>girl</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>55</td>\n","      <td>77</td>\n","      <td>76</td>\n","      <td>girl</td>\n","      <td>2</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>25</td>\n","      <td>57</td>\n","      <td>60</td>\n","      <td>girl</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>88</td>\n","      <td>40</td>\n","      <td>43</td>\n","      <td>girl</td>\n","      <td>2</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["            math_score  english_score  chinese_score   sex  class\n","student_id                                                       \n","1                   50             80             70   boy      1\n","2                   60             45             50   boy      2\n","3                   98             43             55   boy      1\n","4                   70             69             89   boy      2\n","5                   56             79             60  girl      1\n","6                   60             68             55  girl      2\n","7                   45             70             77  girl      1\n","8                   55             77             76  girl      2\n","9                   25             57             60  girl      1\n","10                  88             40             43  girl      2"]},"metadata":{"tags":[]},"execution_count":11}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":204},"id":"bDEuMHiXXPh7","executionInfo":{"status":"ok","timestamp":1608454595961,"user_tz":-480,"elapsed":1260,"user":{"displayName":"献竤黃","photoUrl":"","userId":"07529243043474362942"}},"outputId":"04ba4906-22c3-4573-cea5-6e0646acc336"},"source":["#Groupby也可以針對多個欄位做分析\r\n","score_df.groupby(['sex','class']).mean()"],"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></th>\n","      <th>math_score</th>\n","      <th>english_score</th>\n","      <th>chinese_score</th>\n","    </tr>\n","    <tr>\n","      <th>sex</th>\n","      <th>class</th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th rowspan=\"2\" valign=\"top\">boy</th>\n","      <th>1</th>\n","      <td>74.000000</td>\n","      <td>61.500000</td>\n","      <td>62.500000</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>65.000000</td>\n","      <td>57.000000</td>\n","      <td>69.500000</td>\n","    </tr>\n","    <tr>\n","      <th rowspan=\"2\" valign=\"top\">girl</th>\n","      <th>1</th>\n","      <td>42.000000</td>\n","      <td>68.666667</td>\n","      <td>65.666667</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>67.666667</td>\n","      <td>61.666667</td>\n","      <td>58.000000</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["            math_score  english_score  chinese_score\n","sex  class                                          \n","boy  1       74.000000      61.500000      62.500000\n","     2       65.000000      57.000000      69.500000\n","girl 1       42.000000      68.666667      65.666667\n","     2       67.666667      61.666667      58.000000"]},"metadata":{"tags":[]},"execution_count":12}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":390},"id":"dT9FRW1gZ1Zs","executionInfo":{"status":"ok","timestamp":1608455251108,"user_tz":-480,"elapsed":1301,"user":{"displayName":"献竤黃","photoUrl":"","userId":"07529243043474362942"}},"outputId":"713553d0-a96b-47f1-dfa3-16aadae86e48"},"source":["score_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>math_score</th>\n","      <th>english_score</th>\n","      <th>chinese_score</th>\n","      <th>sex</th>\n","      <th>class</th>\n","    </tr>\n","    <tr>\n","      <th>student_id</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>1</th>\n","      <td>50</td>\n","      <td>80</td>\n","      <td>70</td>\n","      <td>boy</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>60</td>\n","      <td>45</td>\n","      <td>50</td>\n","      <td>boy</td>\n","      <td>2</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>98</td>\n","      <td>43</td>\n","      <td>55</td>\n","      <td>boy</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>70</td>\n","      <td>69</td>\n","      <td>89</td>\n","      <td>boy</td>\n","      <td>2</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>56</td>\n","      <td>79</td>\n","      <td>60</td>\n","      <td>girl</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>60</td>\n","      <td>68</td>\n","      <td>55</td>\n","      <td>girl</td>\n","      <td>2</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>45</td>\n","      <td>70</td>\n","      <td>77</td>\n","      <td>girl</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>55</td>\n","      <td>77</td>\n","      <td>76</td>\n","      <td>girl</td>\n","      <td>2</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>25</td>\n","      <td>57</td>\n","      <td>60</td>\n","      <td>girl</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>88</td>\n","      <td>40</td>\n","      <td>43</td>\n","      <td>girl</td>\n","      <td>2</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["            math_score  english_score  chinese_score   sex  class\n","student_id                                                       \n","1                   50             80             70   boy      1\n","2                   60             45             50   boy      2\n","3                   98             43             55   boy      1\n","4                   70             69             89   boy      2\n","5                   56             79             60  girl      1\n","6                   60             68             55  girl      2\n","7                   45             70             77  girl      1\n","8                   55             77             76  girl      2\n","9                   25             57             60  girl      1\n","10                  88             40             43  girl      2"]},"metadata":{"tags":[]},"execution_count":14}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":173},"id":"4eaijUg_XWBi","executionInfo":{"status":"ok","timestamp":1608454936393,"user_tz":-480,"elapsed":1454,"user":{"displayName":"献竤黃","photoUrl":"","userId":"07529243043474362942"}},"outputId":"b3e1f9d5-6dbe-40cb-d23e-78d1eec80292"},"source":["#Groupby也可以針對欄位做多個分析\r\n","score_df.groupby(['sex']).agg(['mean','std'])"],"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 tr th {\n","        text-align: left;\n","    }\n","\n","    .dataframe thead tr:last-of-type th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr>\n","      <th></th>\n","      <th colspan=\"2\" halign=\"left\">math_score</th>\n","      <th colspan=\"2\" halign=\"left\">english_score</th>\n","      <th colspan=\"2\" halign=\"left\">chinese_score</th>\n","      <th colspan=\"2\" halign=\"left\">class</th>\n","    </tr>\n","    <tr>\n","      <th></th>\n","      <th>mean</th>\n","      <th>std</th>\n","      <th>mean</th>\n","      <th>std</th>\n","      <th>mean</th>\n","      <th>std</th>\n","      <th>mean</th>\n","      <th>std</th>\n","    </tr>\n","    <tr>\n","      <th>sex</th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>boy</th>\n","      <td>69.500000</td>\n","      <td>20.680103</td>\n","      <td>59.250000</td>\n","      <td>18.191115</td>\n","      <td>66.000000</td>\n","      <td>17.530925</td>\n","      <td>1.5</td>\n","      <td>0.577350</td>\n","    </tr>\n","    <tr>\n","      <th>girl</th>\n","      <td>54.833333</td>\n","      <td>20.566153</td>\n","      <td>65.166667</td>\n","      <td>14.579666</td>\n","      <td>61.833333</td>\n","      <td>12.952477</td>\n","      <td>1.5</td>\n","      <td>0.547723</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["     math_score            english_score  ... chinese_score class          \n","           mean        std          mean  ...           std  mean       std\n","sex                                       ...                              \n","boy   69.500000  20.680103     59.250000  ...     17.530925   1.5  0.577350\n","girl  54.833333  20.566153     65.166667  ...     12.952477   1.5  0.547723\n","\n","[2 rows x 8 columns]"]},"metadata":{"tags":[]},"execution_count":13}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/","height":235},"id":"3M5LfFXSYpFp","executionInfo":{"status":"ok","timestamp":1608455714475,"user_tz":-480,"elapsed":1113,"user":{"displayName":"献竤黃","photoUrl":"","userId":"07529243043474362942"}},"outputId":"3c96d6aa-d6fa-4f50-8b55-52887d200643"},"source":["#Groupby也可以同時針對多個欄位做多個分析\r\n","score_df.groupby(['sex','class']).agg(['mean','max'])"],"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 tr th {\n","        text-align: left;\n","    }\n","\n","    .dataframe thead tr:last-of-type th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr>\n","      <th></th>\n","      <th></th>\n","      <th colspan=\"2\" halign=\"left\">math_score</th>\n","      <th colspan=\"2\" halign=\"left\">english_score</th>\n","      <th colspan=\"2\" halign=\"left\">chinese_score</th>\n","    </tr>\n","    <tr>\n","      <th></th>\n","      <th></th>\n","      <th>mean</th>\n","      <th>max</th>\n","      <th>mean</th>\n","      <th>max</th>\n","      <th>mean</th>\n","      <th>max</th>\n","    </tr>\n","    <tr>\n","      <th>sex</th>\n","      <th>class</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 rowspan=\"2\" valign=\"top\">boy</th>\n","      <th>1</th>\n","      <td>74.000000</td>\n","      <td>98</td>\n","      <td>61.500000</td>\n","      <td>80</td>\n","      <td>62.500000</td>\n","      <td>70</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>65.000000</td>\n","      <td>70</td>\n","      <td>57.000000</td>\n","      <td>69</td>\n","      <td>69.500000</td>\n","      <td>89</td>\n","    </tr>\n","    <tr>\n","      <th rowspan=\"2\" valign=\"top\">girl</th>\n","      <th>1</th>\n","      <td>42.000000</td>\n","      <td>56</td>\n","      <td>68.666667</td>\n","      <td>79</td>\n","      <td>65.666667</td>\n","      <td>77</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>67.666667</td>\n","      <td>88</td>\n","      <td>61.666667</td>\n","      <td>77</td>\n","      <td>58.000000</td>\n","      <td>76</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["           math_score     english_score     chinese_score    \n","                 mean max          mean max          mean max\n","sex  class                                                   \n","boy  1      74.000000  98     61.500000  80     62.500000  70\n","     2      65.000000  70     57.000000  69     69.500000  89\n","girl 1      42.000000  56     68.666667  79     65.666667  77\n","     2      67.666667  88     61.666667  77     58.000000  76"]},"metadata":{"tags":[]},"execution_count":16}]},{"cell_type":"code","metadata":{"id":"JJi_FAaZblSp"},"source":[""],"execution_count":null,"outputs":[]}]}