Python Basics for Business - AiPro Institute™ | Empower People with AI Education

Python Basics for Business | AiPro Institute™

🚀 Getting Started with Python

Why Python for Business?

Python is the #1 language for data analysis, automation, and AI. It's beginner-friendly, powerful, and has libraries for virtually every business task—from analyzing sales data to automating reports to building AI applications.

✓ Easy to Learn

Readable syntax similar to English, gentle learning curve for non-programmers

📊 Data Analysis

Pandas, NumPy for Excel-like operations at scale

🤖 AI & ML Ready

TensorFlow, PyTorch, scikit-learn for machine learning

⚡ Automation

Automate repetitive tasks, reports, data processing

📈 Visualization

Matplotlib, Seaborn, Plotly for charts and dashboards

🌐 Web Scraping

Extract data from websites automatically

Installation & Setup

Option 1: Anaconda (Recommended for Beginners)

Download from: anaconda.com

Includes Python + 250+ data science packages
Comes with Jupyter Notebook (interactive coding environment)
No command line setup needed

Option 2: Python.org (Lightweight)

Download from: python.org

# After installation, install packages via command line:
pip install pandas numpy matplotlib jupyter

Option 3: Google Colab (No Installation)

Go to: colab.research.google.com

Free, browser-based Python environment
Pre-installed data science libraries
Free GPU access for machine learning

💡 Pro Tip: Start with Google Colab if you want to try Python immediately without installation. Switch to Anaconda when you're ready for local development.

📚 Python Fundamentals

Variables & Data Types

Beginner Essential

Basic Data Types

# Numbers
revenue = 150000        # Integer
price = 49.99          # Float (decimal)

# Strings (text)
company_name = "Acme Corp"
product = 'Premium Widget'

# Boolean (True/False)
is_active = True
has_discount = False

# Printing values
print(revenue)           # Output: 150000
print(company_name)      # Output: Acme Corp

Strings (Text Operations)

# String methods for business data email = "[email protected]" # Convert to uppercase/lowercase print(email.upper()) # [email protected] print(email.lower()) # [email protected] # Extract parts domain = email.split("@")[1] # company.com username = email.split("@")[0] # john.doe # Replace text clean_name = "John Doe".replace(" ", " ") # Remove extra spaces # Check if text contains something if "@" in email: print("Valid email format") # String formatting (f-strings) name = "Alice" amount = 1250.50 message = f"{name} owes ${amount:.2f}" # Alice owes $1250.50

Business Use Case: Email Validation & Cleaning

# Clean and validate customer emails customer_email = " [email protected] " # Clean: remove whitespace, convert to lowercase clean_email = customer_email.strip().lower() # Validate: check format if "@" in clean_email and "." in clean_email: print(f"Valid: {clean_email}") else: print("Invalid email")

Lists & Data Collections

Beginner Essential

Lists (Ordered Collections)

# Create a list
monthly_revenue = [45000, 52000, 48000, 61000, 55000]
product_names = ["Widget A", "Widget B", "Widget C"]

# Access items by index (0-based)
first_month = monthly_revenue[0]      # 45000
last_month = monthly_revenue[-1]      # 55000 (negative = from end)

# Add items
monthly_revenue.append(58000)       # Add to end
product_names.insert(0, "Widget Z")  # Insert at position 0

# Remove items
monthly_revenue.remove(48000)      # Remove specific value
product_names.pop()                 # Remove last item

# List operations
total_revenue = sum(monthly_revenue)
average_revenue = sum(monthly_revenue) / len(monthly_revenue)
max_revenue = max(monthly_revenue)
min_revenue = min(monthly_revenue)

# Slicing (get subsets)
first_three = monthly_revenue[0:3]    # [45000, 52000, 48000]
last_two = monthly_revenue[-2:]       # [61000, 55000]

Dictionaries (Key-Value Pairs)

# Create a dictionary (like a record/row) customer = { "name": "John Smith", "email": "[email protected]", "age": 35, "purchases": 12, "vip": True } # Access values by key print(customer["name"]) # John Smith print(customer["purchases"]) # 12 # Add or update values customer["phone"] = "555-1234" # Add new key customer["purchases"] = 13 # Update existing # Check if key exists if "email" in customer: print("Email found") # Get all keys and values keys = customer.keys() values = customer.values() items = customer.items() # Key-value pairs

Business Use Case: Sales Data Analysis

# Monthly sales by region
sales_by_region = {
    "North": [45000, 52000, 48000],
    "South": [38000, 41000, 39000],
    "East":  [51000, 55000, 53000],
    "West":  [42000, 44000, 46000]
}

# Calculate total per region
for region, sales in sales_by_region.items():
    total = sum(sales)
    average = total / len(sales)
    print(f"{region}: Total = ${total:,}, Avg = ${average:,.0f}")

