data-science 2021-03-29 | Slack Archive

David Vujic09:03:08

I have another question about .dataset : It seems that an Excel document with more than one tab/sheet causes an exception Multiple (2) datasets found in file - is there a way to configure it to select a specific sheet?

David Vujic09:03:55

I looked in the docs, but couldn't find anything about this. @UDRJMEFSN Do you have any ideas on how to solve multiple tabs/datasets?

chrisn13:03:21

@U018VMC8T0W - Yes - the ->dataset pathways are set to produce a single datasets and at this point I do not have an option to select one out of potentially many which is an interesting idea. In either https://techascent.github.io/tech.ml.dataset/tech.v3.libs.poi.html or https://techascent.github.io/tech.ml.dataset/tech.v3.libs.fastexcel.html you can find methods that will return a sequence of datasets from an xlsx or xls file.

David Vujic14:03:55

Thanks! I did a quick experiment with workbook->datasets and I think it will be perfect 😄

jsa-aerial14:03:42

@U018VMC8T0W also, generally, DS hangs out in Zulip. For TMD in particular, try https://clojurians.zulipchat.com/#narrow/stream/151924-data-science/topic/tech.2Eml.2Edataset

David Vujic16:03:58

I’ll check it out! Wasn’t aware of that platform 😄

2021-03-29

Channels