我的数据集如下所示.我正在try 对其进行排序,以便列按以下顺序排列:周末、澳大利亚、德国、法国等...
我曾try 使用loc
并将每个数据集指定为变量,但当我创建新的数据帧时,它会导致错误.任何帮助都将不胜感激.
这是任何更改之前的数据:
Region | Week End | Value |
---|---|---|
Australia | 2014-01-11 | 1.480510 |
Germany | 2014-01-11 | 1.481258 |
France | 2014-01-11 | 0.986507 |
United Kingdom | 2014-01-11 | 1.973014 |
Italy | 2014-01-11 | 0.740629 |
这是我想要的输出:
Week End | Australia | Germany | France | United Kingdom | Italy |
---|---|---|---|---|---|
2014-01-11 | 1.480510 | 1.481258 | 0.986507 | 1.973014 | 0.740629 |
我所try 的:
cols = (['Region','Week End','Value'])
df = GS.loc[GS['Brand'].isin(rows)]
df = df[cols]
AUS = df.loc[df['Region'] == 'Australia']
JPN = df.loc[df['Region'] == 'Japan']
US = df.loc[df['Region'] == 'United States of America']