Parsing CSV data into a dict

Question

I'm currently trying to pass csv data into an empty dict. Column A of the dict has the book title, column B the book's author. So once passed in, I'm hoping my dict will look like this:

books = {'Booktitle1':'Author1','Booktitle2':'Author2','Booktitle 3':'Author3'}

Does this answer your question? Best way to convert csv data to dict — jolammi
– jolammi, Commented Jan 27, 2021 at 20:48
for book, author in csv.reader(csvfile): books[book] = author ? — alkasm
– alkasm, Commented Jan 27, 2021 at 20:49

Regzand · Accepted Answer · 2021-01-27 21:09:40Z

2

Something like this should solve your problem:

import csv

with open('books.csv') as file:
    reader = csv.reader(file)
    books = dict(line for line in reader if line)

The file like this:

Booktitle1,Author1
Booktitle2,Author2
Booktitle3,Author3

Will give you:

books = {'Booktitle1': 'Author1', 'Booktitle2': 'Author2', 'Booktitle3': 'Author3'}

The if line takes care of empty lines

If your file has a header, you can take a look here

answered Jan 27, 2021 at 21:09

Regzand

211 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Parsing CSV data into a dict

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related