How to sort dataframe with ignoring prefixes?

Question

I can sort dataframe by column like this:

df.sort(columns='sort_index', inplace=True)

And I can sort array with ignoring prefixes like this:

array.sort(key=lambda element: re.sub(re, "", element))

But how to sort dataframe with ignoring prefixes?

Add a "key" column to your dataframe with the re.sub logic then sort on that "key". After sort, drop('key', axis=1). Plus you'll need to use sort_values. — Scott Boston
– Scott Boston, Commented Feb 21, 2018 at 13:47

jezrael · Accepted Answer · 2018-02-21 13:52:15Z

2

I think you need str.replace with argsort for indices and then select by iloc what reorder rows:

df = pd.DataFrame({
    'B': list(range(9)), 
}, index=['1s','2d','2a','1c','22d','1b','2b','1c','4d'])
print (df)
     B
1s   0
2d   1
2a   2
1c   3
22d  4
1b   5
2b   6
1c   7
4d   8

idx = df.index.str.replace('\D+', '').astype(int).argsort()
df = df.iloc[idx]
print (df)
     B
1s   0
1c   3
1b   5
1c   7
2d   1
2a   2
2b   6
4d   8
22d  4

answered Feb 21, 2018 at 13:52

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to sort dataframe with ignoring prefixes?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related