Submissions for "EDA with SAP HANA" developer challenge: Week 2 - DataFrames

[Vitaliy-R]

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.

[sourabh3ss]

Week 2 Solution 

[Vitaliy-R]

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.

[sourabh3ss]

Thanks for your inputs. Updated the submission link.

[Former Member]

Hello @Vitaliy-R 

Week 2 submission: Link 

Very interesting challenge! Thank you.

[pawelwiejkut]

Helo all,

Week 2:

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

Best regards,

Pawel.

[f1se4]

Let's go! 

Week2 -> link

Thx!!

Sergi

[MioYasutake]

My week2 submission.

[abcl0653]

My week2 submission

[gphadnis2000]

Hi All,

Week 2 Submission link.

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

Thanks and Regards,

Gaurav Phadnis

[Vitaliy-R]

Thank you for the submission @gphadnis2000 , but it looks like your notebook is not all completed:

[gphadnis2000]

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

[MadhavKumar]

Week 2 Submission.

Regards,

Madhav Kumar

[Sai_Nithesh_G]

Hi,

My Week 2 Submission.

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

Regards,

Sai Nithesh

[Sergiu]

Week 2 solution.

[Vitaliy-R]

@Sergiu i see you went ahead and added different SELECT’s using HDF. We’ll do some of that starting this Wednesday. 

[obinym]

Hi,

catching up on week2. Not as challenging as the installation last week but cool stuff to simplify data handling.

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

Looking forward to learning how to make the hdf learn from the data.

Kind Regards, Oskar

[Vitaliy-R]

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

[obinym]

Cool. Thanks for sharing. 😎

"I won't quit" but stay on board for week3!

[kyvraoaiml]

Hi, Please find my week2 submission.

https://github.com/VENKATAISAP/sap-community-developer-challenge-eda-hana/blob/main/SAP_EDA_Challeng...

[Vitaliy-R]

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.

[kyvraoaiml]

I am taking care of it. Thank you for the advise.

[dinah]

Week2 Notebook

[former_member122105]

Hi, Please find my week2 submission.

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

Regards 

Salim Nisar

[Mariusz]

Hi,

My Week 2 Submission.

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

Best regards 

Mariusz 

[Vitaliy-R]

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.

[Vitaliy-R]

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

[richa_dwivedi]

Hi,

Please find my week2 Submission link: Week2.ipynb

Thanks & Regards,

Richa Dwivedi

[moh_ali_square]

Hi Vitaliy, 

please find my submission for week2:

Week2 submission 

[Vitaliy-R]

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.

[Akash-B-R]

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.

[Vitaliy-R]

I think experimenting is the best part.