How do I create an array of multiple values extracted from the rows and columns of excel

Question

import xlrd

fw = 'C://Users/MM/Desktop/'

test=[]

wb1 = xlrd.open_workbook(fw + 'assignment.xls')
sh1 = wb1.sheet_by_index(0)

for a in range(2,sh1.nrows):    
    for b in range(0,sh1.ncols):
        test.append(sh1.cell(a,b).value)
print(test)

I have this code, but it is not doing what I want it to do. The output I am getting is

[0,200,clothes,1,300,shoes,2,900,food]

But, instead I want to have:

[0,200,clothes],[1,300,shoes],[2,900,food]

I can't think of anyway to get that. What I want is the code to read each row's data from every column and put it in the form I have above. "0" is column 0, "200" is in column 1, "clothes" is in column 2. I am sure this is know from the code I have.

khelwood · Accepted Answer · 2016-02-25 20:27:32Z

1

You can use nested list comprehensions for things like this.

test = [[sh1.cell(a,b).value for b in range(0, sh1.ncols)] for a in range(2, sh1.nrows)]

answered Feb 25, 2016 at 20:27

khelwood

59.7k14 gold badges91 silver badges116 bronze badges

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

Comments

Yaroslav Admin · Accepted Answer · 2016-02-25 20:22:55Z

0

You have to create a new list for each row on every row iteration:

test = []

for a in range(2, sh1.nrows):
    row = []
    for b in range(0, sh1.ncols):
        row.append(sh1.cell(a, b).value)
    test.append(row)

print(test)

answered Feb 25, 2016 at 20:22

Yaroslav Admin

14.7k6 gold badges65 silver badges85 bronze badges

7 Comments

Bob Over a year ago

That does it ! Thanks

Bob Over a year ago

How can I use those values from those arrays individually for something ?

Yaroslav Admin Over a year ago

@MasterMind You can do print(test[0][2]) to print 3rd column from the first row for example.

Bob Over a year ago

With the original problem, I had I am not getting those words in the array. What am I missing?

Yaroslav Admin Over a year ago

I'm not really getting. Which "those words" in which array?

|

Collectives™ on Stack Overflow

How do I create an array of multiple values extracted from the rows and columns of excel

2 Answers 2

Comments

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related