#!/bin/bash
awk -F, '{print $0, NR==1?"c4":($NF==$(NF-1))?"match":"mismatch"}' OFS=,