Python pandas df rename index using regex

Question

My df looks like this.

                 2019   2018
Sally#16#       -6461  -6340
Brian#06#        7139   7200
rebecca#9#       1337   1067
mark#10#        10922  11128
toto            12936  13054

Here, I would like to remove #number# from all my indexes. Is there a way to achieve this? probably with regex, so that I can have a final df like this:

                 2019   2018
Sally           -6461  -6340
Brian            7139   7200
rebecca          1337   1067
mark            10922  11128
toto            12936  13054

Thank you!

jezrael · Accepted Answer · 2020-07-10 06:40:39Z

5

Use Series.str.replace with \d+ for select all numbers between #:

df.index = df.index.str.replace(r'(#\d+#)', '')
print (df)
          2019   2018
Sally    -6461  -6340
Brian     7139   7200
rebecca   1337   1067
mark     10922  11128
toto     12936  13054

edited Jul 10, 2020 at 6:40

answered Jul 10, 2020 at 6:37

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

Python pandas df rename index using regex

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