exporting dataframe to feature class missing field in attribute table

125
0
12-13-2021 07:14 AM
AroldoRocha
New Contributor

Hi!

I'm using Python on a notebook on ArcGis Pro 2.9.0 to create a featureclas by Pandas dataframe.
The procedure is executed without error, however when looking in the attributes table the "price" field (flot64) is ignored and does not appear in the attributes table.
Any tips about it?

This is part of code I'm using:

# Cria um datafram com o preço sumarizado pelo prefixo do zipcode (3 dígitos)
gp = df.groupby('customer_zip_code_prefix_3_digits')['price'].sum().to_frame()

gp['price'] = gp['price'] / 1000

# Criando receita --> localização + gp
receita = localizacao.merge(gp, left_on='geolocation_zip_code_prefix_3_digits', right_on='customer_zip_code_prefix_3_digits', how='left')

# Cria geodataframe
receita_geo = receita.spatial.from_xy(localizacao, x_column="geolocation_lng", y_column="geolocation_lat", sr=4326)

# Cria a FeatureClass na GDB
receita_geo = receita_geo.spatial.to_featureclass(location=r"D:/DADOS/Python/trabalhos/E_comerce/CEP_Ecomerce_GIS/CEP_Ecomerce_GIS.gdb/receita_geo", overwrite=True)  

 1.JPG2.JPG

3.JPG

Thanks!

0 Kudos
0 Replies