Spotfire and Python Data Type Mapping

To create Python data functions in Spotfire, you need to know how the data types in each application map to each other. This table provides that mapping, including data type mapping to Pandas column dtype, and for mapping columns and tables.

Exported data from Spotfire and received by Python
Data type exported from Spotfire Data type received by Python Pandas column dtype
Integer int Int32
LongInteger int Int64
Real float float64
SingleReal float float32
Currency decimal.Decimal object
Date datetime.date object
DateTime datetime.datetime object
Time datetime.time object
TimeSpan (not supported) (not supported)
Boolean bool object
String str object
Binary bytes object
  • Spotfire columns map in Python to Pandas Series type.
  • Spotfire tables map in Python to Pandas DataFrame type.
Sent from Python and Imported into Spotfire
Data type sent by Python Data type imported into Spotfire
int LongInteger
float Real
decimal.Decimal Currency
datetime.date Date
datetime.datetime DateTime
datetime.time Time
datetime.timedelta TimeSpan
bool Boolean
str String
byte Binary