OUTPUT: North: Total = $145,000, Avg = $48,333
South: Total = $118,000, Avg = $39,333
East: Total = $159,000, Avg = $53,000
West: Total = $132,000, Avg = $44,000

Control Flow (If, Loops)

Beginner

If Statements (Conditional Logic)

# Basic if-else
revenue = 75000

if revenue > 100000:
    print("Exceeded target!")
elif revenue > 50000:
    print("On track")
else:
    print("Below target")

# Multiple conditions
age = 35
income = 75000

if age > 30 and income > 50000:
    print("Target demographic")

if age < 25 or age > 65:
    print("Special discount eligible")

For Loops (Iterate Over Data)

# Loop through a list
products = ["Laptop", "Mouse", "Keyboard"]

for product in products:
    print(f"Product: {product}")

# Loop with index
for i, product in enumerate(products):
    print(f"{i+1}. {product}")

# Loop through a range of numbers
for year in range(2020, 2025):
    print(f"Year: {year}")

# Loop through dictionary
sales = {"Q1": 45000, "Q2": 52000, "Q3": 48000}

for quarter, amount in sales.items():
    print(f"{quarter}: ${amount:,}")

Business Use Case: Customer Segmentation

# Categorize customers based on purchase amount
customers = [
    {"name": "Alice", "total_spent": 1200},
    {"name": "Bob", "total_spent": 350},
    {"name": "Carol", "total_spent": 5500}
]

for customer in customers:
    name = customer["name"]
    spent = customer["total_spent"]
    
    if spent > 5000:
        tier = "VIP"
    elif spent > 1000:
        tier = "Gold"
    else:
        tier = "Silver"
    
    print(f"{name}: {tier} (${spent:,})")

OUTPUT: Alice: Gold ($1,200)
Bob: Silver ($350)
Carol: VIP ($5,500)

Functions (Reusable Code)

Intermediate

Defining & Using Functions

# Define a function
def calculate_profit(revenue, costs):
    profit = revenue - costs
    margin = (profit / revenue) * 100
    return profit, margin

# Use the function
revenue = 150000
costs = 95000
profit, margin = calculate_profit(revenue, costs)

print(f"Profit: ${profit:,}")
print(f"Margin: {margin:.1f}%")

Function with Default Parameters

# Function with default tax rate
def calculate_total(price, quantity, tax_rate=0.08):
    subtotal = price * quantity
    tax = subtotal * tax_rate
    total = subtotal + tax
    return total

# Use default tax rate
total1 = calculate_total(49.99, 3)

# Override tax rate
total2 = calculate_total(49.99, 3, tax_rate=0.10)

Business Use Case: Discount Calculator

def apply_discount(price, customer_tier):
    """Calculate price after discount based on customer tier"""
    
    discounts = {
        "VIP": 0.20,      # 20% off
        "Gold": 0.15,     # 15% off
        "Silver": 0.05    # 5% off
    }
    
    discount_rate = discounts.get(customer_tier, 0)
    discount_amount = price * discount_rate
    final_price = price - discount_amount
    
    return final_price, discount_amount

# Test the function
original_price = 100
final, saved = apply_discount(original_price, "VIP")
print(f"Final price: ${final}, Saved: ${saved}")

📊 Data Analysis with Pandas

Introduction to Pandas

Pandas is Python's primary library for data analysis—think "Excel on steroids". It handles spreadsheet-like data with powerful operations.

Import Pandas & Create DataFrame

import pandas as pd

# Create DataFrame from dictionary
data = {
    "Product": ["Laptop", "Mouse", "Keyboard", "Monitor"],
    "Price": [899, 25, 75, 299],
    "Units_Sold": [45, 230, 150, 65],
    "Category": ["Electronics", "Accessories", "Accessories", "Electronics"]
}

df = pd.DataFrame(data)
print(df)

OUTPUT:

     Product  Price  Units_Sold     Category
0     Laptop    899          45  Electronics
1      Mouse     25         230  Accessories
2   Keyboard     75         150  Accessories
3    Monitor    299          65  Electronics

Reading Data from Files

# Read CSV file
df = pd.read_csv("sales_data.csv")

# Read Excel file
df = pd.read_excel("sales_data.xlsx", sheet_name="Sheet1")

# Read from URL
url = "https://example.com/data.csv"
df = pd.read_csv(url)

# Basic inspection
print(df.head())        # First 5 rows
print(df.tail())        # Last 5 rows
print(df.info())        # Data types and missing values
print(df.describe())    # Statistical summary

Data Selection & Filtering

Selecting Columns & Rows

# Select single column
prices = df["Price"]

