csv.writer writing each character of word in separate column/cell

by

.writerow() requires a sequence ('', (), []) and places each index in it’s own column of the row, sequentially. If your desired string is not an item in a sequence, writerow() will iterate over each letter in your string and each will be written to your CSV in a separate cell.

after you import csv

If this is your list:

myList = ['Diamond', 'Sierra', 'Crystal', 'Bridget', 'Chastity', 'Jasmyn', 'Misty', 'Angel', 'Dakota', 'Asia', 'Desiree', 'Monique', 'Tatiana']


listFile = open('Names.csv', 'wb')
writer = csv.writer(listFile)
for item in myList:
    writer.writerow(item)

The above script will produce the following CSV:
Names.csv

D,i,a,m,o,n,d
S,i,e,r,r,a
C,r,y,s,t,a,l
B,r,i,d,g,e,t
C,h,a,s,t,i,t,y
J,a,s,m,y,n
M,i,s,t,y
A,n,g,e,l
D,a,k,o,t,a
A,s,i,a
D,e,s,i,r,e,e
M,o,n,i,q,u,e
T,a,t,i,a,n,a

If you want each name in it’s own cell, the solution is to simply place your string (item) in a sequence. Here I use square brackets []. :

listFile2 = open('Names2.csv', 'wb')
writer2 = csv.writer(listFile2)
for item in myList:
    writer2.writerow([item])

The script with .writerow([item]) produces the desired results:
Names2.csv

Diamond
Sierra
Crystal
Bridget
Chastity
Jasmyn
Misty
Angel
Dakota
Asia
Desiree
Monique
Tatiana

More Related Contents:

  1. A simple maths operation on a CSV column using python [closed]
  2. How to write a python code which copies a unique column from an output file to a .csv file
  3. How can I convert JSON to CSV?
  4. Using python Requests with javascript pages
  5. How to avoid Python/Pandas creating an index in a saved csv?
  6. Scraping dynamic content using python-Scrapy
  7. datetime dtypes in pandas read_csv
  8. How can I download a file on a click event using selenium?
  9. How do I convert this list of dictionaries to a csv file?
  10. csv.Error: iterator should return strings, not bytes
  11. How to save an image locally using Python whose URL address I already know?
  12. Compare two CSV files and search for similar items
  13. “SSL: certificate_verify_failed” error when scraping https://www.thenewboston.com/
  14. Pandas read csv file with float values results in weird rounding and decimal digits
  15. Key error when selecting columns in pandas dataframe after read_csv
  16. Precision lost while using read_csv in pandas
  17. Python Pandas: How to read only first n rows of CSV files in?
  18. Prevent pandas read_csv treating first row as header of column names
  19. How to get the scrapy failure URLs?
  20. read and write on same csv file
  21. How to avoid pandas creating an index in a saved csv
  22. Pandas – write Multiindex rows with to_csv
  23. How to add header row to a pandas DataFrame
  24. UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0x8b in position 1: invalid start byte, while reading csv file in pandas
  25. csv: writer.writerows() splitting my string inputs
  26. Clicking link using beautifulsoup in python
  27. Beautiful Soup and Table Scraping – lxml vs html parser
  28. How to convert csv to json in python?
  29. Download all pdf files from a website using Python
  30. How to handle IncompleteRead: in python

Leave a Comment