Overview
What you will study
In the Spreadsheet Data Analysis and Automation with Python course offered by City, University of London , we use various Python libraries for manipulating Excel formats, especially OpenPyXL.
We also use xlsxWriter and tools for binary and legacy formats such as pylxsb, xlsd, xlst and xlUtils. These are used to manipulate cell data, worksheets, files, charts, format data and produce summary reports in Excel format, sometimes without opening Excel.
We also automate Excel with xlWings. People with VBA experience will find many of the operations familiar.
Programme Structure
The program focuses on:
- Installing Python libraries such as Pandas
- Use openpyxl to manipulate data in Excel format
- Use xlwings to automate Excel
- Use Python to manipulate data in Google sheets
- Review of Python data structures; Python documentation
- Installing Python libraries such as pandas, numpy, openpyxl
- Numpy data structures and functions
- Pandas data frames; slicing; summary functions
- Interacting with files and operating system (os library)
- Importing and Exporting Excel files, CSV files; exporting to HTML
- Excel Object Model. replicating Excel and VBA functionality
- Pivot tables
- Charting; Matplotlib library
- Installing Anaconda, using virtual environments
- Automating Excel and Office with xlwings and win32.com
- Working with Google sheets
Key information
Duration
- Part-time
- 2 months
Start dates & application deadlines
- Starting
- Apply before
-
- Starting
- Apply before
-
Language
Delivered
Disciplines
Data Science & Big Data Data Analytics View 17 other Short Courses in Data Analytics in United KingdomAcademic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- Comfortable with basic programming in Python and installing software. No special maths knowledge required.
- You will need a good level of spoken and written English to enrol on this course.
Tuition Fee
-
International
595 GBP/fullTuition FeeBased on the tuition of 595 GBP for the full programme during 2 months. -
National
595 GBP/fullTuition FeeBased on the tuition of 595 GBP for the full programme during 2 months.