Statistica Python node function "ActiveDataSet" gives warning of creating Pandas data frame column via new attribute name

Statistica Python node function "ActiveDataSet" gives warning of creating Pandas data frame column via new attribute name

book

Article ID: KB0076937

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.5

Description

In Statistica Python scripting node, "ActiveDataSet" function is used to read an upstream input spreadsheet to a Pandas data frame, for example "trainDS = ActiveDataSet['trainData']" or "trainDS = ActiveDataSet[0]".

When using "ActiveDataSet" function in Statistica Python node, user may get below warning of creating Pandas data frame:

UserWarning: Pandas doesn't allow columns to be created via a new attribute name - see https://pandas.pydata.org/pandas-docs/stable/indexing.html#attribute-access
retPDF.VariableFormatString = varFormatString


User-added image

Issue/Introduction

Statistica Python node function "ActiveDataSet" gives warning of creating Pandas data frame: "Pandas doesn't allow columns to be created via a new attribute name".

Environment

Windows

Resolution

Pandas version of 0.18.1 or higher is required to be installed in order to use ActiveDataSet function in Statistica Python node.

Above warning of "Pandas doesn't allow columns to be created via a new attribute name" when using ActiveDataSet function, occurs if user is using Pandas version 0.21.0 or above, including 0.21.0, 0.21.1, 0.22.0, 0.23.0, 0.24.2, e.t.c. 
Such warning vanishes when user installed Pandas version 0.20.3 or below, including 0.20.3, 0.19.2, 0.19.1 and 0.18.1.

The warning does not raise error to the execution of the Python node. It however might be a nuisance to users. 
If the users wants to get rid of this warning message, he/she may consider installing Pandas version 0.20.3 or lower.
Pandas version 0.21.0 or above will give such warning message when using "ActiveDataSet" function in Statistica Python node. 

Hints: 
command to install latest version of Pandas for your Python version: " pip install pandas"
command to uninstall currently installed version of Pandas: " pip uninstall pandas"
command to install a specific version of Pandas (e.g. 0.18.1): " pip install pandas==0.18.1