Use Python, ReportLab and data visualization packages like Seaborn and Matplotlib to generate automated reports
Creating reports is a standard task in the modern working environment. Pretty much every office worker has to do it from time to time, some of us even daily.
What you’ll learn
- Understand how Python can help you in data reporting.
- Learn how to speed up the data reporting process.
- Write Python code to automate PDF report generation.
- Understand the ReportLab (Python library) document building system.
- Document data analysis progress and data visualizations in a PDF report.
- Plan out document templates, layouts and styles.
Course Content
- Workspace Setup –> 4 lectures • 7min.
- ReportLab Groundwork –> 8 lectures • 38min.
- Document Data Analysis Progress with ReportLab –> 11 lectures • 36min.
- Including Data Visualizations in Your Reports –> 7 lectures • 23min.
- Updating and Extending the Report –> 7 lectures • 24min.
- Automating the Report Building Process –> 3 lectures • 8min.
Requirements
Creating reports is a standard task in the modern working environment. Pretty much every office worker has to do it from time to time, some of us even daily.
Therefore it makes perfect sense to be an expert at it. This can save you a lot of time, make your manager happy and you can be of great help to your colleagues.
Therefore I will demonstrate in this course how you can use Python and the main package ReportLab to easily create reports and to even automate the process for fast reporting of multiple similar data files.
Our target output file type will be the pdf which anybody of us knows and uses regularly.
The portable document format, or PDF, is the standard for document sharing since decades. Its cross platform compatibility, the ease of printing and the variety of written and visual content it can handle, make the pdf one of the most important document formats.
Reading a PDF is easy as it gets, however, generating a PDF document can get complicated. Text editing software and many interactive apps are able to generate PDFs – data analysis software usually makes great use of this feature too. On the user’s side, PDF generation is just a matter of some mouse clicks. However, in the background the PDF document is written in the PostScript language.
If you are working on your own applications, or if you create a data analysis with a programming language such as Python, then figuring out PDF generation is not as straight forward. You would need an interpreter which translates your code to PostScript and then a PDF document is generated. Sometimes, this process relies on additional software.
If you use python the ReportLab package could be the right tool for you. ReportLab lets you directly create documents in PDF format without any intervening steps. This means that your applications can generate reports very fast, sometimes much faster than stand alone report writing software. A great advantage, especially when you want to automate the process. Besides text, ReportLab also handles charts, graphs, data tables, model outputs – basically anything you can produce with python.
In order to follow along with this course the only skill you need is some beginner level python. So if you know how to install and import packages, handle lists, and how to write simple loops and functions, then you will have no problem keeping up with the course.
Do not worry if your understanding of python is still not at its fullest – I will make an effort in guiding you through the lectures step by step from setting up your working environment, performing a simple data analysis and writing the code for the actual PDF report generation and automation.
Alright I hope you will take this chance to bring your reporting skills to the next level!