Count the Number of Rows with a Condition
Suppose you are working with a pandas DataFrame in Python. You are doing some EDA (exploratory data analysis) […]
count
EDA Structuring with Pandas
Exploratory Data Analysis (EDA) has six main practices. The six main practices of EDA are discovering, structuring, cleaning, […]
The count Function in R
In R, count() lets you quickly count the unique values of one or more variables: df %>% count(a, […]
SQL Server COUNT DISTINCT
You can count the number of unique values in a column with COUNT DISTINCT. The Microsoft Press book […]
Excel COUNTIF Function
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for […]
Excel Totals in Tables
When you are working with a table in Excel you can have the aggregations calculate automatically. How can […]
T-SQL Count Character Occurrences
Do you have a table in SQL Server that has a column with a string that has several […]
SQL Count NULLs
How many NULLs are there in a column? What would the SQL query be? For small tables you […]
SQL Server Count Duplicates
You may have a need to count the number of duplicates in a column. Perhaps you want to […]
SQL Server COUNT
In T-SQL, COUNT returns the number of items in a group. COUNT works like the COUNT_BIG function. The […]
SQL Server Finding String Length
Suppose you have a table with a column that needs some data validation performed on it. The data […]
SQL Server Duplicates Part 1
When working with databases you will often need to check if there are any duplicates in your tables. […]