A
andydtaylor
Hi
I have some convenient short place name IDs which would be handy for columnnames. Unfortunately, many begin with a number.
I can work around this by appending a letter to each one, but should I escape the number in such a way that I can use it directly as my column name, in the same way as I might an apostrophe? How could I do that? I wondered what the best approach is to take.
My python list come out looking like this:
['9400ZZLUACY1', '490000238006', '490000276005', '9400ZZLUACT2']
I'm producing it using this code:
.... if row[8]:
.... # Station values for database
.... stn_list_short.append(row[0])
And trying to employ the list something like this:
Thanks,
Andy
I have some convenient short place name IDs which would be handy for columnnames. Unfortunately, many begin with a number.
I can work around this by appending a letter to each one, but should I escape the number in such a way that I can use it directly as my column name, in the same way as I might an apostrophe? How could I do that? I wondered what the best approach is to take.
My python list come out looking like this:
['9400ZZLUACY1', '490000238006', '490000276005', '9400ZZLUACT2']
I'm producing it using this code:
.... if row[8]:
.... # Station values for database
.... stn_list_short.append(row[0])
And trying to employ the list something like this:
Thanks,
Andy