topic Re: Convert multiple feature classes to dataframes using GeoAccessor in ArcGIS API for Python Questions

Convert multiple feature classes to dataframes using GeoAccessor

PenelopeMitchell — Wed, 07 Sep 2022 20:45:29 GMT

I wrote a function that should read in multiple feature classes and return pandas dataframes. Here is the code:

import pandas as pd from arcgis.features import GeoAccessor, GeoSeriesAccessor CHList=arcpy.ListFeatureClasses('*CH') # list feature classes from ArcGIS Pro and assign to variable def DF_from_Ftr(in_features): for feature in in_features: sdf = pd.DataFrame.spatial.from_featureclass(feature) #use geoaccessor to convert ftr to df sdf.drop(['SHAPE'], axis=1, inplace=True) return sdf

When I run the function as follows:

DF_from_Ftr(CHList)

One dataframe is shown in the print screen.

When i try to access the other dataframes (there should be 30 of them) using indexing (shown in code below), I get a key error for whatever index number I use indicating that dataframe object isn't there.

DF_from_Ftr(CHList)[1]

What might I be doing wrong here?

Thank you!

Re: Convert multiple feature classes to dataframes using GeoAccessor

jcarlson — Wed, 07 Sep 2022 21:13:46 GMT

If CHList is a list, then you need to index it inside your function:

DF_from_Ftr(CHList[1])

Re: Convert multiple feature classes to dataframes using GeoAccessor

PenelopeMitchell — Wed, 07 Sep 2022 21:52:34 GMT

Thanks for your response-- reading that I would think that would perform the function on the second item in CHList--but the output is an OSError: "C" does not exist.

Re: Convert multiple feature classes to dataframes using GeoAccessor

Clubdebambos — Thu, 08 Sep 2022 08:08:25 GMT

Hi @PenelopeMitchell

Your function is returning one sdf. The last one from the input. Create an empty list in the function and append in each sdf, then return the list, as below.

def DF_from_Ftr(in_features): sdf_list = [] for feature in in_features: sdf = pd.DataFrame.spatial.from_featureclass(feature) #use geoaccessor to convert ftr to df sdf.drop(['SHAPE'], axis=1, inplace=True) sdf_list.append(sdf) return sdf_list

Call your function

sdf_list = DF_from_Ftr(CHList)

Then access the elements of the list with indexing

sdf_1 = sdf_list[0] sdf_2 = sdf_list[1] sdf_3 = sdf_list[2] ## and so on

Re: Convert multiple feature classes to dataframes using GeoAccessor

PenelopeMitchell — Thu, 08 Sep 2022 17:56:51 GMT

Ah, yes! Many thanks!