from pymongo import MongoClient import csv import sys def pfl(val): try: return float(val) except: return None with open(sys.argv[1]) as csvfile: collec = MongoClient()["galaxy"]["comets"] for row in csv.reader(csvfile, delimiter="\t"): try: collec.insert({"name":row[0],"observer":row[1],"type":row[2],"period":pfl(row[3]), "ecc":pfl(row[4]),"semaj_axs":pfl(row[5]), "perih_dist":pfl(row[6]), "incl":pfl(row[7]), "abs_mag":pfl(row[8])}) except: print "Error: could not import: ", row