csv filtering with python.

[buran]

csv file:

Hide/Show

Output:
date_time,test_location,part_number,product_serial_number,test_detail,test_result
2017/08/23 12:09:10,London,04X-1101-0116,1633-0001,Overall,Fail
2017/08/23 12:12:20,Glasgow,04X-1101-0115,1633-0020,Overall,Pass
2017/08/23 12:09:55,London,04X-1101-0114,1633-0002,Overall Pass
2017/08/23 12:09:55,Somewhere Magical,04X-1101-0113,1633-0050,Overall,Pass
2017/08/23 12:12:50,Glasgow,04X-1101-0112,1633-0021,Overall,Pass
2017/08/23 12:09:10,London,04X-1101-0116,1633-0001,Self Test,Fail
2017/08/23 12:12:20,Glasgow,04X-1101-0115,1633-0020,Self Test,Pass
2017/08/23 12:09:55,London,04X-1101-0114,1633-0002,Self Test,Pass
2017/08/23 12:09:55,Somewhere Magical,04X-1101-0113,1633-0050,Self Test,Pass
2017/08/23 12:12:50,Glasgow,04X-1101-0112,1633-0021,Self Test,Pas

import csv

def filter_csv(csv_file):
    reader = csv.DictReader(csv_file)
    return set((row['part_number'], row['product_serial_number']) for row in reader)


@upload_csv_blueprint.route('/upload_csv', methods=['GET','POST'])
@login_required
def upload_file():
    if request.method == 'POST':
        csvfile = request.files['file']
        for product in filter_csv(csv_file=csvfile):
            print(','.join(product))

tested with

with open('products.csv') as csvfile:
    for product in filter_csv(csv_file=csvfile):
        print(','.join(product))

Output:
04X-1101-0116,1633-0001
04X-1101-0114,1633-0002
04X-1101-0112,1633-0021
04X-1101-0113,1633-0050
04X-1101-0115,1633-0020

---

by the way, 'excel' is just name of one of the available dialects in csv module. I didn't think it's excel file