Azure-Samples / cdm-azure-data-services-integration

Tutorials and sample code for integrating CDM folders with Azure Data Services
MIT License
70 stars 46 forks source link

cdm-customer-classification-demo doesn't work #12

Open chucksalvo opened 5 years ago

chucksalvo commented 5 years ago

Please provide us with the following information:

This issue is for a: (mark with an x)

- [ x] bug report -> please search issues before submitting
- [ ] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Minimal steps to reproduce

run the cdm-customer-classification-demo.ipyyb notebook

also there are incorrect references in the notebook in regards to you have sales_invoice_line_df = read_from_adls_with_cdm_format(model.entities["Sales InvoiceLines"], "cdm") sales_invoice_df = read_from_adls_with_cdm_format(model.entities["Sales Invoices"], "cdm") when it should read sales_invoice_line_df = read_from_adls_with_cdm_format(model.entities["Sales OrderLines"], "cdm") sales_invoice_df = read_from_adls_with_cdm_format(model.entities["Sales Orders"], "cdm")

Any log messages given by the failure


TypeError Traceback (most recent call last) pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._convert_tokens()

TypeError: Cannot cast array from dtype('O') to dtype('int64') according to the rule 'safe'

During handling of the above exception, another exception occurred:

ValueError Traceback (most recent call last)

in 9 #sales_invoice_line_df = read_from_adls_with_cdm_format(model.entities["Sales OrderLines"], "cdm") 10 #sales_invoice_line_df ---> 11 sales_invoice_df = read_from_adls_with_cdm_format(model.entities["Sales Orders"], "cdm") 12 #sales_invoice_df 13 ### Expected/desired behavior > ### OS and Version? > Windows 7, 8 or 10. Linux (which distribution). macOS (Yosemite? El Capitan? Sierra?) ### Versions > ### Mention any other details that might be useful > --------------------------------------------------------------- > Thanks! We'll be in touch soon.