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

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




    _______________________________________________
    Pspp-users mailing list
    Pspp-users@gnu.org <mailto:Pspp-users@gnu.org>
    https://lists.gnu.org/mailman/listinfo/pspp-users


_______________________________________________
Pspp-users mailing list
Pspp-users@gnu.org <mailto:us...@gnu.org>
https://lists.gnu.org/mailman/listinfo/pspp-users


_______________________________________________
Pspp-users mailing list
Pspp-users@gnu.org
https://lists.gnu.org/mailman/listinfo/pspp-users

Reply via email to