python将SQL查询结果转换为图片推送到企业微信

import pandas as pd
plt.rcParams['font.sans-serif'] = ['SimHei']  # 指定默认字体 'SimHei'为黑体
plt.rcParams['axes.unicode_minus'] = False  # 解决保存图像是负号'-'显示为方块的问题
import matplotlib.pyplot as plt
from pandas.plotting import table
from IPython.display import Image, display

def write_data_to_excel(df, file_path):
    """
    Write a DataFrame to an Excel file.
    """
    df.to_excel(file_path, index=False)

   
  
def save_df_as_image(df, img_path):
    """
    Save a DataFrame as an image.
    """
    fig, ax = plt.subplots(figsize=(15,4)) # set size frame表示创建一个宽12英寸、高6英寸的图形
    ax.xaxis.set_visible(False)  # hide the x axis
    ax.yaxis.set_visible(False)  # hide the y axis
    ax.set_frame_on(False)  # no visible frame
    tabla = table(ax, df, loc='center', cellLoc = 'center')  # where df is your data frame
    tabla.auto_set_font_size(False) # Activate set fontsize manually
    tabla.set_fontsize(10) # if ++fontsize is necessary ++colWidths
    tabla.scale(1.2, 1.2) # Table size 
    plt.savefig(img_path)

# 定义新的列名
new_column_names = {"pdate": "日期", "sku": "业务线", "success_membercnt": "成功消费用户数", "hb_success_membercnt": "成功消费人数环比"
                   , "success_ordercnt": "成功消费订单数", "hb_success_ordercnt": "成功消费订单环比"
                   ,"success_totalamount": "成功消费订单金额", "success_payamount": "成功消费实付金额"
                  , "cancel_membercnt": "取消用户数", "cancel_ordercnt": "取消订单数"}
#names=['pdate','sku','success_membercnt','hb_success_membercnt','success_ordercnt','hb_success_ordercnt','success_totalamount','success_payamount','cancel_membercnt','cancel_ordercnt']
df_data.rename(columns=new_column_names, inplace=True)
df =df_data

# Use the above functions
write_data_to_excel(df, "test.xlsx")
save_df_as_image(df, "table.png")

# Display the image
#display(Image(filename='table.png'))
# 发送图片
image_path = os.path.abspath('table.png')
bot.send_picture(image_path)