CODEWITHSUNDEEP
pythoncsvdictionary
user3458145
user3458145

Reputation: 53

Creating a dictionary

my goal is to create a dictionary in Python. I have a .csv file which contains two columns, first one being 'word', other being 'meaning'. I am trying to read the csv file in the dictionary format and get the 'meaning' when 'word' is given.

Can you please help me by telling me how to get the value of 'word'? this is what I tried:

My codes are,

>>> with open('wordlist.csv', mode = 'r') as infile:
...     reader = csv.reader(infile)
...     with open('wordlist.csv', mode = 'w') as outfile:
...         writer = csv.writer(outfile)
...         mydict = {rows[0]:rows[1] for rows in reader}
...     print(mydict)
...

The result turns out to be,

{}

the next one I tried was,

>>> reader = csv.reader(open('wordlist.csv', 'r'))
>>> d = {}
>>> for row in reader:
...     k, v = row
...     d[k] = v
...

But when I wanted to use this, the result was like this- 

>>> d['Try']
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
KeyError: 'Try'

The next code I tried was,

>>> reader = csv.DictReader(open('wordlist.csv'))
>>> result = {}
>>> for row in reader:
...     key = row.pop('word')
...     if key in result:
...         pass
...     result[key] = row
...     print result
...

It didn't give me any answer at all.

>>> for row in reader:
...     for column, value in row.iteritems():
...         result.setdefault(column, []).append(value)
...     print result
...

Neither did this give me a result.

Upvotes: 2

Views: 385

Answers (2)

Chris Hagmann
Chris Hagmann

Reputation: 1096

I would use pandas. You could then use zip two create the dictionaries.

import pandas as pd    

df = pd.read_csv('wordlist.csv')
words = list(df.word)
meaning = dict( zip( df.word, df.meaning ) )

if your file doesn't have a header row, that is ok. just print out the each column is still given some name which can then be referenced.

Alternative:

import pandas as pd    

df = pd.read_csv('wordlist.csv')
dictionary = {}

for w, s, m, p in zip(df.words, df.meaning):
    dictionary[w] = [m, p]

Upvotes: 1

Tim Lind
Tim Lind

Reputation: 160

If "final_word.csv" looks like this:

word1, synonym1, meaning1, POS_tag1
word2, synonym2, meaning2, POS_tag2

This will read it in as a dictionary:

with open("final_word.csv",'r') as f:
    rows = f.readlines()

dictionary = {}
for row in rows:
    row = row.strip()
    word, synonym, meaning, POS_tag = row.split(", ")
    dictionary[word] = [synonym, meaning, POS_tag]

print(dictionary['word1'])
#out>> ['synonym1', 'meaning1', 'POS_tag1']
print(dictionary['word2'][0])
#out>> synonym2

The strip() is used to get rid of the newlines "\n" that's in the end of each csv-row

Upvotes: 1

Related Questions