Function that works in python but sql doesn't pyspark

Question

Function that works in python but sql doesn't pyspark

I have successfully performed a function, and I have used it without problems, python, I have seen in videos and I have read that it can be implemented in both contexts, but I cannot do it myself

Here is an image where I use it in python and then in another cell I use it in sql, and the error message appears

Function applied

Error message PythonException: 'AttributeError: 'NoneType' object has no attribute '_tools''

but if the geocode function works, it is because it is registered, I installed arcgis, and then I did this

%python
import unicodedata
from pathlib import Path
import pyspark.sql.functions as function
from pyspark.sql.types import *
import pandas as pd
import numpy as np
import re

import utm

import arcgis
from arcgis.geocoding import reverse_geocode
from arcgis.gis import GIS
from arcgis.geocoding import geocode
from arcgis.gis import GIS

Answer 1