You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
DataFrame index treated inconsistently by array_preview #39
When output as is specified to Excel values, a DataFrame will only output the index if the values of the index column are not numeric (in the case of describe(), or group_by()) OR if the index name has been set.
Thanks! I'd still love to be able to decide myself whether the index is shown or not. If I give my index a name in sheet1.A1, which will have a side effect on what I do in sheet10.Z50, that could be very confusing. I'd argue that the conversion from Python object to values would be much cleaner via Data Type properties (such as A1.arrayPreview that exists today), so you could choose A1.valuesWithIndex or A1.values (which would default to no index).
Adding a comment here. This is expected. If index is explicitly set by users (in this case index = [0,1,2]), we show the index on the UI. By default, pandas dataframe creates auto generated range index if index is not explicitly set by users. We suppress those auto generated index, which explains why you don't see index generated for df1.
Activity
keyur32 commentedon Oct 13, 2023
Sorry for the delay. Yes, this is intentional.
When output as is specified to Excel values, a DataFrame will only output the index if the values of the index column are not numeric (in the case of describe(), or group_by()) OR if the index name has been set.
Will add this to our dataframes documentation.
Was there something else you were expecting?
fzumstein commentedon Oct 16, 2023
Hm, according to your rules, df2 should not show the index (numeric index without an index name), but it does.
keyur32 commentedon Oct 17, 2023
Thanks Felix! Good point. Follow up with the team, to understand what is going on there.
fzumstein commentedon Oct 17, 2023
Thanks! I'd still love to be able to decide myself whether the index is shown or not. If I give my index a name in sheet1.A1, which will have a side effect on what I do in sheet10.Z50, that could be very confusing. I'd argue that the conversion from Python object to values would be much cleaner via Data Type properties (such as
A1.arrayPreviewthat exists today), so you could chooseA1.valuesWithIndexorA1.values(which would default to no index).KimJun9011 commentedon Oct 18, 2023
Adding a comment here. This is expected. If index is explicitly set by users (in this case index = [0,1,2]), we show the index on the UI. By default, pandas dataframe creates auto generated range index if index is not explicitly set by users. We suppress those auto generated index, which explains why you don't see index generated for df1.