List of list if statement for Python

Question

I have a list that looks like:

[['a', 'b', 'null', 'c'], ['d', 'e', '5', 'f'], ['g' ,'h', 'null' ,'I'] ]

I want to uppercase all strings, but when I try:

x = 0
for row in range(1, sheet.nrows):
    listx.append(sheet.cell(row, x))
    [x.upper() for x in x in listx]
x += 1

I got:

TypeError: 'bool' object is not iterable

How can I make a statement for it?

`... for x in x in listx` - that doesn't look right, surely? — jonrsharpe, Mar 17 '18 at 12:38
Thanks for reply I tried make upper for each element in each lists and u are right that loop doesn't seem good. — Halil İbrahim Akalın, Mar 17 '18 at 12:42

score 3 · Accepted Answer · answered Mar 17 '18 at 12:43

3

This list comprehension does it, and retains your list of lists structure:

listx = [['a', 'b', 'null', 'c'], ['d', 'e', '5', 'f'], ['g' ,'h', 'null' ,'I'] ]

[[x.upper() for x in sublist] for sublist in listx]

returns:

[['A', 'B', 'NULL', 'C'], ['D', 'E', '5', 'F'], ['G', 'H', 'NULL', 'I']]

answered Mar 17 '18 at 12:43

sacuL

49,704
8
81
106

Thanks for reply I tried sth look like code but when I run it I get TypeError: 'Cell' object is not iterable error – Halil İbrahim Akalın Mar 17 '18 at 12:45
You are absolutely right I solved my problem with using pandas thanks for ur time. – Halil İbrahim Akalın Mar 17 '18 at 13:12

score 1 · Answer 2 · answered Mar 17 '18 at 12:43

1

is this what you're looking for:

l = [['a', 'b', 'null', 'c'], ['d', 'e', '5', 'f'], ['g' ,'h', 'null' ,'I']]
new_list = []
for row in l:
    new_list.append([x.upper() for x in row])

answered Mar 17 '18 at 12:43

gyx-hh

1,421
1
10
15

solution by @sacul is better than this. – gyx-hh Mar 17 '18 at 12:45

List of list if statement for Python

2 Answers2