Where are my csv files and why I can't import .xsl files&
Where are my csv files and why I can't import .xsl files&
When I use smartPLS, I can't find the csv files. Moreover, I can't import .xsl files? Why? Who can tell me? Please help me! Thank you very much!
Two tips from a smartPLS-Newbie:Diogenes wrote: Take care with: missing values, blanks, strings...
- When CSV-Files are imported (via right-click on the project-icon in the project tab -> Import Indicator data) smartPLS moves the file from its original place to project's subfolder of the current smartPLS workspace directory.
- I was used to use the string "NA" as a placeholder for missing values in all my data files (because I do other statistical stuff in R). It took me a whole day of trial and error (plus extensive forum search) to realize, that smartPLS cannot handle "NA", because smartPLS does not allow any character values in the data file! (except the head line of course). Not even in columns that you never intended to use in your analysis. Replacing "NA" with some unique integer (e.g. 99999) is a 3-seconds tasks with any text editor, but removing all kind of non-integer factor variables (e.g. species names) is sometimes really annoying.