如何将DataFrame中序列的顺序反转到新列中?
data = [["US Dollar", 7.00],
['Euro', 2.00],
['British Pound', 4.00],
['Indian Rupee', 2.00],
['Australian Dollar', 9.00],
['Canadian Dollar', 3.00],
['Singapore Dollar', 3.00],
['Swiss Franc', 5.00]
]
df = pd.DataFrame(data, columns=['Currency', 'Order'])
我试着使用loc来做这件事,但这给了我相同的命令.
df['Reverse Order'] = df['Order'].iloc[::-1]
df
# Currency Order Reverse Order
# 0 US Dollar 7.0 7.0
# 1 Euro 2.0 2.0
# 2 British Pound 4.0 4.0
# 3 Indian Rupee 2.0 2.0
# 4 Australian Dollar 9.0 9.0
# 5 Canadian Dollar 3.0 3.0
# 6 Singapore Dollar 3.0 3.0
# 7 Swiss Franc 5.0 5.0
我在试着得到相反的顺序
# Currency Order Reverse Order
# 0 US Dollar 7.0 5.0
# 1 Euro 2.0 3.0
# 2 British Pound 4.0 3.0
# 3 Indian Rupee 2.0 9.0
# 4 Australian Dollar 9.0 2.0
# 5 Canadian Dollar 3.0 4.0
# 6 Singapore Dollar 3.0 2.0
# 7 Swiss Franc 5.0 7.0