First let’s import our libraries and get the dataset in.

import pandas as pd
import numpy as np
Assess_Combined = pd.DataFrame.from_csv("Assess_Combined.csv",encoding="UTF-8")

Now, let’s create a function to find the upper and lower bounds for both latitude and longitude.

def locationSlice():
    Map_Points = Assess_Combined[['LATITUDE','LONGITUDE']]
    a= Map_Points.max()['LATITUDE']
    b= Map_Points.min()['LATITUDE']
    c= Map_Points.max()['LONGITUDE']
    d= Map_Points.min()['LONGITUDE']
    print(a)
    print(b)
    print(c)
    print(d)

And let’s run it.

locationSlice()

Now that we know the bounds, what we want to do is find the distance from bound to bound. This will be what we slice up for our grid. We’ll modify the function, and get the variables as such below.

def locationSlice(slice_constant):
    Map_Points = Assess_Combined[['LATITUDE','LONGITUDE']]
    a= Map_Points.max()['LATITUDE']
    b= Map_Points.min()['LATITUDE']
    c= Map_Points.max()['LONGITUDE']
    d= Map_Points.min()['LONGITUDE']
    lat_range = (a-b)/slice_constant
    lon_range = (c-d)/slice_constant
    return (a,b,c,d,lat_range,lon_range)
a,b,c,d,lat_range,lon_range = locationSlice(100)

Our next move is to represent these location slices as numbers in the grid.