Build Tableau Data Extract (.tde) from Pandas DataFrame using Tableau SDK

1. Python 2.7 (Python 3 not supported by Tableau SDK)
2. Tableau SDK
   • documentation: https://onlinehelp.tableau.com/current/api/sdk/en-us/help.htm
   • download: https://downloads.tableau.com/tssoftware/Tableau-SDK-Python-Win-64Bit-10-3-5.zip

import pytde
import pandas as pd

df = pd.read_csv("dataset.csv")
pytde.to_tde(df,"extract.tde")

1. Python3.5 works OK, with Tableau-SDK-PYTHON-64Bit-10-3-13.tar
2. Use zip in inner loop, speed up 6 times.
3. Use apply to to take place of outter loop(iterrows), speed up 1.5 time.