Data Science Tutorials

Count in Python fast, validate data, and avoid common mistakes with Counter, count(), and pandas

Learn the mathematical foundations of z-scores, explore practical calculation methods, and discover applications across statistics and data science.

Learn how to calculate and interpret the likelihood of multiple events occurring simultaneously. Discover practical applications in predictive modeling, risk assessment, and machine learning that solve complex data science challenges.

A practical guide to GPT-5 function calling: from JSON-schema functions to free-form tools, Lark/CFG constraints, preambles, and tool allowlists.

Learn how denormalization boosts read performance by reducing joins and simplifying queries. Understand the trade-offs, techniques, and use cases that make it a powerful tool for analytics and reporting systems.

Discover how to unlock Excel's Developer tab, explore its core components, and apply macros, controls, and XML tools to automate workflows and enhance productivity.

Learn about DeepSeek-V3.2-Exp, its new sparse attention mechanism, how it reduces API costs and improves long-context handling, and how to use it in your own projects.

Learn what the Git rest HEAD command is, how it works, and its related safety and recovery considerations.

Set up Ollama in Docker to run local LLMs like Llama and Mistral. Keep your data private, eliminate API costs, and build AI apps that work offline.

Learn functional decomposition techniques to build scalable, maintainable software systems. Discover step-by-step methods, real-world examples, and best practices for system design.

Learn how to move a column in Excel using drag-and-drop, cut-and-insert, and shortcuts. Discover tips to improve efficiency across all versions of Excel.

Learn how Anthropic's Imagine with Claude introduces a new paradigm for AI-assisted software development, generating functionality on the fly.