Corellation in Python
In this project, Using Python, I analyzed a movie dataset to establish the relationship between the attributes of the dataset.
Corellation in Python
Covid 19 Data Exploration Using SQL
In this project, I am exploring Covid-19 Dataset from https://ourworldindata.org/covid-deaths to get the following information:
- Total Cases vs Total Deaths (Likelihood of dying if you contract covid in your country)
- Total Cases vs Population (What percentage of population infected with Covid)
- Countries with Highest Infection Rate compared to Population
- Countries with Highest Death Count per Population
- Continent with Highest Death Count per Population
- Continent with Highest Death Count per Population
Data Analysis and Visualization of New York Citi Bikers Dataset
In this project, I am analyzing data collected by Citi Bike to answer the following questions:
- What are the most popular pick-up locations across the city for NY Citi Bike rental?
- How does the average trip duration vary across different age groups?
- Which age group rents the most bikes?
- How does bike rental vary across the two user groups (one-time users vs long-term subscribers) on different days of the week?
- Does user age impact the average bike trip duration?
Data Wrangling with Python
Data wrangling is the process of converting data from the initial format to a format that may be better for analysis. In this project, I used an Automobile Dataset, handled the missing values, corrected the data format and performed standardization and normalization of the dataset.
Extracting and Visualizing Stock Data using yfinance and BeautifulSoup
Extracting essential data from a dataset and displaying it is a necessary part of data science; individuals can therefore make correct decisions based on the data. In this project, I will extract some stock data, I will then display this data in a graph.
Extracting Stock Data Using Web Scraping
Not all stock data is available via API in this project; I used web-scraping to obtain financial data. Using beautiful soup, I extracted historical share data from a web-page.
Extracting Stock Data
Using a Python Library
In this project, I extracted stock data using Python library. The yfinance library was used, which allows to extract data for stocks returning data in a pandas dataframe.
Sorting and Analyzing Fleet Inventory Data
In this project, Using Microsoft Excel, I took a dataset of Montgomery Fleet Equipment Inventory, cleaned it, created pivot tables in preparation for the results to be visualized in a dashboard and addeded to a data findings report later.
Extract, Transform,
Load
In this project, I extracted data from two sources (sql database and csv), cleaned the data and then loaded it into an SQL database.
Bike Sales Analysis
In this project, Using Microsoft Excel, I take a dataset of bike buyers, cleaned it, created pivot tables and finally a dashboard.
