本文介绍了如何使用Python的pandas库对CSV数据进行排序。首先，按照金额字段'amount'进行整体排序，然后讨论了rank()函数的不同方法，包括first、min、max和dense，来处理相同值时的排序规则。接着，展示了如何进行组内排序，即根据'id'字段分组后，按'amount'字段进行组内降序排序，并确保序号连续。
需求：利用python实现排序功能
测试数据：data.csv
"id","date","amount"
"1","2019-02-08","6214.23"
"1","2019-02-08","6247.32"
"1","2019-02-09","85.63"
"2","2019-02-14","943.18"
"2","2019-02-15","369.76"
"2","2019-02-18","795.15"
"2","2019-02-19","715.65"
"2","2019-02-21","537.71"
"2","2019-02-24","1037.71"
"3","2019-02-09","967.36"
"3","2019-02-10","85.69"
"3","2019-02-12","769.85"
"3","2019-02-13","943.86"
"3","2019-02-19","843.86"
"3","201
最低0.47元/天 解锁文章
1041
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
