Python：pandas读取Excel数据用plotly图表呈现

水深无声 2022-12-27 12:42 175阅读 0赞

这篇（[https://zhangphil.blog.csdn.net/article/details/111019441][https_zhangphil.blog.csdn.net_article_details_111019441]）是用matplotlib呈现了各大城市机场的客运量排名数据，本篇数据清洗部分保持基本不变，图表换成plotly实现。Python代码：

import pandas as pd
    
    import plotly.express as px
    
    KEYS = ['城市/机场', '排名', '客流量']
    FONT_SIZE = 18
    
    
    # 数据清洗
    # 数据链接 https://download.csdn.net/download/zhangphil/13624153
    def get_data():
        df = pd.read_excel(io='2019年民航机场吞吐量排名.xls',
                           nrows=20,  # 读取20行
                           skiprows=[1, 2, 3, 4],  # 跳过1,2,3,4行
                           index_col=[0, 1, 2])  # 读取0,1,2列
    
        data = []
        order = []
        for v in df.index.values:
            bundle = {}
            for i in range(len(KEYS)):
                bundle.setdefault(KEYS[i], v[i])
            order.append(v[1])
            data.append(bundle)
    
        new_df = pd.DataFrame(data, columns=KEYS, index=order)
    
        return new_df
    
    
    if __name__ == '__main__':
        df = get_data()
    
        fig = px.bar(title='2019年机场客流量城市排名TOP20',
                     data_frame=df,
                     x=KEYS[0],
                     y=KEYS[2],
                     opacity=0.8,
                     color=KEYS[2],
                     hover_data=KEYS,
                     # text=KEYS[2], #Bar上显示数字
                     )
        fig.show()

输出结果如图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncGhpbA_size_16_color_FFFFFF_t_70][]

不同于matplotlib做出的静态图片，plotly做出的图表是html网页，有交互效果，鼠标移到图表Bar上，交互如图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncGhpbA_size_16_color_FFFFFF_t_70 1][]

[https_zhangphil.blog.csdn.net_article_details_111019441]: https://zhangphil.blog.csdn.net/article/details/111019441
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncGhpbA_size_16_color_FFFFFF_t_70]: /images/20221120/5a8b97f2d4e64e1eae67ea712d7019ee.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5ncGhpbA_size_16_color_FFFFFF_t_70 1]: /images/20221120/984f304fac0849ba99d97ccc33b9edc8.png