pandas dataframe dataframe.to-ag捕鱼王app官网

python pandas dataframe.to_excel(values) 函数将 dataframe 数据转储到 excel 文件中，单页或多页中。

pandas.dataframe.to_excel() 语法

dataframe.isin(
    excel_writer,
    sheet_name="sheet1",
    na_rep="",
    float_format=none,
    columns=none,
    header=true,
    index=true,
    index_label=none,
    startrow=0,
    startcol=0,
    engine=none,
    merge_cells=true,
    encoding=none,
    inf_rep="inf",
    verbose=true,
    freeze_panes=none,
)

参数

返回值

none

示例代码：pandas dataframe.to_excel()

import pandas as pd
dataframe= pd.dataframe({'attendance': [60, 100, 80, 78, 95],
                    'name': ['olivia', 'john', 'laura', 'ben', 'kevin'],
                    'marks': [90, 75, 82, 64, 45]})
dataframe.to_excel('test.xlsx')

调用者 dataframe 为

   attendance    name  marks
0          60  olivia     90
1         100    john     75
2          80   laura     82
3          78     ben     64
4          95   kevin     45

test.xlsx 文件被创建。

示例代码：pandas dataframe.to_excel() 和 excelwriter

上面的例子使用文件路径作为 excel_writer，我们也可以使用 pandas.excelwriter 来指定 dataframe 转储的 excel 文件。

import pandas as pd
dataframe = pd.dataframe(
    {
        "attendance": [60, 100, 80, 78, 95],
        "name": ["olivia", "john", "laura", "ben", "kevin"],
        "marks": [90, 75, 82, 64, 45],
    }
)
with pd.excelwriter("test.xlsx") as writer:
    dataframe.to_excel(writer)

示例代码：pandas dataframe.to_excel 来追加到一个现有的 excel 文件中

import pandas as pd
import openpyxl
dataframe = pd.dataframe(
    {
        "attendance": [60, 100, 80, 78, 95],
        "name": ["olivia", "john", "laura", "ben", "kevin"],
        "marks": [90, 75, 82, 64, 45],
    }
)
with pd.excelwriter("test.xlsx", mode="a", engine="openpyxl") as writer:
    dataframe.to_excel(writer, sheet_name="new")

我们应该指定引擎为 openpyxl，而不是默认的 xlsxwriter；否则，我们会得到 xlswriter 不支持 append 模式的错误信息。

valueerror: append mode is not supported with xlsxwriter!

因为 openpyxl 不属于 pandas 的一部分，所以要安装和导入。

pip install openpyxl

示例代码：pandas dataframe.to_excel 写入 excel 中的多页

import pandas as pd
dataframe = pd.dataframe(
    {
        "attendance": [60, 100, 80, 78, 95],
        "name": ["olivia", "john", "laura", "ben", "kevin"],
        "marks": [90, 75, 82, 64, 45],
    }
)
with pd.excelwriter("test.xlsx") as writer:
    dataframe.to_excel(writer, sheet_name="sheet1")
    dataframe.to_excel(writer, sheet_name="sheet2")

它将 dataframe 对象转储到 sheet1 和 sheet2。

如果你指定了 columns 参数，你也可以将不同的数据写入多个表。

import pandas as pd
dataframe = pd.dataframe(
    {
        "attendance": [60, 100, 80, 78, 95],
        "name": ["olivia", "john", "laura", "ben", "kevin"],
        "marks": [90, 75, 82, 64, 45],
    }
)
with pd.excelwriter("test.xlsx") as writer:
    dataframe.to_excel(writer, columns=["name", "attendance"], sheet_name="sheet1")
    dataframe.to_excel(writer, columns=["name", "marks"], sheet_name="sheet2")

示例代码： 带有参数 header 的 pandas dataframe.to_excel

import pandas as pd
dataframe = pd.dataframe(
    {
        "attendance": [60, 100, 80, 78, 95],
        "name": ["olivia", "john", "laura", "ben", "kevin"],
        "marks": [90, 75, 82, 64, 45],
    }
)
with pd.excelwriter("test.xlsx") as writer:
    dataframe.to_excel(writer, header=["student", "first name", "score"])

在创建的 excel 文件中，默认的标题与 dataframe 的列名相同。header 参数指定新的标题，以取代默认的标题。

示例代码： 当 index=false 时的 pandas dataframe.to_excel

import pandas as pd
dataframe = pd.dataframe(
    {
        "attendance": [60, 100, 80, 78, 95],
        "name": ["olivia", "john", "laura", "ben", "kevin"],
        "marks": [90, 75, 82, 64, 45],
    }
)
with pd.excelwriter("test.xlsx") as writer:
    dataframe.to_excel(writer, index=false)

index = false 指定 dataframe.to_excel() 生成一个没有头行的 excel 文件。

示例代码：pandas dataframe.to_excel 参数为 index_label

import pandas as pd
dataframe = pd.dataframe(
    {
        "attendance": [60, 100, 80, 78, 95],
        "name": ["olivia", "john", "laura", "ben", "kevin"],
        "marks": [90, 75, 82, 64, 45],
    }
)
with pd.excelwriter("test.xlsx") as writer:
    dataframe.to_excel(writer, index_label="id")

index_label='id'设置索引列的列名为 id。

示例代码：pandas dataframe.to_excel 与 float_format 参数

import pandas as pd
dataframe = pd.dataframe(
    {
        "attendance": [60, 100, 80, 78, 95],
        "name": ["olivia", "john", "laura", "ben", "kevin"],
        "marks": [90, 75, 82, 64, 45],
    }
)
with pd.excelwriter("test.xlsx") as writer:
    dataframe.to_excel(writer, float_format="%.1f")

float_format="%.1f"指定浮点数小数点后有两位。

示例代码：pandas dataframe.to_excel 参数为 freeze_panes

import pandas as pd
dataframe = pd.dataframe(
    {
        "attendance": [60, 100, 80, 78, 95],
        "name": ["olivia", "john", "laura", "ben", "kevin"],
        "marks": [90, 75, 82, 64, 45],
    }
)
with pd.excelwriter("test.xlsx") as writer:
    dataframe.to_excel(writer, freeze_panes=(1, 1))

freeze_panes=(1,1) 指定 excel 文件有冻结的顶行和冻结的第一列。