Update Pandas df Given String Query

As a result of data introduced by users in the interface I have a string query-like.

query = '(ColA=="7") & (ColB=="3") & (ColC=="alpha") & (ColD=="yu")'

JavaScript
​x
 
query = '(ColA=="7") & (ColB=="3") & (ColC=="alpha") & (ColD=="yu")'
​

Now I want to update a column of the df based on those conditions, assigning it a variable Z.

I don’t know if it can be done somehow with loc

df.loc[query, 'ColZ'] = Z

JavaScript
 
df.loc[query, 'ColZ'] = Z
​

Answer

I got the solution by myself:

df.loc[df.eval(query), 'ColZ'] = Z

JavaScript
 
df.loc[df.eval(query), 'ColZ'] = Z
​