csv-example.py

#!/usr/bin/env python
#
# Example of using Python's csv module.
#
# Usage:
#
#   python csv-example.py < input.csv

import csv
import sys

reader = csv.reader(sys.stdin)
writer = csv.writer(sys.stdout)

for inrow in reader:
    outcol1 = "".join(inrow[0:3])
    outcol2 = inrow[3]
    writer.writerow([outcol1, outcol2])