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.

Spotfire 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 datetime.timedelta object
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.