![\"Open](\"https://colab.research.google.com/assets/colab-badge.svg\"){kind=icon}
"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "b16dpglpVMZ5",
"outputId": "59985be8-256f-415c-e5af-16c00c9faff5"
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Mounted at /content/drive\n"
]
}
],
"source": [
"from google.colab import drive\n",
"drive.mount('/content/drive')"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "ANExoqDfLJgW",
"outputId": "31390638-de1e-460b-e13b-4bcc070303b7"
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Collecting wordsegment\n",
" Downloading wordsegment-1.3.1-py2.py3-none-any.whl.metadata (7.7 kB)\n",
"Downloading wordsegment-1.3.1-py2.py3-none-any.whl (4.8 MB)\n",
"\u001b[2K \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m4.8/4.8 MB\u001b[0m \u001b[31m28.8 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
"\u001b[?25hInstalling collected packages: wordsegment\n",
"Successfully installed wordsegment-1.3.1\n",
"Collecting num2words\n",
" Downloading num2words-0.5.13-py3-none-any.whl.metadata (12 kB)\n",
"Collecting docopt>=0.6.2 (from num2words)\n",
" Downloading docopt-0.6.2.tar.gz (25 kB)\n",
" Preparing metadata (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
"Downloading num2words-0.5.13-py3-none-any.whl (143 kB)\n",
"\u001b[2K \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m143.3/143.3 kB\u001b[0m \u001b[31m4.5 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
"\u001b[?25hBuilding wheels for collected packages: docopt\n",
" Building wheel for docopt (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
" Created wheel for docopt: filename=docopt-0.6.2-py2.py3-none-any.whl size=13704 sha256=997bcc56f52522df0cb3a62df70b13e1bcedc05a68f95774f1c783ca5b3cd8c5\n",
" Stored in directory: /root/.cache/pip/wheels/fc/ab/d4/5da2067ac95b36618c629a5f93f809425700506f72c9732fac\n",
"Successfully built docopt\n",
"Installing collected packages: docopt, num2words\n",
"Successfully installed docopt-0.6.2 num2words-0.5.13\n",
"Collecting deep-translator\n",
" Downloading deep_translator-1.11.4-py3-none-any.whl.metadata (30 kB)\n",
"Requirement already satisfied: beautifulsoup4<5.0.0,>=4.9.1 in /usr/local/lib/python3.10/dist-packages (from deep-translator) (4.12.3)\n",
"Requirement already satisfied: requests<3.0.0,>=2.23.0 in /usr/local/lib/python3.10/dist-packages (from deep-translator) (2.31.0)\n",
"Requirement already satisfied: soupsieve>1.2 in /usr/local/lib/python3.10/dist-packages (from beautifulsoup4<5.0.0,>=4.9.1->deep-translator) (2.5)\n",
"Requirement already satisfied: charset-normalizer<4,>=2 in /usr/local/lib/python3.10/dist-packages (from requests<3.0.0,>=2.23.0->deep-translator) (3.3.2)\n",
"Requirement already satisfied: idna<4,>=2.5 in /usr/local/lib/python3.10/dist-packages (from requests<3.0.0,>=2.23.0->deep-translator) (3.7)\n",
"Requirement already satisfied: urllib3<3,>=1.21.1 in /usr/local/lib/python3.10/dist-packages (from requests<3.0.0,>=2.23.0->deep-translator) (2.0.7)\n",
"Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.10/dist-packages (from requests<3.0.0,>=2.23.0->deep-translator) (2024.7.4)\n",
"Downloading deep_translator-1.11.4-py3-none-any.whl (42 kB)\n",
"\u001b[2K \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m42.3/42.3 kB\u001b[0m \u001b[31m3.1 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
"\u001b[?25hInstalling collected packages: deep-translator\n",
"Successfully installed deep-translator-1.11.4\n"
]
}
],
"source": [
"!pip install wordsegment\n",
"!pip install num2words\n",
"!pip install deep-translator"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"id": "e6vQjKm2LIfL"
},
"outputs": [],
"source": [
"import pandas as pd\n",
"import numpy as np\n",
"# import re\n",
"# import nltk\n",
"# from nltk.corpus import stopwords\n",
"# from nltk.tokenize import word_tokenize\n",
"# from nltk.stem import WordNetLemmatizer\n",
"# from wordsegment import load, segment\n",
"# from num2words import num2words\n",
"# from deep_translator import GoogleTranslator\n",
"\n",
"# nltk.download('punkt')\n",
"# nltk.download('stopwords')\n",
"# nltk.download('wordnet')"
]
},
{
"cell_type": "markdown",
"metadata": {
"id": "dFObjtjvEqm4"
},
"source": [
"# merge"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 573
},
"id": "1i6rlkRbD7l5",
"outputId": "3c1071fe-5491-4d06-ee42-aba65b12d99e"
},
"outputs": [
{
"data": {
"application/vnd.google.colaboratory.intrinsic+json": {
"summary": "{\n \"name\": \"combined_df\",\n \"rows\": 28274,\n \"fields\": [\n {\n \"column\": \"id\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 9783,\n \"min\": 1001,\n \"max\": 34746,\n \"num_unique_values\": 28274,\n \"samples\": [\n 7329,\n 8181,\n 1346\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"job_title\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 19674,\n \"samples\": [\n \"Cluster Manager Sales Internet Bali\",\n \"Operator Jahit/Sewing\",\n \"Jurnalis Financial\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"location\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 198,\n \"samples\": [\n \"Sukabumi\",\n \"Sulawesi Selatan\",\n \"Jambi\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"salary_currency\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 2,\n \"samples\": [\n \"USD\",\n \"IDR\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"career_level\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 6,\n \"samples\": [\n \"Supervisor/Koordinator\",\n \"Pegawai (non-manajemen & non-supervisor)\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"experience_level\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 20,\n \"samples\": [\n \"3 tahun\",\n \"17 tahun\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"education_level\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 21,\n \"samples\": [\n \"Sertifikat Professional, D3 (Diploma), D4 (Diploma), Sarjana (S1)\",\n \"Sarjana (S1), Diploma Pascasarjana, Gelar Professional\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"employment_type\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 9,\n \"samples\": [\n \"Temporer, Magang\",\n \"Kontrak\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"job_function\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 68,\n \"samples\": [\n \"Penjualan / Pemasaran,Digital Marketing\",\n \"Layanan Kesehatan,Farmasi\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"job_benefits\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 3144,\n \"samples\": [\n \"Tip;Asuransi kesehatan;Parkir;BPJS KESEHATAN DAN BPJS KETENAGAKERJAAN;Formal;Monday - Saturday\",\n \"Asuransi kesehatan;Formil (contoh: Kemeja + Dasi);Senin-Jumat (holding company) - Senin-Sabtu (manufacture & trading)\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"company_process_time\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 30,\n \"samples\": [\n \"10 days\",\n \"4 days\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"company_size\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 7,\n \"samples\": [\n \"1001 - 2000 pekerja\",\n \"51 - 200 pekerja\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"company_industry\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 58,\n \"samples\": [\n \"Manufaktur/Produksi\",\n \"Konstruksi/Bangunan/Teknik\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"job_description\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 28262,\n \"samples\": [\n \"Deskripsi PekerjaanMembuat laporan hutang dagang dan analisa umur hutangMenghitung Pajak\\u00a0Membuat rekonsiliasi pajak, bank dan PPNCek JurnalMenghitung AR dan APMenghitung HPPUpdate dengan perpajakanPersyaratan:Pendidikan minimal D1/S1 AkuntansiMaksimal usia 26 tahunMenguasai dasar-dasar akuntansi/jurnal basic/PSAK,dllMemiliki kemampuan analisa yang baikMempunyai pengalaman di bidang akuntansi minimal 1 tahunTeliti, detail, cekatan, proaktif dan mampu bekerja dibawah tekananMemiliki kemampuan komunikasi yang baik dan dapat bekerja dengan teamBisa membuat Jurnal dan Laporan KeuanganJujur, disiplin dan bertanggung jawabTerbiasa menggunakan MYOB, Accurate dan Zahir menjadi nilai plus\",\n \"Responsibilities:Your duties will include (but will not be limited to):Designing module & syllabus training program appropriate to the skills neededMaintaining training records. Keep and report data on completed courses, issues, etcMaterial Enhancement and Constant Feedback to traineeLearning many new technologies to fulfill different objectivesRequirements:Bachelor Degree in Computer Science, IT, Engineering, Science & Education or related fieldsMinimum 1 year prior experience as a trainer is preferred.Good knowledge on Backend, Frontend, Mobile ProgrammingStrong communication skills, both verbal and written.Strong knowledge on Object-Oriented Programming, Data Structures, DBMS and Algorithms in-depth.Flexible and adaptable in regards to learning and understanding new technologies.Having proficiency on at least one programming language is a plusFluent in English both verbal and written.Excellent creative, analytical and conceptual thinking abilitiesExcellent communication skill, interpersonal skill, proactive, and discipline.Highly self-motivated and directed.A patient and friendly approach to teachingHigh energy, enthusiastic, encouraging training style\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"salary\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 23786415.13407935,\n \"min\": 10.0,\n \"max\": 2000000000.0,\n \"num_unique_values\": 561,\n \"samples\": [\n 3299055.0,\n 7440000.0\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"clean_data\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 28215,\n \"samples\": [\n \"qualification able speak mandarin actively willing teach offline mataram surrounding area fresh graduate welcome apply full time part time position able get attractive salary application sent directly\",\n \"responsibility prepare control import document ensure monitor import shipment schedule process according schedule follow import flow activity port consignee ensure completeness supporting import document correct complete import process good according consignee request understand master creation pib receipt imported good qualification minimum education associate degree bachelor maximum age thirty three year old must worked company forwarding minimum two year import experience proactive agile active english salary negotiable\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n }\n ]\n}",
"type": "dataframe",
"variable_name": "combined_df"
},
"text/html": [
"\n",
" | \n", " | id | \n", "job_title | \n", "location | \n", "salary_currency | \n", "career_level | \n", "experience_level | \n", "education_level | \n", "employment_type | \n", "job_function | \n", "job_benefits | \n", "company_process_time | \n", "company_size | \n", "company_industry | \n", "job_description | \n", "salary | \n", "clean_data | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1001 | \n", "PROCUREMENT & EXIM SUPERVISOR | \n", "Jawa Timur | \n", "IDR | \n", "Supervisor/Koordinator | \n", "3 tahun | \n", "Sertifikat Professional, D3 (Diploma), D4 (Dip... | \n", "Penuh Waktu | \n", "Manufaktur,Pembelian/Manajemen Material | \n", "Tip;Asuransi kesehatan;Parkir;Bisnis (contoh: ... | \n", "26 days | \n", "1001 - 2000 pekerja | \n", "Manufaktur/Produksi | \n", "Procurement & Exim SupervisorREQUIREMENT1. ... | \n", "NaN | \n", "procurement exim supervisor requirement 1 leas... | \n", "
| 1 | \n", "1002 | \n", "Staff Admin | \n", "Palembang | \n", "IDR | \n", "Pegawai (non-manajemen & non-supervisor) | \n", "1 tahun | \n", "SMA, SMU/SMK/STM, Sertifikat Professional, D3 ... | \n", "Penuh Waktu | \n", "Sumber Daya Manusia/Personalia,Staf / Administ... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "Lainnya | \n", "Kualifikasi :Terbuka untuk segala usiaPendidik... | \n", "NaN | \n", "qualification open age minimum education high ... | \n", "
| 2 | \n", "1003 | \n", "Motion Graphic Designer | \n", "Jakarta Selatan | \n", "IDR | \n", "Pegawai (non-manajemen & non-supervisor) | \n", "2 tahun | \n", "Tidak terspesifikasi | \n", "Penuh Waktu | \n", "Seni/Media/Komunikasi,Seni / Desain Kreatif | \n", "Tip;Asuransi kesehatan;Waktu regular, Senin - ... | \n", "26 days | \n", "51 - 200 pekerja | \n", "Transportasi/Logistik | \n", "RequirementsBachelor's Degree or equivalent in... | \n", "NaN | \n", "requirement bachelor degree equivalent design ... | \n", "
| 3 | \n", "1004 | \n", "Asisten Associate Manager | \n", "Jakarta Raya | \n", "IDR | \n", "Manajer/Asisten Manajer | \n", "3 tahun | \n", "Tidak terspesifikasi | \n", "Penuh Waktu | \n", "Penjualan / Pemasaran,Pemasaran/Pengembangan B... | \n", "NaN | \n", "24 days | \n", "1- 50 pekerja | \n", "Akunting / Audit / Layanan Pajak | \n", "Apakah Anda mendambakan kebebasan bekerja. Kel... | \n", "12000000.0 | \n", "crave freedom work get comfort zone faster sig... | \n", "
| 4 | \n", "1005 | \n", "Staff Design Development | \n", "Tangerang | \n", "IDR | \n", "Pegawai (non-manajemen & non-supervisor) | \n", "3 tahun | \n", "Sarjana (S1) | \n", "Penuh Waktu | \n", "Bangunan/Konstruksi,Arsitek/Desain Interior | \n", "Tip;Waktu regular, Senin - Jumat;Formil (conto... | \n", "23 days | \n", "1001 - 2000 pekerja | \n", "Kesehatan/Medis | \n", "Job Responsibilities : Responsible for the pro... | \n", "NaN | \n", "job responsibility responsible process develop... | \n", "
| \n", " | id | \n", "job_title | \n", "location | \n", "salary_currency | \n", "career_level | \n", "experience_level | \n", "education_level | \n", "employment_type | \n", "job_function | \n", "job_benefits | \n", "company_process_time | \n", "company_size | \n", "company_industry | \n", "job_description | \n", "salary | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1 | \n", "Facility Maintenance & Smart Warehouse Manager | \n", "Bandung | \n", "IDR | \n", "Manajer/Asisten Manajer | \n", "5 tahun | \n", "Sertifikat Professional, D3 (Diploma), D4 (Dip... | \n", "Penuh Waktu | \n", "Manufaktur,Pemeliharaan | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "Deskripsi PekerjaanRequirements :D3/SI from re... | \n", "NaN | \n", "
| 1 | \n", "2 | \n", "Procurement Department Head | \n", "Jakarta Raya | \n", "IDR | \n", "Manajer/Asisten Manajer | \n", "5 tahun | \n", "Sarjana (S1), Diploma Pascasarjana, Gelar Prof... | \n", "Penuh Waktu | \n", "Manufaktur,Pembelian/Manajemen Material | \n", "NaN | \n", "25 days | \n", "51 - 200 pekerja | \n", "Manajemen/Konsulting HR | \n", "Job Role: 1. Responsible for material availabi... | \n", "NaN | \n", "
| 2 | \n", "3 | \n", "SALES ADMIN | \n", "Jakarta Barat | \n", "IDR | \n", "Supervisor/Koordinator | \n", "4 tahun | \n", "Sarjana (S1) | \n", "Penuh Waktu | \n", "Penjualan / Pemasaran,Penjualan Ritel | \n", "Waktu regular, Senin - Jumat;Bisnis (contoh: K... | \n", "30 days | \n", "51 - 200 pekerja | \n", "Umum & Grosir | \n", "Internal Sales & AdminJob Description :We are ... | \n", "NaN | \n", "
| 3 | \n", "4 | \n", "City Operation Lead Shopee Express (Cirebon) | \n", "Cirebon | \n", "IDR | \n", "Supervisor/Koordinator | \n", "5 tahun | \n", "Sarjana (S1), Diploma Pascasarjana, Gelar Prof... | \n", "Penuh Waktu | \n", "Pelayanan,Logistik/Rantai Pasokan | \n", "Tip;Waktu regular, Senin - Jumat;Kasual (conto... | \n", "21 days | \n", "2001 - 5000 pekerja | \n", "Retail/Merchandise | \n", "Job Description:Responsible for HSE implementa... | \n", "NaN | \n", "
| 4 | \n", "5 | \n", "Japanese Interpreter | \n", "Bekasi | \n", "IDR | \n", "Pegawai (non-manajemen & non-supervisor) | \n", "2 tahun | \n", "Sertifikat Professional, D3 (Diploma), D4 (Dip... | \n", "Penuh Waktu | \n", "Lainnya,Jurnalis/Editor | \n", "NaN | \n", "23 days | \n", "201 - 500 pekerja | \n", "Manajemen/Konsulting HR | \n", "Overview: Our clients is manufacture for autom... | \n", "NaN | \n", "
| \n", " | ID | \n", "Query | \n", "Job Title | \n", "Description | \n", "
|---|---|---|---|---|
| 0 | \n", "1 | \n", "Data Scientist | \n", "Junior Data Scientist Apprenticeship | \n", "Job Description As a Junior Data Scientist at ... | \n", "
| 1 | \n", "2 | \n", "Data Scientist | \n", "HBO Data Scientist, Content Science | \n", "OVERALL SUMMARY As a Data Scientist on the Dat... | \n", "
| 2 | \n", "3 | \n", "Data Scientist | \n", "Junior Data Scientist | \n", "The Team: The Data science team is a newly for... | \n", "
| 3 | \n", "4 | \n", "Data Scientist | \n", "Jr Data Scientist | \n", "We now have a need for junior Data Scientist(s... | \n", "
| 4 | \n", "5 | \n", "Data Scientist | \n", "Data Scientist, Premium Content | \n", "Do you want to help guide the core business of... | \n", "
| \n", " | ID | \n", "Query | \n", "Job Title | \n", "Description | \n", "clean_data | \n", "
|---|---|---|---|---|---|
| 0 | \n", "1 | \n", "Data Scientist | \n", "Junior Data Scientist Apprenticeship | \n", "Job Description As a Junior Data Scientist at ... | \n", "job description junior data scientist ibm work... | \n", "
| 1 | \n", "2 | \n", "Data Scientist | \n", "HBO Data Scientist, Content Science | \n", "OVERALL SUMMARY As a Data Scientist on the Dat... | \n", "overall summary data scientist data science so... | \n", "
| 2 | \n", "3 | \n", "Data Scientist | \n", "Junior Data Scientist | \n", "The Team: The Data science team is a newly for... | \n", "team data science team newly formed applied re... | \n", "
| 3 | \n", "4 | \n", "Data Scientist | \n", "Jr Data Scientist | \n", "We now have a need for junior Data Scientist(s... | \n", "need junior data scientist ny area remote succ... | \n", "
| 4 | \n", "5 | \n", "Data Scientist | \n", "Data Scientist, Premium Content | \n", "Do you want to help guide the core business of... | \n", "want help guide core business spotify using in... | \n", "
| \n", " | Job ID | \n", "Agency | \n", "Posting Type | \n", "# Of Positions | \n", "Business Title | \n", "Civil Service Title | \n", "Title Code No | \n", "Level | \n", "Job Category | \n", "Full-Time/Part-Time indicator | \n", "... | \n", "Additional Information | \n", "To Apply | \n", "Hours/Shift | \n", "Work Location 1 | \n", "Recruitment Contact | \n", "Residency Requirement | \n", "Posting Date | \n", "Post Until | \n", "Posting Updated | \n", "Process Date | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "87990 | \n", "DEPARTMENT OF BUSINESS SERV. | \n", "Internal | \n", "1 | \n", "Account Manager | \n", "CONTRACT REVIEWER (OFFICE OF L | \n", "40563 | \n", "1 | \n", "\n", " | \n", " | ... | \n", "Salary range for this position is: $42,405 - $45,000 per year | \n", "\n", " | \n", " | \n", " | NaN | \n", "New York City residency is generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview. | \n", "2011-06-24T00:00:00 | \n", "NaN | \n", "2011-06-24T00:00:00 | \n", "2018-07-17T00:00:00 | \n", "
| 1 | \n", "97899 | \n", "DEPARTMENT OF BUSINESS SERV. | \n", "Internal | \n", "1 | \n", "EXECUTIVE DIRECTOR, BUSINESS DEVELOPMENT | \n", "ADMINISTRATIVE BUSINESS PROMOT | \n", "10009 | \n", "M3 | \n", "\n", " | F | \n", "... | \n", "\n", " | In addition to applying through this website, also email your resume and cover letter including the following subject line: Executive Director – Business Development to: careers@sbs.nyc.gov Salary range for this position is: $85,000 - $87,000 per year NOTE: Only those candidates under consideration will be contacted. | \n", "\n", " | \n", " | NaN | \n", "New York City residency is generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview. | \n", "2012-01-26T00:00:00 | \n", "NaN | \n", "2012-01-26T00:00:00 | \n", "2018-07-17T00:00:00 | \n", "
| 2 | \n", "102221 | \n", "DEPT OF ENVIRONMENT PROTECTION | \n", "External | \n", "1 | \n", "Project Specialist | \n", "ENVIRONMENTAL ENGINEERING INTE | \n", "20616 | \n", "0 | \n", "\n", " | F | \n", "... | \n", "Appointments are subject to OMB approval | \n", "click the apply now button | \n", "35 hours per week/day | \n", "\n", " | NaN | \n", "New York City Residency is not required for this position | \n", "2012-06-21T00:00:00 | \n", "NaN | \n", "2012-09-07T00:00:00 | \n", "2018-07-17T00:00:00 | \n", "
| 3 | \n", "102221 | \n", "DEPT OF ENVIRONMENT PROTECTION | \n", "Internal | \n", "1 | \n", "Project Specialist | \n", "ENVIRONMENTAL ENGINEERING INTE | \n", "20616 | \n", "0 | \n", "\n", " | F | \n", "... | \n", "Appointments are subject to OMB approval | \n", "click the apply now button | \n", "35 hours per week/day | \n", "\n", " | NaN | \n", "New York City Residency is not required for this position | \n", "2012-06-21T00:00:00 | \n", "NaN | \n", "2012-09-07T00:00:00 | \n", "2018-07-17T00:00:00 | \n", "
| 4 | \n", "114352 | \n", "DEPT OF ENVIRONMENT PROTECTION | \n", "Internal | \n", "5 | \n", "Deputy Plant Chief | \n", "SENIOR STATIONARY ENGINEER (EL | \n", "91639 | \n", "0 | \n", "\n", " | F | \n", "... | \n", "Appointments are subject to OMB approval For additional information about DEP, visit www.nyc.gov/dep | \n", "Click \"Apply Now\" button | \n", "40 per week / day | \n", "Various | \n", "NaN | \n", "New York City residency is generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview. | \n", "2012-12-12T00:00:00 | \n", "NaN | \n", "2012-12-13T00:00:00 | \n", "2018-07-17T00:00:00 | \n", "
5 rows × 28 columns
\n", "| \n", " | ID | \n", "Query | \n", "Job Title | \n", "Description | \n", "clean_data | \n", "data | \n", "
|---|---|---|---|---|---|---|
| 0 | \n", "1 | \n", "Data Scientist | \n", "Junior Data Scientist Apprenticeship | \n", "Job Description As a Junior Data Scientist at ... | \n", "job description junior data scientist ibm work... | \n", "Data Scientist job description junior data sci... | \n", "
| 1 | \n", "2 | \n", "Data Scientist | \n", "HBO Data Scientist, Content Science | \n", "OVERALL SUMMARY As a Data Scientist on the Dat... | \n", "overall summary data scientist data science so... | \n", "Data Scientist overall summary data scientist ... | \n", "
| 2 | \n", "3 | \n", "Data Scientist | \n", "Junior Data Scientist | \n", "The Team: The Data science team is a newly for... | \n", "team data science team newly formed applied re... | \n", "Data Scientist team data science team newly fo... | \n", "
| 3 | \n", "4 | \n", "Data Scientist | \n", "Jr Data Scientist | \n", "We now have a need for junior Data Scientist(s... | \n", "need junior data scientist ny area remote succ... | \n", "Data Scientist need junior data scientist ny a... | \n", "
| 4 | \n", "5 | \n", "Data Scientist | \n", "Data Scientist, Premium Content | \n", "Do you want to help guide the core business of... | \n", "want help guide core business spotify using in... | \n", "Data Scientist want help guide core business s... | \n", "