This 50-minute session will guide participants through automating direct debit mandate processing using Python in Microsoft Fabric. Starting with raw, unformatted text files, attendees will learn to transform data into HSBC-compliant structured files by:

Parsing raw text into tabular data using PySpark and pandas.

Creating dynamic headers and footers that include record counts and aggregated financial sums.

Formatting fields with precise lengths and padding to meet specific requirements.

Key skills include chaining methods for efficient data processing, aggregating data for insights, and leveraging Python’s scalability for large datasets.

Attendees will also explore practical examples of manipulating text fields, validating data, and generating outputs ready for real-world delivery.

Code snippets will highlight list operations, text transformations, and scalable solutions using PySpark’s capabilities, empowering participants to automate complex workflows with confidence.