|
不过那样效率比较低,这样写更快, 大概能快10倍以上吧
import os
import pandas as pd
import openpyxl
df = pd.read_excel("tasheng.xls",encoding='gbk')
def update(row):
if row['B'].find('个人融合') > -1:
row['D'] = '个人融合'
elif row['B'].find('续包') > -1:
row['D'] = '续包'
else:
row['D'] = '1'
return row
d = df.apply(update, axis=1)
print(d) |
|