将数据框的某些部分转置为单独的列

import pandas as pd

# 创建示例数据框
data = {'Name': ['John', 'Mike', 'Sarah'],
        'Math': [90, 80, 95],
        'English': [85, 75, 90],
        'Science': [92, 88, 94]}
df = pd.DataFrame(data)

# 将Math列转置为单独的列
df_transposed = pd.melt(df, id_vars=['Name'], value_vars=['Math'], var_name='Subject', value_name='Score')

print(df_transposed)

   Name Subject  Score
0  John    Math     90
1  Mike    Math     80
2 Sarah    Math     95

library(tidyverse)

# 创建示例数据框
data <- data.frame(Name = c('John', 'Mike', 'Sarah'),
                   Math = c(90, 80, 95),
                   English = c(85, 75, 90),
                   Science = c(92, 88, 94))

# 将Math列转置为单独的列
df_transposed <- data %>%
  gather(key = Subject, value = Score, Math)

print(df_transposed)

   Name Subject Score
1  John    Math    90
2  Mike    Math    80
3 Sarah    Math    95