Jump to content
We've recently updated our Privacy Statement, available here. ×

Internal Table to Pandas Database


Dimitri Critsinelis

Recommended Posts

I am currently pulling multiple tables from SQL and adding columns to one data table (stored in-memory), so Ihave 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)

Link to comment
Share on other sites

input parameter should be defined in parameters section pointing to spotfire table which you would like to call using pandas.

Also, for creating spotfire calculated columns you do not need python. You can directly import data from SQL to spotfire and create custom calculated columns from Data > Add calculated column or Data > Column Properties > Insert > Calculated Column

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...