It's not using pipes, but you can refactor the example with this Python list comprehension.

    def filter_authors(authors, company):
        return [author['twitter_handle'] for author in authors if author['company'] == company and author['twitter_handle']]

EDIT: HN code formatting seems to be broken so you may need to scroll right to see the entire comprehension.

You can do other SQL-like operations with list comprehensions too.

http://code.activestate.com/recipes/159974-sql-like-set-oper...