|
From: | Karl Sinn |
Subject: | Re: problems importing csv files |
Date: | Mon, 03 Nov 2014 18:27:48 +0100 |
User-agent: | Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.6.0 |
Hi, I tried to read your file into R and it worked with no errors but.... The data is absolutely not usable for any statistics. Sometimes I get values, sometimes labels and also the whole information about the coding is included in this csv file. For me this looks like a SPSS file in csv-format which is IMO nonsense. Can you export the data in a different format? Can you choose to only have variables and data without the coding and label information in the file? If you will be able to get a "clean" csv, I'm pretty sure pspp won't cause you any more trouble. Karl Am 01.11.2014 19:21, schrieb Benjamin
Oppermann:
Hello, This is psppire 0.7.9 on Kubuntu 14.04. All software was installed and kept up to date from the GNU/Linux distro repositories. I can't get this .csv file correctly imported into pspp. I opened it in Libreoffice Calc (v.4.2.6.3) and saved as .osd. To be honest, I'm not sure whetherI should choose commas or semicolons or both as separating chars. In Calc, semicolons only or bot seems to look neat, but PSPP jumbles everything up. Some variables have mixed data types, e.g. the text of the given answer mixed with the numbers corresponding to the answer. For reference, I attached one file that was output as a result of the same online survey, and has fewer cases than the one I'm working with now, but the same variables. Thanks, Ben |
[Prev in Thread] | Current Thread | [Next in Thread] |