Summarize a directory with PowerShell

Question

I'm trying to output aggregate information about a directory tree (file extension plus accumulative count and size per file type) with PowerShell.

This is as far as I've got.

gci -r -ea Si `
| group { if ($_.PSIsContainer) {""} else {$_.Extension} } `
| select Name, Count, @{n="Measure"; e={$_.Group | measure Length -Sum -Average} }`
| sort Count -desc `
| ft Name, Count, @{n="SizeMB"; e={"{0:N1}" -f ($_.Measure.Sum / 1MB)}; a="right"} -Auto

which gives me

Name  Count SizeMB
----  ----- ------
.jar   2489  262,2
       1592    1,2
.vim   1147    7,1
.xml   1087    9,6
.dll    803  657,3
.png    762    9,1
.js     380    1,9
.txt    360   14,1
.py     305    1,4
.gyp    266    0,3
.exe    262  198,3
.mui    178   47,1
.c      157    0,1
.md     137    0,3
.html   132    1,1
.tmpl   113    0,1
[...]

Not too bad for my first stab at PowerShell, but it feels unwieldy and I'm wondering if this could be made more elegant.

Answer 1

You are running your select twice and saving an unused Average from your Select-Object

gci -r -ea Si `
| group { if ($_.PSIsContainer) {""} else {$_.Extension} } `
| sort Count -desc `
| ft Name, Count, @{n="SizeMB"; e={"{0:N1}" -f (($_.Group | measure Length -Sum).Sum / 1MB)};a="right"} -Auto

You have to move the Group Measurement to the FT line from the Select.

If you want this a little more readable, you can pull the formatting HashTable out of the pipeline:

$sizeMB = @{n="SizeMB"; 
            e={"{0:N1}" -f (($_.Group | measure Length -Sum).Sum / 1MB)};
            a="right"}

gci -r -ea Si `
| group { if ($_.PSIsContainer) {""} else {$_.Extension} } `
| sort Count -desc `
| ft Name, Count, $sizeMB  -Auto