Panda sdf.spatial.to_featureclass fails to write Featureclass but writes shapefile

BillChappell

Below is the abbreviated copy of my code. I take an Excel file, read into a panda dataframe, convert that to a spatial dataframe and write it out as a point featureclass. If I write a shapefile it works but when I write to a File GDB it writes nothing and doesn't even show an error.

My Code:

import pandas as pd
from arcgis.features import GeoAccessor, GeoSeriesAccessor

df = pd.read_excel (filename)

# convert Pandas dataframe to Spatial Data Frame
sdf= pd.DataFrame.spatial.from_xy(df=df,
x_column='Structure_Lng',
y_column='Structure Lat',
sr=4326)

# show first 5 records in SDF
print(sdf.head()) # looks good

#Convert SDF to Featureclass. ### This fails
sdf.spatial.to_featureclass(location="C:/temp/test.fdb/myPts", overwrite=True);

# this works
sdf.spatial.to_featureclass(location="C:/temp/myPts.shp", overwrite=True)

BillChappell

Got it. While I was running my script thru Python 3.6.8 IDLE, I had never logged into Pro on this laptop. Once I logged in, it threw an error and I found some Lat/Lngs were actually null throwing a bad geometry error. By making a shapefile these were just ignored, to a featureclass these were an issue. So .fillna(0) fixed that.

My working script is attached as a text file.

Thanks for the help. 

importExcel.txt.zip