Category
Data Manipulation
7-Day Challenge
Land Your First Data Science Job
A proven roadmap to prepare for $75K+ entry-level data roles. Perfect for Data Scientist ready to level up their career.
Build portfolios that hiring managers love
Master the Python and SQL essentials to be industry-ready
Practice with real interview questions from tech companies
Access to the $100k/y Data Scientist Cheatsheet
Databases
2 min readHow to Read a Folder of CSVs in Python Using DuckDB
Explore the power of DuckDB, an efficient open-source analytical database system for processing large datasets. This post delves into reading a folder of CSVs using DuckDB in Python, demonstrating its advantages over traditional methods like Pandas.
5/30/2023Read More
Getting Started
3 min readHow long does it take to learn Python for Data Science in 2023
Learn how long it takes to learn Python for Data Science in 2021.
What does it take to be a Data Scientist in 2021?
4/18/2023Read More
DataFrame
1 min readHow to merge two time-series DataFrames with different time intervals
Learn how to merge time-series DataFrames with different frequencies in Pandas using the resample and merge/concat methods.
4/8/2023Read More
Requests
1 min readHow to use requests in Python
Use 'requests' library in python to send HTTP requests and receive response, also pass headers, cookies, json payload in the request
3/5/2023Read More
Advanced
1 min readHow to compute Bitcoin volatility in Python
The yield keyword in Python allows functions to produce a series of values over time, making it efficient for handling large data sets or for producing a series of values for iteration.
2/21/2023Read More
Fundamentals
5 min readHow to do statistics on a DataFrame
Learn how to perform various statistics on a Pandas DataFrame such as mean, median, mode, standard deviation, variance, minimum and maximum, sum, count and more using built-in methods like .mean(), .median(), .std(), .min(), .max(), .sum(), .count(), .describe() etc.
2/17/2023Read More
Getting Started
1 min readHow to slice a Pandas DataFrame
Learn various ways to slice a Pandas DataFrame, including using the .loc[], .iloc[], and [] accessors, boolean indexing and chaining multiple conditions to select specific rows and columns.
2/16/2023Read More
Fundamentals
1 min read6 ways to efficiently store data in Python
Learn various ways to store data efficiently in Python, including relational databases, NoSQL databases, data serialization, data compression, and data containers like NumPy array and Pandas DataFrame.
2/13/2023Read More
Fundamentals
2 min readHow to read an excel, csv, json file in Python
Learn how to easily read and manipulate data from excel, csv and json formats in Python using popular libraries such as pandas, openpyxl, and json
2/12/2023Read More
Free Newsletter
Master Data Science in Days, Not Months 🚀
Skip the theoretical rabbit holes. Get practical data science skills delivered in bite-sized lessons – Approach used by real data scientist. Not bookworms. 📚
Weekly simple and practical lessons
Access to ready to use code examples
Skip the math, focus on results
Learn while drinking your coffee