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

Users

Alice, Bob, Carol, Dave, Eve, Mallory
Fictional characters often used in cryptography and security literature
https://en.wikipedia.org/wiki/Alice_and_Bob#Cast_of_characters
https://www.youtube.com/watch?v=BuUSi_QvFLY

Table 3. "Alice and Bob" dataset
firstname	lastname	age	uid	username	password	email	is_user	is_staff	is_admin	lastlogin	remember	groups
Alice	Apricot	30	1000	alice	secret	alice@example.com	True	True	False	2001-01-11	True	users,staff
Bob	Blackthorn	31	1001	bob	qwerty	bob@example.com	True	True	False	2002-02-12	True	users,staff
Carol	Corn	32	1002	carol	123456	carol@example.com	True	False	False	2003-03-13	True	users
Dave	Durian	33	1003	dave	abc123	dave@example.org	True	False	False	2004-04-14	True	users
Eve	Elderberry	34	1004	eve	password1	eve@example.org	True	True	True	2005-05-15	True	users,staff,admins
Mallory	Melon	15	1005	mallory	NULL	mallory@example.net	False	False	False	None	False

Most Common:

>>> DATA = ['Alice', 'Bob', 'Carol']
>>> DATA =  ['Alice', 'Bob', 'Carol', 'Dave', 'Eve', 'Mallory']

>>> DATA = {'firstname': 'Alice', 'lastname': 'Apricot'}
>>> DATA = {'firstname': 'Alice', 'lastname': 'Apricot', 'age': 30}

>>> DATA = [
...     ('firstname', 'lastname', 'age'),
...     ('Alice', 'Apricot', 30),
...     ('Bob', 'Blackthorn', 31),
...     ('Carol', 'Corn', 32),
...     ('Dave', 'Durian', 33),
...     ('Eve', 'Elderberry', 34),
...     ('Mallory', 'Melon', 15),
... ]

>>> DATA = [
...     {'firstname': 'Alice', 'lastname': 'Apricot', 'age': 30},
...     {'firstname': 'Bob', 'lastname': 'Blackthorn', '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},
... ]

>>> class User:
...     def __init__(self, firstname, lastname, age):
...         self.firstname = firstname
...         self.lastname = lastname
...         self.age = age
...
...     def __repr__(self):
...         clsname = self.__class__.__name__
...         firstname = self.firstname
...         lastname = self.lastname
...         age = self.age
...         return f'{clsname}({firstname=}, {lastname=}, {age=})'
>>>
>>> DATA = [
...     User('Alice', 'Apricot', age=30),
...     User('Bob', 'Blackthorn', age=31),
...     User('Carol', 'Corn', age=32),
...     User('Dave', 'Durian', age=33),
...     User('Eve', 'Elderberry', age=34),
...     User('Mallory', 'Melon', age=15),
... ]

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',
... }

>>> DATA = {
...     'firstname': 'Alice',
...     'lastname': 'Apricot',
...     'age': 30,
... }

>>> DATA = {
...     'alice': 'secret',
...     'bob': 'qwerty',
...     'carol': '123456',
...     'dave': 'abc123',
...     'eve': 'password1',
...     'mallory': 'NULL',
... }

List Tuple:

>>> DATA = [
...     ('firstname', 'lastname'),
...     ('Alice', 'Apricot'),
...     ('Bob', 'Blackthorn'),
...     ('Carol', 'Corn'),
...     ('Dave', 'Durian'),
...     ('Eve', 'Elderberry'),
...     ('Mallory', 'Melon'),
... ]

>>> DATA = [
...     ('firstname', 'lastname', 'age'),
...     ('Alice', 'Apricot', 30),
...     ('Bob', 'Blackthorn', 31),
...     ('Carol', 'Corn', 32),
...     ('Dave', 'Durian', 33),
...     ('Eve', 'Elderberry', 34),
...     ('Mallory', 'Melon', 15),
... ]

