Add support for Pandas Dataframes to arcpy

Idea created by martinschaefer on Feb 14, 2018
    Reviewed
    Score60
    • Hornbydd
    • Holisticbynature
    • 907454_rhdhvesri
    • recurvata
    • tlaxson
    • oshyouk

    Pandas are a great asset for any data scientist. Data manipulation using pandas dataframes is powerful and easy. At the moment they only way to read feature class data into pandas for manipulation is using structured numpy arrays using arcpy.da.FeatureClassToNumPyArray, and then convert that to a dataframe. That is quite straightforward, but the reverse is more difficult due to the data types dataframes use. Strings are usually stored as objects, which arcpy.da.NumPyArrayToFeatureClass doesn't support. So each column's dtype has to be checked and converted if necessary.

     

    It'd be great to have a arcpy.da.FeatureClassToDataFrame and arcpy.da.DataFrameToFeatureClass.