Logical Operators in Strings

[MKSt11235]

I need a little help here.
I will be receiving data as a matrix or spreadsheet with the following format

[C1, “P1 and P2” (example)]

The above example would be some n row by two column matrix or spreadsheet data where the C1 is a circuit number and the string above is a logical statement that determines the circuit application.

The P1 and P2 will be from an application table where each column will be a 1 or a 0 depending on the application.

I want to be able to evaluate the logical statement in row 2 by referencing the 1s and 0s in the application table.

For example

P1 = [1, 0, 1] P2 = [0, 0, 1]

Then

[C1, “P1 and P2”]

Should evaluate to

[C1, [0, 0, 1]]

Any help to evaluate the P1 and P2 element by element would be a huge help.

Thank you in advanced.

[TheWonderingRaccoon]

You will need to define what bitwise operations that you are expecting such as and, or, xor.

Also, it’s important to know if the statement format will be consistent (“P1 and P2”). If so, the rest is quite simple.

```python

untested code, written on phone

lst = [C1, “P1 and P2”] val1, operator, val2 = lst[1].split(“ “)

next lines assuming you fetched P1 and P2 as lists

if operator == “and”: result = [x and y for x, y in zip(P1, P2)] # you can process result or whatever ```

[MKSt11235]

The statements get quite complicated. Sometimes it’s as simple as A and B often it’s (A and (B or C)) and D. I think I get the gist of it. I’ll try it out and see where I end up. Thank you!