Exclude records with specific field values

youssef.mourad

I am trying to use codebook to extract certain data as per the code found below

from the data extracted I would like to exclude records with values other than USD in the CF_CURR field

Any idea how I can do that?

df, err = ek.get_data(

instruments = ['0#EGEUROSAZ='],

fields = ['CF_CURR']

)

display(df)

chavalit-jintamalit

Hi @youssef.mourad

You can read some articles online about how to select dataframe row with column value condition.

Here is example, https://www.geeksforgeeks.org/selecting-rows-in-pandas-dataframe-based-on-conditions/

Here is the sample code for your question: