How To Import Web Table Content Into Excel And Then Send It Through Email In Python

Although I tried to get this coding done using pandas, xlrd etc libraries, but not able to get success till now. Problem Statement: So I have a website that is having two tables and I need to import both the tables into Excel and then filter it on date column and send the output on an email address.

Can someone help on this...!!!