[Tutor] Converting a string into dictionary references

[Joel Goldstick]

On Mon, Apr 23, 2012 at 8:56 AM, Gerhardus Geldenhuis
<gerhardus.geldenhuis at gmail.com> wrote:
> Hi
> Appologies about the subject I could not think of a better description.
>
> I have this very simple function:
>
> def readcsvfile(filename):
>   f = open(filename, 'ro')
>   csvdata = csv.DictReader(f)
>   for row in csvdata:
>     print row["column3"]+','+row["column1"]
>
> I have another inputfile that will be comma separated list of values.
> Eg:
> column3,column4,column10
>
> The idea is that I use this inputfile to tranform the original csv file. I
> thus want a new file with only the specified columns. I am sure there is an
> elegant way of doing this but I am not sure how to convert my print
> statement into something more dynamic. Any pointers would be appreciated.
>
> Regards
>
> --
> Gerhardus Geldenhuis
>
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> To unsubscribe or change subscription options:
> http://mail.python.org/mailman/listinfo/tutor
>

So you want to take 'column1' and get back 1?, 'column10' and get back 10?

s = 'column1'
i = int(s[6:])

This will only work if your strings all start with the text 'column'

-- 
Joel Goldstick