Discussion:
reading csv data set
(too old to reply)
someone
2017-12-30 00:00:59 UTC
Permalink
Hi all


I'm trying to read in a data set, in csv. I also have xls and ods versions, all here
https://sites.google.com/site/gsocialchange/datasets



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
https://sourceforge.net/projects/pspp4windows/

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
ftr public
2017-12-30 15:04:34 UTC
Permalink
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
Post by someone
Hi all
I'm trying to read in a data set, in csv. I also have xls and ods versions, all here
https://sites.google.com/site/gsocialchange/datasets
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
https://sourceforge.net/projects/pspp4windows/
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
https://lists.gnu.org/mailman/listinfo/pspp-users
someone
2017-12-30 17:49:02 UTC
Permalink
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 <***@free.fr>
To: pspp-users <pspp-***@gnu.org>
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

https://sites.google.com/site/gsocialchange/datasets





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

https://sourceforge.net/projects/pspp4windows/


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
ftr public
2017-12-30 21:08:00 UTC
Permalink
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
Post by someone
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=",".
.19: error: Syntax error at end of command: expecting '/'.
Does that help?
Thanks
Gene
-----Original Message-----
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
Hi all
I'm trying to read in a data set, in csv. I also have xls and ods
versions, all here
https://sites.google.com/site/gsocialchange/datasets
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
https://sourceforge.net/projects/pspp4windows/
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
https://lists.gnu.org/mailman/listinfo/pspp-users
_______________________________________________
Pspp-users mailing list
https://lists.gnu.org/mailman/listinfo/pspp-users
someone
2017-12-31 00:35:45 UTC
Permalink
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 <***@free.fr>
To: someone <***@aol.com>; pspp-users <pspp-***@gnu.org>
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 <***@free.fr>
To: pspp-users <pspp-***@gnu.org>
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

https://sites.google.com/site/gsocialchange/datasets





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

https://sourceforge.net/projects/pspp4windows/


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
someone
2017-12-31 14:15:03 UTC
Permalink
Could I ask what syntax you used to read my csv data set?


Thanks again for all your feedback


Gene




-----Original Message-----
From: someone <***@aol.com>
To: public.ftr <***@free.fr>; pspp-users <pspp-***@gnu.org>
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 <***@free.fr>
To: someone <***@aol.com>; pspp-users <pspp-***@gnu.org>
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 <***@free.fr>
To: pspp-users <pspp-***@gnu.org>
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

https://sites.google.com/site/gsocialchange/datasets





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

https://sourceforge.net/projects/pspp4windows/


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
ftr public
2018-01-01 20:40:37 UTC
Permalink
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
Post by someone
Could I ask what syntax you used to read my csv data set?
Thanks again for all your feedback
Gene
-----Original Message-----
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-----
Sent: Sat, Dec 30, 2017 4:09 pm
Subject: Re: reading csv data set
Hi,
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
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=",".
.19: error: Syntax error at end of command: expecting '/'.
Does that help?
Thanks
Gene
-----Original Message-----
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
Hi all
I'm trying to read in a data set, in csv. I also have xls and
ods versions, all here
https://sites.google.com/site/gsocialchange/datasets
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
https://sourceforge.net/projects/pspp4windows/
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
https://lists.gnu.org/mailman/listinfo/pspp-users
someone
2018-01-03 00:26:03 UTC
Permalink
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"



https://sites.google.com/site/gsocialchange/datasets




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 <***@free.fr>
To: pspp-users <pspp-***@gnu.org>
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 <***@aol.com>
To: public.ftr <***@free.fr>; pspp-users <pspp-***@gnu.org>
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 <***@free.fr>
To: someone <***@aol.com>; pspp-users <pspp-***@gnu.org>
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 <***@free.fr>
To: pspp-users <pspp-***@gnu.org>
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

https://sites.google.com/site/gsocialchange/datasets





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

https://sourceforge.net/projects/pspp4windows/


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
ftr public
2018-01-03 13:15:50 UTC
Permalink
Hi Gene,

The next logical question is : which is your version on which OS ?

-ftr
Post by someone
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"
https://sites.google.com/site/gsocialchange/datasets
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
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-----
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
Could I ask what syntax you used to read my csv data set?
Thanks again for all your feedback
Gene
-----Original Message-----
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-----
Sent: Sat, Dec 30, 2017 4:09 pm
Subject: Re: reading csv data set
Hi,
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
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=",".
.19: error: Syntax error at end of command: expecting '/'.
Does that help?
Thanks
Gene
-----Original Message-----
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
Hi all
I'm trying to read in a data set, in csv. I also have xls
and ods versions, all here
https://sites.google.com/site/gsocialchange/datasets
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
https://sourceforge.net/projects/pspp4windows/
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
https://lists.gnu.org/mailman/listinfo/pspp-users
_______________________________________________
Pspp-users mailing list
https://lists.gnu.org/mailman/listinfo/pspp-users
someone
2018-01-03 23:35:41 UTC
Permalink
Well, I wrote to the pspp people and they said, actually, that there was a bug


"The bug must be there for a longer time as it was already in the 2017-07-30 version. However it is solved in the 2017-11-16 version."


I am trying to get the newest version, as it is not clear whether at November version is on their website.

I will keep you posted.


Thanks


Gene



-----Original Message-----
From: ftr public <***@free.fr>
To: someone <***@aol.com>; pspp-users <pspp-***@gnu.org>
Sent: Wed, Jan 3, 2018 8:16 am
Subject: Re: reading csv data set



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"





https://sites.google.com/site/gsocialchange/datasets

Loading...