Issues converting xlsx to csv

GoogleCloudPlatform / training-data-analyst

Labs and demos for courses for GCP Training (http://cloud.google.com/training).

Apache License 2.0

7.68k stars 5.79k forks source link

Issues converting xlsx to csv #2536

Open joeymbryan opened 5 months ago

joeymbryan commented 5 months ago

There are two issues with the Vertex AI lab preventing it from being run. First is the utils/data_download.py is expecting an the .data directory to not exist, which when you clone the git repo it does exist.

Secondly, openpxyl is set on version 3.0.7 but pandas needs openpyxl==3.0.10 in order to convert the xlsx file to csv.

I got everything else to run after that.

This is for the Vertix AI qwiklab found here: https://www.cloudskillsboost.google/focuses/18938?parent=catalog

joeymbryan commented 5 months ago

I added a PR here: https://github.com/GoogleCloudPlatform/training-data-analyst/pull/2537