BUG: writing dataframe to excel if one of the rows has name "render" fails · Issue #34331 · pandas-dev/pandas (original) (raw)

I try to write an dataframe to excel with excel. It fails if a row is called "render".

Pandas version 1.0.3

Reproduce with:
s1 = pandas.Series(("1","2"),index=["a","b"])
s2 = pandas.Series(("3","4"),index=["b","b"])

df = pandas.DataFrame({"render":s1,"huhu":s2})
df.to_excel("/tmp/out.xlsx")

gives:

AttributeError Traceback (most recent call last)
in
----> 1 df.to_excel("/tmp/out.xlsx")

/usr/local/anaconda3/envs/exoplanets/lib/python3.7/site-packages/pandas/core/generic.py in to_excel(self, excel_writer, sheet_name, na_rep, float_format, columns, header, index, index_label, startrow, startcol, engine, merge_cells, encoding, inf_rep, verbose, freeze_panes)
2171 index_label=index_label,
2172 merge_cells=merge_cells,
-> 2173 inf_rep=inf_rep,
2174 )
2175 formatter.write(

/usr/local/anaconda3/envs/exoplanets/lib/python3.7/site-packages/pandas/io/formats/excel.py in init(self, df, na_rep, float_format, cols, header, index, index_label, merge_cells, inf_rep, style_converter)
384 if hasattr(df, "render"):
385 self.styler = df
--> 386 df = df.data
387 if style_converter is None:
388 style_converter = CSSToExcelConverter()

/usr/local/anaconda3/envs/exoplanets/lib/python3.7/site-packages/pandas/core/generic.py in getattr(self, name)
5272 if self._info_axis._can_hold_identifiers_and_holds_name(name):
5273 return self[name]
-> 5274 return object.getattribute(self, name)
5275
5276 def setattr(self, name: str, value) -> None:

AttributeError: 'DataFrame' object has no attribute 'data'