Internal Table to Pandas Database

I am currently pulling multiple tables from SQL and adding columns to one data table (stored in-memory), so I have one big table that i can refresh and get new data. I am trying to get this table into a pandas dataframe so i can add calculated columns using python. Im pretty new to spotfire, but i have have pandas already installed, anyone have any example code or can provide guidance i would greatly appreciate it.

This is how i normally pull data with pandas using excel. 

import pandas as pd

# Inputs and Outputs
input = 'Daily Frac Data.xlsx'
output = 'Daily Frac Summary.xlsx'

# Master Data frame
df = pd.read_excel(input, header=4)

 

(1) Answer

Login