>>> DATA = [
...     ('firstname', 'lastname', 'email'),
...     ('Alice', 'Apricot', 'alice@example.com'),
...     ('Bob', 'Blackthorn', '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', 'lastname', 'group'),
...     ('Alice', 'Apricot', 'users'),
...     ('Bob', 'Blackthorn', 'users'),
...     ('Carol', 'Corn', 'staff'),
...     ('Dave', 'Durian', 'staff'),
...     ('Eve', 'Elderberry', 'admins'),
...     ('Mallory', 'Melon', None),
... ]

List Mappings:

>>> DATA = [
...     {'firstname': 'Alice', 'lastname': 'Apricot', 'age': 30},
...     {'firstname': 'Bob', 'lastname': 'Blackthorn', '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},
... ]

>>> from datetime import date
>>>
>>> DATA = [
...     {'firstname': 'Alice', 'lastname': 'Apricot', 'lastlogin': date(2000, 1, 1)},
...     {'firstname': 'Bob', 'lastname': 'Blackthorn', 'lastlogin': date(2000, 2, 2)},
...     {'firstname': 'Carol', 'lastname': 'Corn', 'lastlogin': date(2000, 3, 3)},
...     {'firstname': 'Dave', 'lastname': 'Durian', 'lastlogin': date(2000, 4, 4)},
...     {'firstname': 'Eve', 'lastname': 'Elderberry', 'lastlogin': date(2000, 5, 5)},
...     {'firstname': 'Mallory', 'lastname': 'Melon', 'lastlogin': None},
... ]

>>> DATA = [
...     {'username': 'alice', 'password': 'secret'},
...     {'username': 'bob', 'password': 'qwerty'},
...     {'username': 'carol', 'password': '123456'},
...     {'username': 'dave', 'password': 'abc123'},
...     {'username': 'eve', 'password': 'password1'},
...     {'username': 'mallory', 'password': 'NULL'},
... ]

>>> DATA = [
...     {'username': 'alice', 'password': 'secret', 'token': 'e5e9fa1ba31ecd1ae84f75caaa474f3a663f05f4'},
...     {'username': 'bob', 'password': 'qwerty', 'token': 'b1b3773a05c0ed0176787a4f1574ff0075f7521e'},
...     {'username': 'carol', 'password': '123456', 'token': '7c4a8d09ca3762af61e59520943dc26494f8941b'},
...     {'username': 'dave', 'password': 'abc123', 'token': '6367c48dd193d56ea7b0baad25b19455e529f5ee'},
...     {'username': 'eve', 'password': 'password1', 'token': 'e38ad214943daad1d64c102faec29de4afe9da3d'},
...     {'username': 'mallory', 'password': 'NULL', 'token': 'eef19c54306daa69eda49c0272623bdb5e2b341f'},
... ]

>>> 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": "Blackthorn", "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):
...         self.firstname = firstname
...         self.lastname = lastname
...
...     def __repr__(self):
...         clsname = self.__class__.__name__
...         firstname = self.firstname
...         lastname = self.lastname
...         return f'{clsname}({firstname=}, {lastname=})'
>>>
>>>
>>> DATA = [
...     User('Alice', 'Apricot'),
...     User('Bob', 'Blackthorn'),
...     User('Carol', 'Corn'),
...     User('Dave', 'Durian'),
...     User('Eve', 'Elderberry'),
...     User('Mallory', 'Melon'),
... ]

>>> class User:
...     def __init__(self, firstname, lastname, age):
...         self.firstname = firstname
...         self.lastname = lastname
...         self.age = age
...
...     def __repr__(self):
...         clsname = self.__class__.__name__
...         firstname = self.firstname
...         lastname = self.lastname
...         age = self.age
...         return f'{clsname}({firstname=}, {lastname=}, {age=})'
>>>
>>>
>>> DATA = [
...     User('Alice', 'Apricot', age=30),
...     User('Bob', 'Blackthorn', age=31),
...     User('Carol', 'Corn', age=32),
...     User('Dave', 'Durian', age=33),
...     User('Eve', 'Elderberry', age=34),
...     User('Mallory', 'Melon', age=15),
... ]

