需求
输入
import pandas as pd
lt = [["A", "F", "K"], ["B", "G", "L"], ["C", "H", "M"], ["D", "I", "N"], ["E", "J", "O"]]
df = pd.DataFrame(lt, columns=["C1", "C2", "C3"])
print(df)
C1 C2 C3
0 A F K
1 B G L
2 C H M
3 D I N
4 E J O
输出:仅一列
拼接的时候横向
C1
0 A
1 F
2 K
3 B
4 G
5 L
6 C
7 H
8 M
9 D
10 I
11 N
12 E
13 J
14 O
拼接的时候纵向
C1
0 A
1 B
2 C
3 D
4 E
5 F
6 G
7 H
8 I
9 J
10 K
11 L
12 M
13 N
14 O
解决
拼接的时候横向
df_new = pd.DataFrame(df.to_numpy().reshape(-1, 1, order='C'), columns=['C1'])
拼接的时候纵向
df_new = pd.DataFrame(df.to_numpy().reshape(-1, 1, order='F'), columns=['C1'])
参考:
[stackoverflow] combining-the-rows-of-all-columns-into-a-single-column