Data Science Tutorials

Learn how to set up PostgreSQL on macOS using Homebrew, a convenient package manager. Follow step-by-step instructions to install, configure, and start PostgreSQL services.

Discover how Q-Q plots are a useful visual method to assess normality. Compare observed data to a theoretical distribution like the normal distribution to highlight deviations. Learn to diagnose model fit.

Learn how to use Excel’s built-in features, formulas, and even Power Query to tackle duplicates, along with best practices and troubleshooting tips for handling complex datasets.

Learn how to manage dependencies and virtual environments for complex projects using Python Poetry.

Explore how you can identify duplicate entries in Excel using Conditional Formatting, the COUNTIF() formula, and Power Query. Learn best practices and troubleshoot issues.

Learn how to implement recursive retrieval in RAG systems using LlamaIndex to improve the accuracy and relevance of retrieved information, especially for large document collections.

Learn how to evaluate your LLM on code generation capabilities with the Hugging Face Evaluate library.

This tutorial walks you through Microsoft Fabric, showing you how to set up, connect data, build pipelines, and collaborate—all in one practical guide!

See how to use VLOOKUP() to pull data from another sheet in your Excel workbook. Build confidence with practical examples and troubleshooting techniques.

Enhance your visualizations with Matplotlib colormaps. Learn to pick the right colormap, adjust color classes, and troubleshoot common visualization issues.

A practical guide to leveraging AI in your legal practice while maintaining professional standards and ethical compliance.

Learn what speculative decoding is, how it works, when to use it, and how to implement it using Gemma2 models.