- 31
- 77 401
Pat Long Codes
United States
เข้าร่วมเมื่อ 5 ส.ค. 2020
Creating extensive tutorials in Python, SAS, R, Java and more with an emphasis in Data Science.
Modifying existing excel files using openpyxl in python
Code: github.com/patrickjlong1/python-tutorials/blob/master/modifyXLSX.ipynb
Intro to excel files in python:
th-cam.com/video/65Gi6PuGevA/w-d-xo.html
Intro to excel files in python:
th-cam.com/video/65Gi6PuGevA/w-d-xo.html
มุมมอง: 217
วีดีโอ
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
มุมมอง 231ปีที่แล้ว
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: th-cam.com/video/3FwIihaHqbU/w-d-xo.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
มุมมอง 5Kปีที่แล้ว
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: th-cam.com/video/_zLZphf2uHI/w-d-xo.html Chapters: 00:00:00 Introduction and Setup 00:06:22 Section 1 - Proc SQL 01:49:20 Section 2 - SAS ...
Intro to Building Graphical Web Applications in Python using Flask
มุมมอง 2712 ปีที่แล้ว
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)
มุมมอง 7643 ปีที่แล้ว
Full code: github.com/patrickjlong1/python-tutorials/blob/master/gaugeChartXLSX.ipynb Previous videos on line charts: th-cam.com/video/Qij2kwXj6-E/w-d-xo.html th-cam.com/video/OSgG1hvnGdw/w-d-xo.html
Flask Includes using google colab and ngrok
มุมมอง 1.1K3 ปีที่แล้ว
Showing a basic example using jinja templating in the Flask python library in google colab. An Introductory example using Flask: th-cam.com/video/rGDgg3WqbgU/w-d-xo.html Link to code used: github.com/patrickjlong1/python-tutorials/blob/master/flaskColabIntro.ipynb
Introduction to BeautifulSoup Python Library by example (in Google Colab)
มุมมอง 7803 ปีที่แล้ว
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: th-cam.com/video/7fYoc8-HgcM/w-d-xo.html
Brief Introduction to BeautifulSoup Python Library by example (in Google Colab)
มุมมอง 4163 ปีที่แล้ว
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.4K3 ปีที่แล้ว
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: th-cam.com/video/UlKEUEWqaHM/w-d-xo.html 2. Intro to...
Intro to using chartjs with Flask and ngrok (in google colab)
มุมมอง 4723 ปีที่แล้ว
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: th-cam.com/video/rGDgg3WqbgU/w-d-xo.html
Introduction to Flask using google colab and ngrok
มุมมอง 4.5K3 ปีที่แล้ว
Showing a basic example (or two) of the Flask python library in google colab. Link to code used: github.com/patrickjlong1/python-tutorials/blob/master/flaskColabIntro.ipynb
Creating PDFs with Charts and Tables using Python FPDF and Matplotlib libraries (in Google Colab)
มุมมอง 12K4 ปีที่แล้ว
Using the Matplotlib and FPDF libraries we generate a pdf containing a simple grouped bar chart and a customized accompanying table. Full Code: github.com/patrickjlong1/python-tutorials/blob/master/pythonChartpdf.ipynb Using only python matplotlib library to produce a similar outputted pdf in python: th-cam.com/video/R0NHDXD7h48/w-d-xo.html Intro Pdf in python video: th-cam.com/video/LwdiCtBuzn...
Creating PDFs w/ Charts and Tables using Python Matplotlib library (in Google Colab)
มุมมอง 2.8K4 ปีที่แล้ว
Using the Matplotlib library we generate a pdf containing a simple grouped bar chart and an accompanying table. Full Code: github.com/patrickjlong1/python-tutorials/blob/master/pythonChartpdf.ipynb Intro Pdf in python video: th-cam.com/video/LwdiCtBuzng/w-d-xo.html
Two Ways to Create PDF Files with tables in Python
มุมมอง 12K4 ปีที่แล้ว
Two Ways to Create PDF Files with tables in Python: 1. FPDF Library 2. Matplotlib Library Code used in video: github.com/patrickjlong1/python-tutorials/blob/master/pdfsPython.ipynb
Writing Excel Formulas to .xlsx files in Python (using Google Colab)
มุมมอง 1.8K4 ปีที่แล้ว
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)
มุมมอง 984 ปีที่แล้ว
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)
มุมมอง 8594 ปีที่แล้ว
Introduction to Formatting Excel Files using Python (in Google Colab)
Create a Chart Sheet in Excel using Python (in Google Colab)
มุมมอง 2554 ปีที่แล้ว
Create a Chart Sheet in Excel using Python (in Google Colab)
Create a Combined Chart in Excel using Python (in Google Colab)
มุมมอง 2584 ปีที่แล้ว
Create a Combined Chart in Excel using Python (in Google Colab)
Create a Scatter Chart in Excel using Python (in Google Colab)
มุมมอง 1.4K4 ปีที่แล้ว
Create a Scatter Chart in Excel using Python (in Google Colab)
Create a Bar Chart in Excel using Python (in Google Colab)
มุมมอง 2.2K4 ปีที่แล้ว
Create a Bar Chart in Excel using Python (in Google Colab)
Create a Line Chart in Excel using Python (in Google Colab)
มุมมอง 1.6K4 ปีที่แล้ว
Create a Line Chart in Excel using Python (in Google Colab)
Create a Pie Chart in Excel using Python (in Google Colab)
มุมมอง 1.5K4 ปีที่แล้ว
Create a Pie Chart in Excel using Python (in Google Colab)
Create a Column Chart in Excel using Python (in Google Colab)
มุมมอง 2804 ปีที่แล้ว
Create a Column Chart in Excel using Python (in Google Colab)
Three Simple Ways to Create .XLSX files in python (using Google Colab)
มุมมอง 5114 ปีที่แล้ว
Three Simple Ways to Create .XLSX files in python (using Google Colab)
SAS 9.4 Base Programming Performance Based Exam Tutorial 2020 - Data Step / Libname (Part 1)
มุมมอง 12K4 ปีที่แล้ว
SAS 9.4 Base Programming Performance Based Exam Tutorial 2020 - Data Step / Libname (Part 1)
SAS 9.4 Base Programming Performance Based Exam Tutorial 2020 - Reports and Output (Part 4)
มุมมอง 2.5K4 ปีที่แล้ว
SAS 9.4 Base Programming Performance Based Exam Tutorial 2020 - Reports and Output (Part 4)
SAS 9.4 Base Programming Performance Based Exam Tutorial 2020 - Error Handling (Part 3)
มุมมอง 2.8K4 ปีที่แล้ว
SAS 9.4 Base Programming Performance Based Exam Tutorial 2020 - Error Handling (Part 3)
SAS 9.4 Base Programming Performance Based Exam Tutorial 2020 - Managing Data (Part 2)
มุมมอง 4.1K4 ปีที่แล้ว
SAS 9.4 Base Programming Performance Based Exam Tutorial 2020 - Managing Data (Part 2)
Thank You😊 and please make more videos
Thank you sir it is very helpful
Thanks a lot
Keep up the good work!
Thanks for your videso. I passed the base exam yesterday
Not audible enough. Please reupload.
Use headsets
Hi, what if i am taking the exam from home through sas 94, which path should I consider while creating a permanent sas library
Thankyou😊
Love your video! I was wondering if there was a way I could solicit your help with a scrapping from a different website!
Please make a video on SAS Certified Professional : Clinical Trials Programmer Using SAS 9.4
Where can we find what sas documentation is available to access
@chaitanyavignan2048 this is the link to the study guide I used in that video series. www.sas.com/content/dam/SAS/documents/technical/certification/content-guide/specialist-base-programming.pdf
Why hasn't beautifulsoup on colab on my browser?
Awesome - thanks so much for posting this!!!!
But they not working with me
Hello I would like to join two table but one value with hyphen and one without hyphen. Can you advise how should I code it so that the hyphen will be disregarded? Thanks in advance for help Table studentAge Student_id Age Abc-123-dd 19 Ccd-578-ee 22 Table studentGender Student_no Gender abc123dd F ccd578ee M ``` Proc sql; Select a.*, b.* From studentAge as a Left join studentGender as b On a.Student_id = b.Student_no ; Quit; ```
I think you'd be best off making use of the `compress()` function to eliminate the '-' from the join and also the `lowcase()` function because of the upper case letter in the student_id column. The fully reporducible snippet below should solve your problem data studentAge; input student_id $10. age; datalines; Abc-123-dd 19 Ccd-578-ee 22 ; run; data studentGender; input Student_no $8. Gender $2.; datalines; abc123dd F ccd578ee M ; run; proc sql; create table combined as select a.*, b.* from studentAge as a left join studentGender as b on lowcase(compress(a.Student_id,'-')) = b.Student_no; quit;
Thank you so much
Actually I have one more question regarding date format and want to seek for your advice I need to add a where clause so that only effective_date or process_date greater than 20230123 will be shown. However, in the existinf table effective_date is in numeric format and effective_date is in text format in the existing table and the table size is big so I would not be able to create a separate table to clean up the format. Proc sql; Select * From OperationTime Where process_date > 20230123 or Datepart(effective_date) >= ’23Jan2023’d Table OperationTime Tasks Effective_date Process_date (text) C234 20230101 2013-01-24 16:58:54.3028 B355 20201006 2020-01-16 16:58:54.3028 D777 20221005 2010-01-24 16:58:54.3028
@@scottau743 switching this line in for the second part of your where clause might solve it. Using The `mdy()` funtion you'll have a SAS date to compare to a SAS date if that makes sense. mdy(input(substr(effective_date,5,2),2.),input(substr(effective_date,5,2),2.),input(substr(effective_date,1,4)),4.) >= ’23Jan2023’d
Wahoo!! Super!! Thanks!!
great!!!!!!!!!!!!!!!!!
Thanks Mama
Thanks bud. Walked it with you, very helpful. Wish me luck. My question is why you got the score you did when you clearly know a lot, seems like it should have been higher. Does this speak to the difficulty of the exam?
This tutorial is extremely valuable, thanks. Can you show us how to display charts with data from DBS ?
Very grateful 🙏 Thank you!
nice
Is there any way to create a pdf with plots without inserting them as an image
I also wanted to ask when SAS advanced will be? Will it be this year? Base video was great!
good, you come back. How about SAS Advance ? thank you so much.
Thanks! I'm working on an Advanced SAS Programmer Certification video.Hoping to finish soon.
when will the advance come ? thank you so much.
thank you so much ! Verr good videoes.
great tutorial thanks
hi, how to wrap a text if the text is too long? thank you sir
Is there a way to highlight the maximum values of each column?
Is it possible to highlight the max values of each column in the table?
Full SAS Sessions :- th-cam.com/play/PLCmzhzAgjyBwafMtp7Fm7ZJj1oiwn1U5V.html
Hi. Could you share baseball.xlsx and baseball.csv files?
In "Use DO and END statements to execute multiple statements conditionally" they don't mean do-loop but do-end statement which you use before. And you shouldn't. You should use only if-else, without do-end.
Hi, why text in your log written by putlog is blue, like the orygnal sas log notes. In my Log Putlog write only in black. So it is different that oryginal notes.
really cool pdf, I tried it on Thursday, at work, and had a hard time with positioning. You seem to know exactly where you are putting the cells. It took me a long time to figure out where to place a logo image. How do you figure out the coordinates positions? Do you by any chance know how to get it to work with non Latin characters?
Very useful videos. I followed all your videos and passed my Base SAS certification exam. Thanks a lot! Highly recommend these videos for anyone looking to crack the exam.
Thanks so much for letting me know. I'm working on an advanced programmer one and comments like this motivate me to publish it sooner. Thanks!
excellent explanation...Thanks !!
THanks bro.
Thanks How can I make the columns narrower?
Good question, @Somya Rathee. You can adjust the parameters of the .cell() method. For instance pdf.cell(70, 10, ) has 70mm as the width and 10mm as the height of the cell and adjusting these will alter the size of the cell. The FPDF docs are a good source for further examples and explanations too. Link: pyfpdf.readthedocs.io/en/latest/index.html
just wanted to ask quick question.!! You work in Tech??
@@mozzaminamdar7143 yes why
@@somyarathee actually I just started in tech and wanted some guidance in what should i do next..btw can I know what is your job profile??
Good one and great work!
can you make video on sas base programming fundamentals exam.. tat wud be gr8 help
How to upload an image in the "text.html" using flask and colab? Do you have any video on that?
hi sir, i tested the code. it is running correctly but when i re run the code or run the code after modifying the html content. it shows that the webpage isn't working right now. it works fine for the first time but not after i re run the code. please help
Hi @Madara Uchiha. Based on your experience, it sounds like you're going to the previous ngrok url. If you're changing the html, you'll need to interrupt execution and re-run and then click the new link ngrok tunnel link. Hopefully that is helpful.
sir how to avoid empty cells (i.e None) in between while using for loop
Thank you so much for your efforts. It's like a quick refresher
Thanks - it was helpful
sir how to read cells loaded with formula
Using openpyxl library you could use the load_workbook method and the _data_only=True_ option. e.g., wb = load_workbook('file.xlsx', data_only=True)
@@patlongcodes THANK YOU VERY MUCH, first to understand my question and to reply correct solution.
This is really helpful!
THE BEST training video.