Designation of applicants into Web Developer and Machine learning on the basis of their skillset
Libraries used:
Pandas, openpyexcel
To download openpyexcel use the following command "!pip install openpyxl"
In The new column "Designation" the people are classified according to their skills
When machine learning skills are more than 3 or web development skills are more than 3 it is classified into ML engineer and web developer respectively. When total skills are not more than 3 or when the relevant skills are not more than 3 the applicant is classified as "None of the above"
The output file is "Designation.xlsx"