123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 |
- ''' helper methods
- '''
- import pandas as pd
- import numpy as np
- import re
- from Timer import timer
- import json
- import os
- import requests
- from pprint import pprint
- class BaseMethods():
- ''' base methods class
- '''
- def __init__(self) -> None:
- pass
- def pandas_read_xls(self, file_path:str, sheetname:str="Sheet1"):
- ''' 读取xls文件方法
- '''
- return pd.read_excel(file_path,sheet_name=sheetname)
- def json_read(self, file_path:str):
- ''' 读取json文件方法
- '''
- with open(file_path, "r", encoding='utf-8') as fp:
- return json.load(fp)
-
- def save_file(self, save_data:list, save_path:str, file_format:str):
- ''' 保存文件
- '''
- print(len(save_data))
- if file_format == "json":
- with open(save_path,'w',encoding='utf-8') as sf:
- sf.write(json.dumps(save_data,ensure_ascii=False))
- elif file_format == "xlsx" or file_format == "xls":
- with pd.ExcelWriter(save_path) as fp:
- save_data.to_excel(fp, sheet_name="Sheet1")
- elif file_format == 'txt':
- with open(save_path, 'w', encoding='utf-8') as tx:
- for data in save_data:
- tx.write(data+"\n")
-
- def traverse_file(self, dirpath:str):
- '''
- 遍历文件夹下文件
- '''
- filename = tuple()
- for root, dir, files in os.walk(dirpath):
- for name in files:
- filename = filename.__add__((name,))
- return filename
-
- if __name__ == "__main__":
- pass
|