pandas show column with regular expression
S=pd.Series(['Finland','Colombia','Florida','Japan','Puerto Rico','Russia','france'])
S.str.contains('^F.*')
4.2
10
# Get countries starting with letter P
S=pd.Series(['Finland','Colombia','Florida','Japan','Puerto Rico','Russia','france'])
S[S.str.match(r'(^P.*)')==True]
Thank you!
10
0
4.71
7
S=pd.Series(['Finland','Colombia','Florida','Japan','Puerto Rico','Russia','france'])
[itm[0] for itm in S.str.findall('^[Ff].*') if len(itm)>0]
Thank you!
7
0
4.5
2
import numpy as np
df['first_five_Letter']=df['Country (region)'].str.extract(r'(^\w{5})')
df.head()
Thank you!
2
0
4
2
df[df['Country (region)'].str.count('^[pP].*')>0]
Thank you!
2
0
4.33
3
# Total items starting with F
S.str.count(r'(^F.*)').sum()
Thank you!
3
0
Are there any code examples left?
New code examples in category Python