Order DataFrame columns by multiple regex

Question

I want to order a DataFrame by multiple regex. That is to say, for example in this DataFrame

df = pd.DataFrame({'Col1': [20, 30],
                    'Col2': [50, 60],
                    'Pol2': [50, 60]})

get the columns beginning with P before the ones beginning with C.

I've discovered that you can filter with one regex like

df.filter(regex = "P*")

but I can't do that with more levels.

UPDATE: I want to do that in one instruction, I'm already able to use a list of regex and concatenate the columns in another DataFrame.

jezrael · Accepted Answer · 2019-07-05 07:10:20Z

4

I believe you need list of DataFrames filtered by regexes in list with concat:

reg = ['^P','^C']
df1 = pd.concat([df.filter(regex = r) for r in reg], axis=1)
print (df1)
   Pol2  Col1  Col2
0    50    20    50
1    60    30    60

edited Jul 5, 2019 at 7:10

answered Jul 5, 2019 at 7:08

jezrael

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

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

2 Comments

Angelo Over a year ago

Look at the update I made few seconds ago. Thank you anyway

jezrael Over a year ago

@Angelo - Not sure if understand but I can't do that with more levels. Can you explain more?

Adam.Er8 · Accepted Answer · 2019-07-05 07:12:12Z

0

you can just re-order columns by regular assignment.

export the colums to a sorted list, and index by it.

try:

import pandas as pd

df = pd.DataFrame({'Col1': [20, 30],
                   'Pol2': [50, 60],
                    'Col2': [50, 60],
                    })

df = df[sorted(df.columns.to_list(), key=lambda col: col.startswith("P"), reverse=True)]

print(df)

answered Jul 5, 2019 at 7:12

Adam.Er8

13.5k3 gold badges32 silver badges43 bronze badges

1 Comment

Adam.Er8 Over a year ago

note: if you need a more complex regex, you can modify the key to your needs

Collectives™ on Stack Overflow

Order DataFrame columns by multiple regex

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related