Question

我有一个数据框架,我想根据三栏进行分类,其中一栏特别有我想使用的具体地图。例如,就这一数据框架而言:

我想按以下几栏分类:<代码>Code,Item,和Type,但我特别要分类。具体图象(<>t/code>,即指Admin、工作人员、用户、客户(因为我知道Item和栏>的“Code/code>栏将始终至少有4项相同价值(例如所举的例子中的1和2)。因此,我希望我的数据框架照此办理:



In Python, I know how to sort by multiple columns, and I also know how to sort by a particular mapping, but I don t know how to do both at the same time, so if anyone could provide some help I would greatly appreciate it, thank you!

Answer 1

<><><>>>>

http://www.un.org/Depts/DGACM/index_french.htm func

# your order of Type column
order = [ Admin ,  Staff ,  User ,  Customer ]

# make mapper of your Type column order 
m = {key: n for n, key in enumerate(order)}

# sort by Code, Item and mapped Type column
页: 1 = df.sort_values(
    [ Code ,  Item ,  Type ], 
    key=lambda x: x.map(m) if x.name ==  Type  else x
)

页: 1

  Code  Item      Type
3  AAA     1     Admin
2  AAA     1     Staff
1  AAA     1      User
0  AAA     1  Customer
6  AAA     2     Admin
4  AAA     2     Staff
5  AAA     2      User
7  AAA     2  Customer
8  BBB     1      User

www.un.org/spanish/ecosoc 例

在法典或文本中树立榜样,而不是形象。

import pandas as pd

data = { Code : [ AAA ,  AAA ,  AAA ,  AAA ,  AAA ,  AAA ,  AAA ,  AAA ,  BBB ],
         Item : [1, 1, 1, 1, 2, 2, 2, 2, 1],
         Type : [ Customer ,  User ,  Staff ,  Admin ,  Staff ,  User ,  Admin ,  Customer ,  User ]}

df = pd.DataFrame(data)

友情链接