主页 / 问题 / 1363053
Accepted
Дмитрий
Asked:2022-05-17 17:24:17 +0000 UTC2022-05-17 17:24:17 +0000 UTC

使用 csv python 表格形成

  • 772

好时光！您能告诉我如何 使用 Python创建下表吗？

我看到这样的东西（表本身）：

            user_dump = {
                "Channel": title,
                "About": description,
                "Links": {
                    "link#1",
                    "link#2",
                },

                "video_links": {
                    "link#1",
                    "link#2",
                },

                "data": {
                    "data#1"
                    "data#2"
                },
                "video_description": {
                    "description#1"
                    "description#2"
                }
            }

然后很容易在每次通过通道的新通道时填充它。唯一的问题是如何编写链接列表，以便在表格中它们都在一个新行中，而不是全部在一个？

python

1 个回答

  1. Best Answer

    在我看来，这里最简单的方法是使用Pandas模块。

    首先，您需要将数据准备为列表列表以制作表格：

    data = [
  ["channel_name_1", "channel_description_1", "video1_link", "video1_date", "video1_desc"],
  ["channel_name_1", "channel_description_1", "video2_link", "video2_date", "video2_desc"],
  ["channel_name_1", "channel_description_1", "video3_link", "video3_date", "video3_desc"],
  ["channel_name_2", "channel_description_2", "video1_link", "video1_date", "video1_desc"],
  ["channel_name_2", "channel_description_2", "video2_link", "video2_date", "video2_desc"],
]

    之后，您可以创建一个 Pandas DataFrame：

    import pandas as pd

df = pd.DataFrame(data, columns=["channel","chnl_desc","video_link","video_date","video_desc"])

    结果：

    In [141]: df
Out[141]:
          channel              chnl_desc   video_link   video_date   video_desc
0  channel_name_1  channel_description_1  video1_link  video1_date  video1_desc
1  channel_name_1  channel_description_1  video2_link  video2_date  video2_desc
2  channel_name_1  channel_description_1  video3_link  video3_date  video3_desc
3  channel_name_2  channel_description_2  video1_link  video1_date  video1_desc
4  channel_name_2  channel_description_2  video2_link  video2_date  video2_desc

    然后可以将此 DataFrame 保存到 Excel 文件中：

    df.set_index(["channel","chnl_desc"]).to_excel("result.xlsx")
    • 2

相关问题