Re: Import a float field using a script

Thanks for your response

I am using djjango-extensions to run the script. Everything imports fine except the one field. The Category, Region, County and Iso's are foreign keys to the property.

The data in the csv for the area_hectares does contain in some cases no data but the format for the data is:

158.9265

70

58.9

150

7200000

665.03

Here is the contents of my import script

import csv  # https://docs.python.org/3/library/csv.html

# python manage.py runscript import_data_csv

from unesco.models import Category, County, Region, Iso, Property


def run():
    # file handler
    fhand = open('unesco/whc-sites.csv')
    reader = csv.reader(fhand)
    next(reader)  # Advance past the header

    contSuccess = 0
    Category.objects.all().delete()
    County.objects.all().delete()
    Region.objects.all().delete()
    Iso.objects.all().delete()
    Property.objects.all().delete()

    for row in reader:
        print(row)

        category_object, created = Category.objects.get_or_create(name=str(row[7]))
        county_object, created = States.objects.get_or_create(name=str(row[8]))
        region_object, created = Region.objects.get_or_create(name=str(row[9]))
        iso_object, created = Iso.objects.get_or_create(name=str(row[10]))
        e, created = Property.objects.get_or_create(name=row[0], description=row[1], sale_details=row[2], year=int(row[3]), longtitude=float(row[4]), latitude=float(row[5]), area_hectares=float(row[6]), category=category_object, county=county_object, region=region_object, iso=iso_object)

        contSuccess += 1
    print(f'{str(contSuccess)} inserted successfully! ')

On 16 Oct 2019, at 11:49, Kasper Laudrup <laudrup@stacktrace.dk> wrote:

Hi dtdave,

On 16/10/2019 12.28, 'dtdave' via Django users wrote:

In my script for importing from a csv I seem to run into the following error:
could not convert string to float
The relevant part of the script is as follows:
area_hectares=float(row[6])

That is impossible to tell without seeing the contents of your CSV file, but obviously row 6 of that file at least sometimes contains something that cannot be converted to a float.

I'd suggest you simply print out the values of row 6 in your script to see which values you cannot convert and then handle that. Possibly it's an empty string, in which case you might want to handle that by converting that to a NoneType, but that depends on your use case of course.

Kind regards,

Kasper Laudrup

--
You received this message because you are subscribed to a topic in the Google Groups "Django users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/django-users/vlHtz3JtsC0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/6360fe4d-e3f2-6825-e73a-ca93084667ae%40stacktrace.dk.