Data Science Tutorials

This tutorial guides you through DuckDB's key features and practical applications, including building tables, performing data analysis, building an RAG application, and using an SQL query engine with LLM.

Learn the application of the SQL LIMIT clause to filter data. Master the use of the LIMIT clause in PostgreSQL and MySQL databases.

We create data models by formatting data, creating relationships, using Power Query, and leveraging Power Pivot for seamless data integration and analysis.

The SQL BETWEEN operator helps filter values within specific ranges, enabling efficient data analysis. Discover its various applications and full potential.

Explore how the LAG() function allows you to access previous rows in your dataset, enabling time series analysis and comparisons of sequential observations.

The SQL IN operator allows you to filter query results to include only rows that meet specified conditions. Explore its full potential and alternatives.

Learn about memory management in Python with advanced techniques for coding memory-efficient classes. Explore practical exercises for optimal performance.

Explore Cohere Command R+ online and locally, learn about the unique features of the Cohere Python API, and build a multi-step AI agent using LangChain and Cohere.

We set na.rm = TRUE in common R functions to exclude missing (NA) values. This helps us compute accurate statistics and enhances the reliability of our results.

Learn key features and best practices for Azure Monitor to optimize resource usage and costs, ensure compliance, and resolve performance or security issues.

To fix the "'builtin_function_or_method' object is not subscriptable" error, ensure you are calling the function or method with parentheses () instead of square brackets [].

To create a box and whisker plot in Excel, select your data, open the Insert tab, click on Recommended Charts, choose the Box & Whisker chart, and press OK.