如何将pandas DataFrame的列转换为列表列表? [英] How can I convert columns of a pandas DataFrame into a list of lists?

问题描述

我有一个带有多列的pandas DataFrame.

I have a pandas DataFrame with multiple columns.

2u    2s    4r     4n     4m   7h   7v
0     1     1      0      0     0    1
0     1     0      1      0     0    1
1     0     0      1      0     1    0
1     0     0      0      1     1    0
1     0     1      0      0     1    0
0     1     1      0      0     0    1

我想做的就是将此 进入类似以下的列表

What I want to do is to convert this pandas.DataFrame into a list like following

X = [
     [0, 0, 1, 1, 1, 0],
     [1, 1, 0, 0, 0, 1],
     [1, 0, 0, 0, 1, 1],
     [0, 1, 1, 0, 0, 0],
     [0, 0, 0, 1, 0, 0],
     [0, 0, 1, 1, 1, 0],
     [1, 1, 0, 0, 0, 1]
    ]

2u 2s 4r 4n 4m 7h 7v是列标题.它会在不同的情况下发生变化，因此不必理会.

2u 2s 4r 4n 4m 7h 7v are column headings. It will change in different situations, so don't bother about it.

推荐答案

它看起来像是转置矩阵:

It looks like a transposed matrix:

df.values.T.tolist()

---

[list(l) for l in zip(*df.values)]

[[0, 0, 1, 1, 1, 0],
 [1, 1, 0, 0, 0, 1],
 [1, 0, 0, 0, 1, 1],
 [0, 1, 1, 0, 0, 0],
 [0, 0, 0, 1, 0, 0],
 [0, 0, 1, 1, 1, 0],
 [1, 1, 0, 0, 0, 1]]

这篇关于如何将pandas DataFrame的列转换为列表列表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！