question

MangeshAgnihotri-4896 avatar image
0 Votes"
MangeshAgnihotri-4896 asked MangeshAgnihotri-4896 answered

Help for Azure ML Studio experiment data translation


I am learning Azure ML (Studio) and please help me for below scenarios,
I have a bank customer data having column labelled as customer age, family members (1,2,3 &4), credit card (Yes /no) Personal Loan (Yes /no), education (1. Undergrad 2. Graduate 3. Advanced/professional), Experience in year (with -ve values) .



  1. How to find % customers who are having credit card as well Personal loan?

  2. How to compare education category with customers to found possibility of more subscribe to personal loan?

  3. How to change -ve experience to 0

4.How to do visual analysis?

  1. How to calculate correlation between 2 columns?

Thanks in advance for your guidance. and incase tag to wrong group please guide to appropriate group

azure-machine-learning-studio-classic
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YutongTie-MSFT avatar image
0 Votes"
YutongTie-MSFT answered YutongTie-MSFT edited

Hello,

Thanks for reaching out to us. I have seen the similar question you have asked https://docs.microsoft.com/en-us/answers/questions/390316/help-for-azure-ml-studio-experiment-mapping.html Since you ask again, I provide more details about sql and also solution in Machine Learning studio in needed.

For question 1 and 2: As part of your data preparations step, you can use apply sql transformation and apply math operation to perform data transformations. The trend can be seen in Visualization as well.

This can be done with sql COUNT and SELECT in sql. https://www.sqltutorial.org/sql-aggregate-functions/sql-count/ https://www.sqltutorial.org/sql-select/

For question 3, kind of same if you are using sql transformation. You can use SQL UPDATE to do it: https://www.sqltutorial.org/sql-update/

For question 4, How to do visual analysis?
With Azure ML Designer, You can visualize the data to understand the dataset that you'll use. Right-click the data you want to visualized and select Visualize > Dataset output. You can also select the different columns in the data window to view information about each one.
96708-image.png

For question 5, How to calculate correlation between 2 columns? I don't think there is a directly way in Azure Machine Learning designer but there is one in old machine learning studio https://docs.microsoft.com/en-us/azure/machine-learning/studio-module-reference/compute-linear-correlation




Regards,
Yutong



image.png (20.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MangeshAgnihotri-4896 avatar image
0 Votes"
MangeshAgnihotri-4896 answered

Hi Yutong,

Thanks for your input but I am not good in SQL. Ca it possible to perform above activity without SQL scripts.
If yes please suggest steps.

If not, please tell me how will i convert dataset to table and how to know the table name?

Thank you for understanding me


Regards
Mangesh

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.