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

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

Ares 3 data:

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

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:

>>> DATA = [
...     ('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 3. Addresses used in a book
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"""