Python | Pandas Series.str.contains() 过滤pandas datafram格式中包含特定字符串的行

Example #1: Use Series.str.contains a () function to find if a pattern is present in the strings of the underlying data in the given series object.

Python3

# importing pandas as pd
import pandas as pd
 
# importing re for regular expressions
import re
 
# Creating the Series
sr = pd.Series(['New_York', 'Lisbon', 'Tokyo', 'Paris', 'Munich'])
 
# Creating the index
idx = ['City 1', 'City 2', 'City 3', 'City 4', 'City 5']
 
# set the index
sr.index = idx
 
# Print the series
print(sr)

Output :

Now we will use Series.str.contains a () function to find if a pattern is contained in the string present in the underlying data of the given series object.

Python3

# find if 'is' substring is present
result = sr.str.contains(pat = 'is')
 
# print the result
print(result)

Output :

As we can see in the output, the Series.str.contains() function has returned a series object of boolean values. It is true if the passed pattern is present in the string else False is returned.
Example #2: Use Series.str.contains a () function to find if a pattern is present in the strings of the underlying data in the given series object. Use regular expressions to find patterns in the strings.

Python3

# importing pandas as pd
import pandas as pd
 
# importing re for regular expressions
import re
 
# Creating the Series
sr = pd.Series(['Mike', 'Alessa', 'Nick', 'Kim', 'Britney'])
 
# Creating the index
idx = ['Name 1', 'Name 2', 'Name 3', 'Name 4', 'Name 5']
 
# set the index
sr.index = idx
 
# Print the series
print(sr)

Output :

Now we will use Series.str.contains a () function to find if a pattern is contained in the string present in the underlying data of the given series object.

Python3

# find if there is a substring such that it has
# the letter 'i' followed by any small alphabet.
result = sr.str.contains(pat = 'i[a-z]', regex = True)
 
# print the result
print(result)

Output :

As we can see in the output, the Series.str.contains() function has returned a series object of boolean values. It is true if the passed pattern is present in the string else False is returned.

import pandas as pd
import csv
 
aliUid=["123","124","125","126"]
file = './123.log'
 
 
data = pd.read_csv(file,delimiter=',',quoting=csv.QUOTE_NONE,header=None)
 
 
for uid in aliUid:
    df = data.loc[data[52].str.contains(uid)]
 
    for column in df:
        df[column]=df[column].str.replace('"','')
 
    print(df)
    new_file=f"./{uid}.log"
    df.to_csv(new_file,quoting=csv.QUOTE_NONE,index=False,header=False)