Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Vitaliy-R
Developer Advocate
Developer Advocate

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.

28 REPLIES 28

sourabh3ss
Product and Topic Expert
Product and Topic Expert

sainithesh21
Active Participant

gphadnis2000
Participant

Hello,

My link week3 submission.

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

 

Thanks and Regards,

Gaurav Phadnis

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

Thank you @former_member122105 

How was it?

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

f1se4
Explorer

And now week 3!! -> week3 

Sergi García

rcaziraghi
Participant

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
Explorer

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
Developer Advocate
Developer Advocate
0 Kudos

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.

0 Kudos

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
Developer Advocate
Developer Advocate
0 Kudos

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
Developer Advocate
Developer Advocate
0 Kudos

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.

MadhavKumar
Explorer

Hi Vitaliy,

Here is the Week3 submission.

Regards,

Madhav Kumar

dinah
Product and Topic Expert
Product and Topic Expert

Sergiu
Contributor

Week 3

Regards,

Sergiu Iatco

Vitaliy-R
Developer Advocate
Developer Advocate

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

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

abcl0653
Product and Topic Expert
Product and Topic Expert

Week 3 

Thanks!

richa_dwivedi
Explorer

Hi,

Please find my week3 submission : Week3.ipynb

Thanks & Regards,

Richa

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
Explorer

Hi Vitaliy, 

 

please find my submission for week3:

Week3 submission 

Akash-B-R
Product and Topic Expert
Product and Topic Expert

Hello,

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

As always, a delight.

Thank you.