avsngh-git Goto Github PK

• 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)

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

• 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