這是我的基本資料框：
Course Subject Score Teacher Student
course_1 subject_1 18 teacher1 student_1
course_1 subject_1 16 teacher1 student_3
course_1 subject_1 18 teacher1 student_2
course_1 subject_2 19 teacher1 student_1
course_1 subject_2 20 teacher1 student_3
course_1 subject_3 17 teacher1 student_2
course_1 subject_3 18 teacher1 student_1
course_1 subject_3 13 teacher1 student_3
我使用這種方法來創建資料透視表：
pivot_df = pd.pivot_table(df, values="Score", index=["Course", "Subject"], columns=["Teacher", "Student"])
我想要這樣的東西：
teacher1
student_1 student_2 student_3
course_1 subject_1 18 18 16
subject_2 19 Nan 20
subject_3 18 17 13
但是熊貓給了我這個：
teacher1\student_1 teacher1\student_2 teacher1\student_3
course_1\subject_1 18 18 16
course_1\subject_2 19 Nan 20
course_1\subject_3 18 17 13
如何解決這個問題？
uj5u.com熱心網友回復：
我不會重現您的問題（使用 pandas 版本 1.3.5 和 1.4.1 進行測驗）。
正如預期的那樣，我得到了一個 MultiIndex：
Teacher teacher1
Student student_1 student_2 student_3
Course Subject
course_1 subject_1 18.0 18.0 16.0
subject_2 19.0 NaN 20.0
subject_3 18.0 17.0 13.0
如圖：
使用的輸入：
df = pd.DataFrame({'Course': ['course_1', 'course_1', 'course_1', 'course_1', 'course_1', 'course_1', 'course_1', 'course_1'],
'Subject': ['subject_1', 'subject_1', 'subject_1', 'subject_2', 'subject_2', 'subject_3', 'subject_3', 'subject_3'],
'Score': [18, 16, 18, 19, 20, 17, 18, 13],
'Teacher': ['teacher1', 'teacher1', 'teacher1', 'teacher1', 'teacher1', 'teacher1', 'teacher1', 'teacher1'],
'Student': ['student_1', 'student_3', 'student_2', 'student_1', 'student_3', 'student_2', 'student_1', 'student_3']})
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/424785.html
標籤：Python python-3.x 熊猫 数据透视表