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 2 - DataFrames

Vitaliy-R
Developer Advocate
Developer Advocate

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.

31 REPLIES 31

sourabh3ss
Product and Topic Expert
Product and Topic Expert

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

VitaliyR_0-1678883551721.png

That's the only thing required to be fixed in your solution.

sourabh3ss
Product and Topic Expert
Product and Topic Expert

Thanks for your inputs. Updated the submission link.

rcaziraghi
Participant

Hello @Vitaliy-R 

Week 2 submission: Link 

Very interesting challenge! Thank you.

f1se4
Explorer

Let's go! 

Week2 -> link

Thx!!

Sergi

MioYasuatke
Active Contributor

abcl0653
Product and Topic Expert
Product and Topic Expert

gphadnis2000
Participant

Hi All,

 

Week 2 Submission link.

 

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

 

Thanks and Regards,

Gaurav Phadnis

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

VitaliyR_0-1679055376055.png

 

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
Explorer

Week 2 Submission.

Regards,

Madhav Kumar

Sergiu
Contributor

Vitaliy-R
Developer Advocate
Developer Advocate

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

obinym
Explorer

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
Developer Advocate
Developer Advocate

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

Cool. Thanks for sharing. 😎

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

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_0-1679410436217.png

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

dinah
Product and Topic Expert
Product and Topic Expert

Vitaliy-R
Developer Advocate
Developer Advocate

Cześć @Mariusz. Line 31 still requires correction:

VitaliyR_0-1679485868177.png

You should receive a table with names of database tables as an output, not a Python object definition.

 

 

Vitaliy-R
Developer Advocate
Developer Advocate

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
Explorer

Hi,

Please find my week2 Submission link: Week2.ipynb

Thanks & Regards,

Richa Dwivedi

moh_ali_square
Explorer

Hi Vitaliy, 

 

please find my submission for week2:

Week2 submission 

 

 

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
Product and Topic Expert
Product and Topic Expert

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
Developer Advocate
Developer Advocate

I think experimenting is the best part.