Python - Real World Example - Parsing Names From a CSV to an HTML List
** Real World Example - Parsing Names From a CSV to an HTML List
==========================================
import csv
html_output = ''
names = []
with open('patrons.csv', 'r') as data_file:
csv_data = csv.reader(data_file)
print(list(csv_data))
---------------------------------
[['FirstName', 'LastName', 'Email', 'Pledge', 'Lifetime', 'Status', 'Country', 'Start'], ['1 + Reward', 'Description I will add your name to the contributors page on my website.\n\t\nYou will also be eligible for Patreon-only rewards. I will occasionally give away books that I have read, and will choose a Patron at random to receive those.', '', '', '', '', '', ''], ['John', 'Doe', 'johndoe@linuxerhan.com', '10.00', '20.00', 'Ok', '', '2017-05-06 21:28:06.183108'], ['Dave', 'Smith', 'davesmith@linuxerhan.com', '5.00', '10.00', 'Ok', '', '2017-05-29 16:13:58.318920'], ['Mary', 'Jacobs', 'maryjacobs@linuxerhan.com', '5.00', '10.00', 'Ok', '', '2017-05-14 07:37:01.074648'], ['Jane', 'Stuart', 'janestuart@linuxerhan.com', '5.00', '25.00', 'Ok', '', '2016-12-30 18:12:13'], ['Tom', 'Wright', 'tomwright@linuxerhan.com', '5.00', '15.00', 'Ok', '', '2017-04-14 04:02:06.658439'], ['Steve', 'Robinson', 'steverobinson@linuxerhan.com', '5.00', '20.00', 'Ok', '', '2017-03-17 02:20:14'], ['Nicole', 'Jacobs', 'nicolejacobs@linuxerhan.com', '5.00', '20.00', 'Ok', '', '2017-03-12 17:07:29'], ['Jane', 'Wright', 'janewright@linuxerhan.com', '5.00', '25.00', '', '', '2017-01-14 17:40:06'], ['Jane', 'Doe', 'janedoe@linuxerhan.com', '2.50', '5.00', 'Ok', '', '2017-05-14 11:20:50.798440'], ['Kurt', 'Wright', 'kurtwright@linuxerhan.com', '2.00', '2.00', 'Ok', '', '2017-06-23 21:12:15.662157'], ['Kurt', 'Robinson', 'kurtrobinson@linuxerhan.com', '2.00', '4.00', 'Ok', '', '2017-05-03 03:18:54.877885'], ['Jane', 'Jenkins', 'janejenkins@linuxerhan.com', '2.00', '8.00', 'Ok', '', '2017-03-23 16:37:47.708634'], ['Neil', 'Robinson', 'neilrobinson@linuxerhan.com', '1.50', '3.00', 'Ok', '', '2017-05-26 19:59:51.013984'], ['Tom', 'Patterson', 'tompatterson@linuxerhan.com', '1.34', '4.02', 'Ok', '', '2017-04-27 01:55:12.313799'], ['Sam', 'Jenkins', 'samjenkins@linuxerhan.com', '1.00', '0.00', 'Ok', '', '2017-07-16 02:34:47.674287'], ['Steve', 'Stuart', 'stevestuart@linuxerhan.com', '1.00', '1.00', 'Ok', '', '2017-06-12 03:32:00.706554'], ['Maggie', 'Patterson', 'maggiepatterson@linuxerhan.com', '1.00', '2.00', 'Ok', '', '2017-05-26 01:23:14.097393'], ['Maggie', 'Stuart', 'maggiestuart@linuxerhan.com', '1.00', '2.00', 'Ok', '', '2017-05-19 23:11:08.624354'], ['Jane', 'Doe', 'janedoe@linuxerhan.com', '1.00', '3.00', 'Ok', '', '2017-04-15 19:40:17.044921'], ['Steve', 'Patterson', 'stevepatterson@linuxerhan.com', '1.00', '3.00', 'Ok', '', '2017-04-09 17:14:23.591656'], ['Dave', 'Smith', 'davesmith@linuxerhan.com', '1.00', '3.00', 'Ok', '', '2017-04-01 18:35:10.731005'], ['Sam', 'Wilks', 'samwilks@linuxerhan.com', '1.00', '4.00', 'Ok', '', '2017-03-01 09:40:56'], ['Kurt', 'Jefferson', 'kurtjefferson@linuxerhan.com', '1.00', '5.00', 'Ok', '', '2017-02-24 08:23:05'], ['Sam', 'Stuart', 'samstuart@linuxerhan.com', '1.00', '5.00', 'Ok', '', '2017-02-12 00:14:31'], ['Jane', 'Stuart', 'janestuart@linuxerhan.com', '1.00', '5.00', 'Ok', '', '2017-02-06 14:52:28'], ['Dave', 'Davis', 'davedavis@linuxerhan.com', '1.00', '0.00', '', '', '2016-11-18 01:37:25'], ['Sam', 'Patterson', 'sampatterson@linuxerhan.com', '1.00', '8.00', 'Ok', '', '2016-11-01 11:27:17'], ['Tom', 'Jefferson', 'tomjefferson@linuxerhan.com', '1.00', '10.00', 'Ok', '', '2016-09-27 09:56:48'], ['Jane', 'Stuart', 'janestuart@linuxerhan.com', '1.00', '7.00', '', '', '2016-08-09 14:42:25'], ['Maggie', 'Jefferson', 'maggiejefferson@linuxerhan.com', '1.00', '12.00', 'Ok', '', '2016-07-26 05:02:16'], ['No Reward', 'Description: (None for No Reward)', '', '', '', '', '', ''], ['Mary', 'Wilks', 'marywilks@linuxerhan.com', '20.00', '60.00', 'Ok', '', '2017-04-21 02:44:43.395224'], ['Neil', 'Patterson', 'neilpatterson@linuxerhan.com', '10.00', '80.00', 'Ok', '', '2016-11-12 17:49:37'], ['Corey', 'Davis', 'coreydavis@linuxerhan.com', '6.00', '90.00', 'Ok', '', '2016-04-01 15:19:52'], ['Steve', 'Jacobs', 'stevejacobs@linuxerhan.com', '5.00', '21.00', 'Ok', '', '2017-01-04 19:38:44'], ['Jane', 'Jenkins', 'janejenkins@linuxerhan.com', '5.00', '30.00', 'Ok', '', '2017-01-15 17:24:39'], ['John', 'Jacobs', 'johnjacobs@linuxerhan.com', '3.14', '34.54', 'Ok', '', '2016-08-23 16:09:25'], ['Neil', 'Smith', 'neilsmith@linuxerhan.com', '3.00', '24.00', 'Ok', '', '2016-11-28 02:57:48'], ['Corey', 'Wilks', 'coreywilks@linuxerhan.com', '2.00', '8.00', 'Ok', '', '2017-03-26 20:13:08.207869'], ['Corey', 'Smith', 'coreysmith@linuxerhan.com', '1.00', '0.00', 'Ok', '', '2017-07-05 01:50:35.171076'], ['Mary', 'Patterson', 'marypatterson@linuxerhan.com', '1.00', '0.00', 'Ok', '', '2017-07-04 18:05:23.052059'], ['Jane', 'Stuart', 'janestuart@linuxerhan.com', '1.00', '2.00', 'Ok', '', '2017-05-21 19:42:36.098523'], ['Travis', 'Arnold', 'travisarnold@linuxerhan.com', '1.00', '3.00', 'Ok', '', '2017-04-19 08:04:33.428559'], ['John', 'Robinson', 'johnrobinson@linuxerhan.com', '1.00', '4.00', 'Ok', '', '2017-03-30 14:59:33.850333'], ['Travis', 'Arnold', 'travisarnold@linuxerhan.com', '1.00', '6.00', 'Ok', '', '2017-01-28 22:02:57']]
---------------------------------
==========================================
import csv
html_output = ''
names = []
with open('patrons.csv', 'r') as data_file:
csv_data = csv.reader(data_file)
for line in csv_data:
print(line)
---------------------------------
['FirstName', 'LastName', 'Email', 'Pledge', 'Lifetime', 'Status', 'Country', 'Start']
['1 + Reward', 'Description I will add your name to the contributors page on my website.\n\t\nYou will also be eligible for Patreon-only rewards. I will occasionally give away books that I have read, and will choose a Patron at random to receive those.', '', '', '', '', '', '']
['John', 'Doe', 'johndoe@linuxerhan.com', '10.00', '20.00', 'Ok', '', '2017-05-06 21:28:06.183108']
['Dave', 'Smith', 'davesmith@linuxerhan.com', '5.00', '10.00', 'Ok', '', '2017-05-29 16:13:58.318920']
['Mary', 'Jacobs', 'maryjacobs@linuxerhan.com', '5.00', '10.00', 'Ok', '', '2017-05-14 07:37:01.074648']
['Jane', 'Stuart', 'janestuart@linuxerhan.com', '5.00', '25.00', 'Ok', '', '2016-12-30 18:12:13']
['Tom', 'Wright', 'tomwright@linuxerhan.com', '5.00', '15.00', 'Ok', '', '2017-04-14 04:02:06.658439']
['Steve', 'Robinson', 'steverobinson@linuxerhan.com', '5.00', '20.00', 'Ok', '', '2017-03-17 02:20:14']
['Nicole', 'Jacobs', 'nicolejacobs@linuxerhan.com', '5.00', '20.00', 'Ok', '', '2017-03-12 17:07:29']
['Jane', 'Wright', 'janewright@linuxerhan.com', '5.00', '25.00', '', '', '2017-01-14 17:40:06']
['Jane', 'Doe', 'janedoe@linuxerhan.com', '2.50', '5.00', 'Ok', '', '2017-05-14 11:20:50.798440']
['Kurt', 'Wright', 'kurtwright@linuxerhan.com', '2.00', '2.00', 'Ok', '', '2017-06-23 21:12:15.662157']
['Kurt', 'Robinson', 'kurtrobinson@linuxerhan.com', '2.00', '4.00', 'Ok', '', '2017-05-03 03:18:54.877885']
['Jane', 'Jenkins', 'janejenkins@linuxerhan.com', '2.00', '8.00', 'Ok', '', '2017-03-23 16:37:47.708634']
['Neil', 'Robinson', 'neilrobinson@linuxerhan.com', '1.50', '3.00', 'Ok', '', '2017-05-26 19:59:51.013984']
['Tom', 'Patterson', 'tompatterson@linuxerhan.com', '1.34', '4.02', 'Ok', '', '2017-04-27 01:55:12.313799']
['Sam', 'Jenkins', 'samjenkins@linuxerhan.com', '1.00', '0.00', 'Ok', '', '2017-07-16 02:34:47.674287']
['Steve', 'Stuart', 'stevestuart@linuxerhan.com', '1.00', '1.00', 'Ok', '', '2017-06-12 03:32:00.706554']
['Maggie', 'Patterson', 'maggiepatterson@linuxerhan.com', '1.00', '2.00', 'Ok', '', '2017-05-26 01:23:14.097393']
['Maggie', 'Stuart', 'maggiestuart@linuxerhan.com', '1.00', '2.00', 'Ok', '', '2017-05-19 23:11:08.624354']
['Jane', 'Doe', 'janedoe@linuxerhan.com', '1.00', '3.00', 'Ok', '', '2017-04-15 19:40:17.044921']
['Steve', 'Patterson', 'stevepatterson@linuxerhan.com', '1.00', '3.00', 'Ok', '', '2017-04-09 17:14:23.591656']
['Dave', 'Smith', 'davesmith@linuxerhan.com', '1.00', '3.00', 'Ok', '', '2017-04-01 18:35:10.731005']
['Sam', 'Wilks', 'samwilks@linuxerhan.com', '1.00', '4.00', 'Ok', '', '2017-03-01 09:40:56']
['Kurt', 'Jefferson', 'kurtjefferson@linuxerhan.com', '1.00', '5.00', 'Ok', '', '2017-02-24 08:23:05']
['Sam', 'Stuart', 'samstuart@linuxerhan.com', '1.00', '5.00', 'Ok', '', '2017-02-12 00:14:31']
['Jane', 'Stuart', 'janestuart@linuxerhan.com', '1.00', '5.00', 'Ok', '', '2017-02-06 14:52:28']
['Dave', 'Davis', 'davedavis@linuxerhan.com', '1.00', '0.00', '', '', '2016-11-18 01:37:25']
['Sam', 'Patterson', 'sampatterson@linuxerhan.com', '1.00', '8.00', 'Ok', '', '2016-11-01 11:27:17']
['Tom', 'Jefferson', 'tomjefferson@linuxerhan.com', '1.00', '10.00', 'Ok', '', '2016-09-27 09:56:48']
['Jane', 'Stuart', 'janestuart@linuxerhan.com', '1.00', '7.00', '', '', '2016-08-09 14:42:25']
['Maggie', 'Jefferson', 'maggiejefferson@linuxerhan.com', '1.00', '12.00', 'Ok', '', '2016-07-26 05:02:16']
['No Reward', 'Description: (None for No Reward)', '', '', '', '', '', '']
['Mary', 'Wilks', 'marywilks@linuxerhan.com', '20.00', '60.00', 'Ok', '', '2017-04-21 02:44:43.395224']
['Neil', 'Patterson', 'neilpatterson@linuxerhan.com', '10.00', '80.00', 'Ok', '', '2016-11-12 17:49:37']
['Corey', 'Davis', 'coreydavis@linuxerhan.com', '6.00', '90.00', 'Ok', '', '2016-04-01 15:19:52']
['Steve', 'Jacobs', 'stevejacobs@linuxerhan.com', '5.00', '21.00', 'Ok', '', '2017-01-04 19:38:44']
['Jane', 'Jenkins', 'janejenkins@linuxerhan.com', '5.00', '30.00', 'Ok', '', '2017-01-15 17:24:39']
['John', 'Jacobs', 'johnjacobs@linuxerhan.com', '3.14', '34.54', 'Ok', '', '2016-08-23 16:09:25']
['Neil', 'Smith', 'neilsmith@linuxerhan.com', '3.00', '24.00', 'Ok', '', '2016-11-28 02:57:48']
['Corey', 'Wilks', 'coreywilks@linuxerhan.com', '2.00', '8.00', 'Ok', '', '2017-03-26 20:13:08.207869']
['Corey', 'Smith', 'coreysmith@linuxerhan.com', '1.00', '0.00', 'Ok', '', '2017-07-05 01:50:35.171076']
['Mary', 'Patterson', 'marypatterson@linuxerhan.com', '1.00', '0.00', 'Ok', '', '2017-07-04 18:05:23.052059']
['Jane', 'Stuart', 'janestuart@linuxerhan.com', '1.00', '2.00', 'Ok', '', '2017-05-21 19:42:36.098523']
['Travis', 'Arnold', 'travisarnold@linuxerhan.com', '1.00', '3.00', 'Ok', '', '2017-04-19 08:04:33.428559']
['John', 'Robinson', 'johnrobinson@linuxerhan.com', '1.00', '4.00', 'Ok', '', '2017-03-30 14:59:33.850333']
['Travis', 'Arnold', 'travisarnold@linuxerhan.com', '1.00', '6.00', 'Ok', '', '2017-01-28 22:02:57']
---------------------------------
==========================================
import csv
html_output = ''
names = []
with open('patrons.csv', 'r') as data_file:
csv_data = csv.reader(data_file)
# We don't want headers or first line of bad data
next(csv_data)
next(csv_data)
for line in csv_data:
print(line)
---------------------------------
['John', 'Doe', 'johndoe@linuxerhan.com', '10.00', '20.00', 'Ok', '', '2017-05-06 21:28:06.183108']
['Dave', 'Smith', 'davesmith@linuxerhan.com', '5.00', '10.00', 'Ok', '', '2017-05-29 16:13:58.318920']
['Mary', 'Jacobs', 'maryjacobs@linuxerhan.com', '5.00', '10.00', 'Ok', '', '2017-05-14 07:37:01.074648']
['Jane', 'Stuart', 'janestuart@linuxerhan.com', '5.00', '25.00', 'Ok', '', '2016-12-30 18:12:13']
['Tom', 'Wright', 'tomwright@linuxerhan.com', '5.00', '15.00', 'Ok', '', '2017-04-14 04:02:06.658439']
['Steve', 'Robinson', 'steverobinson@linuxerhan.com', '5.00', '20.00', 'Ok', '', '2017-03-17 02:20:14']
['Nicole', 'Jacobs', 'nicolejacobs@linuxerhan.com', '5.00', '20.00', 'Ok', '', '2017-03-12 17:07:29']
['Jane', 'Wright', 'janewright@linuxerhan.com', '5.00', '25.00', '', '', '2017-01-14 17:40:06']
['Jane', 'Doe', 'janedoe@linuxerhan.com', '2.50', '5.00', 'Ok', '', '2017-05-14 11:20:50.798440']
['Kurt', 'Wright', 'kurtwright@linuxerhan.com', '2.00', '2.00', 'Ok', '', '2017-06-23 21:12:15.662157']
['Kurt', 'Robinson', 'kurtrobinson@linuxerhan.com', '2.00', '4.00', 'Ok', '', '2017-05-03 03:18:54.877885']
['Jane', 'Jenkins', 'janejenkins@linuxerhan.com', '2.00', '8.00', 'Ok', '', '2017-03-23 16:37:47.708634']
['Neil', 'Robinson', 'neilrobinson@linuxerhan.com', '1.50', '3.00', 'Ok', '', '2017-05-26 19:59:51.013984']
['Tom', 'Patterson', 'tompatterson@linuxerhan.com', '1.34', '4.02', 'Ok', '', '2017-04-27 01:55:12.313799']
['Sam', 'Jenkins', 'samjenkins@linuxerhan.com', '1.00', '0.00', 'Ok', '', '2017-07-16 02:34:47.674287']
['Steve', 'Stuart', 'stevestuart@linuxerhan.com', '1.00', '1.00', 'Ok', '', '2017-06-12 03:32:00.706554']
['Maggie', 'Patterson', 'maggiepatterson@linuxerhan.com', '1.00', '2.00', 'Ok', '', '2017-05-26 01:23:14.097393']
['Maggie', 'Stuart', 'maggiestuart@linuxerhan.com', '1.00', '2.00', 'Ok', '', '2017-05-19 23:11:08.624354']
['Jane', 'Doe', 'janedoe@linuxerhan.com', '1.00', '3.00', 'Ok', '', '2017-04-15 19:40:17.044921']
['Steve', 'Patterson', 'stevepatterson@linuxerhan.com', '1.00', '3.00', 'Ok', '', '2017-04-09 17:14:23.591656']
['Dave', 'Smith', 'davesmith@linuxerhan.com', '1.00', '3.00', 'Ok', '', '2017-04-01 18:35:10.731005']
['Sam', 'Wilks', 'samwilks@linuxerhan.com', '1.00', '4.00', 'Ok', '', '2017-03-01 09:40:56']
['Kurt', 'Jefferson', 'kurtjefferson@linuxerhan.com', '1.00', '5.00', 'Ok', '', '2017-02-24 08:23:05']
['Sam', 'Stuart', 'samstuart@linuxerhan.com', '1.00', '5.00', 'Ok', '', '2017-02-12 00:14:31']
['Jane', 'Stuart', 'janestuart@linuxerhan.com', '1.00', '5.00', 'Ok', '', '2017-02-06 14:52:28']
['Dave', 'Davis', 'davedavis@linuxerhan.com', '1.00', '0.00', '', '', '2016-11-18 01:37:25']
['Sam', 'Patterson', 'sampatterson@linuxerhan.com', '1.00', '8.00', 'Ok', '', '2016-11-01 11:27:17']
['Tom', 'Jefferson', 'tomjefferson@linuxerhan.com', '1.00', '10.00', 'Ok', '', '2016-09-27 09:56:48']
['Jane', 'Stuart', 'janestuart@linuxerhan.com', '1.00', '7.00', '', '', '2016-08-09 14:42:25']
['Maggie', 'Jefferson', 'maggiejefferson@linuxerhan.com', '1.00', '12.00', 'Ok', '', '2016-07-26 05:02:16']
['No Reward', 'Description: (None for No Reward)', '', '', '', '', '', '']
['Mary', 'Wilks', 'marywilks@linuxerhan.com', '20.00', '60.00', 'Ok', '', '2017-04-21 02:44:43.395224']
['Neil', 'Patterson', 'neilpatterson@linuxerhan.com', '10.00', '80.00', 'Ok', '', '2016-11-12 17:49:37']
['Corey', 'Davis', 'coreydavis@linuxerhan.com', '6.00', '90.00', 'Ok', '', '2016-04-01 15:19:52']
['Steve', 'Jacobs', 'stevejacobs@linuxerhan.com', '5.00', '21.00', 'Ok', '', '2017-01-04 19:38:44']
['Jane', 'Jenkins', 'janejenkins@linuxerhan.com', '5.00', '30.00', 'Ok', '', '2017-01-15 17:24:39']
['John', 'Jacobs', 'johnjacobs@linuxerhan.com', '3.14', '34.54', 'Ok', '', '2016-08-23 16:09:25']
['Neil', 'Smith', 'neilsmith@linuxerhan.com', '3.00', '24.00', 'Ok', '', '2016-11-28 02:57:48']
['Corey', 'Wilks', 'coreywilks@linuxerhan.com', '2.00', '8.00', 'Ok', '', '2017-03-26 20:13:08.207869']
['Corey', 'Smith', 'coreysmith@linuxerhan.com', '1.00', '0.00', 'Ok', '', '2017-07-05 01:50:35.171076']
['Mary', 'Patterson', 'marypatterson@linuxerhan.com', '1.00', '0.00', 'Ok', '', '2017-07-04 18:05:23.052059']
['Jane', 'Stuart', 'janestuart@linuxerhan.com', '1.00', '2.00', 'Ok', '', '2017-05-21 19:42:36.098523']
['Travis', 'Arnold', 'travisarnold@linuxerhan.com', '1.00', '3.00', 'Ok', '', '2017-04-19 08:04:33.428559']
['John', 'Robinson', 'johnrobinson@linuxerhan.com', '1.00', '4.00', 'Ok', '', '2017-03-30 14:59:33.850333']
['Travis', 'Arnold', 'travisarnold@linuxerhan.com', '1.00', '6.00', 'Ok', '', '2017-01-28 22:02:57']
---------------------------------
==========================================
import csv
html_output = ''
names = []
with open('patrons.csv', 'r') as data_file:
csv_data = csv.reader(data_file)
# We don't want headers or first line of bad data
next(csv_data)
next(csv_data)
for line in csv_data:
names.append(f"{line[0]} {line[1]}")
for name in names:
print(name)
---------------------------------
John Doe
Dave Smith
Mary Jacobs
Jane Stuart
Tom Wright
Steve Robinson
Nicole Jacobs
Jane Wright
Jane Doe
Kurt Wright
Kurt Robinson
Jane Jenkins
Neil Robinson
Tom Patterson
Sam Jenkins
Steve Stuart
Maggie Patterson
Maggie Stuart
Jane Doe
Steve Patterson
Dave Smith
Sam Wilks
Kurt Jefferson
Sam Stuart
Jane Stuart
Dave Davis
Sam Patterson
Tom Jefferson
Jane Stuart
Maggie Jefferson
No Reward Description: (None for No Reward)
Mary Wilks
Neil Patterson
Corey Davis
Steve Jacobs
Jane Jenkins
John Jacobs
Neil Smith
Corey Wilks
Corey Smith
Mary Patterson
Jane Stuart
Travis Arnold
John Robinson
Travis Arnold
---------------------------------
==========================================
import csv
html_output = ''
names = []
with open('patrons.csv', 'r') as data_file:
csv_data = csv.reader(data_file)
# We don't want headers or first line of bad data
next(csv_data)
next(csv_data)
for line in csv_data:
if line[0] == 'No Reward':
break
names.append(f"{line[0]} {line[1]}")
for name in names:
print(name)
---------------------------------
John Doe
Dave Smith
Mary Jacobs
Jane Stuart
Tom Wright
Steve Robinson
Nicole Jacobs
Jane Wright
Jane Doe
Kurt Wright
Kurt Robinson
Jane Jenkins
Neil Robinson
Tom Patterson
Sam Jenkins
Steve Stuart
Maggie Patterson
Maggie Stuart
Jane Doe
Steve Patterson
Dave Smith
Sam Wilks
Kurt Jefferson
Sam Stuart
Jane Stuart
Dave Davis
Sam Patterson
Tom Jefferson
Jane Stuart
Maggie Jefferson
---------------------------------
==========================================
---------------------------------
==========================================
import csv
html_output = ''
names = []
with open('patrons.csv', 'r') as data_file:
csv_data = csv.DictReader(data_file)
for item in csv_data:
print(item)
---------------------------------
{'FirstName': '1 + Reward', 'LastName': 'Description I will add your name to the contributors page on my website.\n\t\nYou will also be eligible for Patreon-only rewards. I will occasionally give away books that I have read, and will choose a Patron at random to receive those.', 'Email': '', 'Pledge': '', 'Lifetime': '', 'Status': '', 'Country': '', 'Start': ''}
{'FirstName': 'John', 'LastName': 'Doe', 'Email': 'johndoe@linuxerhan.com', 'Pledge': '10.00', 'Lifetime': '20.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-05-06 21:28:06.183108'}
{'FirstName': 'Dave', 'LastName': 'Smith', 'Email': 'davesmith@linuxerhan.com', 'Pledge': '5.00', 'Lifetime': '10.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-05-29 16:13:58.318920'}
{'FirstName': 'Mary', 'LastName': 'Jacobs', 'Email': 'maryjacobs@linuxerhan.com', 'Pledge': '5.00', 'Lifetime': '10.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-05-14 07:37:01.074648'}
{'FirstName': 'Jane', 'LastName': 'Stuart', 'Email': 'janestuart@linuxerhan.com', 'Pledge': '5.00', 'Lifetime': '25.00', 'Status': 'Ok', 'Country': '', 'Start': '2016-12-30 18:12:13'}
{'FirstName': 'Tom', 'LastName': 'Wright', 'Email': 'tomwright@linuxerhan.com', 'Pledge': '5.00', 'Lifetime': '15.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-04-14 04:02:06.658439'}
{'FirstName': 'Steve', 'LastName': 'Robinson', 'Email': 'steverobinson@linuxerhan.com', 'Pledge': '5.00', 'Lifetime': '20.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-03-17 02:20:14'}
{'FirstName': 'Nicole', 'LastName': 'Jacobs', 'Email': 'nicolejacobs@linuxerhan.com', 'Pledge': '5.00', 'Lifetime': '20.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-03-12 17:07:29'}
{'FirstName': 'Jane', 'LastName': 'Wright', 'Email': 'janewright@linuxerhan.com', 'Pledge': '5.00', 'Lifetime': '25.00', 'Status': '', 'Country': '', 'Start': '2017-01-14 17:40:06'}
{'FirstName': 'Jane', 'LastName': 'Doe', 'Email': 'janedoe@linuxerhan.com', 'Pledge': '2.50', 'Lifetime': '5.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-05-14 11:20:50.798440'}
{'FirstName': 'Kurt', 'LastName': 'Wright', 'Email': 'kurtwright@linuxerhan.com', 'Pledge': '2.00', 'Lifetime': '2.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-06-23 21:12:15.662157'}
{'FirstName': 'Kurt', 'LastName': 'Robinson', 'Email': 'kurtrobinson@linuxerhan.com', 'Pledge': '2.00', 'Lifetime': '4.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-05-03 03:18:54.877885'}
{'FirstName': 'Jane', 'LastName': 'Jenkins', 'Email': 'janejenkins@linuxerhan.com', 'Pledge': '2.00', 'Lifetime': '8.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-03-23 16:37:47.708634'}
{'FirstName': 'Neil', 'LastName': 'Robinson', 'Email': 'neilrobinson@linuxerhan.com', 'Pledge': '1.50', 'Lifetime': '3.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-05-26 19:59:51.013984'}
{'FirstName': 'Tom', 'LastName': 'Patterson', 'Email': 'tompatterson@linuxerhan.com', 'Pledge': '1.34', 'Lifetime': '4.02', 'Status': 'Ok', 'Country': '', 'Start': '2017-04-27 01:55:12.313799'}
{'FirstName': 'Sam', 'LastName': 'Jenkins', 'Email': 'samjenkins@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '0.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-07-16 02:34:47.674287'}
{'FirstName': 'Steve', 'LastName': 'Stuart', 'Email': 'stevestuart@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '1.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-06-12 03:32:00.706554'}
{'FirstName': 'Maggie', 'LastName': 'Patterson', 'Email': 'maggiepatterson@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '2.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-05-26 01:23:14.097393'}
{'FirstName': 'Maggie', 'LastName': 'Stuart', 'Email': 'maggiestuart@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '2.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-05-19 23:11:08.624354'}
{'FirstName': 'Jane', 'LastName': 'Doe', 'Email': 'janedoe@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '3.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-04-15 19:40:17.044921'}
{'FirstName': 'Steve', 'LastName': 'Patterson', 'Email': 'stevepatterson@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '3.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-04-09 17:14:23.591656'}
{'FirstName': 'Dave', 'LastName': 'Smith', 'Email': 'davesmith@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '3.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-04-01 18:35:10.731005'}
{'FirstName': 'Sam', 'LastName': 'Wilks', 'Email': 'samwilks@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '4.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-03-01 09:40:56'}
{'FirstName': 'Kurt', 'LastName': 'Jefferson', 'Email': 'kurtjefferson@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '5.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-02-24 08:23:05'}
{'FirstName': 'Sam', 'LastName': 'Stuart', 'Email': 'samstuart@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '5.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-02-12 00:14:31'}
{'FirstName': 'Jane', 'LastName': 'Stuart', 'Email': 'janestuart@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '5.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-02-06 14:52:28'}
{'FirstName': 'Dave', 'LastName': 'Davis', 'Email': 'davedavis@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '0.00', 'Status': '', 'Country': '', 'Start': '2016-11-18 01:37:25'}
{'FirstName': 'Sam', 'LastName': 'Patterson', 'Email': 'sampatterson@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '8.00', 'Status': 'Ok', 'Country': '', 'Start': '2016-11-01 11:27:17'}
{'FirstName': 'Tom', 'LastName': 'Jefferson', 'Email': 'tomjefferson@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '10.00', 'Status': 'Ok', 'Country': '', 'Start': '2016-09-27 09:56:48'}
{'FirstName': 'Jane', 'LastName': 'Stuart', 'Email': 'janestuart@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '7.00', 'Status': '', 'Country': '', 'Start': '2016-08-09 14:42:25'}
{'FirstName': 'Maggie', 'LastName': 'Jefferson', 'Email': 'maggiejefferson@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '12.00', 'Status': 'Ok', 'Country': '', 'Start': '2016-07-26 05:02:16'}
{'FirstName': 'No Reward', 'LastName': 'Description: (None for No Reward)', 'Email': '', 'Pledge': '', 'Lifetime': '', 'Status': '', 'Country': '', 'Start': ''}
{'FirstName': 'Mary', 'LastName': 'Wilks', 'Email': 'marywilks@linuxerhan.com', 'Pledge': '20.00', 'Lifetime': '60.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-04-21 02:44:43.395224'}
{'FirstName': 'Neil', 'LastName': 'Patterson', 'Email': 'neilpatterson@linuxerhan.com', 'Pledge': '10.00', 'Lifetime': '80.00', 'Status': 'Ok', 'Country': '', 'Start': '2016-11-12 17:49:37'}
{'FirstName': 'Corey', 'LastName': 'Davis', 'Email': 'coreydavis@linuxerhan.com', 'Pledge': '6.00', 'Lifetime': '90.00', 'Status': 'Ok', 'Country': '', 'Start': '2016-04-01 15:19:52'}
{'FirstName': 'Steve', 'LastName': 'Jacobs', 'Email': 'stevejacobs@linuxerhan.com', 'Pledge': '5.00', 'Lifetime': '21.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-01-04 19:38:44'}
{'FirstName': 'Jane', 'LastName': 'Jenkins', 'Email': 'janejenkins@linuxerhan.com', 'Pledge': '5.00', 'Lifetime': '30.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-01-15 17:24:39'}
{'FirstName': 'John', 'LastName': 'Jacobs', 'Email': 'johnjacobs@linuxerhan.com', 'Pledge': '3.14', 'Lifetime': '34.54', 'Status': 'Ok', 'Country': '', 'Start': '2016-08-23 16:09:25'}
{'FirstName': 'Neil', 'LastName': 'Smith', 'Email': 'neilsmith@linuxerhan.com', 'Pledge': '3.00', 'Lifetime': '24.00', 'Status': 'Ok', 'Country': '', 'Start': '2016-11-28 02:57:48'}
{'FirstName': 'Corey', 'LastName': 'Wilks', 'Email': 'coreywilks@linuxerhan.com', 'Pledge': '2.00', 'Lifetime': '8.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-03-26 20:13:08.207869'}
{'FirstName': 'Corey', 'LastName': 'Smith', 'Email': 'coreysmith@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '0.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-07-05 01:50:35.171076'}
{'FirstName': 'Mary', 'LastName': 'Patterson', 'Email': 'marypatterson@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '0.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-07-04 18:05:23.052059'}
{'FirstName': 'Jane', 'LastName': 'Stuart', 'Email': 'janestuart@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '2.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-05-21 19:42:36.098523'}
{'FirstName': 'Travis', 'LastName': 'Arnold', 'Email': 'travisarnold@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '3.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-04-19 08:04:33.428559'}
{'FirstName': 'John', 'LastName': 'Robinson', 'Email': 'johnrobinson@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '4.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-03-30 14:59:33.850333'}
{'FirstName': 'Travis', 'LastName': 'Arnold', 'Email': 'travisarnold@linuxerhan.com', 'Pledge': '1.00', 'Lifetime': '6.00', 'Status': 'Ok', 'Country': '', 'Start': '2017-01-28 22:02:57'}
---------------------------------
==========================================
---------------------------------
---------------------------------