How to split string and get only one word in python

Question

I have the below string similar to this:

HELLO TEST PACKAGE PARIS1 PROJECT

I got the string from the selecting row and column:

project_name = df[col_pro].values[row_pro]

I also want to get "PARIS" to be in the new column which is 'location_id'

I tried using the split but it was difficult for me to get  "PARIS" only.

How can I do this with python? Thank you

Answer 1

I would use the Named groups. Say you have df;

                               text

0  HELLO TEST PACKAGE PARIS1 PROJECT

Using the Named Groups

df.text.str.extract(r'(?P<location_id>PARIS)')

 Improve your knowledge in data science from scratch using Data science online courses