Re: Update: Can't read .csv from Google Analytics into SPSS

Posted by Rick Oliver-3 on Apr 05, 2011; 7:40pm
URL: http://spssx-discussion.165.s1.nabble.com/Multiple-imputation-tp1075737p4284937.html

Python has a CSV module. Don't know if it or something else in Python can address your problem. But if it can be solved with list manipulation, then you can do it Python, since it brings in the whole files as a list (or a tuple, I forget which).



From:        Ruben van den Berg <[hidden email]>
To:        [hidden email]
Date:        04/05/2011 02:31 PM
Subject:        Update: Can't read .csv from Google Analytics into SPSS
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Dear all,

I just discovered that I get a warning when I try to save the .xls file as an .xls file. It says something like "the file possibly contains functions that are not compatible with Unicode text". When I persist and save it anyway, I can read it into SPSS normally afterwards.

So from here, I'm off-topic since this has now become an .xls question in an SPSS mailing list. But if anybody knows how to "convert" or "adapt" a whole bunch of such nasty .csv files like this (perhaps with Python?), I'd be very grateful!

Thanks again,

Ruben