03-21-2023 8:11 PM
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.
03-21-2023 11:21 PM
03-22-2023 1:05 AM
Here is my Week 3 Submissions.
03-22-2023 2:57 AM
My link week3 submission.
Thanks and Regards,
03-23-2023 6:32 AM
This developer challenge has cleared lot of concepts related to Pandas and other concept related to dataframes.
Thanks a lot for wonderful Challenge.
03-22-2023 6:12 AM
Here is my Week 3 Submissions.
03-22-2023 6:23 AM
03-22-2023 6:57 AM
Week 3 was a great learning experience. It was a really interesting challenge! I learned a lot .
03-22-2023 7:35 AM
03-23-2023 4:33 AM
Here is submission for week 3:
I'm really enjoying and learning a lot with this challenge. Very interesting!
03-23-2023 7:34 AM
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
03-23-2023 8:32 AM
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.
03-24-2023 2:28 AM
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.
03-24-2023 2:54 AM
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...
03-24-2023 3:00 AM
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.
03-23-2023 2:21 PM
03-27-2023 8:00 AM
Please find my week3 submission.
03-27-2023 2:24 PM
Week 3 submission
03-28-2023 8:40 AM
03-29-2023 3:56 AM
03-29-2023 6:00 AM
03-29-2023 1:51 PM
I am glad to see that you play a bit with the data and the code too @Sergiu !
03-29-2023 10:25 PM
Learning is about breaking complexity into primary elements and exploring something different. 🙂
03-30-2023 10:53 PM
03-31-2023 6:21 AM
Please find my week3 submission : Week3.ipynb
Thanks & Regards,
03-31-2023 4:21 PM
I liked to see you played a bit with the notebook @richa_dwivedi
Timing of selecting from a few 100s of records won’t be in favor of the database as it would be in case of a few 1000000s of records; so it was for the learning purposes.
04-01-2023 9:25 PM
please find my submission for week3:
04-02-2023 12:40 PM
04-03-2023 1:13 AM - edited 04-03-2023 1:14 AM
My submission for week 3: EDA HANA Week 3 Akash-B-R .
As always, a delight.