How to use the get_tld library for an entire column in dataset?

Question

This is the get_tld code:

from tld import get_tld
res = get_tld("http://toystory.disney.com/toy-story", as_object=True)
print(res.domain)

I'd like to apply this to an entire column in a dataset. I'm only interested in the top level domain and not the subdomain nor the suffix.

any dataset. I have a column full of url's. The column is df['homepage'] — Mike D, Jul 19 '20 at 16:04
Does the answer helps you ? Is true, consider accepting/voting it up ;) — azro, Jul 28 '20 at 16:55

score 1 · Answer 1 · answered Jul 19 '20 at 16:08

1

Use Series.apply()

df['tld'] = df['homepage'].apply(lambda x: get_tld(x, as_object=True).domain)

answered Jul 19 '20 at 16:08

azro

1 Answers1