excel TypeError：必须传递类似列表的“名称”

eufgjt7s 于 2023-02-10 发布在其他

关注(0)|答案(1)|浏览(120)

我尝试用Pandas重命名excel文件中的列，但是我在标题中得到错误。错误来自第18行或#重命名列部分。有什么想法吗？谢谢！

import pandas as pd

# Load the excel file into a dataframe
df = pd.read_excel("Marginal CPA data - NOV.xlsx")

# Delete the bottom row
df = df[:-1]

# Filter the column labeled "Campaign Type (Search ACQ) - ONC" to keep only rows with value "NonBrand"
df = df[df["Campaign Type (Search ACQ) - ONC"] == "NonBrand"]

# Make a pivot table
pivot_table = pd.pivot_table(df, values=["Media Cost", "CAFE Approvals"], 
                              index=["Campaign Type (Search ACQ) - ONC", "Product (ACQ Search) - ONC", "Day"], 
                              columns=["CDJ"], aggfunc="sum")

# Remove subtotals and repeat all item labels
pivot_table = pivot_table.rename_axis(None, axis=1)
pivot_table = pivot_table.rename_axis(None, axis=0)

# Copy and paste as values the pivot table into a new tab
df_pivot = pivot_table.copy()

# Rename columns
df_pivot = df_pivot.rename(columns={("Media Cost", "CPA"): "CPA Spend", ("Media Cost", "Non CPA"): "CDJ Spend"})
df_pivot = df_pivot.rename(columns={("CAFE Approvals", "CPA"): "CPA Approvals", ("CAFE Approvals", "Non CPA"): "CDJ Approvals"})

excel

来源：https://stackoverflow.com/questions/75392413/typeerror-must-pass-list-like-as-names

1条答案

按热度按时间

anauzrmj1#

没有样本数据会使它很难解决，但我相信您的代码应该是：

import pandas as pd

df = pd.read_excel("Marginal CPA data - NOV.xlsx")

df = df[:-1]

df = df[df["Campaign Type (Search ACQ) - ONC"] == "NonBrand"]

pivot_table = pd.pivot_table(df, values=["Media Cost", "CAFE Approvals"], 
                              index=["Campaign Type (Search ACQ) - ONC", "Product (ACQ Search) - ONC", "Day"], 
                              columns=["CDJ"], aggfunc="sum")

pivot_table = pivot_table.rename_axis(None, axis=1)
pivot_table = pivot_table.rename_axis(None, axis=0)

df_pivot = pivot_table.copy()

# Reset the column index to a single level
df_pivot.columns = ["_".join(col) for col in df_pivot.columns]

# Rename columns
df_pivot = df_pivot.rename(columns={"Media Cost_CPA": "CPA Spend", "Media Cost_Non CPA": "CDJ Spend",
                                     "CAFE Approvals_CPA": "CPA Approvals", "CAFE Approvals_Non CPA": "CDJ Approvals"})

赞(0）回复(0）举报 2023-02-10

我来回答

excel TypeError：必须传递类似列表的“名称”

1条答案

相关问题

热门标签

最新问答