Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to use Python Pandas to find the total number of count for more than one special characters present in each word in a given series?
Input − Assume you have a series,
0 fruits!! 1 *cakes* 2 $nuts 3 #drinks dtype: object
Input − The result for the total number of counts for more than one special character in a series is 2.
Let us try to find different solutions to this question.
Solution 1
To solve this, we will follow the steps given below −
Define a Series
Create special characters list of values.
Set the initial value of special character and total special char count value as 0.
Create a for loop and access all the values in the Series one by one and create an if condition to compare the value based on special character as follows −
for i in data: chars_count = 0 for j in list(i): if j in special_char: chars_count = chars_count+1
Set the if condition and check the count value. If count > 1, then print the total count.
It is defined below −
if(chars_count>1): total_count = total_count+1 print(total_count)
Solution 2
Alternatively, we can use regular expression and lambda function filter method to find the total count.
To solve this, we will follow the steps given below −
Define a series
Apply lambda filter method to validate the input based on special char ().
Find the length is more than one. It is defined below −
l=["fruits!!","*cakes*","$nuts","#drinks"] data=pd.Series(filter(lambda x:1<len(re.findall(r"\W",x)),l))
Example
Let us see the implementation to get a better understanding −
import pandas as pd import string l = ["Fruits!!","*Cakes*","$Nuts","#Drinks"] data = pd.Series(l) chars=string.punctuation special_char=list(chars) total_count = 0 for i in data: chars_count = 0 for j in list(i): if j in special_char: chars_count = chars_count+1 if(chars_count>1): total_count = total_count+1 print(total_count)
Solution 3
Example
import pandas as pd
import re
l=["fruits!!","*cakes*","$nuts","#drinks"]
data=pd.Series(filter(lambda x:1<len(re.findall(r"\W",x)),l))
print("count:",len(data))Output
The output of the above program is as follows −
2
499 Views
