Skip to content

Instantly share code, notes, and snippets.

@qwo

qwo/filter.ps1

Created June 21, 2021 20:50
Show Gist options
  • Save qwo/40ed5dbe154ea39a84cddd72150441c9 to your computer and use it in GitHub Desktop.
Save qwo/40ed5dbe154ea39a84cddd72150441c9 to your computer and use it in GitHub Desktop.
Download ZIP
powershell spreadsheets
Raw
filter.ps1
Import-CSV -Path .\pluto_21v1.csv |Where-Object {$_.borough -eq "BK" -and $_.zipcode -in @(11205, 11206, "11216", 11221, 11233, 11238) -and $_.bldgclass -like "V*"} | Export-Csv -Path .\vacant_bedstuy_brooklyn_pluto_21v1.csv
Import-CSV -Path .\pluto_21v1.csv |Where-Object {$_.borough -eq "BK" -and $_.zipcode -in @(11205, 11206, 11216, 11221, 11233, 11238) -and $_.bldgclass -like "V*"} | select -ExpandProperty zipcode
select -ExpandProperty bldgclass
Import-CSV -Path .\pluto_21v1.csv |Where-Object {$_.borough -eq "BK" -and $_.zipcode -in @(11205, 11206, "11216", 11221, 11233, 11238) -and $_.bldgclass -like "V*"} | select
Import-CSV -Path .\pluto_21v1.csv |Where-Object {$_.borough -eq "BK" -and $_.zipcode -match "11216" -and $_.bldgclass -like "V"} | Export-Csv -Path .\Processes.csv
Import-CSV -Path .\brooklyn_pluto_21v1.csv |Where-Object {$_.borough -eq "BK" -and $_.zipcode -eq"11216" -and $_.bldgclass -like "V"}
Import-CSV -Path .\brooklyn_pluto_21v1.csv |Where-Object {$_.borough -eq "BK" -and $_.bldgclass -like "V"}
# tickets per spaces
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment