This discussion thread is to submit your solution for Week 3, when participating in the March 2023 developer challenge for SAP Community. The challenge is about "Exploratory Data Analysis with SAP HANA and Python".
Please use this separate thread to ask your questions and discuss issues. Keep this thread for your submissions only.
Here is submission for week 3:
I'm really enjoying and learning a lot with this challenge. Very interesting!
I am really impressed how efficient querying HANA DB with "panda"-style is. Looking forward to next week.
Little short on time this week: so here goes my uncreative click-through:
Kind Regards, Oskar
How much time have you spent on this week's notebook, including playing with it a bit, as I see?
Unf. HANA Trial does not include embedded ML functionality, as I saw you were trying to execute at the end. That's why we focus only on the DataFrame module of the hana-ml package during this challenge.
Yeah. Thanks for confirming. I only wanted to see how far I could get as some of the machine learning helper work nicely. I got stuck on missing "SYSTEM" privileges to add the "scripting"
alter system alter configuration ('daemon.ini', 'SYSTEM') set ('scriptserver', 'instances') = '1' with reconfigure;
Not sure exactly how much time I spent this week as I had to do it in parallel to meetings with limited focus 😉 with some focus I would guess approx 1-2h. So completely fine.
I was wondering if there is a chance to set up the training / DB connection without any local installation - like using google Colab: that would simplify using it for that 99% of the "old" SAP world population (like me) who do not have local installation privileges on their ordinary windows desktops.
I did not have time to invest in checking Binder or CoLab for this exercise, but @kyvraoaiml wrote they were using CoLab for that: https://groups.community.sap.com/t5/application-development/questions-re-quot-eda-with-sap-hana-quot...
Enablement of a ScriptServer in HANA database in SAP HANA Cloud is done from the Cloud Central UI: https://help.sap.com/docs/HANA_CLOUD/9ae9104a46f74a6583ce5182e7fb20cb/3dbe5597a2ef4d48a32f42e0eff283... or by using the cli:
But the trial edition has too few vCPUs to enable it.