python pptx 以及matplotlib使用

import numpy as np import pandas as pd import time import seaborn as sns import matplotlib.pyplot as plt import matplotlib as mpl from matplotlib.pyplot import MultipleLocator plt.rcParams[font.sans-serif] = [SimHei] # 中文字体设置-黑体 plt.rcParams[axes.unicode_minus] = False # 解决保存图像是负号-显示为方块的问题 sns.set(font=SimHei) # 解决Seaborn中文显示问题

#柱高信息 Y = y.tolist() Y1 = y1.tolist() X = np.arange(len(x.tolist())) bar_width = 0.25 tick_label = x.tolist()# [A,B,C,D,E] #显示每个柱的具体高度 for x,y in zip(X,Y): plt.text(x+0.005,y+0.005,%.0f %y, ha=center,va=bottom) for x,y1 in zip(X,Y1): plt.text(x+0.24,y1+0.005,%.0f %y1, ha=center,va=bottom) #绘制柱状图 plt.bar(X, Y, bar_width, align=”center”, color=”#2e75b6″, label=”label_name”, alpha=0.5) plt.bar -&nbsp(X+bar_width, Y1, bar_width, color=”#c00000″, align=”center”, \ label=”label_name”, alpha=0.5) frame = plt.gca() # y 轴不可见 frame.axes.get_yaxis().set_visible(False) # x 轴不可见 # frame.axes.get_xaxis().set_visible(False) plt.xlabel(“xlabel_name”) plt.ylabel(“ylabel_name”) # plt.title(Picture Name) plt.xticks(X+bar_width/2, tick_label) #显示图例 plt.legend() #plt.show() plt.savefig(iamge.png,dpi = 400)

#绘制基础图层 x=df.iloc[:-1,0].values.tolist()# x轴/横轴 y1=df.iloc[:-1,1].values.tolist()# y轴/纵轴 mycolors = [tab:red, tab:blue, tab:green, tab:orange, tab:brown, tab:grey, tab:pink, tab:olive] columns = [column1, column2] # 组合图：第一个图，进店 面积图 fig, ax1 = plt.subplots(figsize=(10,6)) frame = plt.gca() # x 轴不可见 frame.axes.get_xaxis().set_visible(False) # fig.set_facecolor(w) ax1.set_title(title, fontsize=16) ax1.set_xlabel(xlabel, fontsize=16) ax1.set_ylabel(columns[1], fontsize=16, color=mycolors[2]) # ax1 = sns.barplot(x=column1, y=column2, data = df.iloc[:-1,:], palette=summer)# 条形图 ax1.fill_between(x, y1=y1, y2=0, label=columns[1], alpha=0.5, color=mycolors[2], linewidth=2)# 面积图 # 组合图：第二个图，途径， # ax1.tick_params(axis=y) #twinx共享x轴(类似的语法，如共享y轴twiny) ax2 = ax1.twinx() #第二个图，折线图 ax2.set_ylabel(ylabel, fontsize=16, color=mycolors[1]) ax2 = sns.lineplot(x=column1, y=column2, data = df.iloc[:-1,:], sort=False, color=mycolors[1]) ax2.tick_params(axis=y, color=mycolors[1]) #显示绘制结果 # plt.show() plt.savefig(image.png,dpi = 400)

#绘制基础图层 y=df.iloc[:-1,1] y2=df.iloc[:-1,2] x=df.iloc[:-1,0] fig, ax1 = plt.subplots(figsize=(10,6)) color = tab:green ax1.set_title(title, fontsize=16) ax1.set_xlabel(xlabel, fontsize=16) ax1.set_ylabel(ylabel, fontsize=16, color=color) #第一图条形图 ax1 = sns.lineplot(x=column1, y=column2, data = df.iloc[:-1,:], sort=False, color=color) ax1.tick_params(axis=y) # 设置数字标签 for a, b in zip(x, y): plt.text(a, b, b, ha=center, va=bottom, fontsize=10) #twinx共享x轴(类似的语法，如共享y轴twiny) ax2 = ax1.twinx() color = tab:red #第二个图，折线图 ax2.set_ylabel(ylabel, fontsize=16, color=color) ax2 = sns.lineplot(x=column1, y=column2, data = df.iloc[:-1,:], sort=False, color=color) ax2.tick_params(axis=y, color=color) # 设置数字标签 for a, b in zip(x, y2): plt.text(a, b, b, ha=center, va=bottom, fontsize=10) #显示绘制结果 # plt.show() plt.savefig(image.png,dpi = 400)

