topic Re: Writing Results to Existing Specific CSV Column in Python Questions

Writing Results to Existing Specific CSV Column

AdamThompson3 — Thu, 01 Nov 2018 21:05:57 GMT

Hey Everyone,

Running into a bit of a problem that I am not sure how to resolve after researching for awhile, What I would like to do is write my results from a search cursor to an existing column in a csv file.

So currently this is the code I have;

The first portion of my code works exactly how I want it too, and prints how I would like it to be displayed in the csv file. Now what I would like to do is take those values and write them to an existing Field in my CSV called "Play", I am not sure how to go about this. This is what I have gotten so far for my results..

The highlighted portion is what I want to write to the specific column "Play" in my csv, I can read the file and find out the column position is row[0] but cant write to it.

Any help is appreciated!

Re: Writing Results to Existing Specific CSV Column

DarrenWiens2 — Thu, 01 Nov 2018 21:16:37 GMT

You need a writer to write. Check the example here: 13.1. csv — CSV File Reading and Writing — Python 2.7.15 documentation

Re: Writing Results to Existing Specific CSV Column

AdamThompson3 — Fri, 02 Nov 2018 16:27:04 GMT

I took a read through it all, was quite a lot of information to take in but I ended up getting it to work with just one hiccup,

My data that is put into that column contains a space between each one, as seen below;

not sure why.. but other then that it works!

Here is the code

Re: Writing Results to Existing Specific CSV Column

DarrenWiens2 — Fri, 02 Nov 2018 16:39:45 GMT

Weird, do you see anything funny (newline character) if you open it in a simple text editor?

Re: Writing Results to Existing Specific CSV Column

AdamThompson3 — Fri, 02 Nov 2018 16:45:54 GMT

No when I open it with just notepad it looks correct,

Although NotePad ++ gives me the same as the excel as well

very weird indeed! Anyways thank you for the link to the CSV Writer info though, that was very helpful.

Re: Writing Results to Existing Specific CSV Column

DarrenWiens2 — Fri, 02 Nov 2018 17:40:09 GMT

Oh, try using 'wb' mode rather than 'w' with Python 2 on Windows.

Re: Writing Results to Existing Specific CSV Column

AdamThompson3 — Fri, 02 Nov 2018 17:43:48 GMT

Yup that did it!