Vlookup with condition using Python

See more:

Python

I have invoice dates(estimates) for about 100 customers spread across 60 columns as some are weekly/monthly/quarterly/yearly. I am trying to create a new column that will have only dates that fall in current month. I tries using filter function but did not work well - can you please suggest

What I have tried:

currentmon = datetime.datetime.now().strftime("%m")
df3 = df.loc[df['A'] == 'currentmon']