python - How to create new column in Pandas, based on another column by matching different string values?

Question

I want to create new column, based on text, included in a another columns string values. i've got a large df with column 'start_url':

for exaple:

df['start_url'].head(4)

• 0 https://sitename.com/
• 1 https://sitename.com/about/news/
• 2 https://sitename.com/?click_id=8YeZ1Ti4adZixjK&city=City
• 3 https://sitename.com//product/

And i want something like this:

df['start_event'].head(4)

• 0 mainscreen
• 1 news
• 2 city_selection
• 3 product_page

What's the easiest way to do this?

question from:https://stackoverflow.com/questions/65933697/how-to-create-new-column-in-pandas-based-on-another-column-by-matching-differen

Answer 1

You can use Series.map() function to do this:

your_dic = {
    "https://sitename.com/": "mainscreen",
    "https://sitename.com/about/news/": "news",
    "https://sitename.com/?click_id=8YeZ1Ti4adZixjK&city=City": "city_selection",
    "https://sitename.com//product/": "product_page"
}
df['start_event'] = df['start_url'].map(your_dic)