-
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: avinjsingh@gmail.com or drop a message on LinkedIn
-
Resume : Link