

In [1]:

    
name = '2017-11-27-report-automation'
title = 'Report Automation with pandas and PyLaTeX'
tags = 'pandas, pdf, latex'
author = 'Benjamin Young-Longstaff'



In [2]:

    
from nb_tools import connect_notebook_to_post
from IPython.core.display import HTML

html = connect_notebook_to_post(name, title, tags, author)

Today we had a short demo on producing automatic reports in PDF using the PyLaTeX library. This approach was tested during an internship at Liftshare. Besides PyLaTeX, we briefly looked at the pandas library, and its functions to process Excel spreadheets, which is an essential part of automatic report generation.

Below are the links to get started with pandas and PyLaTeX, as well as to some of the other packages that were mentioned in the demo:

Pandas - 10 minute guide: https://pandas.pydata.org/pandas-docs/stable/10min.html

Pylatex Examples: https://jeltef.github.io/PyLaTeX/latest/examples.html

Pylatex guide: http://www.jaggedverge.com/2015/12/using-latex-for-fast-document-generation/

Google Map Plotter: https://pypi.python.org/pypi/gmplot/1.0.5

Seaborn Examples: https://seaborn.pydata.org/examples/index.html

Cohort Analysis with Seaborn: http://www.gregreda.com/2015/08/23/cohort-analysis-with-python/

An alternative to pylatex: http://pbpython.com/pdf-reports.html



In [3]:

    
HTML(html)









    Out[3]:





    
     This post was written as an IPython (Jupyter) notebook. You can view or download it using
    nbviewer.