Introduction to Data Aggregation Methods in PHP

Welcome to today's lesson! Our topic for the day is data aggregation, a crucial aspect of data analysis. Like summarizing a massive book into key points, data aggregation summarizes large amounts of data into important highlights.

By the end of today, you'll be equipped with several aggregation methods to summarize data streams in PHP. Let's get started!

Let's say we have an array of integers denoting the ages of a group of people. We will demonstrate several basic aggregation methods using PHP's built-in functions:

<?php

$ages = [21, 23, 20, 25, 22, 27, 24, 22, 25, 22, 23, 22];

// Number of people
$num_people = count($ages);
echo "Number of people: $num_people\n";

// Total age
$total_ages = array_sum($ages);
echo "Total age: $total_ages\n";

// Youngest age
$youngest_age = min($ages);
echo "Youngest age: $youngest_age\n";

// Oldest age
$oldest_age = max($ages);
echo "Oldest age: $oldest_age\n";

// Average age
$average_age = $total_ages / $num_people;
echo "Average age: $average_age\n";

// Age range
$age_range = $oldest_age - $youngest_age;
echo "Age range: $age_range\n";

?>

Here's a brief overview of the above code snippet:

1. Number of people: Uses count() to get the number of elements in the array.
2. Total age: Uses array_sum() to sum all elements in the array.
3. Youngest age: Uses min() to find the smallest element.
4. Oldest age: Uses max() to find the largest element.
5. Average age: Calculates the average age by dividing the total age by the number of people.
6. Age range: Computes the range of ages by subtracting the youngest age from the oldest age.

These functions provide essential aggregation operations and are widely used with data streams.

For deeper analysis, such as calculating the mode, or most frequent age, we can use PHP's foreach loops.

For example, using foreach loops, we can find the mode or most frequent age:

<?php

$ages = [21, 23, 20, 25, 22, 27, 24, 22, 25, 22, 23, 22];

// Initialize an associative array to store the frequency of each age
$frequencies = [];

// Use a foreach loop to populate frequencies
foreach ($ages as $age) {
    if (!isset($frequencies[$age])) {
        $frequencies[$age] = 0;
    }
    $frequencies[$age]++;
}

// Find the age with max frequency
$max_freq = 0;
$mode_age = -1;
foreach ($frequencies as $age => $freq) {
    if ($freq > $max_freq) {
        $max_freq = $freq;
        $mode_age = $age;
    }
}
echo "Max frequency: $max_freq\n"; // Max frequency: 4
echo "Mode age: $mode_age\n"; // Mode age: 22

?>