Sanctioned Date:- DateTime column
a = df[df['Sanctioned Date'] >= '2022-01-01']
b = df[df['Sanctioned Date'] <= '2022-06-16']
want :- a & b
>Solution :
Output of a, b is filtered DataFrame, so cannot chain by &.
You can chain masks with ():
out = df[(df['Sanctioned Date'] >= '2022-01-01') & (df['Sanctioned Date'] <= '2022-06-16')]
Or use Series.between:
out = df[df['Sanctioned Date'].between('2022-01-01', '2022-06-16')]
Your solution has to be changed with remove df[] first for possible chain masks:
a = df['Sanctioned Date'] >= '2022-01-01'
b = df['Sanctioned Date'] <= '2022-06-16'
out = df[a & b]