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
4,578

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
4,558

Week 3 

 

SaiNithesh_Gajula
Active Participant

gphadnis2000
Participant
4,543

Hello,

My link week3 submission.

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

 

Thanks and Regards,

Gaurav Phadnis

4,424

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

4,521

Thank you @former_member122105 

How was it?

4,513

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

f1se4
Explorer
4,502

And now week 3!! -> week3 

Sergi García

rcaziraghi
Participant
4,438

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
4,417

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
4,412

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
4,363

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
4,362

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
4,362

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
4,231

Hi Vitaliy,

Here is the Week3 submission.

Regards,

Madhav Kumar

dinah
Product and Topic Expert
Product and Topic Expert

Sergiu
Contributor
4,199

Week 3

Regards,

Sergiu Iatco

Vitaliy-R
Developer Advocate
Developer Advocate
4,181

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

4,163

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

abcl0653
Product and Topic Expert
Product and Topic Expert
4,134

Week 3 

Thanks!

richa_dwivedi
Explorer
4,126

Hi,

Please find my week3 submission : Week3.ipynb

Thanks & Regards,

Richa

4,119

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
Participant
4,097

Hi Vitaliy, 

 

please find my submission for week3:

Week3 submission 

Akash-B-R
Product and Topic Expert
Product and Topic Expert
4,048

Hello,

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

As always, a delight.

Thank you.