Once in Excel, you can't differentiate between DataFrames with and without index anymore, so using the DataFrame's column index in filters is super confusing as it could cause the same filter to manipulate a different column in Excel, depending on whether the index is shown or not.
Once in Excel, you can't differentiate between DataFrames with and without index anymore, so using the DataFrame's column index in filters is super confusing as it could cause the same filter to manipulate a different column in Excel, depending on whether the index is shown or not.