Insert prefix to all pandas dataframe columns names

Question

I have created the following pandas dataframe:

import pandas as pd

ds = {"col1":[1,2,3,4,5], "col2":[6,7,8,9,10]}
df = pd.DataFrame(data=ds)
print(df)

Which looks like this:

   col1  col2
0     1     6
1     2     7
2     3     8
3     4     9
4     5    10

I need to add a prefix (Milan_) to all columns anmes. Bear in mind that in a real dataframe I have 2,000+ columns, so I won't be able to do it manually.

The resulting dataframe would look like this:

   Milan_col1  Milan_col2
0           1           6
1           2           7
2           3           8
3           4           9
4           5          10

Is there an automatica way to do it in Python for dataframes with 2,000+ fields?

Jesse Sealand · Accepted Answer · 2023-09-23 15:41:22Z

1

There certainly is a way to do that

df_new = df.add_prefix("Milan_")

answered Sep 23, 2023 at 15:41

Jesse Sealand

1,6331 gold badge10 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Insert prefix to all pandas dataframe columns names

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related