def handle_noargs(self, **options):
data_reader = csv.reader(open(SOURCE_FILE))
def clean_int(value):
if value <> '':
value = int(value.replace(',', '').replace(' ', ''))
else:
value = None
return value
for i, row in enumerate(data_reader):
if i == 0:
header_row = row;
else:
record = KidsHealthInsurance()
for j,col in enumerate(row):
setattr(record, header_row[j], col)
record.save()
def handle_noargs(self, **options):
data_reader = csv.reader(open(SOURCE_FILE))
def clean_num(value):
if value.strip()=='':
value=None
elif value.find(".") <> -1:
value = value.replace(",","")
value = float(value)
else:
value = value.replace(",","")
value = int(value)
return value
for i, row in enumerate(data_reader):
if i == 0:
header_row = row;
else:
record = KidsHealthInsurance()
for j,col in enumerate(row):
if j == 0:
setattr(record, header_row[j], col)
else:
setattr(record, header_row[j], clean_num(col))
record.all_people = record.all_people * 1000
record.not_covered = record.not_covered * 1000
record.covered = record.covered * 1000
record.private = record.private * 1000
record.private_employment = record.private_employment * 1000
record.direct_purchase = record.direct_purchase * 1000
record.govt = record.govt * 1000
record.medicaid = record.medicaid * 1000
record.medicare = record.medicare * 1000
record.military = record.military * 1000
record.save()
def handle_noargs(self, **options):
data_reader = csv.reader(open(SOURCE_FILE))
def clean_num(value):
if value.strip() == '':
value = None
elif value.find(".") <> -1:
value = value.replace(",", "")
value = float(value)
else:
value = value.replace(",", "")
value = int(value)
return value
for i, row in enumerate(data_reader):
if i == 0:
header_row = row
else:
record = KidsHealthInsurance()
for j, col in enumerate(row):
if j == 0:
setattr(record, header_row[j], col)
else:
setattr(record, header_row[j], clean_num(col))
record.all_people = record.all_people * 1000
record.not_covered = record.not_covered * 1000
record.covered = record.covered * 1000
record.private = record.private * 1000
record.private_employment = record.private_employment * 1000
record.direct_purchase = record.direct_purchase * 1000
record.govt = record.govt * 1000
record.medicaid = record.medicaid * 1000
record.medicare = record.medicare * 1000
record.military = record.military * 1000
record.save()