create_kewords.py 767 B

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