- 35
- 80 964
Pat Long Codes
United States
Приєднався 5 сер 2020
Creating extensive tutorials in Python, SAS, R, Java and more with an emphasis in Data Science.
SAS 9.4 Foundation Exam Programming Certification Full Tutorial 2024
Resources:
Full Code used in this tutorial -github.com/patrickjlong1/SAS/blob/main/foundation_certification.sas
SAS 9.4 Programming Fundamentals Exam Content Guide - www.sas.com/content/dam/SAS/documents/technical/certification/content-guide/programming-fundamentals.pdf
Free SAS Studio access in SAS On Demand for Academics - welcome.oda.sas.com/
Other SAS programming Cert Videos:
Video Playlist I made in 2020 on SAS Certified Specialist: Base Programming Using SAS 9.4 (the certification content guide hasn't changed) - ua-cam.com/video/_zLZphf2uHI/v-deo.html&pp=gAQBiAQB
Video I made last year on Advanced Programming in SAS 9.4 Certification - ua-cam.com/video/3FwIihaHqbU/v-deo.html
Full Code used in this tutorial -github.com/patrickjlong1/SAS/blob/main/foundation_certification.sas
SAS 9.4 Programming Fundamentals Exam Content Guide - www.sas.com/content/dam/SAS/documents/technical/certification/content-guide/programming-fundamentals.pdf
Free SAS Studio access in SAS On Demand for Academics - welcome.oda.sas.com/
Other SAS programming Cert Videos:
Video Playlist I made in 2020 on SAS Certified Specialist: Base Programming Using SAS 9.4 (the certification content guide hasn't changed) - ua-cam.com/video/_zLZphf2uHI/v-deo.html&pp=gAQBiAQB
Video I made last year on Advanced Programming in SAS 9.4 Certification - ua-cam.com/video/3FwIihaHqbU/v-deo.html
Переглядів: 146
Відео
Using Functions in Python Reportlab to Create pdfs with multiple Charts and Tables
Переглядів 121Місяць тому
Using the Matplotlib and Reportlab libraries with functions we generate a pdf containing multiple line charts and customized tables. Full Code: github.com/patrickjlong1/python-tutorials/blob/master/pdf_with_reportlab.ipynb Previous Video with user defined functions: ua-cam.com/video/LdTtOWa7psY/v-deo.html
Creating PDFs with Charts and Tables using Python Reportlab Library
Переглядів 185Місяць тому
Using the Matplotlib and Reportlab libraries we generate a pdf containing a simple line chart and a customized table. Full Code: github.com/patrickjlong1/python-tutorials/blob/master/pdf_with_reportlab.ipynb
Creating and Editing Excel Files in Python: An Introduction
Переглядів 792 місяці тому
This tutorial covers generating xlsx files in Python using Pandas and XlsxWriter Library for custom formatting. It also covers a basic example of editing an existing xlsx file using the Openpyxl library. Code used in the tutorial: github.com/patrickjlong1/python-tutorials/blob/master/introExcelPython.ipynb XlsxWriter Docs: xlsxwriter.readthedocs.io/ Openpyxl Docs: openpyxl.readthedocs.io/en/sta...
Modifying existing excel files using openpyxl in python
Переглядів 275Рік тому
Code: github.com/patrickjlong1/python-tutorials/blob/master/modifyXLSX.ipynb Intro to excel files in python: ua-cam.com/video/65Gi6PuGevA/v-deo.html
Introduction to joins with pandas
Переглядів 31Рік тому
This video covers four types of simple joins using the df.merge() method. Full code used: github.com/patrickjlong1/python-tutorials/blob/master/pandasJoins.ipynb Chapters: 00:00:00 Introduction and Setup 00:01:52 Inner Join 00:20:48 Left Join 00:30:16 Right Join 00:31:42 Full Join
Introduction to joins in SAS using PROC SQL
Переглядів 288Рік тому
This video covers the four basic types of joins in SAS sql procedure. Full code used: github.com/patrickjlong1/SAS/blob/main/sas_joins.sas Advanced SAS Certification Tutorial: ua-cam.com/video/3FwIihaHqbU/v-deo.html Chapters: 00:00:00 Introduction and Setup 00:02:54 Inner Join 00:11:55 Left Join 00:18:42 Right Join 00:21:45 Full Join
SAS 9.4 Advanced Programming Certification Full Tutorial 2023
Переглядів 6 тис.2 роки тому
Code used: github.com/patrickjlong1/sas-tutorials-advanced/blob/main/sas_advanced_programmer.sas SAS Exam Content Guide: www.sas.com/content/dam/SAS/documents/technical/certification/content-guide/advanced-programming-sas94.pdf Base SAS Certification Videos: ua-cam.com/video/_zLZphf2uHI/v-deo.html Chapters: 00:00:00 Introduction and Setup 00:06:22 Section 1 - Proc SQL 01:49:20 Section 2 - SAS M...
Intro to Building Graphical Web Applications in Python using Flask
Переглядів 2922 роки тому
In this video we go over making a graphing web application in python using the flask framework. We use gridJS and chartJS javasript libraries to produce the graph and table. We're using google colab and test deploying app with NGROK. Full jupyter notebook: github.com/patrickjlong1/python-tutorials/blob/master/flaskChartJSGridJS.ipynb
Create a Gauge Chart in Excel using Python (in Google Colab)
Переглядів 7773 роки тому
Full code: github.com/patrickjlong1/python-tutorials/blob/master/gaugeChartXLSX.ipynb Previous videos on line charts: ua-cam.com/video/Qij2kwXj6-E/v-deo.html ua-cam.com/video/OSgG1hvnGdw/v-deo.html
Flask Includes using google colab and ngrok
Переглядів 1,2 тис.3 роки тому
Showing a basic example using jinja templating in the Flask python library in google colab. An Introductory example using Flask: ua-cam.com/video/rGDgg3WqbgU/v-deo.html Link to code used: github.com/patrickjlong1/python-tutorials/blob/master/flaskColabIntro.ipynb
Introduction to BeautifulSoup Python Library by example (in Google Colab)
Переглядів 8244 роки тому
Extensive example of scraping data from the www.federalreserve.gov/monetarypolicy/fomc_historical.htm using BeautifulSoup. Then we create a pandas dataframe using the scraped data and demonstrate a starting point for EDA. Full Code: github.com/patrickjlong1/python-tutorials/blob/master/beautifulSoupIntro.ipynb More Simple BeautifulSoup example: ua-cam.com/video/7fYoc8-HgcM/v-deo.html
Brief Introduction to BeautifulSoup Python Library by example (in Google Colab)
Переглядів 4544 роки тому
Short example of scraping data from the archives.gov website using BeautifulSoup. Then we create a pandas dataframe using the scraped data. Full Code: github.com/patrickjlong1/python-tutorials/blob/master/beautifulSoupIntro.ipynb
Creating a pdf with a Pie Chart and table using Python FPDF and Matplotlib libraries in Google Colab
Переглядів 2,5 тис.4 роки тому
In this tutorial, I use the Matplotlib and FPDF libraries to generate a pdf containing a simple pie chart and an accompanying table. Full Code: github.com/patrickjlong1/python-tutorials/blob/master/CreatePieChartPDFPython.ipynb Other Relevant Videos: 1. Using matplotlib and FPDF libraries to produce a bar chart and table pdf output in python: ua-cam.com/video/UlKEUEWqaHM/v-deo.html 2. Intro to ...
Intro to using chartjs with Flask and ngrok (in google colab)
Переглядів 4834 роки тому
Full example showing how to use chartjs javascript library in Flask and deploying with ngrok. We use a pandas dataframe as the data displayed in the chart Link to code: github.com/patrickjlong1/python-tutorials/blob/master/flaskColabChartjs.ipynb Intro tutorial on Flask using google colab and ngrok: ua-cam.com/video/rGDgg3WqbgU/v-deo.html
Introduction to Flask using google colab and ngrok
Переглядів 4,6 тис.4 роки тому
Introduction to Flask using google colab and ngrok
Creating PDFs with Charts and Tables using Python FPDF and Matplotlib libraries (in Google Colab)
Переглядів 12 тис.4 роки тому
Creating PDFs with Charts and Tables using Python FPDF and Matplotlib libraries (in Google Colab)
Creating PDFs w/ Charts and Tables using Python Matplotlib library (in Google Colab)
Переглядів 2,8 тис.4 роки тому
Creating PDFs w/ Charts and Tables using Python Matplotlib library (in Google Colab)
Two Ways to Create PDF Files with tables in Python
Переглядів 12 тис.4 роки тому
Two Ways to Create PDF Files with tables in Python
Writing Excel Formulas to .xlsx files in Python (using Google Colab)
Переглядів 1,9 тис.4 роки тому
Writing Excel Formulas to .xlsx files in Python (using Google Colab)
Introduction to Formatting Excel Files using Python using for loops and functions (in Google Colab)
Переглядів 1024 роки тому
Introduction to Formatting Excel Files using Python using for loops and functions (in Google Colab)
Introduction to Formatting Excel Files using Python (in Google Colab)
Переглядів 8784 роки тому
Introduction to Formatting Excel Files using Python (in Google Colab)
Create a Chart Sheet in Excel using Python (in Google Colab)
Переглядів 2644 роки тому
Create a Chart Sheet in Excel using Python (in Google Colab)
Create a Combined Chart in Excel using Python (in Google Colab)
Переглядів 2764 роки тому
Create a Combined Chart in Excel using Python (in Google Colab)
Create a Scatter Chart in Excel using Python (in Google Colab)
Переглядів 1,5 тис.4 роки тому
Create a Scatter Chart in Excel using Python (in Google Colab)
Create a Bar Chart in Excel using Python (in Google Colab)
Переглядів 2,3 тис.4 роки тому
Create a Bar Chart in Excel using Python (in Google Colab)
Create a Line Chart in Excel using Python (in Google Colab)
Переглядів 1,6 тис.4 роки тому
Create a Line Chart in Excel using Python (in Google Colab)
Create a Pie Chart in Excel using Python (in Google Colab)
Переглядів 1,6 тис.4 роки тому
Create a Pie Chart in Excel using Python (in Google Colab)
Create a Column Chart in Excel using Python (in Google Colab)
Переглядів 2944 роки тому
Create a Column Chart in Excel using Python (in Google Colab)
Three Simple Ways to Create .XLSX files in python (using Google Colab)
Переглядів 5414 роки тому
Three Simple Ways to Create .XLSX files in python (using Google Colab)