Exception Report from pandas DataFrame

Question

Background:
The following function takes a pandas DataFrame and renames it exceptions_df whilst applying 2x conditions to it.

Function:

def ownership_exception_report():
    df = ownership_qc()
    exceptions_df = df[df['Entity ID %'] != 100.00]
    exceptions_df = df[df['Account # %'] != 100.00]
    return exceptions_df

My problem:
Whilst my code works fine, I wonder if there is a simple and more eloquent way to apply 2x conditions to a DataFrame and resave it? At the moment I am simply resaving the exceptions_df twice and it seems rather messy. Or perhaps I am wrong, and this is the correct way to apply conditions to a DataFrame?

user17242583 · Accepted Answer · 2021-12-08 15:28:18Z

3

def ownership_exception_report():
    df = ownership_qc()
    return df[(df['Entity ID %'] != 100.00) & (df['Account # %'] != 100.00)]

Or:

def ownership_exception_report():
    df = ownership_qc()
    return df[df['Entity ID %'].ne(100.00) & df['Account # %'].ne(100.00)]

Both will return a copy of df with only the rows where Entity ID % is 100 AND Account # % is 100.

answered Dec 8, 2021 at 15:28

user17242583

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

Collectives™ on Stack Overflow

Exception Report from pandas DataFrame

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related