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.
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... ?
Hi @Vitaliy-R ,
Please find my week 1 Submission. I have removed user credentials from ConnectionContext.
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...
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.
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 😉
Happy Learning everyone,
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.
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)
Could you check your notebook, update and resubmit it?
Thanks for the opportunity to learn about HANA machine learning
please find link below for my week1 file :