Remove Additional & in the end whilst generating a query string

Question

I am constructing a query string for pandas and appending & at the end of each condition

So, for example if I have condition1, condition2, condition3 my query would be generated as: "condition1 & condition2 & condition3 &"

I am using json to provide flexibility to the user to specify condition and then read json:

    {"scenario": "123-456-222",  
     "query": 
        {
          "key": "field1",
          "value": "condition1"
        },
        {
          "key": "field2",
          "value": "condition2"
        },
        {
          "key": "field3",
          "value": "condition3"
        },
    "data":

Next, I use python's final_condition[:-1] to remove the redundant & in the end.

Wondering if there's a better way to organise this code.

test_str = "field1=condition1 & field2=condition2 & field3=condition3 &"
print(test_str[:-1])

Patrick Haugh · Accepted Answer · 2022-03-27 01:33:50Z

3

You can use str.join to put the ampersands between the operands:

args = ["statement 1", "statement 2",  "statement 3"]
output = " & ".join(args)
print(output)
# statement 1 & statement 2 & statement 3

answered Mar 27, 2022 at 1:33

Patrick Haugh

61.4k13 gold badges94 silver badges101 bronze badges

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

Collectives™ on Stack Overflow

Remove Additional & in the end whilst generating a query string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related