Jose_Porfolio

Example data science porfolio

Project 1: Data Science Salary Estimator: Project Overview

• Created a tool that estimates data science salaries (MAE ~ $ 11K) to help data scientists negotiate their income when they get a job.
• Scraped over 1000 job descriptions from glassdoor using python and selenium
• Engineered features from the text of each job description to quantify the value companies put on python, excel, aws, and spark.
• Optimized Linear, Lasso, and Random Forest Regressors using GridsearchCV to reach the best model.
• Built a client facing API using flask

Project 2: Data Cleaning

After scraping the data, I needed to clean it up so that it was usable for our model. I made the following changes and created the following variables:

• Parsed numeric data out of salary
• Made columns for employer provided salary and hourly wages
• Removed rows without salary
• Parsed rating out of company text
• Made a new column for company state
• Added a column for if the job was at the company’s headquarters
• Transformed founded date into age of company
• Made columns for if different skills were listed in the job description:
  • Python
  • R
  • Excel
  • AWS
  • Spark
• Column for simplified job title and Seniority
• Column for description length

EDA

I looked at the distributions of the data and the value counts for the various categorical variables. Below are a few highlights from the pivot tables.

Project 3: for Coursera - Databases_and_SQL_for_Data_Science

Description

This course teaches a lot of things, since how to run basic queries until modeling databases. What was nice about the learnings, is about the exercises using real data!

Topics

-> Statements: CREATE, DELETE, SELECT, INSERT and UPDATE table.

-> COUNT, LIMIT, DISTINCT.

-> String Patterns, Ranges, Sorting, Grouping.

-> Sub-queries and multiple tables(implicit join)

-> Database access from Python.

-> Analyzing data with Python.

-> JOIN(inner, outer).

-> Working with real-word datasets.

-> Relational databases concepts.

-> Relational Model Constraints.

Project 4: Write and Save Files in Python

Writing the text to file in Python Programming Language where you learn know how to write to file and copy the file.

Project 5: Analyzing-US-Economic-Data-and-Building-a-Dashboard Using Python

Extracting essential data from a dataset and displaying it is a necessary part of data science; therefore individuals can make correct decisions based on the data. In this Project I will extract some essential economic indicators from some data, I will then display these economic indicators in a Dashboard.then i will share the dashboard via an URL. Gross domestic product (GDP) is a measure of the market value of all the final goods and services produced in a period. GDP is an indicator of how well the economy is doing. A drop in GDP indicates the economy is producing less; similarly an increase in GDP suggests the economy is performing better. In this lab, I will examine how changes in GDP impact the unemployment rate and then I will take screen shots of Dashboard and every steps,share the notebook and the URL pointing to the dashboard.