﻿ Pandas: Capitalize all the string values of specified columns of a given DataFrame - w3resource # Pandas: Capitalize all the string values of specified columns of a given DataFrame

## Pandas: String and Regular Expression Exercise-5 with Solution

Write a Pandas program to capitalize all the string values of specified columns of a given DataFrame.

Sample Solution:

Python Code :

``````import pandas as pd
df = pd.DataFrame({
'name': ['alberto','gino','ryan', 'Eesha', 'syed'],
'date_of_birth ': ['17/05/2002','16/02/1999','25/09/1998','11/05/2002','15/09/1997'],
'age': [18.5, 21.2, 22.5, 22, 23]
})
print("Original DataFrame:")
print(df)
print("\nAfter capitalizing name column:")
df['name'] = list(map(lambda x: x.capitalize(), df['name']))
print(df)
``````

Sample Output:

```Original DataFrame:
name date_of_birth    age
0  alberto     17/05/2002  18.5
1     gino     16/02/1999  21.2
2     ryan     25/09/1998  22.5
3    Eesha     11/05/2002  22.0
4     syed     15/09/1997  23.0

After capitalizing name column:
name date_of_birth    age
0  Alberto     17/05/2002  18.5
1     Gino     16/02/1999  21.2
2     Ryan     25/09/1998  22.5
3    Eesha     11/05/2002  22.0
4     Syed     15/09/1997  23.0
```

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

What is the difficulty level of this exercise?

Test your Python skills with w3resource's quiz

﻿

## Python: Tips of the Day

Returns True if there are duplicate values in a flat list, False otherwise

Example:

```def tips_duplicates(lst):
return len(lst) != len(set(lst))

x = [2, 4, 6, 8, 4, 2]
y = [1, 3, 5, 7, 9]
print(tips_duplicates(x))
print(tips_duplicates(y))
```

Output:

```True
False
```