plt.figure(figsize=(10,10)) #新建画布，画布大小为8*8 plt.pie(df.iloc[:,3] ,radius=1 # 设置半径为1 ,labels=df.iloc[:,0].values.tolist() #设置各个角的标签 ,autopct=%.2f%% #设置精度为小数点后两位 ,textprops={fontsize: 35, color: k} #设置标签字体和颜色 ,wedgeprops=dict(width=0.4, edgecolor=w)); #设置饼弧宽度和边框颜色 plt.savefig(image.png,dpi = 400)

# Import Data df = pd.read_csv(“https://github.com/selva86/datasets/raw/master/economics.csv”) # Prepare Data x = df[date].values.tolist() y1 = df[psavert].values.tolist() y2 = df[uempmed].values.tolist() mycolors = [tab:red, tab:blue, tab:green, tab:orange, tab:brown, tab:grey, tab:pink, tab:olive] columns = [psavert, uempmed] # Draw Plot fig, ax = plt.subplots(1, 1, figsize=(16,9), dpi= 80) ax.fill_between(x, y1=y1, y2=0, label=columns[1], alpha=0.5, color=mycolors[1], linewidth=2) ax.fill_between(x, y1=y2, y2=0, label=columns[0], alpha=0.5, color=mycolors[0], linewidth=2) # Decorations ax.set_title(Personal Savings Rate vs Median Duration of Unemployment, fontsize=18) ax.set(ylim=[0, 30]) ax.legend(loc=best, fontsize=12) plt.xticks(x[::50], fontsize=10, horizontalalignment=center) plt.yticks(np.arange(2.5, 30.0, 2.5), fontsize=10) plt.xlim(-10, x[-1]) # Draw Tick lines for y in np.arange(2.5, 30.0, 2.5): plt.hlines(y, xmin=0, xmax=len(x), colors=black, alpha=0.3, linestyles=”–“, lw=0.5) # Lighten borders plt.gca().spines[“top”].set_alpha(0) plt.gca().spines[“bottom”].set_alpha(.3) plt.gca().spines[“right”].set_alpha(0) plt.gca().spines[“left”].set_alpha(.3) plt.show()

from pptx import Presentation from pptx.chart.data import ChartData,XyChartData,BubbleChartData,CategoryChartData from pptx.enum.chart import XL_CHART_TYPE,XL_LABEL_POSITION,XL_LEGEND_POSITION from pptx.util import Inches from pptx.enum.text import MSO_ANCHOR, MSO_AUTO_SIZE,MSO_VERTICAL_ANCHOR,PP_PARAGRAPH_ALIGNMENT,PP_ALIGN from pptx.dml.color import RGBColor from pptx.enum.dml import MSO_THEME_COLOR from pptx.enum.shapes import MSO_SHAPE_TYPE,MSO_SHAPE from pptx.util import Pt,Cm

prs = Presentation(模板.pptx)

shape=prs.slides[0].shapes for i in range(0,len(shape)): if(shape[i].has_text_frame): for paragraph in shape[i].text_frame.paragraphs: for run in paragraph.runs: if 品牌 in run.text: run.text=brand_name

slide2=prs.slides[2] # 设置待添加的图片 img_path = ./3.png left1, top1, width1, height1 = Cm(0), Cm(0), Cm(19), Cm(19) slide2.shapes.add_picture(image_file=img_path,left=left1,top=top1,width=width1,height=height1)

