Dataset: LinkedIn Data Analyst Jobs Listings

About this Dataset

LinkedIn Data Analyst Jobs Listings

This project was born out of curiosity. Being new to data analysis, I was perplexed about received opinions propagated by senior data analysts. I thought, why not check all this out?
The steps are simple: collect, clean and analyze data.

Data

We chose LinkedIn as the jobs listing platform to scrape. To do so, we wrote a python script to go through LinkedIn and collected all the necessary data. After a poll, 3 locations were chosen: Africa, Canada, and the USA. You can find the whole project here

Features

title: Job title
company: Name of the company
description: description of the job and company
onsite_remote:
Location where the employee will be working from
salary: Salary for the job. May be yearly or hourly. In most cases, it is a range from min to max
location: Where the company with the opening role is located
criteria: Job requirements like experience, employment type, etc
posted_date: The date the job was posted
link: The URL to the job

Tables

Linkedin Jobs Africa

@kaggle.cedricaubin_linkedin_data_analyst_jobs_listings.linkedin_jobs_africa

340.12 KB
2872 rows
9 columns


CREATE TABLE linkedin_jobs_africa (
  "title" VARCHAR,
  "company" VARCHAR,
  "description" VARCHAR,
  "onsite_remote" VARCHAR,
  "salary" VARCHAR,
  "location" VARCHAR,
  "criteria" VARCHAR,
  "posted_date" TIMESTAMP,
  "link" VARCHAR
);

Linkedin Jobs Canada

@kaggle.cedricaubin_linkedin_data_analyst_jobs_listings.linkedin_jobs_canada

490.17 KB
2773 rows
9 columns


CREATE TABLE linkedin_jobs_canada (
  "title" VARCHAR,
  "company" VARCHAR,
  "description" VARCHAR,
  "onsite_remote" VARCHAR,
  "salary" VARCHAR,
  "location" VARCHAR,
  "criteria" VARCHAR,
  "posted_date" TIMESTAMP,
  "link" VARCHAR
);

Linkedin Jobs Usa

@kaggle.cedricaubin_linkedin_data_analyst_jobs_listings.linkedin_jobs_usa

462.62 KB
2845 rows
9 columns


CREATE TABLE linkedin_jobs_usa (
  "title" VARCHAR,
  "company" VARCHAR,
  "description" VARCHAR,
  "onsite_remote" VARCHAR,
  "salary" VARCHAR,
  "location" VARCHAR,
  "criteria" VARCHAR,
  "posted_date" TIMESTAMP,
  "link" VARCHAR
);