如何将表格和Python代码打包成可独立运行的exe文件

Question

-- coding=gbk --

import pandas as pd
from pyecharts import options as opts
from pyecharts.charts import Map
from pyecharts.charts import Timeline

datafile = u'E:\毕设\新建文件夹\PythonApplication1\全国人口数据.xlsx'
data = pd.read_excel(datafile)
def a():
name = data['省份'].tolist()[1:]
value1 = data['1953年第一次人口普查'].tolist()[1:]
value2 = data['1964年第二次人口普查'].tolist()[1:]
value3 = data['1982年第三次人口普查'].tolist()[1:]
value4 = data['1990年第四次人口普查'].tolist()[1:]
value5 = data['2000年第五次人口普查'].tolist()[1:]
value6 = data['2010年第六次人口普查'].tolist()[1:]
value7 = data['2020年第七次人口普查'].tolist()[1:]
provinces = [i.replace("\u3000","") for i in name]
print(provinces)

t = Timeline()
c1 = (
    Map()
        .add("", [list(z) for z in zip(provinces, value1)], "china")
        .set_global_opts(
        title_opts=opts.TitleOpts(title="第一次人口普查不同省份总人口",subtitle="数据来自国家统计网"),
        visualmap_opts=opts.VisualMapOpts(max_=130000000, split_number=10, is_piecewise=True),
        toolbox_opts=opts.ToolboxOpts(is_show=True,
                                      pos_top="top",
                                      pos_left="right",
                                      feature={"saveAsimage":{} ,
                                          "dataZoom":{"yAxisIndex":"none"},
                                          "restore":{},
                                          "magicType":{"show":True, "type":["line","bar"]},
                                          "dataView":[]})
    )
)
t.add(c1, "第一次人口普查不同省份总人口")

c2 = (
    Map()
        .add("", [list(z) for z in zip(provinces, value2)], "china")
        .set_global_opts(
        title_opts=opts.TitleOpts(title="第二次人口普查不同省份总人口",subtitle="数据来自国家统计网"),
        visualmap_opts=opts.VisualMapOpts(max_=130000000, split_number=10, is_piecewise=True),
        toolbox_opts=opts.ToolboxOpts(is_show=True,
                                      pos_top="top",
                                      pos_left="right",
                                      feature={"saveAsimage":{} ,
                                          "dataZoom":{"yAxisIndex":"none"},
                                          "restore":{},
                                          "magicType":{"show":True, "type":["line","bar"]},
                                          "dataView":[]})
    )
)
t.add(c2, "第二次人口普查不同省份总人口")

c3 = (
    Map()
        .add("", [list(z) for z in zip(provinces, value3)], "china")
        .set_global_opts(
        title_opts=opts.TitleOpts(title="第三次人口普查不同省份总人口",subtitle="数据来自国家统计网"),
        visualmap_opts=opts.VisualMapOpts(max_=130000000, split_number=10, is_piecewise=True),
        toolbox_opts=opts.ToolboxOpts(is_show=True,
                                      pos_top="top",
                                      pos_left="right",
                                      feature={"saveAsimage":{} ,
                                          "dataZoom":{"yAxisIndex":"none"},
                                          "restore":{},
                                          "magicType":{"show":True, "type":["line","bar"]},
                                          "dataView":[]})
    )
)
t.add(c3, "第三次人口普查不同省份总人口")

c4 = (
    Map()
        .add("", [list(z) for z in zip(provinces, value4)], "china")
        .set_global_opts(
        title_opts=opts.TitleOpts(title="第四次人口普查不同省份总人口",subtitle="数据来自国家统计网"),
        visualmap_opts=opts.VisualMapOpts(max_=130000000, split_number=10, is_piecewise=True),
        toolbox_opts=opts.ToolboxOpts(is_show=True,
                                      pos_top="top",
                                      pos_left="right",
                                      feature={"saveAsimage":{} ,
                                          "dataZoom":{"yAxisIndex":"none"},
                                          "restore":{},
                                          "magicType":{"show":True, "type":["line","bar"]},
                                          "dataView":[]})
    )
)
t.add(c4, "第四次人口普查不同省份总人口")

c5 = (
    Map()
        .add("", [list(z) for z in zip(provinces, value5)], "china")
        .set_global_opts(
        title_opts=opts.TitleOpts(title="第五次人口普查不同省份总人口",subtitle="数据来自国家统计网"),
        visualmap_opts=opts.VisualMapOpts(max_=130000000, split_number=10, is_piecewise=True),
        toolbox_opts=opts.ToolboxOpts(is_show=True,
                                      pos_top="top",
                                      pos_left="right",
                                      feature={"saveAsimage":{} ,
                                          "dataZoom":{"yAxisIndex":"none"},
                                          "

需要的数据在Excel表格中，但是不会打包，求解救，图中代码是部分

Answer 1

参考这个吧 https://blog.csdn.net/qq_46095164/article/details/121645608?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522165337865616781435479653%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=165337865616781435479653&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~baidu_landing_v2~default-3-121645608-null-null.142^v10^control,157^v8^control&utm_term=pyinstaller%E6%89%93%E5%8C%85%E6%96%87%E4%BB%B6%E5%A4%B9exe&spm=1018.2226.3001.4449