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()