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)