How i can convert a list to a dictionary in python 3.4

Question

How i can convert a list of,

>> print(row)
>> [text:'Data 1', text:'Data 27']  # this is list but i want a dic

to something like

>> print(row)
>> {'text':'Data 1', 'text':'data 27'} # this is how i want my list to be

i tried like every possible aswer that i found while googling this.

this is what i got when i write print(type(row[0]))

this is my full code

import xlrd

def readData(xlsxfilename):
    workbook = xlrd.open_workbook(xlsxfilename, on_demand=True)

    # Getting the first sheet in the file which should contain input data
    worksheet = workbook.sheet_by_index(0)

    max_nb_row = 0
    max_nb_row = max(max_nb_row, worksheet.nrows)

    # Getting data
    i = 0
    for row in range(max_nb_row):
        if i is not 0:  # skip the first row because it just contains: Data Column 1 Data Column 2
            if row < worksheet.nrows:
                calcScore(worksheet.row(row))
        i += 1


# TODO: calculate the score
def calcScore(row):
    print(type(row[0]))

It does not look like a list, and furthermore in a dictionary a key can occur **only once**. — Willem Van Onsem, Mar 27 '17 at 12:30
I suspect that `row` is actually a string. What does `print(repr(row))` print? — PM 2Ring, Mar 27 '17 at 12:30
print(repr(row)) is printing this: [text:'Data 1', text:'Data 27'] — Ayyoub, Mar 27 '17 at 12:32
That looks like anything but a list... Are you sure that's how you have it? — Mr. Xcoder, Mar 27 '17 at 12:32
Better put a screenshot of what is being printed out, since it doesn't make sense at all — , Mar 27 '17 at 12:33
I suspected that the row items were some kind of class instance. So you need to know how to extract the data you want from those `xlrd.sheet.Cell` objects. Is that an Excel spreadsheet cell? — PM 2Ring, Mar 27 '17 at 12:39
This question might be useful: http://stackoverflow.com/questions/8909342/python-xlrd-how-to-convert-an-extracted-value — , Mar 27 '17 at 12:40
Yes sir, will do. for now if you could help me that will be great — Ayyoub, Mar 27 '17 at 12:51
You should have mentioned that you were using Excel and xlrd in the question. But anyway, you can probably extract the cell values into a list like `[c.value for c in row]`. But you can't build a dict for the reason Willem mentioned at the start. — PM 2Ring, Mar 27 '17 at 12:53
BTW, thanks for responding to all these requests in the comments. But we really _don't_ need that screenshot: the `` text gave us all the info we needed. — PM 2Ring, Mar 27 '17 at 12:55
No worries. Next time, try to include all the relevant details in your question. :) — PM 2Ring, Mar 27 '17 at 12:56
thanks @PM2Ring some people asked for the screen shot, that's why i post it there — Ayyoub, Mar 27 '17 at 12:56

score 0 · Answer 1 · answered Mar 27 '17 at 13:00

0

from the comments, @PM2Ring suggested using this, and it worked like a charm

[c.value for c in row]

answered Mar 27 '17 at 13:00

Ayyoub

4,581
2
19
32

How i can convert a list to a dictionary in python 3.4

1 Answers1