将列转置为来自特定单词的行

import pandas as pd

# 读取CSV文件
df = pd.read_csv('students_scores.csv')

# 假设CSV文件内容如下：
# Name,Math,Science,English
# Alice,90,85,88
# Bob,78,92,80

# 转置数据，以学生姓名为行索引
transposed_df = df.set_index('Name').T

print(transposed_df)

Name     Alice   Bob
Math        90    78
Science     85    92
English     88    80

# 填充缺失值
df_filled = df.fillna(0)  # 用0填充缺失值
transposed_df_filled = df_filled.set_index('Name').T

# 删除包含缺失值的行
df_dropped = df.dropna()
transposed_df_dropped = df_dropped.set_index('Name').T

# 假设我们只想转置数学和科学成绩
selected_columns = ['Math', 'Science']
transposed_selected_df = df[selected_columns].set_index('Name').T