Copy/duplicate rows with arcpy

IlkaIllers1 — Mon, 20 Nov 2023 15:32:05 GMT

I have a table (no spatial data) of cadastral data indicating monuments, where several plots have been combined into one single row. I want to disentangle them to join them with the base cadastral set. I would rather not do this manually. I have been trying to figure out a way to make duplicate rows with arcpy based on the number of "," in one field. This is how far I got:

with arcpy.da.UpdateCursor('input_fc','plots') as uCur: for row in uCur: list = [] if ',' in row[0]: number = row[0].count(',') r = range(1,number,1) for i in r:

and that is where I got stuck trying to figure out how to tell it to duplicate the row as many times as there is a comma. Does anything like that exist?

Re: Copy/duplicate rows with arcpy

AlfredBaldenweck — Tue, 21 Nov 2023 01:28:21 GMT

You want an Insert Cursor, not an update cursor. Update is for editing rows that are already in the table, insert is for adding new ones.

I wrote this without testing, but the basic workflow is:

Read the table and load the row (a tuple with only 1 value) into a list of tuples.
With the insert cursor, count the number of commas in the first value of each row in the list.
If the number is greater than 1, insert the row X many times.
1. I really am not sure of the math here, so you'll have to play around a bit to make sure it's right.

Also, am not sure if you're putting the rows into the same feature class or a new one, but either way you want an insert cursor.

rowList = [] with arcpy.da.SearchCursor(input_fc, 'plots') as sCur: for row in sCur: rowList.append(row) with arcpy.da.InsertCursor('input_fc','plots') as iCur: for row in rowList: number = row[0].count(',') if number > 1: for i in range(1, number): iCur.insertRow(row)

I also recommend asking python question in the Python Questions board for faster responses.

topic Re: Copy/duplicate rows with arcpy in ArcGIS Pro Questions

Copy/duplicate rows with arcpy

Re: Copy/duplicate rows with arcpy