Data Science Tutorials

This tutorial discusses the purpose and syntax of the XLOOKUP Excel function, its advantages concerning its predecessors, the two main ways of using XLOOKUP with multiple criteria including their pros and cons, extending functionality through the optional parameters, and the way of running a similar search in older Excel versions.

How to sort a data frame in R.

Unlock the power of Large Language Models (LLMs) in your applications with our latest blog on "Serving LLM Application as an API Endpoint Using FastAPI in Python." LLMs like GPT, Claude, and LLaMA are revolutionizing chatbots, content creation, and many more use-cases. Discover how APIs act as crucial bridges, enabling seamless integration of sophisticated language understanding and generation features into your projects.

Learn how to use the RELATED DAX function in Power BI to simplify data modeling and build insightful reports.

Learn how to combining multiple plots in R into one graph with either the par() or layout() functions. This page includes coding examples.

Learn how to use arithmetic and logical operators in R. These binary operators work on vectors, matrices, and scalars.

Learn the advanced aspects of resource management in Python by mastering how to write custom context managers.

Learn how to create a scatterplot in R. The basic function is plot(x, y), where x and y are numeric vectors denoting the (x,y) points to plot.

Improve your graphs in R with titles, text annotations, labelling of points, minor tick marks, reference lines, custom axes, and a chart legend.

Explore different approaches to enhance RAG systems: Chunking, Reranking, and Query Transformations.

Learn three methods to transpose a matrix in R in this quick tutorial

Enhance your data analysis skills and learn how to build and customize a waterfall chart in Tableau