I have a dataframe with 4 columns identifieds with names single and compounded "Identificação Única", "Nome", "Código da Rubrica" and "Valor" and I would like to get some values from these columns. e.i. numbers 10 and 11 from "Identificação Única" or numbers 1 and 2 from "Origem". The code following just works if the name of the columns is single, but it doesn't works if it is compound.
For example:
For example:
#f0619.query('Origem in ["1", "2"]') # it works fine f0619.query('Código Rubrica in ["27","69"]') # it doesn't works, but if I rename these column to, let's say, Codigo_Rubrica, it works fine.How can I to work with compound columns using "IN"?