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

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

2000-01-01

True

users,staff

Bob

Blackthorn

31

1001

bob

qwerty

bob@example.com

True

True

False

2000-01-02

True

users,staff

Carol

Corn

32

1002

carol

123456

carol@example.com

True

False

False

2000-01-03

True

users

Dave

Durian

33

1003

dave

abc123

dave@example.org

True

False

False

2000-01-04

True

users

Eve

Elderberry

34

1004

eve

password1

eve@example.org

True

True

True

2000-01-05

True

users,staff,admins

Mallory

Melon

15

1005

mallory

NULL

mallory@example.net

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', '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': 'Alice', 'lastname': 'Apricot'},
...     {'firstname': 'Bob', 'lastname': 'Blackthorn'},
...     {'firstname': 'Carol', 'lastname': 'Corn'},
...     {'firstname': 'Dave', 'lastname': 'Durian'},
...     {'firstname': 'Eve', 'lastname': 'Elderberry'},
...     {'firstname': 'Mallory', 'lastname': 'Melon'},
... ]

>>> DATA = [
...     ('alice', 'secret'),
...     ('bob', 'qwerty'),
...     ('carol', '123456'),
...     ('dave', 'abc123'),
...     ('eve', 'password1'),
...     ('mallory', 'NULL'),
... ]

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

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

>>> DATA = [
...     {'firstname': 'Alice', 'lastname': 'Apricot', 'email': 'alice@example.com'},
...     {'firstname': 'Bob', 'lastname': 'Blackthorn', '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": "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, 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', 'Blackthorn'),
...     User('Carol', 'Corn'),
...     User('Dave', 'Durian'),
...     User('Eve', 'Elderberry'),
...     User('Mallory', 'Melon'),
... ]

>>> 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),
... ]

>>> 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'),
... ]

>>> DATA = [
...     User(firstname='Alice', lastname='Apricot', age=30, groups=[
...         Group('users'),
...         Group('staff'),
...     ]),
...
...     User(firstname='Bob', lastname='Blackthorn', 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,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
... """

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":[]}]"""

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

Passwd, Shadow, and Group:

>>> 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
... nobody:x:65534:65534:nobody:/nonexistent:/usr/sbin/nologin
... """

>>> 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: :::::::
... nobody:*:10957:0:99999:7:::
... """
DATA = [

# File: /etc/group ('root', '', '0', 'root'), ('daemon', '', '1', 'root,daemon'), ('bin', '', '2', 'root,bin,daemon'), ('sys', '', '3', 'root,bin,sys,adm'), ('adm', '', '4', 'root,adm,daemon'), ('users', '', '1001', 'alice,bob,carol,dave,eve'), ('staff', '', '1002', 'alice,bob,eve'), ('admins', '', '1003', 'eve'), ('nogroup', '', '65534', ''),

]

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

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

../_images/about-references-pan-twardowski.jpg

Monty Python

Iris Dataset

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'),
... ]
../_images/about-references-iris-dataset.png

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