Renaming multiple DataFrame columns with a for loop in Pandas

Question

So i have Dataframe that has around 40 columns. They contain (made up) scores for a test. The columns are now named as follows:
Student, Date, Score, Score.1, Score.2 all the way to Score.39.
We were asked to reset the column names so they match the score (change Score to Score.1, Score.1 to Score.2, Score.2 to Score.3 and so on).

My code looks like this now:

import pandas as pd
prog = pd.read_excel('File.xlsx')
for c in prog.columns:
    prog[c].rename(columns = lambda x : 'Score_' + x)

Unfortunatly this does not give the output i want it to.
I was hoping someone could show me how to do this.
Thanks in advance

cols = df.columns.tolist() and df.columns = cols[:2] + ['Score_%i' % i for i in xrange(1, len(cols[2:])+1)]? — Zero
– Zero, Commented Feb 9, 2017 at 20:19

Matthijs Kemp · Accepted Answer · 2017-02-09 22:33:55Z

1

John Galt came up with the solution in the comments: cols = df.columns.tolist() and df.columns = cols[:2] + ['Score_%i' % i for i in xrange(1, len(cols[2:])+1)]

answered Feb 9, 2017 at 22:33

Matthijs Kemp

311 silver badge6 bronze badges

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

Collectives™ on Stack Overflow

Renaming multiple DataFrame columns with a for loop in Pandas

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