csv_parser.py

#!/usr/bin/python

# csv_parser.py - read csv check if shit is present
# Usage:
# python csv_parser.py <file.csv>
# CONFIGURE THESE 2 value
# postion_of_cig = 2 
# value_of_cig_in_string = '1'
#
#

import sys
import csv

# get csv
file = sys.argv[1]

data = []
# open csv and read it into a list of lists
with open(file, 'rb') as csvfile:
	csvreader = csv.reader(csvfile, delimiter=' ', quotechar='|')
	for row in csvreader:
		data.append(row[0].split(','))



# get rid of csv headers
data.pop(0)


# change this to fit your data set
# @chelsea, remember stuff in 0 indexed into python lists
postion_of_cig = 2 
value_of_cig_in_string = '1'

last_six_seen_memebers = []




for row in data:
	# does current row match the cig thing
	if row[postion_of_cig] == value_of_cig_in_string:
		# check chace to see if it has been seen before in the last 6
		for last_seen in last_six_seen_memebers:
			if last_seen[postion_of_cig] == value_of_cig_in_string:
				print "seen" + str(row)

	# update the cache of recently seen and remove oldest if bigger than 6		
	last_six_seen_memebers.append(row)	
	if len(last_six_seen_memebers) > 6:
		last_six_seen_memebers.pop(0)	

data.csv