Intermediate Python Programming¶

## WHAT YOU'LL BUILD (End of chapter!)
import pandas as pd

## 1. READ EXCEL (5 lines → 1M rows)
df = pd.read_excel('sales.xlsx')

## 2. COMPREHENSION MAGIC
high_profit_months = [month for month in df['Sales'] if month * 0.28 > 10000]

## 3. ERROR-SAFE WRITING
try:
    df.to_csv('automated_report.csv', index=False)
    print("✅ REPORT AUTOMATED!")
except Exception as e:
    print(f"⚠️  Handled: {e}")

## 4. BUSINESS INSIGHT
print(f"🎯 High-profit months: {len(high_profit_months)}")

## JUNIOR (Manual hell)
## Copy Excel → Paste → Formula × 50 → Save → Email

## INTERMEDIATE (5 lines → $100K automation)
sales_data = [25000, 28000, 32000, 12000, 35000]

## ONE LINE → ALL INSIGHTS
profits = [s * 0.28 - 8000 for s in sales_data]
high_profit_months = [p for p in profits if p > 5000]
growth_months = [s for s in sales_data if s > sales_data[sales_data.index(s)-1]]

print(f"💼 AUTOMATED INSIGHTS:")
print(f"   Total Profit: ${sum(profits):,.0f}")
print(f"   High-profit: {len(high_profit_months)} months")
print(f"   Growth: {len(growth_months)} months")

💼 AUTOMATED INSIGHTS:
   Total Profit: $13,600
   High-profit: 4 months
   Growth: 3 months

## Run this → See your POWER LEVEL!
print("⚡ INTERMEDIATE PYTHON READINESS TEST")
print("⏳ After this chapter, you'll master:")

skills = [
    "🔥 Comprehensions = 1-line analytics",
    "📁 File I/O = Excel automation",
    "🛡️  Error handling = Production ready",
    "📚 Libraries = Pandas power",
    "💼 Business formats = PDFs + APIs"
]

for skill in skills:
    print(skill)

print(f"\n🚀 YOUR PROGRESS: 0/{len(skills)} → {len(skills)}/{len(skills)}")
print("💪 READY TO AUTOMATE ENTIRE DEPARTMENTS!")

print("🎊" * 20)
print("INTERMEDIATE PYTHON = $120K+ ENGINEER UNLOCKED!")
print("💻 Companies TEST these EXACT skills!")
print("🚀 Your automation empire starts NOW!")
print("🎊" * 20)