pandas show column with regular expression code example

Example 1: pandas show column with regular expression

S=pd.Series(['Finland','Colombia','Florida','Japan','Puerto Rico','Russia','france'])
S.str.contains('^F.*')

Example 2: pandas show column with regular expression

import numpy as np
df['first_five_Letter']=df['Country (region)'].str.extract(r'(^\w{5})')
df.head()

Example 3: pandas show column with regular expression

# Get countries starting with letter P
S=pd.Series(['Finland','Colombia','Florida','Japan','Puerto Rico','Russia','france'])
S[S.str.match(r'(^P.*)')==True]

Example 4: pandas show column with regular expression

S=pd.Series(['Finland','Colombia','Florida','Japan','Puerto Rico','Russia','france'])
[itm[0] for itm in S.str.findall('^[Ff].*') if len(itm)>0]

Example 5: pandas show column with regular expression

df[df['Country (region)'].str.count('^[pP].*')>0]

Example 6: pandas show column with regular expression

# Total items starting with F
S.str.count(r'(^F.*)').sum()