Python Tutorials

Machine Learning

Linear Regression – statsmodels
Multiple Linear Regression
K-Means Clustering
Confusion Matrix
Logistic Regression
Random Forest

Pandas

Calculate stats
Import CSV File into Python
Import CSV with Variable Name
Import Excel File into Python
Create Pandas DataFrame
Export DataFrame to CSV
Export DataFrame to Excel
Export DataFrame to JSON
IF condition – DataFrame
Concatenate Column Values
Convert DataFrame to List
Sort Pandas DataFrame
Create Pivot Table
Remove Duplicates from Pandas DataFrame
Select Row from Pandas DataFrame
Union Pandas DataFrames
Plot DataFrame
Descriptive Statistics for Pandas DataFrame
Convert Strings to Floats in Pandas DataFrame
LEFT, RIGHT and MID and Pandas
Replace NaN Values with Zero’s
Load JSON String into DataFrame
Round Values in Pandas DataFrame
Count Duplicates in Pandas DataFrame
Sum each Column and Row in Pandas DataFrame
Add new column to Pandas DataFrame
Compare Values in two DataFrames
Join Pandas DataFrames using Merge
Convert String to Integer in Pandas DataFrame
Convert a List to DataFrame
Reset an Index in Pandas DataFrame
Rename Columns in Pandas DataFrame
Drop Rows with NaN Values in Pandas DataFrame
Pandas DataFrame to SQL
Convert CSV to Excel

Databases & SQL

Connect Python to MS Access
Connect Python to Oracle
Connect Python to SQL Server
Connect Python to MySQL

Create a Database using sqlite3
Use SQL in Python
Insert Values into MySQL

Insert Values into MS Access
Insert Values into SQL Server

Update values in MySQL
SQL to Pandas DataFrame
Delete Records from MS Access
Update Records in MS Access
Update Records in SQL Server

GUI – tkinter

Create GUI – tkinter
Yes/No message box
Place charts on GUI
Create an Entry Box

System, Installations and Upgrades

Install package – PIP
Install package – Anaconda

Install package – connection error
Uninstall package – PIP
Upgrade PIP – Anaconda
Upgrade PIP – Windows
System Dates

Current Date
Delete File or Folder
Rename a File using Python
Schedule Python Script using Windows Scheduler
Add Python to Windows Path
Create Executable using Pyinstaller
List all txt Files in a Directory
Take Screenshots using Python

Matplotlib

Create Charts – Matplotlib
Export Matplotlib Charts to PDF
Plot Histogram

Other

While Loop
IF, ELIF and ELSE
Concatenate and Slice Lists
Create a Calculator using Python
Create a List in Python
Modify a List in Python
Append an Item to a List in Python