References
Difficulty
Easy - task is almost identical to listings described in this section, changes are only in variable names and values
Medium - task uses knowledge and skills acquired prior to this chapter
Hard - task requires extra skills or Python stdlib and ecosystem knowledge (check hints section below assignment)
Sub-project - task is part of bigger project completed over whole chapter
Names
firstname |
lastname |
age |
uid |
username |
password |
is_user |
is_staff |
is_admin |
lastlogin |
remember |
groups |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
Alice |
Apricot |
30 |
1000 |
alice |
secret |
True |
True |
False |
2000-01-01 |
True |
users,staff |
|
Bob |
Banana |
31 |
1001 |
bob |
qwerty |
True |
True |
False |
2000-01-02 |
True |
users,staff |
|
Carol |
Corn |
32 |
1002 |
carol |
123456 |
True |
False |
False |
2000-01-03 |
True |
users,staff |
|
Dave |
Durian |
33 |
1003 |
dave |
abc123 |
True |
False |
False |
2000-01-04 |
True |
users,staff |
|
Eve |
Elderberry |
34 |
1004 |
eve |
password1 |
True |
True |
True |
2000-01-05 |
True |
users,staff,admins |
|
Mallory |
Melon |
15 |
1005 |
mallory |
NULL |
False |
False |
False |
None |
False |
Sequences:
>>> DATA = ['Alice', 'Bob', 'Carol']
>>> DATA = ['Alice', 'Bob', 'Carol', 'Dave', 'Eve', 'Mallory']
Mappings:
>>> DATA = {'username': 'alice', 'password': 'secret'}
>>> DATA = {'username': 'alice', 'password': 'secret', 'remember': True}
>>> DATA = {'firstname': 'Alice', 'lastname': 'Apricot', 'age': 30}
List Tuple:
>>> DATA = [
... ('firstname', 'lastname'),
... ('Alice', 'Apricot'),
... ('Bob', 'Banana'),
... ('Carol', 'Corn'),
... ('Dave', 'Durian'),
... ('Eve', 'Elderberry'),
... ('Mallory', 'Melon'),
... ]
>>> DATA = [
... ('firstname', 'lastname', 'age'),
... ('Alice', 'Apricot', 30),
... ('Bob', 'Banana', 31),
... ('Carol', 'Corn', 32),
... ('Dave', 'Durian', 33),
... ('Eve', 'Elderberry', 34),
... ('Mallory', 'Melon', 15),
... ]
>>> DATA = [
... ('firstname', 'lastname', 'email'),
... ('Alice', 'Apricot', 'alice@example.com'),
... ('Bob', 'Banana', 'bob@example.com'),
... ('Carol', 'Corn', 'carol@example.com'),
... ('Dave', 'Durian', 'dave@example.org'),
... ('Eve', 'Elderberry', 'eve@example.org'),
... ('Mallory', 'Melon', 'mallory@example.net'),
... ]
>>> DATA = [
... {'firstname': 'Alice', 'lastname': 'Apricot'},
... {'firstname': 'Bob', 'lastname': 'Banana'},
... {'firstname': 'Carol', 'lastname': 'Corn'},
... {'firstname': 'Dave', 'lastname': 'Durian'},
... {'firstname': 'Eve', 'lastname': 'Elderberry'},
... {'firstname': 'Mallory', 'lastname': 'Melon'},
... ]
>>> from datetime import date
>>>
>>> DATA = [
... {'username': 'alice', 'password': 'secret', 'lastlogin': date(2000, 1, 1)},
... {'username': 'bob', 'password': 'qwerty', 'lastlogin': date(2000, 1, 2)},
... {'username': 'carol', 'password': '123456', 'lastlogin': date(2000, 1, 3)},
... {'username': 'dave', 'password': 'abc123', 'lastlogin': date(2000, 1, 4)},
... {'username': 'eve', 'password': 'password1', 'lastlogin': date(2000, 1, 5)},
... {'username': 'mallory', 'password': 'NULL', 'lastlogin': None},
... ]
>>> DATA = [
... {'firstname': 'Alice', 'lastname': 'Apricot', 'age': 30},
... {'firstname': 'Bob', 'lastname': 'Banana', 'age': 31},
... {'firstname': 'Carol', 'lastname': 'Corn', 'age': 32},
... {'firstname': 'Dave', 'lastname': 'Durian', 'age': 33},
... {'firstname': 'Eve', 'lastname': 'Elderberry', 'age': 34},
... {'firstname': 'Mallory', 'lastname': 'Melon', 'age': 15},
... ]
>>> DATA = [
... {'firstname': 'Alice', 'lastname': 'Apricot', 'email': 'alice@example.com'},
... {'firstname': 'Bob', 'lastname': 'Banana', 'email': 'bob@example.com'},
... {'firstname': 'Carol', 'lastname': 'Corn', 'email': 'carol@example.com'},
... {'firstname': 'Dave', 'lastname': 'Durian', 'email': 'dave@example.org'},
... {'firstname': 'Eve', 'lastname': 'Elderberry', 'email': 'eve@example.org'},
... {'firstname': 'Mallory', 'lastname': 'Melon', 'email': 'mallory@example.net'},
... ]
>>> DATA = [
... {'username': 'alice', 'is_user': True, 'is_staff': True, 'is_admin': False},
... {'username': 'bob', 'is_user': True, 'is_staff': True, 'is_admin': False},
... {'username': 'carol', 'is_user': True, 'is_staff': False, 'is_admin': False},
... {'username': 'dave', 'is_user': True, 'is_staff': False, 'is_admin': False},
... {'username': 'eve', 'is_user': True, 'is_staff': True, 'is_admin': True},
... {'username': 'mallory', 'is_user': False, 'is_staff': False, 'is_admin': False},
... ]
Nested:
>>> DATA = {
... 'database': 'myapp',
... 'table': 'users',
... 'rows': [
... {'username': 'alice', 'email': 'alice@example.com'},
... {'username': 'bob', 'email': 'bob@example.com'},
... {'username': 'carol', 'email': 'carol@example.com'},
... {'username': 'dave', 'email': 'dave@example.org'},
... {'username': 'eve', 'email': 'eve@example.org'},
... {'username': 'mallory', 'email': 'mallory@example.net'},
... ]
... }
>>> DATA = {
... 'username': 'alice',
... 'password': 'secret',
... 'age': 30,
... 'lastlogin': '2000-01-01',
... 'is_user': True,
... 'is_staff': True,
... 'is_admin': False,
... 'emails': ('alice@example.com', 'alice@example.edu'),
... 'permissions': ['auth.add_user', 'auth.change_user'],
... 'groups': {'users', 'staff', 'admins'},
... 'friends': [
... {'username': 'bob', 'email': 'bob@example.com'},
... {'username': 'carol', 'email': 'carol@example.com'},
... {'username': 'dave', 'email': 'dave@example.org'},
... {'username': 'eve', 'email': 'eve@example.org'},
... {'username': 'mallory', 'email': 'mallory@example.net'},
... ],
... }
>>> DATA = [
... {"firstname": "Alice", "lastname": "Apricot", "groups": [
... {"gid": 1, "name": "users"},
... {"gid": 2, "name": "staff"},
... ]},
...
... {"firstname": "Bob", "lastname": "Banana", "groups": [
... {"gid": 1, "name": "users"},
... {"gid": 2, "name": "staff"},
... ]},
...
... {"firstname": "Carol", "lastname": "Corn", "groups": [
... {"gid": 1, "name": "users"},
... ]},
...
... {"firstname": "Dave", "lastname": "Durian", "groups": [
... {"gid": 1, "name": "users"},
... ]},
...
... {"firstname": "Eve", "lastname": "Elderberry", "groups": [
... {"gid": 1, "name": "users"},
... {"gid": 2, "name": "staff"},
... {"gid": 3, "name": "admins"},
... ]},
...
... {"firstname": "Mallory", "lastname": "Melon", "groups": []},
... ]
List of Objects:
>>> class User:
... def __init__(self, firstname, lastname, age=None, email=None, groups=None):
... self.firstname = firstname
... self.lastname = lastname
... self.age = age
... self.email = email
... self.groups = groups if groups else []
...
... def __repr__(self):
... clsname = self.__class__.__qualname__
... arguments = ', '.join(f'{k}={v!r}' for k,v in vars(self).items())
... return f'{clsname}({arguments})'
>>>
>>> class Group:
... def __init__(self, name):
... self.name = name
...
... def __repr__(self):
... return f'{self.name}'
>>> DATA = [
... User('Alice', 'Apricot'),
... User('Bob', 'Banana'),
... User('Carol', 'Corn'),
... User('Dave', 'Durian'),
... User('Eve', 'Elderberry'),
... User('Mallory', 'Melon'),
... ]
>>> DATA = [
... User('Alice', 'Apricot', age=30),
... User('Bob', 'Banana', age=31),
... User('Carol', 'Corn', age=32),
... User('Dave', 'Durian', age=33),
... User('Eve', 'Elderberry', age=34),
... User('Mallory', 'Melon', age=15),
... ]
>>> DATA = [
... User('Alice', 'Apricot', email='alice@example.com'),
... User('Bob', 'Banana', email='bob@example.com'),
... User('Carol', 'Corn', email='carol@example.com'),
... User('Dave', 'Durian', email='dave@example.org'),
... User('Eve', 'Elderberry', email='eve@example.org'),
... User('Mallory', 'Melon', email='mallory@example.net'),
... ]
>>> DATA = [
... User(firstname='Alice', lastname='Apricot', age=30, groups=[
... Group('users'),
... Group('staff'),
... ]),
...
... User(firstname='Bob', lastname='Banana', age=31, groups=[
... Group('users'),
... Group('staff'),
... ]),
...
... User(firstname='Carol', lastname='Corn', age=32, groups=[
... Group('users'),
... ]),
...
... User(firstname='Dave', lastname='Durian', age=33, groups=[
... Group('users'),
... ]),
...
... User(firstname='Eve', lastname='Elderberry', age=34, groups=[
... Group('users'),
... Group('staff'),
... Group('admins'),
... ]),
...
... User(firstname='Mallory', lastname='Melon', age=15, groups=[]),
... ]
Strings:
>>> DATA = 'Alice,Apricot,30'
>>> DATA = 'firstname,lastname,age;Alice,Apricot,30'
>>> DATA = 'firstname,lastname,age;Alice,Apricot,30;Bob,Banana,31;Carol,Corn,32;Dave,Durian,33;Eve,Elderberry,34;Mallory,Melon,15'
CSV:
>>> DATA = """Alice,Apricot,30"""
>>> DATA = """firstname,lastname,age
... Alice,Apricot,30
... """
>>> DATA = """firstname,lastname,age
... Alice,Apricot,30
... Bob,Banana,31
... Carol,Corn,32
... Dave,Durian,33
... Eve,Elderberry,34
... Mallory,Melon,15"""
JSON:
>>> DATA = """[{"firstname":"Alice","lastname":"Apricot","groups":[{"gid":1,"name":"users"},{"gid":2,"name":"staff"}]},{"firstname":"Bob","lastname":"Banana","groups":[{"gid":1,"name":"users"},{"gid":2,"name":"staff"}]},{"firstname":"Carol","lastname":"Corn","groups":[{"gid":1,"name":"users"}]},{"firstname":"Dave","lastname":"Durian","groups":[{"gid":1,"name":"users"}]},{"firstname":"Eve","lastname":"Elderberry","groups":[{"gid":1,"name":"users"},{"gid":2,"name":"staff"},{"gid":3,"name":"admins"}]},{"firstname":"Mallory","lastname":"Melon","groups":[]}]"""
Schemaless:
>>> DATA = [
... {'firstname': 'Alice', 'lastname': 'Apricot'},
... {'firstname': 'Bob', 'age': 31},
... {'lastname': 'Corn', 'firstname': 'Carol'},
... {'lastname': 'Durian', 'age': 33},
... {'age': 34, 'firstname': 'Eve'},
... {'age': 15, 'lastname': 'Mallory'},
... ]
Martian
Fictional NASA and ESA astronauts
Characters from "The Martian" book and movie
Book author: Andy Weir
Movie director: Ridley Scott
Ares 3 mission crew members:
Melissa Lewis (top left)
Alex Vogel (top center)
Mark Watney (top right)
Chris Beck (bottom left)
Beth Johanssen (bottom center)
Rick Martinez (bottom right)
>>> USERS = [
... ('firstname', 'lastname', 'age'),
... ('Mark', 'Watney', 41),
... ('Melissa', 'Lewis', 40),
... ('Rick', 'Martinez', 39),
... ('Alex', 'Vogel', 40),
... ('Chris', 'Beck', 36),
... ('Beth', 'Johanssen', 29),
... ]
>>> USERS = [
... {'firstname': 'Mark', 'lastname': 'Watney', 'age': 41},
... {'firstname': 'Melissa', 'lastname': 'Lewis', 'age': 40},
... {'firstname': 'Rick', 'lastname': 'Martinez', 'age': 39},
... {'firstname': 'Alex', 'lastname': 'Vogel', 'age': 40},
... {'firstname': 'Chris', 'lastname': 'Beck', 'age': 36},
... {'firstname': 'Beth', 'lastname': 'Johanssen', 'age': 29},
... ]
>>> class Account:
... def __init__(self, firstname, lastname):
... self.firstname = firstname
... self.lastname = lastname
...
... def __repr__(self):
... clsname = self.__class__.__name__
... firstname = self.firstname
... lastname = self.lastname
... return f'{clsname}({firstname=}, {lastname=})'
>>>
>>> class User(Account):
... pass
>>>
>>> class Admin(Account):
... pass
>>>
>>>
>>> ACCOUNTS = [
... User('Mark', 'Watney'),
... Admin('Melissa', 'Lewis'),
... User('Rick', 'Martinez'),
... User('Alex', 'Vogel'),
... User('Chris', 'Beck'),
... User('Beth', 'Johanssen'),
... ]
>>> MISSION = {
... "name": "Ares 3",
... "planet": "Mars",
... "launch": "2035-06-29",
... "landing": "2035-11-07",
... "location": "Acidalia Planitia",
... "longitude": +31.3, # North
... "latitude": -331.3, # East
... "crew": [{"name": "Melissa Lewis", "email": "mlewis@nasa.gov"},
... {"name": "Rick Martinez", "email": "rmartinez@nasa.gov"},
... {"name": "Alex Vogel", "email": "avogel@esa.int"},
... {"name": "Chris Beck", "email": "cbeck@nasa.gov"},
... {"name": "Beth Johanssen", "email": "bjohanssen@nasa.gov"},
... {"name": "Mark Watney", "email": "mwatney@nasa.gov"},
... ],
... }
Pan Twardowski
Wizard from Polish legend who escaped from the devil to the Moon
Modern Film Adaptation by Allegro: https://www.youtube.com/watch?v=hRdYz8cnOW4
https://www.youtube.com/watch?v=hRdYz8cnOW4&list=PLv4THqSPE6me9Y_57EsCYjBcBMXdRz3Kp
Monty Python
onty Python's Flying Circus https://en.wikipedia.org/wiki/Monty_Python%27s_Flying_Circus
Spanish Inquisition: https://people.csail.mit.edu/paulfitz/spanish/script.html
Iris Dataset
Iris flower species:
Iris dataset:
>>> IRIS = [
... ('sepal_length', 'sepal_width', 'petal_length', 'petal_width', 'species'),
... (5.8, 2.7, 5.1, 1.9, 'virginica'),
... (5.1, 3.5, 1.4, 0.2, 'setosa'),
... (5.7, 2.8, 4.1, 1.3, 'versicolor'),
... (6.3, 2.9, 5.6, 1.8, 'virginica'),
... (6.4, 3.2, 4.5, 1.5, 'versicolor'),
... (4.7, 3.2, 1.3, 0.2, 'setosa'),
... (7.0, 3.2, 4.7, 1.4, 'versicolor'),
... (7.6, 3.0, 6.6, 2.1, 'virginica'),
... (4.6, 3.1, 1.5, 0.2, 'setosa'),
... ]
Dates and Timezones
1957-10-04 19:28:34 UTC- Sputnik launch1961-04-12 06:07:00 UTC- Yuri Gagarin's launch1969-07-21 02:56:15 UTC- Apollo 11 Neil Armstrong's first step on the Moon
>>> from datetime import datetime, date, timezone
>>>
>>>
>>> DATA = {
... 'mission': 'Ares 3',
... 'launch_date': datetime(2035, 6, 29),
... 'destination': 'Mars',
... 'destination_landing': datetime(2035, 11, 7),
... 'destination_location': 'Acidalia Planitia',
... 'crew': [{'name': 'Melissa Lewis', 'birthdate': date(1995, 7, 15), "age": 40},
... {'name': 'Rick Martinez', 'birthdate': date(1996, 1, 21), "age": 39},
... {'name': 'Alex Vogel', 'birthdate': date(1994, 11, 15), "age": 40},
... {'name': 'Chris Beck', 'birthdate': date(1999, 8, 2), "age": 36},
... {'name': 'Beth Johanssen', 'birthdate': date(2006, 5, 9), "age": 29},
... {'name': 'Mark Watney', 'birthdate': date(1994, 10, 12), "age": 41}]
... }
{"mission": "Ares 3",
"launch_date": "2035-06-29T00:00:00",
"destination": "Mars",
"destination_landing": "2035-11-07T00:00:00",
"destination_location": "Acidalia Planitia",
"crew": [{"name": "Melissa Lewis", "birthdate": "1995-07-15", "age": 40},
{"name": "Rick Martinez", "birthdate": "1996-01-21", "age": 39},
{"name": "Alex Vogel", "birthdate": "1994-11-15", "age": 40},
{"name": "Chris Beck", "birthdate": "1999-08-02", "age": 36},
{"name": "Beth Johanssen", "birthdate": "2006-05-09", "age": 29},
{"name": "Mark Watney", "birthdate": "1994-10-12", "age": 41}]}
[{"model":"authorization.user","pk":1,"fields":{"firstname":"Melissa","lastname":"Lewis","role":"commander","username":"mlewis","password":"pbkdf2_sha256$120000$gvEBNiCeTrYa0$5C+NiCeTrYsha1PHogqvXNiCeTrY0CRSLYYAA90=","email":"mlewis@nasa.gov","birthdate":"1995-07-15","last_login":"1970-01-01T00:00:00.000+00:00","is_active":true,"is_staff":true,"is_superuser":false,"user_permissions":[{"eclss":["add","modify","view"]},{"communication":["add","modify","view"]},{"medical":["add","modify","view"]},{"science":["add","modify","view"]}]}},{"model":"authorization.user","pk":2,"fields":{"firstname":"Rick","lastname":"Martinez","role":"pilot","username":"rmartinez","password":"pbkdf2_sha256$120000$aXNiCeTrY$UfCJrBh/qhXohNiCeTrYH8nsdANiCeTrYnShs9M/c=","birthdate":"1996-01-21","last_login":null,"email":"rmartinez@nasa.gov","is_active":true,"is_staff":true,"is_superuser":false,"user_permissions":[{"communication":["add","view"]},{"eclss":["add","modify","view"]},{"science":["add","modify","view"]}]}},{"model":"authorization.user","pk":3,"fields":{"firstname":"Alex","lastname":"Vogel","role":"chemist","username":"avogel","password":"pbkdf2_sha256$120000$eUNiCeTrYHoh$X32NiCeTrYZOWFdBcVT1l3NiCeTrY4WJVhr+cKg=","email":"avogel@esa.int","birthdate":"1994-11-15","last_login":null,"is_active":true,"is_staff":true,"is_superuser":false,"user_permissions":[{"eclss":["add","modify","view"]},{"communication":["add","modify","view"]},{"medical":["add","modify","view"]},{"science":["add","modify","view"]}]}},{"model":"authorization.user","pk":4,"fields":{"firstname":"Chris","lastname":"Beck","role":"crew-medical-officer","username":"cbeck","password":"pbkdf2_sha256$120000$3G0RNiCeTrYlaV1$mVb62WNiCeTrYQ9aYzTsSh74NiCeTrY2+c9/M=","email":"cbeck@nasa.gov","birthdate":"1999-08-02","last_login":"1970-01-01T00:00:00.000+00:00","is_active":true,"is_staff":true,"is_superuser":false,"user_permissions":[{"communication":["add","view"]},{"medical":["add","modify","view"]},{"science":["add","modify","view"]}]}},{"model":"authorization.user","pk":5,"fields":{"firstname":"Beth","lastname":"Johanssen","role":"sysop","username":"bjohanssen","password":"pbkdf2_sha256$120000$QmSNiCeTrYBv$Nt1jhVyacNiCeTrYSuKzJ//WdyjlNiCeTrYYZ3sB1r0g=","email":"bjohanssen@nasa.gov","birthdate":"2006-05-09","last_login":null,"is_active":true,"is_staff":true,"is_superuser":false,"user_permissions":[{"communication":["add","view"]},{"science":["add","modify","view"]}]}},{"model":"authorization.user","pk":6,"fields":{"firstname":"Mark","lastname":"Watney","role":"botanist","username":"mwatney","password":"pbkdf2_sha256$120000$bxS4dNiCeTrY1n$Y8NiCeTrYRMa5bNJhTFjNiCeTrYp5swZni2RQbs=","email":"mwatney@nasa.gov","birthdate":"1994-10-12","last_login":null,"is_active":true,"is_staff":true,"is_superuser":false,"user_permissions":[{"communication":["add","modify","view"]},{"science":["add","modify","view"]}]}}]
Addresses
POLSA - Polish Space Agency
ESA - European Space Agency
NASA - National Aeronautics and Space Administration, USA
name |
street |
city |
post_code |
state |
country |
|---|---|---|---|---|---|
Kosmodrom Bajkonur |
Wochod |
Bajkonur |
101503 |
Kyzyłordyński |
Kazachstan |
Johnson Space Center |
2101 E NASA Pkwy |
Huston |
77058 |
Texas |
USA |
Kennedy Space Center |
None |
Cape Canaveral |
32899 |
Floryda |
USA |
NASA Jet Propulsion Laboratory |
4800 Oak Grove Dr |
Pasadena |
91109 |
California |
USA |
NASA Armstrong Research Center |
2825 E Ave P |
Palmdale |
93550 |
California |
USA |
ESA EAC |
Linder Hoehe |
Cologne |
51147 |
North Rhine-Westphalia |
Germany |
[
{"firstname": "Pan", "lastname": "Twardowski", "addresses": [
{"street": "Kamienica Pod św. Janem Kapistranem", "city": "Kraków", "post_code": "31-008", "region": "Małopolskie", "country": "Poland"}]},
{"firstname": "José", "lastname": "Jiménez", "addresses": [
{"street": "2101 E NASA Pkwy", "city": "Houston", "post_code": "77058", "region": "Texas", "country": "USA"},
{"street": "", "city": "Kennedy Space Center", "post_code": "32899", "region": "Florida", "country": "USA"}]},
{"firstname": "Иван", "lastname": "Иванович", "addresses": [
{"street": "", "city": "Космодро́м Байкону́р", "post_code": "", "region": "Кызылординская область", "country": "Қазақстан"},
{"street": "", "city": "Звёздный городо́к", "post_code": "141160", "region": "Московская область", "country": "Россия"}]}
]
[
{"firstname": "Mark",
"lastname": "Watney", "addresses": [
{"street": "2101 E NASA Pkwy",
"city": "Houston",
"postcode": "77058",
"region": "Texas",
"country": "USA"},
{"street": "",
"city": "Kennedy Space Center",
"postcode": 32899,
"region": "Florida",
"country": "USA"}]},
{"firstname": "Melissa", "lastname": "Lewis", "addresses": [
{"street": "4800 Oak Grove Dr",
"city": "Pasadena",
"postcode": "91109",
"region": "California",
"country": "USA"}]},
{"firstname": "Rick", "lastname": "Martinez", "addresses": [
{"street": "2825 E Ave P",
"city": "Palmdale",
"postcode": "93550",
"region": "California",
"country": "USA"}]},
{"firstname": "Alex", "lastname": "Vogel", "addresses": [
{"street": "Linder Hoehe",
"city": "Cologne",
"postcode": "51147",
"region": "North Rhine-Westphalia",
"country": "Germany"}]},
{"firstname": "Beth", "lastname": "Johanssen", "addresses": []},
{"firstname": "Cris", "lastname": "Beck", "addresses": []}
]
CSV
>>> USERS = """firstname,lastname,birthdate,gender,ssn,email,phone
... Mark,Watney,1994-10-12,male,94101212345,mwatney@nasa.gov,+1 (234) 555-0000
... Melissa,Lewis,1995-07-15,female,95071512345,mlewis@nasa.gov,+1 (234) 555-0001
... Rick,Martinez,1996-01-21,male,96012112345,rmartinez@nasa.gov,+1 (234) 555-0010
... Alex,Vogel,1994-11-15,male,94111512345,avogel@esa.int,+49 (234) 555-0011
... Beth,Johanssen,2006-05-09,female,06250912345,bjohanssen@nasa.gov,+1 (234) 555-0100
... Chris,Beck,1999-08-02,male,99080212345,cbeck@nasa.gov,+1 (234) 555-0101"""
>>> ADDRESSES = """user,type,street,city,postcode,region,country
... mwatney@nasa.gov,billing,2101 E NASA Pkwy,Houston,77058,Texas,USA
... mwatney@nasa.gov,shipment,,Kennedy Space Center,32899,Florida,USA
... mlewis@nasa.gov,shipment,Kamienica Pod św. Janem Kapistranem,Kraków,31008,Małopolskie,Poland
... rmartinez@nasa.gov,billing,,Звёздный городо́к,141160,Московская область,Россия
... rmartinez@nasa.gov,shipment,,Космодро́м Байкону́р,,Кызылординская область,Қазақстан
... avogel@esa.int,shipment,Linder Hoehe,Cologne,51147,North Rhine-Westphalia,Germany
... bjohanssen@nasa.gov,shipment,2825 E Ave P,Palmdale,93550,California,USA
... cbeck@nasa.gov,shipment,4800 Oak Grove Dr,Pasadena,91109,California,USA"""
>>> PRODUCTS = """ean13,name,price
... 5039271113244,Alfa,123.00
... 5202038482222,Bravo,312.22
... 5308443764554,Charlie,812.00
... 5439667086587,Delta,332.18
... 5527865721147,Echo,114.00
... 5535686226512,Foxtrot,99.12
... 5721668602638,Golf,123.00
... 5776136485596,Hotel,444.40
... 5863969679442,India,674.21
... 5908105406923,Juliet,324.00
... 5957751061635,Kilo,932.20
... 6190780033092,Lima,128.00
... 6512625994397,Mike,91.00
... 6518235371269,November,12.00
... 6565923118590,Oscar,43.10
... 6650630136545,Papa,112.00
... 6692669560199,Quebec,997.10
... 6711341590108,Romeo,1337.00
... 6816011714454,Sierra,998.10
... 7050114819954,Tango,123.00
... 7251625012784,Uniform,564.99
... 7251925199277,Victor,990.50
... 7283004100423,Whisky,881.89
... 7309682004683,X-Ray,123.63
... 7324670042560,Zulu,311.00"""
>>> ORDERS = """user,product
... mwatney@nasa.gov,Sierra
... mwatney@nasa.gov,Victor
... bjohanssen@nasa.gov,Delta
... mlewis@nasa.gov,November
... rmartinez@nasa.gov,Mike
... mwatney@nasa.gov,Bravo
... mwatney@nasa.gov,Kilo
... avogel@esa.int,Victor
... bjohanssen@nasa.gov,Romeo
... bjohanssen@nasa.gov,Whisky
... cbeck@nasa.gov,Zulu
... mwatney@nasa.gov,Romeo
... avogel@esa.int,Romeo
... bjohanssen@nasa.gov,Victor
... bjohanssen@nasa.gov,Whisky
... mlewis@nasa.gov,Whisky
... rmartinez@nasa.gov,Mike
... mwatney@nasa.gov,November
... mwatney@nasa.gov,Kilo
... avogel@esa.int,Bravo
... bjohanssen@nasa.gov,X-Ray
... avogel@esa.int,Romeo
... bjohanssen@nasa.gov,Victor
... bjohanssen@nasa.gov,India
... mlewis@nasa.gov,Juliet
... rmartinez@nasa.gov,Foxtrot
... avogel@esa.int,Victor
... bjohanssen@nasa.gov,Romeo
... bjohanssen@nasa.gov,Whisky
... cbeck@nasa.gov,Zulu
... mwatney@nasa.gov,Alfa
... avogel@esa.int,Romeo
... bjohanssen@nasa.gov,Quebec"""