{"id":237,"date":"2025-11-20T14:40:01","date_gmt":"2025-11-20T14:40:01","guid":{"rendered":"https:\/\/codetypingpro.com\/?p=237"},"modified":"2025-11-20T14:40:01","modified_gmt":"2025-11-20T14:40:01","slug":"32-real-world-python-projects-automated-report-generator","status":"publish","type":"post","link":"https:\/\/codetypingpro.com\/?p=237","title":{"rendered":"32 – Real-World Python Projects – Automated Report Generator"},"content":{"rendered":"\n
<\/h6>\n\n\n\n

Purpose<\/strong><\/h3>\n\n\n\n

Automatically collect data, process it, create charts, generate a PDF or Excel report, and send it \u2014 without manual effort.<\/p>\n\n\n\n

Real-World Use Cases<\/strong><\/h3>\n\n\n\n
    \n
  • Weekly Sales Reports<\/li>\n\n\n\n
  • HR Monthly Attendance Reports<\/li>\n\n\n\n
  • Finance KPI Dashboards<\/li>\n\n\n\n
  • Website Traffic Reports<\/li>\n\n\n\n
  • Automated Email Reports<\/li>\n<\/ul>\n\n\n\n
    \n\n\n\n

    \ud83e\udde0 What the Project Will Do<\/strong><\/h3>\n\n\n\n

    \u2714 Load data from CSV\/Excel\/Database
    \u2714 Process KPIs (totals, growth %, averages)
    \u2714 Create charts (matplotlib)
    \u2714 Generate a final PDF report<\/strong>
    \u2714 Auto-save with a timestamp
    \u2714 Optional Email Sending Feature<\/p>\n\n\n\n

    \n\n\n\n

    \ud83e\uddf0 Tech Stack<\/strong><\/h3>\n\n\n\n
      \n
    • pandas<\/code><\/li>\n\n\n\n
    • matplotlib<\/code><\/li>\n\n\n\n
    • reportlab<\/code><\/li>\n\n\n\n
    • datetime<\/code><\/li>\n\n\n\n
    • smtplib<\/code> (optional for email)<\/li>\n<\/ul>\n\n\n\n
      \n\n\n\n

      \ud83d\udcc1 Folder Structure<\/h3>\n\n\n\n
      Automated_Report_Generator\/\n\u2502\u2500\u2500 data\/\n\u2502     \u251c\u2500\u2500 sales.csv\n\u2502\u2500\u2500 output\/\n\u2502     \u251c\u2500\u2500 reports.pdf\n\u2502\u2500\u2500 report_generator.py\n<\/code><\/pre>\n\n\n\n
      \n\n\n\n
      \ud83d\udcc4 Sample Data (sales.csv)<\/strong><\/h3>\n\n\n\n
      date,product,units_sold,revenue\n2025-01-01,Mobile,40,400000\n2025-01-02,Laptop,25,750000\n2025-01-03,Tablet,18,270000\n<\/code><\/pre>\n\n\n\n
      \n\n\n\n
      \ud83e\udde0 Full Python Code: report_generator.py<\/code><\/strong><\/h3>\n\n\n\n
      \u2714 Simple, clean, real-world ready.<\/em><\/p>\n\n\n\n
      import pandas as pd\nimport matplotlib.pyplot as plt\nfrom reportlab.platypus import SimpleDocTemplate, Paragraph, Spacer, Image\nfrom reportlab.lib.styles import getSampleStyleSheet\nfrom datetime import datetime\n\n# Load data\ndf = pd.read_csv(\"data\/sales.csv\")\n\n# Summary metrics\ntotal_revenue = df[\"revenue\"].sum()\ntotal_units = df[\"units_sold\"].sum()\navg_daily_sales = round(df[\"revenue\"].mean(), 2)\n\n# Generate chart\nplt.figure(figsize=(6, 4))\nplt.plot(df[\"date\"], df[\"revenue\"])\nplt.title(\"Daily Revenue Trend\")\nplt.xlabel(\"Date\")\nplt.ylabel(\"Revenue\")\nchart_path = \"output\/chart.png\"\nplt.savefig(chart_path)\nplt.close()\n\n# Build PDF\ntimestamp = datetime.now().strftime(\"%Y-%m-%d_%H-%M\")\npdf_path = f\"output\/Report_{timestamp}.pdf\"\n\nstyles = getSampleStyleSheet()\ndoc = SimpleDocTemplate(pdf_path)\n\ncontent = []\n\ncontent.append(Paragraph(\"<b>Automated Sales Report<\/b>\", styles[\"Title\"]))\ncontent.append(Spacer(1, 20))\n\ncontent.append(Paragraph(f\"Total Revenue: \u20b9{total_revenue:,}\", styles[\"BodyText\"]))\ncontent.append(Paragraph(f\"Total Units Sold: {total_units}\", styles[\"BodyText\"]))\ncontent.append(Paragraph(f\"Average Daily Revenue: \u20b9{avg_daily_sales:,}\", styles[\"BodyText\"]))\ncontent.append(Spacer(1, 20))\n\ncontent.append(Paragraph(\"<b>Revenue Trend<\/b>\", styles[\"Heading2\"]))\ncontent.append(Image(chart_path, width=500, height=300))\n\ndoc.build(content)\n\nprint(\"Report Created:\", pdf_path)\n<\/code><\/pre>\n\n\n\n
      \n\n\n\n
      \ud83d\udcca Output PDF Contains:<\/h3>\n\n\n\n
      \u2714 Title: “Automated Sales Report”
      \u2714 Key metrics
      \u2714 Line chart of daily revenue
      \u2714 Auto-generated timestamp
      \u2714 Professionally formatted output<\/p>\n\n\n\n
      \n\n\n\n
      \ud83d\ude80 Advanced Add-Ons (Optional)<\/strong><\/h3>\n\n\n\n
      1\ufe0f\u20e3 Email the PDF Automatically<\/h4>\n\n\n\n
      Use smtplib<\/code> to send a report to the manager every morning.<\/p>\n\n\n\n
      2\ufe0f\u20e3 Add Multiple Charts<\/h4>\n\n\n\n
        \n
      • Product-wise revenue<\/li>\n\n\n\n
      • Weekly averages<\/li>\n\n\n\n
      • Pie chart for categories<\/li>\n<\/ul>\n\n\n\n
        3\ufe0f\u20e3 Use Database Instead of CSV<\/h4>\n\n\n\n
        MySQL \/ PostgreSQL \/ MongoDB \u2192 pandas \u2192 report.<\/p>\n\n\n\n
        4\ufe0f\u20e3 Build a Scheduler<\/h4>\n\n\n\n
        Use schedule<\/code> module:<\/p>\n\n\n\n
        schedule.every().day.at(\"09:00\").do(generate_report)\n<\/code><\/pre>\n\n\n\n
        5\ufe0f\u20e3 Create a Streamlit Dashboard<\/h4>\n\n\n\n
        PDF + Live charts + Filters<\/p>\n\n\n\n
        <\/p>\n","protected":false},"excerpt":{"rendered":"
        Purpose Automatically collect data, process it, create charts, generate a PDF or Excel report, and send it \u2014 without manual effort. Real-World Use Cases \ud83e\udde0 What the Project Will Do \u2714 Load data from CSV\/Excel\/Database\u2714 Process KPIs (totals, growth %, averages)\u2714 Create charts (matplotlib)\u2714 Generate a final PDF report\u2714 Auto-save with a timestamp\u2714 Optional Email […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-237","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/codetypingpro.com\/index.php?rest_route=\/wp\/v2\/posts\/237","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/codetypingpro.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codetypingpro.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codetypingpro.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codetypingpro.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=237"}],"version-history":[{"count":1,"href":"https:\/\/codetypingpro.com\/index.php?rest_route=\/wp\/v2\/posts\/237\/revisions"}],"predecessor-version":[{"id":238,"href":"https:\/\/codetypingpro.com\/index.php?rest_route=\/wp\/v2\/posts\/237\/revisions\/238"}],"wp:attachment":[{"href":"https:\/\/codetypingpro.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codetypingpro.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codetypingpro.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}