In [1]:

    

import pandas as pd


    

In [2]:

    

file = "data/neolithic sites_coordinates_Anatolia.xlsx" 
data = pd.read_excel(file)


    

In [4]:

    

gps = DC_site_geographicalreferencesystem.objects.get(name="WGS84 - World Geodetic System 1984")
source = DC_site_coordinatesource.objects.get(name="OREA")


    

In [6]:

    

duplicates = []
for index, rows in data.iterrows():
    try:
        temp_site, _ = Site.objects.get_or_create(name=rows['Site name'])
        temp_site.save()
        temp_site.geographical_coordinate_reference_system = gps
        temp_site.coordinate_source = source
        temp_site.latitude = float(rows['X'].replace(",", "."))
        temp_site.longitude = float(rows['Y'].replace(",", "."))
        temp_site.exact_location = "yes" 
        temp_site.save()
    except:
        duplicates.append(rows['Site name'])
        print(rows['Site name'])


    

In [7]:

    

len(duplicates)


    

    
Out[7]:





0