Data Profession Salary Trends (2009-2016)

Analyzing Salary Trends and Factors Affecting Data Professionals

@kaggle.namangarg2075_data_profession_salary_trends_2009_2016

Table List

2 tables(164.94 KB)

Cleaned Data

@kaggle.namangarg2075_data_profession_salary_trends_2009_2016.cleaned_data

86.81 KB
2477 rows
17 columns

first_name FIRST NAME	last_name LAST NAME	sex SEX	doj DOJ	current_date CURRENT DATE	designation DESIGNATION	age AGE	unit UNIT	leaves_used LEAVES USED	leaves_remaining LEAVES REMAINING	ratings RATINGS	past_exp PAST EXP	salary SALARY	day DAY	day_name DAY NAME	month MONTH	year YEAR
TOMASA	ARMEN	F	Sun May 18 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Analyst	21	Finance	24	6	2		44570	18	Sunday	5	2014
OLIVE	ANCY	F	Mon Jul 28 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Analyst	21	Finance	23	7	3		40955	28	Monday	7	2014
CHERRY	AQUILAR	F	Wed Apr 03 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Analyst	22	IT	22	8	3		45550	3	Wednesday	4	2013
LEON	ABOULAHOUD	M	Thu Nov 20 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Analyst	24	Operations	27	3		3	43161	20	Thursday	11	2014
VICTORIA	-	F	Tue Feb 19 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Analyst	22	Marketing	20	10	4		48736	19	Tuesday	2	2013
ELLIOT	AGULAR	M	Mon Sep 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Analyst	22	Marketing	19	11	5		40339	2	Monday	9	2013
JACQUES	AKMAL	M	Thu Dec 05 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Analyst	24	Marketing	29	1	2	2	40058	5	Thursday	12	2013
KATHY	ALSOP	F	Sun Jun 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Senior Analyst	28	Operations	20	10	3	1	63478	29	Sunday	6	2014
LILIAN	APELA	F	Tue Nov 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Analyst	22	Finance	15	15	3		43110	11	Tuesday	11	2014
BELLE	ARDS	F	Mon Mar 10 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Analyst	24	Marketing	22	8	4	1	41590	10	Monday	3	2014


CREATE TABLE cleaned_data (
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "sex" VARCHAR,
  "doj" TIMESTAMP,
  "current_date" TIMESTAMP,
  "designation" VARCHAR,
  "age" DOUBLE,
  "unit" VARCHAR,
  "leaves_used" BIGINT,
  "leaves_remaining" BIGINT,
  "ratings" DOUBLE,
  "past_exp" BIGINT,
  "salary" BIGINT,
  "day" BIGINT,
  "day_name" VARCHAR,
  "month" BIGINT,
  "year" BIGINT
);