基于Element分组的PowerShell CSV数据过滤规则实现及代码补全

Got it, let's work through this to get your filtering logic implemented correctly and export the final results. First, let's recap your rules to make sure we're aligned:

1. If both the IndicatorType='10' and IndicatorType='ND' records for an Element have an Indicator of ! or empty/Null → select the ND record
2. If the IndicatorType='10' record has an Indicator of ! or empty/Null, and the IndicatorType='ND' record has an Indicator of o or u → select the 10 record

Your initial code started grouping by Element, but we need to adjust it to process each group (not just filter groups) to pick the right record. Here's the complete, commented script:

# Define your source path (update this to your actual directory path)
$myfileSource = "C:\Your\Source\File\Path"

# Grab the target CSV file from the source directory
$myfile = Get-ChildItem -Path $myfileSource -Filter *.csv

# Import CSV data and group records by the Element field
$groupedData = Import-Csv $myfile.FullName | Group-Object Element

# Initialize an empty array to store our filtered results
$filteredResults = @()

# Loop through each Element group to apply your rules
foreach ($group in $groupedData) {
    # Isolate the two possible records for the current Element
    $record10 = $group.Group | Where-Object { $_.IndicatorType -eq '10' }
    $recordND = $group.Group | Where-Object { $_.IndicatorType -eq 'ND' }

    # Skip groups that don't have both 10 and ND records (adjust this if you need to handle single-type groups)
    if (-not $record10 -or -not $recordND) {
        continue
    }

    # Create helper checks to simplify rule logic
    $is10Match = ($record10.Indicator -eq '!' -or [string]::IsNullOrEmpty($record10.Indicator))
    $isNDMatch = ($recordND.Indicator -eq '!' -or [string]::IsNullOrEmpty($recordND.Indicator))
    $isNDou = ($recordND.Indicator -eq 'o' -or $recordND.Indicator -eq 'u')

    # Apply your filtering rules to select the correct record
    if ($is10Match -and $isNDMatch) {
        # Rule 1: Both records are !/empty → keep the ND record
        $filteredResults += $recordND
    }
    elseif ($is10Match -and $isNDou) {
        # Rule 2: 10 record is !/empty, ND record is o/u → keep the 10 record
        $filteredResults += $record10
    }
    # Add additional elseif blocks here if you need to handle other edge cases (e.g., neither matches your rules)
}

# Export the final filtered results to a new CSV (update the output path as needed)
$filteredResults | Export-Csv -Path "C:\Your\Output\File\Path\filtered_results.csv" -NoTypeInformation -Encoding UTF8

Quick Notes: #

• Readability: Helper variables like $is10Match make the rule logic easier to follow and modify later.
• Edge Case Handling: The script skips groups missing either a 10 or ND record—tweak that if block if you need to retain single-type groups.
• Export Settings: -NoTypeInformation removes the unnecessary type header line, and -Encoding UTF8 ensures compatibility with most spreadsheet tools.

Just update the source and output file paths to match your environment, and this script will handle your filtering requirements perfectly.

内容的提问来源于stack exchange，提问作者Esperanza