topic Re: Trying to create a feature layer from a pandas dataframe in ArcGIS Notebooks Questions

Trying to create a feature layer from a pandas dataframe

AsafEvenPaz — Fri, 30 Oct 2020 20:47:05 GMT

Hi I am trying to follow the documentation to convert a dataframe into a feature collection.

Here is the code I am using:

groups_stats_fc=gis.content.import_data(df)

import json
groups_stats_fc_dict = dict(groups_stats_fc.properties)
groups_stats_fc_json = json.dumps({"featureCollection": {"layers": [groups_stats_fc_dict]}})
groups_stats_fc_json

groups_stats_item_properties = {'title': 'AGOL Group Statistics',
'description':'AGOL Group Statistics' ,
'tags': 'arcgis ,python, api, pandas, csv',
'text':groups_stats_fc_json,
'type':'Feature Collection'}
group_stats_item = gis.content.add(groups_stats_item_properties)
group_stats_item

The item is created but when I try to access it nothing shows up...

Any ideas?

Re: Trying to create a feature layer from a pandas dataframe

Anonymous User — Fri, 30 Oct 2020 23:24:16 GMT

Hi again Asaf!

I suspect there's an issue with the dataframe being passed in. Have you verified that the dataframe is valid and being imported correctly? When you call groups_stats_fc does it return <FeatureCollection>? You should also verify that groups_stats_fc_dict is valid.

Here's some more info on the import_data method: arcgis.gis module — arcgis 1.8.2 documentation

Re: Trying to create a feature layer from a pandas dataframe

AsafEvenPaz — Wed, 04 Nov 2020 16:02:31 GMT

Joshua,

The dataframe seems to be valid.

When I call the groups_stats_fc it returns <FeatureCollection> and the groups_stats_fc_dict seems to be valid as well:

Any other ideas?

Re: Trying to create a feature layer from a pandas dataframe

DanCostello — Tue, 20 Apr 2021 18:48:22 GMT

In the last line, call:

group_stats_item.publish()

This should make it vieweable on maps in ArcGIS Online.