DAY 31 - Organize a Secret Santa Game in your organization using a Python Script
The script will perform below mentioned activities: 1. Assign a Secret Santa randomly to each participant 2. Save the final extract into an excel file 3. Send an automated mail to each Secret Santa with a complete address details of his/her Secret Santa Child Sample final extract file: Sample Mail Format: Prerequisite: 1. Collect information of participants in an excel file as shown below. 2. Click on “Manage your Google Account” > Security > Less secure app access Turn ON access for less secure app Note - This setup is required to send a mail from Gmail using Python script Python Script: # -*- coding: utf-8 -*- """ Created on Wed Dec 2 12:15:58 2020 @author: Rakesh.Ranjan """ import random import pandas as pd import numpy as np import os import string ss_keys = [] ssc_values = [] input_file_name = "Secret Santa - Information needed-Tes...