How to Include a comma ',' as a part of a tuple entry in Python

Asked May 28 '18 at 08:39

Active May 28 '18 at 08:44

Viewed 58 times

I am trying to create a tuple and export the tuple as entries in a CSV file. The inputs to the tuple include book titles (some of which include commas in the title), book price and availability. These commas in the title create separate entries in the CSV file, creating 4 entries instead of the proper 3.

saveMetaDataBooks = open('C:\\Users\\xxx\\Desktop\\booksMetaData.csv','a')
book_title = 'The Coming Woman: A Novel Based on the Life of the Infamous Feminist, Victoria Woodhull'
book_price = 17.93
book_stock = 'In stock'

book_tuple = book_title, book_price, book_stock
saveMetaDataBooks.write(str(book_tuple).replace("'",'').replace('(','').replace(')',''))

Is there a way to fix this issue?

edited May 28 '18 at 08:44

asked May 28 '18 at 08:39

Ilan

what is `saveMetaDataBooks`? – Azat Ibrakov May 28 '18 at 08:41
2

just use the `csv` module that will escape the commas for you. – Jean-François Fabre May 28 '18 at 08:42
@Jean-FrançoisFabre how do I do that? – Ilan May 28 '18 at 08:45
follow the duplicate link – Jean-François Fabre May 28 '18 at 08:45
probably you are doing something wrong. just use standard python csv module and use writer with any other separator(delimiter), but not comma. – NobbyNobbs May 28 '18 at 08:46

How to Include a comma ',' as a part of a tuple entry in Python

0 Answers0