>>> class User:
...     def __init__(self, firstname, lastname, email):
...         self.firstname = firstname
...         self.lastname = lastname
...         self.email = email
...
...     def __repr__(self):
...         clsname = self.__class__.__name__
...         firstname = self.firstname
...         lastname = self.lastname
...         age = self.age
...         return f'{clsname}({firstname=}, {lastname=}, {email=})'
>>>
>>>
>>> DATA = [
...     User('Alice', 'Apricot', email='alice@example.com'),
...     User('Bob', 'Blackthorn', 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'),
... ]

>>> class User:
...     def __init__(self, firstname, lastname, groups=None):
...         self.firstname = firstname
...         self.lastname = lastname
...         self.groups = groups if groups else []
...
...     def __repr__(self):
...         clsname = self.__class__.__name__
...         firstname = self.firstname
...         lastname = self.lastname
...         groups = self.groups
...         return f'{clsname}({firstname=}, {lastname=}, {groups=})'
>>>
>>> class Group:
...     def __init__(self, name):
...         self.name = name
...
...     def __repr__(self):
...         clsname = self.__class__.__name__
...         name = self.name
...         return f'{clsname}({name=})'
>>>
>>>
>>> DATA = [
...     User(firstname='Alice', lastname='Apricot', groups=[
...         Group('users'),
...         Group('staff'),
...     ]),
...
...     User(firstname='Bob', lastname='Blackthorn', groups=[
...         Group('users'),
...         Group('staff'),
...     ]),
...
...     User(firstname='Carol', lastname='Corn', groups=[
...         Group('users'),
...     ]),
...
...     User(firstname='Dave', lastname='Durian', groups=[
...         Group('users'),
...     ]),
...
...     User(firstname='Eve', lastname='Elderberry', groups=[
...         Group('users'),
...         Group('staff'),
...         Group('admins'),
...     ]),
...
...     User(firstname='Mallory', lastname='Melon', groups=[]),
... ]

Strings:

>>> DATA = 'Alice,Apricot,30'

>>> DATA = 'firstname,lastname,age;Alice,Apricot,30'

>>> DATA = 'firstname,lastname,age;Alice,Apricot,30;Bob,Blackthorn,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,Blackthorn,31
... Carol,Corn,32
... Dave,Durian,33
... Eve,Elderberry,34
... Mallory,Melon,15
... """

>>> DATA = """firstname,lastname,age,email,lastlogin,is_active,groups
... Alice,Apricot,30,alice@example.com,2000-01-01,True,users;staff
... Bob,Blackthorn,31,bob@example.com,2000-01-02,True,users;staff
... Carol,Corn,32,carol@example.com,2000-01-03,True,users
... Dave,Durian,33,dave@example.org,2000-01-04,True,users
... Eve,Elderberry,34,eve@example.org,2000-01-05,True,users;staff;admins
... Mallory,Melon,15,mallory@example.net,,False,
... """

JSON:

>>> DATA = """[{"firstname":"Alice","lastname":"Apricot","groups":[{"gid":1,"name":"users"},{"gid":2,"name":"staff"}]},{"firstname":"Bob","lastname":"Blackthorn","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":[]}]"""

>>> DATA = """[{"firstname":"Alice","lastname":"Apricot","age":30,"email":"alice@example.com","lastlogin":"2000-01-01","is_active":"True","groups":"users;staff"},{"firstname":"Bob","lastname":"Blackthorn","age":31,"email":"bob@example.com","lastlogin":"2000-01-02","is_active":"True","groups":"users;staff"},{"firstname":"Carol","lastname":"Corn","age":32,"email":"carol@example.com","lastlogin":"2000-01-03","is_active":"True","groups":"users"},{"firstname":"Dave","lastname":"Durian","age":33,"email":"dave@example.org","lastlogin":"2000-01-04","is_active":"True","groups":"users"},{"firstname":"Eve","lastname":"Elderberry","age":34,"email":"eve@example.org","lastlogin":"2000-01-05","is_active":"True","groups":"users;staff;admins"},{"firstname":"Mallory","lastname":"Melon","age":15,"email":"mallory@example.net","lastlogin":"","is_active":"False","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'},
... ]

Unix Files

Fictional users and groups on a Unix system
Format is based on typical Linux distribution, but the data is fictional
/etc/passwd
/etc/shadow
/etc/group
/etc/hosts

>>> DATA_PASSWD = """# File: /etc/passwd
... root:x:0:0:root:/root:/bin/bash
... daemon:x:1:1:daemon:/usr/sbin:/usr/sbin/nologin
... bin:x:2:2:bin:/bin:/usr/sbin/nologin
... sys:x:3:3:sys:/dev:/usr/sbin/nologin
... alice:x:1000:1000:Alice:/home/alice:/bin/bash
... bob:x:1001:1001:Bob:/home/bob:/bin/bash
... carol:x:1002:1002:Carol:/home/carol:/bin/bash
... dave:x:1003:1003:Dave:/home/dave:/bin/bash
... eve:x:1004:1004:Eve:/home/eve:/bin/bash
... mallory:x:1005:1005:Mallory:/home/mallory:/bin/bash
... """

>>> DATA_SHADOW = """# File: /etc/shadow
... root:*:10957:0:99999:7:::
... daemon:*:10957:0:99999:7:::
... bin:*:10957:0:99999:7:::
... sys:*:10957:0:99999:7:::
... alice:$6$5H0QpwprRiJQR19Y$bXGOh7dIfOWpUb/Tuqr7yQVCqL3UkrJns9.7msfvMg4ZO/PsFC5Tbt32PXAw9qRFEBs1254aLimFeNM8YsYOv.:10957:0:99999:7:::
... bob:$6$P9zn0KwR$tgfvvFWJJ5FKmoXiP5rXWOjwoEBOEoAuBi3EphRbJqqjWYvhEM2wa67L9XgQ7W591FxUNklkDIQsk4kijuhE50:10957:0:99999:7:::
... carol:!$1$.QKDPc5E$SWlkjRWexrXYgc98F.:10957:0:99999:7:::
... dave:!$6$wXtY9ZoG$MxaKfj3Z8F9G8wKz7LU0:10957:0:99999:7:::
... eve:!!:10957:0:90:5:30:10988:
... mallory: :::::::
... """

>>> DATA_GROUP = """# File: /etc/group
... root::0:root
... daemon::1:root,daemon
... bin::2:root,bin,daemon
... sys::3:root
... sudo::4:
... users::1001:alice,bob,carol,dave,eve
... staff::1002:alice,bob,eve
... admins::1003:eve
... """

>>> DATA_GROUP = [
...     # File: /etc/group
...     ('root', '', '0', 'root'),
...     ('daemon', '', '1', 'root,daemon'),
...     ('bin', '', '2', 'root,bin,daemon'),
...     ('sys', '', '3', 'root'),
...     ('sudo', '', '4', ''),
...     ('users', '', '1001', 'alice,bob,carol,dave,eve'),
...     ('staff', '', '1002', 'alice,bob,eve'),
...     ('admins', '', '1003', 'eve'),
... ]

>>> DATA_HOSTS = """# File: /etc/hosts
... 127.0.0.1       localhost
... 127.0.0.1       mycomputer
... 172.16.0.1      example.com
... 192.168.0.1     example.edu example.org
... 10.0.0.1        example.net
... 255.255.255.255 broadcasthost
... ::1             localhost
... """

>>> DATA = {
...     '127.0.0.1': ['localhost'],
...     '127.0.0.1': ['mycomputer'],
...     '172.16.0.1': ['example.com'],
...     '192.168.0.1': ['example.edu', 'example.org'],
...     '10.0.0.1': ['example.net'],
...     '255.255.255.255': ['broadcasthost'],
...     '::1': ['localhost']
... }

Shop

>>> DATA_CUSTOMERS = [
...     {
...         "firstname": "Alice",
...         "lastname": "Apricot",
...         "birthdate": "2001-01-11",
...         "gender": "female",
...         "tax_number": "777-286-18-01",
...         "email": "alice@example.com",
...         "phone": "+1 (234) 555-0000"
...     },
...     {
...         "firstname": "Bob",
...         "lastname": "Blackthorn",
...         "birthdate": "2002-02-12",
...         "gender": "male",
...         "tax_number": "777-286-18-02",
...         "email": "bob@example.com",
...         "phone": "+1 (234) 555-0001"
...     },
...     {
...         "firstname": "Carol",
...         "lastname": "Corn",
...         "birthdate": "2003-03-13",
...         "gender": "female",
...         "tax_number": "777-286-18-03",
...         "email": "carol@example.com",
...         "phone": "+1 (234) 555-0010"
...     },
...     {
...         "firstname": "Dave",
...         "lastname": "Durian",
...         "birthdate": "2004-04-14",
...         "gender": "male",
...         "tax_number": "777-286-18-04",
...         "email": "dave@example.org",
...         "phone": "+1 (234) 555-0011"
...     },
...     {
...         "firstname": "Eve",
...         "lastname": "Elderberry",
...         "birthdate": "2005-05-15",
...         "gender": "female",
...         "tax_number": "777-286-18-05",
...         "email": "eve@example.org",
...         "phone": "+1 (234) 555-0100"
...     },
...     {
...         "firstname": "Mallory",
...         "lastname": "Melon",
...         "birthdate": "",
...         "gender": "",
...         "tax_number": "",
...         "email": "mallory@example.net",
...         "phone": ""
...     }
... ]

>>> DATA_PRODUCTS = [
...     {"barcode": "5039271113244", "name": "Alfa", "price": "123.00"},
...     {"barcode": "5202038482222", "name": "Bravo", "price": "312.22"},
...     {"barcode": "5308443764554", "name": "Charlie", "price": "812.00"},
...     {"barcode": "5439667086587", "name": "Delta", "price": "332.18"},
...     {"barcode": "5527865721147", "name": "Echo", "price": "114.00"},
...     {"barcode": "5535686226512", "name": "Foxtrot", "price": "99.12"},
...     {"barcode": "5721668602638", "name": "Golf", "price": "123.00"},
...     {"barcode": "5776136485596", "name": "Hotel", "price": "444.40"},
...     {"barcode": "5863969679442", "name": "India", "price": "674.21"},
...     {"barcode": "5908105406923", "name": "Juliet", "price": "324.00"},
...     {"barcode": "5957751061635", "name": "Kilo", "price": "932.20"},
...     {"barcode": "6190780033092", "name": "Lima", "price": "128.00"},
...     {"barcode": "6512625994397", "name": "Mike", "price": "91.00"},
...     {"barcode": "6518235371269", "name": "November", "price": "12.00"},
...     {"barcode": "6565923118590", "name": "Oscar", "price": "43.10"},
...     {"barcode": "6650630136545", "name": "Papa", "price": "112.00"},
...     {"barcode": "6692669560199", "name": "Quebec", "price": "997.10"},
...     {"barcode": "6711341590108", "name": "Romeo", "price": "1337.00"},
...     {"barcode": "6816011714454", "name": "Sierra", "price": "998.10"},
...     {"barcode": "7050114819954", "name": "Tango", "price": "123.00"},
...     {"barcode": "7251625012784", "name": "Uniform", "price": "564.99"},
...     {"barcode": "7251925199277", "name": "Victor", "price": "990.50"},
...     {"barcode": "7283004100423", "name": "Whisky", "price": "881.89"},
...     {"barcode": "7309682004683", "name": "X-Ray", "price": "123.63"},
...     {"barcode": "7324670042560", "name": "Zulu", "price": "311.00"}
... ]

>>> DATA_ORDERS = [
...     {"customer": "alice@example.com", "product": "Sierra"},
...     {"customer": "alice@example.com", "product": "Victor"},
...     {"customer": "eve@example.org", "product": "Delta"},
...     {"customer": "bob@example.com", "product": "November"},
...     {"customer": "carol@example.com", "product": "Mike"},
...     {"customer": "alice@example.com", "product": "Bravo"},
...     {"customer": "alice@example.com", "product": "Kilo"},
...     {"customer": "dave@example.org", "product": "Victor"},
...     {"customer": "eve@example.org", "product": "Romeo"},
...     {"customer": "eve@example.org", "product": "Whisky"},
...     {"customer": "mallory@example.net", "product": "Zulu"},
...     {"customer": "alice@example.com", "product": "Romeo"},
...     {"customer": "dave@example.org", "product": "Romeo"},
...     {"customer": "eve@example.org", "product": "Victor"},
...     {"customer": "eve@example.org", "product": "Whisky"},
...     {"customer": "bob@example.com", "product": "Whisky"},
...     {"customer": "carol@example.com", "product": "Mike"},
...     {"customer": "alice@example.com", "product": "November"},
...     {"customer": "alice@example.com", "product": "Kilo"},
...     {"customer": "dave@example.org", "product": "Bravo"},
...     {"customer": "eve@example.org", "product": "X-Ray"},
...     {"customer": "dave@example.org", "product": "Romeo"},
...     {"customer": "eve@example.org", "product": "Victor"},
...     {"customer": "eve@example.org", "product": "India"},
...     {"customer": "bob@example.com", "product": "Juliet"},
...     {"customer": "carol@example.com", "product": "Foxtrot"},
...     {"customer": "dave@example.org", "product": "Victor"},
...     {"customer": "eve@example.org", "product": "Romeo"},
...     {"customer": "eve@example.org", "product": "Whisky"},
...     {"customer": "mallory@example.net", "product": "Zulu"},
...     {"customer": "alice@example.com", "product": "Alfa"},
...     {"customer": "dave@example.org", "product": "Romeo"},
...     {"customer": "eve@example.org", "product": "Quebec"},
... ]

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)

../_images/about-references-crew-martian.jpg

>>> 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

https://github.com/scikit-learn/scikit-learn/blob/main/sklearn/datasets/data/iris.csv

Iris flower species:

../_images/about-references-iris-species.jpg

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 launch
1961-04-12 06:07:00 UTC - Yuri Gagarin's launch
1969-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

Table 4. Addresses used in a book
name	street	city	postcode	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": "Alice", "lastname": "Apricot", "addresses": [
        {"street": "2101 E NASA Pkwy", "city": "Houston", "postcode": "77058", "region": "Texas", "country": "USA"}
    ]},

    {"firstname": "Bob", "lastname": "Blackthorn", "addresses": [
        {"street": "", "city": "Kennedy Space Center", "postcode": "32899", "region": "Florida", "country": "USA"}
    ]},

    {"firstname": "Carol", "lastname": "Corn", "addresses": [
        {"street": "4800 Oak Grove Dr", "city": "Pasadena", "postcode": "91109", "region": "California", "country": "USA"},
        {"street": "2825 E Ave P", "city": "Palmdale", "postcode": "93550", "region": "California", "country": "USA"}
    ]},

    {"firstname": "Dave", "lastname": "Durian", "addresses": [
        {"street": "Linder Hoehe", "city": "Cologne", "postcode": "51147", "region": "North Rhine-Westphalia", "country": "Germany"}
    ]},

    {"firstname": "Eve", "lastname": "Elderberry", "addresses": [
        {"street": "", "city": "Космодро́м Байкону́р", "postcode": "", "region": "Кызылординская область", "country": "Қазақстан"},
        {"street": "", "city": "Звёздный городо́к", "postcode": "141160", "region": "Московская область", "country": "Россия"}
    ]},

    {"firstname": "Mallory", "lastname": "Melon", "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"""