Insert related records

[JohnConnor01]

Hello,

Would someone be able to give me any insight how I go about importing a csv of inspection records for feature class using Python and Arcpy? I think I can get to the point of inserting the records, but I don't understand how I can match an inspection record with the related parent table? 

Thank you.

-JC from Boston

[Anonymous User]

You can do this several ways. Easiest may be using the Join field method documented here  

You will need to convert the csv to a database table format method documented here. 

You will need to find the shared field (primary key in the shapefile/ foreign key in the csv) that you can use to join the two datasets together.

If you can't convert the csv to a database table, you can use cursors or pandas to do the join and then export the joined shapefile. Depending on which way you want to go, (providing sample data could help) we can probably provide some code for it.

[JohnConnor01]

Thank you JeffK! I will run with this for now and see where it takes me. Ill post back if needed! Thanks again.

-JC from Boston