# Select multiple columns
subset = df[["Product", "Price"]]

# Select rows by index
first_row = df.iloc[0]          # First row
first_three = df.iloc[0:3]      # Rows 0-2

# Filter rows by condition
expensive = df[df["Price"] > 100]
electronics = df[df["Category"] == "Electronics"]

# Multiple conditions
high_volume = df[(df["Price"] > 100) & (df["Units_Sold"] > 50)]

Adding & Calculating Columns

# Add new column with calculation
df["Revenue"] = df["Price"] * df["Units_Sold"]

# Add column with conditional logic
df["Price_Category"] = df["Price"].apply(
    lambda x: "Premium" if x > 500 else "Standard"
)

# Percentage calculation
total_revenue = df["Revenue"].sum()
df["Revenue_Share"] = (df["Revenue"] / total_revenue) * 100

Grouping & Aggregation

Group By Operations

# Group by category and calculate totals
category_summary = df.groupby("Category").agg({
    "Revenue": "sum",
    "Units_Sold": "sum",
    "Price": "mean"
})

print(category_summary)

# Multiple aggregations on same column
sales_stats = df.groupby("Category")["Revenue"].agg([
    "sum", "mean", "min", "max", "count"
])

Business Use Case: Monthly Sales Report

import pandas as pd

# Sample sales data
data = {
    "Date": ["2024-01-15", "2024-01-20", "2024-02-10", "2024-02-25"],
    "Product": ["Laptop", "Mouse", "Laptop", "Keyboard"],
    "Revenue": [45000, 5000, 35000, 7500]
}

df = pd.DataFrame(data)
df["Date"] = pd.to_datetime(df["Date"])

# Extract month and create monthly report
df["Month"] = df["Date"].dt.strftime("%Y-%m")

monthly_report = df.groupby("Month").agg({
    "Revenue": ["sum", "mean"],
    "Product": "count"
}).round(2)

print(monthly_report)

Data Cleaning

Handling Missing Data

# Check for missing values
print(df.isnull().sum())

# Drop rows with any missing values
df_clean = df.dropna()

# Fill missing values
df["Price"].fillna(0, inplace=True)          # Fill with 0
df["Price"].fillna(df["Price"].mean(), inplace=True)  # Fill with average

# Drop duplicates
df_unique = df.drop_duplicates()

Data Type Conversion

# Convert to numeric (handles errors)
df["Price"] = pd.to_numeric(df["Price"], errors="coerce")

# Convert to datetime
df["Date"] = pd.to_datetime(df["Date"])

# Convert to string
df["Customer_ID"] = df["Customer_ID"].astype(str)

Exporting Data

Save to Files

# Save to CSV
df.to_csv("output.csv", index=False)

# Save to Excel
df.to_excel("output.xlsx", sheet_name="Sales", index=False)

# Save multiple sheets to Excel
with pd.ExcelWriter("report.xlsx") as writer:
    df.to_excel(writer, sheet_name="Raw_Data")
    summary.to_excel(writer, sheet_name="Summary")

📈 Data Visualization

Basic Plotting with Matplotlib

Line Chart

import matplotlib.pyplot as plt

# Sample data
months = ["Jan", "Feb", "Mar", "Apr", "May"]
revenue = [45000, 52000, 48000, 61000, 55000]

# Create line chart
plt.figure(figsize=(10, 6))
plt.plot(months, revenue, marker="o", linewidth=2, color="#7B3FF2")
plt.title("Monthly Revenue Trend", fontsize=16)
plt.xlabel("Month")
plt.ylabel("Revenue ($)")
plt.grid(True, alpha=0.3)
plt.show()

Bar Chart

# Sample data
products = ["Laptop", "Mouse", "Keyboard", "Monitor"]
sales = [45, 230, 150, 65]

# Create bar chart
plt.figure(figsize=(10, 6))
plt.bar(products, sales, color=["#7B3FF2", "#00A8E8", "#9C27B0", "#4CAF50"])
plt.title("Units Sold by Product", fontsize=16)
plt.xlabel("Product")
plt.ylabel("Units Sold")
plt.show()

Pandas Built-in Plotting

# Plot directly from DataFrame
df.plot(x="Product", y="Revenue", kind="bar", figsize=(10,6))
plt.show()

# Multiple plots
df.plot(x="Month", y=["Revenue", "Costs"], kind="line")
plt.show()

# Pie chart
df.groupby("Category")["Revenue"].sum().plot(kind="pie", autopct="%1.1f%%")
plt.show()

💼 Real-World Business Examples

Example 1: Sales Performance Dashboard

import pandas as pd

# Load sales data
df = pd.read_csv("sales_2024.csv")
df["Date"] = pd.to_datetime(df["Date"])

