pandas 将多列拼接到一列后面，进行多列的横向或纵向合并

需求

输入

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

代码007普通

打赏 收藏 海报 链接