{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "d574d4b5-26ce-4e9e-b310-fa8a19fcfac1", "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "import spacy\n", "from nltk.stem.porter import PorterStemmer\n", "from nltk.stem import WordNetLemmatizer\n", "import re\n", "from nltk.stem import SnowballStemmer\n", "import matplotlib.pyplot as plt\n", "import seaborn as sns" ] }, { "cell_type": "code", "execution_count": 2, "id": "2539be18-2320-46e8-92d6-3c111db91a77", "metadata": {}, "outputs": [], "source": [ "data=pd.read_excel('SHL_assesment_list.xlsx')" ] }, { "cell_type": "code", "execution_count": 3, "id": "551911cd-5cdb-4641-a640-73eb6b5d5124", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | Assesment Name | \n", "URL | \n", "Remote Testing Support | \n", "Adaptive/IRT | \n", "Duration | \n", "Job Type | \n", "Test Type | \n", "Description | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "Account Manager Solution | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "yes | \n", "49 | \n", "Middle | \n", "CPAB | \n", "The Account Manager solution is an assessment ... | \n", "
1 | \n", "Administrative Professional-Short Form | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "yes | \n", "36 | \n", "Entry -level | \n", "AKP | \n", "The Administrative Professional solution is fo... | \n", "
2 | \n", "Agency Manager Solution | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "yes | \n", "51 | \n", "Manager | \n", "ABPS | \n", "The Agency Manager solution is for mid-level s... | \n", "
3 | \n", "Apprentice + 8.0 Job Focused Assessment | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "no | \n", "30 | \n", "Entry -level | \n", "BP | \n", "The Apprentice + 8.0 Job-Focused Assessment is... | \n", "
4 | \n", "Apprentice 8.0 Job Focused Assessment | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "no | \n", "20 | \n", "Entry -level | \n", "BP | \n", "The Apprentice 8.0 Job-Focused Assessment is a... | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
139 | \n", "Workplace Safety - Individual 7.1 (Americas) | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "no | \n", "16 | \n", "Entry-Level | \n", "B | \n", "Our Workplace Safety - Individual 7.1 solution... | \n", "
140 | \n", "Workplace Safety - Team 7.0 Solution | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "no | \n", "20 | \n", "Director | \n", "B | \n", "The Workplace Safety – Team 7.0 solution is de... | \n", "
141 | \n", "Workplace Safety - Team 7.1 (Americas) | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "no | \n", "20 | \n", "Entry-Level, General Population, Professional ... | \n", "BCP | \n", "The Workplace Safety – Team 7.1 solution is de... | \n", "
142 | \n", "Workplace Safety - Team 7.1 (International) | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "no | \n", "20 | \n", "Entry-Level, General Population, Professional ... | \n", "BCP | \n", "The Workplace Safety – Team 7.1 solution is de... | \n", "
143 | \n", "Workplace Safety Solution | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "yes | \n", "21 | \n", "Entry-Level | \n", "BP | \n", "The Workplace Safety Solution is designed for ... | \n", "
144 rows × 8 columns
\n", "\n", " | Duration | \n", "
---|---|
count | \n", "144.000000 | \n", "
mean | \n", "38.569444 | \n", "
std | \n", "14.045706 | \n", "
min | \n", "16.000000 | \n", "
25% | \n", "27.500000 | \n", "
50% | \n", "40.000000 | \n", "
75% | \n", "49.000000 | \n", "
max | \n", "74.000000 | \n", "
\n", " | Assesment Name | \n", "URL | \n", "Remote Testing Support | \n", "Adaptive/IRT | \n", "Duration | \n", "Job Type | \n", "Test Type | \n", "Description | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "Account Manager Solution | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "yes | \n", "49 | \n", "Middle | \n", "CPAB | \n", "The Account Manager solution is an assessment ... | \n", "
1 | \n", "Administrative Professional-Short Form | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "yes | \n", "36 | \n", "Entry -level | \n", "AKP | \n", "The Administrative Professional solution is fo... | \n", "
2 | \n", "Agency Manager Solution | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "yes | \n", "51 | \n", "Manager | \n", "ABPS | \n", "The Agency Manager solution is for mid-level s... | \n", "
3 | \n", "Apprentice + 8.0 Job Focused Assessment | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "no | \n", "30 | \n", "Entry -level | \n", "BP | \n", "The Apprentice + 8.0 Job-Focused Assessment is... | \n", "
4 | \n", "Apprentice 8.0 Job Focused Assessment | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "no | \n", "20 | \n", "Entry -level | \n", "BP | \n", "The Apprentice 8.0 Job-Focused Assessment is a... | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
139 | \n", "Workplace Safety - Individual 7.1 (Americas) | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "no | \n", "16 | \n", "Entry-Level | \n", "B | \n", "Our Workplace Safety - Individual 7.1 solution... | \n", "
140 | \n", "Workplace Safety - Team 7.0 Solution | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "no | \n", "20 | \n", "Director | \n", "B | \n", "The Workplace Safety – Team 7.0 solution is de... | \n", "
141 | \n", "Workplace Safety - Team 7.1 (Americas) | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "no | \n", "20 | \n", "Entry-Level, General Population, Professional ... | \n", "BCP | \n", "The Workplace Safety – Team 7.1 solution is de... | \n", "
142 | \n", "Workplace Safety - Team 7.1 (International) | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "no | \n", "20 | \n", "Entry-Level, General Population, Professional ... | \n", "BCP | \n", "The Workplace Safety – Team 7.1 solution is de... | \n", "
143 | \n", "Workplace Safety Solution | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "yes | \n", "21 | \n", "Entry-Level | \n", "BP | \n", "The Workplace Safety Solution is designed for ... | \n", "
143 rows × 8 columns
\n", "\n", " | Assesment Name | \n", "URL | \n", "Remote Testing Support | \n", "Adaptive/IRT | \n", "Duration | \n", "Job Type | \n", "Test Type | \n", "Description | \n", "desc_len | \n", "Comb_text | \n", "cleaned_text | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Account Manager Solution | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "yes | \n", "49 | \n", "Middle | \n", "CPAB | \n", "The Account Manager solution is an assessment ... | \n", "87 | \n", "Middle The Account Manager solution is an asse... | \n", "Middle Account Manager solution assessment job... | \n", "
1 | \n", "Administrative Professional-Short Form | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "yes | \n", "36 | \n", "Entry -level | \n", "AKP | \n", "The Administrative Professional solution is fo... | \n", "67 | \n", "Entry -level The Administrative Professional s... | \n", "entry -level Administrative Professional solut... | \n", "
2 | \n", "Agency Manager Solution | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "yes | \n", "51 | \n", "Manager | \n", "ABPS | \n", "The Agency Manager solution is for mid-level s... | \n", "77 | \n", "Manager The Agency Manager solution is for mid... | \n", "Manager Agency Manager solution mid level sale... | \n", "
3 | \n", "Apprentice + 8.0 Job Focused Assessment | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "no | \n", "30 | \n", "Entry -level | \n", "BP | \n", "The Apprentice + 8.0 Job-Focused Assessment is... | \n", "51 | \n", "Entry -level The Apprentice + 8.0 Job-Focused ... | \n", "entry -level Apprentice + Job Focused Assessme... | \n", "
4 | \n", "Apprentice 8.0 Job Focused Assessment | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "no | \n", "20 | \n", "Entry -level | \n", "BP | \n", "The Apprentice 8.0 Job-Focused Assessment is a... | \n", "43 | \n", "Entry -level The Apprentice 8.0 Job-Focused As... | \n", "entry -level Apprentice Job Focused Assessment... | \n", "
\n", " | Assesment Name | \n", "cleaned_text | \n", "Duration | \n", "Remote Testing Support | \n", "URL | \n", "Adaptive/IRT | \n", "Job Type | \n", "
---|---|---|---|---|---|---|---|
64 | \n", "Installation and Repair Technician Solution | \n", "Mid Professional Professional Individual Contr... | \n", "49 | \n", "yes | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "Mid-Professional,Professional Individual Contr... | \n", "
132 | \n", "Technician/Technologist Solution | \n", "Mid Professional Technician technologist solut... | \n", "52 | \n", "yes | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "Mid-Professional | \n", "
107 | \n", "Sales Engineer Solution | \n", "Mid Professional Professional Individual Contr... | \n", "61 | \n", "yes | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "Mid-Professional, Professional Individual Cont... | \n", "
84 | \n", "Network Engineer/Analyst Solution | \n", "Mid Professional Professional Individual Contr... | \n", "41 | \n", "yes | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "Mid-Professional, Professional Individual Cont... | \n", "
60 | \n", "Industrial - Semi-skilled 7.1 (Americas) | \n", "entry -level Industrial semi skilled solution ... | \n", "24 | \n", "yes | \n", "https://www.shl.com/solutions/products/product... | \n", "no | \n", "Entry -level | \n", "
61 | \n", "Industrial - Semi-skilled 7.1 (International) | \n", "entry -level Industrial semi skilled solution ... | \n", "24 | \n", "yes | \n", "https://www.shl.com/solutions/products/product... | \n", "no | \n", "Entry -level | \n", "
83 | \n", "Manufacturing Skilled Maintenance Worker | \n", "entry -level Manufacturing Skilled Maintenance... | \n", "45 | \n", "yes | \n", "https://www.shl.com/solutions/products/product... | \n", "no | \n", "Entry -level | \n", "
114 | \n", "Sales Support Specialist Solution | \n", "entry -level Sales support Specialist solution... | \n", "43 | \n", "yes | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "Entry -level | \n", "
50 | \n", "Healthcare Call Center Agent Solution | \n", "entry -level Healthcare Center Agent solution ... | \n", "44 | \n", "yes | \n", "https://www.shl.com/solutions/products/product... | \n", "yes | \n", "Entry -level | \n", "
56 | \n", "Industrial - Entry Level 7.0 Solution | \n", "entry -level Industrial Entry level solution d... | \n", "20 | \n", "yes | \n", "https://www.shl.com/solutions/products/product... | \n", "no | \n", "Entry -level | \n", "