How do I modify my syntax to properly read an csv file and write the contents to a shapefile using an update cursor ? # Read csv file & write to shapefile via update cursor import csv , os updateCursor = arcpy . da . UpdateCursor ( r 'sample.shp' , [ "Name" , "OrderCount" , "Time" , "Miles" ] ) with open ( r 'CsvToShape.csv' , 'rb' ) as f : reader = csv . reader ( f ) for row in reader : route = row [ 0 ] order = row [ 1 ] time = row [ 2 ] mile = row [ 3 ] for row in updateCursor : row . setValue ( route = Name ) ## row[1]= order ## row[2] = time ## row[3] = mile updateCursor . updateRow ( row )

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

csv.reader to updateCursor

DevinUnderwood2

How do I modify my syntax to properly read an csv file and write the contents to a shapefile using an update cursor ?

<SPAN class="comment token"># Read csv file & write to shapefile via update cursor</SPAN>
<SPAN class="keyword token">import</SPAN> csv<SPAN class="punctuation token">,</SPAN>os

updateCursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'sample.shp'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Name"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"OrderCount"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Time"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Miles"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">with</SPAN> open<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'CsvToShape.csv'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'rb'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> f<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; reader <SPAN class="operator token">=</SPAN> csv<SPAN class="punctuation token">.</SPAN>reader<SPAN class="punctuation token">(</SPAN>f<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> reader<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; route <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; order <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; time <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mile <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> updateCursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN>route <SPAN class="operator token">=</SPAN> Name<SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">##&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row[1]= order</SPAN>
<SPAN class="comment token">##&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row[2] = time</SPAN>
<SPAN class="comment token">##&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row[3] = mile</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; updateCursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Trouver plus de publications taguées avec

Accepted answers

All comments

VinceAngelo

This is a different question, but no, there isn't a function to make arbitrary text into integer.

It is, however, simple to use a dictionary to assign an numeric lookup value for text values if you create a dictionary that performs the encoding for you:

lookup1 <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN> <SPAN class="string token">'Yes'</SPAN>  <SPAN class="punctuation token">:</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'No'</SPAN>    <SPAN class="punctuation token">:</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'DEFAULT'</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN> <SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">for</SPAN> txt <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Yes'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'No'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'YES'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'NO'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Maybe'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
    alt <SPAN class="operator token">=</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN>
    <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>txt <SPAN class="keyword token">in</SPAN> lookup1<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        alt <SPAN class="operator token">=</SPAN> lookup1<SPAN class="punctuation token">[</SPAN>txt<SPAN class="punctuation token">]</SPAN>
    <SPAN class="comment token">#else:</SPAN>
    <SPAN class="comment token">#    alt = lookup['DEFAULT']</SPAN>
    <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{:>10s} : {:d}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>txt<SPAN class="punctuation token">,</SPAN>alt<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

JumaKhudonazarov1

I am trying to find solution to CSV file that automatically become numeric . When i finish my survey I export it to CSV file and I am using RAnalitic software where i need to convert text to number as mentioned yes or no text should be 1 or 2 and so on. Is there any function i can use to do this?

VinceAngelo

You're using 'row' twice, for different objects. This cannot result in success.

You're also attempting to use setValue on an array, which is wrong (DA cursors are very different creatures the the old , deprecated cursors)

The canonical approach to this problem is to read the CVS once, into a dictionary by key column, then to loop the update cursor once, consulting the dictionary. Double-nested looping with cursors is exceeding slow, and should be avoided.

- V

JumaKhudonazarov

Hi if I use the can I export CSV file with numeric rather than text? For example instead Yes, or NO. 1 or 2????

<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit; font-size: 14px;"># Read csv file & write to shapefile via update cursor</SPAN>
<SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit; font-size: 14px;">import</SPAN> csv<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">,</SPAN>os

updateCursor <SPAN class="" style="color: #a67f59; background-color: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit; font-size: 14px;">=</SPAN> arcpy<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">.</SPAN>da<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">.</SPAN>UpdateCursor<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">(</SPAN>r<SPAN class="" style="color: #669900; border: 0px; font-weight: inherit; font-size: 14px;">'sample.shp'</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">,</SPAN> <SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">[</SPAN><SPAN class="" style="color: #669900; border: 0px; font-weight: inherit; font-size: 14px;">"Name"</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">,</SPAN> <SPAN class="" style="color: #669900; border: 0px; font-weight: inherit; font-size: 14px;">"OrderCount"</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">,</SPAN><SPAN class="" style="color: #669900; border: 0px; font-weight: inherit; font-size: 14px;">"Time"</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">,</SPAN><SPAN class="" style="color: #669900; border: 0px; font-weight: inherit; font-size: 14px;">"Miles"</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">]</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">)</SPAN>

<SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit; font-size: 14px;">with</SPAN> open<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">(</SPAN>r<SPAN class="" style="color: #669900; border: 0px; font-weight: inherit; font-size: 14px;">'CsvToShape.csv'</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">,</SPAN><SPAN class="" style="color: #669900; border: 0px; font-weight: inherit; font-size: 14px;">'rb'</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">)</SPAN> <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit; font-size: 14px;">as</SPAN> f<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">:</SPAN>
&nbsp;&nbsp;&nbsp; reader <SPAN class="" style="color: #a67f59; background-color: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit; font-size: 14px;">=</SPAN> csv<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">.</SPAN>reader<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">(</SPAN>f<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit; font-size: 14px;">for</SPAN> row <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit; font-size: 14px;">in</SPAN> reader<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; route <SPAN class="" style="color: #a67f59; background-color: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit; font-size: 14px;">=</SPAN> row<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">[</SPAN><SPAN class="" style="color: #990000; border: 0px; font-weight: inherit; font-size: 14px;">0</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; order <SPAN class="" style="color: #a67f59; background-color: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit; font-size: 14px;">=</SPAN> row<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">[</SPAN><SPAN class="" style="color: #990000; border: 0px; font-weight: inherit; font-size: 14px;">1</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; time <SPAN class="" style="color: #a67f59; background-color: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit; font-size: 14px;">=</SPAN> row<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">[</SPAN><SPAN class="" style="color: #990000; border: 0px; font-weight: inherit; font-size: 14px;">2</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mile <SPAN class="" style="color: #a67f59; background-color: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit; font-size: 14px;">=</SPAN> row<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">[</SPAN><SPAN class="" style="color: #990000; border: 0px; font-weight: inherit; font-size: 14px;">3</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit; font-size: 14px;">for</SPAN> row <SPAN class="" style="color: #0077aa; border: 0px; font-weight: inherit; font-size: 14px;">in</SPAN> updateCursor<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">.</SPAN>setValue<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">(</SPAN>route <SPAN class="" style="color: #a67f59; background-color: rgba(255, 255, 255, 0.498039); border: 0px; font-weight: inherit; font-size: 14px;">=</SPAN> Name<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">)</SPAN>
<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit; font-size: 14px;">##&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row[1]= order</SPAN>
<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit; font-size: 14px;">##&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row[2] = time</SPAN>
<SPAN class="" style="color: slategray; border: 0px; font-weight: inherit; font-size: 14px;">##&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row[3] = mile</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; updateCursor<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">.</SPAN>updateRow<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit; font-size: 14px;">(</SPAN>row

JumaKhudonazarov

Can you please advice can't sorted this out?

JumaKhudonazarov1

Yes exactly the column values are text should i change it?

JoshuaBixby

I suggest starting a new question and providing a bit more information in that new question. For example, what does your data structure look like? I assume the Yes/No column values are currently stored as Text?

JumaKhudonazarov

Hi Joshua if I plan to export CSV file and want to see numeric value rather than text how to do that. In other words instead of Yes or Now I want to see 1 or 2?

DevinUnderwood2

I believe you are referring to my following example of a dictionary to a list.

In my case, I would read the csv file as a dictionary not hardcoded in the script.

my_dict = {'A1':405,'A2':145}

print str(list_items) + " " + " These are the keys and values"
print str(list_keys) + " " + " These are the keys"
print str(list_values) + " " + " These are values"

[('A1', 405), ('A2', 145)] These are the keys and values
['A1', 'A2'] These are the keys
[405, 145] These are values

DevinUnderwood2

the polygon feature is not empty, I want to add table info from the csv file.

DevinUnderwood2

It is a polygon.

DevinUnderwood2

Thank you for the advice, I will work this out with your suggestions.

VinceAngelo

The row object returned by iteration of reader is NOT an array. You must unpack the dictionary into an array in the order required by the field list.

Your current logic assumes that the order of the file and the feature class as processed in the cursor are identical. In most cases, this will end badly.

- V

JoshuaBixby

Can you elaborate on "still have the issue of passing the values to the cursor?" Are you getting an error message? If so, what? Are you getting unexpected results? If so, what?

RichardFairhurst

To do a full update there are 3 separate processes. Update records, which occurs as you iterate through the updateCursor records and find a key match in the csv dictionary. Delete records (optional), which occurs as you iterate through the updateCursor records and do not find a key match in the csv dictionary. Update and Delete can be done as you do a single pass on all of the updateCursor records. Finally, Insert records, which I usually approach by first creating a dictionary of the updateCursor records after every record has been updated and deleted. Then I iterate through the csv file or csv dictionary records and if it is not in the updateCursor record dictionary, I insert that records using an InsertCursor into the FC being updated.

If the FC you are updating is empty and all you are doing is adding records, you need to use an insertCursor, not an updateCursor.

DanPatterson_Retired

If this is a point file, it is far easier to read the csv file into a numpy array, then use arcpy.NumPyArrayToFeatureClass

Many ways to do this, but a dictionary describing the field names and the data type will do it

dt <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">'names'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Longitude'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Latitude'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'formats'</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'f8'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'f8'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'i4'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'f8'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'U4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN>

<SPAN class="comment token"># ---- the csv name, the datatype as described above, skip the header row, delimiter is ','</SPAN>
np<SPAN class="punctuation token">.</SPAN>loadtxt<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'c:/temp/test.csv'</SPAN><SPAN class="punctuation token">,</SPAN> dtype<SPAN class="operator token">=</SPAN>dt<SPAN class="punctuation token">,</SPAN> skiprows<SPAN class="operator token">=</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> delimiter<SPAN class="operator token">=</SPAN><SPAN class="string token">','</SPAN><SPAN class="punctuation token">)</SPAN>

array<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">75.5</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">45.5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">1</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' aaa'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">75</SPAN><SPAN class="punctuation token">.</SPAN> <SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">45</SPAN><SPAN class="punctuation token">.</SPAN> <SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="number token">2</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' bbb'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dtype<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Longitude'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<f8'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Latitude'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<f8'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'A'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<i4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'B'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<f8'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'C'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'<U4'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="string token">"""
original file

Longitude, Latitude, A, B, C
-75.5, 45.5, 1, 1.0, aaaa
-75.0, 45.0, 2, 2.0, bbbb

"""</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DevinUnderwood2

Creating a dictionary form the csv is straight forward but I still have the issue of passing the values to the cursor.

<SPAN class="keyword token">import</SPAN> csv<SPAN class="punctuation token">,</SPAN>os

updateCursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'sample.shp'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Name"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"OrderCount"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Time"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Miles"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="keyword token">with</SPAN> open<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'test.csv'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> csvfile<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp; reader <SPAN class="operator token">=</SPAN> csv<SPAN class="punctuation token">.</SPAN>DictReader<SPAN class="punctuation token">(</SPAN>csvfile<SPAN class="punctuation token">,</SPAN> delimiter <SPAN class="operator token">=</SPAN> <SPAN class="string token">","</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> reader<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; updateCursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

VinceAngelo

You've got a variable name collision on 'row'. The DA cursor row object is just an array/list.

You should probably choose between caching the contents of the CSV in a dictionary and stepping through the UpdateCursor linearly, and using a new cursor with an index-covered WHERE clause for each CSV row. This decision will dictate the structure of your code.

- V

DevinUnderwood2

Thanks for the advice.

I did not realize cursors as gone thru the following iterations:

arcpy.UpdateCursor

arcpy.da.UpdateCursor

UpdateCursor

I actually want to read a separate excel csv file and write the data (UpdateCursor) to same named shapefile fields.

JoshuaBixby

You are using the older style cursor, you should look into using What is the data access module?—Help | ArcGIS Desktop .

More importantly, if you want to convert a CSV into a shapefile it is best to have some spatial data. Where is yours or how is it stored in the CSV?

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.