w3resource

Pandas: Convert all the string values to upper, lower cases in a given pandas series and also find the length of the string values

Pandas: String and Regular Expression Exercise-1 with Solution

Write a Pandas program to convert all the string values to upper, lower cases in a given pandas series. Also find the length of the string values.

Sample Solution:

Python Code :

import pandas as pd
import numpy as np
s = pd.Series(['X', 'Y', 'Z', 'Aaba', 'Baca', np.nan, 'CABA', None, 'bird', 'horse', 'dog'])
print("Original series:")
print(s)
print("\nConvert all string values of the said Series to upper case:")
print(s.str.upper())
print("\nConvert all string values of the said Series to lower case:")
print(s.str.lower())
print("\nLength of the string values of the said Series:")
print(s.str.len()) 

Sample Output:

Original series:
0         X
1         Y
2         Z
3      Aaba
4      Baca
5       NaN
6      CABA
7      None
8      bird
9     horse
10      dog
dtype: object

Convert all string values of the said Series to upper case:
0         X
1         Y
2         Z
3      AABA
4      BACA
5       NaN
6      CABA
7      None
8      BIRD
9     HORSE
10      DOG
dtype: object

Convert all string values of the said Series to lower case:
0         x
1         y
2         z
3      aaba
4      baca
5       NaN
6      caba
7      None
8      bird
9     horse
10      dog
dtype: object

Length of the string values of the said Series:
0     1.0
1     1.0
2     1.0
3     4.0
4     4.0
5     NaN
6     4.0
7     NaN
8     4.0
9     5.0
10    3.0
dtype: float64                      

Python Code Editor:


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

Previous: Python Pandas String and Regular Expression Exercises Home.
Next: Write a Pandas program to remove whitespaces, left sided whitespaces and right sided whitespaces of the string values of a given pandas series.

What is the difficulty level of this exercise?

Test your Python skills with w3resource's quiz



Python: Tips of the Day

Returns a flat list of all the keys in a flat dictionary

Example:

def tips_keys(flat_dict):
  return list(flat_dict.keys())

ages = {
  "Jack": 15,
  "Owen": 21,
  "Wyatt": 11,
}
print(tips_keys(ages))

Output:

['Jack', 'Owen', 'Wyatt']