How to check multiple columns value within range

[SamLiu]

Hi all,

The demo is wanted check multiple columns within range(filter out of range row) and pick up other columns.

when chosen one column that can work by between function, but add more columns got an error.

import pandas as pd
df=pd.read_csv(r'log.csv',header=1).drop([0,1])

df1=df['VDD Continuity'].between(-0.8,-0.25,inclusive ='both')
print(df[df1]['DUT_NM_Noise'])
# It is work as well.



df1=df[['VDD Continuity','LR Continuity','DATA Continuity','SCLK Continuity']].astype('float').between(-0.8,-0.25,inclusive ='both')
print(df[df1]['DUT_NM_Noise'])

It doesn't work.

Is there have a good way to handle the issue,thanks!!

[snippsat]

Try this.

import pandas as pd

df = pd.read_csv(r'log.csv', header=1).drop([0, 1])
# Filter rows based on multiple columns
filter_cond = (
    df['VDD Continuity'].between(-0.8, -0.25, inclusive='both') &
    df['LR Continuity'].between(-0.8, -0.25, inclusive='both') &
    df['DATA Continuity'].between(-0.8, -0.25, inclusive='both') &
    df['SCLK Continuity'].between(-0.8, -0.25, inclusive='both')
)

filtered_df = df.loc[filter_cond]
result = filtered_df['DUT_NM_Noise']
print(result)

[SamLiu]

It's work, thanks for you.