大蟒蛇python教程共享python绘制直方图的方法

#coding=gbk    import xlwings as xw  import pandas  as pd  import matplotlib.pyplot as plt    #pd.set_option('display.max_columns', none)  #解决表格多列时中间省略显示问题  #pd.set_option('display.max_rows', none)    #解决表格多行时中间省略显示问题    #读取excel文件中的数据  app = xw.app(visible = false, add_book = false)  workbook = app.books.open("score1000.xlsx")  worksheet = workbook.sheets[0]  #使用sheets()方法获取所有sheet页，加个序号获取某个sheet页  values = worksheet.range("a1").expand().options(pd.dataframe, index = false).value  print(values)  workbook.close()  app.quit()    #绘制直方图  figure = plt.figure()  #plt.rcparams['font.sans-serif'] = ['simhei']  #解决图表中中文显示问题  #plt.rcparams['axes.unicode_minus'] = false   #解决图表中负号显示问题    x = values['total_score']  #指定x轴  y = values['interface_delta_b']  #指定y轴  plt.bar(x, y, color = 'blue')    #设置图表参数  plt.xlabel('total_score', fontsize = 15, color = 'black')   #设置x轴标签  plt.ylabel('interface_delta_b', fontsize = 15, color = 'green')   #设置y轴标签  #plt.title('score', fontsize = 20)  #设置标题  #plt.axis([-1, 6, -2, 2])   #可手动设置x轴y轴范围  #plt.grid(true)   #设置网格    plt.show()

# coding=gbk  import pandas as pd  import matplotlib.pyplot as plt  from pyecharts import options as opts  from pyecharts.charts import bar  import numpy as np    df = pd.read_excel("score1000.xlsx",engine='openpyxl')  #print(df["total_score"])    #使用matplotlib画图  # plt.figure()  # plt.hist(df["interface_delta_b"])  # plt.show()      hist,bin_edges = np.histogram(df["interface_delta_b"],bins=100)  # # print(bin_edges)  # # print(len(bin_edges))  # # print(len(hist))    bar=(      bar()      .add_xaxis([str(x) for x in bin_edges[:-1]])      .add_yaxis("",[float(x) for x in hist],category_gap=0)      .set_global_opts(          title_opts=opts.titleopts(title="interface_delta_b",pos_left="center"),          legend_opts=opts.legendopts(is_show=false)      )  )  bar.render("f:total_score.html")