Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
SAP Community Log-in Update
In a few months, SAP Community will switch to SAP Universal ID as the only option to login. Don’t wait, create your SAP Universal ID now! If you have multiple S- or P- accounts, use the Consolidation Tool to merge your content. Get started with SAP Universal ID now!

Submissions for "EDA with SAP HANA" developer challenge: Week 1 - Setup

Vitaliy-R
Employee
Employee

‎03-08-2023 3:47 AM - edited ‎03-08-2023 9:25 AM

This discussion thread is to submit your solution for Week 1, if participating in the March 2023 developer challenge for SAP Community. The topic is "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.

Labels:
30 REPLIES 30

dinah
Employee
Employee

‎03-08-2023 6:22 AM - edited ‎03-08-2023 6:46 AM

Week One Notebook

f1se4
Galactic 2
Galactic 2

‎03-09-2023 9:37 PM

Week 1 --> GitHub notebook link

Note. I'm using python 3.11. If the next weeks the challenge impacts on python version I will recreate an environment for this, but now, just to check.

Thx!!! And good challenge to all!

Sergi García. 
Customer - Solution Architech

 

Vitaliy-R
Employee
Employee
In response to f1se4

‎03-10-2023 1:33 AM

Thank you for the submission. I suggested Python 3.10, as I had an issue with one of the 3rd party dependencies not working with Python 3.11 last month yet.

f1se4
Galactic 2
Galactic 2
In response to Vitaliy-R

‎03-10-2023 1:35 AM

Ah, perfect! So I will continue with 3.10 ^^

Thank you!!

Sergi

0 Kudos

abcl0653
Employee
Employee

‎03-09-2023 11:49 PM

Week 1 Submission link 

MadhavKumar
Galactic 2
Galactic 2

‎03-10-2023 7:58 AM

Week_1 Submission .

Regards,

Madhav Kumar

gphadnis2000
Galactic 3
Galactic 3

‎03-10-2023 8:13 PM

Hi,

Please find week 1 submission.

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

 

Thanks and Regards,

Gaurav Phadnis

Sergiu
Galactic 3
Galactic 3

‎03-13-2023 3:56 AM

Week one submission here.

Vitaliy-R
Employee
Employee
In response to Sergiu

‎03-13-2023 4:17 AM

Thanks for submitting!

I see you commented the line

# print("SAP HANA DB version: ", myconn.hana_version())

in your notebook.

Was there any issue with that line?

0 Kudos

Sergiu
Galactic 3
Galactic 3
In response to Vitaliy-R

‎03-13-2023 4:41 AM

I have resubmitted without commented lines. 🙂

Mariusz
Galactic 2
Galactic 2

‎03-15-2023 3:35 PM - edited ‎03-15-2023 3:40 PM

Hi @Vitaliy-R 

Week 1 submission: 

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

Regards,
Mariusz

kyvraoaiml
Galactic 2
Galactic 2

‎03-16-2023 3:36 AM

Hi, Please find my week 1 Submission.  I have removed user credentials from ConnectionContext. 

Week1 Assignment 

For me below statement did not work. So I used above syntax.

myconn=hdf.ConnectionContext(userkey='DevChallenger')

 

Vitaliy-R
Employee
Employee
In response to kyvraoaiml

‎03-16-2023 8:51 AM

Do you want to discuss the issue you had setting up HANA user store on the client side in the https://groups.community.sap.com/t5/application-development/questions-re-quot-eda-with-sap-hana-quot... ?

0 Kudos

Salim_Nisar
Galactic 3
Galactic 3

‎03-16-2023 6:37 AM

Hi  @Vitaliy-R ,

Please find my week 1 Submission.  I have removed user credentials from ConnectionContext.

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

Regards,
Salim 

Vitaliy-R
Employee
Employee
In response to Salim_Nisar

‎03-16-2023 7:30 AM

Thank you for your submission @Salim_Nisar .

Have you had problems setting up a user credential store that would eliminate the need using user+password in the code?

Regards,
-Vitaliy

Salim_Nisar
Galactic 3
Galactic 3
In response to Vitaliy-R

‎03-20-2023 3:56 AM

