Classify column with URLs into categories base on terms

user_11985718 0
Viewed 56

I'm still a newbie in Python and having a hard time trying to code something.

I have a list with more than 80k URLs and this is the only thing I have in my .xls, the URLs looks like this:

https://domainexample.com/user-query/credit-card-debit-balance/
https://domainexample.com/user-query/second-invoice-current-debt/
https://domainexample.com/user-query/query-balances/
https://domainexample.com/user-query/where-is-client-portal/
https://domainexample.com/user-query/i-want-to-change-my-password/
https://domainexample.com/user-query/second-invoice-internet/
https://domainexample.com/user-query/print-payment-invoice/

I want to create a code that will read this excel and based on certain categories I already wrote, will put them in other columns.

So, whenever the code finds "paswword" it will put that URL in the column password, when it finds "user" will put the URL in the column "user".

It would look like this:

debt
https://domainexample.com/user-query/second-invoice-current-debt/

password
https://domainexample.com/user-query/i-want-to-change-my-password/

payment
https://domainexample.com/user-query/print-payment-invoice/

The code doesn't necessarily needs to change the column of the URLs, if it can create a 2nd column and write of what categories that URL belongs, it would be also great.

There is no need for the code to read the URL, just the excel file, like those URLs are simple text.

If anyone can help me, thanks a lot!

pandas excel python
1 Answers

Try this where df is your dataframe, and 'url_column' is the column with all your urls

df.loc[df['url_column'] =='url.com/what-is-a-car', 'car'] = 'url.com/'+'car'
df.loc[df['url_column'] =='url.com/what-is-a-bike', 'bike'] = 'url.com/'+'bike'
df.loc[df['url_column'] =='url.com/what-is-a-van', 'van'] = 'url.com/'+'van'
user_43422130
Related