2023 Mar 14 8:15 PM
This discussion thread is to submit your solution for Week 2, 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.
2023 Mar 15 4:43 AM - edited 2023 Mar 15 12:53 PM
2023 Mar 15 12:35 PM
Thank you for submitting @sourabh3ss!
Cell 47 in your solution outputs
<bound method ConnectionContext.get_tables of <hana_ml.dataframe.ConnectionContext object at 0x000001E341443BB0>>
which is not the error message, but it should output the list of the tables, like
That's the only thing required to be fixed in your solution.
2023 Mar 15 12:54 PM
Thanks for your inputs. Updated the submission link.
2023 Mar 15 1:28 PM
2023 Mar 15 3:08 PM
2023 Mar 15 4:16 PM - edited 2023 Mar 15 4:24 PM
2023 Mar 15 9:06 PM
2023 Mar 16 10:27 AM
2023 Mar 17 7:46 AM
Hi All,
Week 2 Submission link.
https://github.com/UZOIQ4SW/HANA-EDA/blob/main/Week2.ipynb
Thanks and Regards,
Gaurav Phadnis
2023 Mar 17 12:16 PM
2023 Mar 17 1:20 PM
Hi Vitaliy,
My local notebook showed output somehow in git hub it was not showing.
I had executed all cells.Please check same link its updated.
https://github.com/UZOIQ4SW/HANA-EDA/blob/main/Week2.ipynb
All output shown.
Thanks and Regards,
Gaurav Phadnis
2023 Mar 17 3:43 PM
2023 Mar 19 8:05 PM
Hi,
My Week 2 Submission.
Regards,
Sai Nithesh
2023 Mar 20 11:01 AM
2023 Mar 20 12:30 PM
@Sergiu i see you went ahead and added different SELECT’s using HDF. We’ll do some of that starting this Wednesday.
2023 Mar 20 5:00 PM
Hi,
catching up on week2. Not as challenging as the installation last week but cool stuff to simplify data handling.
Looking forward to learning how to make the hdf learn from the data.
Kind Regards, Oskar
2023 Mar 20 6:03 PM
Hi Oskar. This dev challenge is meant to be at an introductory level, so not that challenging (besides the setup indeed). We are focusing only on the fundamentals of HANA DataFrames here, while I see you went much further, including training models.
ML was a part of the challenge our product management ran beginning of the year. You can watch:
1/ introduction to embedded ML in SAP HANA: https://www.youtube.com/live/pgV_NFdokZ4?t=14
2/ participants presentations: https://www.youtube.com/live/ul5ZqnB3qVw
Regards,
-Vitaliy
2023 Mar 21 5:02 PM
Cool. Thanks for sharing. 😎
"I won't quit" but stay on board for week3!
2023 Mar 21 6:48 AM
2023 Mar 21 1:22 PM
It seems you are using the `DBADMIN` user in your exercises, @kyvraoaiml
I would still suggest you create and use a separate user for this challenge, as described in point 1 of https://github.com/SAP-samples/sap-community-developer-challenge-eda-hana#security-setup --- even if you are not setting up a user store.
2023 Mar 21 2:54 PM
I am taking care of it. Thank you for the advise.
2023 Mar 21 12:35 PM
2023 Mar 21 3:30 PM
Hi, Please find my week2 submission.
https://github.com/salimnisar/SAP-community-developer-challenge-eda-hana/blob/main/Week%202.ipynb
Regards
Salim Nisar
2023 Mar 21 8:38 PM
Hi,
My Week 2 Submission.
Best regards
Mariusz
2023 Mar 22 11:52 AM
Cześć @Mariusz. Line 31 still requires correction:
You should receive a table with names of database tables as an output, not a Python object definition.
2023 Mar 22 2:51 PM
Thanks to all for joining Week 2 so far! I would like to remind you that the Week 3 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/
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 Week 2 were too easy or too hard, and what you have learned.
Cheers!
-Vitaliy
2023 Mar 30 4:01 PM
2023 Apr 02 5:23 AM
2023 Apr 03 2:00 PM
I see you got an error in line 24 when executing `type(months_df.collect())` @moh_ali_square :
AttributeError: 'DataFrame' object has no attribute 'collect'
That's because collect is the method of HANA DataFrame, while you were using it with the Pandas dataframe.
2023 Apr 03 9:08 AM - edited 2023 Apr 03 9:11 AM
Hello,
My submission for week 2: EDA HANA Week 2 Akash-B-R .
I had a bit of fun with .style.hide(axis='index'). I have left a comment in Line In[42]. Surprising output.
Thank you.
2023 Apr 03 10:05 AM