Using Python for Data Analytics in SAS Viya
Unite the Python language with the analytic power of SAS. In this presentation, you learn how to use the SWAT (SAS wrapper for analytics transfer) package to take advantage of the SAS Cloud Analytic Services (CAS) engine in SAS Viya for massively parallel processing (MPP). We begin with a quick overview of SAS Viya and the CAS engine and then discuss how to leverage the strengths of the CAS engine and your local Python client, how to connect Python to CAS, and how to access and load data into CAS's MPP environment. Then we dive into exploring, preparing, and analyzing data using the CAS server, taking advantage of the CAS server's distributed processing power using familiar pandas API and CAS actions from the SWAT package. Lastly, we learn how to unite traditional python packages such as Pandas and matplotlib with the summarized results from the CAS server for additional processing and visualization. Download the notebook used here https://communities.sas.com/t5/SAS-Explore-Presentations/Using-Python-for-Data-Analytics-in-SAS-Viya/ta-p/838271 Chapters 0:00:00 – Welcome 0:01:00 – Introduction to SAS Viya 0:03:31 – CAS Server Overview 0:11:43 – SWAT Package Overview 0:16:20 – Python Demonstration Setup 0:17:56 – Connect to the CAS Server 0:20:20 – Explore Available Data in the CAS Server 0:25:04 – Load a Data Source File into Memory 0:32:17 – Reload the CSV File as a CAS Table and Fix the Issues 0:34:27 – Overview of Common SWAT Package Python Objects 0:43:05 – Explore the CAS Table Columns 0:54:05 – Explore Numeric Columns 0:58:56 – Remove Duplicate Rows 1:01:38 – Create the Final CAS Tables 1:12:33 – Analyzing Data 1:21:30 – Save the CAS Table as a Data Source File (on disk) 1:23:11 – Understanding CAS Table Scope 1:28:25 – Use SAS Visual Analytics to Create a Dashboard 1:30:44 – Terminate the CAS Connection 1:31:27 – Resources 1:32:18 – Conclusion Additional resources ◉ SAS Viya and Python Integration for Machine Learning – https://support.sas.com/edu/schedules.html?id=20404 ◉ SAS Global Certification Program – https://www.sas.com/certify ◉ SAS Learning Subscription – https://www.sas.com/en_us/training/programs/learning-subscription.html SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS https://www.youtube.com/SASUsers?sub_confirmation=1 ABOUT SAS SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change. CONNECT WITH SAS SAS ► https://www.sas.com SAS Customer Support ► https://support.sas.com SAS Communities ► https://communities.sas.com SAS Analytics Explorers ► https://explorers.sas.com Facebook ► https://www.facebook.com/SASsoftware Twitter ► https://www.twitter.com/SASsoftware LinkedIn ► https://www.linkedin.com/company/sas Blogs ► https://blogs.sas.com RSS ► https://www.sas.com/rss