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
6
votes
2 answers
how to make "modelerData" and "modelerDataModel" correctly in "Extension Transform (R syntax)" node adding multiple cols
I use SPSS modeler v18.2.1 with R v3.5.1 (or v3.3.3) using
Essentials for R 18.2.1.
I'm trying to make "Extension Transform (R syntax)" nodes to deal with some problems difficult for SPSS (future: make them Extension Bundles). I want them to add…
cuttlefish44
- 6,586
- 2
- 17
- 34
5
votes
1 answer
Pandas module in SPSS Modeler
I need to put a certain code developed in Python 3 into a SPSS Modeler node (using the Extension Transform node). This code uses pandas and the default installation of Modeler doesn't include this module.
I tried to make SPSS to point to my own…
Pacullamen
- 165
- 1
- 1
- 7
5
votes
1 answer
IBM spss Modeler, how to delete rows containing missing values
All my data is in a .txt file, Field delimiters are Comma and Newline. So I used the "Var. File" component as Source component.
I am trying to figure out how to delete the rows containing null values, and then get the output for further processing.
belas
- 277
- 4
- 17
4
votes
0 answers
SPSS modeller student activation not working
While trying to activate SPSS Modeller student activation receiving the below error, irrespective of clearing cookies or trying from different laptop same issue.
Another IBMid has already been used with this application. Please clear your browser's…
user11959661
- 41
- 1
3
votes
2 answers
Question about SPSS modeler (There is an obstacle for make the stream run automatically)
I have SPSSmodeler stream which is now used and updated every week constantly to generate a certain dataset. A raw data for this stream is also renewed on a weekly basis.
In part of this stream, there is a chunk of nodes that were necessary to…
Toshi
- 45
- 7
2
votes
2 answers
Reading the spss file java
SPSSReader reader = new SPSSReader(args[0], null);
Iterator it = reader.getVariables().iterator();
while (it.hasNext())
{
System.out.println(it.next());
}
I am using this SPSSReader…
Great Person
- 62
- 10
2
votes
1 answer
Using df.withColumn() on multiple columns
I am working with python and pyspark to extend the SPSS Modeler.
I want to manipulate ~5000 columns and therefore use the following construct:
for target in targets:
inputData = inputData.withColumn(target+appendString, function(target))
This…
pandayo
- 310
- 2
- 13
2
votes
1 answer
Modify values programmatically SPSS
I have a file with more than 250 variables and more than 100 cases. Some of these variables have an error in decimal dot (20445.12 should be 2.044512).
I want to modify programatically these data, I found a possible way in a Visual Basic editor…
Joseph
- 149
- 1
- 2
- 9
2
votes
1 answer
How to restructure data in SPSS Modeler?
could you please advise on restructuring the data so to get the data structure that can be used for time series modeling in SPSS Modeler?
E.g. (currently having the below structure)
ID Period Value
ABC 1 100
ABC 2 110
DEF 1 …
Patricia
- 41
- 1
- 6
2
votes
1 answer
Why represent neural network quality as 1 minus the ratio of the mean absolute error in prediction to the range of the predicted values?
The documentation for IBM's SPSS Modeler defines neural network quality as:
For a continuous target, this 1 minus the ratio of the mean absolute error in prediction (the average of the absolute values of the predicted values minus the observed…
Blinky
- 200
- 2
- 14
2
votes
1 answer
How to delete a row from table using SPSS Modeler
I'm using SPSS Modeler 17.0 and I want to delete a row from a table. In export database node there is only the option Delete all existing records. It deletes all the records and does enable to delete just one using a WHERE sql like condition.
Is…
deltascience
- 3,321
- 5
- 42
- 71
2
votes
1 answer
How to set an SPSS model nugget to be automatically placed on palette only?
This is a very very trivial question. However, it's impossible to find the answer online so far.
Allow me to describe what happens -
In SPSS Modeler, when a model (CHAID in this case) is run, it generates a nugget and the nugget is automatically…
vieplivee
- 121
- 5
1
vote
1 answer
Deriving multiple fields in SPSS modeler (using unique fields each time)
I'm using SPSS modeler to calculate the accuracy of various weekly estimates. I have a data table with a couple weeks of estimates and a couple weeks of actual data points. Currently, to calculate the errors per week I have to use a derive node for…
Som Naik
- 11
- 1
1
vote
1 answer
Automated transfer of files to an SFTP - SPSS Modeler / PS Clem
We currently use SPSS Modeler for our analytics and output to excel files for reporting. We automate the running of modeler streams with PS Clementine.
We do have access to SQL server tables within Modeler via ODBC connections.
What I need to do is…
Help_appreciated
- 11
- 1
1
vote
1 answer
How to combine/merge rows in SPSS Modeler?
Please advice how to transform the original dataset to the expected output as shown below on SPSS Modeler?
It is expected to merge the values of all rows shared the same ID No.
StephL
- 27
- 4