# 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