python split dataframe based on multiple criteria in 2 columns

Question

I need to filter the df based on 2 criteria: where Name != jack and ignore all dates for jack where Date <= 2020-04-01

 # List of Tuples
df =       [ ('jack', 'Apples' , '2020-01-01') ,
             ('Riti', 'Mangos' , '2020-02-01') ,
             ('Aadi', 'Grapes' , '2020-03-01') ,
             ('jack', 'Oranges', '2020-04-01') ,
             ('Lucy', 'Mangos' , '2020-05-01') ,
             ('jack', 'Apples' , '2020-12-01')
              ]
#Create a DataFrame object
df1 = pd.DataFrame(df, columns = ['Name' , 'Product', 'Date']) 
df1

Expected result being:

    Name    Product Date
0   Riti    Mangos  2020-02-01
1   Aadi    Grapes  2020-03-01
2   Lucy    Mangos  2020-05-01
3   jack    Apples  2020-12-01

Do you mean (Name != jack) or (ignore all dates for jack where date <= 2020-04-01)? — jaemmin
– jaemmin, Commented Nov 10, 2022 at 4:39
both criteria. (Name != jack) AND (ignore all dates for jack where date <= 2020-04-01) — spartacus8w2039
– spartacus8w2039, Commented Nov 10, 2022 at 4:44

Panda Kim · Accepted Answer · 2022-11-10 04:49:34Z

2

boolean indexing of multi condition

cond1 = df1['Name'] != 'jack'
cond2 = pd.to_datetime(df1['Date']) > pd.Timestamp('2020-04-01')
df1[cond1 | cond2].reset_index(drop=True)

output:

    Name    Product Date
0   Riti    Mangos  2020-02-01
1   Aadi    Grapes  2020-03-01
2   Lucy    Mangos  2020-05-01
3   jack    Apples  2020-12-01

edited Nov 10, 2022 at 4:49

answered Nov 10, 2022 at 4:43

Panda Kim

13.7k2 gold badges8 silver badges15 bronze badges

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

Comments

kavigun · Accepted Answer · 2022-11-10 04:50:56Z

0

You could do the below:

import pandas as pd
 # List of Tuples
df = [('jack', 'Apples' , '2020-01-01'), 
('Riti', 'Mangos' , '2020-02-01'),
('Aadi', 'Grapes' , '2020-03-01'),
('jack', 'Oranges', '2020-04-01'),
('Lucy', 'Mangos' , '2020-05-01'),
('jack', 'Apples' , '2020-12-01')
]
#Create a DataFrame object
df1 = pd.DataFrame(df, columns = ['Name', 'Product', 'Date']) 

# Filtering for condition Name = !jack
df1 = df1[df1['Name'] != 'jack']

# Convert the date to datetime64
df1['Date'] = pd.to_datetime(df1['Date'], format='%Y-%m-%d')

# Filter by specified date
filtered_df = df1.loc[(df1['Date'] <= '2020-04-01')]

# print the filtered result
print(filtered_df)

answered Nov 10, 2022 at 4:50

kavigun

2,3832 gold badges18 silver badges38 bronze badges

Collectives™ on Stack Overflow

python split dataframe based on multiple criteria in 2 columns

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related