fx Automation

Capstone

40 मिनट1 पाठ3 प्रश्न

पाठ

1. Capstone: end-to-end pipeline — CSV folder → clean → aggregate → formatted xlsx → email → schedule40 min

अभ्यास फ़ाइल

Automation practice bundle

One ZIP serves all seven modules. It contains a generated, macro-free automation-practice.xlsx, bilingual solutions, three intentionally messy CSVs, Python report/email/pipeline scripts, requirements, a Windows launcher, a sample GitHub Actions workflow, and a README. No credentials or executable VBA are embedded.

The workbook contains Read Me, ROI, Data, Output, Sales, Products, Customers, Invoices, Statement, Orders, Rates, and Log. Data has 30 stock rows (15 reorder, 3 out of stock, total shortfall 45). Sales has 30 rows: North/South 8 each and East/West 7 each; three salespeople have 10 rows each. Five customer balances are 1200, 0, 800, 0, 500. Statement is an exercise template, not a completed statement.

The separate CSV project has 10 input rows: 7 valid unique, 2 rejected and 1 duplicate. Regional totals: South 96000, North 92000, West 61000; overall 249000. Rejected rows preserve original field values, including the literal NA amount.

Extract the ZIP and follow README.md to install the Python requirements and run the examples. Start with python pipeline.py --no-email using copies of the sample data. Desktop VBA, Outlook and xlwings exercises require the applications listed in their respective lessons. The bundle includes no credentials or enabled schedules.

मॉड्यूल प्रश्नोत्तरी (3)

1. Why archive inputs only after the report and email succeed?

So a failed run can be rerun with the same files

2. What should an empty inbox return?

Exit code 0 with a "nothing to do" log line

3. Where should the SMTP password live?

In an environment variable or secret store — never in code