How to add another condition to filter csv data

Question

My question is related to this post:

How to filter csv data by applying conditions on certain columns in python

How would I apply another condition? For example, let's say I'm only interested in Albania and Zambia when Energy_Supply_per_capita > 280 and emissions_of_co2 < 30? Thanks

MaxU - stand with Ukraine · Accepted Answer · 2017-06-12 22:25:25Z

1

Try this:

q = "Country_Area in ['Albania','Zambia'] "+\
    "and Energy_Supply_per_capita > 280 "+\
    "and emissions_of_co2 < 30"
df.query(q)

answered Jun 12, 2017 at 22:25

MaxU - stand with Ukraine

212k37 gold badges402 silver badges437 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Pistol Pete Over a year ago

One of the comments included these lines of code: cols = ['Country_Area', 'Energy_Supply_per_capita', 'Avg_GDP'] data_c.query('Energy_Supply_per_capita > 280')[cols]. How would I incorporate them? ps sorry for the poor formatting. I'm very new to stack overflow and still figuring things out.

Pistol Pete Over a year ago

To be more clear, how would I include the rows from another column of data, such as Avg_GDP for those countries? Thanks again

MaxU - stand with Ukraine Over a year ago

@PistolPete, it's not clear - what are you trying to achieve. Please edit your question and provide a small reproducible data set and a desired data set

Collectives™ on Stack Overflow

How to add another condition to filter csv data

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related