Hi Vitaliy

I made some revisions to the file that I shared with you earlier. After reviewing it again, I realized that I had forgotten to include some important steps in the process. I have now updated the file and Please take a moment to review the updated file. https://github.com/salimnisar/SAP-community-developer-challenge-eda-hana/blob/main/updated%20-%20Wee...

Regards,
Salim Nisar

Vitaliy-R
Employee
Employee

‎03-16-2023 8:57 AM

Thanks to all for joining Week 1 so far! I would like to remind you that the Week 2 challenge has been available since yesterday: please see "The Timeline" in https://blogs.sap.com/2023/03/08/sap-community-developer-challenge-eda-with-sap-hana-and-python/

Plus, I would really appreciate your feedback about challenges added as comments to that blog post: what you liked, what you think can be improved, what you were missing to get started successfully, if challenges starting from the Week 2 were too easy or too hard. 

Thank you!

0 Kudos

sainithesh
Galactic 3
Galactic 3

‎03-19-2023 12:22 PM

Hi,

Here is my Week Submission.
https://github.com/SaiNithesh/sap-community-developer-challenge-eda-hana/blob/main/notebooks/challen... 

Regards,

Sai Nithesh

obinym
Galactic 2
Galactic 2

‎03-20-2023 2:40 AM

Hi Vit,

find my fantastic improvement of the notebook here - only took me two days to set up a DB connection because I was struggling on my Ubuntu 18.04 stuck with python 3.6.9 - upgraded to 20.x and python 3.8.x and "shapely" is still missing on requirements somewhere - manually pip installed. Now ready to go and to learn the fantastic improvement of having HDB as a pandas backend 😉

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

 Happy Learning everyone,

Oskar

Vitaliy-R
Employee
Employee
In response to obinym

‎03-20-2023 3:36 AM

Hi Osk. Thanks for joining!

I know setup took quite a few steps, if someone does it for the first time.

Yeah, Python 3.6 is like 5 years old now. 
“shapely” is listed in https://help.sap.com/doc/cd94b08fe2e041c2ba778374572ddba9/2022_4_QRC/en-US/Installation.html, but is not required this time, as we are not going to use geospatial data in this challenge. 
I did include it into step 2 of https://github.com/SAP-samples/sap-community-developer-challenge-eda-hana/blob/main/setup/miniconda.... just to avoid that red message.

Thanks for your effort and looking 👀 forward to week 2 submission. 
-Vitaliy

richa_dwivedi
Galactic 2
Galactic 2

‎03-28-2023 11:52 AM - edited ‎03-28-2023 11:30 PM

Week One Notebook

0 Kudos

Vitaliy-R
Employee
Employee
In response to richa_dwivedi

‎03-28-2023 9:38 PM

Thank you for joining @richa_dwivedi ! But there is one last cell missing in your notebook

print(myconn.sql("SELECT NOW() FROM DUMMY").collect().CURRENT_TIMESTAMP[0])

comparing to the https://github.com/SAP-samples/sap-community-developer-challenge-eda-hana/blob/main/notebooks/challe... 

Could you check your notebook, update and resubmit it?

Thank you!

richa_dwivedi
Galactic 2
Galactic 2
In response to Vitaliy-R

‎03-28-2023 11:26 PM - edited ‎03-28-2023 11:30 PM

Hi @Vitaliy-R ,

Thanks for informing, I've updated the changes in the  provided week1.ipynb  submission.

Thanks & Regards,

Richa 

moh_ali_square
Galactic 2
Galactic 2

‎04-01-2023 9:19 PM

Hi, 

Thanks for the opportunity to learn about HANA machine learning

 

please find link below for my week1 file :

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

Akash-B-R
Employee
Employee

‎04-03-2023 1:06 AM

Hello,

I can't believe I almost missed this.

Hope I am not too late.

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

Wonderful new topic. The setup was the biggest hurdle. The exercises were enjoyable.

The details are much appreciated.

Thank you.

Vitaliy-R
Employee
Employee
In response to Akash-B-R

‎04-03-2023 2:00 AM

Thank you. And thank you for joining @Akash-B-R!

0 Kudos