How Can LINQ Efficiently Pivot Data from a Wide to a Tall Format for Grid Display?

Pivot Data with LINQ

In data science, pivoting transforms data from a wide format to a tall format or vice versa. Suppose you have a dataset with items containing an Enum and a User object and need to flatten it for a grid display. A straightforward method involves nested foreach loops, but this approach can introduce errors due to changing collection size.

The LINQ Pivot Approach

LINQ provides a cleaner and more efficient way to pivot data:

1. Group and Select: Group the data by the Enum value and select the user names for each group.

var grps = from d in data
           group d by d.Foo
           into grp
           select new
           {
               Foo = grp.Key,
               Bars = grp.Select(d2 => d2.Bar).ToArray()
           };

2. Determine Row Count: Calculate the maximum number of rows based on the length of each group's Bars array.

int rows = grps.Max(grp => grp.Bars.Length);

3. Output Column Headers: Print the Enum values as column headers.

foreach (var grp in grps) {
    Console.Write(grp.Foo + "\t");
}

4. Output Data: Iterate through the rows and print the corresponding user names or null for missing values.

for (int i = 0; i < rows; i++) {
    foreach (var grp in grps) {
        Console.Write((i < grp.Bars.Length ? grp.Bars[i] : null) + "\t");
    }
    Console.WriteLine();
}

This code elegantly performs the data pivoting, providing a clean and efficient solution for flattening complex datasets into a grid format.

The above is the detailed content of How Can LINQ Efficiently Pivot Data from a Wide to a Tall Format for Grid Display?. For more information, please follow other related articles on the PHP Chinese website!