otavio-s-s

from selenium import webdriver
from selenium.webdriver.chrome.options import Options
import pandas as pd
import smtplib
from time import sleep

otavio-s-s

def send_email(subject, msg):
  try:
    mail_from = 'your email as string'
    password = 'Your password as string'
    mail_to = 'The email address that will receive the email as string'
    server = smtplib.SMTP('smtp.gmail.com:587')
    server.ehlo()
    server.starttls()
    server.login(mail_from, password)
    message = f'Subject: {subject}\n\n{msg}'

otavio-s-s

while True:
  my_url = 'https://community.dataquest.io/c/qa/44'
  option = Options()
  option.headless = True
  driver = webdriver.Chrome(options=option)
  driver.get(my_url)

otavio-s-s

tables = pd.read_html(driver.page_source)
table = tables[0]

otavio-s-s

table = table.iloc[1:10, [0, 2, 5]]
table['time'] = table['Activity'].str[-1]
table['Activity'] = table['Activity'].str[:-1].astype(int)

otavio-s-s

new_topics = table[(table['time'] == 'm') & (table['Activity'] <= 10) & (table['Replies'] == 0)]
new_topics = new_topics.reset_index(drop=True)
num_new = new_topics.shape[0]

otavio-s-s

if num_new > 0:
  subject = f'{num_new} new topics!'
  msg = f'New topics: \n {new_topics}\n\n {my_url}'
  send_email(subject, msg)
else:
  print('No new topics found.')
 
sleep(600)

otavio-s-s

   Topic                                               Replies Activity time
1  Star Wars Survey Project - Converting Yes/No r...        0         1    m
2  Distance above and below the mean of a distrib...        3        21    m
3  Help : Reading from dictionary  Non-DQ Courses...       10         1    h
4  Categorical and Quantitative data  Non-DQ Courses        4         2    h
5  Problem to finish the exercise and mission 392...        2         2    h
6  Cannot connect with DB from Jupyter Notebook  ...        8         5    h
7  Intro courses not working (possible bug)  DQ C...        1         7    h
8  How does one solve “invalid literal for int() ...        1         8    h
9  Problem with saving takeaways  DQ Courses  dat...        3         8    h

otavio-s-s

otavio-s-s