Python Pandas - df.loc - adding additional criteria not working

Question

I have a script with the following code that is working as intended

Table2 = df.loc[df.Date.between('2018-11-22','2018-11-30')].groupby(df['FPYear'])[['New Customer', 'Existing Customer', 'revenue']].sum()

However, now i am trying to add an additional criterion in order to filter on a column called "region" which has the value Canada in the dataset but it doesn't seem to be working.

Table2 = df.loc[df.Date.between('2018-11-22','2018-11-30'), df['Region'] = 'Canada'].groupby(df['FPYear'])[['New Customer', 'Existing Customer', 'revenue']].sum()

The additional filter seems to have no impact. Can anyone help. Thanks

You can combine boolean sequences using &.

AMC
– AMC

2019-11-30 04:09:10 +00:00
Commented Nov 30, 2019 at 4:09 — AMC
– AMC, Commented Nov 30, 2019 at 4:09
how would i adjust my code?

wolfblitza
– wolfblitza

2019-11-30 04:24:24 +00:00
Commented Nov 30, 2019 at 4:24 — wolfblitza
– wolfblitza, Commented Nov 30, 2019 at 4:24

Asif Ali · Accepted Answer · 2019-11-30 15:40:42Z

2

As mentioned by @Alaxander

Here's an example snippet:

import pandas

df = pd.DataFrame({
    "A": [1,2,3],
    "B": [4,5,6],
    "C": [1,1,1]
})

df.loc[((d["A"]==1) & (d["B"]==4)), ["A", "B"]]

Also, you might want to look at the assignment operator used in df["Region"] = "Canada", shouldn't it be == for it to be used as a filter? I have added this as well in your code below.

Your code if you want specific fields:

Table2 = df.loc[((df.Date.between('2018-11-22','2018-11-30')) & (df['Region'] == 'Canada')), ["Date", "Region"]].groupby(df['FPYear'])[['New Customer', 'Existing Customer', 'revenue']].sum()

Your code if you want all the fields:

Table2 = df.loc[((df.Date.between('2018-11-22','2018-11-30')) & (df['Region'] == 'Canada'))].groupby(df['FPYear'])[['New Customer', 'Existing Customer', 'revenue']].sum()

PS: Thanks to @Alexandar for mentioning about the mistake.

edited Nov 30, 2019 at 15:40

answered Nov 30, 2019 at 4:44

Asif Ali

1,4323 gold badges12 silver badges30 bronze badges

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

1 Comment

Asif Ali Over a year ago

Made the changes thanks and added all possible variations :) Thanks for pointing out @AlexanderCécile

wolfblitza · Accepted Answer · 2019-11-30 04:44:56Z

0

i figured this out by doing the following

Table2 = df.loc[df.Date.between('2018-11-22','2018-11-30') & (df['Region'] == 'Canada')].groupby(df['FPYear'])[['New Customer', 'Existing Customer', 'revenue']].sum() #with date filters for table

answered Nov 30, 2019 at 4:44

wolfblitza

4871 gold badge6 silver badges17 bronze badges

Collectives™ on Stack Overflow

Python Pandas - df.loc - adding additional criteria not working

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related