采取多个栏，并将它们与熊猫的索引相同。

Question

我有一堆丑陋的客户数据，我正试图使之正常化。基本上是这样的：

Customer   Order1   Order2   Order3 ... OrderN

  John      This     That     The   ...  Other
 Shelly    Thing1   Thing2   Thing3 ... ThingN
   .         .        .        .          .
   .         .        .        .          .

所以我想把它改成：

Customer   Order

 John      This
 John      That
 John      The
 Shelly    Thing1
 Shelly    Thing2

诸若此类。

不过，我不知道该怎么做。

任何帮助都会很好！

Answer 1

准确地说是一个stack和两个reset_index调用。

df
  Customer  Order1  Order2  Order3  OrderN
0     John    This    That     The   Other
1   Shelly  Thing1  Thing2  Thing3  ThingN

​

(df.set_index('Customer')
   .stack()
   .reset_index(level=1, drop=True)
   .reset_index(name='Order')
)

  Customer   Order
0     John    This
1     John    That
2     John     The
3     John   Other
4   Shelly  Thing1
5   Shelly  Thing2
6   Shelly  Thing3
7   Shelly  ThingN

Answer 2

pd.melt是你要找的那个：

# Assuming all the other columns are orders except for the Customer column
value_list = [col for col in df.columns if col != 'Customer']

pd.melt(df, id_vars=['Customer'], value_vars=value_list,
        value_name='Order').drop('variable', axis=1)

  Customer   Order
0    John    this
1  Shelly  thing1
2    John    that
3  Shelly  thing2
4    John    that
5  Shelly  thing2

Answer 3

我认为使用stack稍微好一点

df.set_index('Customer').stack().reset_index(level=0)
Out[1219]: 
       Customer       0
Order1     John    This
Order2     John    That
Order3     John     The
OrderN     John   Other
Order1   Shelly  Thing1
Order2   Shelly  Thing2
Order3   Shelly  Thing3
OrderN   Shelly  ThingN