python常用工具

读取和生成json文件

from json import load,dumps


# 读取json文件
def read_json(file_path):
    file_json = None
    try:
        with open(file_path, mode='r', encoding="utf-8") as f:
            file_json = load(f)
    except Exception as e:
        print(f"read json error:{e}")
    finally:
        return file_json

# 生成json文件
def generate_json(content_dic,file_path):
    try:
        with open(file_path, "w", encoding="utf-8") as f:
            f.write(dumps(content_dic, indent=4, ensure_ascii=False))
    except Exception as e:
        print(f"generate json error:{e}")

读取和生成csv文件

import csv


def read_csv(file_path):
    try:
        with open(file_path, "rb") as f:
            # 这里reader是一个生成器
            content = csv.reader(f)
            for row in content:
                return row
    except Exception as e:
        print(f"read csv error:{e}")


def generate_csv(file_path, content: tuple):
    try:
        with open(file_path, "wb",newline='',encoding='cp936') as f:
            # 使用python的csv生成excel所兼容的csv文件，设置参数dialect="excel"
            write = csv.writer(f, dialect="excel")
            write.writerow(content)
    except Exception as e:
        print(f"generate csv error:{e}")

创建和读取exceL

import xlwt
import openpyxl as px

# 创建excel,并创建sheet
def creat_excel():
    # 新建workbook
    workbook = xlwt.Workbook()
    # 新建worksheet
    sheet = workbook.add_sheet("data")

    # 添加边框
    borders = xlwt.Borders()
    borders.left = xlwt.Borders.THIN
    borders.right = xlwt.Borders.THIN
    borders.top = xlwt.Borders.THIN
    borders.bottom = xlwt.Borders.THIN
    font = xlwt.Font()
    font.height = 20 * 11
    style = xlwt.XFStyle()
    style.borders = borders
    style.font = font
    return workbook, sheet, style

def load_excel(excel_path):
    try:
        open_excel = px.load_workbook(excel_path)
        sheet = open_excel.worksheets[0]
        return sheet
    except Exception as e:
        print(f"{excel_path}:load_excel error:{e}")

def read_excel(excel_path):
    sheet = load_excel(excel_path)
    for row in range(2, sheet.max_row + 1):
        data = sheet.cell(row, 1).value

捕获异常

    try:
        main(csv_file, input_folder, result_folder)
        print("Finished...")
    except Exception as e:
        import traceback

        print(f"程序运行失败！！！请联系数据处理中心:{e}")
        print(traceback.format_exc())
    system("pause")

不论你在什么时候开始，重要的是开始之后就不要停止。 不论你在什么时候结束，重要的是结束之后就不要悔恨。