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.
Table 1. 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.
Table 2. 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
|