Jason Ching Yuk Jason Ching Yuk - 3 months ago 18
Python Question

Capitalize first letter of each word in the column Python

how do you capitalize the first letter of each word in the column? I am using python pandas by the way. For example,

Column1
The apple
the Pear
Green tea


My desire result will be:

Column1
The Apple
The Pear
Green Tea

Answer

You can use str.title:

print (df.Column1.str.title())
0    The Apple
1     The Pear
2    Green Tea
Name: Column1, dtype: object

Another very similar method is str.capitalize, but it uppercases only first letters:

print (df.Column1.str.capitalize())
0    The apple
1     The pear
2    Green tea
Name: Column1, dtype: object