topic Re: Machine Learning algorithm to find correlations between columns in a table. in Artificial Intelligence Forum

Machine Learning algorithm to find correlations between columns in a table.

former_member510186 — Mon, 25 Jun 2018 12:28:51 GMT

Hi All,

I have a table with say 10 columns. I want to find the correlation between these columns.

Can someone please tell me which Machine Learning Algorithm can be used to find correlations between columns in a table.

Someone please help me out in this regard.

Thanks in Advance,

Medini H K

Re: Machine Learning algorithm to find correlations between columns in a table.

Former Member — Mon, 25 Jun 2018 22:19:47 GMT

Association rule learning can be used to 'identify strong rules discovered in databases using some measures of interestingness'

Since you have not specified any SAP Product, here are some links which may be useful for you:

SAP BusinessObjects Predictive Analytics 3.1: Getting Started With Association Rules (Automated Analytics User Guide)

Automated Analytics - Create association rules: SAP Predictive Analytics 2.0

Re: Machine Learning algorithm to find correlations between columns in a table.

former_member510186 — Tue, 26 Jun 2018 04:52:08 GMT

Thanks for the reply Poonam. But I'm looking for a Machine Learning Algorithm in particular (like Linear regression, Naive Bayes etc) to find the correlation. Please let me know if you know any such algorithms for correlation.

Thanks in Advance,

Medini H K

Re: Machine Learning algorithm to find correlations between columns in a table.

Former Member — Wed, 27 Jun 2018 00:18:08 GMT

Hi Medini,

Assuming you are pulling data from HANA and want to use its native capacities, you options among association rules are Apriori, FP-Growth, K-Optimal Rule Discovery (KORD), Sequential Pattern Mining.

Reference: PAL Functions

Re: Machine Learning algorithm to find correlations between columns in a table.

former_member510186 — Thu, 28 Jun 2018 06:10:11 GMT

Thank you Poonam, will try it now.

Regards,

Medini H K