Spreadsheet Data Analysis and Automation with Python

Program Overview

This intermediate-level Python course empowers participants to manipulate and automate data on spreadsheets. Through hands-on exercises, they'll master Python libraries for data manipulation, Excel automation, and Google Sheets integration. The program is taught by an experienced instructor in small groups, fostering personalized attention and interactive learning. Upon completion, participants will receive a certificate and be equipped for careers in data analysis, business intelligence, and automation.

Program Outline

Spreadsheet Data Analysis and Automation with Python: A Detailed Extraction

Degree Overview:

Objective:

This intermediate-level course is designed for individuals familiar with basic Python who are interested in manipulating and automating data on spreadsheets. Participants will explore various Python libraries and frameworks, enabling them to work efficiently with Excel and Google Sheets.

Description:

Through this course, participants will gain the ability to:

• Install and utilize Python libraries: Master the installation and application of libraries like Pandas, NumPy, openpyxl, xlsxWriter, and others for efficient data manipulation.
• Control Excel with Python: Learn how to use OpenPyXL to manipulate data within Excel files and formats, including cell data, worksheets, charts, and more.
• Automate Excel tasks: Enhance your productivity by automating repetitive tasks in Excel using xlWings, leveraging similar functionalities as in VBA.
• Work with Google Sheets: Discover how to use Python to access and manipulate data within Google Sheets, allowing for greater flexibility and collaboration.

Outline:

Course Structure:

• Weekly sessions: The program consists of 10 weekly evening sessions, delivered over one term.
• Flexibility: Participants can choose to attend the course either in person or online, depending on their preference.

Course Content:

• Review of Python basics: Refresh your understanding of fundamental Python concepts, including data structures and documentation.
• Installing libraries: Learn how to install and utilize various Python libraries, including Pandas, NumPy, openpyxl, and more.
• Data manipulation: Explore techniques for manipulating data using libraries like NumPy and Pandas, including data structures, functions, slicing, summary functions, and more.
• File handling: Gain proficiency in interacting with files and operating systems using the Python `os` library.
• Data import and export: Learn how to import and export data from various formats, including Excel files, CSV files, and exporting to HTML.
• Excel object model: Understand the Excel object model and how to replicate Excel and VBA functionality using Python.
• Pivot tables and charts: Discover how to create and manipulate pivot tables and charts using Python libraries like Matplotlib.
• Virtual environments: Learn how to manage virtual environments using tools like Anaconda, ensuring project isolation and dependency management.
• Automating Excel and Office: Explore the automation of Excel and other Office applications using xlWings and win32.com, streamlining repetitive tasks.
• Working with Google sheets: Discover how to interact with Google Sheets using Python, enabling data access, manipulation, and analysis.

Assessment:

• Certificate: Participants who attend over 70% of the classes will receive an official City, University of London certificate.
• Informal assessment: Ongoing assessment will occur through class discussions, activities, and question-and-answer sessions facilitated by the tutor.

Teaching:

• Experienced instructor: The course is taught by Sean Walsh, a professional with over 20 years of experience in Excel, VBA, and Python instruction.
• Small groups: The course is delivered in small groups, allowing for personalized attention and interaction.
• Interactive approach: The learning environment encourages active participation through discussions, activities, and hands-on exercises.

Careers:

Completing this program can open doors to various career paths, including:

• Data analysts
• Business intelligence specialists
• Automation developers
• Financial analysts
• Researchers

Other:

• The course is designed to be accessible for individuals with varying levels of experience.
Participants should be comfortable with basic programming concepts and installation of software.