topic Re: Export Attribute Table to .csv in Python Questions

Export Attribute Table to .csv

mpboyle — Fri, 23 Oct 2015 14:43:31 GMT

I'm looking to export an attribute table to a .csv file using the csv module within python. I'm wondering what is the best way to do this with multiple fields...? Do you use a search cursor to iterate over the rows? How can you include field names...?

I realize I could use the Table to Excel function or the Table to ASCII, but I believe for large datasets this would be faster and create a smaller output.

Re: Export Attribute Table to .csv

BruceHarold — Fri, 23 Oct 2015 14:54:28 GMT

There are a couple of tools available in the gallery:

http://www.arcgis.com/home/search.html?q=CSV&t=content&focus=tools

Regards

Re: Export Attribute Table to .csv

mpboyle — Sat, 11 Dec 2021 12:34:43 GMT

Bruce Harold,

Those tools are definitely nice to know about!

As I'm far from a python expert, below is what I have and seems to work...without any domain translating...

import arcpy
import csv

fc = r'...path to input fc...'
fields = ['field1', 'field2', 'field3']
outCsv = r'...path to output csv...'

with open(outCsv, 'wb') as ouputCsv:
    writer = csv.writer(outputCsv)
    writer.writerow(fields)  # writes header containing list of fields
    rows = arcpy.da.SearchCursor(fc, field_names=fields)
    for row in rows:
        writer.writerow(row)  # writes fc contents to output csv
    del rows

Re: Export Attribute Table to .csv

JamesCrandall — Sat, 11 Dec 2021 12:34:46 GMT

I typically use pandas DataFrame.to_csv for this operation as I mostly work with that library. But NumPy also has similar method that you could just convert your feature class or table to a NumPy array and save it out from there.

import numpy
import arcpy

lyr = r'H:\Documents\ArcGIS\Default.gdb\MyFeatureClass'
nparr = arcpy.da.FeatureClassToNumPyArray(lyr, ['OBJECTID','STNAME','CNTYFIPS','Shape_Area'])
numpy.savetxt('H:\MyFeatureClass.csv', nparr, delimiter=",", fmt="%s")

Re: Export Attribute Table to .csv

BlakeTerhune — Sat, 11 Dec 2021 12:34:48 GMT

Here's what I use for exporting to CSV.

import arcpy
import csv
import os

# Environment variables
workingDir = r"C:\temp"
workingGDB = os.path.join(workingDir, "MyGeodatabase.gdb")
inputTable = os.path.join(workingGDB, "MyInputTable")
outputCSV = os.path.join(workingDir, "MyOutput.csv")

# Create CSV
with open(outputCSV, "w") as csvfile:
    csvwriter = csv.writer(csvfile, delimiter=',', lineterminator='\n')
    ## Write field name header line
    fields = ['FirstField','NextField','AndThirdExample']
    csvwriter.writerow(fields)
    ## Write data rows
    with arcpy.da.SearchCursor(inputTable, fields) as s_cursor:
        for row in s_cursor:
            csvwriter.writerow(row)