如何将字符串远程处理为特定字符(Python/panda)

Question

我有DataFrame:

link = [{'name': 'http://website.com/product76tre53932'}, {'name': 'http://website.it/productiee8340'}, {'name': 'http://website.de/productooi7309'}]
df = pd.DataFrame(link)

如何剪切得到下一个结果的值，您可以在df['name_2]列中看到：在此处输入图像描述

Answer 1

您可以使用urllib.parse模块来解析这些URL。

>>> from urllib.parse import urlsplit
>>>
>>> def create_url(url):
...     r = urlsplit(url)
...     return f"{r.scheme}://{r.netloc}"
...
>>> link = [{'name': 'http://website.com/product76tre53932'}, {'name': 'http://website.it/productiee8340'}, {'name': 'http://website.de/productooi7309'}]
>>>
>>> import pandas as pd
>>> df = pd.DataFrame(link)
>>> df['new_url'] = df.name.apply(create_url)
>>> df
name             new_url
0  http://website.com/product76tre53932  http://website.com
1      http://website.it/productiee8340   http://website.it
2      http://website.de/productooi7309   http://website.de
>>>