I am pretty sure there is something wrong with the pspp version I got.
I followed these steps on the pspp gui, and got a data set, but see the problems below
file
import data
click on "testing.csv"
buttons on lower right are "reset", "next", "cancel"
click on next
upper left shows
"Select the lines to import"
"Select file to import"
lower right shows "reset", "next", "back", "finish" and "cancel"
click on next
upper left shows
"Select the first line"
"Select file to import"
click on next
upper left shows
"choose separators"
"Select file to import"
now lower right only shows "reset", "next", "back" and "cancel"
upper left shows
"adjust variable formats"
"Select file to import"
lower right had "finish"
click finish
data set is read in, but:
variable names disappeared
there is an extra first and last line
At each step where the upper left showed that I was -supposed- to be able to do something, there was no opportunity to do so, nothing appeared which would allow me to select, choose, adjust, or anything.
This seems to be a really simple csv data set, and it didn't work, so I can only conclude this version of pspp isn't working, for the windows set up I have. Again, I think it's windows 10, on a 64 bit laptop, and I downloaded pspp a couple of days ago from here
https://sourceforge.net/projects/pspp4windows/
Would I tell these problems to the people there?
Thanks
Gene
-----Original Message-----
From: ftr public <address@hidden>
To: pspp-users <address@hidden>
Sent: Mon, Jan 1, 2018 3:42 pm
Subject: Re: reading csv data set
Hi Gene,
I tried another way: I downloaded the csv file and directly
opened it in Libreoffice, without saving it, see the attached
screen capture. The LO interface is in French, but the buttons
should be at the same place in all of the different
language-versions of LO. And then you can open the ods file via
the GET DATA command. I have no syntax for the csv file. Did you
look into the PSPP manual p.86- ?
Regards
-ftr
On 31/12/2017 15:15, someone wrote:
Could I ask what syntax you
used to read my csv data set?
Thanks again for all your feedback
Gene
-----Original
Message-----
From: someone
<address@hidden>
To: public.ftr
<address@hidden>; pspp-users
<address@hidden>
Sent: Sat, Dec 30, 2017 7:35 pm
Subject: reading csv data set
Thanks. I'm not really clear on what you
mean.
"integrating several field
delimiter into a single one"
"Only when you stop the last
functionality the importation went as expected."
Can you please
explain or give example?
Thanks for your help.
Gene
-----Original
Message-----
From: ftr public <
address@hidden>
To: someone <
address@hidden>;
pspp-users <pspp-
address@hidden>
Sent: Sat, Dec 30, 2017 4:09 pm
Subject: Re: reading csv data set
Hi,
I imported the ods data file with the
following syntax:
GET DATA /TYPE=ODS
/FILE="(file path)\pd_data_cia.ods"
/READNAMES=ON.
and it worked.
I also imported the csv file into Libreoffice
Calc to see the data. When using the comma as
a field delimiter I realised that the function
of integrating several field delimiter into a
single one made that the imported data and the
column headers did not fit : there were too
few data columns. Only when you stop the last
functionality the importation went as
expected.
Thanks for the idea of a direct importation of
ods files into PSPP of which I was unaware.
- ftr
On
30/12/2017 18:49, someone wrote:
Hi
Thanks for the response. I imported
the ods file through the gui interface.
That is,
file
import data
went to my directory, clicked on the
ods data set
next
got the screen importing spreadsheet
data
next
apply
I did notice that, when I read the
ods file, pspp, in the output viewer,
showed this
get data
/type=ods
/file="C:\Users\Owner\Documents\icaap\data\testdata\PD_data_cia.ods"
/sheet=index 1
/readnames=on
/cellrange=range "a1:al236".
So to try to read the csv file, I tried
this
get data
/ type=txt
/
file="C:\Users\Owner\Documents\icaap\data\testdata\PD_data_cia.csv"
/ arrangement=delimited
/ firstcase=2
/ delimiters=",".
now, only one error:
.19: error: Syntax error at end of
command: expecting '/'.
Does that help?
Thanks
Gene
-----Original
Message-----
From: ftr public
<address@hidden>
To: pspp-users
<address@hidden>
Sent: Sat, Dec 30, 2017 10:05 am
Subject: Re: reading csv data set
Hi Gene,
I also tried to import the
csv data file and got into
difficulties.
How did you import the ods
file ? Can you send the syntax ?
What is funny is that the
country data set has no case,
i.e. country, names.
Regards,
ftr
On
30/12/2017 01:00, someone wrote:
Hi all
I'm trying to read in a
data set, in csv. I also
have xls and ods versions,
all here
All the files I'm looking
at are versions of the
pd_data_cia data set.
I -have- imported the ods
version, but when I try to
import the csv version, I
just get blank. I go to
file, import data, go to my
directory, and all the files
are listed. I click on
pd_data_cia.cvs, and then on
the upper left of the
screen, where it says select
file to import, I cannot
select any of the options.
I am using pspp
version 1.0.1-g818227,
downloaded a couple of days
ago from here
I'm on windows, 64 bit
operating system, I think
windows 10.
I also tried using the
command line, and, well, not
doing it right, perhaps
someone can help? These are
the lines I tried
get data
/ type=txt
/
file=’C:\Users\Owner\Documents\icaap\data\testdata\PD_data_cia.csv’
/
arrangement=delimited
/ firstcase=2
/ delimiters=","
Thanks
Gene Shackman
_______________________________________________
Pspp-users mailing list
address@hidden
https://lists.gnu.org/mailman/listinfo/pspp-users
_______________________________________________
Pspp-users mailing list
Pspp-
address@hidden
https://lists.gnu.org/mailman/listinfo/pspp-users