Training pipeline failed with error message: Invalid column names:

[Steve Walker]

Is there a way to find out more detailed information on this error?  I'm using the TF titanic dataset, nothing fancy.  

https://pantheon.corp.google.com/ai/platform/locations/us-central1/training/6235743857489739776?project=steveswalker

https://screenshot.googleplex.com/AxaSKvSFJAQsPqK

[Chenyu Zhao]

I suspect you're using CSV and there's an erroneous comma somewhere causing there to be an extra column with the name "" (i.e. empty string)

Can you double-check? If you attach the CSV file, we can help take a look too.

--
You received this message because you are subscribed to the Google Groups "cloud-automl-tables-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cloud-automl-tables...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/cloud-automl-tables-discuss/98b4b686-6fda-4918-9021-e019cf9438e4n%40googlegroups.com.

[Chenyu Zhao]

*an erroneous comma in the header line

[Pratap Ramamurthy]

I am hitting the same error. Apparently VertexAI python SDK throws this error when column names have spaces. like "Column 1" etc.

I was able to get past this error when I renamed my columns names in the CSV file.

thanks

Pratap

[Ivan Cheung]

Thanks for bringing this to our attention.

Can you provide a truncated CSV (1 to 3 lines) and a code example for us to test?

Thanks!

Ivan Cheung CloudAI Developer Programs Engineer iva...@google.com

To view this discussion on the web visit https://groups.google.com/d/msgid/cloud-automl-tables-discuss/1b38e650-1f11-44b8-bfe1-998f77157915n%40googlegroups.com.

[Pratap Ramamurthy]

I am using this notebook (from official repository).

https://github.com/GoogleCloudPlatform/vertex-ai-samples/blob/main/notebooks/official/automl/automl-tabular-classification.ipynb

The is the easiest way to recreate this error is to that that dataset csv file, just change one of the column names to contain a space, you will hit the error.

Make sure you also change it in this call: "aiplatform.AutoMLTabularTrainingJob()

thanks

Pratap

--

Pratap Ramamurthy AI/ML Specialist Customer Engineer prat...@google.com | (647) 244-8430

[Ivan Cheung]

Tracked in https://b.corp.google.com/issues/219781405

Ivan Cheung CloudAI Developer Programs Engineer iva...@google.com

[sokipriala jonah]

Thanks, Guys. The suggestions worked for me; spaces on my table header caused the error

[Michel Siqueira Reis]

I solved preparing a DataFrame and using the pandas function:
df.to_csv("data.csv", index=False). This output the format that AutoML reads.

[Manish Kumar]

Even when my column names were having "_" in it I get this error message.

[Michael Hu]

Hi Manish,

Any column names that align with https://cloud.google.com/bigquery/docs/schemas#column_names should be allowed by AutoML. If you want, you can share your project number and training pipeline id with cloud-automl-t...@google.com and we can take a look.

Thanks,

Michael