I recently wrote PAWK (https://github.com/alecthomas/pawk) in order to give me Python at the command line. It's exactly what you think it is: Python AWK.

It's served me well so far.