Creating a database from a .csv file

Question

I need to take a .csv file, open the file, read the file, then create a database, which is a dictionary whose keys are years and values are a list with a tuple in it, like so:

db = {2002:[('Andrew', 5, 63, 75000)], etc…}

The categories that I need are 'Name', Category, deaths, DamageMillions

This is a snap of the data that I am working with:

enter image description here

How would I do this?

Edit: I know how to open and read the file, I just don't know how to create the database.

The spreadsheet is a database! What more do you want?

wallyk
– wallyk

2015-07-09 15:41:16 +00:00
Commented Jul 9, 2015 at 15:41 — wallyk
– wallyk, Commented Jul 9, 2015 at 15:41

Ewan · Accepted Answer · 2015-07-09 15:41:42Z

2

This is untested but should give you a good idea where to start:

import csv
from collections import defaultdict

db = defaultdict(list)
with open('csvfile.csv') as f:
     csvreader = csv.reader(f)
     for row in csvreader:
         db[row[0]].append((row[1], row[4], row[5], row[6]))

return db

More info on defaultdict and the csv module.

answered Jul 9, 2015 at 15:41

Ewan

15.2k6 gold badges50 silver badges65 bronze badges

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

Comments

nucleon · Accepted Answer · 2015-07-09 15:41:15Z

0

Use the csv module in conjunction with DictReader. You'll get a list of dictionaries to iterate over, which you'll have to transform to get your desired year indices.

See: https://docs.python.org/2/library/csv.html

answered Jul 9, 2015 at 15:41

nucleon

1,1581 gold badge7 silver badges19 bronze badges

Collectives™ on Stack Overflow

Creating a database from a .csv file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related