Apply loc for 2 columns values Pandas

Question

I´m tying to loc a dataframe with 2 columns parameters: if I do paises_cpm = df.loc[a]is working but if I do paises_cpm = df.loc[a,b] I receive an error: IndexingError: Unalignable boolean Series provided as indexer (index of the boolean Series and of the indexed object do not match

import pandas as pd
import time


fecha = time.strftime(str((int(time.strftime("%d")))-1))

subastas = int(fecha) * 5000
impresiones = int(fecha) * 1000

df = pd.read_csv('Cliente_x_Pais.csv')
a = df['Subastas'] > subastas
b = df['Impresiones_exchange'] > impresiones


paises_cpm = df.loc[a,b]

paises_cpm.to_csv('paises_cpm.csv', index=False)

yoonghm · Accepted Answer · 2018-12-06 14:06:30Z

8

You need chain conditions with | for or or & for and:

paises_cpm = df.loc[a | b]

Or:

paises_cpm = df.loc[a & b]

There is possible one line solution, but parentheses are necessary:

paises_cpm = df.loc[(df['Subastas'] > subastas) | 
                    (df['Impresiones_exchange'] > impresiones)
                   ]

edited Dec 6, 2018 at 14:06

yoonghm

4,7051 gold badge40 silver badges53 bronze badges

answered Jan 24, 2018 at 13:19

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

2 Comments

Martin Bouhier Over a year ago

Can you tell my how can I sort by values with that: paises_cpm = paises_cpm.sort_values(by=['Country', 'Subastas'],ascending=False) It works but I need to do it with Country ascending and Subastas descending

jezrael Over a year ago

You are really close, need change ascending=False to ascending=[True, False]

Collectives™ on Stack Overflow

Apply loc for 2 columns values Pandas

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related