downloads SDSS spectrum of a given sql query result which includes specobjid

mineSDSS.py

#!/usr/bin/python

from os import popen

def loadData(inputFile,delimiter):
    data = []
    for line in inputFile:
        if line.startswith("#"):
            continue
        data.append([str(v) for v in line.strip().split(delimiter)])
    return data

def transpose(data):
        return [[data[j][i] for j in range(len(data))] for i in range(len(data[0]))]


if __name__ == '__main__':
	sql = 'result.csv'
	data = loadData(open(sql),',')
	cols = transpose(data[1:])
        print data[0]
        i_id = data[0].index('specobjid')
        print i_id

        sdss_core = 'http://skyserver.sdss3.org/dr9/en/get/specById.asp?id='
	for id in cols[i_id]:
          popen('wget '+sdss_core + id)