Azure / Azure/MachineLearningNotebooks

AzureML TabularDataSet via parquet and pandas index error

Open
#1,299 5 comments 4 reactions 1 assignee Claimed by @MayMSFT View on GitHub
ADO Data4ML product-issue
Dominant language
Jupyter Notebook
Stars
4.4k
Forks
2.6k
PR merge metrics
No merged PRs in 30d

Description

Azure's TabularDataset implementation introduces an index, \_\_index\_level_0\_\_ when creating or reading parquet files that were originally written by Pandas/Python. This occurs when an index is unnamed but has been modified at some point; if an index is named we get an extra column with the same name as the index.

When making changes to datasets, this additional field causes Azure errors if not handled. Depending on what's been done to the index of the original dataset, you may or may not get that additional field.

I have an example notebook that can be run to reproduce the issue. It's here: https://github.com/vla6/Azure_notes/blob/main/tabulardataset_parquet_index_di_issue.ipynb

The notebook requires an Azure Machine Learning workspace and a storage account to run

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.