摘要: # coding=utf8 import pymysql import os import pandas as pd host='127.0.0.1' port=3308 user='root' password='*****' db='impairment_testing' conn=pymysq 阅读全文
posted @ 2023-11-24 15:18 汶淏 阅读(363) 评论(0) 推荐(0)
摘要: import pandas as pd file_path='C:\\Users\\user\\Desktop\\费用统计2023年1-9月\\分产品费用明细表-2023年9月-汇总-汇报20231018-数据源.xlsx' # 读取Excel文件 df = pd.read_excel(file_p 阅读全文
posted @ 2023-10-20 10:26 汶淏 阅读(53) 评论(0) 推荐(0)
摘要: #coding=utf-8 import numbers import os import openpyxl from openpyxl import load_workbook from openpyxl.styles import NumberFormatDescriptor path_sum= 阅读全文
posted @ 2023-10-12 11:09 汶淏 阅读(47) 评论(0) 推荐(0)
摘要: from openpyxl.styles import Font, PatternFill, Border, Side, Alignment, Protection from openpyxl.styles import numbers wb = Workbook() ws = wb.active 阅读全文
posted @ 2023-10-11 11:43 汶淏 阅读(25) 评论(0) 推荐(0)
摘要: 安装dash-bootstrap-components安装包代理问题: 1.windows代理设置文件user/**/pip.ini 2.代理设置命令:pip config set global.index-url https://pypi.tuna.tsinghua.edu.cn/simple 3 阅读全文
posted @ 2023-09-20 16:29 汶淏 阅读(511) 评论(0) 推荐(0)