pandas: capitalize all or the first n words in the column names

Question

I am trying to find how to capitalize the first and second word of column header.

Example:

check match ==> Check Match

date found ==> Date Found

Thank you

Answer 1

# if your data frame is `df`, then:
df.columns = [s.capitalize() for s in df.columns]

Answer 2

capitalize all words

If you want to capitalize all words, use:

df.columns = df.columns.str.title()

or:

df.rename(columns=str.title, inplace=True)

Example:

df = pd.DataFrame(columns=['example', 'longer example', 'quite longer example'])

output headers:

['Example', 'Longer Example', 'Quite Longer Example']

capitalize only the first n words

df.columns = df.columns.str.replace(r'(\w+)', lambda x: x.group().capitalize(),
                                    n=2, regex=True)

example:

['Example', 'Longer Example', 'Quite Longer example']

Answer 3

Did you try?

df.columns=df.columns.str.title()