w3resource

Python Pandas: Replace missing white spaces in a given string with the least frequent character

 

Python Pandas: Data Series Exercise-33 with Solution

Write a Pandas program to replace missing white spaces in a given string with the least frequent character.

Sample Solution :

Python Code :

import pandas as pd
str1 = 'abc def abcdef icd'
print("Original series:")
print(str1)
ser = pd.Series(list(str1))
element_freq = ser.value_counts()
print(element_freq)
current_freq = element_freq.dropna().index[-1]
result = "".join(ser.replace(' ', current_freq))
print(result)

Sample Output:

Original series:
abc def abcdef icd
c    3
     3
d    3
f    2
e    2
a    2
b    2
i    1
dtype: int64
abcidefiabcdefiicd

Python Code Editor:


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

Previous: Write a Pandas program to find the positions of the values neighboured by smaller values on both sides in a given series.
Next: Write a Pandas program to compute the autocorrelations of a given numeric series.

What is the difficulty level of this exercise?

Test your Python skills with w3resource's quiz



Python: Tips of the Day

Python: Membership Testing in a Collection

>>> a = ('one', 'two', 'three', 'four', 'five')
>>> if 'one' in a:
...     print('The tuple contains one.')
... 
The tuple contains one.
>>> b = {0: 'zero', 1: 'one', 2: 'two', 3: 'three'}
>>> if 2 in b.keys():
...     print('The dict has the key of 2.')
... 
The dict has the key of 2.