Snack Bar is the category pointing to the Recalling Firm which points to the Brand Name
Over on The Crabby Office Lady site is a post on Excel viewer aids peanut butter recall awareness. The FDA published the Peanut Butter Recall information in Excel.
I downloaded it, saved it as a CSV and used the PowerShell code from Social Networks and Pork Barrel Spending? that wrapped the NetMap (now called NodeXL) visualization control from Microsoft Research.
. .\Show-NetMap
$d = Import-Csv .\PeanutButterProducts2009.csv | ? {$_.Category -eq 'Snack Bar'}
$firstSet = $d |
Select @{
Name="Source"
Expression={$_."Category"}
}, @{
Name="Target"
Expression={$_."Recalling Firm"}
}
$secondSet = $d |
Select @{
Name="Source"
Expression={$_."Recalling Firm"}
}, @{
Name="Target"
Expression={$_."Brand Name"}
}
$firstSet+$secondSet | Show-NetMap F
Here is the breakdown of food categories. The above visualization is only the Snack Bars.
Import-Csv .\PeanutButterProducts2009.csv | group -NoElement Category | sort count
Count Name
----- ----
1 Pet Food Peanut Paste
3 Pre-Packaged Meals
3 Peanut Paste
8 Fruit and Vegetable
9 Cake
10 Brownie
19 Pet Food
22 Cracker
31 Ice Cream
34 Peanut Butter
50 Candy
73 Snack Bar
125 Cookie
{ 8 trackbacks }
{ 2 comments… read them below or add one }
this is great! what a great tool.
This is too cool, I used your Show-NetMap function to http://ping.fm/hp9Fn.