Data Science Tutorials

Learn to count unique values in Excel using basic and advanced formulas. See the difference between unique and distinct values.

There are multiple ways to generate random numbers in Excel, such as the `RAND(),` `RANDBETWEEN(),` and `RANDARRAY()` functions.

Learn how to set up a Databricks account, register the DeepSeek R1 model, deploy it to an endpoint, and access it locally for seamless AI integration!

Learn how to use Sora AI to create and edit videos, including using remix, loop, re-cut, style presets, and storyboards.

Learn how to manage Databricks Notebooks. Leverage multi-language support, scheduling, version control, and magic commands to optimize your workflow.

Build a chat app that can understand text, images, audio, and documents, as well as execute Python code. Truly a multimodal application closer to AGI.

Learn about Python generators to optimize memory usage and simplify workflows. Build efficient, real-world data pipelines and enhance your code’s performance.

This practical guide to AWS Lightsail walks you through setting up, managing, and scaling cloud instances, making cloud hosting simple and accessible.

Learn about the policy gradient theorem in RL and how to derive it mathematically. Implement an algorithm based on policy gradients to solve a simple RL environment in Gymnasium.

Learn about Python string interpolation, its purpose, and when to use it. Includes practical examples and best practices.

Python inheritance allows you to build new classes by reusing and extending the functionality of existing ones. Learn how to design parent-child class relationships, implement inheritance patterns, and apply techniques such as method overriding.

Merge two columns in Excel using the ampersand & operator or the CONCAT() function with a custom delimiter. Or use TEXTJOIN(), which lets you ignore blank cells.