{"id":3224,"date":"2026-01-13T16:06:06","date_gmt":"2026-01-13T08:06:06","guid":{"rendered":"https:\/\/teen.aiproinstitute.com\/?p=3224"},"modified":"2026-01-13T16:10:38","modified_gmt":"2026-01-13T08:10:38","slug":"python-basics-for-business","status":"publish","type":"post","link":"https:\/\/teen.aiproinstitute.com\/zh\/python-basics-for-business\/","title":{"rendered":"Python Basics for Business"},"content":{"rendered":"
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\n\n\n \n \n Python Basics for Business | AiPro Institute\u2122<\/title>\n <style>\n * {\n margin: 0;\n padding: 0;\n box-sizing: border-box;\n }\n\n body {\n font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;\n background: #ffffff;\n color: #333;\n line-height: 1.6;\n padding: 20px;\n }\n\n .container {\n max-width: 1400px;\n margin: 0 auto;\n background: white;\n padding: 40px;\n box-shadow: 0 0 20px rgba(0,0,0,0.1);\n }\n\n .header {\n background: linear-gradient(135deg, #7B3FF2 0%, #00A8E8 100%);\n color: white;\n padding: 40px;\n border-radius: 10px;\n margin-bottom: 30px;\n text-align: center;\n }\n\n .header h1 {\n font-size: 2.5em;\n margin-bottom: 10px;\n font-weight: 700;\n }\n\n .header .subtitle {\n font-size: 1.2em;\n opacity: 0.95;\n font-weight: 300;\n }\n\n .member-badge {\n display: inline-block;\n background: rgba(255,255,255,0.2);\n padding: 8px 20px;\n border-radius: 20px;\n margin-top: 15px;\n font-size: 0.9em;\n font-weight: 500;\n }\n\n .section {\n margin-bottom: 40px;\n }\n\n .section-header {\n background: linear-gradient(135deg, #7B3FF2 0%, #00A8E8 100%);\n color: white;\n padding: 20px 30px;\n border-radius: 8px;\n margin-bottom: 20px;\n font-size: 1.8em;\n font-weight: 600;\n }\n\n .subsection {\n margin-bottom: 30px;\n background: #f8f9fa;\n padding: 25px;\n border-radius: 8px;\n border-left: 5px solid #7B3FF2;\n }\n\n .subsection h3 {\n color: #7B3FF2;\n font-size: 1.5em;\n margin-bottom: 15px;\n font-weight: 600;\n }\n\n .code-card {\n background: white;\n padding: 25px;\n margin-bottom: 20px;\n border-radius: 8px;\n border: 2px solid #e0e0e0;\n transition: all 0.3s ease;\n }\n\n .code-card:hover {\n border-color: #7B3FF2;\n box-shadow: 0 4px 12px rgba(123, 63, 242, 0.1);\n }\n\n .code-card h4 {\n color: #00A8E8;\n font-size: 1.3em;\n margin-bottom: 15px;\n font-weight: 600;\n }\n\n .code-block {\n background: #1e1e1e;\n color: #d4d4d4;\n padding: 20px;\n border-radius: 8px;\n overflow-x: auto;\n font-family: 'Courier New', monospace;\n margin: 15px 0;\n font-size: 0.9em;\n line-height: 1.7;\n }\n\n .code-comment {\n color: #6a9955;\n }\n\n .code-keyword {\n color: #569cd6;\n }\n\n .code-string {\n color: #ce9178;\n }\n\n .code-function {\n color: #dcdcaa;\n }\n\n .code-number {\n color: #b5cea8;\n }\n\n .output-block {\n background: #f0f0f0;\n padding: 15px;\n border-radius: 8px;\n margin: 15px 0;\n border-left: 4px solid #4caf50;\n font-family: 'Courier New', monospace;\n }\n\n .output-label {\n color: #2e7d32;\n font-weight: bold;\n display: block;\n margin-bottom: 8px;\n }\n\n .comparison-table {\n width: 100%;\n border-collapse: collapse;\n margin: 20px 0;\n background: white;\n box-shadow: 0 2px 8px rgba(0,0,0,0.1);\n }\n\n .comparison-table th {\n background: linear-gradient(135deg, #7B3FF2 0%, #00A8E8 100%);\n color: white;\n padding: 15px;\n text-align: left;\n font-weight: 600;\n }\n\n .comparison-table td {\n padding: 15px;\n border-bottom: 1px solid #e0e0e0;\n vertical-align: top;\n }\n\n .comparison-table tr:hover {\n background: #f8f9fa;\n }\n\n .best-practice {\n background: #e3f2fd;\n border-left: 5px solid #2196f3;\n padding: 15px;\n margin: 15px 0;\n border-radius: 5px;\n }\n\n .best-practice strong {\n color: #1565c0;\n }\n\n .pro-tip {\n background: #e8f5e9;\n border-left: 5px solid #4caf50;\n padding: 15px;\n margin: 15px 0;\n border-radius: 5px;\n }\n\n .pro-tip strong {\n color: #2e7d32;\n }\n\n .warning-box {\n background: #fff3e0;\n border-left: 5px solid #ff9800;\n padding: 15px;\n margin: 15px 0;\n border-radius: 5px;\n }\n\n .warning-box strong {\n color: #e65100;\n }\n\n .use-case-box {\n background: linear-gradient(135deg, rgba(123, 63, 242, 0.05) 0%, rgba(0, 168, 232, 0.05) 100%);\n padding: 20px;\n border-radius: 8px;\n margin: 15px 0;\n border-left: 4px solid #7B3FF2;\n }\n\n .use-case-box h5 {\n color: #7B3FF2;\n margin-bottom: 10px;\n font-size: 1.1em;\n }\n\n .tag {\n display: inline-block;\n background: #7B3FF2;\n color: white;\n padding: 5px 12px;\n border-radius: 15px;\n font-size: 0.85em;\n margin: 5px 5px 5px 0;\n font-weight: 500;\n }\n\n .tag.beginner { background: #4caf50; }\n .tag.intermediate { background: #ff9800; }\n .tag.advanced { background: #f44336; }\n .tag.essential { background: #9c27b0; }\n\n .cheatsheet-grid {\n display: grid;\n grid-template-columns: repeat(auto-fit, minmax(300px, 1fr));\n gap: 20px;\n margin: 20px 0;\n }\n\n .cheatsheet-card {\n background: white;\n padding: 20px;\n border-radius: 8px;\n border: 2px solid #e0e0e0;\n }\n\n .cheatsheet-card h4 {\n color: #7B3FF2;\n margin-bottom: 12px;\n font-size: 1.1em;\n }\n\n ul, ol {\n margin-left: 20px;\n margin-top: 10px;\n }\n\n ul li, ol li {\n margin-bottom: 8px;\n }\n\n footer {\n margin-top: 50px;\n padding-top: 30px;\n border-top: 3px solid #7B3FF2;\n text-align: center;\n color: #666;\n }\n\n .footer-logo {\n font-size: 1.5em;\n font-weight: 700;\n background: linear-gradient(135deg, #7B3FF2 0%, #00A8E8 100%);\n -webkit-background-clip: text;\n -webkit-text-fill-color: transparent;\n background-clip: text;\n margin-bottom: 10px;\n }\n\n @media (max-width: 768px) {\n .container {\n padding: 20px;\n }\n\n .header h1 {\n font-size: 1.8em;\n }\n\n .section-header {\n font-size: 1.4em;\n padding: 15px 20px;\n }\n\n .cheatsheet-grid {\n grid-template-columns: 1fr;\n }\n }\n <\/style>\n<\/head>\n<body>\n <div class=\"container\">\n <div class=\"header\">\n <h1>\ud83d\udc0d Python Basics for Business<\/h1>\n <div class=\"subtitle\">Essential Python Skills for Business Professionals & Data Analysis<\/div>\n <div class=\"member-badge\">AiPro Institute\u2122 Members Only<\/div>\n <\/div>\n\n <!-- Getting Started -->\n <div class=\"section\">\n <div class=\"section-header\">\ud83d\ude80 Getting Started with Python<\/div>\n\n <div class=\"subsection\">\n <h3>Why Python for Business?<\/h3>\n <p style=\"font-size: 1.05em; margin-bottom: 15px;\">\n Python is the #1 language for data analysis, automation, and AI. It's beginner-friendly, powerful, and has libraries for virtually every business task\u2014from analyzing sales data to automating reports to building AI applications.\n <\/p>\n\n <div class=\"cheatsheet-grid\">\n <div class=\"cheatsheet-card\">\n <h4>\u2713 Easy to Learn<\/h4>\n <p>Readable syntax similar to English, gentle learning curve for non-programmers<\/p>\n <\/div>\n <div class=\"cheatsheet-card\">\n <h4>\ud83d\udcca Data Analysis<\/h4>\n <p>Pandas, NumPy for Excel-like operations at scale<\/p>\n <\/div>\n <div class=\"cheatsheet-card\">\n <h4>\ud83e\udd16 AI & ML Ready<\/h4>\n <p>TensorFlow, PyTorch, scikit-learn for machine learning<\/p>\n <\/div>\n <div class=\"cheatsheet-card\">\n <h4>\u26a1 Automation<\/h4>\n <p>Automate repetitive tasks, reports, data processing<\/p>\n <\/div>\n <div class=\"cheatsheet-card\">\n <h4>\ud83d\udcc8 Visualization<\/h4>\n <p>Matplotlib, Seaborn, Plotly for charts and dashboards<\/p>\n <\/div>\n <div class=\"cheatsheet-card\">\n <h4>\ud83c\udf10 Web Scraping<\/h4>\n <p>Extract data from websites automatically<\/p>\n <\/div>\n <\/div>\n <\/div>\n\n <div class=\"subsection\">\n <h3>Installation & Setup<\/h3>\n \n <div class=\"code-card\">\n <h4>Option 1: Anaconda (Recommended for Beginners)<\/h4>\n <p>Download from: <strong>anaconda.com<\/strong><\/p>\n <ul>\n <li>Includes Python + 250+ data science packages<\/li>\n <li>Comes with Jupyter Notebook (interactive coding environment)<\/li>\n <li>No command line setup needed<\/li>\n <\/ul>\n <\/div>\n\n <div class=\"code-card\">\n <h4>Option 2: Python.org (Lightweight)<\/h4>\n <p>Download from: <strong>python.org<\/strong><\/p>\n <div class=\"code-block\">\n<span class=\"code-comment\"># After installation, install packages via command line:<\/span>\npip install pandas numpy matplotlib jupyter<\/div>\n <\/div>\n\n <div class=\"code-card\">\n <h4>Option 3: Google Colab (No Installation)<\/h4>\n <p>Go to: <strong>colab.research.google.com<\/strong><\/p>\n <ul>\n <li>Free, browser-based Python environment<\/li>\n <li>Pre-installed data science libraries<\/li>\n <li>Free GPU access for machine learning<\/li>\n <\/ul>\n <\/div>\n\n <div class=\"pro-tip\">\n <strong>\ud83d\udca1 Pro Tip:<\/strong> Start with Google Colab if you want to try Python immediately without installation. Switch to Anaconda when you're ready for local development.\n <\/div>\n <\/div>\n <\/div>\n\n <!-- Python Fundamentals -->\n <div class=\"section\">\n <div class=\"section-header\">\ud83d\udcda Python Fundamentals<\/div>\n\n <div class=\"subsection\">\n <h3>Variables & Data Types<\/h3>\n <span class=\"tag beginner\">Beginner<\/span>\n <span class=\"tag essential\">Essential<\/span>\n\n <div class=\"code-card\">\n <h4>Basic Data Types<\/h4>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Numbers<\/span>\nrevenue = <span class=\"code-number\">150000<\/span> <span class=\"code-comment\"># Integer<\/span>\nprice = <span class=\"code-number\">49.99<\/span> <span class=\"code-comment\"># Float (decimal)<\/span>\n\n<span class=\"code-comment\"># Strings (text)<\/span>\ncompany_name = <span class=\"code-string\">\"Acme Corp\"<\/span>\nproduct = <span class=\"code-string\">'Premium Widget'<\/span>\n\n<span class=\"code-comment\"># Boolean (True\/False)<\/span>\nis_active = <span class=\"code-keyword\">True<\/span>\nhas_discount = <span class=\"code-keyword\">False<\/span>\n\n<span class=\"code-comment\"># Printing values<\/span>\n<span class=\"code-function\">print<\/span>(revenue) <span class=\"code-comment\"># Output: 150000<\/span>\n<span class=\"code-function\">print<\/span>(company_name) <span class=\"code-comment\"># Output: Acme Corp<\/span><\/div>\n <\/div>\n\n <div class=\"code-card\">\n <h4>Strings (Text Operations)<\/h4>\n <div class=\"code-block\">\n<span class=\"code-comment\"># String methods for business data<\/span>\nemail = <span class=\"code-string\">\"<a href=\"\/cdn-cgi\/l\/email-protection\" class=\"__cf_email__\" data-cfemail=\"741e1b1c1a5a101b1134171b1904151a0d5a171b19\">[email protected]<\/a>\"<\/span>\n\n<span class=\"code-comment\"># Convert to uppercase\/lowercase<\/span>\n<span class=\"code-function\">print<\/span>(email.<span class=\"code-function\">upper<\/span>()) <span class=\"code-comment\"># <a href=\"\/cdn-cgi\/l\/email-protection\" class=\"__cf_email__\" data-cfemail=\"ce84818680e08a818b8e8d81839e8f8097e08d8183\">[email protected]<\/a><\/span>\n<span class=\"code-function\">print<\/span>(email.<span class=\"code-function\">lower<\/span>()) <span class=\"code-comment\"># <a href=\"\/cdn-cgi\/l\/email-protection\" class=\"__cf_email__\" data-cfemail=\"0963666167276d666c496a666479686770276a6664\">[email protected]<\/a><\/span>\n\n<span class=\"code-comment\"># Extract parts<\/span>\ndomain = email.<span class=\"code-function\">split<\/span>(<span class=\"code-string\">\"@\"<\/span>)[<span class=\"code-number\">1<\/span>] <span class=\"code-comment\"># company.com<\/span>\nusername = email.<span class=\"code-function\">split<\/span>(<span class=\"code-string\">\"@\"<\/span>)[<span class=\"code-number\">0<\/span>] <span class=\"code-comment\"># john.doe<\/span>\n\n<span class=\"code-comment\"># Replace text<\/span>\nclean_name = <span class=\"code-string\">\"John Doe\"<\/span>.<span class=\"code-function\">replace<\/span>(<span class=\"code-string\">\" \"<\/span>, <span class=\"code-string\">\" \"<\/span>) <span class=\"code-comment\"># Remove extra spaces<\/span>\n\n<span class=\"code-comment\"># Check if text contains something<\/span>\n<span class=\"code-keyword\">if<\/span> <span class=\"code-string\">\"@\"<\/span> <span class=\"code-keyword\">in<\/span> email:\n <span class=\"code-function\">print<\/span>(<span class=\"code-string\">\"Valid email format\"<\/span>)\n\n<span class=\"code-comment\"># String formatting (f-strings)<\/span>\nname = <span class=\"code-string\">\"Alice\"<\/span>\namount = <span class=\"code-number\">1250.50<\/span>\nmessage = <span class=\"code-string\">f\"<span class=\"code-keyword\">{name}<\/span> owes $<span class=\"code-keyword\">{amount:.2f}<\/span>\"<\/span> <span class=\"code-comment\"># Alice owes $1250.50<\/span><\/div>\n <\/div>\n\n <div class=\"use-case-box\">\n <h5>Business Use Case: Email Validation & Cleaning<\/h5>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Clean and validate customer emails<\/span>\ncustomer_email = <span class=\"code-string\">\" <a href=\"\/cdn-cgi\/l\/email-protection\" class=\"__cf_email__\" data-cfemail=\"66270a0f050348350b0f120e2625292b3627283f4825292b\">[email protected]<\/a> \"<\/span>\n\n<span class=\"code-comment\"># Clean: remove whitespace, convert to lowercase<\/span>\nclean_email = customer_email.<span class=\"code-function\">strip<\/span>().<span class=\"code-function\">lower<\/span>()\n\n<span class=\"code-comment\"># Validate: check format<\/span>\n<span class=\"code-keyword\">if<\/span> <span class=\"code-string\">\"@\"<\/span> <span class=\"code-keyword\">in<\/span> clean_email <span class=\"code-keyword\">and<\/span> <span class=\"code-string\">\".\"<\/span> <span class=\"code-keyword\">in<\/span> clean_email:\n <span class=\"code-function\">print<\/span>(<span class=\"code-string\">f\"Valid: <span class=\"code-keyword\">{clean_email}<\/span>\"<\/span>)\n<span class=\"code-keyword\">else<\/span>:\n <span class=\"code-function\">print<\/span>(<span class=\"code-string\">\"Invalid email\"<\/span>)<\/div>\n <\/div>\n <\/div>\n\n <div class=\"subsection\">\n <h3>Lists & Data Collections<\/h3>\n <span class=\"tag beginner\">Beginner<\/span>\n <span class=\"tag essential\">Essential<\/span>\n\n <div class=\"code-card\">\n <h4>Lists (Ordered Collections)<\/h4>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Create a list<\/span>\nmonthly_revenue = [<span class=\"code-number\">45000<\/span>, <span class=\"code-number\">52000<\/span>, <span class=\"code-number\">48000<\/span>, <span class=\"code-number\">61000<\/span>, <span class=\"code-number\">55000<\/span>]\nproduct_names = [<span class=\"code-string\">\"Widget A\"<\/span>, <span class=\"code-string\">\"Widget B\"<\/span>, <span class=\"code-string\">\"Widget C\"<\/span>]\n\n<span class=\"code-comment\"># Access items by index (0-based)<\/span>\nfirst_month = monthly_revenue[<span class=\"code-number\">0<\/span>] <span class=\"code-comment\"># 45000<\/span>\nlast_month = monthly_revenue[<span class=\"code-number\">-1<\/span>] <span class=\"code-comment\"># 55000 (negative = from end)<\/span>\n\n<span class=\"code-comment\"># Add items<\/span>\nmonthly_revenue.<span class=\"code-function\">append<\/span>(<span class=\"code-number\">58000<\/span>) <span class=\"code-comment\"># Add to end<\/span>\nproduct_names.<span class=\"code-function\">insert<\/span>(<span class=\"code-number\">0<\/span>, <span class=\"code-string\">\"Widget Z\"<\/span>) <span class=\"code-comment\"># Insert at position 0<\/span>\n\n<span class=\"code-comment\"># Remove items<\/span>\nmonthly_revenue.<span class=\"code-function\">remove<\/span>(<span class=\"code-number\">48000<\/span>) <span class=\"code-comment\"># Remove specific value<\/span>\nproduct_names.<span class=\"code-function\">pop<\/span>() <span class=\"code-comment\"># Remove last item<\/span>\n\n<span class=\"code-comment\"># List operations<\/span>\ntotal_revenue = <span class=\"code-function\">sum<\/span>(monthly_revenue)\naverage_revenue = <span class=\"code-function\">sum<\/span>(monthly_revenue) \/ <span class=\"code-function\">len<\/span>(monthly_revenue)\nmax_revenue = <span class=\"code-function\">max<\/span>(monthly_revenue)\nmin_revenue = <span class=\"code-function\">min<\/span>(monthly_revenue)\n\n<span class=\"code-comment\"># Slicing (get subsets)<\/span>\nfirst_three = monthly_revenue[<span class=\"code-number\">0<\/span>:<span class=\"code-number\">3<\/span>] <span class=\"code-comment\"># [45000, 52000, 48000]<\/span>\nlast_two = monthly_revenue[<span class=\"code-number\">-2<\/span>:] <span class=\"code-comment\"># [61000, 55000]<\/span><\/div>\n <\/div>\n\n <div class=\"code-card\">\n <h4>Dictionaries (Key-Value Pairs)<\/h4>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Create a dictionary (like a record\/row)<\/span>\ncustomer = {\n <span class=\"code-string\">\"name\"<\/span>: <span class=\"code-string\">\"John Smith\"<\/span>,\n <span class=\"code-string\">\"email\"<\/span>: <span class=\"code-string\">\"<a href=\"\/cdn-cgi\/l\/email-protection\" class=\"__cf_email__\" data-cfemail=\"9df7f2f5f3ddf8f0fcf4f1b3fef2f0\">[email protected]<\/a>\"<\/span>,\n <span class=\"code-string\">\"age\"<\/span>: <span class=\"code-number\">35<\/span>,\n <span class=\"code-string\">\"purchases\"<\/span>: <span class=\"code-number\">12<\/span>,\n <span class=\"code-string\">\"vip\"<\/span>: <span class=\"code-keyword\">True<\/span>\n}\n\n<span class=\"code-comment\"># Access values by key<\/span>\n<span class=\"code-function\">print<\/span>(customer[<span class=\"code-string\">\"name\"<\/span>]) <span class=\"code-comment\"># John Smith<\/span>\n<span class=\"code-function\">print<\/span>(customer[<span class=\"code-string\">\"purchases\"<\/span>]) <span class=\"code-comment\"># 12<\/span>\n\n<span class=\"code-comment\"># Add or update values<\/span>\ncustomer[<span class=\"code-string\">\"phone\"<\/span>] = <span class=\"code-string\">\"555-1234\"<\/span> <span class=\"code-comment\"># Add new key<\/span>\ncustomer[<span class=\"code-string\">\"purchases\"<\/span>] = <span class=\"code-number\">13<\/span> <span class=\"code-comment\"># Update existing<\/span>\n\n<span class=\"code-comment\"># Check if key exists<\/span>\n<span class=\"code-keyword\">if<\/span> <span class=\"code-string\">\"email\"<\/span> <span class=\"code-keyword\">in<\/span> customer:\n <span class=\"code-function\">print<\/span>(<span class=\"code-string\">\"Email found\"<\/span>)\n\n<span class=\"code-comment\"># Get all keys and values<\/span>\nkeys = customer.<span class=\"code-function\">keys<\/span>()\nvalues = customer.<span class=\"code-function\">values<\/span>()\nitems = customer.<span class=\"code-function\">items<\/span>() <span class=\"code-comment\"># Key-value pairs<\/span><\/div>\n <\/div>\n\n <div class=\"use-case-box\">\n <h5>Business Use Case: Sales Data Analysis<\/h5>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Monthly sales by region<\/span>\nsales_by_region = {\n <span class=\"code-string\">\"North\"<\/span>: [<span class=\"code-number\">45000<\/span>, <span class=\"code-number\">52000<\/span>, <span class=\"code-number\">48000<\/span>],\n <span class=\"code-string\">\"South\"<\/span>: [<span class=\"code-number\">38000<\/span>, <span class=\"code-number\">41000<\/span>, <span class=\"code-number\">39000<\/span>],\n <span class=\"code-string\">\"East\"<\/span>: [<span class=\"code-number\">51000<\/span>, <span class=\"code-number\">55000<\/span>, <span class=\"code-number\">53000<\/span>],\n <span class=\"code-string\">\"West\"<\/span>: [<span class=\"code-number\">42000<\/span>, <span class=\"code-number\">44000<\/span>, <span class=\"code-number\">46000<\/span>]\n}\n\n<span class=\"code-comment\"># Calculate total per region<\/span>\n<span class=\"code-keyword\">for<\/span> region, sales <span class=\"code-keyword\">in<\/span> sales_by_region.<span class=\"code-function\">items<\/span>():\n total = <span class=\"code-function\">sum<\/span>(sales)\n average = total \/ <span class=\"code-function\">len<\/span>(sales)\n <span class=\"code-function\">print<\/span>(<span class=\"code-string\">f\"<span class=\"code-keyword\">{region}<\/span>: Total = $<span class=\"code-keyword\">{total:,}<\/span>, Avg = $<span class=\"code-keyword\">{average:,.0f}<\/span>\"<\/span>)<\/div>\n \n <div class=\"output-block\">\n <span class=\"output-label\">OUTPUT:<\/span>\nNorth: Total = $145,000, Avg = $48,333<br>\nSouth: Total = $118,000, Avg = $39,333<br>\nEast: Total = $159,000, Avg = $53,000<br>\nWest: Total = $132,000, Avg = $44,000\n <\/div>\n <\/div>\n <\/div>\n\n <div class=\"subsection\">\n <h3>Control Flow (If, Loops)<\/h3>\n <span class=\"tag beginner\">Beginner<\/span>\n\n <div class=\"code-card\">\n <h4>If Statements (Conditional Logic)<\/h4>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Basic if-else<\/span>\nrevenue = <span class=\"code-number\">75000<\/span>\n\n<span class=\"code-keyword\">if<\/span> revenue > <span class=\"code-number\">100000<\/span>:\n <span class=\"code-function\">print<\/span>(<span class=\"code-string\">\"Exceeded target!\"<\/span>)\n<span class=\"code-keyword\">elif<\/span> revenue > <span class=\"code-number\">50000<\/span>:\n <span class=\"code-function\">print<\/span>(<span class=\"code-string\">\"On track\"<\/span>)\n<span class=\"code-keyword\">else<\/span>:\n <span class=\"code-function\">print<\/span>(<span class=\"code-string\">\"Below target\"<\/span>)\n\n<span class=\"code-comment\"># Multiple conditions<\/span>\nage = <span class=\"code-number\">35<\/span>\nincome = <span class=\"code-number\">75000<\/span>\n\n<span class=\"code-keyword\">if<\/span> age > <span class=\"code-number\">30<\/span> <span class=\"code-keyword\">and<\/span> income > <span class=\"code-number\">50000<\/span>:\n <span class=\"code-function\">print<\/span>(<span class=\"code-string\">\"Target demographic\"<\/span>)\n\n<span class=\"code-keyword\">if<\/span> age < <span class=\"code-number\">25<\/span> <span class=\"code-keyword\">or<\/span> age > <span class=\"code-number\">65<\/span>:\n <span class=\"code-function\">print<\/span>(<span class=\"code-string\">\"Special discount eligible\"<\/span>)<\/div>\n <\/div>\n\n <div class=\"code-card\">\n <h4>For Loops (Iterate Over Data)<\/h4>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Loop through a list<\/span>\nproducts = [<span class=\"code-string\">\"Laptop\"<\/span>, <span class=\"code-string\">\"Mouse\"<\/span>, <span class=\"code-string\">\"Keyboard\"<\/span>]\n\n<span class=\"code-keyword\">for<\/span> product <span class=\"code-keyword\">in<\/span> products:\n <span class=\"code-function\">print<\/span>(<span class=\"code-string\">f\"Product: <span class=\"code-keyword\">{product}<\/span>\"<\/span>)\n\n<span class=\"code-comment\"># Loop with index<\/span>\n<span class=\"code-keyword\">for<\/span> i, product <span class=\"code-keyword\">in<\/span> <span class=\"code-function\">enumerate<\/span>(products):\n <span class=\"code-function\">print<\/span>(<span class=\"code-string\">f\"<span class=\"code-keyword\">{i+1}<\/span>. <span class=\"code-keyword\">{product}<\/span>\"<\/span>)\n\n<span class=\"code-comment\"># Loop through a range of numbers<\/span>\n<span class=\"code-keyword\">for<\/span> year <span class=\"code-keyword\">in<\/span> <span class=\"code-function\">range<\/span>(<span class=\"code-number\">2020<\/span>, <span class=\"code-number\">2025<\/span>):\n <span class=\"code-function\">print<\/span>(<span class=\"code-string\">f\"Year: <span class=\"code-keyword\">{year}<\/span>\"<\/span>)\n\n<span class=\"code-comment\"># Loop through dictionary<\/span>\nsales = {<span class=\"code-string\">\"Q1\"<\/span>: <span class=\"code-number\">45000<\/span>, <span class=\"code-string\">\"Q2\"<\/span>: <span class=\"code-number\">52000<\/span>, <span class=\"code-string\">\"Q3\"<\/span>: <span class=\"code-number\">48000<\/span>}\n\n<span class=\"code-keyword\">for<\/span> quarter, amount <span class=\"code-keyword\">in<\/span> sales.<span class=\"code-function\">items<\/span>():\n <span class=\"code-function\">print<\/span>(<span class=\"code-string\">f\"<span class=\"code-keyword\">{quarter}<\/span>: $<span class=\"code-keyword\">{amount:,}<\/span>\"<\/span>)<\/div>\n <\/div>\n\n <div class=\"use-case-box\">\n <h5>Business Use Case: Customer Segmentation<\/h5>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Categorize customers based on purchase amount<\/span>\ncustomers = [\n {<span class=\"code-string\">\"name\"<\/span>: <span class=\"code-string\">\"Alice\"<\/span>, <span class=\"code-string\">\"total_spent\"<\/span>: <span class=\"code-number\">1200<\/span>},\n {<span class=\"code-string\">\"name\"<\/span>: <span class=\"code-string\">\"Bob\"<\/span>, <span class=\"code-string\">\"total_spent\"<\/span>: <span class=\"code-number\">350<\/span>},\n {<span class=\"code-string\">\"name\"<\/span>: <span class=\"code-string\">\"Carol\"<\/span>, <span class=\"code-string\">\"total_spent\"<\/span>: <span class=\"code-number\">5500<\/span>}\n]\n\n<span class=\"code-keyword\">for<\/span> customer <span class=\"code-keyword\">in<\/span> customers:\n name = customer[<span class=\"code-string\">\"name\"<\/span>]\n spent = customer[<span class=\"code-string\">\"total_spent\"<\/span>]\n \n <span class=\"code-keyword\">if<\/span> spent > <span class=\"code-number\">5000<\/span>:\n tier = <span class=\"code-string\">\"VIP\"<\/span>\n <span class=\"code-keyword\">elif<\/span> spent > <span class=\"code-number\">1000<\/span>:\n tier = <span class=\"code-string\">\"Gold\"<\/span>\n <span class=\"code-keyword\">else<\/span>:\n tier = <span class=\"code-string\">\"Silver\"<\/span>\n \n <span class=\"code-function\">print<\/span>(<span class=\"code-string\">f\"<span class=\"code-keyword\">{name}<\/span>: <span class=\"code-keyword\">{tier}<\/span> (${spent:,})\"<\/span>)<\/div>\n \n <div class=\"output-block\">\n <span class=\"output-label\">OUTPUT:<\/span>\nAlice: Gold ($1,200)<br>\nBob: Silver ($350)<br>\nCarol: VIP ($5,500)\n <\/div>\n <\/div>\n <\/div>\n\n <div class=\"subsection\">\n <h3>Functions (Reusable Code)<\/h3>\n <span class=\"tag intermediate\">Intermediate<\/span>\n\n <div class=\"code-card\">\n <h4>Defining & Using Functions<\/h4>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Define a function<\/span>\n<span class=\"code-keyword\">def<\/span> <span class=\"code-function\">calculate_profit<\/span>(revenue, costs):\n profit = revenue - costs\n margin = (profit \/ revenue) * <span class=\"code-number\">100<\/span>\n <span class=\"code-keyword\">return<\/span> profit, margin\n\n<span class=\"code-comment\"># Use the function<\/span>\nrevenue = <span class=\"code-number\">150000<\/span>\ncosts = <span class=\"code-number\">95000<\/span>\nprofit, margin = <span class=\"code-function\">calculate_profit<\/span>(revenue, costs)\n\n<span class=\"code-function\">print<\/span>(<span class=\"code-string\">f\"Profit: $<span class=\"code-keyword\">{profit:,}<\/span>\"<\/span>)\n<span class=\"code-function\">print<\/span>(<span class=\"code-string\">f\"Margin: <span class=\"code-keyword\">{margin:.1f}<\/span>%\"<\/span>)<\/div>\n <\/div>\n\n <div class=\"code-card\">\n <h4>Function with Default Parameters<\/h4>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Function with default tax rate<\/span>\n<span class=\"code-keyword\">def<\/span> <span class=\"code-function\">calculate_total<\/span>(price, quantity, tax_rate=<span class=\"code-number\">0.08<\/span>):\n subtotal = price * quantity\n tax = subtotal * tax_rate\n total = subtotal + tax\n <span class=\"code-keyword\">return<\/span> total\n\n<span class=\"code-comment\"># Use default tax rate<\/span>\ntotal1 = <span class=\"code-function\">calculate_total<\/span>(<span class=\"code-number\">49.99<\/span>, <span class=\"code-number\">3<\/span>)\n\n<span class=\"code-comment\"># Override tax rate<\/span>\ntotal2 = <span class=\"code-function\">calculate_total<\/span>(<span class=\"code-number\">49.99<\/span>, <span class=\"code-number\">3<\/span>, tax_rate=<span class=\"code-number\">0.10<\/span>)<\/div>\n <\/div>\n\n <div class=\"use-case-box\">\n <h5>Business Use Case: Discount Calculator<\/h5>\n <div class=\"code-block\">\n<span class=\"code-keyword\">def<\/span> <span class=\"code-function\">apply_discount<\/span>(price, customer_tier):\n <span class=\"code-string\">\"\"\"Calculate price after discount based on customer tier\"\"\"<\/span>\n \n discounts = {\n <span class=\"code-string\">\"VIP\"<\/span>: <span class=\"code-number\">0.20<\/span>, <span class=\"code-comment\"># 20% off<\/span>\n <span class=\"code-string\">\"Gold\"<\/span>: <span class=\"code-number\">0.15<\/span>, <span class=\"code-comment\"># 15% off<\/span>\n <span class=\"code-string\">\"Silver\"<\/span>: <span class=\"code-number\">0.05<\/span> <span class=\"code-comment\"># 5% off<\/span>\n }\n \n discount_rate = discounts.<span class=\"code-function\">get<\/span>(customer_tier, <span class=\"code-number\">0<\/span>)\n discount_amount = price * discount_rate\n final_price = price - discount_amount\n \n <span class=\"code-keyword\">return<\/span> final_price, discount_amount\n\n<span class=\"code-comment\"># Test the function<\/span>\noriginal_price = <span class=\"code-number\">100<\/span>\nfinal, saved = <span class=\"code-function\">apply_discount<\/span>(original_price, <span class=\"code-string\">\"VIP\"<\/span>)\n<span class=\"code-function\">print<\/span>(<span class=\"code-string\">f\"Final price: $<span class=\"code-keyword\">{final}<\/span>, Saved: $<span class=\"code-keyword\">{saved}<\/span>\"<\/span>)<\/div>\n <\/div>\n <\/div>\n <\/div>\n\n <!-- Data Analysis with Pandas -->\n <div class=\"section\">\n <div class=\"section-header\">\ud83d\udcca Data Analysis with Pandas<\/div>\n\n <div class=\"subsection\">\n <h3>Introduction to Pandas<\/h3>\n <p style=\"margin-bottom: 15px;\">Pandas is Python's primary library for data analysis\u2014think \"Excel on steroids\". It handles spreadsheet-like data with powerful operations.<\/p>\n\n <div class=\"code-card\">\n <h4>Import Pandas & Create DataFrame<\/h4>\n <div class=\"code-block\">\n<span class=\"code-keyword\">import<\/span> pandas <span class=\"code-keyword\">as<\/span> pd\n\n<span class=\"code-comment\"># Create DataFrame from dictionary<\/span>\ndata = {\n <span class=\"code-string\">\"Product\"<\/span>: [<span class=\"code-string\">\"Laptop\"<\/span>, <span class=\"code-string\">\"Mouse\"<\/span>, <span class=\"code-string\">\"Keyboard\"<\/span>, <span class=\"code-string\">\"Monitor\"<\/span>],\n <span class=\"code-string\">\"Price\"<\/span>: [<span class=\"code-number\">899<\/span>, <span class=\"code-number\">25<\/span>, <span class=\"code-number\">75<\/span>, <span class=\"code-number\">299<\/span>],\n <span class=\"code-string\">\"Units_Sold\"<\/span>: [<span class=\"code-number\">45<\/span>, <span class=\"code-number\">230<\/span>, <span class=\"code-number\">150<\/span>, <span class=\"code-number\">65<\/span>],\n <span class=\"code-string\">\"Category\"<\/span>: [<span class=\"code-string\">\"Electronics\"<\/span>, <span class=\"code-string\">\"Accessories\"<\/span>, <span class=\"code-string\">\"Accessories\"<\/span>, <span class=\"code-string\">\"Electronics\"<\/span>]\n}\n\ndf = pd.<span class=\"code-function\">DataFrame<\/span>(data)\n<span class=\"code-function\">print<\/span>(df)<\/div>\n\n <div class=\"output-block\">\n <span class=\"output-label\">OUTPUT:<\/span>\n<pre> Product Price Units_Sold Category\n0 Laptop 899 45 Electronics\n1 Mouse 25 230 Accessories\n2 Keyboard 75 150 Accessories\n3 Monitor 299 65 Electronics<\/pre>\n <\/div>\n <\/div>\n\n <div class=\"code-card\">\n <h4>Reading Data from Files<\/h4>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Read CSV file<\/span>\ndf = pd.<span class=\"code-function\">read_csv<\/span>(<span class=\"code-string\">\"sales_data.csv\"<\/span>)\n\n<span class=\"code-comment\"># Read Excel file<\/span>\ndf = pd.<span class=\"code-function\">read_excel<\/span>(<span class=\"code-string\">\"sales_data.xlsx\"<\/span>, sheet_name=<span class=\"code-string\">\"Sheet1\"<\/span>)\n\n<span class=\"code-comment\"># Read from URL<\/span>\nurl = <span class=\"code-string\">\"https:\/\/example.com\/data.csv\"<\/span>\ndf = pd.<span class=\"code-function\">read_csv<\/span>(url)\n\n<span class=\"code-comment\"># Basic inspection<\/span>\n<span class=\"code-function\">print<\/span>(df.<span class=\"code-function\">head<\/span>()) <span class=\"code-comment\"># First 5 rows<\/span>\n<span class=\"code-function\">print<\/span>(df.<span class=\"code-function\">tail<\/span>()) <span class=\"code-comment\"># Last 5 rows<\/span>\n<span class=\"code-function\">print<\/span>(df.<span class=\"code-function\">info<\/span>()) <span class=\"code-comment\"># Data types and missing values<\/span>\n<span class=\"code-function\">print<\/span>(df.<span class=\"code-function\">describe<\/span>()) <span class=\"code-comment\"># Statistical summary<\/span><\/div>\n <\/div>\n <\/div>\n\n <div class=\"subsection\">\n <h3>Data Selection & Filtering<\/h3>\n\n <div class=\"code-card\">\n <h4>Selecting Columns & Rows<\/h4>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Select single column<\/span>\nprices = df[<span class=\"code-string\">\"Price\"<\/span>]\n\n<span class=\"code-comment\"># Select multiple columns<\/span>\nsubset = df[[<span class=\"code-string\">\"Product\"<\/span>, <span class=\"code-string\">\"Price\"<\/span>]]\n\n<span class=\"code-comment\"># Select rows by index<\/span>\nfirst_row = df.<span class=\"code-function\">iloc<\/span>[<span class=\"code-number\">0<\/span>] <span class=\"code-comment\"># First row<\/span>\nfirst_three = df.<span class=\"code-function\">iloc<\/span>[<span class=\"code-number\">0<\/span>:<span class=\"code-number\">3<\/span>] <span class=\"code-comment\"># Rows 0-2<\/span>\n\n<span class=\"code-comment\"># Filter rows by condition<\/span>\nexpensive = df[df[<span class=\"code-string\">\"Price\"<\/span>] > <span class=\"code-number\">100<\/span>]\nelectronics = df[df[<span class=\"code-string\">\"Category\"<\/span>] == <span class=\"code-string\">\"Electronics\"<\/span>]\n\n<span class=\"code-comment\"># Multiple conditions<\/span>\nhigh_volume = df[(df[<span class=\"code-string\">\"Price\"<\/span>] > <span class=\"code-number\">100<\/span>) & (df[<span class=\"code-string\">\"Units_Sold\"<\/span>] > <span class=\"code-number\">50<\/span>)]<\/div>\n <\/div>\n\n <div class=\"code-card\">\n <h4>Adding & Calculating Columns<\/h4>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Add new column with calculation<\/span>\ndf[<span class=\"code-string\">\"Revenue\"<\/span>] = df[<span class=\"code-string\">\"Price\"<\/span>] * df[<span class=\"code-string\">\"Units_Sold\"<\/span>]\n\n<span class=\"code-comment\"># Add column with conditional logic<\/span>\ndf[<span class=\"code-string\">\"Price_Category\"<\/span>] = df[<span class=\"code-string\">\"Price\"<\/span>].<span class=\"code-function\">apply<\/span>(\n <span class=\"code-keyword\">lambda<\/span> x: <span class=\"code-string\">\"Premium\"<\/span> <span class=\"code-keyword\">if<\/span> x > <span class=\"code-number\">500<\/span> <span class=\"code-keyword\">else<\/span> <span class=\"code-string\">\"Standard\"<\/span>\n)\n\n<span class=\"code-comment\"># Percentage calculation<\/span>\ntotal_revenue = df[<span class=\"code-string\">\"Revenue\"<\/span>].<span class=\"code-function\">sum<\/span>()\ndf[<span class=\"code-string\">\"Revenue_Share\"<\/span>] = (df[<span class=\"code-string\">\"Revenue\"<\/span>] \/ total_revenue) * <span class=\"code-number\">100<\/span><\/div>\n <\/div>\n <\/div>\n\n <div class=\"subsection\">\n <h3>Grouping & Aggregation<\/h3>\n\n <div class=\"code-card\">\n <h4>Group By Operations<\/h4>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Group by category and calculate totals<\/span>\ncategory_summary = df.<span class=\"code-function\">groupby<\/span>(<span class=\"code-string\">\"Category\"<\/span>).<span class=\"code-function\">agg<\/span>({\n <span class=\"code-string\">\"Revenue\"<\/span>: <span class=\"code-string\">\"sum\"<\/span>,\n <span class=\"code-string\">\"Units_Sold\"<\/span>: <span class=\"code-string\">\"sum\"<\/span>,\n <span class=\"code-string\">\"Price\"<\/span>: <span class=\"code-string\">\"mean\"<\/span>\n})\n\n<span class=\"code-function\">print<\/span>(category_summary)\n\n<span class=\"code-comment\"># Multiple aggregations on same column<\/span>\nsales_stats = df.<span class=\"code-function\">groupby<\/span>(<span class=\"code-string\">\"Category\"<\/span>)[<span class=\"code-string\">\"Revenue\"<\/span>].<span class=\"code-function\">agg<\/span>([\n <span class=\"code-string\">\"sum\"<\/span>, <span class=\"code-string\">\"mean\"<\/span>, <span class=\"code-string\">\"min\"<\/span>, <span class=\"code-string\">\"max\"<\/span>, <span class=\"code-string\">\"count\"<\/span>\n])<\/div>\n <\/div>\n\n <div class=\"use-case-box\">\n <h5>Business Use Case: Monthly Sales Report<\/h5>\n <div class=\"code-block\">\n<span class=\"code-keyword\">import<\/span> pandas <span class=\"code-keyword\">as<\/span> pd\n\n<span class=\"code-comment\"># Sample sales data<\/span>\ndata = {\n <span class=\"code-string\">\"Date\"<\/span>: [<span class=\"code-string\">\"2024-01-15\"<\/span>, <span class=\"code-string\">\"2024-01-20\"<\/span>, <span class=\"code-string\">\"2024-02-10\"<\/span>, <span class=\"code-string\">\"2024-02-25\"<\/span>],\n <span class=\"code-string\">\"Product\"<\/span>: [<span class=\"code-string\">\"Laptop\"<\/span>, <span class=\"code-string\">\"Mouse\"<\/span>, <span class=\"code-string\">\"Laptop\"<\/span>, <span class=\"code-string\">\"Keyboard\"<\/span>],\n <span class=\"code-string\">\"Revenue\"<\/span>: [<span class=\"code-number\">45000<\/span>, <span class=\"code-number\">5000<\/span>, <span class=\"code-number\">35000<\/span>, <span class=\"code-number\">7500<\/span>]\n}\n\ndf = pd.<span class=\"code-function\">DataFrame<\/span>(data)\ndf[<span class=\"code-string\">\"Date\"<\/span>] = pd.<span class=\"code-function\">to_datetime<\/span>(df[<span class=\"code-string\">\"Date\"<\/span>])\n\n<span class=\"code-comment\"># Extract month and create monthly report<\/span>\ndf[<span class=\"code-string\">\"Month\"<\/span>] = df[<span class=\"code-string\">\"Date\"<\/span>].dt.<span class=\"code-function\">strftime<\/span>(<span class=\"code-string\">\"%Y-%m\"<\/span>)\n\nmonthly_report = df.<span class=\"code-function\">groupby<\/span>(<span class=\"code-string\">\"Month\"<\/span>).<span class=\"code-function\">agg<\/span>({\n <span class=\"code-string\">\"Revenue\"<\/span>: [<span class=\"code-string\">\"sum\"<\/span>, <span class=\"code-string\">\"mean\"<\/span>],\n <span class=\"code-string\">\"Product\"<\/span>: <span class=\"code-string\">\"count\"<\/span>\n}).<span class=\"code-function\">round<\/span>(<span class=\"code-number\">2<\/span>)\n\n<span class=\"code-function\">print<\/span>(monthly_report)<\/div>\n <\/div>\n <\/div>\n\n <div class=\"subsection\">\n <h3>Data Cleaning<\/h3>\n\n <div class=\"code-card\">\n <h4>Handling Missing Data<\/h4>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Check for missing values<\/span>\n<span class=\"code-function\">print<\/span>(df.<span class=\"code-function\">isnull<\/span>().<span class=\"code-function\">sum<\/span>())\n\n<span class=\"code-comment\"># Drop rows with any missing values<\/span>\ndf_clean = df.<span class=\"code-function\">dropna<\/span>()\n\n<span class=\"code-comment\"># Fill missing values<\/span>\ndf[<span class=\"code-string\">\"Price\"<\/span>].<span class=\"code-function\">fillna<\/span>(<span class=\"code-number\">0<\/span>, inplace=<span class=\"code-keyword\">True<\/span>) <span class=\"code-comment\"># Fill with 0<\/span>\ndf[<span class=\"code-string\">\"Price\"<\/span>].<span class=\"code-function\">fillna<\/span>(df[<span class=\"code-string\">\"Price\"<\/span>].<span class=\"code-function\">mean<\/span>(), inplace=<span class=\"code-keyword\">True<\/span>) <span class=\"code-comment\"># Fill with average<\/span>\n\n<span class=\"code-comment\"># Drop duplicates<\/span>\ndf_unique = df.<span class=\"code-function\">drop_duplicates<\/span>()<\/div>\n <\/div>\n\n <div class=\"code-card\">\n <h4>Data Type Conversion<\/h4>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Convert to numeric (handles errors)<\/span>\ndf[<span class=\"code-string\">\"Price\"<\/span>] = pd.<span class=\"code-function\">to_numeric<\/span>(df[<span class=\"code-string\">\"Price\"<\/span>], errors=<span class=\"code-string\">\"coerce\"<\/span>)\n\n<span class=\"code-comment\"># Convert to datetime<\/span>\ndf[<span class=\"code-string\">\"Date\"<\/span>] = pd.<span class=\"code-function\">to_datetime<\/span>(df[<span class=\"code-string\">\"Date\"<\/span>])\n\n<span class=\"code-comment\"># Convert to string<\/span>\ndf[<span class=\"code-string\">\"Customer_ID\"<\/span>] = df[<span class=\"code-string\">\"Customer_ID\"<\/span>].<span class=\"code-function\">astype<\/span>(<span class=\"code-function\">str<\/span>)<\/div>\n <\/div>\n <\/div>\n\n <div class=\"subsection\">\n <h3>Exporting Data<\/h3>\n\n <div class=\"code-card\">\n <h4>Save to Files<\/h4>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Save to CSV<\/span>\ndf.<span class=\"code-function\">to_csv<\/span>(<span class=\"code-string\">\"output.csv\"<\/span>, index=<span class=\"code-keyword\">False<\/span>)\n\n<span class=\"code-comment\"># Save to Excel<\/span>\ndf.<span class=\"code-function\">to_excel<\/span>(<span class=\"code-string\">\"output.xlsx\"<\/span>, sheet_name=<span class=\"code-string\">\"Sales\"<\/span>, index=<span class=\"code-keyword\">False<\/span>)\n\n<span class=\"code-comment\"># Save multiple sheets to Excel<\/span>\n<span class=\"code-keyword\">with<\/span> pd.<span class=\"code-function\">ExcelWriter<\/span>(<span class=\"code-string\">\"report.xlsx\"<\/span>) <span class=\"code-keyword\">as<\/span> writer:\n df.<span class=\"code-function\">to_excel<\/span>(writer, sheet_name=<span class=\"code-string\">\"Raw_Data\"<\/span>)\n summary.<span class=\"code-function\">to_excel<\/span>(writer, sheet_name=<span class=\"code-string\">\"Summary\"<\/span>)<\/div>\n <\/div>\n <\/div>\n <\/div>\n\n <!-- Visualization -->\n <div class=\"section\">\n <div class=\"section-header\">\ud83d\udcc8 Data Visualization<\/div>\n\n <div class=\"subsection\">\n <h3>Basic Plotting with Matplotlib<\/h3>\n\n <div class=\"code-card\">\n <h4>Line Chart<\/h4>\n <div class=\"code-block\">\n<span class=\"code-keyword\">import<\/span> matplotlib.pyplot <span class=\"code-keyword\">as<\/span> plt\n\n<span class=\"code-comment\"># Sample data<\/span>\nmonths = [<span class=\"code-string\">\"Jan\"<\/span>, <span class=\"code-string\">\"Feb\"<\/span>, <span class=\"code-string\">\"Mar\"<\/span>, <span class=\"code-string\">\"Apr\"<\/span>, <span class=\"code-string\">\"May\"<\/span>]\nrevenue = [<span class=\"code-number\">45000<\/span>, <span class=\"code-number\">52000<\/span>, <span class=\"code-number\">48000<\/span>, <span class=\"code-number\">61000<\/span>, <span class=\"code-number\">55000<\/span>]\n\n<span class=\"code-comment\"># Create line chart<\/span>\nplt.<span class=\"code-function\">figure<\/span>(figsize=(<span class=\"code-number\">10<\/span>, <span class=\"code-number\">6<\/span>))\nplt.<span class=\"code-function\">plot<\/span>(months, revenue, marker=<span class=\"code-string\">\"o\"<\/span>, linewidth=<span class=\"code-number\">2<\/span>, color=<span class=\"code-string\">\"#7B3FF2\"<\/span>)\nplt.<span class=\"code-function\">title<\/span>(<span class=\"code-string\">\"Monthly Revenue Trend\"<\/span>, fontsize=<span class=\"code-number\">16<\/span>)\nplt.<span class=\"code-function\">xlabel<\/span>(<span class=\"code-string\">\"Month\"<\/span>)\nplt.<span class=\"code-function\">ylabel<\/span>(<span class=\"code-string\">\"Revenue ($)\"<\/span>)\nplt.<span class=\"code-function\">grid<\/span>(<span class=\"code-keyword\">True<\/span>, alpha=<span class=\"code-number\">0.3<\/span>)\nplt.<span class=\"code-function\">show<\/span>()<\/div>\n <\/div>\n\n <div class=\"code-card\">\n <h4>Bar Chart<\/h4>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Sample data<\/span>\nproducts = [<span class=\"code-string\">\"Laptop\"<\/span>, <span class=\"code-string\">\"Mouse\"<\/span>, <span class=\"code-string\">\"Keyboard\"<\/span>, <span class=\"code-string\">\"Monitor\"<\/span>]\nsales = [<span class=\"code-number\">45<\/span>, <span class=\"code-number\">230<\/span>, <span class=\"code-number\">150<\/span>, <span class=\"code-number\">65<\/span>]\n\n<span class=\"code-comment\"># Create bar chart<\/span>\nplt.<span class=\"code-function\">figure<\/span>(figsize=(<span class=\"code-number\">10<\/span>, <span class=\"code-number\">6<\/span>))\nplt.<span class=\"code-function\">bar<\/span>(products, sales, color=[<span class=\"code-string\">\"#7B3FF2\"<\/span>, <span class=\"code-string\">\"#00A8E8\"<\/span>, <span class=\"code-string\">\"#9C27B0\"<\/span>, <span class=\"code-string\">\"#4CAF50\"<\/span>])\nplt.<span class=\"code-function\">title<\/span>(<span class=\"code-string\">\"Units Sold by Product\"<\/span>, fontsize=<span class=\"code-number\">16<\/span>)\nplt.<span class=\"code-function\">xlabel<\/span>(<span class=\"code-string\">\"Product\"<\/span>)\nplt.<span class=\"code-function\">ylabel<\/span>(<span class=\"code-string\">\"Units Sold\"<\/span>)\nplt.<span class=\"code-function\">show<\/span>()<\/div>\n <\/div>\n\n <div class=\"code-card\">\n <h4>Pandas Built-in Plotting<\/h4>\n <div class=\"code-block\">\n<span class=\"code-comment\"># Plot directly from DataFrame<\/span>\ndf.<span class=\"code-function\">plot<\/span>(x=<span class=\"code-string\">\"Product\"<\/span>, y=<span class=\"code-string\">\"Revenue\"<\/span>, kind=<span class=\"code-string\">\"bar\"<\/span>, figsize=(<span class=\"code-number\">10<\/span>,<span class=\"code-number\">6<\/span>))\nplt.<span class=\"code-function\">show<\/span>()\n\n<span class=\"code-comment\"># Multiple plots<\/span>\ndf.<span class=\"code-function\">plot<\/span>(x=<span class=\"code-string\">\"Month\"<\/span>, y=[<span class=\"code-string\">\"Revenue\"<\/span>, <span class=\"code-string\">\"Costs\"<\/span>], kind=<span class=\"code-string\">\"line\"<\/span>)\nplt.<span class=\"code-function\">show<\/span>()\n\n<span class=\"code-comment\"># Pie chart<\/span>\ndf.<span class=\"code-function\">groupby<\/span>(<span class=\"code-string\">\"Category\"<\/span>)[<span class=\"code-string\">\"Revenue\"<\/span>].<span class=\"code-function\">sum<\/span>().<span class=\"code-function\">plot<\/span>(kind=<span class=\"code-string\">\"pie\"<\/span>, autopct=<span class=\"code-string\">\"%1.1f%%\"<\/span>)\nplt.<span class=\"code-function\">show<\/span>()<\/div>\n <\/div>\n <\/div>\n <\/div>\n\n <!-- Real-World Examples -->\n <div class=\"section\">\n <div class=\"section-header\">\ud83d\udcbc Real-World Business Examples<\/div>\n\n <div class=\"subsection\">\n <h3>Example 1: Sales Performance Dashboard<\/h3>\n\n <div class=\"code-block\">\n<span class=\"code-keyword\">import<\/span> pandas <span class=\"code-keyword\">as<\/span> pd\n\n<span class=\"code-comment\"># Load sales data<\/span>\ndf = pd.<span class=\"code-function\">read_csv<\/span>(<span class=\"code-string\">\"sales_2024.csv\"<\/span>)\ndf[<span class=\"code-string\">\"Date\"<\/span>] = pd.<span class=\"code-function\">to_datetime<\/span>(df[<span class=\"code-string\">\"Date\"<\/span>])\n\n<span class=\"code-comment\"># Calculate key metrics<\/span>\ntotal_revenue = df[<span class=\"code-string\">\"Revenue\"<\/span>].<span class=\"code-function\">sum<\/span>()\navg_order_value = df[<span class=\"code-string\">\"Revenue\"<\/span>].<span class=\"code-function\">mean<\/span>()\ntotal_orders = <span class=\"code-function\">len<\/span>(df)\n\n<span class=\"code-comment\"># Monthly performance<\/span>\ndf[<span class=\"code-string\">\"Month\"<\/span>] = df[<span class=\"code-string\">\"Date\"<\/span>].dt.<span class=\"code-function\">to_period<\/span>(<span class=\"code-string\">\"M\"<\/span>)\nmonthly = df.<span class=\"code-function\">groupby<\/span>(<span class=\"code-string\">\"Month\"<\/span>).<span class=\"code-function\">agg<\/span>({\n <span class=\"code-string\">\"Revenue\"<\/span>: <span class=\"code-string\">\"sum\"<\/span>,\n <span class=\"code-string\">\"Order_ID\"<\/span>: <span class=\"code-string\">\"count\"<\/span>\n})\n\n<span class=\"code-comment\"># Calculate growth rate<\/span>\nmonthly[<span class=\"code-string\">\"Growth_Rate\"<\/span>] = monthly[<span class=\"code-string\">\"Revenue\"<\/span>].<span class=\"code-function\">pct_change<\/span>() * <span class=\"code-number\">100<\/span>\n\n<span class=\"code-comment\"># Top 5 products<\/span>\ntop_products = df.<span class=\"code-function\">groupby<\/span>(<span class=\"code-string\">\"Product\"<\/span>)[<span class=\"code-string\">\"Revenue\"<\/span>].<span class=\"code-function\">sum<\/span>().<span class=\"code-function\">sort_values<\/span>(ascending=<span class=\"code-keyword\">False<\/span>).<span class=\"code-function\">head<\/span>(<span class=\"code-number\">5<\/span>)\n\n<span class=\"code-comment\"># Create summary report<\/span>\n<span class=\"code-function\">print<\/span>(<span class=\"code-string\">f\"=== Sales Performance Report ===\"<\/span>)\n<span class=\"code-function\">print<\/span>(<span class=\"code-string\">f\"Total Revenue: $<span class=\"code-keyword\">{total_revenue:,.2f}<\/span>\"<\/span>)\n<span class=\"code-function\">print<\/span>(<span class=\"code-string\">f\"Average Order Value: $<span class=\"code-keyword\">{avg_order_value:,.2f}<\/span>\"<\/span>)\n<span class=\"code-function\">print<\/span>(<span class=\"code-string\">f\"Total Orders: <span class=\"code-keyword\">{total_orders:,}<\/span>\"<\/span>)\n<span class=\"code-function\">print<\/span>(<span class=\"code-string\">f\"\\nTop 5 Products:\"<\/span>)\n<span class=\"code-function\">print<\/span>(top_products)<\/div>\n <\/div>\n\n <div class=\"subsection\">\n <h3>Example 2: Customer Churn Analysis<\/h3>\n\n <div class=\"code-block\">\n<span class=\"code-keyword\">import<\/span> pandas <span class=\"code-keyword\">as<\/span> pd\n\n<span class=\"code-comment\"># Load customer data<\/span>\ndf = pd.<span class=\"code-function\">read_csv<\/span>(<span class=\"code-string\">\"customers.csv\"<\/span>)\n\n<span class=\"code-comment\"># Calculate churn indicators<\/span>\ndf[<span class=\"code-string\">\"Days_Since_Purchase\"<\/span>] = (pd.<span class=\"code-function\">Timestamp<\/span>.<span class=\"code-function\">now<\/span>() - pd.<span class=\"code-function\">to_datetime<\/span>(df[<span class=\"code-string\">\"Last_Purchase\"<\/span>])).<span class=\"code-function\">dt<\/span>.days\n\n<span class=\"code-comment\"># Define churn (no purchase in 90 days)<\/span>\ndf[<span class=\"code-string\">\"Is_Churned\"<\/span>] = df[<span class=\"code-string\">\"Days_Since_Purchase\"<\/span>] > <span class=\"code-number\">90<\/span>\n\n<span class=\"code-comment\"># Churn analysis by segment<\/span>\nchurn_by_segment = df.<span class=\"code-function\">groupby<\/span>(<span class=\"code-string\">\"Customer_Segment\"<\/span>)[<span class=\"code-string\">\"Is_Churned\"<\/span>].<span class=\"code-function\">mean<\/span>() * <span class=\"code-number\">100<\/span>\n\n<span class=\"code-comment\"># At-risk customers (60-90 days)<\/span>\nat_risk = df[(df[<span class=\"code-string\">\"Days_Since_Purchase\"<\/span>] > <span class=\"code-number\">60<\/span>) & \n (df[<span class=\"code-string\">\"Days_Since_Purchase\"<\/span>] <= <span class=\"code-number\">90<\/span>)]\n\n<span class=\"code-comment\"># High-value at-risk customers<\/span>\npriority_outreach = at_risk[at_risk[<span class=\"code-string\">\"Lifetime_Value\"<\/span>] > <span class=\"code-number\">1000<\/span>].<span class=\"code-function\">sort_values<\/span>(\n <span class=\"code-string\">\"Lifetime_Value\"<\/span>, ascending=<span class=\"code-keyword\">False<\/span>\n)\n\n<span class=\"code-comment\"># Export for retention campaign<\/span>\npriority_outreach[[<span class=\"code-string\">\"Customer_ID\"<\/span>, <span class=\"code-string\">\"Email\"<\/span>, <span class=\"code-string\">\"Lifetime_Value\"<\/span>]].<span class=\"code-function\">to_csv<\/span>(\n <span class=\"code-string\">\"retention_campaign.csv\"<\/span>, index=<span class=\"code-keyword\">False<\/span>\n)<\/div>\n <\/div>\n\n <div class=\"subsection\">\n <h3>Example 3: Inventory Optimization<\/h3>\n\n <div class=\"code-block\">\n<span class=\"code-keyword\">import<\/span> pandas <span class=\"code-keyword\">as<\/span> pd\n\n<span class=\"code-comment\"># Load inventory and sales data<\/span>\ninventory = pd.<span class=\"code-function\">read_csv<\/span>(<span class=\"code-string\">\"inventory.csv\"<\/span>)\nsales = pd.<span class=\"code-function\">read_csv<\/span>(<span class=\"code-string\">\"sales_history.csv\"<\/span>)\n\n<span class=\"code-comment\"># Calculate average daily sales<\/span>\ndaily_sales = sales.<span class=\"code-function\">groupby<\/span>(<span class=\"code-string\">\"Product_ID\"<\/span>)[<span class=\"code-string\">\"Units_Sold\"<\/span>].<span class=\"code-function\">mean<\/span>()\n\n<span class=\"code-comment\"># Merge with current inventory<\/span>\ninventory = inventory.<span class=\"code-function\">merge<\/span>(daily_sales, on=<span class=\"code-string\">\"Product_ID\"<\/span>, how=<span class=\"code-string\">\"left\"<\/span>)\n\n<span class=\"code-comment\"># Calculate days of inventory remaining<\/span>\ninventory[<span class=\"code-string\">\"Days_Remaining\"<\/span>] = inventory[<span class=\"code-string\">\"Current_Stock\"<\/span>] \/ inventory[<span class=\"code-string\">\"Units_Sold\"<\/span>]\n\n<span class=\"code-comment\"># Identify low stock items (< 14 days)<\/span>\nlow_stock = inventory[inventory[<span class=\"code-string\">\"Days_Remaining\"<\/span>] < <span class=\"code-number\">14<\/span>].<span class=\"code-function\">sort_values<\/span>(<span class=\"code-string\">\"Days_Remaining\"<\/span>)\n\n<span class=\"code-comment\"># Calculate reorder quantities<\/span>\nlead_time_days = <span class=\"code-number\">7<\/span>\nsafety_stock_days = <span class=\"code-number\">7<\/span>\n\ninventory[<span class=\"code-string\">\"Reorder_Quantity\"<\/span>] = (\n inventory[<span class=\"code-string\">\"Units_Sold\"<\/span>] * (lead_time_days + safety_stock_days) - \n inventory[<span class=\"code-string\">\"Current_Stock\"<\/span>]\n)\n\n<span class=\"code-comment\"># Generate purchase order<\/span>\npurchase_order = inventory[inventory[<span class=\"code-string\">\"Reorder_Quantity\"<\/span>] > <span class=\"code-number\">0<\/span>][[\n <span class=\"code-string\">\"Product_ID\"<\/span>, <span class=\"code-string\">\"Product_Name\"<\/span>, <span class=\"code-string\">\"Reorder_Quantity\"<\/span>, <span class=\"code-string\">\"Supplier\"<\/span>\n]]\n\npurchase_order.<span class=\"code-function\">to_csv<\/span>(<span class=\"code-string\">\"purchase_order.csv\"<\/span>, index=<span class=\"code-keyword\">False<\/span>)<\/div>\n <\/div>\n <\/div>\n\n <!-- Quick Reference -->\n <div class=\"section\">\n <div class=\"section-header\">\ud83d\udcd6 Quick Reference Cheat Sheet<\/div>\n\n <table class=\"comparison-table\">\n <thead>\n <tr>\n <th>Task<\/th>\n <th>Code<\/th>\n <th>Example<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td><strong>Read CSV<\/strong><\/td>\n <td><code>pd.read_csv(\"file.csv\")<\/code><\/td>\n <td>Load data from Excel export<\/td>\n <\/tr>\n <tr>\n <td><strong>Filter Rows<\/strong><\/td>\n <td><code>df[df[\"Column\"] > 100]<\/code><\/td>\n <td>Get all sales > $100<\/td>\n <\/tr>\n <tr>\n <td><strong>Group & Sum<\/strong><\/td>\n <td><code>df.groupby(\"Category\")[\"Sales\"].sum()<\/code><\/td>\n <td>Total sales per category<\/td>\n <\/tr>\n <tr>\n <td><strong>Add Column<\/strong><\/td>\n <td><code>df[\"New\"] = df[\"A\"] * df[\"B\"]<\/code><\/td>\n <td>Calculate revenue = price \u00d7 quantity<\/td>\n <\/tr>\n <tr>\n <td><strong>Sort Data<\/strong><\/td>\n <td><code>df.sort_values(\"Sales\", ascending=False)<\/code><\/td>\n <td>Highest sales first<\/td>\n <\/tr>\n <tr>\n <td><strong>Remove Duplicates<\/strong><\/td>\n <td><code>df.drop_duplicates()<\/code><\/td>\n <td>Clean duplicate entries<\/td>\n <\/tr>\n <tr>\n <td><strong>Fill Missing<\/strong><\/td>\n <td><code>df[\"Price\"].fillna(0)<\/code><\/td>\n <td>Replace blanks with 0<\/td>\n <\/tr>\n <tr>\n <td><strong>Export to Excel<\/strong><\/td>\n <td><code>df.to_excel(\"output.xlsx\")<\/code><\/td>\n <td>Save results to Excel<\/td>\n <\/tr>\n <tr>\n <td><strong>Basic Stats<\/strong><\/td>\n <td><code>df.describe()<\/code><\/td>\n <td>Mean, median, min, max<\/td>\n <\/tr>\n <tr>\n <td><strong>Count Values<\/strong><\/td>\n <td><code>df[\"Category\"].value_counts()<\/code><\/td>\n <td>Count items per category<\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n <\/div>\n\n <!-- Learning Resources -->\n <div class=\"section\">\n <div class=\"section-header\">\ud83d\udcda Learning Path & Resources<\/div>\n\n <div class=\"subsection\">\n <h3>Recommended Learning Sequence<\/h3>\n <ol style=\"font-size: 1.05em; line-height: 2;\">\n <li><strong>Week 1-2:<\/strong> Python basics (variables, lists, loops, functions)<\/li>\n <li><strong>Week 3-4:<\/strong> Pandas fundamentals (reading data, filtering, basic operations)<\/li>\n <li><strong>Week 5-6:<\/strong> Data analysis (grouping, aggregation, cleaning)<\/li>\n <li><strong>Week 7-8:<\/strong> Visualization (Matplotlib basics, charts)<\/li>\n <li><strong>Week 9-12:<\/strong> Real projects (automate your actual work tasks)<\/li>\n <\/ol>\n <\/div>\n\n <div class=\"subsection\">\n <h3>Free Resources<\/h3>\n <ul style=\"font-size: 1.05em;\">\n <li><strong>Python.org Tutorial:<\/strong> Official beginner guide<\/li>\n <li><strong>Google Colab:<\/strong> Free online Python environment<\/li>\n <li><strong>Pandas Documentation:<\/strong> Comprehensive examples<\/li>\n <li><strong>Real Python:<\/strong> Practical tutorials for business users<\/li>\n <li><strong>Kaggle Learn:<\/strong> Free micro-courses on data analysis<\/li>\n <\/ul>\n <\/div>\n\n <div class=\"pro-tip\">\n <strong>\ud83d\udca1 Best Way to Learn:<\/strong> Start with a real problem from your work. Automate one repetitive task\u2014even if it's just cleaning an Excel file. The best learning happens when you're solving actual problems.\n <\/div>\n <\/div>\n\n <footer>\n <div class=\"footer-logo\">AiPro Institute\u2122<\/div>\n <p>Python Basics for Business | Members Only Resource<\/p>\n <p style=\"margin-top: 10px; font-size: 0.9em;\">\n \u00a9 2024 AiPro Institute. Master Python for business automation and data analysis.\n Start small, practice daily, build real projects.\n <\/p>\n <\/footer>\n <\/div>\n<script data-cfasync=\"false\" src=\"\/cdn-cgi\/scripts\/5c5dd728\/cloudflare-static\/email-decode.min.js\"><\/script><\/body>\n<\/html>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>Python Basics for Business | AiPro Institute\u2122 \ud83d\udc0d Python Basics for Business Essential Python Skills for Business Professionals & Data Analysis AiPro Institute\u2122 Members Only \ud83d\ude80 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…<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[87],"tags":[],"class_list":["post-3224","post","type-post","status-publish","format-standard","hentry","category-technical-skills"],"acf":[],"_links":{"self":[{"href":"https:\/\/teen.aiproinstitute.com\/zh\/wp-json\/wp\/v2\/posts\/3224","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teen.aiproinstitute.com\/zh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teen.aiproinstitute.com\/zh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teen.aiproinstitute.com\/zh\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/teen.aiproinstitute.com\/zh\/wp-json\/wp\/v2\/comments?post=3224"}],"version-history":[{"count":4,"href":"https:\/\/teen.aiproinstitute.com\/zh\/wp-json\/wp\/v2\/posts\/3224\/revisions"}],"predecessor-version":[{"id":3234,"href":"https:\/\/teen.aiproinstitute.com\/zh\/wp-json\/wp\/v2\/posts\/3224\/revisions\/3234"}],"wp:attachment":[{"href":"https:\/\/teen.aiproinstitute.com\/zh\/wp-json\/wp\/v2\/media?parent=3224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teen.aiproinstitute.com\/zh\/wp-json\/wp\/v2\/categories?post=3224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teen.aiproinstitute.com\/zh\/wp-json\/wp\/v2\/tags?post=3224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}