The SPSS Modeler is a data-mining tool by IBM. It's UI is user-friendly and easy to use, yet it is a great tool for data manipulation, data mining and data science. If you have trouble using it's built-in scripting language for stream automatisation, it might be useful to tag Python as well.
Questions tagged [spss-modeler]
136 questions
1
vote
1 answer
How to restructure data in SPSS Modeler
May I know how I can convert the data in SPSS Modeler as the image below?
I have read How to restructure data in SPSS Modeler?
and tried Restructure but it did not generate format like "From_1", "To_1", etc.
Greatly appreciate any…
StephL
- 27
- 4
1
vote
0 answers
SPSS Modeler setting the parametr in python script
I have a one problem with SPSS. I want to set the parameter using the python script.
The parametr name is pMacroregion and I'm using this parameter in Select Node. In this node I set the column value is equal the parametr value.
In my script, I…
Palczando
- 23
- 4
1
vote
1 answer
Adding a date to a filename through syntax spss modeler
I try to automatize my spss modeler flow and this flow exports excel files. In my excel files,the syntax is like "list_23.06.2023.xlsx". This syntax depends on which day is today,so how can i export my filename automatically?
Aybuke Meydan
- 11
- 1
1
vote
1 answer
Looping through column to perform amalysis on each
I have over 338 columns with different drug name in each column. what I want to do is to loop through all the columns using the code. This code is for one specific drug. The problem is I have 338 different drug names. The code is:
NPTESTS…
Hadi Zafar
- 31
- 1
1
vote
0 answers
SPSS Modeler SQL Query CASE Statement Link to Excel File
I'm using SPSS Modeler in order to connect to a database and run a SQL query.
Let's say I have a query like this
SELECT
COUNT(distinct
CASE WHEN "Product__Ord_Ln_"
IN
(
'Discount1',
'Discount2',
'Discount3',
/*
...
'Discount5000'
*/
)
THEN…
2837a
- 53
- 8
1
vote
1 answer
If-Ifelse logic with partly repeating condition
I1 S1 I2 S2 I3 S3 I4 S4 I5 S5 I6 S6 ACTUAL WANTED
10 1 10 2 0 0 0 0 0 0 0 0 3 3
10 1 10 2 10 3 0 0 0 0 0 0 3 6
10 1 10 2 10 3 10 4 0 0 0 0 3 10
if I1=I2 then (S1+S2)
elseif I1=I2=I3 then…
marabiocho92
- 11
- 2
1
vote
0 answers
Error: Unable to complete last action in Watson Studio Modeler flows
I`m trying training a model with a little dataset (1000 rows), but Modeler flow of IBM Watson Studio takes too long time in "Running flow Status: Training model process completed, took 4 minutes and 20 seconds" state.
After this, result in generic…
Luiz Carvalho
- 1,549
- 1
- 23
- 46
1
vote
1 answer
Implementing Python into IBM SPSS Modeler 18.2
I would like to know how to get into dataframe using Python in IBM SPSS Modeler?
So far the only thing I've noticed was a piece of code which itself is not that clear.
Example: SPSS modeler Extension Transform - Python
As you probably know for R in…
Filip
- 63
- 3
1
vote
1 answer
How to discard records in SPSS Modeler by row/field numbers?
I have a number of records with no meaning. Would like to discard from row 1 to 20 for example.
What is the expression to input in the Select-->Discard Node? Or any other node to suggest?
Thank you in advance!!
image attached
intake.soy
- 11
- 1
1
vote
1 answer
Design matrix macro interpretation
After study the macro section from a SPSS book, I'm still having trouble to understand why/how this code works
DEFINE !Combinations (Set = !TOKENS(1)
/Len = !TOKENS(1) )
INPUT PROGRAM.
!LET !Str = " ".
!LET !LisVar = "".…
Roland
- 334
- 2
- 21
1
vote
2 answers
Assigning bins to records in CHAID model
I built a custom CHAID tree in SPSS modeler. I would like to assign the particular terminal nodes to all of the records in the dataset. How would I go about doing this from within the software?
matsuo_basho
- 2,833
- 8
- 26
- 47
1
vote
3 answers
Replacing values with SPSS Modeler
I am currently trying to perform data cleaning on my dataset containing 2K records from online transactions from an online supermarket.
In my dataset, there are a few data quality issues -
1) "?" in my Income columns as shown
May I know how do I…
plzhelp
- 185
- 1
- 3
- 9
1
vote
2 answers
Excel output of SPSS Modeler
In using the dataset SP500W90 for Artificial Neural Network in SPSS Modeler, I have a simple stream below.
It generate a result of accuracy 90.9%.
I want to output the predicted values side by side with the existing “closing”, however it doesn’t…
Mark K
- 8,767
- 14
- 58
- 118
1
vote
1 answer
Running CHAID on continuous predictors
Please, did anyone try to run CHAID algorithm on continuous predictors ??
At first, I used SPSS Modeler and it worked fine.
but when I tried it on Python 3.6, it didn't work for me.
Thanks :)
P.S. CHAID package could be found here…
Ahmed Al
- 11
- 2
1
vote
1 answer
binomial mixed effects model BIC - R vs SPSS
I'm trying to calculate Bayes Factor from my data and I'm getting very different results in R and SPSS for my mixed effects model. It's fine for a linear one, but not binomial. Here is the R code:
``memory.model = glmer(correct ~ (1|ps) + (1|item),…
Agata
- 343
- 3
- 13