tools.py 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. ''' helper methods
  2. '''
  3. import pandas as pd
  4. import numpy as np
  5. import re
  6. from Timer import timer
  7. import json
  8. import os
  9. import requests
  10. from pprint import pprint
  11. class BaseMethods():
  12. ''' base methods class
  13. '''
  14. def __init__(self) -> None:
  15. pass
  16. def pandas_read_xls(self, file_path:str, sheetname:str="Sheet1"):
  17. ''' 读取xls文件方法
  18. '''
  19. return pd.read_excel(file_path,sheet_name=sheetname)
  20. def json_read(self, file_path:str):
  21. ''' 读取json文件方法
  22. '''
  23. with open(file_path, "r", encoding='utf-8') as fp:
  24. return json.load(fp)
  25. def save_file(self, save_data:list, save_path:str, file_format:str):
  26. ''' 保存文件
  27. '''
  28. print(len(save_data))
  29. if file_format == "json":
  30. with open(save_path,'w',encoding='utf-8') as sf:
  31. sf.write(json.dumps(save_data,ensure_ascii=False))
  32. elif file_format == "xlsx" or file_format == "xls":
  33. with pd.ExcelWriter(save_path) as fp:
  34. save_data.to_excel(fp, sheet_name="Sheet1")
  35. elif file_format == 'txt':
  36. with open(save_path, 'w', encoding='utf-8') as tx:
  37. for data in save_data:
  38. tx.write(data+"\n")
  39. def traverse_file(self, dirpath:str):
  40. '''
  41. 遍历文件夹下文件
  42. '''
  43. filename = tuple()
  44. for root, dir, files in os.walk(dirpath):
  45. for name in files:
  46. filename = filename.__add__((name,))
  47. return filename
  48. if __name__ == "__main__":
  49. pass