Python prettytable custom columns

Question

I'm trying to create a prettytable with 4 columns. The information I'm trying to insert per row are located in different python dictionary. I would assume the code below will work but i'm receiving the error below

Exception: Row has incorrect number of values, (actual) 2!=4 (expected)

My code is:

t = PrettyTable(['key', 'Start', 'End', 'Retention'])

for key, val in total.items():
    t.add_row([key, val])

for key, val in dic.items():
    t.add_row([key, val])

print(t)

your table is expecting 4 values for each row whereas you are entering only two values , that's the reason you are getting error — arjunsv3691, Nov 01 '17 at 19:36
@arjunsv3691 ... yes, but I have another function that is meant to add two inputs. — iNeed2LearnToEat, Nov 01 '17 at 19:37

score 0 · Answer 1 · answered Nov 01 '17 at 19:38

0

If you want to use values from both the total and dic dictionaries, You can use zip to iterate over them pairwise:

table = PrettyTable(['key', 'Start', 'End', 'Retention'])

for col_1_2, col_3_4 in zip(total.items(), dic.items()):
    table.add_row([*col_1_2, *col_3_4])

answered Nov 01 '17 at 19:38

Christian Dean

22,138
7
54
87

Part of the code worked. For dic dictionary I just want to use the values. How would i go about adding that? – iNeed2LearnToEat Nov 01 '17 at 19:54
@iNeed2LearnToEat Are the values of `dic` a list or a single element? – Christian Dean Nov 01 '17 at 20:23
no, I just want to choose a the values from it. The code you gave me prints out both key and value – iNeed2LearnToEat Nov 02 '17 at 16:03

score 0 · Answer 2 · answered Nov 01 '17 at 19:40

0

your table is expecting 4 values for each row whereas you are entering only two values, that's the reason you are getting the error, so try this

 for (k,v), (k2,v2) in zip(total.items(), dic.items()):
        t.add_row([k, v, k2, v2])

answered Nov 01 '17 at 19:40

arjunsv3691

791
6
19

Python prettytable custom columns

2 Answers2