How to append strings to Pandas Index

Question

I have the following Pandas data frame:

import pandas as pd
df = pd.DataFrame({'d': [1, 2, 3]}, index=['FOO', 'BAR', 'BAZ'])
df
        d
FOO     1
BAR     2
BAZ     3

What I want to do is to append two strings in front of the index.

str1 = "x"
str2 = "y"

Yielding:

            d
x_y.FOO     1
x_y.BAR     2
x_y.BAZ     3

How can I do that?

df.index="x_y."+df.index or df.index=str1+'_'+str2+df.index? — Anurag Dabas
– Anurag Dabas, Commented Jul 29, 2021 at 3:26
@scamander hadn't my answer solved your problem? You haven't responded anything. — imxitiz
– imxitiz, Commented Jul 29, 2021 at 4:14

imxitiz · Accepted Answer · 2021-07-29 03:41:49Z

3

You can try this:

import pandas as pd
df = pd.DataFrame({'d': [1, 2, 3]}, index=['FOO', 'BAR', 'BAZ'])
print(df)
"""
        d
FOO     1
BAR     2
BAZ     3
"""
str1 = "x"
str2 = "y"
df.index=f"{str1}_{str2}."+df.index
print(df)
"""
         d
x_y.FOO  1
x_y.BAR  2
x_y.BAZ  3
"""

We are just adding that same string in all of the index of df. You can explore for about index from here

Note : This will only work if index is already str this wouldn't work on a RangeIndex without

df.index.astype(str)

edited Jul 29, 2021 at 3:41

answered Jul 29, 2021 at 3:28

imxitiz

4,0253 gold badges14 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

How to append strings to Pandas Index

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