Tutorials
Newest first · 121 to 150 of 461
- Machine LearningMutual information vs Cross EntropyUnderstand the key differences between mutual information and cross-entropy. Learn how each measures relationships between probability distributions in ML and information theory.
- Statistics and MathF Statistic Formula – ExplainedThe F statistic is used in statistical hypothesis testing to determine if there are significant differences between group means. It is most commonly used in ANOVA (Analysis of Variance) but also appears in regression analysis.
- Machine LearningBayesian Optimization for Hyperparameter Tuning – Clearly explained.Bayesian Optimization is a method used for optimizing 'expensive-to-evaluate' functions, particularly useful in hyperparameter tuning for machine learning models.
- Statistics and MathDifference between Joint probability and Conditional probabilityJoint probability and conditional probability are two concepts in probability theory that deal with the likelihood of events, but they are used in different contexts and measure different things.
- SQLHow to use the GROUP BY clause on multiple columns in SQL?How to use the GROUP BY clause on multiple columns in SQL?
- SQLHow to sort multiple columns in SQL and in different directions?How to sort multiple columns in SQL and in different directions?
- SQLHow to count the number of work days between two dates?How to count the number of work days between two dates?
- SQLHow to compute maximum of multiple columns, aks row wise max?How to compute maximum of multiple columns, aks row wise max?
- PythonHow to convert Python code to Cython (and speed up 100x)?Using Cython, you can speed up existing Python code by an order of 100x or more. This is possible because Cython converts some of the Python code to C by doing some basic code changes.
- PythonHow to convert Python to Cython inside Jupyter Notebooks?Lets see how to convert Python to Cython inside Jupyter Notebooks?
- Machine LearningKL Divergence – What is it and mathematical details explainedAt its core, KL (Kullback-Leibler) Divergence is a statistical measure that quantifies the dissimilarity between two probability distributions.
- Machine LearningProbe Method – How to select features for ML modelsThe Probe method is a highly intuitive approach to feature selection. The idea is to introduce a random feature to the dataset and train a machine learning model. This random feature is understand to have no useful information to predict the Y. After training the ML model, extract the feature importances.
- SQLWhat is the difference between CROSS JOIN and INNER JOIN in SQL?Let's understand the difference between CROSS JOIN and INNER JOIN with example
- SQLHow to get a list of dates between two dates in SQL?Let's see how to get a list of dates between two dates in SQL using an example. We will explore alternate solutions as well.
- SQLHow to get records from one table that does not exist in another?How to get records from one table that does not exist in another?
- SQLHow to exclude a column using select * except column?How to exclude a column using select * except column in SQL? Let's also see some work arounds.
- SQLHow to access the “previous row” value in a SELECT statement in SQL?Let's see how to access the 'previous row' value in a SELECT statement in SQL?
- Statistics and MathCorrelation – Connecting the Dots, the Role of Correlation in Data AnalysisUnderstand intricacies of correlation with our concise guide. Explore its importance, applications, and visual insights in data analysis.
- SQLWhat is the difference between UNION and UNION ALL in SQL?Let's understand the difference between UNION and UNION ALL with an example
- SQLHow to use GROUP BY to concatenate strings in MySQL and SQL Server?How to use GROUP BY to concatenate strings in MySQL and SQL Server?
- SQLHow to find duplicate values in SQL Table?Let's see how to find duplicate values in an SQL table.
- Statistics and MathHypothesis Testing – A Deep Dive into Hypothesis Testing, The Backbone of Statistical InferenceExplore the intricacies of hypothesis testing, a cornerstone of statistical analysis. Dive into methods, interpretations, and applications for making data-driven decisions.
- SQLHow to return results only if value exists in SQL?You have a table with a column where some rows contain NULL values or empty strings. You want to retrieve rows where this column has a value (i.e., not NULL and not an empty string).
- SQLHow to get top n results in each ‘group by’ group in SQL?Let's see how to get top n results in each 'group by' group in SQL. You have a table with multiple records. For each distinct value in each 'group by' group, get the top 'n' rows based on some criteria
- SQLHow to concatenate multiple rows into one field in MySQL?Let's see how to concatenate multiple rows into one field in MySQL?
- SQLWhat is the difference between INNER JOIN, OUTER JOIN and FULL OUTER JOIN?Understand the difference between INNER JOIN, OUTER JOIN and FULL OUTER JOIN with examples and compare the results.
- Statistics and MathSampling and Sampling Distributions – A Comprehensive Guide on Sampling and Sampling DistributionsExplore the fundamentals of sampling and sampling distributions in statistics. Dive deep into various sampling methods, from simple random to stratified, and uncover the significance of sampling distributions in detail.
- Statistics and MathLaw of Large Numbers – A Deep Dive into the World of StatisticsUnderstanding the Law of Large Numbers: Explore how bigger sample sizes give more accurate results and why it matters in statistics and real life.
- SQLHow to select a random row using SQL?Let's see how to select a random row from large tables efficiently using SQL
- SQLHow to randomly select rows from a large table in MySQL super fast?Let's see how to randomly select rows from a large table quick and efficiently in SQL