String operations on only certain column names in pandas dataframe

Question

I have column names in a dataframe

ID c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 ... cN

but I want it to look like

ID c01 c02 c03 c04 c05 c06 c07 c08 c09 c10 c11 c12 ... cN

How can I only change select column names without changing any others?

See this

ramesh
– ramesh

2018-06-18 18:32:01 +00:00
Commented Jun 18, 2018 at 18:32 — ramesh
– ramesh, Commented Jun 18, 2018 at 18:32

skrubber · Accepted Answer · 2018-06-18 18:39:03Z

3

You can use zfill to get the leading zeroes:

l=[]
for i in range(1,20):
    l.append('c'+str(i).zfill(2))
print(l)

['c01', 'c02', 'c03', 'c04', 'c05', 'c06', 'c07', 'c08', 'c09', 'c10', 'c11', 'c12', 'c13', 'c14', 'c15', 'c16', 'c17', 'c18', 'c19']

And then add 'ID' to this list and then assign it as df.columns.

answered Jun 18, 2018 at 18:39

skrubber

1,1051 gold badge9 silver badges19 bronze badges

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

3 Comments

DrakeMurdoch Over a year ago

So there is no way to actually do it within the dataframe?

skrubber Over a year ago

am afraid once you define the columns as alphanumeric (c1, c2, etc), you cannot insert a leading zero in between.

DrakeMurdoch Over a year ago

I want to use df.rename but I am not sure how to actually go into the specific names and change them.

Collectives™ on Stack Overflow

String operations on only certain column names in pandas dataframe

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related