import pandas as pd
excel_path = 'GPA.xlsx'
d = pd.read_excel(excel_path, sheetname=None)
D:\anacorda\lib\site-packages\pandas\io\excel.py:329: FutureWarning: The `sheetname` keyword is deprecated, use `sheet_name` instead
**kwds)
df = pd.DataFrame(d['Sheet1'],columns=['學年度學期','選別', '科目名稱', '學分','成績','GPA 4.3','GPA 4.0'])
df.head(5)
|
學年度學期 |
選別 |
科目名稱 |
學分 |
成績 |
GPA 4.3 |
GPA 4.0 |
0 |
1072 |
選修 |
機器學習 |
3 |
80 |
NaN |
NaN |
1 |
1072 |
選修 |
進階資料結構 |
3 |
99 |
NaN |
NaN |
2 |
1072 |
選修 |
金融交易系統 |
3 |
96 |
NaN |
NaN |
3 |
1071 |
必修 |
專題(二) |
1 |
90 |
NaN |
NaN |
4 |
1071 |
必修 |
專業倫理-科技倫理 |
2 |
90 |
NaN |
NaN |
換算成積至4.3/4.0
def four_point_three(grade):
if grade>=90:
return 4.3
elif grade<=89 and grade>=85:
return 4
elif grade<=84 and grade>=80:
return