Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Correlation Matrix Not Available
Added on June 14, 2020 1:12AM
Likes: 1
Replies: 2
Shepherd
Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Registered Posts: 19 ✭✭✭✭✭
I want to perform correlation matrix analysis on a dataset but all the fields are greyed out and not available, making it impossible to do the analysis.
I was expecting to be able to select fields for use in the analysis, but DSS greys out all the fields immediately I enter the "Correlation matrix" window.
What could I be missing?
See attached image
Best Answers
-
Hi,
The Statistics capability in DSS relies on the storage type of the columns to know if they are numerical or categorical. Only numerical columns are eligible for correlation matrix. At the moment, all your columns are categorical (i.e. "string")
You have two options:
* Use a prepare recipe to create a new output dataset with types infered from the input
* Or go to the Settings of the dataset, then go to Schema, click on "Check now" then on "Infer types from data" in order to compute storage types that match your data -
Shepherd Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Registered Posts: 19 ✭✭✭✭✭
I tried both options. They work perfectly.
Thanks
