Hi Gene,
The next logical question is : which is your version on which OS
?
-ftr
On 03/01/2018 01:26, someone wrote:
Hi
I am pretty sure there is something wrong with the pspp
version I got.
I made a simple csv file here, called "testing.csv"
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
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
|