# Calculate key metrics
total_revenue = df["Revenue"].sum()
avg_order_value = df["Revenue"].mean()
total_orders = len(df)

# Monthly performance
df["Month"] = df["Date"].dt.to_period("M")
monthly = df.groupby("Month").agg({
    "Revenue": "sum",
    "Order_ID": "count"
})

# Calculate growth rate
monthly["Growth_Rate"] = monthly["Revenue"].pct_change() * 100

# Top 5 products
top_products = df.groupby("Product")["Revenue"].sum().sort_values(ascending=False).head(5)

# Create summary report
print(f"=== Sales Performance Report ===")
print(f"Total Revenue: ${total_revenue:,.2f}")
print(f"Average Order Value: ${avg_order_value:,.2f}")
print(f"Total Orders: {total_orders:,}")
print(f"\nTop 5 Products:")
print(top_products)

Example 2: Customer Churn Analysis

import pandas as pd

# Load customer data
df = pd.read_csv("customers.csv")

# Calculate churn indicators
df["Days_Since_Purchase"] = (pd.Timestamp.now() - pd.to_datetime(df["Last_Purchase"])).dt.days

# Define churn (no purchase in 90 days)
df["Is_Churned"] = df["Days_Since_Purchase"] > 90

# Churn analysis by segment
churn_by_segment = df.groupby("Customer_Segment")["Is_Churned"].mean() * 100

# At-risk customers (60-90 days)
at_risk = df[(df["Days_Since_Purchase"] > 60) & 
             (df["Days_Since_Purchase"] <= 90)]

# High-value at-risk customers
priority_outreach = at_risk[at_risk["Lifetime_Value"] > 1000].sort_values(
    "Lifetime_Value", ascending=False
)

# Export for retention campaign
priority_outreach[["Customer_ID", "Email", "Lifetime_Value"]].to_csv(
    "retention_campaign.csv", index=False
)

Example 3: Inventory Optimization

import pandas as pd

# Load inventory and sales data
inventory = pd.read_csv("inventory.csv")
sales = pd.read_csv("sales_history.csv")

# Calculate average daily sales
daily_sales = sales.groupby("Product_ID")["Units_Sold"].mean()

# Merge with current inventory
inventory = inventory.merge(daily_sales, on="Product_ID", how="left")

# Calculate days of inventory remaining
inventory["Days_Remaining"] = inventory["Current_Stock"] / inventory["Units_Sold"]

# Identify low stock items (< 14 days)
low_stock = inventory[inventory["Days_Remaining"] < 14].sort_values("Days_Remaining")

# Calculate reorder quantities
lead_time_days = 7
safety_stock_days = 7

inventory["Reorder_Quantity"] = (
    inventory["Units_Sold"] * (lead_time_days + safety_stock_days) - 
    inventory["Current_Stock"]
)

# Generate purchase order
purchase_order = inventory[inventory["Reorder_Quantity"] > 0][[
    "Product_ID", "Product_Name", "Reorder_Quantity", "Supplier"
]]

purchase_order.to_csv("purchase_order.csv", index=False)

📖 Quick Reference Cheat Sheet

Task	Code	Example
Read CSV	`pd.read_csv("file.csv")`	Load data from Excel export
Filter Rows	`df[df["Column"] > 100]`	Get all sales > $100
Group & Sum	`df.groupby("Category")["Sales"].sum()`	Total sales per category
Add Column	`df["New"] = df["A"] * df["B"]`	Calculate revenue = price × quantity
Sort Data	`df.sort_values("Sales", ascending=False)`	Highest sales first
Remove Duplicates	`df.drop_duplicates()`	Clean duplicate entries
Fill Missing	`df["Price"].fillna(0)`	Replace blanks with 0
Export to Excel	`df.to_excel("output.xlsx")`	Save results to Excel
Basic Stats	`df.describe()`	Mean, median, min, max
Count Values	`df["Category"].value_counts()`	Count items per category

📚 Learning Path & Resources

Recommended Learning Sequence

Week 1-2: Python basics (variables, lists, loops, functions)
Week 3-4: Pandas fundamentals (reading data, filtering, basic operations)
Week 5-6: Data analysis (grouping, aggregation, cleaning)
Week 7-8: Visualization (Matplotlib basics, charts)
Week 9-12: Real projects (automate your actual work tasks)

Free Resources

Python.org Tutorial: Official beginner guide
Google Colab: Free online Python environment
Pandas Documentation: Comprehensive examples
Real Python: Practical tutorials for business users
Kaggle Learn: Free micro-courses on data analysis

💡 Best Way to Learn: Start with a real problem from your work. Automate one repetitive task—even if it's just cleaning an Excel file. The best learning happens when you're solving actual problems.

🐍 Python Basics for Business