titanic_flask.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import sqlalchemy\n",
    "from sqlalchemy import create_engine, inspect, func\n",
    "from sqlalchemy.ext.automap import automap_base\n",
    "from sqlalchemy.orm import Session\n",
    "\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Database Setup using SQLAlchmy ORM\n",
    "engine = create_engine(f\"sqlite:///titanic.sqlite\")\n",
    "Base = automap_base()\n",
    "Base.prepare(engine, reflect=True)\n",
    "\n",
    "# Map table\n",
    "Passenger = Base.classes.passenger"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "id INTEGER\n",
      "name TEXT\n",
      "pclass TEXT\n",
      "age FLOAT\n",
      "sex TEXT\n",
      "survived INTEGER\n"
     ]
    }
   ],
   "source": [
    "# check the columns\n",
    "inspector = inspect(engine)\n",
    "columns = inspector.get_columns('passenger')\n",
    "for c in columns:\n",
    "    print(c['name'], c[\"type\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[(1, 'Allen, Miss Elisabeth Walton', '1st', 29.0, 'female', 1),\n",
       " (2, 'Allison, Miss Helen Loraine', '1st', 2.0, 'female', 0),\n",
       " (3, 'Allison, Mr Hudson Joshua Creighton', '1st', 30.0, 'male', 0),\n",
       " (4, 'Allison, Mrs Hudson JC (Bessie Waldo Daniels)', '1st', 25.0, 'female', 0),\n",
       " (5, 'Allison, Master Hudson Trevor', '1st', 0.92, 'male', 1),\n",
       " (6, 'Anderson, Mr Harry', '1st', 47.0, 'male', 1),\n",
       " (7, 'Andrews, Miss Kornelia Theodosia', '1st', 63.0, 'female', 1),\n",
       " (8, 'Andrews, Mr Thomas, jr', '1st', 39.0, 'male', 0),\n",
       " (9, 'Appleton, Mrs Edward Dale (Charlotte Lamson)', '1st', 58.0, 'female', 1),\n",
       " (10, 'Artagaveytia, Mr Ramon', '1st', 71.0, 'male', 0),\n",
       " (11, 'Astor, Colonel John Jacob', '1st', 47.0, 'male', 0),\n",
       " (12, 'Astor, Mrs John Jacob (Madeleine Talmadge Force)', '1st', 19.0, 'female', 1),\n",
       " (13, 'Aubert, Mrs Leontine Pauline', '1st', None, 'female', 1),\n",
       " (14, 'Barkworth, Mr Algernon H', '1st', None, 'male', 1),\n",
       " (15, 'Baumann, Mr John D', '1st', None, 'male', 0),\n",
       " (16, 'Baxter, Mrs James (Helene DeLaudeniere Chaput)', '1st', 50.0, 'female', 1),\n",
       " (17, 'Baxter, Mr Quigg Edmond', '1st', 24.0, 'male', 0),\n",
       " (18, 'Beattie, Mr Thomson', '1st', 36.0, 'male', 0),\n",
       " (19, 'Beckwith, Mr Richard Leonard', '1st', 37.0, 'male', 1),\n",
       " (20, 'Beckwith, Mrs Richard Leonard (Sallie Monypeny)', '1st', 47.0, 'female', 1),\n",
       " (21, 'Behr, Mr Karl Howell', '1st', 26.0, 'male', 1),\n",
       " (22, 'Birnbaum, Mr Jakob', '1st', 25.0, 'male', 0),\n",
       " (23, 'Bishop, Mr Dickinson H', '1st', 25.0, 'male', 1),\n",
       " (24, 'Bishop, Mrs Dickinson H (Helen Walton)', '1st', 19.0, 'female', 1),\n",
       " (25, 'Bjornstrm-Steffansson, Mr Mauritz Hakan', '1st', 28.0, 'male', 1),\n",
       " (26, 'Blackwell, Mr Stephen Weart', '1st', 45.0, 'male', 0),\n",
       " (27, 'Blank, Mr Henry', '1st', 39.0, 'male', 1),\n",
       " (28, 'Bonnell, Miss Caroline', '1st', 30.0, 'female', 1),\n",
       " (29, 'Bonnell, Miss Elizabeth', '1st', 58.0, 'female', 1),\n",
       " (30, 'Borebank, Mr John James', '1st', None, 'male', 0),\n",
       " (31, 'Bowen, Miss Grace Scott', '1st', 45.0, 'female', 1),\n",
       " (32, 'Bowerman, Miss Elsie Edith', '1st', 22.0, 'female', 1),\n",
       " (33, 'Bradley, Mr George', '1st', None, 'male', 1),\n",
       " (34, 'Brady, Mr John Bertram', '1st', 41.0, 'male', 0),\n",
       " (35, 'Brandeis, Mr Emil', '1st', 48.0, 'male', 0),\n",
       " (36, 'Brewe, Dr Arthur Jackson', '1st', None, 'male', 0),\n",
       " (37, 'Brown, Mrs James Joseph (Margaret Molly\" Tobin)\"', '1st', 44.0, 'female', 1),\n",
       " (38, 'Brown, Mrs John Murray (Caroline Lane Lamson)', '1st', 59.0, 'female', 1),\n",
       " (39, 'Bucknell, Mrs William Robert (Emma Eliza Ward)', '1st', 60.0, 'female', 1),\n",
       " (40, 'Butt, Major Archibald Willingham', '1st', 45.0, 'male', 0),\n",
       " (41, 'Calderhead, Mr Edward P', '1st', None, 'male', 1),\n",
       " (42, 'Candee, Mrs Edward (Helen Churchill Hungerford)', '1st', 53.0, 'female', 1),\n",
       " (43, 'Cardeza, Mrs James Warburton Martinez (Charlotte Wardle Drake)', '1st', 58.0, 'female', 1),\n",
       " (44, 'Cardeza, Mr Thomas Drake Martinez', '1st', 36.0, 'male', 1),\n",
       " (45, 'Carlsson, Mr Frans Olof', '1st', 33.0, 'male', 0),\n",
       " (46, 'Carrau, Mr Francisco M', '1st', None, 'male', 0),\n",
       " (47, 'Carrau, Mr Jose Pedro', '1st', None, 'male', 0),\n",
       " (48, 'Carter, Mr William Ernest', '1st', 36.0, 'male', 1),\n",
       " (49, 'Carter, Mrs William Ernest (Lucile Polk)', '1st', 36.0, 'female', 1),\n",
       " (50, 'Carter, Miss Lucile Polk', '1st', 14.0, 'female', 1),\n",
       " (51, 'Carter, Master William T II', '1st', 11.0, 'male', 1),\n",
       " (52, 'Case, Mr Howard Brown', '1st', 49.0, 'male', 0),\n",
       " (53, 'Cassebeer, Mrs Henry Arthur jr (Genevieve Fosdick)', '1st', None, 'female', 1),\n",
       " (54, 'Cavendish, Mr Tyrell William', '1st', 36.0, 'male', 0),\n",
       " (55, 'Cavendish, Mrs Tyrell William Julia Florence Siegel', '1st', None, 'female', 1),\n",
       " (56, 'Chaffee, Mr Herbert Fuller', '1st', 46.0, 'male', 0),\n",
       " (57, 'Chaffee, Mrs Herbert Fuller (Carrie Constance Toogood)', '1st', 47.0, 'female', 1),\n",
       " (58, 'Chambers, Mr Norman Campbell', '1st', 27.0, 'male', 1),\n",
       " (59, 'Chambers, Mrs Norman Campbell (Bertha Griggs)', '1st', 31.0, 'female', 1),\n",
       " (60, 'Cherry, Miss Gladys', '1st', None, 'female', 1),\n",
       " (61, 'Chevre, Mr Paul', '1st', None, 'male', 1),\n",
       " (62, 'Chibnall (Bowerman), Mrs Edith Martha', '1st', None, 'female', 1),\n",
       " (63, 'Chisholm, Mr Roderick Robert', '1st', None, 'male', 0),\n",
       " (64, 'Clark, Mr Walter Miller', '1st', 27.0, 'male', 0),\n",
       " (65, 'Clark, Mrs Walter Miller (Virginia McDowell)', '1st', 26.0, 'female', 1),\n",
       " (66, 'Clifford, Mr George Quincy', '1st', None, 'male', 0),\n",
       " (67, 'Colley, Mr Edward Pomeroy', '1st', None, 'male', 0),\n",
       " (68, 'Compton, Mrs Alexander Taylor (Mary Eliza Ingersoll)', '1st', 64.0, 'female', 1),\n",
       " (69, 'Compton, Mr Alexander Taylor, Jr', '1st', 37.0, 'male', 0),\n",
       " (70, 'Compton, Miss Sara Rebecca', '1st', 39.0, 'female', 1),\n",
       " (71, 'Cornell, Mrs Robert Clifford (Malvina Helen Lamson)', '1st', 55.0, 'female', 1),\n",
       " (72, 'Crafton, Mr John Bertram', '1st', None, 'male', 0),\n",
       " (73, 'Crosby, Captain Edward Gifford', '1st', 70.0, 'male', 0),\n",
       " (74, 'Crosby, Mrs Edward Gifford (Catherine Elizabeth Halstead)', '1st', 69.0, 'female', 1),\n",
       " (75, 'Crosby, Miss Harriet R', '1st', 36.0, 'female', 1),\n",
       " (76, 'Cumings, Mr John Bradley', '1st', 39.0, 'male', 0),\n",
       " (77, 'Cumings, Mrs John Bradley (Florence Briggs Thayer)', '1st', 38.0, 'female', 1),\n",
       " (78, 'Daly, Mr Peter Denis ', '1st', None, 'male', 1),\n",
       " (79, 'Daniel, Mr Robert Williams', '1st', 27.0, 'male', 1),\n",
       " (80, 'Davidson, Mr Thornton', '1st', 31.0, 'male', 0),\n",
       " (81, 'Davidson, Mrs Thornton (Orian Hays)', '1st', 27.0, 'female', 1),\n",
       " (82, 'de Villiers, Madame Berthe', '1st', None, 'female', 1),\n",
       " (83, 'Dick, Mr Albert Adrian', '1st', 31.0, 'male', 1),\n",
       " (84, 'Dick, Mrs Albert Adrian Vera Gillespie', '1st', 17.0, 'female', 1),\n",
       " (85, 'Dodge, Dr Washington', '1st', None, 'male', 1),\n",
       " (86, 'Dodge, Mrs Washington (Ruth Vidaver)', '1st', None, 'female', 1),\n",
       " (87, 'Dodge, Master Washington', '1st', 4.0, 'male', 1),\n",
       " (88, 'Douglas, Mrs Frederick Charles (Suzette Baxter)', '1st', 27.0, 'female', 1),\n",
       " (89, 'Douglas, Mr Walter Donald', '1st', 50.0, 'male', 0),\n",
       " (90, 'Douglas, Mrs Walter Donald (Mahala Dutton)', '1st', 48.0, 'female', 1),\n",
       " (91, 'Duff Gordon, Sir Cosmo Edmund', '1st', 49.0, 'male', 1),\n",
       " (92, 'Duff Gordon, Lady (Lucille Wallace Sutherland)', '1st', 48.0, 'female', 1),\n",
       " (93, 'Dulles, Mr William Crothers', '1st', 39.0, 'male', 0),\n",
       " (94, 'Earnshaw, Mrs Boulton (Olive Potter)', '1st', 23.0, 'female', 1),\n",
       " (95, 'Eustis, Miss Elizabeth Mussey', '1st', 53.0, 'female', 1),\n",
       " (96, 'Evans, Miss Edith Corse', '1st', 36.0, 'female', 0),\n",
       " (97, 'Flegenheim, Mrs Alfred (Antoinette)', '1st', None, 'female', 1),\n",
       " (98, 'Flynn, Mr John Irving', '1st', None, 'male', 1),\n",
       " (99, 'Foreman, Mr Benjamin Laventall', '1st', 30.0, 'male', 0),\n",
       " (100, 'Fortune, Miss Alice Elizabeth', '1st', 24.0, 'female', 1),\n",
       " (101, 'Fortune, Mr Charles Alexander', '1st', 19.0, 'male', 0),\n",
       " (102, 'Fortune, Miss Ethel Flora', '1st', 28.0, 'female', 1),\n",
       " (103, 'Fortune, Miss Mabel', '1st', 23.0, 'female', 1),\n",
       " (104, 'Fortune, Mr Mark', '1st', 64.0, 'male', 0),\n",
       " (105, 'Fortune, Mrs Mark (Mary McDougald)', '1st', 60.0, 'female', 1),\n",
       " (106, 'Franklin, Mr Thomas Parham', '1st', None, 'male', 0),\n",
       " (107, 'Frauenthal, Dr Henry William', '1st', 49.0, 'male', 1),\n",
       " (108, 'Frauenthal, Mrs Henry William (Clara Heinsheimer)', '1st', None, 'female', 1),\n",
       " (109, 'Frauenthal, Mr Isaac Gerald', '1st', 44.0, 'male', 1),\n",
       " (110, 'Frolicher, Miss Marguerite', '1st', 22.0, 'female', 1),\n",
       " (111, 'Frolicher-Stehli, Mr Maxmillian', '1st', 60.0, 'male', 1),\n",
       " (112, 'Frolicher-Stehli, Mrs Maxmillian (Margaretha Emerentia Stehli)', '1st', 48.0, 'female', 1),\n",
       " (113, 'Futrelle, Mr Jacques', '1st', 37.0, 'male', 0),\n",
       " (114, 'Futrelle, Mrs Jacques (May Peel)', '1st', 35.0, 'female', 1),\n",
       " (115, 'Gee, Mr Arthur H', '1st', 47.0, 'male', 0),\n",
       " (116, 'Gibson, Miss Dorothy', '1st', 22.0, 'female', 1),\n",
       " (117, 'Gibson, Mrs Leonard (Pauline C Boeson)', '1st', 45.0, 'female', 1),\n",
       " (118, 'Goldenberg, Mr Samuel L', '1st', 49.0, 'male', 1),\n",
       " (119, 'Goldenberg, Mrs Samuel L (Edwiga Grabowsko)', '1st', None, 'female', 1),\n",
       " (120, 'Goldschmidt, Mr George B', '1st', 71.0, 'male', 0),\n",
       " (121, 'Gracie, Colonel Archibald IV', '1st', 54.0, 'male', 1),\n",
       " (122, 'Graham, Mr George Edward', '1st', 38.0, 'male', 0),\n",
       " (123, 'Graham, Miss Margaret Edith', '1st', 19.0, 'female', 1),\n",
       " (124, 'Graham, Mrs William Thompson (Edith Junkins)', '1st', 58.0, 'female', 1),\n",
       " (125, 'Greenfield, Mrs Leo David (Blanche Strouse)', '1st', 45.0, 'female', 1),\n",
       " (126, 'Greenfield, Mr William Bertram', '1st', 23.0, 'male', 1),\n",
       " (127, 'Guggenheim, Mr Benjamin', '1st', 46.0, 'male', 0),\n",
       " (128, 'Harder, Mr George Achilles', '1st', 25.0, 'male', 1),\n",
       " (129, 'Harder, Mrs George Achilles (Dorothy Annan)', '1st', 21.0, 'female', 1),\n",
       " (130, 'Harper, Mr Henry Sleeper', '1st', 48.0, 'male', 1),\n",
       " (131, 'Harper, Mrs Henry Sleeper (Myna Haxtun)', '1st', 49.0, 'female', 1),\n",
       " (132, 'Harris, Mr Henry Birkhardt', '1st', 45.0, 'male', 0),\n",
       " (133, 'Harris, Mrs Henry Birkhardt (Irene Wallach)', '1st', 36.0, 'female', 1),\n",
       " (134, 'Hawksford, Mr Walter James', '1st', None, 'male', 1),\n",
       " (135, 'Hays, Mr Charles Melville', '1st', 55.0, 'male', 0),\n",
       " (136, 'Hays, Mrs Charles Melville (Clara Jennings Gregg)', '1st', 52.0, 'female', 1),\n",
       " (137, 'Hays, Miss Margaret Bechstein', '1st', 24.0, 'female', 1),\n",
       " (138, 'Head, Mr Christopher', '1st', None, 'male', 0),\n",
       " (139, 'Hilliard, Mr Herbert Henry', '1st', None, 'male', 0),\n",
       " (140, 'Hipkins, Mr William Edward', '1st', None, 'male', 0),\n",
       " (141, 'Hippach, Miss Jean Gertrude', '1st', 16.0, 'female', 1),\n",
       " (142, 'Hippach, Mrs Louis Albert (Ida Sophia Fischer)', '1st', 44.0, 'female', 1),\n",
       " (143, 'Hogeboom, Mrs John C (Anna Andrews)', '1st', 51.0, 'female', 1),\n",
       " (144, 'Holverson, Mr Alexander Oskar', '1st', 42.0, 'male', 0),\n",
       " (145, 'Holverson, Mrs Alexander Oskar (Mary Aline Towner)', '1st', 35.0, 'female', 1),\n",
       " (146, 'Homer, Mr Harry', '1st', 35.0, 'male', 1),\n",
       " (147, 'Hoyt, Mr Frederick Maxfield', '1st', 38.0, 'male', 1),\n",
       " (148, 'Hoyt, Mrs Frederick Maxfield (Jane Anne Forby)', '1st', 35.0, 'female', 1),\n",
       " (149, 'Hoyt, Mr William F', '1st', None, 'male', 0),\n",
       " (150, 'Isham, Miss Anne Elizabeth', '1st', 50.0, 'female', 0),\n",
       " (151, 'Ismay, Mr Joseph Bruce', '1st', 49.0, 'male', 1),\n",
       " (152, 'Jones, Mr Charles Cresson', '1st', 46.0, 'male', 0),\n",
       " (153, 'Julian, Mr Henry Forbes', '1st', None, 'male', 0),\n",
       " (154, 'Kent, Mr Edward Austin', '1st', 58.0, 'male', 0),\n",
       " (155, 'Kenyon, Mr Frederick R', '1st', 41.0, 'male', 0),\n",
       " (156, 'Kenyon, Mrs Frederick R (Marion)', '1st', None, 'female', 1),\n",
       " (157, 'Kimball, Mr Edwin Nelson Jr', '1st', 42.0, 'male', 1),\n",
       " (158, 'Kimball, Mrs Edwin Nelson Jr (Gertrude Parsons)', '1st', 40.0, 'female', 1),\n",
       " (159, 'Klaber, Mr Herman', '1st', None, 'male', 0),\n",
       " (160, 'Leader, Dr Alice Farnham', '1st', None, 'female', 1),\n",
       " (161, 'Lewy, Mr Ervin G', '1st', None, 'male', 0),\n",
       " (162, 'Lindeberg-Lind, Mr Erik Gustaf', '1st', 42.0, 'male', 0),\n",
       " (163, 'Lindstrom, Mrs Carl Johan (Sigrid Posse)', '1st', 55.0, 'female', 1),\n",
       " (164, 'Lines, Mrs Ernest H (Elizabeth Lindsey James)', '1st', 50.0, 'female', 1),\n",
       " (165, 'Lines, Miss Mary Conover', '1st', 16.0, 'female', 1),\n",
       " (166, 'Lingrey, Mr Edward', '1st', None, 'male', 0),\n",
       " (167, 'Long, Mr Milton Clyde', '1st', 29.0, 'male', 0),\n",
       " (168, 'Longley, Miss Gretchen Fiske', '1st', 21.0, 'female', 1),\n",
       " (169, 'Loring, Mr Joseph Holland', '1st', 30.0, 'male', 0),\n",
       " (170, 'Madill, Miss Georgette Alexandra', '1st', 15.0, 'female', 1),\n",
       " (171, 'Maguire, Mr John Edward', '1st', 30.0, 'male', 0),\n",
       " (172, 'Marechal, Mr Pierre', '1st', None, 'male', 1),\n",
       " (173, 'Marvin, Mr Daniel Warner', '1st', None, 'male', 0),\n",
       " (174, 'Marvin, Mrs Daniel Warner (Mary Graham Carmichael Farquarson)', '1st', None, 'female', 1),\n",
       " (175, 'McCaffry, Mr Thomas Francis', '1st', 46.0, 'male', 0),\n",
       " (176, 'McCarthy, Mr Timothy J', '1st', 54.0, 'male', 0),\n",
       " (177, 'McGough, Mr James R', '1st', 36.0, 'male', 1),\n",
       " (178, 'Meyer, Mr Edgar Joseph', '1st', 28.0, 'male', 0),\n",
       " (179, 'Meyer, Mrs Edgar Joseph (Leila Saks)', '1st', None, 'female', 1),\n",
       " (180, 'Millet, Mr Francis Davis', '1st', 65.0, 'male', 0),\n",
       " (181, 'Minahan, Miss Daisy E', '1st', 33.0, 'female', 1),\n",
       " (182, 'Minahan, Dr William Edward', '1st', 44.0, 'male', 0),\n",
       " (183, 'Minahan, Mrs William Edward (Lillian E Thorpe)', '1st', 37.0, 'female', 1),\n",
       " (184, 'Mock, Mr Philip E', '1st', None, 'male', 1),\n",
       " (185, 'Molson, Mr Harry Markland', '1st', 55.0, 'male', 0),\n",
       " (186, 'Moore, Mr Clarence Bloomfield', '1st', 47.0, 'male', 0),\n",
       " (187, 'Natsch, Mr Charles H', '1st', 36.0, 'male', 0),\n",
       " (188, 'Newell, Mr Arthur Webster', '1st', 58.0, 'male', 0),\n",
       " (189, 'Newell, Miss Madeleine', '1st', 31.0, 'female', 1),\n",
       " (190, 'Newell, Miss Marjorie', '1st', 23.0, 'female', 1),\n",
       " (191, 'Newsom, Miss Helen Monypeny', '1st', 19.0, 'female', 1),\n",
       " (192, 'Nicholson, Mr Arthur Ernest', '1st', 64.0, 'male', 0),\n",
       " (193, 'Omont, Mr A Fernand', '1st', None, 'male', 1),\n",
       " (194, 'Ostby, Mr Engelhart Cornelius', '1st', 64.0, 'male', 0),\n",
       " (195, 'Ostby, Miss Helen Raghnild', '1st', 22.0, 'female', 1),\n",
       " (196, 'Ovies y Rodriguez, Mr Servando', '1st', 28.0, 'male', 0),\n",
       " (197, 'Parr, Mr William Henry Marsh', '1st', None, 'male', 0),\n",
       " (198, 'Partner, Mr Austin', '1st', None, 'male', 0),\n",
       " (199, 'Payne, Mr Vivian Ponsonby', '1st', 22.0, 'male', 0),\n",
       " (200, 'Pears, Mr Thomas', '1st', None, 'male', 0),\n",
       " (201, 'Pears, Mrs Thomas (Edith)', '1st', None, 'female', 1),\n",
       " (202, 'Penasco, Mr Victor de Satode', '1st', 18.0, 'male', 0),\n",
       " (203, 'Penasco, Mrs Victor de Satode (Josefa de Soto)', '1st', 17.0, 'female', 1),\n",
       " (204, 'Peuchen, Major Arthur Godfrey', '1st', 52.0, 'male', 1),\n",
       " (205, 'Porter, Mr Walter Chamberlain', '1st', 46.0, 'male', 0),\n",
       " (206, 'Potter, Mrs Thomas, Jr (Lily Alexenia Wilson)', '1st', 56.0, 'female', 1),\n",
       " (207, 'Reuchlin, Jonkheer John George', '1st', None, 'male', 0),\n",
       " (208, 'Rheims, Mr George Lucien', '1st', None, 'male', 1),\n",
       " (209, 'Robert, Mrs Edward Scott (Elisabeth Walton McMillan)', '1st', 43.0, 'female', 1),\n",
       " (210, 'Roebling, Mr Washington Augustus 2nd', '1st', 31.0, 'male', 0),\n",
       " (211, 'Romaine, Mr Charles Hallace', '1st', None, 'male', 1),\n",
       " (212, 'Rood, Mr Hugh R', '1st', None, 'male', 0),\n",
       " (213, 'Rosenbaum (Russell), Miss Edith Louise', '1st', 33.0, 'female', 1),\n",
       " (214, 'Ross, Mr John Hugo', '1st', None, 'male', 0),\n",
       " (215, 'Rothes, the Countess of (Noel Lucy Martha Dyer-Edwardes)', '1st', 27.0, 'female', 1),\n",
       " (216, 'Rothschild, Mr Martin', '1st', 55.0, 'male', 0),\n",
       " (217, 'Rothschild, Mrs Martin (Elizabeth L Barrett)', '1st', 54.0, 'female', 1),\n",
       " (218, 'Rowe, Mr Alfred G', '1st', None, 'male', 0),\n",
       " (219, 'Ryerson, Mr Arthur Larned', '1st', 61.0, 'male', 0),\n",
       " (220, 'Ryerson, Mrs Arthur Larned (Emily Maria Borie)', '1st', 48.0, 'female', 1),\n",
       " (221, 'Ryerson, Miss Emily Borie', '1st', 18.0, 'female', 1),\n",
       " (222, 'Ryerson, Master John Borie', '1st', 13.0, 'male', 1),\n",
       " (223, 'Ryerson, Miss Susan (Suzette) Parker', '1st', 21.0, 'female', 1),\n",
       " (224, 'Saalfeld, Mr Adolphe', '1st', None, 'male', 1),\n",
       " (225, 'Salomon, Mr Abraham L', '1st', None, 'male', 1),\n",
       " (226, 'Schabert, Mrs Paul (Emma Mock)', '1st', None, 'female', 1),\n",
       " (227, 'Seward, Mr Frederic Kimber', '1st', 34.0, 'male', 1),\n",
       " (228, 'Shutes, Miss Elizabeth W', '1st', 40.0, 'female', 1),\n",
       " (229, 'Silverthorne, Mr Spencer Victor', '1st', 36.0, 'male', 1),\n",
       " (230, 'Silvey, Mr William Baird', '1st', 50.0, 'male', 0),\n",
       " (231, 'Silvey, Mrs William Baird (Alice Munger)', '1st', 39.0, 'female', 1),\n",
       " (232, 'Simonius-Blumer, Col Alfons', '1st', 56.0, 'male', 1),\n",
       " (233, 'Sloper, Mr William Thompson', '1st', 28.0, 'male', 1),\n",
       " (234, 'Smart, Mr John Montgomery', '1st', 56.0, 'male', 0),\n",
       " (235, 'Smith, Mr James Clinch', '1st', 56.0, 'male', 0),\n",
       " (236, 'Smith, Mr Lucien Philip', '1st', 24.0, 'male', 0),\n",
       " (237, 'Smith, Mrs Lucien Philip (Mary Eloise Hughes', '1st', 18.0, 'female', 1),\n",
       " (238, 'Smith, Mr Richard William', '1st', None, 'male', 0),\n",
       " (239, 'Snyder, Mr John Pillsbury', '1st', 24.0, 'male', 1),\n",
       " (240, 'Snyder, Mrs John Pillsbury (Nelle Stevenson)', '1st', 23.0, 'female', 1),\n",
       " (241, 'Spedden, Mr Frederick Oakley', '1st', 45.0, 'male', 1),\n",
       " (242, 'Spedden, Mrs Frederick Oakley (Margaretta Corning Stone)', '1st', 40.0, 'female', 1),\n",
       " (243, 'Spedden, Master Robert Douglas', '1st', 6.0, 'male', 1),\n",
       " (244, 'Spencer, Mr William Augustus', '1st', 57.0, 'male', 0),\n",
       " (245, 'Spencer, Mrs William Augustus (Marie Eugenie)', '1st', None, 'female', 1),\n",
       " (246, 'Staehlin, Dr Max', '1st', 32.0, 'male', 1),\n",
       " (247, 'Stead, Mr William Thomas', '1st', 62.0, 'male', 0),\n",
       " (248, 'Stengel, Mr Charles Emil Henry', '1st', 54.0, 'male', 1),\n",
       " (249, 'Stengel, Mrs Charles Emil Henry (Annie May Morris)', '1st', 43.0, 'female', 1),\n",
       " (250, 'Stephenson, Mrs Walter Bertram (Martha Eustis)', '1st', 52.0, 'female', 1),\n",
       " (251, 'Stewart, Mr Albert A', '1st', None, 'male', 0),\n",
       " (252, 'Stone, Mrs George Nelson (Martha E)', '1st', 62.0, 'female', 1),\n",
       " (253, 'Straus, Mr Isidor', '1st', 67.0, 'male', 0),\n",
       " (254, 'Straus, Mrs Isidor (Ida Blun)', '1st', 63.0, 'female', 0),\n",
       " (255, 'Sutton, Mr Frederick', '1st', 61.0, 'male', 0),\n",
       " (256, 'Swift, Mrs Frederick Joel (Margaret Welles Barron)', '1st', 46.0, 'female', 1),\n",
       " (257, 'Taussig, Mr Emil', '1st', 52.0, 'male', 0),\n",
       " (258, 'Taussig, Mrs Emil (Tillie Mandelbaum)', '1st', 39.0, 'female', 1),\n",
       " (259, 'Taussig, Miss Ruth', '1st', 18.0, 'female', 1),\n",
       " (260, 'Taylor, Mr Elmer Zebley', '1st', 48.0, 'male', 1),\n",
       " (261, 'Taylor, Mrs Elmer Zebley (Juliet Cummins Wright)', '1st', None, 'female', 1),\n",
       " (262, 'Thayer, Mr John Borland', '1st', 49.0, 'male', 0),\n",
       " (263, 'Thayer, Mrs John Borland (Marian Longstreth Morris)', '1st', 39.0, 'female', 1),\n",
       " (264, 'Thayer, Mr John Borland, jr', '1st', 17.0, 'male', 1),\n",
       " (265, 'Thorne, Mr George (alias of: Mr George Rosenshine)', '1st', 46.0, 'male', 0),\n",
       " (266, 'Thorne, Mrs Gertrude Maybelle', '1st', None, 'female', 1),\n",
       " (267, 'Tucker, Mr Gilbert Milligan, jr', '1st', 31.0, 'male', 1),\n",
       " (268, 'Uruchurtu, Mr Manuel E', '1st', None, 'male', 0),\n",
       " (269, 'Van Derhoef, Mr Wyckoff', '1st', 61.0, 'male', 0),\n",
       " (270, 'Walker, Mr William Anderson', '1st', 47.0, 'male', 0),\n",
       " (271, 'Warren, Mr Frank Manley', '1st', 64.0, 'male', 0),\n",
       " (272, 'Warren, Mrs Frank Manley (Anna S Atkinson)', '1st', 60.0, 'female', 1),\n",
       " (273, 'Weir, Col John', '1st', 60.0, 'male', 0),\n",
       " (274, 'White, Mrs J Stuart (Ella Holmes)', '1st', 55.0, 'female', 1),\n",
       " (275, 'White, Mr Percival Wayland', '1st', 54.0, 'male', 0),\n",
       " (276, 'White, Mr Richard Frasar', '1st', 21.0, 'male', 0),\n",
       " (277, 'Wick, Mr George Dennick', '1st', 57.0, 'male', 0),\n",
       " (278, 'Wick, Mrs George Dennick (Martha Hitchcock)', '1st', 45.0, 'female', 1),\n",
       " (279, 'Wick, Miss Mary Natalie', '1st', 31.0, 'female', 1),\n",
       " (280, 'Widener, Mr George Dunton', '1st', 50.0, 'male', 0),\n",
       " (281, 'Widener, Mrs George Dunton (Eleanor Elkins)', '1st', 50.0, 'female', 1),\n",
       " (282, 'Widener, Mr Harry Elkins', '1st', 27.0, 'male', 0),\n",
       " (283, 'Willard, Miss Constance', '1st', 20.0, 'female', 1),\n",
       " (284, 'Williams, Mr Charles Duane', '1st', 51.0, 'male', 0),\n",
       " (285, 'Williams, Mr Fletcher Lambert', '1st', None, 'male', 0),\n",
       " (286, 'Williams, Mr Richard Norris II', '1st', 21.0, 'male', 1),\n",
       " (287, 'Woolner, Mr Hugh', '1st', None, 'male', 1),\n",
       " (288, 'Wright, Mr George', '1st', None, 'male', 0),\n",
       " (289, 'Young, Miss Marie Grice', '1st', 36.0, 'female', 1),\n",
       " (290, 'Barber, Ms ', '1st', None, 'female', 1),\n",
       " (291, 'Bazzani, Ms Albina', '1st', None, 'female', 1),\n",
       " (292, 'Bidois, Miss Rosalie', '1st', None, 'female', 1),\n",
       " (293, 'Bird, Ms Ellen', '1st', None, 'female', 1),\n",
       " (294, 'Bissetti, Ms Amelia', '1st', None, 'female', 1),\n",
       " (295, 'Burns, Ms Elizabeth Margaret', '1st', None, 'female', 1),\n",
       " (296, 'Chaudanson, Ms \\tVictorine', '1st', None, 'female', 1),\n",
       " (297, 'Cleaver, Ms Alice', '1st', None, 'female', 1),\n",
       " (298, 'Daniels, Ms Sarah', '1st', None, 'female', 1),\n",
       " (299, 'Endres, Miss Caroline Louise', '1st', None, 'female', 1),\n",
       " (300, 'Farthing, Mr John', '1st', None, 'male', 0),\n",
       " (301, 'Fleming, Ms Margaret', '1st', None, 'female', 0),\n",
       " (302, 'Francatelli, Ms Laura Mabel', '1st', None, 'female', 1),\n",
       " (303, 'Fry, Mr Richard', '1st', None, 'male', 0),\n",
       " (304, 'Geiger, Miss Emily ', '1st', None, 'female', 1),\n",
       " (305, 'Giglio, Mr Victor', '1st', None, 'male', 0),\n",
       " (306, 'Harrington, Mr Charles', '1st', None, 'male', 0),\n",
       " (307, 'Harrison, Mr William \\tHenry', '1st', 40.0, 'male', 0),\n",
       " (308, 'Hassah, Mr Hamad', '1st', None, 'male', 0),\n",
       " (309, 'Icabad (Icabod), Ms', '1st', None, 'female', 1),\n",
       " (310, 'Keeping, Mr Edwin', '1st', 32.0, 'male', 0),\n",
       " (311, 'Kenchen, Ms Amelia', '1st', None, 'female', 1),\n",
       " (312, 'LeRoy, Miss Berthe', '1st', None, 'female', 1),\n",
       " (313, 'Lesneur, Mr Gustave', '1st', None, 'male', 0),\n",
       " (314, 'Maloney, Ms', '1st', None, 'female', 1),\n",
       " (315, 'Oliva, Mlle', '1st', None, 'female', 0),\n",
       " (316, 'Pericault, Ms', '1st', None, 'female', 1),\n",
       " (317, 'Ringhini, Mr Sante', '1st', 33.0, 'male', 0),\n",
       " (318, 'Robbins, Mr Victor', '1st', None, 'male', 0),\n",
       " (319, 'Segesser, Mlle Emma', '1st', None, 'female', 1),\n",
       " (320, 'Seredeca, Ms', '1st', None, 'female', 0),\n",
       " (321, 'Ward, Ms Anna', '1st', None, 'female', 0),\n",
       " (322, 'Wilson, Ms Helen', '1st', None, 'female', 1),\n",
       " (323, 'Abelson, Mr Samuel', '2nd', 30.0, 'male', 0),\n",
       " (324, 'Abelson, Mrs Samuel (Anna)', '2nd', 28.0, 'female', 1),\n",
       " (325, 'Andrew, Mr Edgar Samuel', '2nd', 18.0, 'male', 0),\n",
       " (326, 'Andrew, Mr Frank', '2nd', None, 'male', 0),\n",
       " (327, 'Angle, Mr William A', '2nd', 34.0, 'male', 0),\n",
       " (328, 'Angle, Mrs William A (Florence)', '2nd', 32.0, 'female', 1),\n",
       " (329, 'Ashby, Mr John', '2nd', 57.0, 'male', 0),\n",
       " (330, 'Bailey, Mr Percy Andrew', '2nd', 18.0, 'male', 0),\n",
       " (331, 'Baimbrigge, Mr Charles R', '2nd', 23.0, 'male', 0),\n",
       " (332, 'Balls, Mrs Ada E Hall', '2nd', 36.0, 'female', 1),\n",
       " (333, 'Banfield, Mr Frederick J', '2nd', 28.0, 'male', 0),\n",
       " (334, 'Bateman, Rev Robert James', '2nd', 51.0, 'male', 0),\n",
       " (335, 'Beane, Mr Edward', '2nd', 32.0, 'male', 1),\n",
       " (336, 'Beane, Mrs Edward (Ethel Clarke)', '2nd', 19.0, 'female', 1),\n",
       " (337, 'Beauchamp, Mr Henry James', '2nd', 28.0, 'male', 0),\n",
       " (338, 'Becker, Mrs Allen Oliver (Nellie E Baumgardner)', '2nd', 36.0, 'female', 1),\n",
       " (339, 'Becker, Miss Marion Louise', '2nd', 4.0, 'female', 1),\n",
       " (340, 'Becker, Master Richard F', '2nd', 1.0, 'male', 1),\n",
       " (341, 'Becker, Miss Ruth Elizabeth', '2nd', 12.0, 'female', 1),\n",
       " (342, 'Beesley, Mr Lawrence', '2nd', 34.0, 'male', 1),\n",
       " (343, 'Bentham, Miss Lilian W', '2nd', 19.0, 'female', 1),\n",
       " (344, 'Berriman, Mr William S', '2nd', 23.0, 'male', 0),\n",
       " (345, 'Botsford, Mr William Hull', '2nd', 26.0, 'male', 0),\n",
       " (346, 'Bowenur, Mr Solomon', '2nd', None, 'male', 0),\n",
       " (347, 'Bracken, Mr James H', '2nd', 27.0, 'male', 0),\n",
       " (348, 'Brown, Miss Edith E', '2nd', 15.0, 'female', 1),\n",
       " (349, 'Brown, Mr Thomas William Solomon', '2nd', 45.0, 'male', 0),\n",
       " (350, 'Brown, Mrs Thomas William Solomon (Elizabeth C)', '2nd', 40.0, 'female', 1),\n",
       " (351, 'Bryhl, Miss Dagmar', '2nd', 20.0, 'female', 1),\n",
       " (352, 'Bryhl, Mr Kurt Arnold Gottfrid', '2nd', 25.0, 'male', 0),\n",
       " (353, 'Buss, Miss Kate', '2nd', 36.0, 'female', 1),\n",
       " (354, 'Butler, Mr Reginald Fenton', '2nd', 25.0, 'male', 0),\n",
       " (355, 'Byles, Rev Thomas Roussel D', '2nd', None, 'male', 0),\n",
       " (356, 'Bystrom, Mrs Carolina', '2nd', 42.0, 'female', 1),\n",
       " (357, 'Caldwell, Mr Albert Francis', '2nd', 26.0, 'male', 1),\n",
       " (358, 'Caldwell, Mrs Albert Francis (Sylvia Mae Harbaugh)', '2nd', 26.0, 'female', 1),\n",
       " (359, 'Caldwell, Master Alden Gates', '2nd', 0.83, 'male', 1),\n",
       " (360, 'Cameron, Miss Clear', '2nd', 31.0, 'female', 1),\n",
       " (361, 'Campbell, Mr William', '2nd', None, 'male', 0),\n",
       " (362, 'Carbines, Mr William', '2nd', 19.0, 'male', 0),\n",
       " (363, 'Carter, Rev Ernest Courtenay', '2nd', 54.0, 'male', 0),\n",
       " (364, 'Carter, Mrs Ernest Courtenay (Lillian Hughes)', '2nd', 44.0, 'female', 0),\n",
       " (365, 'Chapman, Mr Charles Henry', '2nd', 52.0, 'male', 0),\n",
       " (366, 'Chapman, Mr John Henry', '2nd', 30.0, 'male', 0),\n",
       " (367, 'Chapman, Mrs John Henry (Elizabeth Lawry)', '2nd', 30.0, 'female', 0),\n",
       " (368, 'Christy, Mrs Alice Frances', '2nd', None, 'female', 1),\n",
       " (369, 'Christy, Miss Julie', '2nd', None, 'female', 1),\n",
       " (370, 'Clarke, Mr Charles V', '2nd', 29.0, 'male', 0),\n",
       " (371, 'Clarke, Mrs Charles V (Ada Maria)', '2nd', None, 'female', 1),\n",
       " (372, 'Coleridge, Mr Reginald Charles', '2nd', 29.0, 'male', 0),\n",
       " (373, 'Collander, Mr Erik', '2nd', 27.0, 'male', 0),\n",
       " (374, 'Collett, Mr Sidney C Stuart', '2nd', 24.0, 'male', 1),\n",
       " (375, 'Collyer, Mr Harvey', '2nd', 35.0, 'male', 0),\n",
       " (376, 'Collyer, Mrs Harvey (Charlotte Tate)', '2nd', 31.0, 'female', 1),\n",
       " (377, 'Collyer, Miss Marjorie', '2nd', 8.0, 'female', 1),\n",
       " (378, 'Cook, Mrs Selena Rogers', '2nd', 22.0, 'female', 0),\n",
       " (379, 'Corbett, Mrs Walter H (Irene Colvin)', '2nd', 30.0, 'female', 0),\n",
       " (380, 'Corey, Mrs Percy C (Mary Phyllis Elizabeth Miller)', '2nd', None, 'female', 0),\n",
       " (381, 'Cotterill, Mr Harry', '2nd', 20.0, 'male', 0),\n",
       " (382, 'Cunningham, Mr Alfred Fleming', '2nd', None, 'male', 0),\n",
       " (383, 'Davies, Mr Charles Henry', '2nd', 21.0, 'male', 0),\n",
       " (384, 'Davis, Mrs Agnes', '2nd', 49.0, 'female', 1),\n",
       " (385, 'Davis, Master John Morgan', '2nd', 8.0, 'male', 1),\n",
       " (386, 'Davis, Miss Mary', '2nd', 28.0, 'female', 1),\n",
       " (387, 'Deacon, Mr Percy', '2nd', 18.0, 'male', 0),\n",
       " (388, 'de Brito, Mr Jose Joaquim', '2nd', None, 'male', 0),\n",
       " (389, 'del Carlo, Mr Sebastiano', '2nd', 28.0, 'male', 0),\n",
       " (390, 'del Carlo, Mrs Sebastiano (Argenia Genovese)', '2nd', 22.0, 'female', 1),\n",
       " (391, 'Denbury, Mr Herbert', '2nd', 25.0, 'male', 0),\n",
       " (392, 'Dibden, Mr William', '2nd', 18.0, 'male', 0),\n",
       " (393, 'Doling, Mrs Ada', '2nd', 32.0, 'female', 1),\n",
       " (394, 'Doling, Miss Elsie', '2nd', 18.0, 'female', 1),\n",
       " (395, 'Downton (?Douton), Mr William James', '2nd', None, 'male', 0),\n",
       " (396, 'Drew, Mr James Vivian', '2nd', 42.0, 'male', 0),\n",
       " (397, 'Drew, Mrs James Vivian (Lulu Thorne Christian)', '2nd', 34.0, 'female', 1),\n",
       " (398, 'Drew, Master Marshall Brines', '2nd', 8.0, 'male', 1),\n",
       " (399, 'Duran y More, Miss Asuncion', '2nd', None, 'female', 1),\n",
       " (400, 'Duran y More, Miss Florentina', '2nd', None, 'female', 1),\n",
       " (401, 'Eitemiller, Mr George Floyd', '2nd', 23.0, 'male', 0),\n",
       " (402, 'Enander, Mr Ingvar', '2nd', 21.0, 'male', 0),\n",
       " (403, 'Fahlstrom, Mr Arne Jonas', '2nd', 19.0, 'male', 0),\n",
       " (404, 'Faunthorpe, Mr Harry', '2nd', None, 'male', 0),\n",
       " (405, 'Faunthorpe, Mrs Lizzie (see Wilkinson, E)', '2nd', None, 'female', 1),\n",
       " (406, 'Fillbrook, Mr Charles', '2nd', None, 'male', 0),\n",
       " (407, 'Fox, Mr Stanley H', '2nd', 38.0, 'male', 0),\n",
       " (408, 'Frost, Mr Anthony (Archie) W', '2nd', None, 'male', 0),\n",
       " (409, 'Funk, Miss Annie C', '2nd', 38.0, 'female', 0),\n",
       " (410, 'Fynney, Mr Joseph J', '2nd', 35.0, 'male', 0),\n",
       " (411, 'Gale, Mr Harry', '2nd', 35.0, 'male', 0),\n",
       " (412, 'Gale, Mr Shadrach', '2nd', 38.0, 'male', 0),\n",
       " (413, 'Garside, Miss Ethel', '2nd', 24.0, 'female', 1),\n",
       " (414, 'Gaskell, Mr Alfred', '2nd', 16.0, 'male', 0),\n",
       " (415, 'Gavey, Mr Lawrence', '2nd', 26.0, 'male', 0),\n",
       " (416, 'Gilbert, Mr William', '2nd', 45.0, 'male', 0),\n",
       " (417, 'Giles, Mr Edgar', '2nd', 24.0, 'male', 0),\n",
       " (418, 'Giles, Mr Frederick', '2nd', 21.0, 'male', 0),\n",
       " (419, 'Giles, Mr Ralph', '2nd', 22.0, 'male', 0),\n",
       " (420, 'Gill, Mr John W', '2nd', None, 'male', 0),\n",
       " (421, 'Gillespie, Mr William', '2nd', 34.0, 'male', 0),\n",
       " (422, 'Givard, Mr Hans Christensen', '2nd', 30.0, 'male', 0),\n",
       " (423, 'Greenberg, Mr Samuel', '2nd', 50.0, 'male', 0),\n",
       " (424, 'Hale, Mr Reginald', '2nd', 30.0, 'male', 0),\n",
       " (425, 'Hamalainen, Mrs William (Anna)', '2nd', 23.0, 'female', 1),\n",
       " (426, 'Hamalainen, Master Viljo', '2nd', 1.0, 'male', 1),\n",
       " (427, 'Harbeck, Mr William H', '2nd', 44.0, 'male', 0),\n",
       " (428, 'Harper, Rev John', '2nd', 28.0, 'male', 0),\n",
       " (429, 'Harper, Miss Nina', '2nd', 6.0, 'female', 1),\n",
       " (430, 'Harris, Mr George', '2nd', 30.0, 'male', 1),\n",
       " (431, 'Harris, Mr Walter', '2nd', None, 'male', 0),\n",
       " (432, 'Hart, Mr Benjamin', '2nd', 43.0, 'male', 0),\n",
       " (433, 'Hart, Mrs Benjamin (Esther)', '2nd', 45.0, 'female', 1),\n",
       " (434, 'Hart, Miss Eva Miriam', '2nd', 7.0, 'female', 1),\n",
       " (435, 'Herman, Miss Alice', '2nd', 24.0, 'female', 1),\n",
       " (436, 'Herman, Miss Kate', '2nd', 24.0, 'female', 1),\n",
       " (437, 'Herman, Mr Samuel', '2nd', 49.0, 'male', 0),\n",
       " (438, 'Herman, Mrs Samuel (Jane Laver)', '2nd', 48.0, 'female', 1),\n",
       " (439, 'Hewlett, Mrs Mary D', '2nd', None, 'female', 1),\n",
       " (440, 'Hickman, Mr Leonard Mark', '2nd', 34.0, 'male', 0),\n",
       " (441, 'Hickman, Mr Lewis', '2nd', 32.0, 'male', 0),\n",
       " (442, 'Hickman, Mr Stanley George', '2nd', 21.0, 'male', 0),\n",
       " (443, 'Hiltunen, Miss Marta', '2nd', 18.0, 'female', 0),\n",
       " (444, 'Hocking, Mrs Elizabeth', '2nd', 53.0, 'female', 1),\n",
       " (445, 'Hocking, Mr George', '2nd', 23.0, 'male', 0),\n",
       " (446, 'Hocking, Miss Ellen (Nellie)', '2nd', 21.0, 'female', 1),\n",
       " (447, 'Hocking, Mr Samuel James', '2nd', None, 'male', 0),\n",
       " (448, 'Hodges, Mr Henry Price', '2nd', 52.0, 'male', 0),\n",
       " (449, 'Hold, Mr Stephen', '2nd', 42.0, 'male', 0),\n",
       " (450, 'Hold, Mrs Stephen (Annie Margaret)', '2nd', 36.0, 'female', 1),\n",
       " (451, 'Hood, Mr Ambrose, Jr', '2nd', 21.0, 'male', 0),\n",
       " (452, 'Hosono, Mr Masafumi', '2nd', 41.0, 'male', 1),\n",
       " (453, 'Howard, Mr Benjamin', '2nd', None, 'male', 0),\n",
       " (454, 'Howard, Mrs Benjamin (Ellen Truelove)', '2nd', None, 'female', 0),\n",
       " (455, 'Hunt, Mr George Henry', '2nd', 33.0, 'male', 0),\n",
       " (456, 'Ilett, Miss Bertha', '2nd', 17.0, 'female', 1),\n",
       " (457, 'Jacobsohn Mr Sidney Samuel', '2nd', None, 'male', 0),\n",
       " (458, 'Jacobsohn, Mrs Sidney Samuel (Amy Frances Christy)', '2nd', None, 'female', 1),\n",
       " (459, 'Jarvis, Mr John Denzil', '2nd', None, 'male', 0),\n",
       " (460, 'Jefferys, Mr Clifford', '2nd', None, 'male', 0),\n",
       " (461, 'Jefferys, Mr Ernest', '2nd', None, 'male', 0),\n",
       " (462, 'Jenkin, Mr Stephen Curnow', '2nd', None, 'male', 0),\n",
       " (463, 'Jerwan, Mrs Amin S (Marie Thuillard)', '2nd', 23.0, 'female', 1),\n",
       " (464, 'Kantor, Mr Sinai', '2nd', 34.0, 'male', 0),\n",
       " (465, 'Kantor, Mrs Sinai (Miriam Sternim)', '2nd', None, 'female', 1),\n",
       " (466, 'Karnes, Mrs J Frank (Claire Bennett)', '2nd', 22.0, 'female', 0),\n",
       " (467, 'Keane, Mr Daniel', '2nd', None, 'male', 0),\n",
       " (468, 'Keane, Miss Nora A', '2nd', None, 'female', 1),\n",
       " (469, 'Kelly, Mrs Florence (Fannie)', '2nd', 45.0, 'female', 1),\n",
       " (470, 'Kirkland, Rev Charles Leonard', '2nd', None, 'male', 0),\n",
       " (471, 'Knight, Mr Robert', '2nd', None, 'male', 0),\n",
       " (472, 'Kvillner, Mr Johan Henrik Johannesson', '2nd', 31.0, 'male', 0),\n",
       " (473, 'Lahtinen, Rev William', '2nd', 30.0, 'male', 0),\n",
       " (474, 'Lahtinen, Mrs William (Anna Sylvan)', '2nd', 26.0, 'female', 0),\n",
       " (475, 'Lamb, Mr John James', '2nd', None, 'male', 0),\n",
       " (476, 'Lemore, Mrs Amelia', '2nd', 34.0, 'female', 1),\n",
       " (477, 'LaRoche, Mr Joseph', '2nd', 26.0, 'male', 0),\n",
       " (478, 'LaRoche, Mrs Joseph (Juliet)', '2nd', 22.0, 'female', 1),\n",
       " (479, 'LaRoche, Miss Louise', '2nd', 1.0, 'female', 1),\n",
       " (480, 'LaRoche, Miss Simonne', '2nd', 3.0, 'female', 1),\n",
       " (481, 'Lehmann, Miss Bertha', '2nd', None, 'female', 1),\n",
       " (482, 'Leitch, Miss Jessie', '2nd', None, 'female', 1),\n",
       " (483, 'Levy, Mr Rene Jacques', '2nd', None, 'male', 0),\n",
       " (484, 'Leyson, Mr Robert William Norman', '2nd', 25.0, 'male', 0),\n",
       " (485, 'Lingan, Mr John', '2nd', None, 'male', 0),\n",
       " (486, 'Louch, Mr Charles Alexander', '2nd', 48.0, 'male', 0),\n",
       " (487, 'Louch, Mrs Charles Alexander (Alice Adelaide)', '2nd', None, 'female', 1),\n",
       " (488, 'Mack, Mrs Mary', '2nd', 57.0, 'female', 0),\n",
       " (489, 'Malachard, Mr Noel', '2nd', None, 'male', 0),\n",
       " (490, 'Mallet, Mr Albert', '2nd', None, 'male', 0),\n",
       " (491, 'Mallet, Mrs Albert (Antoinette)', '2nd', None, 'female', 1),\n",
       " (492, 'Mallet, Master Andre', '2nd', 2.0, 'male', 1),\n",
       " (493, 'Mangiavacchi, Mr Serafino Emilio', '2nd', None, 'male', 0),\n",
       " (494, 'Mantvila, Rev Joseph', '2nd', 27.0, 'male', 0),\n",
       " (495, 'Marshall, Mrs Kate Louise Phillips', '2nd', 19.0, 'female', 1),\n",
       " (496, 'Matthews, Mr William John', '2nd', 30.0, 'male', 0),\n",
       " (497, 'Maybery, Mr Frank H', '2nd', 20.0, 'male', 0),\n",
       " (498, 'McCrae, Mr Arthur Gordon', '2nd', 45.0, 'male', 0),\n",
       " (499, 'McCrie, Mr James Matthew', '2nd', None, 'male', 0),\n",
       " (500, 'McKane, Mr Peter D', '2nd', 46.0, 'male', 0),\n",
       " (501, 'Mellenger, Mrs Elizabeth Anne', '2nd', 41.0, 'female', 1),\n",
       " (502, 'Mellenger, Miss Madeleine Violet', '2nd', 13.0, 'female', 1),\n",
       " (503, 'Mellor, Mr William John', '2nd', 19.0, 'male', 1),\n",
       " (504, 'Meyer, Mr August', '2nd', 30.0, 'male', 0),\n",
       " (505, 'Milling, Mr Jacob Christian', '2nd', 48.0, 'male', 0),\n",
       " (506, 'Mitchell, Mr Henry Michael', '2nd', 71.0, 'male', 0),\n",
       " (507, 'Moraweck, Dr Ernest', '2nd', 54.0, 'male', 0),\n",
       " (508, 'Morley, Mr William', '2nd', None, 'male', 0),\n",
       " (509, 'Mudd, Mr Thomas C', '2nd', None, 'male', 0),\n",
       " (510, 'Myles, Mr Thomas Francis', '2nd', 64.0, 'male', 0),\n",
       " (511, 'Nasser (Nasrallah), Mr Nicholas', '2nd', 32.0, 'male', 0),\n",
       " (512, 'Nasser (Nasrallah), Mrs Nicholas', '2nd', 18.0, 'female', 1),\n",
       " (513, 'Navratil, Master Edmond Roger', '2nd', 2.0, 'male', 1),\n",
       " (514, 'Navratil, Mr Michel', '2nd', 32.0, 'male', 0),\n",
       " (515, 'Navratil, Master Michel M', '2nd', 3.0, 'male', 1),\n",
       " (516, 'Nesson, Mr Israel', '2nd', 26.0, 'male', 0),\n",
       " (517, 'Nicholls, Mr Joseph Charles', '2nd', 19.0, 'male', 0),\n",
       " (518, 'Norman, Mr Robert Douglas', '2nd', None, 'male', 0),\n",
       " (519, 'Nourney, Mr Alfred (aka Baron von Drachstedt)', '2nd', 20.0, 'male', 1),\n",
       " (520, 'Nye, Mrs Elizabeth Ramell', '2nd', 29.0, 'female', 1),\n",
       " (521, 'Otter, Mr Richard', '2nd', 39.0, 'male', 0),\n",
       " (522, 'Oxenham, Mr Percy Thomas', '2nd', 22.0, 'male', 1),\n",
       " (523, 'Padro y Manent, Mr Julian', '2nd', None, 'male', 1),\n",
       " (524, 'Pain, Dr Alfred', '2nd', 24.0, 'male', 0),\n",
       " (525, 'Pallas y Castello, Mr Emilio', '2nd', None, 'male', 1),\n",
       " (526, 'Parker, Mr Clifford R', '2nd', 28.0, 'male', 0),\n",
       " (527, 'Parkes, Mr Francis (Frank)', '2nd', None, 'male', 0),\n",
       " (528, 'Parrish, Mrs Lutie Davis', '2nd', 50.0, 'female', 1),\n",
       " (529, 'Pengelly, Mr Frederick', '2nd', 20.0, 'male', 0),\n",
       " (530, 'Peruschitz, Rev Joseph M', '2nd', 40.0, 'male', 0),\n",
       " (531, 'Phillips, Miss Alice', '2nd', 42.0, 'female', 1),\n",
       " (532, 'Phillips, Mr Robert', '2nd', 21.0, 'male', 0),\n",
       " (533, 'Pinsky, Miss Rosa', '2nd', 32.0, 'female', 1),\n",
       " (534, 'Ponesell, Mr Martin', '2nd', 34.0, 'male', 0),\n",
       " (535, 'Portaluppi, Mr Emilio', '2nd', None, 'male', 1),\n",
       " (536, 'Pulbaum, Mr Frank', '2nd', None, 'male', 0),\n",
       " (537, 'Quick, Mrs Frederick C (Jane Richards)', '2nd', 33.0, 'female', 1),\n",
       " (538, 'Quick, Miss Phyllis May', '2nd', 2.0, 'female', 1),\n",
       " (539, 'Quick, Miss Winifred Vera', '2nd', 8.0, 'female', 1),\n",
       " (540, 'Reeves, Mr David', '2nd', 36.0, 'male', 0),\n",
       " (541, 'Renouf, Mr Peter Henry', '2nd', 34.0, 'male', 0),\n",
       " (542, 'Renouf, Mrs Peter Henry (Lillian Jefferys)', '2nd', 30.0, 'female', 1),\n",
       " (543, 'Reynaldo, Mrs Encarnacion', '2nd', 28.0, 'female', 1),\n",
       " (544, 'Richard, Mr Emil', '2nd', 23.0, 'male', 0),\n",
       " (545, 'Richards, Master George Sidney', '2nd', 0.8, 'male', 1),\n",
       " (546, 'Richards, Mrs Sidney (Emily Hocking)', '2nd', 25.0, 'female', 1),\n",
       " (547, 'Richards, Master William Rowe', '2nd', 3.0, 'male', 1),\n",
       " (548, 'Ridsdale, Miss Lucy', '2nd', 50.0, 'female', 1),\n",
       " (549, 'Rogers, Mr Harry', '2nd', None, 'male', 0),\n",
       " (550, 'Rugg, Miss Emily', '2nd', 21.0, 'female', 1),\n",
       " (551, 'Sedgwick, Mr Charles Frederick Waddington', '2nd', None, 'male', 0),\n",
       " (552, 'Sharp, Mr Percival', '2nd', None, 'male', 0),\n",
       " (553, 'Shelley, Mrs William (Imanita)', '2nd', 25.0, 'female', 1),\n",
       " (554, 'Silven, Miss Lyyli', '2nd', 18.0, 'female', 1),\n",
       " (555, 'Sincock, Miss Maude', '2nd', 20.0, 'female', 1),\n",
       " (556, 'Siukonnen, Miss Anna', '2nd', 30.0, 'female', 1),\n",
       " (557, 'Sjostedt, Mr Ernst Adolf', '2nd', 59.0, 'male', 0),\n",
       " (558, 'Slayter, Miss Hilda Mary', '2nd', 30.0, 'female', 1),\n",
       " (559, 'Slemen, Mr Richard James', '2nd', 35.0, 'male', 0),\n",
       " (560, 'Smith (Schmidt), Mr Augustus', '2nd', 22.0, 'male', 0),\n",
       " (561, 'Smith, Miss Marion', '2nd', None, 'female', 1),\n",
       " (562, 'Sobey, Mr Hayden', '2nd', 25.0, 'male', 0),\n",
       " (563, 'Stanton, Mr Samuel Ward', '2nd', 41.0, 'male', 0),\n",
       " (564, 'Stokes, Mr Philip Joseph', '2nd', 25.0, 'male', 0),\n",
       " (565, 'Sweet, Mr George', '2nd', 14.0, 'male', 0),\n",
       " (566, 'Toomey, Miss Ellen', '2nd', 50.0, 'female', 1),\n",
       " (567, 'Troupiansky, Mr Moses Aaron', '2nd', 22.0, 'male', 0),\n",
       " (568, 'Trout, Mrs William H (Jessie L)', '2nd', None, 'female', 1),\n",
       " (569, 'Troutt, Miss Edwina Celia', '2nd', 27.0, 'female', 1),\n",
       " (570, 'Turpin, Mr William John', '2nd', 29.0, 'male', 0),\n",
       " (571, 'Turpin, Mrs William John (Dorothy Anne Wonnacott)', '2nd', 27.0, 'female', 0),\n",
       " (572, 'Veale, Mr James', '2nd', 30.0, 'male', 0),\n",
       " (573, 'Waelens, Mr Achille', '2nd', 22.0, 'male', 0),\n",
       " (574, 'Walcroft, Miss Nellie', '2nd', 35.0, 'female', 1),\n",
       " (575, 'Ware, Mr John James', '2nd', 30.0, 'male', 0),\n",
       " (576, 'Ware, Mrs John James (Florence Louise Long)', '2nd', 28.0, 'female', 1),\n",
       " (577, 'Ware, Mr William J', '2nd', 23.0, 'male', 0),\n",
       " (578, 'Watson, Mr Ennis Hastings', '2nd', None, 'male', 0),\n",
       " (579, 'Watt, Miss Bertha', '2nd', 12.0, 'female', 1),\n",
       " (580, 'Watt, Mrs James (Bessie Inglis Milne)', '2nd', 40.0, 'female', 1),\n",
       " (581, 'Webber, Miss Susan', '2nd', 36.0, 'female', 1),\n",
       " (582, 'Weisz, Mr Leopold', '2nd', 28.0, 'male', 0),\n",
       " (583, 'Weisz, Mrs Leopold (Mathilde)', '2nd', 32.0, 'female', 1),\n",
       " (584, 'Wells, Mrs Arthur H (Addie Trevaskis)', '2nd', 29.0, 'female', 1),\n",
       " (585, 'Wells, Miss Joan', '2nd', 4.0, 'female', 1),\n",
       " (586, 'Wells, Master Ralph Lester', '2nd', 2.0, 'male', 1),\n",
       " (587, 'West, Miss Barbara J', '2nd', None, 'female', 1),\n",
       " (588, 'West, Miss Constance Mirium', '2nd', None, 'female', 1),\n",
       " (589, 'West, Mr Edwy Arthur', '2nd', 36.0, 'male', 0),\n",
       " (590, 'West, Mrs Edwy Arthur (Ada Mary)', '2nd', 33.0, 'female', 1),\n",
       " (591, 'Wheadon, Mr Edward', '2nd', None, 'male', 0),\n",
       " (592, 'Wheeler, Mr Edwin', '2nd', None, 'male', 0),\n",
       " (593, 'Wheeler, Mr Frederick', '2nd', None, 'male', 0),\n",
       " (594, 'Wilhelms, Mr Charles', '2nd', 32.0, 'male', 1),\n",
       " (595, 'Wilkinson, Mrs Elizabeth Anne', '2nd', None, 'female', 1),\n",
       " (596, 'Williams, Mr Charles Eugene', '2nd', None, 'male', 1),\n",
       " (597, 'Wright, Miss Marion', '2nd', 26.0, 'female', 1),\n",
       " (598, 'Yrois, Miss Henriette', '2nd', None, 'female', 0),\n",
       " (599, 'Aldworth, Mr Charles Augustus', '2nd', 30.0, 'male', 0),\n",
       " (600, 'Brown, Miss Mildred', '2nd', 24.0, 'female', 1),\n",
       " (601, 'Pernot, Mr Rene', '2nd', None, 'male', 0),\n",
       " (602, 'Swane, Mr George', '2nd', 18.0, 'male', 0),\n",
       " (603, 'Abbing, Mr Anthony', '3rd', 42.0, 'male', 0),\n",
       " (604, 'Abbott, Master Eugene Joseph', '3rd', 13.0, 'male', 0),\n",
       " (605, 'Abbott, Mr Rossmore Edward', '3rd', 16.0, 'male', 0),\n",
       " (606, 'Abbott, Mrs Stanton (Rosa)', '3rd', 35.0, 'female', 1),\n",
       " (607, 'Abelseth, Miss Anna Karen', '3rd', 16.0, 'female', 1),\n",
       " (608, 'Abelseth, Mr Olaus', '3rd', 25.0, 'male', 1),\n",
       " (609, 'Abraham, Mrs Joseph (Sophie Easu)', '3rd', 18.0, 'female', 1),\n",
       " (610, 'Abrahamsson, Mr August', '3rd', 20.0, 'male', 1),\n",
       " (611, 'Adahl, Mr Mauritz Nils Martin', '3rd', 30.0, 'male', 0),\n",
       " (612, 'Adams, Mr John', '3rd', 26.0, 'male', 0),\n",
       " (613, 'Ahlin, Mrs Johanna Persdotter', '3rd', 40.0, 'female', 0),\n",
       " (614, 'Ahmed, Mr Ali', '3rd', 24.0, 'male', 0),\n",
       " (615, 'Aijo-Nirva, Mr Isak', '3rd', 41.0, 'male', 0),\n",
       " (616, 'Aks, Mrs Sam (Leah Rosen)', '3rd', 18.0, 'female', 1),\n",
       " (617, 'Aks, Master Philip', '3rd', 0.83, 'male', 1),\n",
       " (618, 'Alexander, Mr William', '3rd', 23.0, 'male', 0),\n",
       " (619, 'Alhomaki, Mr Ilmari Rudolf', '3rd', 20.0, 'male', 0),\n",
       " (620, 'Ali, Mr William', '3rd', 25.0, 'male', 0),\n",
       " (621, 'Allen, Mr William Henry', '3rd', 35.0, 'male', 0),\n",
       " (622, 'Allum, Mr Owen George', '3rd', 17.0, 'male', 0),\n",
       " (623, 'Andersen, Mr Albert Karvin', '3rd', 32.0, 'male', 0),\n",
       " (624, 'Andersen, Mr Thor Olsvigen', '3rd', 20.0, 'male', 0),\n",
       " (625, 'Andersson, Mr Anders Johan', '3rd', 39.0, 'male', 0),\n",
       " (626, 'Andersson, Mrs Anders Johan (Alfrida K Brogren)', '3rd', 39.0, 'female', 0),\n",
       " (627, 'Andersson, Miss Ebba Iris', '3rd', 6.0, 'female', 0),\n",
       " (628, 'Andersson, Miss Ellis Anna Maria', '3rd', 2.0, 'female', 0),\n",
       " (629, 'Andersson, Miss Erna', '3rd', 17.0, 'female', 1),\n",
       " (630, 'Andersson, Miss Ida Augusta Margareta', '3rd', 38.0, 'female', 0),\n",
       " (631, 'Andersson, Miss Ingeborg Constancia', '3rd', 9.0, 'female', 0),\n",
       " (632, 'Andersson, Mr Johan Samuel', '3rd', 26.0, 'male', 0),\n",
       " (633, 'Andersson, Miss Sigrid Elizabeth', '3rd', 11.0, 'female', 0),\n",
       " (634, 'Andersson, Master Sigvard Harald Elias', '3rd', 4.0, 'male', 0),\n",
       " (635, 'Andreasson, Mr Paul Edvin', '3rd', 20.0, 'male', 0),\n",
       " (636, 'Angheloff, Mr Minko', '3rd', 26.0, 'male', 0),\n",
       " (637, 'Arnold, Mr Josef', '3rd', 25.0, 'male', 0),\n",
       " (638, 'Arnold, Mrs Josef (Josephine Frank)', '3rd', 18.0, 'female', 0),\n",
       " (639, 'Aronsson, Mr Ernst Axel Algot', '3rd', 24.0, 'male', 0),\n",
       " (640, 'Asim, Mr Adola', '3rd', 35.0, 'male', 0),\n",
       " (641, 'Asplund, Mr Carl Oscar Vilhelm Gustafsson', '3rd', 40.0, 'male', 0),\n",
       " (642, 'Asplund, Mrs Carl Oscar (Selma Augusta Johansson)', '3rd', 38.0, 'female', 1),\n",
       " (643, 'Asplund, Master Carl Edgar', '3rd', 5.0, 'male', 0),\n",
       " (644, 'Asplund, Master Clarence Gustaf Hugo', '3rd', 9.0, 'male', 0),\n",
       " (645, 'Aspland, Master Edvin Rojj Felix', '3rd', 3.0, 'male', 1),\n",
       " (646, 'Asplund, Master Filip Oscar', '3rd', 13.0, 'male', 0),\n",
       " (647, 'Asplund, Mr John Charles', '3rd', 23.0, 'male', 1),\n",
       " (648, 'Asplund, Miss Lillian Gertrud', '3rd', 5.0, 'female', 1),\n",
       " (649, 'Assaf, Mr Gerios', '3rd', None, 'male', 0),\n",
       " (650, 'Assaf, Mrs Mariana', '3rd', 45.0, 'female', 1),\n",
       " (651, 'Assam, Mr Ali', '3rd', 23.0, 'male', 0),\n",
       " (652, 'Attalah, Miss Malaka', '3rd', 17.0, 'female', 0),\n",
       " (653, 'Attala (Kalil), Mr Solomon', '3rd', 27.0, 'male', 0),\n",
       " (654, 'Augustsson, Mr Albert', '3rd', 23.0, 'male', 0),\n",
       " (655, 'Baccos, Mr Rafoul', '3rd', 20.0, 'male', 0),\n",
       " (656, 'Backstrom, Mr Karl Alfred', '3rd', 32.0, 'male', 0),\n",
       " (657, 'Backstrom, Mrs Karl Alfred (Maria Mathilda Gustafsson)', '3rd', 33.0, 'female', 1),\n",
       " (658, 'Baclini, Miss Eugenie', '3rd', 3.0, 'female', 1),\n",
       " (659, 'Baclini, Miss Helene', '3rd', None, 'female', 1),\n",
       " (660, 'Baclini, Miss Maria', '3rd', None, 'female', 1),\n",
       " (661, 'Baclini, Mrs Solomon (Latifa)', '3rd', None, 'female', 1),\n",
       " (662, 'Badman, Miss Emily Louisa', '3rd', 18.0, 'female', 1),\n",
       " (663, 'Badt, Mr Mohamed', '3rd', 40.0, 'male', 0),\n",
       " (664, 'Balkic, Mr Cerin', '3rd', 26.0, 'male', 0),\n",
       " (665, 'Banoura, Miss Ayout', '3rd', 15.0, 'female', 1),\n",
       " (666, 'Barbara, Mrs Catherine', '3rd', 45.0, 'female', 0),\n",
       " (667, 'Barbara, Miss Saude', '3rd', 18.0, 'female', 0),\n",
       " (668, 'Barry, Miss Julia', '3rd', 27.0, 'female', 0),\n",
       " (669, 'Barton, Mr David', '3rd', 22.0, 'male', 0),\n",
       " (670, 'Beavan, Mr William Thomas', '3rd', 19.0, 'male', 0),\n",
       " (671, 'Bengtsson, Mr John Viktor', '3rd', 26.0, 'male', 0),\n",
       " (672, 'Berglund, Mr Karl Ivar Sven', '3rd', 22.0, 'male', 0),\n",
       " (673, 'Betros, Mr Tannous', '3rd', 20.0, 'male', 0),\n",
       " (674, 'Bing, Mr Lee', '3rd', 32.0, 'male', 1),\n",
       " (675, 'Birkeland, Mr Hans', '3rd', 21.0, 'male', 0),\n",
       " (676, 'Bjorklund, Ernst Herbert', '3rd', 18.0, 'male', 0),\n",
       " (677, 'Bostandyeff, Mr Guentcho', '3rd', 26.0, 'male', 0),\n",
       " (678, 'Boulos, Master Akar', '3rd', 6.0, 'male', 0),\n",
       " (679, 'Boulos, Mr Hanna', '3rd', None, 'male', 0),\n",
       " (680, 'Boulos, Mrs Joseph (Sultana)', '3rd', None, 'female', 0),\n",
       " (681, 'Boulos, Miss Laura', '3rd', 9.0, 'female', 0),\n",
       " (682, 'Bourke, Mr John', '3rd', 40.0, 'male', 0),\n",
       " (683, 'Bourke, Mrs John (Catherine)', '3rd', 32.0, 'female', 0),\n",
       " (684, 'Bourke, Miss Mary', '3rd', None, 'female', 0),\n",
       " (685, 'Bowen, Mr David', '3rd', 26.0, 'male', 0),\n",
       " (686, 'Bradley, Miss Bridget Delia', '3rd', 18.0, 'female', 1),\n",
       " (687, 'Braf, Miss Elin Ester Maria', '3rd', 20.0, 'female', 0),\n",
       " (688, 'Brahim, Mr Youssef', '3rd', None, 'male', 0),\n",
       " (689, 'Braund, Mr Lewis Richard', '3rd', 29.0, 'male', 0),\n",
       " (690, 'Braund, Mr Owen Harris', '3rd', 22.0, 'male', 0),\n",
       " (691, 'Brobek, Mr Karl Rudolf', '3rd', 22.0, 'male', 0),\n",
       " (692, 'Brocklebank, Mr William Alfred', '3rd', 35.0, 'male', 0),\n",
       " (693, 'Buckley, Mr Daniel', '3rd', 21.0, 'male', 1),\n",
       " (694, 'Buckley, Miss Katherine', '3rd', 20.0, 'female', 0),\n",
       " (695, 'Burke, Mr Jeremiah', '3rd', 19.0, 'male', 0),\n",
       " (696, 'Burns, Miss Mary Delia', '3rd', 18.0, 'female', 0),\n",
       " (697, 'Cacic, Mr Grego', '3rd', 18.0, 'male', 0),\n",
       " (698, 'Cacic, Mr Luka', '3rd', 38.0, 'male', 0),\n",
       " (699, 'Cacic, Mr Manda', '3rd', None, 'male', 0),\n",
       " (700, 'Cacic, Mr Maria', '3rd', 30.0, 'male', 0),\n",
       " (701, 'Calic, Mr Peter', '3rd', 17.0, 'male', 0),\n",
       " (702, 'Canavan, Miss Mary', '3rd', 21.0, 'female', 0),\n",
       " (703, 'Canavan, Mr Patrick', '3rd', 21.0, 'male', 0),\n",
       " (704, 'Cann, Mr Ernest', '3rd', 21.0, 'male', 0),\n",
       " (705, 'Caram (Kareem), Mr Joseph', '3rd', None, 'male', 0),\n",
       " (706, 'Caram (Kareem), Mrs Joseph (Maria Elias)', '3rd', None, 'female', 0),\n",
       " (707, 'Carlsson, Mr Carl Robert', '3rd', 24.0, 'male', 0),\n",
       " (708, 'Carlsson, Mr Frans Olof', '3rd', 33.0, 'male', 0),\n",
       " (709, 'Carlsson, Mr Julius', '3rd', 33.0, 'male', 0),\n",
       " (710, 'Carlsson, Mr August Sigfrid', '3rd', 28.0, 'male', 0),\n",
       " (711, 'Carr, Miss Helen', '3rd', 16.0, 'female', 1),\n",
       " (712, 'Carr, Miss Jeannie', '3rd', 37.0, 'female', 0),\n",
       " (713, 'Carver, Mr Alfred John', '3rd', 28.0, 'male', 0),\n",
       " (714, 'Cassem, Mr Nassef Belmenly', '3rd', None, 'male', 1),\n",
       " (715, 'Celotti, Mr Francesco', '3rd', 24.0, 'male', 0),\n",
       " (716, 'Chartens, Mr David', '3rd', 21.0, 'male', 0),\n",
       " (717, 'Chebab, Mr Emir Farres', '3rd', None, 'male', 0),\n",
       " (718, 'Chip, Mr Chang', '3rd', 32.0, 'male', 0),\n",
       " (719, 'Christmann, Mr Emil', '3rd', 29.0, 'male', 0),\n",
       " (720, 'Chronopoulos, Mr Apostolos', '3rd', 26.0, 'male', 0),\n",
       " (721, 'Chronopoulos, Mr Demetrios', '3rd', 18.0, 'male', 0),\n",
       " (722, 'Coelho, Mr Domingos Fernandes', '3rd', 20.0, 'male', 0),\n",
       " (723, 'Cohen, Mr Gurshon (Gus)', '3rd', 19.0, 'male', 1),\n",
       " (724, 'Colbert, Mr Patrick', '3rd', 24.0, 'male', 0),\n",
       " (725, 'Coleff, Mr Fotio', '3rd', 24.0, 'male', 0),\n",
       " (726, 'Coleff, Mr Peyo', '3rd', 36.0, 'male', 0),\n",
       " (727, 'Conlin, Mr Thomas Henry', '3rd', 31.0, 'male', 0),\n",
       " (728, 'Connaghton, Mr Michael', '3rd', 31.0, 'male', 0),\n",
       " (729, 'Connolly, Miss Kate', '3rd', 30.0, 'female', 0),\n",
       " (730, 'Connolly, Miss Kate', '3rd', 22.0, 'female', 1),\n",
       " (731, 'Connors, Mr Patrick', '3rd', None, 'male', 0),\n",
       " (732, 'Cook, Mr Jacob', '3rd', 43.0, 'male', 0),\n",
       " (733, 'Cor, Mr Bartol', '3rd', 35.0, 'male', 0),\n",
       " (734, 'Cor, Mr Ivan', '3rd', 27.0, 'male', 0),\n",
       " (735, 'Cor, Mr Ludovik', '3rd', 19.0, 'male', 0),\n",
       " (736, 'Corn, Mr Harry', '3rd', 30.0, 'male', 0),\n",
       " (737, 'Coutts, Mrs William (Minnie)', '3rd', 36.0, 'female', 1),\n",
       " (738, 'Coutts, Master Neville', '3rd', 3.0, 'male', 1),\n",
       " (739, 'Coutts, Master William Leslie', '3rd', 9.0, 'male', 1),\n",
       " (740, 'Coxon, Mr Daniel', '3rd', 59.0, 'male', 0),\n",
       " (741, 'Crease, Mr Ernest James', '3rd', 19.0, 'male', 0),\n",
       " (742, 'Cribb, Mr John Hatfield', '3rd', 44.0, 'male', 0),\n",
       " (743, 'Cribb, Miss Laura Alice', '3rd', 17.0, 'female', 1),\n",
       " (744, 'Daher, Mr Tannous', '3rd', None, 'male', 0),\n",
       " (745, 'Dahl, Mr Charles Edward', '3rd', 45.0, 'male', 1),\n",
       " (746, 'Dahlberg, Miss Gerda Ulrika', '3rd', 22.0, 'female', 0),\n",
       " (747, 'Dakic, Mr Branko', '3rd', 19.0, 'male', 0),\n",
       " (748, 'Daly, Mr Eugene', '3rd', 29.0, 'male', 1),\n",
       " (749, 'Daly, Miss Marcella', '3rd', 30.0, 'female', 1),\n",
       " (750, 'Danbom, Mr Ernst Gilbert', '3rd', 34.0, 'male', 0),\n",
       " (751, 'Danbom, Mrs Ernst Gilbert (Anna Sigrid Maria Brogren)', '3rd', 28.0, 'female', 0),\n",
       " (752, 'Danbom, Master Gilbert Sigvard Emanuel', '3rd', 0.33, 'male', 0),\n",
       " (753, 'Danoff, Mr Yoto', '3rd', 27.0, 'male', 0),\n",
       " (754, 'Dantchoff, Mr Khristo', '3rd', 25.0, 'male', 0),\n",
       " (755, 'Davies, Mr Alfred', '3rd', 24.0, 'male', 0),\n",
       " (756, 'Davies, Mr Evan', '3rd', 22.0, 'male', 0),\n",
       " (757, 'Davies, Mr John', '3rd', 21.0, 'male', 0),\n",
       " (758, 'Davies, Mr Joseph', '3rd', 17.0, 'male', 0),\n",
       " (759, 'Davison, Mr Thomas Henry', '3rd', None, 'male', 0),\n",
       " (760, 'Davison, Mrs Thomas Henry (Mary Finck)', '3rd', None, 'female', 1),\n",
       " (761, 'Dean, Mr Bertram', '3rd', 26.0, 'male', 0),\n",
       " (762, 'Dean, Mrs Bertram (Eva)', '3rd', 33.0, 'female', 1),\n",
       " (763, 'Dean, Master Bertram Vere', '3rd', 1.0, 'male', 1),\n",
       " (764, 'Dean, Miss Elizabeth Gladys (Millvena)', '3rd', 0.17, 'female', 1),\n",
       " (765, 'Delalic, Mr Regyo', '3rd', 25.0, 'male', 0),\n",
       " (766, 'De Messemaeker, Mr William Joseph', '3rd', 36.0, 'male', 1),\n",
       " (767, 'De Messemaeker, Mrs William Joseph (Anna)', '3rd', 36.0, 'female', 1),\n",
       " (768, 'De Mulder, Mr Theo', '3rd', 30.0, 'male', 1),\n",
       " (769, 'Denkoff, Mr Mito', '3rd', None, 'male', 0),\n",
       " (770, 'Dennis, Mr Samuel', '3rd', 23.0, 'male', 0),\n",
       " (771, 'Dennis, Mr William', '3rd', 26.0, 'male', 0),\n",
       " (772, 'Devaney, Miss Margaret', '3rd', 19.0, 'female', 1),\n",
       " (773, 'Dewan, Mr Frank', '3rd', 65.0, 'male', 0),\n",
       " (774, 'Dibo, Mr Elias', '3rd', None, 'male', 0),\n",
       " (775, 'Dimic, Mr Jovan', '3rd', 42.0, 'male', 0),\n",
       " (776, 'Dintcheff, Mr Valtcho', '3rd', 43.0, 'male', 0),\n",
       " (777, 'Dooley, Mr Patrick', '3rd', 32.0, 'male', 0),\n",
       " (778, 'Dorkings, Mr Edward Arthur', '3rd', 19.0, 'male', 1),\n",
       " (779, 'Dowdell, Miss Elizabeth', '3rd', 30.0, 'female', 1),\n",
       " (780, 'Doyle, Miss Elizabeth', '3rd', 24.0, 'female', 0),\n",
       " (781, 'Drapkin, Miss Jennie', '3rd', 23.0, 'female', 1),\n",
       " (782, 'Drazonovic, Mr Josef', '3rd', None, 'male', 0),\n",
       " (783, 'Driscoll, Miss Bridget', '3rd', 24.0, 'female', 1),\n",
       " (784, 'Duquemin, Mr Joseph', '3rd', 24.0, 'male', 1),\n",
       " (785, 'Dyker, Mr Adolf Fredrik', '3rd', 23.0, 'male', 0),\n",
       " (786, 'Dyker, Mrs Adolf Fredrik (Anna Elizabeth Judith Andersson)', '3rd', 22.0, 'female', 1),\n",
       " (787, 'Econovic, Mr Joso', '3rd', None, 'male', 0),\n",
       " (788, 'Edvardsson, Mr Gustaf Hjalmar', '3rd', 18.0, 'male', 0),\n",
       " (789, 'Eklund, Mr Hans Linus', '3rd', 16.0, 'male', 0),\n",
       " (790, 'Ekstrom, Mr Johan', '3rd', 45.0, 'male', 0),\n",
       " (791, 'Elias, Mr Elias', '3rd', None, 'male', 0),\n",
       " (792, 'Elias, Mr John', '3rd', None, 'male', 0),\n",
       " (793, 'Elias, Mr Joseph', '3rd', None, 'male', 0),\n",
       " (794, 'Elsbury, Mr James', '3rd', 47.0, 'male', 0),\n",
       " (795, 'Emanuel, Miss Virginia Ethel', '3rd', 5.0, 'female', 1),\n",
       " (796, 'Emmeth, Mr Thomas', '3rd', None, 'male', 0),\n",
       " (797, 'Everett, Thomas James', '3rd', None, 'male', 0),\n",
       " (798, 'Farrell, Mr James', '3rd', None, 'male', 0),\n",
       " (799, 'Finoli, Mr Luigi', '3rd', None, 'male', 1),\n",
       " (800, 'Fischer, Mr Eberhard Telander', '3rd', None, 'male', 0),\n",
       " (801, 'Flynn, Mr James', '3rd', None, 'male', 0),\n",
       " (802, 'Flynn, Mr John', '3rd', None, 'male', 0),\n",
       " (803, 'Foley, Mr Joseph', '3rd', None, 'male', 0),\n",
       " (804, 'Foley, Mr William', '3rd', None, 'male', 0),\n",
       " (805, 'Foo, Mr Choong', '3rd', None, 'male', 1),\n",
       " (806, 'Ford, Mr Arthur', '3rd', None, 'male', 0),\n",
       " (807, 'Ford, Miss Doolina Margaret', '3rd', 21.0, 'female', 0),\n",
       " (808, 'Ford, Mr Edward Watson', '3rd', 18.0, 'male', 0),\n",
       " (809, 'Ford, Miss Maggie', '3rd', 9.0, 'female', 0),\n",
       " (810, 'Ford, Mrs Edward (Margaret Ann)', '3rd', 48.0, 'female', 0),\n",
       " (811, 'Ford, Mr Neil Watson', '3rd', 16.0, 'male', 0),\n",
       " (812, 'Fox, Mr Patrick', '3rd', None, 'male', 0),\n",
       " (813, 'Franklin, Mr Charles', '3rd', None, 'male', 0),\n",
       " (814, 'Gallagher, Mr Martin', '3rd', 25.0, 'male', 0),\n",
       " (815, 'Garfirth, Mr John', '3rd', None, 'male', 0),\n",
       " (816, 'Georges, Mrs Shahini Weappi', '3rd', 38.0, 'female', 1),\n",
       " (817, 'Gilinski, Mr Leslie', '3rd', 22.0, 'male', 0),\n",
       " (818, 'Gilnagh, Miss Katie', '3rd', 16.0, 'female', 1),\n",
       " (819, 'Glynn, Miss Mary Agatha', '3rd', None, 'female', 1),\n",
       " (820, 'Goldsmith, Mr Frank John', '3rd', 33.0, 'male', 0),\n",
       " (821, 'Goldsmith, Mrs Frank John (Emily A Brown)', '3rd', None, 'female', 1),\n",
       " (822, 'Goldsmith, Master Frank John William', '3rd', 9.0, 'male', 1),\n",
       " (823, 'Goldsmith, Mr Nathan', '3rd', 41.0, 'male', 0),\n",
       " (824, 'Goncalves, Mr Manuel Estanslas', '3rd', 38.0, 'male', 0),\n",
       " (825, 'Goodwin, Mr Frederick', '3rd', 40.0, 'male', 0),\n",
       " (826, 'Goodwin, Mrs Frederick (Augusta)', '3rd', 43.0, 'female', 0),\n",
       " (827, 'Goodwin, Mr Charles E', '3rd', 14.0, 'male', 0),\n",
       " (828, 'Goodwin, Miss Lillian A', '3rd', 16.0, 'female', 0),\n",
       " (829, 'Goodwin, Master Harold V', '3rd', 9.0, 'male', 0),\n",
       " (830, 'Goodwin, Miss Jessie A', '3rd', 10.0, 'female', 0),\n",
       " (831, 'Goodwin, Master Sidney L', '3rd', 6.0, 'male', 0),\n",
       " (832, 'Goodwin, Master William F', '3rd', 11.0, 'male', 0),\n",
       " (833, 'Green, Mr George', '3rd', 40.0, 'male', 0),\n",
       " (834, 'Gronnestad, Mr Daniel Danielsen', '3rd', 32.0, 'male', 0),\n",
       " (835, 'Guest, Mr Robert', '3rd', None, 'male', 0),\n",
       " (836, 'Gustafsson, Mr Alfred Ossian', '3rd', 20.0, 'male', 0),\n",
       " (837, 'Gustafsson, Mr Anders Vilhelm', '3rd', 37.0, 'male', 0),\n",
       " (838, 'Gustafsson, Mr Johan Birger', '3rd', 28.0, 'male', 0),\n",
       " (839, 'Gustafsson, Mr Karl Gideon', '3rd', 19.0, 'male', 0),\n",
       " (840, 'Haas, Miss Aloisia', '3rd', 24.0, 'female', 0),\n",
       " (841, 'Hagardon, Miss Kate', '3rd', 17.0, 'female', 0),\n",
       " (842, 'Hagland, Mr Ingvald Olsen', '3rd', None, 'male', 0),\n",
       " (843, 'Hagland, Mr Konrad Mathias Reiersen', '3rd', None, 'male', 0),\n",
       " (844, 'Hakkarainen, Mr Pekko Pietari', '3rd', 28.0, 'male', 0),\n",
       " (845, 'Hakkarainen, Mrs Pekko Pietari', '3rd', 24.0, 'female', 1),\n",
       " (846, 'Hampe, Mr Leon', '3rd', 20.0, 'male', 0),\n",
       " (847, 'Hansen, Mr Claus Peter', '3rd', 41.0, 'male', 0),\n",
       " (848, 'Hansen, Mrs Claus Peter', '3rd', 45.0, 'female', 1),\n",
       " (849, 'Hansen, Mr Henrik Juul', '3rd', 26.0, 'male', 0),\n",
       " (850, 'Hansen, Mr Henry Damsgaard', '3rd', 21.0, 'male', 0),\n",
       " (851, 'Harknett, Miss Alice', '3rd', None, 'female', 0),\n",
       " (852, 'Harmer, Mr Abraham', '3rd', None, 'male', 0),\n",
       " (853, 'Hart, Mr Henry', '3rd', None, 'male', 0),\n",
       " (854, 'Hassan, Mr M Houssein', '3rd', None, 'male', 0),\n",
       " (855, 'Healy, Miss Nora', '3rd', None, 'female', 0),\n",
       " (856, 'Hedman, Mr Oscar', '3rd', 27.0, 'male', 1),\n",
       " (857, 'Hee, Mr Ling', '3rd', None, 'male', 0),\n",
       " (858, 'Hegarty, Miss Nora', '3rd', 18.0, 'female', 0),\n",
       " (859, 'Heikkinen, Miss Laina', '3rd', 26.0, 'female', 1),\n",
       " (860, 'Heininen, Miss Wendla Maria', '3rd', 23.0, 'female', 0),\n",
       " (861, 'Hellstrom, Hilda Maria', '3rd', 22.0, 'female', 1),\n",
       " (862, 'Hemming, Miss Nora', '3rd', None, 'female', 0),\n",
       " (863, 'Hendekovic, Mr Ignaz', '3rd', None, 'male', 0),\n",
       " (864, 'Henery, Delia', '3rd', None, 'female', 0),\n",
       " (865, 'Henriksson, Jenny Lovisa', '3rd', 28.0, 'female', 0),\n",
       " (866, 'Hirvonen, Mrs Alexander', '3rd', 22.0, 'female', 1),\n",
       " (867, 'Hirvonen, Miss Hildur E', '3rd', 2.0, 'female', 0),\n",
       " (868, 'Holm, Mr John Frederik Alexander', '3rd', 43.0, 'male', 0),\n",
       " (869, 'Holthen, Mr Johan Martin', '3rd', None, 'male', 0),\n",
       " (870, 'Honkanen, Miss Eluna', '3rd', 27.0, 'female', 1),\n",
       " (871, 'Horgan, Mr John', '3rd', None, 'male', 0),\n",
       " (872, 'Howard, Miss May', '3rd', None, 'female', 1),\n",
       " (873, 'Humblin, Mr Adolf Mathias Nicolai Olsen', '3rd', 42.0, 'male', 0),\n",
       " (874, 'Hyman, Mr Abraham', '3rd', None, 'male', 1),\n",
       " (875, 'Ilieff, Mr Ylio', '3rd', None, 'male', 0),\n",
       " (876, 'Ilmakangas, Miss Ida Livija', '3rd', 27.0, 'female', 0),\n",
       " (877, 'Ilmakangas, Miss Pieta Sofia', '3rd', 25.0, 'female', 0),\n",
       " (878, 'Ivanoff, Mr Konio', '3rd', None, 'male', 0),\n",
       " (879, 'Jansen, Mr Carl Olof', '3rd', 27.0, 'male', 1),\n",
       " (880, 'Jardin, Mr Jose Netto', '3rd', None, 'male', 0),\n",
       " (881, 'Jensen, Miss Carla Christine', '3rd', 19.0, 'female', 1),\n",
       " (882, 'Jensen, Mr Hans Peder', '3rd', 20.0, 'male', 0),\n",
       " (883, 'Jensen, Mr Niels Peder', '3rd', 48.0, 'male', 0),\n",
       " (884, 'Jensen, Mr Svend Lauritz', '3rd', 17.0, 'male', 0),\n",
       " (885, 'Jermyn, Miss Annie', '3rd', None, 'female', 1),\n",
       " (886, 'Johannesen-Bratthammer, Mr Bernt', '3rd', None, 'male', 0),\n",
       " (887, 'Johanson, Mr Jakob Alfred', '3rd', 34.0, 'male', 0),\n",
       " (888, 'Johansson, Mr Erik', '3rd', 22.0, 'male', 0),\n",
       " (889, 'Johansson, Mr Gustaff Joel', '3rd', 33.0, 'male', 0),\n",
       " (890, 'Johansson, Mr Karl Johan', '3rd', 32.0, 'male', 1),\n",
       " (891, 'Johansson, Mr Nils', '3rd', 29.0, 'male', 0),\n",
       " (892, 'Johansson, Oscar L', '3rd', 26.0, 'male', 1),\n",
       " (893, 'Johnson, Mr Alfred', '3rd', 49.0, 'male', 0),\n",
       " (894, 'Johnson, Miss Eleanor Ileen', '3rd', 1.0, 'female', 1),\n",
       " (895, 'Johnson, Mr Malkolm Joackim', '3rd', 33.0, 'male', 0),\n",
       " (896, 'Johnson, Master Harold Theodor', '3rd', 4.0, 'male', 1),\n",
       " (897, 'Johnson, Mrs Oscar W', '3rd', 24.0, 'female', 0),\n",
       " (898, 'Johnson, Mr William Cahoone Jr', '3rd', 19.0, 'male', 0),\n",
       " (899, 'Johnston, Mr Andrew G', '3rd', None, 'male', 0),\n",
       " (900, 'Johnston, Mrs Andrew G', '3rd', None, 'female', 0),\n",
       " (901, 'Johnston, Miss Catherine H', '3rd', None, 'female', 0),\n",
       " (902, 'Johnston, Master William A', '3rd', None, 'male', 0),\n",
       " (903, 'Jonkoff, Mr Lazor', '3rd', None, 'male', 0),\n",
       " (904, 'Jonsson, Mr Carl', '3rd', 32.0, 'male', 1),\n",
       " (905, 'Jonsson, Nils Hilding', '3rd', 27.0, 'male', 0),\n",
       " (906, 'Jussila, Miss Aina Maria', '3rd', 21.0, 'female', 0),\n",
       " (907, 'Jussila, Mr Erik', '3rd', 32.0, 'male', 1),\n",
       " (908, 'Jussila, Miss Katriina', '3rd', 20.0, 'female', 0),\n",
       " (909, 'Kallio, Mr Nikolai Erland', '3rd', 17.0, 'male', 0),\n",
       " (910, 'Kalvig, Mr Johannes K Halverson', '3rd', 21.0, 'male', 0),\n",
       " (911, 'Karajic, Mr Milan', '3rd', 30.0, 'male', 0),\n",
       " (912, 'Karlsson, Mr Einar Gervasius', '3rd', 21.0, 'male', 1),\n",
       " (913, 'Karlsson, Mr Julius Konrad Eugen', '3rd', 23.0, 'male', 0),\n",
       " (914, 'Karlsson, Mr Nils August', '3rd', 22.0, 'male', 0),\n",
       " (915, 'Karun, Miss Anna Mary', '3rd', 4.0, 'female', 1),\n",
       " (916, 'Karun, Mr Franz', '3rd', 39.0, 'male', 0),\n",
       " (917, 'Kassem, Mr Fared', '3rd', None, 'male', 0),\n",
       " (918, 'Keane, Mr Andrew', '3rd', 20.0, 'male', 0),\n",
       " (919, 'Keefe, Mr Arthur', '3rd', None, 'male', 0),\n",
       " (920, 'Kekic, Mr Tido', '3rd', None, 'male', 0),\n",
       " (921, 'Kelly, Miss Anna Kate', '3rd', 21.0, 'female', 1),\n",
       " (922, 'Kelly, Mr James', '3rd', 44.0, 'male', 0),\n",
       " (923, 'Kelly, Mr James', '3rd', 42.0, 'male', 0),\n",
       " (924, 'Kelly, Miss Mary', '3rd', 21.0, 'female', 1),\n",
       " (925, 'Kennedy, Mr John', '3rd', 24.0, 'male', 0),\n",
       " (926, 'Khalil, Mr Betros', '3rd', None, 'male', 0),\n",
       " (927, 'Khalil, Mrs Betros', '3rd', None, 'female', 0),\n",
       " (928, 'Khalil, Mr Saad', '3rd', None, 'male', 0),\n",
       " (929, 'Kiernan, Mr John', '3rd', 25.0, 'male', 0),\n",
       " (930, 'Kiernan, Mr Philip', '3rd', 22.0, 'male', 0),\n",
       " (931, 'Kilgannon, Mr Thomas', '3rd', 22.0, 'male', 0),\n",
       " (932, 'Kink, Mr Anton', '3rd', 39.0, 'male', 1),\n",
       " (933, 'Kink, Mrs Anton (Louise Heilmann)', '3rd', 26.0, 'female', 0),\n",
       " (934, 'Kink, Miss Louise Gretchen', '3rd', 4.0, 'female', 1),\n",
       " (935, 'Kink, Miss Maria', '3rd', 22.0, 'female', 0),\n",
       " (936, 'Kink, Mr Vincenz', '3rd', 26.0, 'male', 0),\n",
       " (937, 'Klasen, Miss Gertrud Emilia', '3rd', 1.5, 'female', 0),\n",
       " (938, 'Klasen, Mrs Hulda Kristina', '3rd', 36.0, 'female', 0),\n",
       " (939, 'Klasen, Mr Klas Albin', '3rd', 18.0, 'male', 0),\n",
       " (940, 'Kraeff, Mr Theodor', '3rd', None, 'male', 0),\n",
       " (941, 'Krekorian, Mr Neshan', '3rd', 25.0, 'male', 1),\n",
       " (942, 'Lahowd, Mr Sarkis', '3rd', None, 'male', 0),\n",
       " (943, 'Laitinen, Miss Kritina Sofia', '3rd', 37.0, 'female', 0),\n",
       " (944, 'Laleff, Mr Kristo', '3rd', None, 'male', 0),\n",
       " (945, 'Lam, Mr Ali', '3rd', None, 'male', 1),\n",
       " (946, 'Lam, Mr Len', '3rd', None, 'male', 0),\n",
       " (947, 'Landegren, Miss Aurora Adelia', '3rd', 22.0, 'female', 1),\n",
       " (948, 'Lane, Mr Patrick', '3rd', 20.0, 'male', 0),\n",
       " (949, 'Lang, Mr Fang', '3rd', 26.0, 'male', 1),\n",
       " (950, 'Larsson, Mr August Viktor', '3rd', 29.0, 'male', 0),\n",
       " (951, 'Larsson, Mr Bengt Edvin', '3rd', 29.0, 'male', 0),\n",
       " (952, 'Larsson-Rondberg, Mr Edvard', '3rd', 22.0, 'male', 0),\n",
       " (953, 'Leeni, Mr Fahim', '3rd', None, 'male', 1),\n",
       " (954, 'Lefebre, Mrs Frank', '3rd', None, 'female', 0),\n",
       " (955, 'Lefebre, Master Henry', '3rd', None, 'male', 0),\n",
       " (956, 'Lefebre, Miss Ida', '3rd', None, 'female', 0),\n",
       " (957, 'Lefebre, Miss Jeannie', '3rd', None, 'female', 0),\n",
       " (958, 'Lefebre, Miss Mathilde', '3rd', None, 'female', 0),\n",
       " (959, 'Leinonen, Mr Antti Gustaf', '3rd', 32.0, 'male', 0),\n",
       " (960, 'Lemberopolous, Mr Peter L', '3rd', None, 'male', 0),\n",
       " (961, 'Lemom, Mr Denis', '3rd', 21.0, 'male', 0),\n",
       " (962, 'Lemon, Miss Mary', '3rd', 21.0, 'female', 0),\n",
       " (963, 'Leonard, Mr Lionel', '3rd', 36.0, 'male', 0),\n",
       " (964, 'Lester, Mr James', '3rd', 39.0, 'male', 0),\n",
       " (965, 'Lindahl, Miss Agda V', '3rd', 25.0, 'female', 0),\n",
       " (966, 'Lindblom, Miss Augusta Charlotta', '3rd', 45.0, 'female', 0),\n",
       " (967, 'Lindell, Mr Edvard Bengtsson', '3rd', 36.0, 'male', 0),\n",
       " (968, 'Lindell, Mrs Edvard Bengtsson', '3rd', 30.0, 'female', 0),\n",
       " (969, 'Lindqvist, Eino William', '3rd', 20.0, 'male', 1),\n",
       " (970, 'Linehan, Mr Michael', '3rd', None, 'male', 0),\n",
       " (971, 'Ling, Mr Lee', '3rd', None, 'male', 0),\n",
       " (972, 'Lithman, Mr Simon', '3rd', None, 'male', 0),\n",
       " (973, 'Lobb, Mr William Arthur', '3rd', None, 'male', 0),\n",
       " (974, 'Lobb, Mrs William Arthur', '3rd', None, 'female', 0),\n",
       " (975, 'Lockyer, Mr Edward', '3rd', None, 'male', 0),\n",
       " (976, 'Lovell, Mr John', '3rd', None, 'male', 0),\n",
       " (977, 'Lulich, Mr Nicola', '3rd', None, 'male', 1),\n",
       " (978, 'Lundahl, Mr Johan', '3rd', None, 'male', 0),\n",
       " (979, 'Lundin, Miss Olga Elida', '3rd', None, 'female', 1),\n",
       " (980, 'Lundstrom, Mr Thure Edvin', '3rd', None, 'male', 0),\n",
       " (981, 'Lyntakoff, Mr Stanko', '3rd', None, 'male', 0),\n",
       " (982, 'MacKay, Mr George William', '3rd', None, 'male', 0),\n",
       " (983, 'Madigan, Miss Margaret', '3rd', None, 'female', 1),\n",
       " (984, 'Madsen, Mr Frithiof', '3rd', None, 'male', 0),\n",
       " (985, 'Maenpaa, Mr Matti Alexanteri', '3rd', None, 'male', 0),\n",
       " (986, 'Mahon, Miss Delia', '3rd', None, 'female', 0),\n",
       " (987, 'Maisner, Mr Simon', '3rd', None, 'male', 0),\n",
       " (988, 'Makinen, Mr Kalle Edvard', '3rd', None, 'male', 0),\n",
       " (989, 'Mamee, Mr Hanna', '3rd', None, 'male', 1),\n",
       " (990, 'Mangan, Miss Mary', '3rd', None, 'female', 0),\n",
       " (991, 'Mannion, Miss Margareth', '3rd', None, 'female', 1),\n",
       " (992, 'Mansour, Mr Hanna', '3rd', None, 'male', 0),\n",
       " (993, 'Mardirosian, Mr Sarkis', '3rd', None, 'male', 0),\n",
       " (994, 'Marinko, Mr Dmitri', '3rd', None, 'male', 0),\n",
       " (995, 'Markim, Mr Johann', '3rd', None, 'male', 0),\n",
       " (996, 'Markoff, Mr Marin', '3rd', None, 'male', 0),\n",
       " (997, 'Masselmany, Mrs Fatima', '3rd', None, 'female', 1),\n",
       " (998, 'Matinoff, Mr Nicola', '3rd', None, 'male', 0),\n",
       " (999, 'McCarthy, Miss Katie', '3rd', None, 'female', 1),\n",
       " (1000, 'McCormack, Mr Thomas J', '3rd', None, 'male', 0),\n",
       " ...]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# check the data\n",
    "engine.execute('SELECT * FROM passenger').fetchall()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Passenger Ages by Class"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'1st': [29.0,\n",
       "  2.0,\n",
       "  30.0,\n",
       "  25.0,\n",
       "  0.92,\n",
       "  47.0,\n",
       "  63.0,\n",
       "  39.0,\n",
       "  58.0,\n",
       "  71.0,\n",
       "  47.0,\n",
       "  19.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  50.0,\n",
       "  24.0,\n",
       "  36.0,\n",
       "  37.0,\n",
       "  47.0,\n",
       "  26.0,\n",
       "  25.0,\n",
       "  25.0,\n",
       "  19.0,\n",
       "  28.0,\n",
       "  45.0,\n",
       "  39.0,\n",
       "  30.0,\n",
       "  58.0,\n",
       "  None,\n",
       "  45.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  41.0,\n",
       "  48.0,\n",
       "  None,\n",
       "  44.0,\n",
       "  59.0,\n",
       "  60.0,\n",
       "  45.0,\n",
       "  None,\n",
       "  53.0,\n",
       "  58.0,\n",
       "  36.0,\n",
       "  33.0,\n",
       "  None,\n",
       "  None,\n",
       "  36.0,\n",
       "  36.0,\n",
       "  14.0,\n",
       "  11.0,\n",
       "  49.0,\n",
       "  None,\n",
       "  36.0,\n",
       "  None,\n",
       "  46.0,\n",
       "  47.0,\n",
       "  27.0,\n",
       "  31.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  27.0,\n",
       "  26.0,\n",
       "  None,\n",
       "  None,\n",
       "  64.0,\n",
       "  37.0,\n",
       "  39.0,\n",
       "  55.0,\n",
       "  None,\n",
       "  70.0,\n",
       "  69.0,\n",
       "  36.0,\n",
       "  39.0,\n",
       "  38.0,\n",
       "  None,\n",
       "  27.0,\n",
       "  31.0,\n",
       "  27.0,\n",
       "  None,\n",
       "  31.0,\n",
       "  17.0,\n",
       "  None,\n",
       "  None,\n",
       "  4.0,\n",
       "  27.0,\n",
       "  50.0,\n",
       "  48.0,\n",
       "  49.0,\n",
       "  48.0,\n",
       "  39.0,\n",
       "  23.0,\n",
       "  53.0,\n",
       "  36.0,\n",
       "  None,\n",
       "  None,\n",
       "  30.0,\n",
       "  24.0,\n",
       "  19.0,\n",
       "  28.0,\n",
       "  23.0,\n",
       "  64.0,\n",
       "  60.0,\n",
       "  None,\n",
       "  49.0,\n",
       "  None,\n",
       "  44.0,\n",
       "  22.0,\n",
       "  60.0,\n",
       "  48.0,\n",
       "  37.0,\n",
       "  35.0,\n",
       "  47.0,\n",
       "  22.0,\n",
       "  45.0,\n",
       "  49.0,\n",
       "  None,\n",
       "  71.0,\n",
       "  54.0,\n",
       "  38.0,\n",
       "  19.0,\n",
       "  58.0,\n",
       "  45.0,\n",
       "  23.0,\n",
       "  46.0,\n",
       "  25.0,\n",
       "  21.0,\n",
       "  48.0,\n",
       "  49.0,\n",
       "  45.0,\n",
       "  36.0,\n",
       "  None,\n",
       "  55.0,\n",
       "  52.0,\n",
       "  24.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  16.0,\n",
       "  44.0,\n",
       "  51.0,\n",
       "  42.0,\n",
       "  35.0,\n",
       "  35.0,\n",
       "  38.0,\n",
       "  35.0,\n",
       "  None,\n",
       "  50.0,\n",
       "  49.0,\n",
       "  46.0,\n",
       "  None,\n",
       "  58.0,\n",
       "  41.0,\n",
       "  None,\n",
       "  42.0,\n",
       "  40.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  42.0,\n",
       "  55.0,\n",
       "  50.0,\n",
       "  16.0,\n",
       "  None,\n",
       "  29.0,\n",
       "  21.0,\n",
       "  30.0,\n",
       "  15.0,\n",
       "  30.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  46.0,\n",
       "  54.0,\n",
       "  36.0,\n",
       "  28.0,\n",
       "  None,\n",
       "  65.0,\n",
       "  33.0,\n",
       "  44.0,\n",
       "  37.0,\n",
       "  None,\n",
       "  55.0,\n",
       "  47.0,\n",
       "  36.0,\n",
       "  58.0,\n",
       "  31.0,\n",
       "  23.0,\n",
       "  19.0,\n",
       "  64.0,\n",
       "  None,\n",
       "  64.0,\n",
       "  22.0,\n",
       "  28.0,\n",
       "  None,\n",
       "  None,\n",
       "  22.0,\n",
       "  None,\n",
       "  None,\n",
       "  18.0,\n",
       "  17.0,\n",
       "  52.0,\n",
       "  46.0,\n",
       "  56.0,\n",
       "  None,\n",
       "  None,\n",
       "  43.0,\n",
       "  31.0,\n",
       "  None,\n",
       "  None,\n",
       "  33.0,\n",
       "  None,\n",
       "  27.0,\n",
       "  55.0,\n",
       "  54.0,\n",
       "  None,\n",
       "  61.0,\n",
       "  48.0,\n",
       "  18.0,\n",
       "  13.0,\n",
       "  21.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  34.0,\n",
       "  40.0,\n",
       "  36.0,\n",
       "  50.0,\n",
       "  39.0,\n",
       "  56.0,\n",
       "  28.0,\n",
       "  56.0,\n",
       "  56.0,\n",
       "  24.0,\n",
       "  18.0,\n",
       "  None,\n",
       "  24.0,\n",
       "  23.0,\n",
       "  45.0,\n",
       "  40.0,\n",
       "  6.0,\n",
       "  57.0,\n",
       "  None,\n",
       "  32.0,\n",
       "  62.0,\n",
       "  54.0,\n",
       "  43.0,\n",
       "  52.0,\n",
       "  None,\n",
       "  62.0,\n",
       "  67.0,\n",
       "  63.0,\n",
       "  61.0,\n",
       "  46.0,\n",
       "  52.0,\n",
       "  39.0,\n",
       "  18.0,\n",
       "  48.0,\n",
       "  None,\n",
       "  49.0,\n",
       "  39.0,\n",
       "  17.0,\n",
       "  46.0,\n",
       "  None,\n",
       "  31.0,\n",
       "  None,\n",
       "  61.0,\n",
       "  47.0,\n",
       "  64.0,\n",
       "  60.0,\n",
       "  60.0,\n",
       "  55.0,\n",
       "  54.0,\n",
       "  21.0,\n",
       "  57.0,\n",
       "  45.0,\n",
       "  31.0,\n",
       "  50.0,\n",
       "  50.0,\n",
       "  27.0,\n",
       "  20.0,\n",
       "  51.0,\n",
       "  None,\n",
       "  21.0,\n",
       "  None,\n",
       "  None,\n",
       "  36.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  40.0,\n",
       "  None,\n",
       "  None,\n",
       "  32.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  33.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " '2nd': [30.0,\n",
       "  28.0,\n",
       "  18.0,\n",
       "  None,\n",
       "  34.0,\n",
       "  32.0,\n",
       "  57.0,\n",
       "  18.0,\n",
       "  23.0,\n",
       "  36.0,\n",
       "  28.0,\n",
       "  51.0,\n",
       "  32.0,\n",
       "  19.0,\n",
       "  28.0,\n",
       "  36.0,\n",
       "  4.0,\n",
       "  1.0,\n",
       "  12.0,\n",
       "  34.0,\n",
       "  19.0,\n",
       "  23.0,\n",
       "  26.0,\n",
       "  None,\n",
       "  27.0,\n",
       "  15.0,\n",
       "  45.0,\n",
       "  40.0,\n",
       "  20.0,\n",
       "  25.0,\n",
       "  36.0,\n",
       "  25.0,\n",
       "  None,\n",
       "  42.0,\n",
       "  26.0,\n",
       "  26.0,\n",
       "  0.83,\n",
       "  31.0,\n",
       "  None,\n",
       "  19.0,\n",
       "  54.0,\n",
       "  44.0,\n",
       "  52.0,\n",
       "  30.0,\n",
       "  30.0,\n",
       "  None,\n",
       "  None,\n",
       "  29.0,\n",
       "  None,\n",
       "  29.0,\n",
       "  27.0,\n",
       "  24.0,\n",
       "  35.0,\n",
       "  31.0,\n",
       "  8.0,\n",
       "  22.0,\n",
       "  30.0,\n",
       "  None,\n",
       "  20.0,\n",
       "  None,\n",
       "  21.0,\n",
       "  49.0,\n",
       "  8.0,\n",
       "  28.0,\n",
       "  18.0,\n",
       "  None,\n",
       "  28.0,\n",
       "  22.0,\n",
       "  25.0,\n",
       "  18.0,\n",
       "  32.0,\n",
       "  18.0,\n",
       "  None,\n",
       "  42.0,\n",
       "  34.0,\n",
       "  8.0,\n",
       "  None,\n",
       "  None,\n",
       "  23.0,\n",
       "  21.0,\n",
       "  19.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  38.0,\n",
       "  None,\n",
       "  38.0,\n",
       "  35.0,\n",
       "  35.0,\n",
       "  38.0,\n",
       "  24.0,\n",
       "  16.0,\n",
       "  26.0,\n",
       "  45.0,\n",
       "  24.0,\n",
       "  21.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  34.0,\n",
       "  30.0,\n",
       "  50.0,\n",
       "  30.0,\n",
       "  23.0,\n",
       "  1.0,\n",
       "  44.0,\n",
       "  28.0,\n",
       "  6.0,\n",
       "  30.0,\n",
       "  None,\n",
       "  43.0,\n",
       "  45.0,\n",
       "  7.0,\n",
       "  24.0,\n",
       "  24.0,\n",
       "  49.0,\n",
       "  48.0,\n",
       "  None,\n",
       "  34.0,\n",
       "  32.0,\n",
       "  21.0,\n",
       "  18.0,\n",
       "  53.0,\n",
       "  23.0,\n",
       "  21.0,\n",
       "  None,\n",
       "  52.0,\n",
       "  42.0,\n",
       "  36.0,\n",
       "  21.0,\n",
       "  41.0,\n",
       "  None,\n",
       "  None,\n",
       "  33.0,\n",
       "  17.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  23.0,\n",
       "  34.0,\n",
       "  None,\n",
       "  22.0,\n",
       "  None,\n",
       "  None,\n",
       "  45.0,\n",
       "  None,\n",
       "  None,\n",
       "  31.0,\n",
       "  30.0,\n",
       "  26.0,\n",
       "  None,\n",
       "  34.0,\n",
       "  26.0,\n",
       "  22.0,\n",
       "  1.0,\n",
       "  3.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  25.0,\n",
       "  None,\n",
       "  48.0,\n",
       "  None,\n",
       "  57.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  2.0,\n",
       "  None,\n",
       "  27.0,\n",
       "  19.0,\n",
       "  30.0,\n",
       "  20.0,\n",
       "  45.0,\n",
       "  None,\n",
       "  46.0,\n",
       "  41.0,\n",
       "  13.0,\n",
       "  19.0,\n",
       "  30.0,\n",
       "  48.0,\n",
       "  71.0,\n",
       "  54.0,\n",
       "  None,\n",
       "  None,\n",
       "  64.0,\n",
       "  32.0,\n",
       "  18.0,\n",
       "  2.0,\n",
       "  32.0,\n",
       "  3.0,\n",
       "  26.0,\n",
       "  19.0,\n",
       "  None,\n",
       "  20.0,\n",
       "  29.0,\n",
       "  39.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  24.0,\n",
       "  None,\n",
       "  28.0,\n",
       "  None,\n",
       "  50.0,\n",
       "  20.0,\n",
       "  40.0,\n",
       "  42.0,\n",
       "  21.0,\n",
       "  32.0,\n",
       "  34.0,\n",
       "  None,\n",
       "  None,\n",
       "  33.0,\n",
       "  2.0,\n",
       "  8.0,\n",
       "  36.0,\n",
       "  34.0,\n",
       "  30.0,\n",
       "  28.0,\n",
       "  23.0,\n",
       "  0.8,\n",
       "  25.0,\n",
       "  3.0,\n",
       "  50.0,\n",
       "  None,\n",
       "  21.0,\n",
       "  None,\n",
       "  None,\n",
       "  25.0,\n",
       "  18.0,\n",
       "  20.0,\n",
       "  30.0,\n",
       "  59.0,\n",
       "  30.0,\n",
       "  35.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  25.0,\n",
       "  41.0,\n",
       "  25.0,\n",
       "  14.0,\n",
       "  50.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  27.0,\n",
       "  29.0,\n",
       "  27.0,\n",
       "  30.0,\n",
       "  22.0,\n",
       "  35.0,\n",
       "  30.0,\n",
       "  28.0,\n",
       "  23.0,\n",
       "  None,\n",
       "  12.0,\n",
       "  40.0,\n",
       "  36.0,\n",
       "  28.0,\n",
       "  32.0,\n",
       "  29.0,\n",
       "  4.0,\n",
       "  2.0,\n",
       "  None,\n",
       "  None,\n",
       "  36.0,\n",
       "  33.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  32.0,\n",
       "  None,\n",
       "  None,\n",
       "  26.0,\n",
       "  None,\n",
       "  30.0,\n",
       "  24.0,\n",
       "  None,\n",
       "  18.0],\n",
       " '3rd': [42.0,\n",
       "  13.0,\n",
       "  16.0,\n",
       "  35.0,\n",
       "  16.0,\n",
       "  25.0,\n",
       "  18.0,\n",
       "  20.0,\n",
       "  30.0,\n",
       "  26.0,\n",
       "  40.0,\n",
       "  24.0,\n",
       "  41.0,\n",
       "  18.0,\n",
       "  0.83,\n",
       "  23.0,\n",
       "  20.0,\n",
       "  25.0,\n",
       "  35.0,\n",
       "  17.0,\n",
       "  32.0,\n",
       "  20.0,\n",
       "  39.0,\n",
       "  39.0,\n",
       "  6.0,\n",
       "  2.0,\n",
       "  17.0,\n",
       "  38.0,\n",
       "  9.0,\n",
       "  26.0,\n",
       "  11.0,\n",
       "  4.0,\n",
       "  20.0,\n",
       "  26.0,\n",
       "  25.0,\n",
       "  18.0,\n",
       "  24.0,\n",
       "  35.0,\n",
       "  40.0,\n",
       "  38.0,\n",
       "  5.0,\n",
       "  9.0,\n",
       "  3.0,\n",
       "  13.0,\n",
       "  23.0,\n",
       "  5.0,\n",
       "  None,\n",
       "  45.0,\n",
       "  23.0,\n",
       "  17.0,\n",
       "  27.0,\n",
       "  23.0,\n",
       "  20.0,\n",
       "  32.0,\n",
       "  33.0,\n",
       "  3.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  18.0,\n",
       "  40.0,\n",
       "  26.0,\n",
       "  15.0,\n",
       "  45.0,\n",
       "  18.0,\n",
       "  27.0,\n",
       "  22.0,\n",
       "  19.0,\n",
       "  26.0,\n",
       "  22.0,\n",
       "  20.0,\n",
       "  32.0,\n",
       "  21.0,\n",
       "  18.0,\n",
       "  26.0,\n",
       "  6.0,\n",
       "  None,\n",
       "  None,\n",
       "  9.0,\n",
       "  40.0,\n",
       "  32.0,\n",
       "  None,\n",
       "  26.0,\n",
       "  18.0,\n",
       "  20.0,\n",
       "  None,\n",
       "  29.0,\n",
       "  22.0,\n",
       "  22.0,\n",
       "  35.0,\n",
       "  21.0,\n",
       "  20.0,\n",
       "  19.0,\n",
       "  18.0,\n",
       "  18.0,\n",
       "  38.0,\n",
       "  None,\n",
       "  30.0,\n",
       "  17.0,\n",
       "  21.0,\n",
       "  21.0,\n",
       "  21.0,\n",
       "  None,\n",
       "  None,\n",
       "  24.0,\n",
       "  33.0,\n",
       "  33.0,\n",
       "  28.0,\n",
       "  16.0,\n",
       "  37.0,\n",
       "  28.0,\n",
       "  None,\n",
       "  24.0,\n",
       "  21.0,\n",
       "  None,\n",
       "  32.0,\n",
       "  29.0,\n",
       "  26.0,\n",
       "  18.0,\n",
       "  20.0,\n",
       "  19.0,\n",
       "  24.0,\n",
       "  24.0,\n",
       "  36.0,\n",
       "  31.0,\n",
       "  31.0,\n",
       "  30.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  43.0,\n",
       "  35.0,\n",
       "  27.0,\n",
       "  19.0,\n",
       "  30.0,\n",
       "  36.0,\n",
       "  3.0,\n",
       "  9.0,\n",
       "  59.0,\n",
       "  19.0,\n",
       "  44.0,\n",
       "  17.0,\n",
       "  None,\n",
       "  45.0,\n",
       "  22.0,\n",
       "  19.0,\n",
       "  29.0,\n",
       "  30.0,\n",
       "  34.0,\n",
       "  28.0,\n",
       "  0.33,\n",
       "  27.0,\n",
       "  25.0,\n",
       "  24.0,\n",
       "  22.0,\n",
       "  21.0,\n",
       "  17.0,\n",
       "  None,\n",
       "  None,\n",
       "  26.0,\n",
       "  33.0,\n",
       "  1.0,\n",
       "  0.17,\n",
       "  25.0,\n",
       "  36.0,\n",
       "  36.0,\n",
       "  30.0,\n",
       "  None,\n",
       "  23.0,\n",
       "  26.0,\n",
       "  19.0,\n",
       "  65.0,\n",
       "  None,\n",
       "  42.0,\n",
       "  43.0,\n",
       "  32.0,\n",
       "  19.0,\n",
       "  30.0,\n",
       "  24.0,\n",
       "  23.0,\n",
       "  None,\n",
       "  24.0,\n",
       "  24.0,\n",
       "  23.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  18.0,\n",
       "  16.0,\n",
       "  45.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  47.0,\n",
       "  5.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  21.0,\n",
       "  18.0,\n",
       "  9.0,\n",
       "  48.0,\n",
       "  16.0,\n",
       "  None,\n",
       "  None,\n",
       "  25.0,\n",
       "  None,\n",
       "  38.0,\n",
       "  22.0,\n",
       "  16.0,\n",
       "  None,\n",
       "  33.0,\n",
       "  None,\n",
       "  9.0,\n",
       "  41.0,\n",
       "  38.0,\n",
       "  40.0,\n",
       "  43.0,\n",
       "  14.0,\n",
       "  16.0,\n",
       "  9.0,\n",
       "  10.0,\n",
       "  6.0,\n",
       "  11.0,\n",
       "  40.0,\n",
       "  32.0,\n",
       "  None,\n",
       "  20.0,\n",
       "  37.0,\n",
       "  28.0,\n",
       "  19.0,\n",
       "  24.0,\n",
       "  17.0,\n",
       "  None,\n",
       "  None,\n",
       "  28.0,\n",
       "  24.0,\n",
       "  20.0,\n",
       "  41.0,\n",
       "  45.0,\n",
       "  26.0,\n",
       "  21.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  27.0,\n",
       "  None,\n",
       "  18.0,\n",
       "  26.0,\n",
       "  23.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  28.0,\n",
       "  22.0,\n",
       "  2.0,\n",
       "  43.0,\n",
       "  None,\n",
       "  27.0,\n",
       "  None,\n",
       "  None,\n",
       "  42.0,\n",
       "  None,\n",
       "  None,\n",
       "  27.0,\n",
       "  25.0,\n",
       "  None,\n",
       "  27.0,\n",
       "  None,\n",
       "  19.0,\n",
       "  20.0,\n",
       "  48.0,\n",
       "  17.0,\n",
       "  None,\n",
       "  None,\n",
       "  34.0,\n",
       "  22.0,\n",
       "  33.0,\n",
       "  32.0,\n",
       "  29.0,\n",
       "  26.0,\n",
       "  49.0,\n",
       "  1.0,\n",
       "  33.0,\n",
       "  4.0,\n",
       "  24.0,\n",
       "  19.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  32.0,\n",
       "  27.0,\n",
       "  21.0,\n",
       "  32.0,\n",
       "  20.0,\n",
       "  17.0,\n",
       "  21.0,\n",
       "  30.0,\n",
       "  21.0,\n",
       "  23.0,\n",
       "  22.0,\n",
       "  4.0,\n",
       "  39.0,\n",
       "  None,\n",
       "  20.0,\n",
       "  None,\n",
       "  None,\n",
       "  21.0,\n",
       "  44.0,\n",
       "  42.0,\n",
       "  21.0,\n",
       "  24.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  25.0,\n",
       "  22.0,\n",
       "  22.0,\n",
       "  39.0,\n",
       "  26.0,\n",
       "  4.0,\n",
       "  22.0,\n",
       "  26.0,\n",
       "  1.5,\n",
       "  36.0,\n",
       "  18.0,\n",
       "  None,\n",
       "  25.0,\n",
       "  None,\n",
       "  37.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  22.0,\n",
       "  20.0,\n",
       "  26.0,\n",
       "  29.0,\n",
       "  29.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  32.0,\n",
       "  None,\n",
       "  21.0,\n",
       "  21.0,\n",
       "  36.0,\n",
       "  39.0,\n",
       "  25.0,\n",
       "  45.0,\n",
       "  36.0,\n",
       "  30.0,\n",
       "  20.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  23.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  21.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  1.5,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  25.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  18.0,\n",
       "  63.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  18.0,\n",
       "  31.0,\n",
       "  31.0,\n",
       "  15.0,\n",
       "  28.0,\n",
       "  36.0,\n",
       "  28.0,\n",
       "  10.0,\n",
       "  36.0,\n",
       "  30.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  29.0,\n",
       "  47.0,\n",
       "  14.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  51.0,\n",
       "  18.0,\n",
       "  45.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  28.0,\n",
       "  21.0,\n",
       "  27.0,\n",
       "  None,\n",
       "  36.0,\n",
       "  None,\n",
       "  27.0,\n",
       "  15.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  27.0,\n",
       "  26.0,\n",
       "  22.0,\n",
       "  24.0,\n",
       "  29.0]}"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Query passengers ages by class\n",
    "session = Session(engine)\n",
    "results = session.query(Passenger.pclass, Passenger.age).all()\n",
    "\n",
    "# Parse results\n",
    "results_dict = {\"1st\": [], \n",
    "                \"2nd\": [], \n",
    "                \"3rd\": []}\n",
    "\n",
    "for pclass, age in results:\n",
    "    results_dict[pclass].append(age)\n",
    "results_dict"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Passenger Survival by Class"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[('1st', 0, 129), ('1st', 1, 193), ('2nd', 0, 161), ('2nd', 1, 119), ('3rd', 0, 573), ('3rd', 1, 138)]\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{'1st': [129, 193], '2nd': [161, 119], '3rd': [573, 138]}"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Query passengers who survived/did not survive grouped by passenger class\n",
    "session = Session(engine)\n",
    "results = session.query(Passenger.pclass, Passenger.survived, func.count(Passenger.pclass)).\\\n",
    "    group_by(Passenger.pclass, Passenger.survived).all()\n",
    "\n",
    "print(results)\n",
    "# Parse results\n",
    "results_dict = {\"1st\": [], \n",
    "                \"2nd\": [], \n",
    "                \"3rd\": []}\n",
    "\n",
    "for pclass, survived, count in results:\n",
    "    results_dict[pclass].append(count)\n",
    "results_dict\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[(0, 129), (1, 193)]\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[129, 193]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Query passengers who survived/did not survive for given passenger class\n",
    "session = Session(engine)\n",
    "results = session.query(Passenger.survived, func.count(Passenger.survived)).\\\n",
    "    filter(Passenger.pclass == \"1st\").\\\n",
    "    group_by(Passenger.survived).all()\n",
    "\n",
    "print(results)\n",
    "# Parse results\n",
    "results_dict = []\n",
    "\n",
    "for survived, count in results:\n",
    "    results_dict.append(count)\n",
    "results_dict"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Passenger Survival by Class and Gender"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[('1st', 'female', 0, 9), ('1st', 'female', 1, 134), ('1st', 'male', 0, 120), ('1st', 'male', 1, 59), ('2nd', 'female', 0, 13), ('2nd', 'female', 1, 94), ('2nd', 'male', 0, 148), ('2nd', 'male', 1, 25), ('3rd', 'female', 0, 132), ('3rd', 'female', 1, 80), ('3rd', 'male', 0, 441), ('3rd', 'male', 1, 58)]\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "{'1st': [9, 134, 120, 59], '2nd': [13, 94, 148, 25], '3rd': [132, 80, 441, 58]}"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Query passengers who survived/did not survive grouped by class and gender\n",
    "session = Session(engine)\n",
    "results = session.query(Passenger.pclass, Passenger.sex, Passenger.survived, func.count(Passenger.pclass)).\\\n",
    "    group_by(Passenger.pclass, Passenger.sex, Passenger.survived).all()\n",
    "\n",
    "print(results)\n",
    "# Parse results\n",
    "results_dict = {\"1st\": [],\n",
    "                \"2nd\": [],\n",
    "                \"3rd\": []}\n",
    "\n",
    "for pclass, sex, survived, count in results:\n",
    "    results_dict[pclass].append(count)\n",
    "results_dict"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Passenger Survival by Age and Gender"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'1st 0': [2.0,\n",
       "  30.0,\n",
       "  25.0,\n",
       "  39.0,\n",
       "  71.0,\n",
       "  47.0,\n",
       "  None,\n",
       "  24.0,\n",
       "  36.0,\n",
       "  25.0,\n",
       "  45.0,\n",
       "  None,\n",
       "  41.0,\n",
       "  48.0,\n",
       "  None,\n",
       "  45.0,\n",
       "  33.0,\n",
       "  None,\n",
       "  None,\n",
       "  49.0,\n",
       "  36.0,\n",
       "  46.0,\n",
       "  None,\n",
       "  27.0,\n",
       "  None,\n",
       "  None,\n",
       "  37.0,\n",
       "  None,\n",
       "  70.0,\n",
       "  39.0,\n",
       "  31.0,\n",
       "  50.0,\n",
       "  39.0,\n",
       "  36.0,\n",
       "  30.0,\n",
       "  19.0,\n",
       "  64.0,\n",
       "  None,\n",
       "  37.0,\n",
       "  47.0,\n",
       "  71.0,\n",
       "  38.0,\n",
       "  46.0,\n",
       "  45.0,\n",
       "  55.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  42.0,\n",
       "  None,\n",
       "  50.0,\n",
       "  46.0,\n",
       "  None,\n",
       "  58.0,\n",
       "  41.0,\n",
       "  None,\n",
       "  None,\n",
       "  42.0,\n",
       "  None,\n",
       "  29.0,\n",
       "  30.0,\n",
       "  30.0,\n",
       "  None,\n",
       "  46.0,\n",
       "  54.0,\n",
       "  28.0,\n",
       "  65.0,\n",
       "  44.0,\n",
       "  55.0,\n",
       "  47.0,\n",
       "  36.0,\n",
       "  58.0,\n",
       "  64.0,\n",
       "  64.0,\n",
       "  28.0,\n",
       "  None,\n",
       "  None,\n",
       "  22.0,\n",
       "  None,\n",
       "  18.0,\n",
       "  46.0,\n",
       "  None,\n",
       "  31.0,\n",
       "  None,\n",
       "  None,\n",
       "  55.0,\n",
       "  None,\n",
       "  61.0,\n",
       "  50.0,\n",
       "  56.0,\n",
       "  56.0,\n",
       "  24.0,\n",
       "  None,\n",
       "  57.0,\n",
       "  62.0,\n",
       "  None,\n",
       "  67.0,\n",
       "  63.0,\n",
       "  61.0,\n",
       "  52.0,\n",
       "  49.0,\n",
       "  46.0,\n",
       "  None,\n",
       "  61.0,\n",
       "  47.0,\n",
       "  64.0,\n",
       "  60.0,\n",
       "  54.0,\n",
       "  21.0,\n",
       "  57.0,\n",
       "  50.0,\n",
       "  27.0,\n",
       "  51.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  40.0,\n",
       "  None,\n",
       "  32.0,\n",
       "  None,\n",
       "  None,\n",
       "  33.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " '1st 1': [29.0,\n",
       "  0.92,\n",
       "  47.0,\n",
       "  63.0,\n",
       "  58.0,\n",
       "  19.0,\n",
       "  None,\n",
       "  None,\n",
       "  50.0,\n",
       "  37.0,\n",
       "  47.0,\n",
       "  26.0,\n",
       "  25.0,\n",
       "  19.0,\n",
       "  28.0,\n",
       "  39.0,\n",
       "  30.0,\n",
       "  58.0,\n",
       "  45.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  44.0,\n",
       "  59.0,\n",
       "  60.0,\n",
       "  None,\n",
       "  53.0,\n",
       "  58.0,\n",
       "  36.0,\n",
       "  36.0,\n",
       "  36.0,\n",
       "  14.0,\n",
       "  11.0,\n",
       "  None,\n",
       "  None,\n",
       "  47.0,\n",
       "  27.0,\n",
       "  31.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  26.0,\n",
       "  64.0,\n",
       "  39.0,\n",
       "  55.0,\n",
       "  69.0,\n",
       "  36.0,\n",
       "  38.0,\n",
       "  None,\n",
       "  27.0,\n",
       "  27.0,\n",
       "  None,\n",
       "  31.0,\n",
       "  17.0,\n",
       "  None,\n",
       "  None,\n",
       "  4.0,\n",
       "  27.0,\n",
       "  48.0,\n",
       "  49.0,\n",
       "  48.0,\n",
       "  23.0,\n",
       "  53.0,\n",
       "  None,\n",
       "  None,\n",
       "  24.0,\n",
       "  28.0,\n",
       "  23.0,\n",
       "  60.0,\n",
       "  49.0,\n",
       "  None,\n",
       "  44.0,\n",
       "  22.0,\n",
       "  60.0,\n",
       "  48.0,\n",
       "  35.0,\n",
       "  22.0,\n",
       "  45.0,\n",
       "  49.0,\n",
       "  None,\n",
       "  54.0,\n",
       "  19.0,\n",
       "  58.0,\n",
       "  45.0,\n",
       "  23.0,\n",
       "  25.0,\n",
       "  21.0,\n",
       "  48.0,\n",
       "  49.0,\n",
       "  36.0,\n",
       "  None,\n",
       "  52.0,\n",
       "  24.0,\n",
       "  16.0,\n",
       "  44.0,\n",
       "  51.0,\n",
       "  35.0,\n",
       "  35.0,\n",
       "  38.0,\n",
       "  35.0,\n",
       "  49.0,\n",
       "  None,\n",
       "  42.0,\n",
       "  40.0,\n",
       "  None,\n",
       "  55.0,\n",
       "  50.0,\n",
       "  16.0,\n",
       "  21.0,\n",
       "  15.0,\n",
       "  None,\n",
       "  None,\n",
       "  36.0,\n",
       "  None,\n",
       "  33.0,\n",
       "  37.0,\n",
       "  None,\n",
       "  31.0,\n",
       "  23.0,\n",
       "  19.0,\n",
       "  None,\n",
       "  22.0,\n",
       "  None,\n",
       "  17.0,\n",
       "  52.0,\n",
       "  56.0,\n",
       "  None,\n",
       "  43.0,\n",
       "  None,\n",
       "  33.0,\n",
       "  27.0,\n",
       "  54.0,\n",
       "  48.0,\n",
       "  18.0,\n",
       "  13.0,\n",
       "  21.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  34.0,\n",
       "  40.0,\n",
       "  36.0,\n",
       "  39.0,\n",
       "  56.0,\n",
       "  28.0,\n",
       "  18.0,\n",
       "  24.0,\n",
       "  23.0,\n",
       "  45.0,\n",
       "  40.0,\n",
       "  6.0,\n",
       "  None,\n",
       "  32.0,\n",
       "  54.0,\n",
       "  43.0,\n",
       "  52.0,\n",
       "  62.0,\n",
       "  46.0,\n",
       "  39.0,\n",
       "  18.0,\n",
       "  48.0,\n",
       "  None,\n",
       "  39.0,\n",
       "  17.0,\n",
       "  None,\n",
       "  31.0,\n",
       "  60.0,\n",
       "  55.0,\n",
       "  45.0,\n",
       "  31.0,\n",
       "  50.0,\n",
       "  20.0,\n",
       "  21.0,\n",
       "  None,\n",
       "  36.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " '2nd 0': [30.0,\n",
       "  18.0,\n",
       "  None,\n",
       "  34.0,\n",
       "  57.0,\n",
       "  18.0,\n",
       "  23.0,\n",
       "  28.0,\n",
       "  51.0,\n",
       "  28.0,\n",
       "  23.0,\n",
       "  26.0,\n",
       "  None,\n",
       "  27.0,\n",
       "  45.0,\n",
       "  25.0,\n",
       "  25.0,\n",
       "  None,\n",
       "  None,\n",
       "  19.0,\n",
       "  54.0,\n",
       "  44.0,\n",
       "  52.0,\n",
       "  30.0,\n",
       "  30.0,\n",
       "  29.0,\n",
       "  29.0,\n",
       "  27.0,\n",
       "  35.0,\n",
       "  22.0,\n",
       "  30.0,\n",
       "  None,\n",
       "  20.0,\n",
       "  None,\n",
       "  21.0,\n",
       "  18.0,\n",
       "  None,\n",
       "  28.0,\n",
       "  25.0,\n",
       "  18.0,\n",
       "  None,\n",
       "  42.0,\n",
       "  23.0,\n",
       "  21.0,\n",
       "  19.0,\n",
       "  None,\n",
       "  None,\n",
       "  38.0,\n",
       "  None,\n",
       "  38.0,\n",
       "  35.0,\n",
       "  35.0,\n",
       "  38.0,\n",
       "  16.0,\n",
       "  26.0,\n",
       "  45.0,\n",
       "  24.0,\n",
       "  21.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  34.0,\n",
       "  30.0,\n",
       "  50.0,\n",
       "  30.0,\n",
       "  44.0,\n",
       "  28.0,\n",
       "  None,\n",
       "  43.0,\n",
       "  49.0,\n",
       "  34.0,\n",
       "  32.0,\n",
       "  21.0,\n",
       "  18.0,\n",
       "  23.0,\n",
       "  None,\n",
       "  52.0,\n",
       "  42.0,\n",
       "  21.0,\n",
       "  None,\n",
       "  None,\n",
       "  33.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  34.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  31.0,\n",
       "  30.0,\n",
       "  26.0,\n",
       "  None,\n",
       "  26.0,\n",
       "  None,\n",
       "  25.0,\n",
       "  None,\n",
       "  48.0,\n",
       "  57.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  27.0,\n",
       "  30.0,\n",
       "  20.0,\n",
       "  45.0,\n",
       "  None,\n",
       "  46.0,\n",
       "  30.0,\n",
       "  48.0,\n",
       "  71.0,\n",
       "  54.0,\n",
       "  None,\n",
       "  None,\n",
       "  64.0,\n",
       "  32.0,\n",
       "  32.0,\n",
       "  26.0,\n",
       "  19.0,\n",
       "  None,\n",
       "  39.0,\n",
       "  24.0,\n",
       "  28.0,\n",
       "  None,\n",
       "  20.0,\n",
       "  40.0,\n",
       "  21.0,\n",
       "  34.0,\n",
       "  None,\n",
       "  36.0,\n",
       "  34.0,\n",
       "  23.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  59.0,\n",
       "  35.0,\n",
       "  22.0,\n",
       "  25.0,\n",
       "  41.0,\n",
       "  25.0,\n",
       "  14.0,\n",
       "  22.0,\n",
       "  29.0,\n",
       "  27.0,\n",
       "  30.0,\n",
       "  22.0,\n",
       "  30.0,\n",
       "  23.0,\n",
       "  None,\n",
       "  28.0,\n",
       "  36.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  30.0,\n",
       "  None,\n",
       "  18.0],\n",
       " '2nd 1': [28.0,\n",
       "  32.0,\n",
       "  36.0,\n",
       "  32.0,\n",
       "  19.0,\n",
       "  36.0,\n",
       "  4.0,\n",
       "  1.0,\n",
       "  12.0,\n",
       "  34.0,\n",
       "  19.0,\n",
       "  15.0,\n",
       "  40.0,\n",
       "  20.0,\n",
       "  36.0,\n",
       "  42.0,\n",
       "  26.0,\n",
       "  26.0,\n",
       "  0.83,\n",
       "  31.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  24.0,\n",
       "  31.0,\n",
       "  8.0,\n",
       "  49.0,\n",
       "  8.0,\n",
       "  28.0,\n",
       "  22.0,\n",
       "  32.0,\n",
       "  18.0,\n",
       "  34.0,\n",
       "  8.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  24.0,\n",
       "  23.0,\n",
       "  1.0,\n",
       "  6.0,\n",
       "  30.0,\n",
       "  45.0,\n",
       "  7.0,\n",
       "  24.0,\n",
       "  24.0,\n",
       "  48.0,\n",
       "  None,\n",
       "  53.0,\n",
       "  21.0,\n",
       "  36.0,\n",
       "  41.0,\n",
       "  17.0,\n",
       "  None,\n",
       "  23.0,\n",
       "  None,\n",
       "  None,\n",
       "  45.0,\n",
       "  34.0,\n",
       "  22.0,\n",
       "  1.0,\n",
       "  3.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  2.0,\n",
       "  19.0,\n",
       "  41.0,\n",
       "  13.0,\n",
       "  19.0,\n",
       "  18.0,\n",
       "  2.0,\n",
       "  3.0,\n",
       "  20.0,\n",
       "  29.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  None,\n",
       "  50.0,\n",
       "  42.0,\n",
       "  32.0,\n",
       "  None,\n",
       "  33.0,\n",
       "  2.0,\n",
       "  8.0,\n",
       "  30.0,\n",
       "  28.0,\n",
       "  0.8,\n",
       "  25.0,\n",
       "  3.0,\n",
       "  50.0,\n",
       "  21.0,\n",
       "  25.0,\n",
       "  18.0,\n",
       "  20.0,\n",
       "  30.0,\n",
       "  30.0,\n",
       "  None,\n",
       "  50.0,\n",
       "  None,\n",
       "  27.0,\n",
       "  35.0,\n",
       "  28.0,\n",
       "  12.0,\n",
       "  40.0,\n",
       "  36.0,\n",
       "  32.0,\n",
       "  29.0,\n",
       "  4.0,\n",
       "  2.0,\n",
       "  None,\n",
       "  None,\n",
       "  33.0,\n",
       "  32.0,\n",
       "  None,\n",
       "  None,\n",
       "  26.0,\n",
       "  24.0],\n",
       " '3rd 0': [42.0,\n",
       "  13.0,\n",
       "  16.0,\n",
       "  30.0,\n",
       "  26.0,\n",
       "  40.0,\n",
       "  24.0,\n",
       "  41.0,\n",
       "  23.0,\n",
       "  20.0,\n",
       "  25.0,\n",
       "  35.0,\n",
       "  17.0,\n",
       "  32.0,\n",
       "  20.0,\n",
       "  39.0,\n",
       "  39.0,\n",
       "  6.0,\n",
       "  2.0,\n",
       "  38.0,\n",
       "  9.0,\n",
       "  26.0,\n",
       "  11.0,\n",
       "  4.0,\n",
       "  20.0,\n",
       "  26.0,\n",
       "  25.0,\n",
       "  18.0,\n",
       "  24.0,\n",
       "  35.0,\n",
       "  40.0,\n",
       "  5.0,\n",
       "  9.0,\n",
       "  13.0,\n",
       "  None,\n",
       "  23.0,\n",
       "  17.0,\n",
       "  27.0,\n",
       "  23.0,\n",
       "  20.0,\n",
       "  32.0,\n",
       "  40.0,\n",
       "  26.0,\n",
       "  45.0,\n",
       "  18.0,\n",
       "  27.0,\n",
       "  22.0,\n",
       "  19.0,\n",
       "  26.0,\n",
       "  22.0,\n",
       "  20.0,\n",
       "  21.0,\n",
       "  18.0,\n",
       "  26.0,\n",
       "  6.0,\n",
       "  None,\n",
       "  None,\n",
       "  9.0,\n",
       "  40.0,\n",
       "  32.0,\n",
       "  None,\n",
       "  26.0,\n",
       "  20.0,\n",
       "  None,\n",
       "  29.0,\n",
       "  22.0,\n",
       "  22.0,\n",
       "  35.0,\n",
       "  20.0,\n",
       "  19.0,\n",
       "  18.0,\n",
       "  18.0,\n",
       "  38.0,\n",
       "  None,\n",
       "  30.0,\n",
       "  17.0,\n",
       "  21.0,\n",
       "  21.0,\n",
       "  21.0,\n",
       "  None,\n",
       "  None,\n",
       "  24.0,\n",
       "  33.0,\n",
       "  33.0,\n",
       "  28.0,\n",
       "  37.0,\n",
       "  28.0,\n",
       "  24.0,\n",
       "  21.0,\n",
       "  None,\n",
       "  32.0,\n",
       "  29.0,\n",
       "  26.0,\n",
       "  18.0,\n",
       "  20.0,\n",
       "  24.0,\n",
       "  24.0,\n",
       "  36.0,\n",
       "  31.0,\n",
       "  31.0,\n",
       "  30.0,\n",
       "  None,\n",
       "  43.0,\n",
       "  35.0,\n",
       "  27.0,\n",
       "  19.0,\n",
       "  30.0,\n",
       "  59.0,\n",
       "  19.0,\n",
       "  44.0,\n",
       "  None,\n",
       "  22.0,\n",
       "  19.0,\n",
       "  34.0,\n",
       "  28.0,\n",
       "  0.33,\n",
       "  27.0,\n",
       "  25.0,\n",
       "  24.0,\n",
       "  22.0,\n",
       "  21.0,\n",
       "  17.0,\n",
       "  None,\n",
       "  26.0,\n",
       "  25.0,\n",
       "  None,\n",
       "  23.0,\n",
       "  26.0,\n",
       "  65.0,\n",
       "  None,\n",
       "  42.0,\n",
       "  43.0,\n",
       "  32.0,\n",
       "  24.0,\n",
       "  None,\n",
       "  23.0,\n",
       "  None,\n",
       "  18.0,\n",
       "  16.0,\n",
       "  45.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  47.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  21.0,\n",
       "  18.0,\n",
       "  9.0,\n",
       "  48.0,\n",
       "  16.0,\n",
       "  None,\n",
       "  None,\n",
       "  25.0,\n",
       "  None,\n",
       "  22.0,\n",
       "  33.0,\n",
       "  41.0,\n",
       "  38.0,\n",
       "  40.0,\n",
       "  43.0,\n",
       "  14.0,\n",
       "  16.0,\n",
       "  9.0,\n",
       "  10.0,\n",
       "  6.0,\n",
       "  11.0,\n",
       "  40.0,\n",
       "  32.0,\n",
       "  None,\n",
       "  20.0,\n",
       "  37.0,\n",
       "  28.0,\n",
       "  19.0,\n",
       "  24.0,\n",
       "  17.0,\n",
       "  None,\n",
       "  None,\n",
       "  28.0,\n",
       "  20.0,\n",
       "  41.0,\n",
       "  26.0,\n",
       "  21.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  18.0,\n",
       "  23.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  28.0,\n",
       "  2.0,\n",
       "  43.0,\n",
       "  None,\n",
       "  None,\n",
       "  42.0,\n",
       "  None,\n",
       "  27.0,\n",
       "  25.0,\n",
       "  None,\n",
       "  None,\n",
       "  20.0,\n",
       "  48.0,\n",
       "  17.0,\n",
       "  None,\n",
       "  34.0,\n",
       "  22.0,\n",
       "  33.0,\n",
       "  29.0,\n",
       "  49.0,\n",
       "  33.0,\n",
       "  24.0,\n",
       "  19.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  27.0,\n",
       "  21.0,\n",
       "  20.0,\n",
       "  17.0,\n",
       "  21.0,\n",
       "  30.0,\n",
       "  23.0,\n",
       "  22.0,\n",
       "  39.0,\n",
       "  None,\n",
       "  20.0,\n",
       "  None,\n",
       "  None,\n",
       "  44.0,\n",
       "  42.0,\n",
       "  24.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  25.0,\n",
       "  22.0,\n",
       "  22.0,\n",
       "  26.0,\n",
       "  22.0,\n",
       "  26.0,\n",
       "  1.5,\n",
       "  36.0,\n",
       "  18.0,\n",
       "  None,\n",
       "  None,\n",
       "  37.0,\n",
       "  None,\n",
       "  None,\n",
       "  20.0,\n",
       "  29.0,\n",
       "  29.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  32.0,\n",
       "  None,\n",
       "  21.0,\n",
       "  21.0,\n",
       "  36.0,\n",
       "  39.0,\n",
       "  25.0,\n",
       "  45.0,\n",
       "  36.0,\n",
       "  30.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  23.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  21.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  1.5,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  18.0,\n",
       "  31.0,\n",
       "  31.0,\n",
       "  15.0,\n",
       "  28.0,\n",
       "  36.0,\n",
       "  28.0,\n",
       "  10.0,\n",
       "  36.0,\n",
       "  30.0,\n",
       "  None,\n",
       "  29.0,\n",
       "  47.0,\n",
       "  14.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  51.0,\n",
       "  18.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  28.0,\n",
       "  21.0,\n",
       "  27.0,\n",
       "  None,\n",
       "  36.0,\n",
       "  27.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  27.0,\n",
       "  26.0,\n",
       "  22.0,\n",
       "  24.0,\n",
       "  29.0],\n",
       " '3rd 1': [35.0,\n",
       "  16.0,\n",
       "  25.0,\n",
       "  18.0,\n",
       "  20.0,\n",
       "  18.0,\n",
       "  0.83,\n",
       "  17.0,\n",
       "  38.0,\n",
       "  3.0,\n",
       "  23.0,\n",
       "  5.0,\n",
       "  45.0,\n",
       "  33.0,\n",
       "  3.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  18.0,\n",
       "  15.0,\n",
       "  32.0,\n",
       "  18.0,\n",
       "  21.0,\n",
       "  16.0,\n",
       "  None,\n",
       "  19.0,\n",
       "  22.0,\n",
       "  36.0,\n",
       "  3.0,\n",
       "  9.0,\n",
       "  17.0,\n",
       "  45.0,\n",
       "  29.0,\n",
       "  30.0,\n",
       "  None,\n",
       "  33.0,\n",
       "  1.0,\n",
       "  0.17,\n",
       "  36.0,\n",
       "  36.0,\n",
       "  30.0,\n",
       "  19.0,\n",
       "  19.0,\n",
       "  30.0,\n",
       "  23.0,\n",
       "  24.0,\n",
       "  24.0,\n",
       "  22.0,\n",
       "  5.0,\n",
       "  None,\n",
       "  None,\n",
       "  38.0,\n",
       "  16.0,\n",
       "  None,\n",
       "  None,\n",
       "  9.0,\n",
       "  24.0,\n",
       "  45.0,\n",
       "  27.0,\n",
       "  26.0,\n",
       "  22.0,\n",
       "  22.0,\n",
       "  27.0,\n",
       "  None,\n",
       "  None,\n",
       "  27.0,\n",
       "  19.0,\n",
       "  None,\n",
       "  32.0,\n",
       "  26.0,\n",
       "  1.0,\n",
       "  4.0,\n",
       "  32.0,\n",
       "  32.0,\n",
       "  21.0,\n",
       "  4.0,\n",
       "  21.0,\n",
       "  21.0,\n",
       "  39.0,\n",
       "  4.0,\n",
       "  25.0,\n",
       "  None,\n",
       "  22.0,\n",
       "  26.0,\n",
       "  None,\n",
       "  20.0,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  None,\n",
       "  25.0,\n",
       "  18.0,\n",
       "  63.0,\n",
       "  22.0,\n",
       "  None,\n",
       "  45.0,\n",
       "  None,\n",
       "  15.0]}"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Query passengers who survived/did not survive grouped by class and gender\n",
    "session = Session(engine)\n",
    "results = session.query(Passenger.pclass, Passenger.age, Passenger.survived).all()\n",
    "\n",
    "# Parse results\n",
    "results_dict = {\"1st 0\": [],\n",
    "                \"1st 1\": [],\n",
    "                \"2nd 0\": [],\n",
    "                \"2nd 1\": [],\n",
    "                \"3rd 0\": [],\n",
    "                \"3rd 1\": []}\n",
    "\n",
    "for pclass, age, survived in results:\n",
    "    new_str = pclass + \" \" + str(survived)\n",
    "    results_dict[new_str].append(age)\n",
    "results_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}