extract_to_csv.py 855 B

123456789101112131415161718192021222324252627282930313233343536
  1. # This Python file uses the following encoding: utf-8
  2. # @author runhey
  3. # github https://github.com/runhey
  4. import re
  5. import csv
  6. import pandas as pd
  7. def parse_one(value: str) -> tuple:
  8. if not value:
  9. print(f'value is None {value}')
  10. return None
  11. result = re.search(r"(.*)?——(.*)", value)
  12. if result:
  13. return result[1], result[2]
  14. else:
  15. print(f'parse error {value}')
  16. return None, None
  17. if __name__ == "__main__":
  18. file = 'data.xlsx'
  19. df_read = pd.read_excel(file, usecols='A')
  20. df_wirte = pd.DataFrame(columns=['question', 'answer'])
  21. print(df_read.columns)
  22. for index, row in df_read.iterrows():
  23. question, answer = parse_one(row['question answering'])
  24. df_wirte.loc[index] = [question, answer]
  25. df_wirte.to_csv('data.csv', index=False, encoding='utf-8-sig')