Python code in pipeline

[sarafrass]

Good afternoon everyone!

I'm building a pipeline in SAS Vyia for learners and I would like to plot (if possible) a correlation matrix by computing it in python language (I attached the pipeline).

The code I've written so far is this on:

import numpy as np
import seaborn as sns
import matplotlib.pyplot as plt
import pandas as pd
import warnings
warnings.filterwarnings('ignore')

bank_df = pd.read_csv(dm_inputdf + "node_data.csv")

corr_df = bank_df.corr(method = "pearson")

plt.figure(figsize=(10,8))

sns.heatmap(corr_df, annot=True)

plt.show()

Unfortunately I cannot execute it because it keeps giving me error.

Actually, I would like to print a correlation matrix of the entire datafile but I can't understand which kind of path I should use.. 

Thank you so much,

Sara

[Cynthia_sas · Accepted solution]

Hi:
I don't recall a Python pipeline activity in the SAS Academy for Data Science classes. Can you clarify which class in the Data Science Academy you're working? The classes that use Viya would be in the AI&ML level, but there are 5 classes in that level and in order to ask the instructors for help, we need to know which class you're working in and what demo, activity or practice you're using. My understanding of the Data Science classes is that if they use R or Python in their examples, that they provide already working programs for students to use.

Are you perhaps using Jupyter Notebook with Viya for Learners in a University class or through a University? I'm guessing that might be a possibility because university students can get access to Viya for Learners without being enrolled in the SAS Academy for Data Science (and, in fact, not all the levels in our Data Science Academy use SAS Viya).

Here's an example of a Community Library post https://communities.sas.com/t5/SAS-Communities-Library/How-to-execute-Python-or-R-models-using-the-O... that discusses running Python with SAS Enterprise Miner. And, this blog post discusses Jupyter Notebook with Viya for Learners: https://blogs.sas.com/content/sgf/2020/04/15/getting-started-with-python-integration-to-sas-viya-par... . If you are trying to import your own data into Viya for Learners, I believe that functionality is not available yet on Viya for Learners.

There's a whole series of articles on using Python with SAS Viya, you'll find the index here: https://blogs.sas.com/content/sgf/2020/06/19/getting-started-with-python-integration-to-sas-viya-ind... .

I hope these resources get you pointed in the right direction. Jupyter Notebook and SAS Viya questions can also be asked in this forum: https://communities.sas.com/t5/Administration-and-Deployment/bd-p/sas_admin

Cynthia

[sarafrass]

Good afternoon @Cynthia_sas ,

yes, you are totally right. I use Vyia for learners for my university degree in Data Science but I'm not enrolled in SAS Academy for Data Science. 

I am terribly sorry for the bother and for my mistake.

Thank you so much for the kind reply, 

Sara