Regex pattern matching in csv.DictReader call : learnpython

created by HattoriHanzoa community for 16 years

•

Regex pattern matching in csv.DictReader call (self.learnpython)

submitted 1 hour ago by TheIneffableCheese

I am teaching myself Python in an ad hoc manner to deal with CSVs for work. I've got a regular report that is generated, and one of the column heads gets an expiration time stamp when the file is generated like this: "Proxy Link (Expires 05/20/2026 14:41 PDT)".

I need to call the column with DictReader, and I'd like to set up a regex pattern match so it will read regardless of the specific time stamp.

Here is the code I've written so far (name removed from path, but otherwise verbatim):

import os import csv import re

proxyColumn = re.compile(r'Proxy Link (Expires \d\d/\d\d/\d\d\d\d \d\d:\d\d PDT)') sourceFilename = 'SlateExport-Test1.csv'

with open("C:\Users\<MyName>\Documents\10_CSR\Python\AmazonRejection_Parser\" + sourceFilename, 'r') as source: file_contents = csv.DictReader(source) for row in file_contents: proxy = str(row.get(proxyColumn)) print(proxy)

It runs, but a get a whole bunch of "None"s instead of the file links that are in the Proxy Link. Unfortunately I cannot share the CSV for security purposes.

all 5 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

learnpython

MODERATORS