pandas自定义排序规则

from pandas.api.types import CategoricalDtype

a = ['红红','白白','看看','慢慢','kini','ssfs','fff']
b = ["Mar(0, 15]","Jan(15, 31]","Aug(15, 31]","Sep(0, 15]","Jun(15, 31]","Jul(0, 15]","May(15, 31]"]
df = pd.DataFrame({"编辑":a,"月份":b})
df

cat_variable_order = CategoricalDtype(
    ["Jan(0, 15]","Jan(15, 31]","Feb(0, 15]","Feb(15, 31]","Mar(0, 15]","Mar(15, 31]","Apr(0, 15]","Apr(15, 31]","May(0, 15]",
     "May(15, 31]","Jun(0, 15]","Jun(15, 31]","Jul(0, 15]","Jul(15, 31]","Aug(0, 15]","Aug(15, 31]","Sep(0, 15]","Sep(15, 31]",
     "Oct(0, 15]","Oct(15, 31]","Nov(0, 15]","Nov(15, 31]"], ordered=True)
df['月份'] = df['月份'].astype(cat_variable_order)
df.sort_values(by = ['月份'], inplace = True)
df

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值