LinkedIn Data Analyst Jobs Listings
More than 8400 rows of data analyst jobs from USA, Canada and Africa
@kaggle.cedricaubin_linkedin_data_analyst_jobs_listings
More than 8400 rows of data analyst jobs from USA, Canada and Africa
@kaggle.cedricaubin_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.
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
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
);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
);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
);Anyone who has the link will be able to view this.