Submissions for "EDA with SAP HANA" developer challenge: Week 3 - Querying

[Vitaliy-R]

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.

[sourabh3ss]

Week 3 

[sainithesh21]

Hello,

Here is my Week 3 Submissions.

https://github.com/SaiNithesh/sap-community-developer-challenge-eda-hana/blob/main/notebooks/challen... 

Regards,

Sai Nithesh

[gphadnis2000]

Hello,

My link week3 submission.

https://github.com/UZOIQ4SW/HANA-EDA/blob/main/Week3.ipynb

Thanks and Regards,

Gaurav Phadnis

[gphadnis2000]

Hi Vitaliy,

This developer challenge has cleared lot of concepts related to Pandas and other concept related to dataframes.

Thanks a lot for wonderful Challenge.

Thanks,

Gaurav Phadnis

[Salim_Nisar]

Hi 

Here is my Week 3 Submissions.

https://github.com/salimnisar/SAP-community-developer-challenge-eda-hana/blob/main/Week%203.ipynb

Regards,

Salim

[Vitaliy-R]

Thank you @Salim_Nisar 

How was it?

[Salim_Nisar]

Hey Vitaliy-R
Week 3 was a great learning experience. It was a really interesting challenge! I learned a lot .

[f1se4]

And now week 3!! -> week3 

Sergi García

[rcaziraghi]

Hello!

Here is submission for week 3:

https://github.com/rcaziraghi/sap-community-developer-challenge-eda-hana/blob/main/notebooks/challen... 

I'm really enjoying and learning a lot with this challenge. Very interesting!

Thank you,
Rafael

[obinym]

Hi Vitaliy,

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:

https://github.com/obinym/sap-community-developer-challenge-eda-hana/blob/main/notebooks/challenges/...

Kind Regards, Oskar

[Vitaliy-R]

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.

[obinym]

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.

[Vitaliy-R]

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...

[Vitaliy-R]

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: 

https://help.sap.com/docs/HANA_CLOUD/9ae9104a46f74a6583ce5182e7fb20cb/2b388882e3c34a19af586add1f604d...

But the trial edition has too few vCPUs to enable it.

[miyasuta]

My submission for week 3.

https://github.com/miyasuta/sap-community-developer-challenge-eda-hana/blob/main/notebooks/challenge...

[kyvraoaiml]

Hi,

Please find my week3 submission.

https://github.com/VENKATAISAP/sap-community-developer-challenge-eda-hana/blob/main/SAP_EDA_Challeng...

[Mariusz]

Week 3 submission

https://github.com/DuoBelt/sap-community-developer-challenge-eda-hana/blob/main/notebooks/challenges... 

THX

Mariusz 

[MadhavKumar]

Hi Vitaliy,

Here is the Week3 submission.

Regards,

Madhav Kumar

[dinah]

Week 3

[Sergiu]

Week 3

Regards,

Sergiu Iatco

[Vitaliy-R]

I am glad to see that you play a bit with the data and the code too @Sergiu !

[Sergiu]

Learning is about breaking complexity into primary elements and exploring something different. 🙂

[abcl0653]

Week 3 

Thanks!

[richa_dwivedi]

Hi,

Please find my week3 submission : Week3.ipynb

Thanks & Regards,

Richa

[Vitaliy-R]

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. 
Regards. 

[moh_ali_square]

Hi Vitaliy, 

please find my submission for week3:

Week3 submission 

[pawelwiejkut]

Hello,

Week 3:

https://github.com/pawelwiejkut/sap-community-developer-challenge-eda-hana/blob/main/notebooks/chall...

[Akash-B-R]

Hello,

My submission for week 3: EDA HANA Week 3 Akash-B-R .

As always, a delight.

Thank you.