[Tutor] Python for SPSS help

[Alan Gauld]

On 01/10/13 19:21, Elise Rosa wrote:
> Hello!
>
> I'm using Python in SPSS to rename and arrange some files. The setup is
> this: I have many .txt files in a folder, and I'd like to first remove
> part of their names. Next, I need to paste the second and third columns
> from each .txt file into another document (could be an excel sheet), and
> match them all by the first column in each .txt file (subject number). I
> also need to rename the second and third columns when they are going
> into the excel file with the name of the .txt file they came from.

Doesn't look like SPSS is particularly significant it's
just text file manipulation. Given you mention the data
being in columns and you want to manipulate the column
names  it sounds like the CSV module should be able to help.

Are you familiar or have you looked at csv yet?
If not take a look at the docs then come back with any
questions.

For manipulating file names the standard os/path/shutil
modules should provide all you need combined with some string
processing.

HTH
-- 
Alan G
Author of the Learn to Program web site
http://www.alan-g.me.uk/
http://www.flickr.com/photos/alangauldphotos