知識付費(fèi)時(shí)代膀跌，經(jīng)常接觸到別人做得漂漂亮亮的數(shù)據(jù)動(dòng)圖象泵，再配上抑揚(yáng)頓挫的音樂，簡直不要太高大上宙帝，自己學(xué)著做了下确沸，原來這個(gè)動(dòng)圖做起來也沒那么神秘

以下是動(dòng)圖的效果：

data_gif.gif

import xlrd
import matplotlib.pyplot as plt
import imageio
import numpy as np


def data_gif(cols, xlim_num, xlim_interval, duration,
             title_attach=''):  # cols 展示前幾列的數(shù)據(jù)捌锭，xlim_num x軸刻度值，duration 兩張圖片間的間隔罗捎，建議寫0.2-0.5,title_attach 標(biāo)題后附加部分观谦，可不寫

    frames = []
    xlsx = xlrd.open_workbook('廣州網(wǎng)簽動(dòng)圖-200329.xlsx')
    sheet = xlsx.sheet_by_index(0)
    name_list = []
    for j in range(1, sheet.ncols):
        name_list.append(sheet.cell_value(0, j))

    for i in range(1, sheet.nrows):
        row_data_list = []
        for j in range(1, sheet.ncols):
            title = xlrd.xldate.xldate_as_datetime(sheet.cell(i, 0).value, 0).strftime('%Y-%m-%d')
            row_data = sheet.cell_value(i, j)
            row_data_list.append(int(row_data))

        dic = dict(zip(name_list, row_data_list))

        xy_sort = sorted(dic.items(), key=lambda d:d[1], reverse = False)

        X_list = []
        Y_list = []
        for a in range(0, len(xy_sort)):
            X_list.append(xy_sort[a][0])
            Y_list.append(xy_sort[a][1])

        font = {'family': 'SimHei',
                'style': 'normal',
                'weight': 'normal',
                'color': '#FFFFFF',
                'size': 20,

                }
        plt.rcParams['figure.figsize'] = (16.0, 9.0)

        plt.rcParams['axes.facecolor'] = '#0D0434'
        plt.rcParams['savefig.facecolor'] = '#0D0434'
        plt.rcParams['xtick.color'] = '#FFFFFF'
        plt.rcParams['ytick.color'] = '#FFFFFF'
        plt.rcParams['axes.edgecolor'] = '#FFFFFF'
        plt.rcParams['font.sans-serif'] = ['SimHei']  # 用來正常顯示中文標(biāo)簽
        plt.rcParams['axes.unicode_minus'] = False  # 用來正常顯示負(fù)號
        plt.tick_params(labelsize=20)
        plt.xlim((0, int(xlim_num)))
        plt.xticks(range(0, xlim_num, xlim_interval))
        # fig = plt.figure()
        # ax = fig.add_subplot(111)
        # ax.xaxis.label.set_color('red')
        # ax.tick_params(axis='x', colors='red')
        # ax.yaxis.label.set_color('red')
        # ax.tick_params(axis='y', colors='red')

        m = 0

        for n in Y_list:
            plt.text(int(xlim_num) / 10, m, str(n), ha='left', va='center', fontdict=font)
            m += 1
        plt.barh(X_list, Y_list, height=0.35, facecolor='#2C43C2', edgecolor='white')
        plt.title(str(title) + str(title_attach), fontdict=font)
        plt.savefig('%s.png' % str(title))
        plt.close('all')

        im = imageio.imread('%s.png' % str(title))
        frames.append(im)
    imageio.mimsave('data_gif.gif', frames, 'GIF', duration=round(duration, 2))


data_gif(11, 130, 10, 0.5, '廣州新房網(wǎng)簽')