df = pd.read_csv(r"C:\Users\micault.DOMPHILYO1\Downloads\nat2017_txt\nat2017.txt", sep='\t')
df2 = df[df.annais != 'XXXX']
df2.annais = df2.annais.astype('int64')
df3 = df2[df2.sexe == 2].groupby(['sexe', 'preusuel'], as_index = False).sum().sort_values(by='nombre', ascending=False).iloc[0:600,]

import sqlite3, random

con = sqlite3.connect("/home/pi/django/prenoms/prenoms/db.sqlite3")

d= con.execute('SELECT * from main_prenoms WHERE voted = 0 AND id = ' + str(random.randrange(6,605)))
res= d.fetchone()
con.execute("UPDATE main_prenoms SET voted = 1 WHERE prenom = '" + res[1] + "'")
string_html = 'http://127.0.0.1:8000/main/?prenom=' + res[1] + '&user=caro&token=petitpepin'

echo $'Vote pour http://127.0.0.1:8000/main/?prenom=HELENA=&user=caro&token=petitpepin \n balala' | mail -s "test" micaultanthony@gmail.com