Python automatic variable assignment based on list

Question

I have a number of variables that I would like to create in an automated way based on 2 lists, but unsure how to do so. The objective is unique, but would help me immensely.

list 1 is a list of names -

subqueries = ['name', 'name2', 'name3']

list 2 is generated from a for loop -

def sub_view(qry,subqueries):
   qry_list = []
   for sub in subqueries:
       qry_list.append(qry + """ SELECT * FROM """ +sub+ """ WHERE id='book'""")
   return qry_list

qry_list = sub_view(qry,subqueries)

To get -

subqueries[0] = qry_list[0]
subqueries[1] = qry_list[1]

and so on many times.

"I have a number of variables that I would like to create in an automated way" -- why? That is what dictionaries are for. Just use a single variable. — John Coleman
– John Coleman, Commented Mar 1, 2021 at 15:03

Ade_1 · Accepted Answer · 2021-03-01 15:03:55Z

2

You can zip both files and create a dictionary

combined_query= dict(zip(subqueries, qry_list))

answered Mar 1, 2021 at 15:03

Ade_1

1,5061 gold badge8 silver badges17 bronze badges

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

2 Comments

paranormaldist Over a year ago

ok cool, and forgive my 'newness' but then does the name dictionary values become something i can extract as a variable? - so if i wanted to extract out the string value for 'name'?

Ade_1 Over a year ago

combined_query['name'] should give you the corresponding query

Collectives™ on Stack Overflow

Python automatic variable assignment based on list

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related