Reading columns or cell data using Pandas

[zinaw Tesemma]

Hi

New user and still learning..

I have spotfire that is connected to sql server and I have my table lets call ittable1. I also added python function (using pandas) which works wellon basic items with input/ouput etc.. I am using version spotfire 10.4

my question is, I can't seems to get my python to interact with internal table (table1).

not sure what syntax I need to add or import

e.g If my data have column names firstName,lastName

I want to use panda pythonand get the value of columns from my table.

using a simple code like this

Name1 = tableName['firstName'] don't work

or am I missing a step(s) in retrieving the data

 

thanks

[zinaw Tesemma]

found the solution, the data connection have to be stored in-memory.