topic Re: Reformating data in a feature class/table in Python Questions

Reformating data in a feature class/table

benberman — Wed, 16 Dec 2015 18:03:20 GMT

I received a feature class that is currently in the format, illustrated below..

AREA	POPUNDER20	POPOVER20	POPOVER50
TAMPA	1000
TAMPA		2000
MIAMI	500
MIAMI		1000
MIAMI			3000
MONTREAL	4000
MONTREAL		5000

I would be needing to re-format this feature class to:

AREA	POPUNDER20	POPOVER20	POPOVER50
TAMPA	1000	2000
MIAMI	500	1000	3000
MONTREAL	4000	5000

If anyone could recommened a script or a tool that would help reformat, that would be really helpful

thanks in advance.

Re: Reformating data in a feature class/table

WesMiller — Wed, 16 Dec 2015 18:46:31 GMT

You could use Summarizing data in a table—Help | ArcGIS for Desktop

Re: Reformating data in a feature class/table

DarrenWiens2 — Wed, 16 Dec 2015 18:46:50 GMT

Summary Statistics, using AREA as case field and the other fields as statistics fields should do the trick.

Re: Reformating data in a feature class/table

benberman — Wed, 16 Dec 2015 19:38:38 GMT

Does not work. What statistic type would you assign to the other fields, anyway?

Re: Reformating data in a feature class/table

DarrenWiens2 — Wed, 16 Dec 2015 19:51:47 GMT

Hmmm... it works for me. Use MAX as the statistic type for each of the pop fields and AREA (the city names) for the case field. MAX should work regardless of whether it's a text or numerical field.

If that doesn't work, how does it not work? Error, blank output, wrong output?

1.)

2.)

3.)

Re: Reformating data in a feature class/table

benberman — Thu, 17 Dec 2015 00:57:27 GMT

Darren, changing the type to MAX does work. Thank you so much.