left, top, width, height = Cm(6), Cm(17), Cm(12), Cm(1.2) tf = slide7.shapes.add_textbox(left=left, top=top, width=width, height=height).text_frame tf.paragraphs[0].text = remarks tf.paragraphs[0].font.size = Pt(10)

rows, cols = 2,len(sheet_各店月客流_df.iloc[2:-1,1].values.tolist())# 根据数据行数创建表格列数 left, top, width, height = Cm(0.5), Cm(3), Cm(33), Cm(2) table=shapes.add_table(rows,cols,left,top,width,height).table data = [ x,x ] for row in range(rows): for col in range(cols): table.cell(row,col).text = str(data[row][col]) def iter_cells(table): for row in table.rows: for cell in row.cells: cell.fill.solid() cell.fill.fore_color.rgb = RGBColor(163, 163, 163) yield cell for cell in iter_cells(table): for paragraph in cell.text_frame.paragraphs: for run in paragraph.runs: run.font.size = Pt(16)

left, top, width, height = Cm(0.5), Cm(3.7), Cm(16), Cm(2.5) s1=serie.values.tolist() s2=serie.values.tolist() shapes=slide.shapes rows, cols = 2,len(s1)# 行；列 table=shapes.add_table(rows,cols,left,top,width,height).table data = [ s1,s2 ] for row in range(rows): for col in range(cols): table.cell(row,col).text = str(data[row][col]) def iter_cells(table): for row in table.rows: for cell in row.cells: cell.fill.solid()# 首行加粗 cell.fill.fore_color.rgb = RGBColor(242, 242, 242)# 表格背景颜色 yield cell for cell in iter_cells(table): for paragraph in cell.text_frame.paragraphs: for run in paragraph.runs: run.font.size = Pt(14) # 字体大小 run.font.color.rgb = RGBColor(0, 0, 0) # 字体颜色

data=df.iloc[0,:-2].values.tolist() shape=slide.shapes left, top, width, height = Cm(6), Cm(6), Cm(6), Cm(6.5) rows, cols = 7,1 table=shape.add_table(rows,cols,left,top,width,height).table # 调整行高 for i in range(rows): table.rows[i].height = Cm(0.95) def set_cell_center(cell): “”” 设置单元格文字居中显示 :param cell: :return: “”” paragraph = cell.text_frame.paragraphs[0] paragraph.alignment = PP_ALIGN.CENTER cell.vertical_anchor = MSO_ANCHOR.MIDDLE for row in range(rows): for col in range(cols): table.cell(row,col).text = str(data[row]) set_cell_center(table.cell(row,col)) def iter_cells(table): for row in table.rows: for cell in row.cells: cell.fill.solid() cell.fill.fore_color.rgb = RGBColor(255, 255, 255) yield cell for cell in iter_cells(table): for paragraph in cell.text_frame.paragraphs: for run in paragraph.runs: run.font.size = Pt(12) run.font.color.rgb = RGBColor(0, 0, 0) run.alignment = PP_ALIGN.CENTER

cols = 2 rows=math.ceil(len(df)/2)# 向上取整 left, top, width, height = Cm(6.5), Cm(14.5), Cm(6), Cm(3) table=shape.add_table(rows,cols,left,top,width,height).table # 调整行高 for i in range(rows): table.rows[i].height = Cm(0.95) def set_cell_center(cell): “”” 设置单元格文字居中显示 :param cell: :return: “”” paragraph = cell.text_frame.paragraphs[0] paragraph.alignment = PP_ALIGN.CENTER cell.vertical_anchor = MSO_ANCHOR.MIDDLE for row in range(2): for col in range(rows): table4.cell(col,row).text = str(data[row][col]) set_cell_center(table.cell(col,row)) def iter_cells(table): for row in table.rows: for cell in row.cells: cell.fill.solid() cell.fill.fore_color.rgb = RGBColor(255, 255, 255) yield cell for cell in iter_cells(table): for paragraph in cell.text_frame.paragraphs: for run in paragraph.runs: run.font.size = Pt(12) run.font.color.rgb = RGBColor(0, 0, 0) run.alignment = PP_ALIGN.CENTER