Skip to content
View avsngh-git's full-sized avatar
🤪
Learning and Practicing
🤪
Learning and Practicing
0 followers · 9 following
Block or Report

Block or report avsngh-git

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
avsngh-git/README.md

I have completed:

  • Courses: Python Programming, Statistics, Data Analysis & Visualization, Machine Learning, SQL & Analytics

  • Highlights: 600+ hours of coursework, 10 coding assignments, 3 projects in Jovian.ai Data Science Bootcamp (Web scraping, EDA, Tableau)

Skills:

SQL & MySql, Python, Microsoft Excel, Tableau, Data Analysis & Visualization, Machine Learning, Numpy, Pandas, Web Scraping, AWS, Probabilistic Modelling

My Projects:

  • Time-Series forecasting of Favourita Stores sales. (View)

    • Cleaned and Analysed 3,000,000 rows of data
    • Trained models such as Linear Regression and LightGBM using Darts Library
    • Used the strategy of training 33 LightGBM models each of which specialized in making predictions for a single product family.
    • This novel strategy got a score of 0.38202 and got placed in top 4 percent for this Kaggle competition.

  • Web scraping and Crawling using Scrapy (View)

    • Scraped research papers from a journal on the 'Springer' website
    • Used tools like CSS Selectors, Item, Objects, Item Pipelines to Scrape, Process and Load data.
    • Stored the results into a CSV file and a MySQL database table having 6 columns and 218 rows of data.

  • Exploratory Data Analysis of Los Angeles's Crime Data from 2019 to Present (View)

    • Analyzed data for 1 million crimes containing 26 columns Using Pandas
    • Created interactive visualizations (Scatter plots, Sunburst, Maps, Bar & Line Charts etc.) using Plotly
    • Discovered trends such as high crime rate against Hispanic, White and Black ethnicities, Discovered Crime hotspots by merging the crime data to GeoJSON data, Discovered types of crimes against Juveniles.

  • Bookshop Data Analysis with Excel & Tableau (View)

    • Used the bookshop sample database containing around 55 thousand rows of sales data of various books in 4 Quarters
    • Created new sheets to summarize data e.g. Average Ratings of each book, Monthly sales of each book.
    • Created a Tableau Public Dashboard with 4 different visualizations e.g. Scatter Plot, Bar charts and Line chart.

  • I’m currently learning - Machine Leaning, Probability Theory

  • 📫 How to reach me: [email protected] or drop a message on LinkedIn

  • Resume : Link

Pinned Loading

  1. Favorita-store-sales-prediction Favorita-store-sales-prediction Public

    Time-Series forecasting sales for Favourita stores from Ecuador using LightGBM Machine Learning Model.

    Jupyter Notebook

  2. Exploratory-Data-Analysis-Crime-Data Exploratory-Data-Analysis-Crime-Data Public

    An EDA project for Jovian Data Science Bootcamp

    Jupyter Notebook

  3. springer_scraping springer_scraping Public

    Python