Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
Utilizing DENSE_RANK for Data Deduplication in SQL
Data deduplication in SQL can be done in several ways. Using DENSE_RANK() is one. Today, we’ll talk about using this function to improve your data’s quality.
Nathan Rosidi -
How to Determine Python String Length?
Discover the simple yet powerful tools Python offers to measure string length effortlessly, enhancing your coding efficiency and data manipulation skills.Nathan Rosidi -
From Arrays to Lists: Converting Numpy Arrays with Python
Learn the essential methods for converting NumPy arrays to Python lists, enhancing your data handling skills in Python with practical examples and applications.Nathan Rosidi -
Tips for Crafting an Impressive Data Analyst Portfolio
Having a project portfolio is an industry standard for data analysts. Making it impressive is not easy, but we’ll provide plenty of tips to make it easier.Nathan Rosidi -
PySpark GroupBy Guide: Super Simple Way to Group Data
Master efficient data grouping techniques with PySpark GroupBy for optimized data analysis.Nathan Rosidi -
Tools for the Full-Stack Data Scientist
What tools does a full-stack data scientist need? In the article, we answer this question by discussing six types of tools you should have in your toolkit.Nathan Rosidi -
Adding and Removing List Elements with Python
Explore the versatile techniques of adding and removing elements in Python lists to enhance data manipulation and streamline your coding workflow.Nathan Rosidi -
SQL PARTITION BY: Advanced Analytical Insights
SQL PARTITION BY makes SQL window functions – already a powerful analytical tool – even more suitable for advanced analytical insights from your data.Nathan Rosidi -
What Are the Steps to Cast INT in SQL for Type Conversion?
Cast INT in SQL is a must-know for anyone even remotely interested in data handling and analysis. This article will cover all the important cast INT topics.Nathan Rosidi -
How to Perform Python String Concatenation?
Learn essential Python string concatenation techniques, including the + operator, join() method, f-strings, and format() method.Nathan Rosidi -
Tools for the Data Scientists Working at Scale
Do data scientists need big data knowledge? Yes, they do! In this article, we’ll cover several big data tools that will help you when working at scale.Nathan Rosidi -
Business Analytics vs Business Intelligence
Business intelligence and business analytics; so similar yet so different. Here’s an article about their differences and how they complement each other.Nathan Rosidi -