I am trying to use findall to find index of items in a dataframe based on multiple conditions. In the example below, I want to find indices when value in FIELD1 = A and values in FIELD3 = 0
df = DataFrame(ID = collect(1:5), FIELD1 = ["A","B","A","C","A"], FIELD3 = [0,1,0,1,1],FIELD4 = ["One","Two","Three","Four","One"])
# with one condition I can find indices using
findall(x -> x == "A", df.FIELD1)
# with two conditions, I don't know the correct syntax
findall((x -> (x == "A" && x == 0), (df.FIELD1, df.FIELD3)))
Thanks. This does not return the indices or row numbers that I am after. I would like to collect row numbers as shown in my code based on one condition