final_filter.py

df['lon'] = df['Адрес'].apply(lambda row: georef[row][0])
df['lat'] = df['Адрес'].apply(lambda row: georef[row][1])

def numberIt(cell):
    if not cell or '*' in cell:
        return None
    tokens = cell.split(' ')
    if ('менее' in tokens):
        return float(tokens[-1])/2
    else:
        return float(cell)
    
df.iloc[:,2:9] = df.iloc[:,2:9].applymap(numberIt)

df.to_csv('spb_pollution_record.csv')