There are chances that we encounter issues with the conversion of data types .
A file of type csv need to be given as a source of input to spss modeler for analysis.
Except the first column all other column contains numbers- integers/ float or decimals.
But surely of non character data types.
When the source file is added , the type of data is displayed as nominal instead of integer.
What to do with this kind of issue ? How to handle it ?
- Check the various options given in the source node- var
- There are possibilities that space, tab were checked. Need to decide whether those are required.
- Analyse the source data whether any special characters were added. Ex- comma, semi colon, hyphen etc. These create troubles for the modeler to understand the type of data.
- If needed delete those without loosing the context of data or rename it if needed.
- These four simple steps can make the data pure of its form
- After keying in the file to the modeler, check whether the required data type is understood by the software. Now it is possible to change/ modify , add dummies, and edit according to our need.
Learning from the experience through blogs, forums saves lot of time in the during data modeling.
