删除python Data fram列开头的特殊字符

2024-09-27 19:27:36 发布

您现在位置:Python中文网/ 问答频道 /正文

在csv文件(company)中有一个名为company\u permalink的列。在我加载到python之后,如何只打印下面列中的公司名称

/organization/-fame
/ORGANIZATION/-QOUNTER
/organization/-qounter
/ORGANIZATION/-THE-ONE-OF-THEM-INC-
/organization/0-6-com
/ORGANIZATION/004-TECHNOLOGIES
/organization/01games-technology
/ORGANIZATION/0NDINE-BIOMEDICAL-INC
/organization/0ndine-biomedical-inc
/ORGANIZATION/0XDATA
/organization/0xdata
/ORGANIZATION/0XDATA
/organization/0xdata
/ORGANIZATION/1
/organization/1
/ORGANIZATION/1
/organization/1-2-3-listo
/ORGANIZATION/1-4-ALL
/organization/1-618-technology
/ORGANIZATION/1-800-DENTIST

import re
import string
b = company['company_permalink'].apply(lambda x: x.split('/')[2])
b.map(lambda x: re.sub(r'[^a-zA-Z0-9]', '', x))

需要提取公司名称


Tags: 文件csvlambdaimportre名称公司company

热门问题