GeoAccessor.from_table results in empty array

[georaleigh]

GeoAccessor.from_table results in empty array

[nanaeaubry]

@georaleigh

Following our guides here I can read in your table data:
https://developers.arcgis.com/python/guide/part2-data-io-reading-data/#read-in-non-spatial-table-data

[georaleigh]

@nanaeaubry thanks for giving this a shot in your environment. I wonder if it's an issue with my version of Pro or Python. Can you share the code you used to test reading in my csv so that I can try it?

Also, I did find a work around for now by using XLS instead. Here's the code I'm using:

trendstable.to_excel(outputXLSFile)
trendstable = arcpy.ExcelToTable_conversion(outputXLSFile, outputTable, 'Sheet1')
trendstable = arcpy.management.Append(inputs=[outputTable], target=CrimeTrendsTableLyr.url)[0]

I'm not sure if the issue I'm having with the CSV is the delimiter, separator, header or something else in how CSVs are created and read back in. During my research I found some weird behavior with the CSV. For example, when I open it in Excel all the data would appear fine. Same for if I viewed it using the print command in Python. However, when trying to read it in using an arcpy command or open it as a table in ArcGIS Pro some columns have null data. Using XLS instead worked great so I'm glad to have a solution but would like to understand the cause better at some point and why I can't get this to work using a CSV.

[nanaeaubry]

@georaleigh
Sure so I also have arcpy in my environment and here is the code I used:

from arcgis.gis import GIS
import pandas as pd
gis = GIS(profile = "your_online_profile")
tbl_df = pd.DataFrame.spatial.from_table(filename=r'C:\workspace\trendstable_test.csv')
tbl_df.head(2)

I have python 3.9 and using our latest api version

You can check the version of the python api by doing:

import arcgis
print(arcgis.__version__)

Maybe this is an issue in python api version 2.2.0.2? I will try to test with older versions and see what happens.