博文
python学习——根据条件提取数据，并去重
|||
[Python字符串提取]
摘要：根据要求进行字符串的提取，并去重
导入分析所需的库
import pandas as pd
构造数据集
as1 = pd.DataFrame({'a':[1,2,3,4],
'b':['adwdea,asdw;swa,des','swa,dwad;asdw;swa','se;dw,asd;erf,de','de']})
编写分析函数
def trans(b):
as1['c'] = b.str.split(";")
c = as1['c'].tolist()
for i in range(len(c)):
for j in range(len(c[i])):
c[i][j] = c[i][j].split(",")[0]
return c
trans(as1['b'])
as1['d'] = as1['c'].apply(lambda x:set(x)).apply(lambda x:",".join(x))
as1
https://blog.sciencenet.cn/blog-3262505-1137397.html
下一篇：python学习——数据批量替换
