How do I filter a Dataframe row by knowing a String value from one of its columns?

Question

Let’s say I have at hand this dataframe

And I know that a specific value inside a column called "Code", contains a String that I will call "mxrf11", in the whole dataframe will not have another name 'mxrf11'' in the column "code" (I am commenting on this because I do not know if it is relevant to have repeated values, but in the case of this Dataframe no name of the column "Codes" is repeated)

How do I pull the Dataframe information line related to the code "mxrf11"?

Edit 1 : Trying the solution of the first comment

Something strange happened, he gave the names of the columns of the Dataframe instead of the information associated with the line

Interestingly, the same problem happened in the second solution suggested in the post.

Edit 2 - The problem was that the letters were lowercase so Dataframe did not return anything. By replacing with the uppercase letter all methods returned the expected information. :)

Answer 1

Take the example:

Creating Dataframe Example

>>> import pandas as pd

>>> df = pd.DataFrame({"frutas": ["banana", "laranja", "pera", "uva", "banana", "pera"], "codigo": ["um", "dois", "mxrf11", "quatro", "cinco", "seis"]})

>>> df
    frutas  codigo
0   banana      um
1  laranja    dois
2     pera  mxrf11
3      uva  quatro
4   banana   cinco
5     pera    seis

Filtering by the code

>>> df[df["codigo"] == "mxrf11"]

  frutas  codigo
2   pera  mxrf11

Assigning result to another Dataframe

>>> df_filtrado = df[df["codigo"] == "mxrf11"]

>>> print(df_filtrado)

  frutas  codigo
2   pera  mxrf11

Filtering by PART of the code

>>> df[df['codigo'].str.contains("mxr")]

  frutas  codigo
2   pera  mxrf11

I hope it helps

Answer 2

Creating Data Frame Test

import pandas as pd

codigos = ['cod1','mxrf11','cod2','mxrf11','cod3','mxrf11']
valores = ['teste1','teste2','teste3','teste4','teste5','teste6']

df = pd.DataFrame({'Codigos':codigos, 'Valores':valores})

---

Use the isin

busca = ['mxrf11']
df[df['Codigos'].isin(busca)]

Exit

   Codigos  Valores
1   mxrf11  teste2
3   mxrf11  teste4
5   mxrf11  teste6

---

Use the Loc

df[df.loc[:,'Codigos'] == 'mxrf11']

Exit

   Codigos  Valores
1   mxrf11  teste2
3   mxrf11  teste4
5   mxrf11  teste6