/Extract-data-from-Tableau-TWBX

Extract data from Tableau TWBX to Pandas

Primary LanguageJupyter NotebookMIT LicenseMIT

How to use Hyper API to extract data from Tableau TWBX and load it in Pandas Dataframe

Grumpy

List of workbooks

  1. Unpackaging of Tableau TWBX file
  2. Extracting data from Tableau extract to Pandas dataframe with Tableau Hyper API

Credits

For this example, I have used the "Salaries by College type in USA" dashboard of O. Agbolabori. You can see and download it from this page on the Tableau Public gallery.

Packages

In this workbook I have used the following modules:

  • shutil
  • pathlib
  • pandas
  • tableauhyperapi (download page)
  • zipfile
  • os

I strongly suggest using a virtual environment and installing packages from the provided requirements file

pip install -r requirements.txt