基于python, sort descending dataframe with pandas
给定:
from pandas import DataFrame
import pandas as pd
d = {'x':[2,3,1,4,5],
'y':[5,4,3,2,1],
'letter':['a','a','b','b','c']}
df = DataFrame(d)df然后看起来像这样:
df:
letter x y
0 a 2 5
1 a 3 4
2 b 1 3
3 b 4 2
4 c 5 1我想要像这样的东西:
f = lambda x,y: x**2 + y**2
test = df.sort(f('x', 'y'))这应该对列'x‘和'y’的平方值之和的完整数据帧进行排序,并给出:
test:
letter x y
2 b 1 3
3 b 4 2
1 a 3 4
4 c 5 1
0 a 2 5升序或降序并不重要。有没有一种既好又简单的方法呢?我还找不到解决方案。
发布于 2020-04-16 05:46:34
df.loc[(df.x ** 2 + df.y ** 2).sort_values().index]在How to sort pandas dataframe by custom order on string index之后
发布于 2016-07-30 00:18:44
您可以创建要在排序中使用的临时列,然后删除它:
df.assign(f = df['one']**2 + df['two']**2).sort_values('f').drop('f', axis=1)
Out:
letter one two
2 b 1 3
3 b 4 2
1 a 3 4
4 c 5 1
0 a 2 5发布于 2016-07-30 00:18:44
from pandas import DataFrame
import pandas as pd
d = {'one':[2,3,1,4,5],
'two':[5,4,3,2,1],
'letter':['a','a','b','b','c']}
df = pd.DataFrame(d)
#f = lambda x,y: x**2 + y**2
array = []
for i in range(5):
array.append(df.ix[i,1]**2 + df.ix[i,2]**2)
array = pd.DataFrame(array, columns = ['Sum of Squares'])
test = pd.concat([df,array],axis = 1, join = 'inner')
test = test.sort_index(by = "Sum of Squares", ascending = True).drop('Sum of Squares',axis =1)刚刚意识到你想要这个:
letter one two
2 b 1 3
3 b 4 2
1 a 3 4
4 c 5 1
0 a 2 5https://stackoverflow.com/questions/38662826
复制相似问题