dataframe-image 0.0.7

Embed pandas DataFrames as images in pdf and markdown files when converting from Jupyter Notebooks

dataframe_image

A package to embed pandas DataFrames as images when converting Jupyter Notebooks to pdf or markdown documents.

Motivation

When converting Jupyter Notebooks to pdf using nbconvert, pandas DataFrames appear as either raw text or as a simple latex table as seen on the left side of the image below.

This package was created to embed DataFrames into pdf and markdown documents as images so that they appear exactly as they do in a Jupyter Notebook, as seen on the right side of the image above.

Installation

pip install dataframe_image

Usage

There are three different ways to use dataframe_image:

• Within a Jupyter Notebook
• As a Python library
• From the command line

To get access to all of the available options, use it as a library or from the command line. Using it within the notebook uses the default options and downloads a pdf.

Within a Jupyter Notebook

Upon installation, a new option will appear in your Jupyter Notebook under File -> Download as -> PDF - DataFrame as Image.

In a separate Python script, import the dataframe_image package and pass the file name of your notebook to the convert function.

The conversion process is time consuming as screenshots of each DataFrame will be taken and then embedded into a pdf. A new blank tab will open during the processing. It will appear as nothing is happening. When processing is complete, the document will be downloaded.

When using this option, the notebook will NOT be executed. Make sure to execute the notebook first.

As a Python Library

Using dataframe_image as a Python library provides you with all of the available options, including downloading as a Markdown document.

>>> import dataframe_image as dfi
>>> dfi.convert('path/to/your_notebook.ipynb',
                to='pdf',
                max_rows=30,
                max_cols=10,
                ss_width=1000,
                ss_height=900,
                resize=1,
                chrome_path=None,
                limit=None,
                document_name=None,
                execute=True,
                save_notebook=False,
                output_dir=None,
                image_dir_name=None
                )

By default, the new file(s) will be saved in the same directory where the notebook resides.

Do not run this command within the same notebook that is being converted.

From the Command Line

The command line tool dataframe_image will be available upon installation with the same options as the convert function from above.

The command line tool is experimental as of now. Use dataframe_image as a library for a more stable version.

dataframe_image --to=pdf "my notebook with dataframes.ipynb"

Finding Google Chrome

You must have Google Chrome installed in order for dataframe_image to work. The path to Chrome will automatically be found. If Chrome is not in a standard location, set it with the chrome_path parameter.

Publish to Medium (upcoming)

You can publish your notebooks as Medium blog posts by installing the jupyter_to_medium package which first converts your notebook to markdown using dataframe_image.

Extras

This package also embeds any images added to markdown cells as attachments (done by dragging and dropping the image) as well as those referenced by HTML <img> tags.

It is also able to properly save the pdf/markdown and its images in a directory outside of where it is located.

Dependencies

You must have the following python libraries installed:

• pandas
• nbconvert which requires latex, xelatex, and pandoc
• pillow