使用value作为新行数来收集多个列

pip install pandas

import pandas as pd

data = {
    'A': [1, 2, 3],
    'B': [4, 5, 6],
    'C': [7, 8, 9]
}

df = pd.DataFrame(data)
print("Original DataFrame:")
print(df)

# 使用melt函数将多个列收集为一个新行
df_melted = df.melt(var_name='Column', value_name='Value')
print("
Melted DataFrame:")
print(df_melted)

Original DataFrame:
   A  B  C
0  1  4  7
1  2  5  8
2  3  6  9

Melted DataFrame:
  Column  Value
0       A      1
1       A      2
2       A      3
3       B      4
4       B      5
5       B      6
6       C      7
7       C      8
8       C      9