Python - Printing a list of lists with strings inbetween

Question

I am trying to write a function that will take a list of lists and print them out one by one with the word UNION between them. My code looks like this:

def printsql(lst):
    print("INSERT INTO table")
    for x in lst:
        print("SELECT")
        print(*x, sep=', ')
        print("UNION")
    return(str)

a = [[1, 3, 4], [2, 5, 7], [3, 4, 6]]

print(printsql(a))

My output currently looks like this:

INSERT INTO table
SELECT
1, 3, 4
UNION
SELECT
2, 5, 7
UNION
SELECT
3, 4, 6
UNION

This is almost exactly what I need but I can't figure out how to not print the last "UNION". Can someone advise?

Aside from this being a duplicate, `return(str)` in this code makes absolutely no sense, and neither does the `print` in `print(printsql(a))`. — Karl Knechtel, Mar 29 '23 at 07:43

score 3 · Answer 1 · answered Mar 11 '18 at 17:25

3

The brute force is to use enumerate

for idx, x in enumerate(lst):
  #other stuff#
  if idx<(len(lst) - 1):
    print("UNION")

But I’d be interested to see if there is a more elegant solution.

answered Mar 11 '18 at 17:25

Pam

1,146
1
14
18

I think adding a repeating pattern at the front of strings just screams .join() like dwag did, but I find this answer to be more readable and simple! Good stuff! – Farstride Mar 11 '18 at 19:06

dawg · Answer 2 · 2018-03-12T17:30:13.140

Consider using the .join method in Python to insert a string between list elements.

Works like so:

>>> '|'.join(['a','b','c','d'])
'a|b|c|d'

Your example is essentially doing this:

[Header string "INSERT INTO table\nSELECT\n"]
'\nUNION\nSELECT\n'.join([list items])
', '.join([sub list items])

To get the pattern you describe.

You can take that description and translate to Python:

def printsql(lst):
    s="INSERT INTO table\nSELECT\n"
    s+="\nUNION\nSELECT\n".join(', '.join(str(e) for e in sl) for sl in lst)
    return s

Then:

>>> a = [[1, 3, 4], [2, 5, 7], [3, 4, 6]]
>>> print(printsql(a))
INSERT INTO table
SELECT
1, 3, 4
UNION
SELECT
2, 5, 7
UNION
SELECT
3, 4, 6

The general outline is:

Create the header with s="INSERT INTO table\nSELECT\n";
Use a nested join to create the list of lists format of "\nUNION\nSELECT\n" between the outer list elements and ', ' with the inner list elements;
Return the string to be printed or used in another section of the program.

Austin · Answer 3 · 2018-03-11T17:45:44.797

This is one way avoiding an extra looping and condition:

def printsql(lst):
    print("INSERT INTO table")
    for x in lst[:-1]:
        print("SELECT")
        print(*x, sep=', ')
        print("UNION")
    print("SELECT")
    print(*lst[-1], sep=', ')
    return(str)

a = [[1, 3, 4], [2, 5, 7], [3, 4, 6]]

print(printsql(a))

'''
INSERT INTO table
SELECT                                                      
1, 3, 4                                                     
UNION                                                      
SELECT                                                      
2, 5, 7                                                     
UNION                                                       
SELECT                                                     
3, 4, 6                                                    
<class 'str'>                                               
'''

That’s elegant and readable! Dawg's answer is also good, but I find the python style of putting loads of things on one line difficult to follow/generate. — Pam, Mar 11 '18 at 19:25
@Pam thank you. I find yours the best of the five and should have been accepted as answer. Happy coding! — Austin, Mar 12 '18 at 02:12

Ryan · Accepted Answer · 2018-03-11T17:57:00.587

1

This will remove the last union and class str

   def printsql(lst):
        print("INSERT INTO table")
        counter = 0
        for x in lst:
                counter = counter + 1
                print("SELECT")
                print(*x, sep=', ')
                if (len(lst)- 1) > counter:
                        print("UNION")
        return("")

a = [[1, 3, 4], [2, 5, 7], [3, 4, 6]]

print(printsql(a))

edited Mar 11 '18 at 17:57

answered Mar 11 '18 at 17:31

Ryan

133
2
13

This is a quick and easy solution. – Ryan Mar 11 '18 at 17:33
Awesome, Thanks so much – Joel Mar 11 '18 at 17:42
Why the `return(str)`? When you print the returned value you get `` from an empty `str` object. – dawg Mar 11 '18 at 17:44
I fix the class "str" return value can you remove your down vote to the code now. – Ryan Mar 11 '18 at 17:57
Well, enumerate is more elegant than counter, but this works fine, too! – Pam Mar 11 '18 at 17:59

score 0 · Answer 5 · answered Mar 11 '18 at 17:27

0

Quick and dirty.

def printsql(lst):
    print("INSERT INTO table")
    for x in lst:
            if x != lst[-1]:
                 print("SELECT")
                 print(*x, sep=', ')
                 print("UNION")
            else:
                print("SELECT")
                print(*x, sep=', ')

    return(str)

a = [[1, 3, 4], [2, 5, 7], [3, 4, 6]]

print(printsql(a))

answered Mar 11 '18 at 17:27

Jon Reinhold

189
1
9

Does this assume a list of unique strings? That is, if all the strings in the list are identical, will it work? – Pam Mar 11 '18 at 17:56
1

It assume the final value is unique. Safer route would be if x is lst[-1] – Jon Reinhold Mar 11 '18 at 18:02

Python - Printing a list of lists with strings inbetween

5 Answers5