top of page

Analysis of Data Scientist Salaries

Güncelleme tarihi: 18 Şub 2023


Hello, in this blog post, we will try to analyze the data scientist salaries by various factors. We will first upload our data to MySQL, we will do data manipulation there. After that we will upload it into the google data studio for creating an interactive dashboard. Data set link.

Lets start by removing the rows that we are not going to use


ALTER TABLE mytable
DROP COLUMN FIELD1,
DROP COLUMN work_year,
DROP COLUMN salary,
DROP COLUMN salary_currency,
DROP COLUMN employee_residence,
DROP COLUMN company_location;

and renaming the columns that we need to change


ALTER TABLE mytable
RENAME COLUMN salary_in_usd TO salary;

Now we need to change data types in order to make changes in our data set


ALTER TABLE mytable
MODIFY COLUMN experience_level VARCHAR(15),
MODIFY COLUMN employment_type VARCHAR(15),
MODIFY COLUMN company_size VARCHAR(10);

Now we can update the values in our data set. Lets start by updating the experience_level column


UPDATE mytable
SET experience_level = "Junior"
WHERE experience_level = "EN";

UPDATE mytable
SET experience_level = "Mid"
WHERE experience_level = "MI";

UPDATE mytable
SET experience_level = "Senior"
WHERE experience_level = "SE";

UPDATE mytable
SET experience_level = "Expert"
WHERE experience_level = "EX";

Employment type column


UPDATE mytable
SET employment_type = "Part_time"
WHERE employment_type = "PT";

UPDATE mytable
SET employment_type = "Full_time"
WHERE employment_type = "FT";

UPDATE mytable
SET employment_type = "Contract"
WHERE employment_type = "CT";

UPDATE mytable
SET employment_type = "Freelance"
WHERE employment_type = "FL";

Company size column


UPDATE mytable
SET company_size = "Small"
WHERE company_size = "S";

UPDATE mytable
SET company_size = "Medium"
WHERE company_size = "M";

UPDATE mytable
SET company_size = "Large"
WHERE company_size = "L";

and we can view it by SELECT * FROM mytable; and export it in order to uploading our updated data into the google data studio. We can finally create our dashboard. And here is our interactive dashboard :










129 görüntüleme0 yorum

Son Yazılar

Hepsini Gör

Comments


Commenting has been turned off.
bottom of page