Solution/Day_05_Solution.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"作業Hong.ipynb","provenance":[],"collapsed_sections":[],"authorship_tag":"ABX9TyMffUZpdOu6C4gOLEIThRao"},"kernelspec":{"name":"python3","display_name":"Python 3"}},"cells":[{"cell_type":"markdown","metadata":{"id":"oef8c2jr-PZY"},"source":["作業"]},{"cell_type":"markdown","metadata":{"id":"4YgL8NF4-Ru3"},"source":["題目:<br>\r\n","english_score = np.array([55,89,76,65,48,70])<br>\r\n","math_score = np.array([60,85,60,68,np.nan,60])<br>\r\n","chinese_score = np.array([65,90,82,72,66,77])<br>\r\n","上3列共六位同學的英文、數學、國文成績，第一個元素代表第一位同學，舉例第一位同學英文55分、數學60分、國文65分，今天第五位同學因某原因沒來考試，導致數學成績缺值，運用上列數據回答下列問題。<br>\r\n","1. 請計算各科成績平均、最大值、最小值、標準差，其中數學缺一筆資料可忽略?\r\n","2. 第五位同學補考數學後成績為55，請計算補考後數學成績平均、最大值、最小值、標準差?\r\n","3. 用補考後資料找出與國文成績相關係數最高的學科?"]},{"cell_type":"code","metadata":{"id":"QwsKU8qO-RK7","executionInfo":{"status":"ok","timestamp":1609394855636,"user_tz":-480,"elapsed":1612,"user":{"displayName":"献竤黃","photoUrl":"","userId":"07529243043474362942"}}},"source":["import numpy as np"],"execution_count":14,"outputs":[]},{"cell_type":"code","metadata":{"id":"B5BqDQAe_czh","executionInfo":{"status":"ok","timestamp":1609395148218,"user_tz":-480,"elapsed":1178,"user":{"displayName":"献竤黃","photoUrl":"","userId":"07529243043474362942"}}},"source":["english_score = np.array([55,89,76,65,48,70])\r\n","math_score = np.array([60,85,60,68,np.nan,60])\r\n","chinese_score = np.array([65,90,82,72,66,77])"],"execution_count":21,"outputs":[]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"K3tUA6u9aI3N","executionInfo":{"status":"ok","timestamp":1609395091684,"user_tz":-480,"elapsed":1257,"user":{"displayName":"献竤黃","photoUrl":"","userId":"07529243043474362942"}},"outputId":"5c16ade9-5884-4ce5-d48d-6718f8a3a3db"},"source":["#1. 請計算各科成績平均、最大值、最小值、標準差，其中數學缺一筆資料可忽略?\r\n","print(\"數學分數 \",\"平均\",np.nanmean(math_score),\"最大值\",np.nanmax(math_score),\"最小值\",np.nanmin(math_score),\"標準差\",np.nanstd(math_score))\r\n","print(\"國文分數 \",\"平均\",np.nanmean(chinese_score),\"最大值\",np.nanmax(chinese_score),\"最小值\",np.nanmin(chinese_score),\"標準差\",np.nanstd(chinese_score))\r\n","print(\"英文分數 \",\"平均\",np.nanmean(english_score),\"最大值\",np.nanmax(english_score),\"最小值\",np.nanmin(english_score),\"標準差\",np.nanstd(english_score))"],"execution_count":19,"outputs":[{"output_type":"stream","text":["數學分數  平均 66.6 最大值 85.0 最小值 60.0 標準差 9.707728879609279\n","國文分數  平均 75.33333333333333 最大值 90 最小值 65 標準差 8.825468196582484\n","英文分數  平均 67.16666666666667 最大值 89 最小值 48 標準差 13.433995020924426\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"mXjDzvSrbLlf","executionInfo":{"status":"ok","timestamp":1609395379520,"user_tz":-480,"elapsed":1754,"user":{"displayName":"献竤黃","photoUrl":"","userId":"07529243043474362942"}},"outputId":"66d381db-0111-43f6-85bc-63d8a43a6af0"},"source":["#2. 第五位同學補考數學後成績為55，請計算補考後數學成績平均、最大值、最小值、標準差?\r\n","math_score[4]=55\r\n","print(\"補考數學後\")\r\n","print(\"數學分數 \",\"平均\",np.nanmean(math_score),\"最大值\",np.nanmax(math_score),\"最小值\",np.nanmin(math_score),\"標準差\",np.nanstd(math_score))"],"execution_count":24,"outputs":[{"output_type":"stream","text":["補考數學後\n","數學分數  平均 64.66666666666667 最大值 85.0 最小值 55.0 標準差 9.860132971832694\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"SaGolKx0cKoU","executionInfo":{"status":"ok","timestamp":1609395443473,"user_tz":-480,"elapsed":1295,"user":{"displayName":"献竤黃","photoUrl":"","userId":"07529243043474362942"}},"outputId":"e8537a92-19f2-464a-debd-6fcea2612496"},"source":["#3. 用補考後資料找出與國文成績相關係數最高的學科?\r\n","#國文與英文相關係數較高\r\n","print(\"國文與數學相關係數\",np.corrcoef(chinese_score,math_score))\r\n","print(\"國文與英文相關係數\",np.corrcoef(chinese_score,english_score))"],"execution_count":25,"outputs":[{"output_type":"stream","text":["國文與數學相關係數 [[1.         0.74056803]\n"," [0.74056803 1.        ]]\n","國文與英文相關係數 [[1.         0.97792828]\n"," [0.97792828 1.        ]]\n"],"name":"stdout"}]}]}