Hi all, I am working to automate a routine workflow I do in ArcGIS Pro, specifically reading in a csv, geocoding, filling in some additional fields, and appending to hosted feature service in AGOL.
I am having trouble with the very first step - reading in a local csv using pandas and I think it's a file path problem. I have tried in both ArcGIS Pro and Online Notebooks thinking Pro would handle the file path better. I tried os.cwd() in AGOL and it says /arcgis, so I can't tell if it's a directory problem.
I know sometimes Python has trouble reading certain slashes or file path format, but I have tried the following combinations and they are all saying No such file or directory
df = pd.read_csv(r"C:\Users\Documents\GeocodeFile.csv")
df = pd.read_csv("C:\\Users\\Documents\\GeocodeFile.csv")
csv_file = 'C:/Users/Documents/GeocodeFile.csv' (this one just keeps the string, trying to import any data still doesn't work).
I am trying to avoid having to upload the csv as an item to AGOL and access it that way because I want to have this process be as automated as possible. There must be an easier way to do this! Am I missing anything?