Blog

Inner Join

An inner join keeps only rows from two tables that have matches. This Venn diagram illustrates which rows are included in an inner join.
Matt Pickard

Left Join

A left join keeps all the rows from the left table and inserts NULLs on the right when there is not a matching row found in the right table.
Matt Pickard

Outer Join

A outer join keeps all the rows from both the right and left tables and inserts NULLs when a matching row is not found in the other table.
Matt Pickard

Right Join

A right join keeps all the rows from the right table and inserts NULLs on the left when there is not a matching row found in the left table.
Matt Pickard

Excel Conditional Aggregation Functions (COUNTIFS, SUMIFS, AVERAGEIFS)

excel
aggregation
conditional aggregation
summarization

Data aggregation involves combing multiple data points into a single number. This post shows how to use Excel to aggregate rows of data that meet certain conditions.
Feb 21, 2023
Matt Pickard

seededlda Topic Model - Finding the best fit

topic modeling
nlp
multithread
Semi-annually, members of The Church of Jesus Christ of Latter-day Saints gather across the world for General Conference (GC) to hear messages and talks about the gospel of Jesus Christ. These messages are delivered by prophets, apostles, and other leaders in the Church. GC occurs the first…
Jan 24, 2023
Matt Pickard

Simple Feature Selection Using a Low-to-No Variance Mask

Demonstrates how to remove features with low to no variance.
Jan 5, 2023
Matt Pickard

regex to Preserve Currency Tokens

regex
data preparation
python
r

Development of a regex to preserve currency values in the U.S. Tax Code.
Mar 14, 2022
Matt Pickard
No matching items