Writing to a particular cell using csv module in python

by

The csv module provides facilities to read and write csv files but does not allow the modification specific cells in-place.

Even the csvwriter.writerow(row) method you highlight in your question does not allow you to identify and overwrite a specific row. Rather it writes the row parameter to the writer’s file object, in effect it simply appends a row the csv file associated with the writer.

Do not be dissuaded from using the csv module though, it is simple to use and with the primitives provided you could implement the higher level functionality you are looking for relatively easily.

For example take a look at the following csv file:

1,2,3,four,5
1,2,3,four,5
1,2,3,four,5

The word four is in column 3 (the fourth column but a row is just a list so the indexing is zero based), this can be easily updated to contain the digit 4 with the following program:

import csv
in_file = open("d:/in.csv", "rb")
reader = csv.reader(in_file)
out_file = open("d:/out.csv", "wb")
writer = csv.writer(out_file)
for row in reader:
    row[3] = 4
    writer.writerow(row)
in_file.close()    
out_file.close()

Resulting in the output:

1,2,3,4,5
1,2,3,4,5
1,2,3,4,5

Granted creating some generic function that allows specific rows and columns to be identified and updated is a little more work, but not much more as manipulating a csv file in Python is just manipulating a sequence of lists.

More Related Contents:

  1. How do I create a python code that distinguishes between the capital of a state and the state that the capital has?
  2. How do I read a large csv file with pandas?
  3. How to add pandas data to an existing csv file?
  4. How to ignore the first line of data when processing CSV data?
  5. Create a .csv file with values from a Python list
  6. Change specific value in CSV file via Python
  7. TypeError: a bytes-like object is required, not ‘str’ in python and CSV
  8. _csv.Error: field larger than field limit (131072)
  9. Pandas split column into multiple columns by comma
  10. Remove file after Flask serves it
  11. General Unicode/UTF-8 support for csv files in Python 2.6
  12. Convert commas decimal separators to dots within a Dataframe
  13. Read data from CSV file and transform from string to correct data-type, including a list-of-integer column
  14. Inline CSV File Editing with Python
  15. ‘utf-8’ codec can’t decode byte 0xa0 in position 4276: invalid start byte
  16. What does ‘killed’ mean when processing a huge CSV with Python, which suddenly stops?
  17. Convert HTML into CSV
  18. How to *actually* read CSV data in TensorFlow?
  19. Deleting rows with Python in a CSV file
  20. Simple CSV to XML Conversion – Python
  21. csv.writer writing each character of word in separate column/cell
  22. Pandas ParserError EOF character when reading multiple csv files to HDF5
  23. Python Pandas – Read csv file containing multiple tables
  24. Is there a way to speed up handling large CSVs and dataframes in python?
  25. Read random lines from huge CSV file
  26. Load CSV to Pandas MultiIndex DataFrame
  27. How to count top 10 most common values in a dict in python
  28. Why is the Python CSV reader ignoring double-quoted fields?
  29. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path
  30. How Postgresql COPY TO STDIN With CSV do on conflic do update?

Leave a Comment