12345678910111213141516171819 |
- import pandas as pd
- import csv
- f = open("xhs_content_rules.csv", "w")
- fr = open("xhs_title_rules.csv", "w")
- writer = csv.writer(f)
- writer2= csv.writer(fr)
- data = pd.read_csv("新华三关键词.csv", keep_default_na=False)
- titles = data.values.tolist()
- writer.writerow(["关键词", "数据量", "附加词", "排除词", "范围", "分类"])
- writer2.writerow(["关键词", "数据量", "附加词", "排除词", "范围", "分类"])
- for title in titles:
- if title[1]=="全文匹配":
- writer.writerow([title[0], "", title[2], title[3], title[1], title[4]])
- writer.writerow([title[0], "", title[2], title[3], "标题匹配", title[4]])
- else:
- writer2.writerow([title[0], "", title[2], title[3], title[1], title[4]])
- f.close()
- fr.close()
|