The ‘Magic’ Methods of the vDataFrame#
VerticaPy 0.3.2 introduces the ‘Magic’ methods, which offer some additional flexilibility for mathematical operations in the vDataFrame. These methods let you handle many operations in a ‘pandas-like’ or Pythonic style.
[11]:
from verticapy.datasets import load_titanic
titanic = load_titanic()
display(titanic)
123 pclassInt | 123 survivedInt | Abc Varchar(164) | Abc sexVarchar(20) | 123 ageNumeric(6,3) | 123 sibspInt | 123 parchInt | Abc ticketVarchar(36) | 123 fareNumeric(10,5) | Abc cabinVarchar(30) | Abc embarkedVarchar(20) | Abc boatVarchar(100) | 123 bodyInt | Abc home.destVarchar(100) | |
1 | 1 | 0 | female | 2.0 | 1 | 2 | 113781 | 151.55 | C22 C26 | S | [null] | [null] | Montreal, PQ / Chesterville, ON | |
2 | 1 | 0 | male | 30.0 | 1 | 2 | 113781 | 151.55 | C22 C26 | S | [null] | 135 | Montreal, PQ / Chesterville, ON | |
3 | 1 | 0 | female | 25.0 | 1 | 2 | 113781 | 151.55 | C22 C26 | S | [null] | [null] | Montreal, PQ / Chesterville, ON | |
4 | 1 | 0 | male | 39.0 | 0 | 0 | 112050 | 0.0 | A36 | S | [null] | [null] | Belfast, NI | |
5 | 1 | 0 | male | 71.0 | 0 | 0 | PC 17609 | 49.5042 | [null] | C | [null] | 22 | Montevideo, Uruguay | |
6 | 1 | 0 | male | 47.0 | 1 | 0 | PC 17757 | 227.525 | C62 C64 | C | [null] | 124 | New York, NY | |
7 | 1 | 0 | male | [null] | 0 | 0 | PC 17318 | 25.925 | [null] | S | [null] | [null] | New York, NY | |
8 | 1 | 0 | male | 24.0 | 0 | 1 | PC 17558 | 247.5208 | B58 B60 | C | [null] | [null] | Montreal, PQ | |
9 | 1 | 0 | male | 36.0 | 0 | 0 | 13050 | 75.2417 | C6 | C | A | [null] | Winnipeg, MN | |
10 | 1 | 0 | male | 25.0 | 0 | 0 | 13905 | 26.0 | [null] | C | [null] | 148 | San Francisco, CA | |
11 | 1 | 0 | male | 45.0 | 0 | 0 | 113784 | 35.5 | T | S | [null] | [null] | Trenton, NJ | |
12 | 1 | 0 | male | 42.0 | 0 | 0 | 110489 | 26.55 | D22 | S | [null] | [null] | London / Winnipeg, MB | |
13 | 1 | 0 | male | 41.0 | 0 | 0 | 113054 | 30.5 | A21 | S | [null] | [null] | Pomeroy, WA | |
14 | 1 | 0 | male | 48.0 | 0 | 0 | PC 17591 | 50.4958 | B10 | C | [null] | 208 | Omaha, NE | |
15 | 1 | 0 | male | [null] | 0 | 0 | 112379 | 39.6 | [null] | C | [null] | [null] | Philadelphia, PA | |
16 | 1 | 0 | male | 45.0 | 0 | 0 | 113050 | 26.55 | B38 | S | [null] | [null] | Washington, DC | |
17 | 1 | 0 | male | [null] | 0 | 0 | 113798 | 31.0 | [null] | S | [null] | [null] | [null] | |
18 | 1 | 0 | male | 33.0 | 0 | 0 | 695 | 5.0 | B51 B53 B55 | S | [null] | [null] | New York, NY | |
19 | 1 | 0 | male | 28.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | Montevideo, Uruguay | |
20 | 1 | 0 | male | 17.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | Montevideo, Uruguay | |
21 | 1 | 0 | male | 49.0 | 0 | 0 | 19924 | 26.0 | [null] | S | [null] | [null] | Ascot, Berkshire / Rochester, NY | |
22 | 1 | 0 | male | 36.0 | 1 | 0 | 19877 | 78.85 | C46 | S | [null] | 172 | Little Onn Hall, Staffs | |
23 | 1 | 0 | male | 46.0 | 1 | 0 | W.E.P. 5734 | 61.175 | E31 | S | [null] | [null] | Amenia, ND | |
24 | 1 | 0 | male | [null] | 0 | 0 | 112051 | 0.0 | [null] | S | [null] | [null] | Liverpool, England / Belfast | |
25 | 1 | 0 | male | 27.0 | 1 | 0 | 13508 | 136.7792 | C89 | C | [null] | [null] | Los Angeles, CA | |
26 | 1 | 0 | male | [null] | 0 | 0 | 110465 | 52.0 | A14 | S | [null] | [null] | Stoughton, MA | |
27 | 1 | 0 | male | 47.0 | 0 | 0 | 5727 | 25.5875 | E58 | S | [null] | [null] | Victoria, BC | |
28 | 1 | 0 | male | 37.0 | 1 | 1 | PC 17756 | 83.1583 | E52 | C | [null] | [null] | Lakewood, NJ | |
29 | 1 | 0 | male | [null] | 0 | 0 | 113791 | 26.55 | [null] | S | [null] | [null] | Roachdale, IN | |
30 | 1 | 0 | male | 70.0 | 1 | 1 | WE/P 5735 | 71.0 | B22 | S | [null] | 269 | Milwaukee, WI | |
31 | 1 | 0 | male | 39.0 | 1 | 0 | PC 17599 | 71.2833 | C85 | C | [null] | [null] | New York, NY | |
32 | 1 | 0 | male | 31.0 | 1 | 0 | F.C. 12750 | 52.0 | B71 | S | [null] | [null] | Montreal, PQ | |
33 | 1 | 0 | male | 50.0 | 1 | 0 | PC 17761 | 106.425 | C86 | C | [null] | 62 | Deephaven, MN / Cedar Rapids, IA | |
34 | 1 | 0 | male | 39.0 | 0 | 0 | PC 17580 | 29.7 | A18 | C | [null] | 133 | Philadelphia, PA | |
35 | 1 | 0 | female | 36.0 | 0 | 0 | PC 17531 | 31.6792 | A29 | C | [null] | [null] | New York, NY | |
36 | 1 | 0 | male | [null] | 0 | 0 | PC 17483 | 221.7792 | C95 | S | [null] | [null] | [null] | |
37 | 1 | 0 | male | 30.0 | 0 | 0 | 113051 | 27.75 | C111 | C | [null] | [null] | New York, NY | |
38 | 1 | 0 | male | 19.0 | 3 | 2 | 19950 | 263.0 | C23 C25 C27 | S | [null] | [null] | Winnipeg, MB | |
39 | 1 | 0 | male | 64.0 | 1 | 4 | 19950 | 263.0 | C23 C25 C27 | S | [null] | [null] | Winnipeg, MB | |
40 | 1 | 0 | male | [null] | 0 | 0 | 113778 | 26.55 | D34 | S | [null] | [null] | Westcliff-on-Sea, Essex | |
41 | 1 | 0 | male | [null] | 0 | 0 | 112058 | 0.0 | B102 | S | [null] | [null] | [null] | |
42 | 1 | 0 | male | 37.0 | 1 | 0 | 113803 | 53.1 | C123 | S | [null] | [null] | Scituate, MA | |
43 | 1 | 0 | male | 47.0 | 0 | 0 | 111320 | 38.5 | E63 | S | [null] | 275 | St Anne's-on-Sea, Lancashire | |
44 | 1 | 0 | male | 24.0 | 0 | 0 | PC 17593 | 79.2 | B86 | C | [null] | [null] | [null] | |
45 | 1 | 0 | male | 71.0 | 0 | 0 | PC 17754 | 34.6542 | A5 | C | [null] | [null] | New York, NY | |
46 | 1 | 0 | male | 38.0 | 0 | 1 | PC 17582 | 153.4625 | C91 | S | [null] | 147 | Winnipeg, MB | |
47 | 1 | 0 | male | 46.0 | 0 | 0 | PC 17593 | 79.2 | B82 B84 | C | [null] | [null] | New York, NY | |
48 | 1 | 0 | male | [null] | 0 | 0 | 113796 | 42.4 | [null] | S | [null] | [null] | [null] | |
49 | 1 | 0 | male | 45.0 | 1 | 0 | 36973 | 83.475 | C83 | S | [null] | [null] | New York, NY | |
50 | 1 | 0 | male | 40.0 | 0 | 0 | 112059 | 0.0 | B94 | S | [null] | 110 | [null] | |
51 | 1 | 0 | male | 55.0 | 1 | 1 | 12749 | 93.5 | B69 | S | [null] | 307 | Montreal, PQ | |
52 | 1 | 0 | male | 42.0 | 0 | 0 | 113038 | 42.5 | B11 | S | [null] | [null] | London / Middlesex | |
53 | 1 | 0 | male | [null] | 0 | 0 | 17463 | 51.8625 | E46 | S | [null] | [null] | Brighton, MA | |
54 | 1 | 0 | male | 55.0 | 0 | 0 | 680 | 50.0 | C39 | S | [null] | [null] | London / Birmingham | |
55 | 1 | 0 | male | 42.0 | 1 | 0 | 113789 | 52.0 | [null] | S | [null] | 38 | New York, NY | |
56 | 1 | 0 | male | [null] | 0 | 0 | PC 17600 | 30.6958 | [null] | C | 14 | [null] | New York, NY | |
57 | 1 | 0 | female | 50.0 | 0 | 0 | PC 17595 | 28.7125 | C49 | C | [null] | [null] | Paris, France New York, NY | |
58 | 1 | 0 | male | 46.0 | 0 | 0 | 694 | 26.0 | [null] | S | [null] | 80 | Bennington, VT | |
59 | 1 | 0 | male | 50.0 | 0 | 0 | 113044 | 26.0 | E60 | S | [null] | [null] | London | |
60 | 1 | 0 | male | 32.5 | 0 | 0 | 113503 | 211.5 | C132 | C | [null] | 45 | [null] | |
61 | 1 | 0 | male | 58.0 | 0 | 0 | 11771 | 29.7 | B37 | C | [null] | 258 | Buffalo, NY | |
62 | 1 | 0 | male | 41.0 | 1 | 0 | 17464 | 51.8625 | D21 | S | [null] | [null] | Southington / Noank, CT | |
63 | 1 | 0 | male | [null] | 0 | 0 | 113028 | 26.55 | C124 | S | [null] | [null] | Portland, OR | |
64 | 1 | 0 | male | [null] | 0 | 0 | PC 17612 | 27.7208 | [null] | C | [null] | [null] | Chicago, IL | |
65 | 1 | 0 | male | 29.0 | 0 | 0 | 113501 | 30.0 | D6 | S | [null] | 126 | Springfield, MA | |
66 | 1 | 0 | male | 30.0 | 0 | 0 | 113801 | 45.5 | [null] | S | [null] | [null] | London / New York, NY | |
67 | 1 | 0 | male | 30.0 | 0 | 0 | 110469 | 26.0 | C106 | S | [null] | [null] | Brockton, MA | |
68 | 1 | 0 | male | 19.0 | 1 | 0 | 113773 | 53.1 | D30 | S | [null] | [null] | New York, NY | |
69 | 1 | 0 | male | 46.0 | 0 | 0 | 13050 | 75.2417 | C6 | C | [null] | 292 | Vancouver, BC | |
70 | 1 | 0 | male | 54.0 | 0 | 0 | 17463 | 51.8625 | E46 | S | [null] | 175 | Dorchester, MA | |
71 | 1 | 0 | male | 28.0 | 1 | 0 | PC 17604 | 82.1708 | [null] | C | [null] | [null] | New York, NY | |
72 | 1 | 0 | male | 65.0 | 0 | 0 | 13509 | 26.55 | E38 | S | [null] | 249 | East Bridgewater, MA | |
73 | 1 | 0 | male | 44.0 | 2 | 0 | 19928 | 90.0 | C78 | Q | [null] | 230 | Fond du Lac, WI | |
74 | 1 | 0 | male | 55.0 | 0 | 0 | 113787 | 30.5 | C30 | S | [null] | [null] | Montreal, PQ | |
75 | 1 | 0 | male | 47.0 | 0 | 0 | 113796 | 42.4 | [null] | S | [null] | [null] | Washington, DC | |
76 | 1 | 0 | male | 37.0 | 0 | 1 | PC 17596 | 29.7 | C118 | C | [null] | [null] | Brooklyn, NY | |
77 | 1 | 0 | male | 58.0 | 0 | 2 | 35273 | 113.275 | D48 | C | [null] | 122 | Lexington, MA | |
78 | 1 | 0 | male | 64.0 | 0 | 0 | 693 | 26.0 | [null] | S | [null] | 263 | Isle of Wight, England | |
79 | 1 | 0 | male | 65.0 | 0 | 1 | 113509 | 61.9792 | B30 | C | [null] | 234 | Providence, RI | |
80 | 1 | 0 | male | 28.5 | 0 | 0 | PC 17562 | 27.7208 | D43 | C | [null] | 189 | ?Havana, Cuba | |
81 | 1 | 0 | male | [null] | 0 | 0 | 112052 | 0.0 | [null] | S | [null] | [null] | Belfast | |
82 | 1 | 0 | male | 45.5 | 0 | 0 | 113043 | 28.5 | C124 | S | [null] | 166 | Surbiton Hill, Surrey | |
83 | 1 | 0 | male | 23.0 | 0 | 0 | 12749 | 93.5 | B24 | S | [null] | [null] | Montreal, PQ | |
84 | 1 | 0 | male | 29.0 | 1 | 0 | 113776 | 66.6 | C2 | S | [null] | [null] | Isleworth, England | |
85 | 1 | 0 | male | 18.0 | 1 | 0 | PC 17758 | 108.9 | C65 | C | [null] | [null] | Madrid, Spain | |
86 | 1 | 0 | male | 47.0 | 0 | 0 | 110465 | 52.0 | C110 | S | [null] | 207 | Worcester, MA | |
87 | 1 | 0 | male | 38.0 | 0 | 0 | 19972 | 0.0 | [null] | S | [null] | [null] | Rotterdam, Netherlands | |
88 | 1 | 0 | male | 22.0 | 0 | 0 | PC 17760 | 135.6333 | [null] | C | [null] | 232 | [null] | |
89 | 1 | 0 | male | [null] | 0 | 0 | PC 17757 | 227.525 | [null] | C | [null] | [null] | [null] | |
90 | 1 | 0 | male | 31.0 | 0 | 0 | PC 17590 | 50.4958 | A24 | S | [null] | [null] | Trenton, NJ | |
91 | 1 | 0 | male | [null] | 0 | 0 | 113767 | 50.0 | A32 | S | [null] | [null] | Seattle, WA | |
92 | 1 | 0 | male | 36.0 | 0 | 0 | 13049 | 40.125 | A10 | C | [null] | [null] | Winnipeg, MB | |
93 | 1 | 0 | male | 55.0 | 1 | 0 | PC 17603 | 59.4 | [null] | C | [null] | [null] | New York, NY | |
94 | 1 | 0 | male | 33.0 | 0 | 0 | 113790 | 26.55 | [null] | S | [null] | 109 | London | |
95 | 1 | 0 | male | 61.0 | 1 | 3 | PC 17608 | 262.375 | B57 B59 B63 B66 | C | [null] | [null] | Haverford, PA / Cooperstown, NY | |
96 | 1 | 0 | male | 50.0 | 1 | 0 | 13507 | 55.9 | E44 | S | [null] | [null] | Duluth, MN | |
97 | 1 | 0 | male | 56.0 | 0 | 0 | 113792 | 26.55 | [null] | S | [null] | [null] | New York, NY | |
98 | 1 | 0 | male | 56.0 | 0 | 0 | 17764 | 30.6958 | A7 | C | [null] | [null] | St James, Long Island, NY | |
99 | 1 | 0 | male | 24.0 | 1 | 0 | 13695 | 60.0 | C31 | S | [null] | [null] | Huntington, WV | |
100 | 1 | 0 | male | [null] | 0 | 0 | 113056 | 26.0 | A19 | S | [null] | [null] | Streatham, Surrey |
Feature Engineering, ‘pandas’-style#
You can create new features with in a ‘pandas’ style.
[12]:
titanic["family_size"] = titanic["parch"] + titanic["sibsp"] + 1
titanic[["sibsp", "parch", "family_size"]]
[12]:
123 sibspInt | 123 parchInt | 123 family_sizeInt | |
1 | 1 | 2 | 4 |
2 | 1 | 2 | 4 |
3 | 1 | 2 | 4 |
4 | 0 | 0 | 1 |
5 | 0 | 0 | 1 |
6 | 1 | 0 | 2 |
7 | 0 | 0 | 1 |
8 | 0 | 1 | 2 |
9 | 0 | 0 | 1 |
10 | 0 | 0 | 1 |
11 | 0 | 0 | 1 |
12 | 0 | 0 | 1 |
13 | 0 | 0 | 1 |
14 | 0 | 0 | 1 |
15 | 0 | 0 | 1 |
16 | 0 | 0 | 1 |
17 | 0 | 0 | 1 |
18 | 0 | 0 | 1 |
19 | 0 | 0 | 1 |
20 | 0 | 0 | 1 |
21 | 0 | 0 | 1 |
22 | 1 | 0 | 2 |
23 | 1 | 0 | 2 |
24 | 0 | 0 | 1 |
25 | 1 | 0 | 2 |
26 | 0 | 0 | 1 |
27 | 0 | 0 | 1 |
28 | 1 | 1 | 3 |
29 | 0 | 0 | 1 |
30 | 1 | 1 | 3 |
31 | 1 | 0 | 2 |
32 | 1 | 0 | 2 |
33 | 1 | 0 | 2 |
34 | 0 | 0 | 1 |
35 | 0 | 0 | 1 |
36 | 0 | 0 | 1 |
37 | 0 | 0 | 1 |
38 | 3 | 2 | 6 |
39 | 1 | 4 | 6 |
40 | 0 | 0 | 1 |
41 | 0 | 0 | 1 |
42 | 1 | 0 | 2 |
43 | 0 | 0 | 1 |
44 | 0 | 0 | 1 |
45 | 0 | 0 | 1 |
46 | 0 | 1 | 2 |
47 | 0 | 0 | 1 |
48 | 0 | 0 | 1 |
49 | 1 | 0 | 2 |
50 | 0 | 0 | 1 |
51 | 1 | 1 | 3 |
52 | 0 | 0 | 1 |
53 | 0 | 0 | 1 |
54 | 0 | 0 | 1 |
55 | 1 | 0 | 2 |
56 | 0 | 0 | 1 |
57 | 0 | 0 | 1 |
58 | 0 | 0 | 1 |
59 | 0 | 0 | 1 |
60 | 0 | 0 | 1 |
61 | 0 | 0 | 1 |
62 | 1 | 0 | 2 |
63 | 0 | 0 | 1 |
64 | 0 | 0 | 1 |
65 | 0 | 0 | 1 |
66 | 0 | 0 | 1 |
67 | 0 | 0 | 1 |
68 | 1 | 0 | 2 |
69 | 0 | 0 | 1 |
70 | 0 | 0 | 1 |
71 | 1 | 0 | 2 |
72 | 0 | 0 | 1 |
73 | 2 | 0 | 3 |
74 | 0 | 0 | 1 |
75 | 0 | 0 | 1 |
76 | 0 | 1 | 2 |
77 | 0 | 2 | 3 |
78 | 0 | 0 | 1 |
79 | 0 | 1 | 2 |
80 | 0 | 0 | 1 |
81 | 0 | 0 | 1 |
82 | 0 | 0 | 1 |
83 | 0 | 0 | 1 |
84 | 1 | 0 | 2 |
85 | 1 | 0 | 2 |
86 | 0 | 0 | 1 |
87 | 0 | 0 | 1 |
88 | 0 | 0 | 1 |
89 | 0 | 0 | 1 |
90 | 0 | 0 | 1 |
91 | 0 | 0 | 1 |
92 | 0 | 0 | 1 |
93 | 1 | 0 | 2 |
94 | 0 | 0 | 1 |
95 | 1 | 3 | 5 |
96 | 1 | 0 | 2 |
97 | 0 | 0 | 1 |
98 | 0 | 0 | 1 |
99 | 1 | 0 | 2 |
100 | 0 | 0 | 1 |
You can also create features from various mathematical functions.
[3]:
import verticapy.stats as st
titanic["ln_fare"] = st.ln(titanic["fare"])
titanic[["fare", "ln_fare"]]
[3]:
123 fareNumeric(10,5) | 123 ln_fareFloat | |
1 | 151.55 | 5.02091560350381 |
2 | 151.55 | 5.02091560350381 |
3 | 151.55 | 5.02091560350381 |
4 | 0.0 | -inf |
5 | 49.5042 | 3.90205751446006 |
6 | 227.525 | 5.42726012246342 |
7 | 25.925 | 3.25520775411559 |
8 | 247.5208 | 5.51149461888159 |
9 | 75.2417 | 4.32070559854228 |
10 | 26.0 | 3.25809653802148 |
11 | 35.5 | 3.56953269648137 |
12 | 26.55 | 3.27902974768795 |
13 | 30.5 | 3.41772668361337 |
14 | 50.4958 | 3.92189016450581 |
15 | 39.6 | 3.67882911826043 |
16 | 26.55 | 3.27902974768795 |
17 | 31.0 | 3.43398720448515 |
18 | 5.0 | 1.6094379124341 |
19 | 47.1 | 3.85227300102237 |
20 | 47.1 | 3.85227300102237 |
21 | 26.0 | 3.25809653802148 |
22 | 78.85 | 4.36754731340905 |
23 | 61.175 | 4.11373860932874 |
24 | 0.0 | -inf |
25 | 136.7792 | 4.91836794684454 |
26 | 52.0 | 3.95124371858143 |
27 | 25.5875 | 3.24210395098741 |
28 | 83.1583 | 4.42074602026042 |
29 | 26.55 | 3.27902974768795 |
30 | 71.0 | 4.26267987704132 |
31 | 71.2833 | 4.26666207838721 |
32 | 52.0 | 3.95124371858143 |
33 | 106.425 | 4.66744051171422 |
34 | 29.7 | 3.39114704580865 |
35 | 31.6792 | 3.45566031410212 |
36 | 221.7792 | 5.40168229234028 |
37 | 27.75 | 3.32323584019244 |
38 | 263.0 | 5.57215403217776 |
39 | 263.0 | 5.57215403217776 |
40 | 26.55 | 3.27902974768795 |
41 | 0.0 | -inf |
42 | 53.1 | 3.97217692824789 |
43 | 38.5 | 3.65065824129374 |
44 | 79.2 | 4.37197629882038 |
45 | 34.6542 | 3.54541893041153 |
46 | 153.4625 | 5.03345623750696 |
47 | 79.2 | 4.37197629882038 |
48 | 42.4 | 3.74714836223791 |
49 | 83.475 | 4.42454718582972 |
50 | 0.0 | -inf |
51 | 93.5 | 4.53796143629464 |
52 | 42.5 | 3.74950407593037 |
53 | 51.8625 | 3.94859598565899 |
54 | 50.0 | 3.91202300542815 |
55 | 52.0 | 3.95124371858143 |
56 | 30.6958 | 3.42412583741652 |
57 | 28.7125 | 3.35733256801522 |
58 | 26.0 | 3.25809653802148 |
59 | 26.0 | 3.25809653802148 |
60 | 211.5 | 5.35422499848633 |
61 | 29.7 | 3.39114704580865 |
62 | 51.8625 | 3.94859598565899 |
63 | 26.55 | 3.27902974768795 |
64 | 27.7208 | 3.32218303393412 |
65 | 30.0 | 3.40119738166216 |
66 | 45.5 | 3.8177123259569 |
67 | 26.0 | 3.25809653802148 |
68 | 53.1 | 3.97217692824789 |
69 | 75.2417 | 4.32070559854228 |
70 | 51.8625 | 3.94859598565899 |
71 | 82.1708 | 4.40880000780905 |
72 | 26.55 | 3.27902974768795 |
73 | 90.0 | 4.49980967033027 |
74 | 30.5 | 3.41772668361337 |
75 | 42.4 | 3.74714836223791 |
76 | 29.7 | 3.39114704580865 |
77 | 113.275 | 4.7298184905532 |
78 | 26.0 | 3.25809653802148 |
79 | 61.9792 | 4.12679884488682 |
80 | 27.7208 | 3.32218303393412 |
81 | 0.0 | -inf |
82 | 28.5 | 3.3499040872746 |
83 | 93.5 | 4.53796143629464 |
84 | 66.6 | 4.19870457754634 |
85 | 108.9 | 4.69043002993891 |
86 | 52.0 | 3.95124371858143 |
87 | 0.0 | -inf |
88 | 135.6333 | 4.90995492057888 |
89 | 227.525 | 5.42726012246342 |
90 | 50.4958 | 3.92189016450581 |
91 | 50.0 | 3.91202300542815 |
92 | 40.125 | 3.69199958145018 |
93 | 59.4 | 4.0842942263686 |
94 | 26.55 | 3.27902974768795 |
95 | 262.375 | 5.5697747781408 |
96 | 55.9 | 4.02356438016105 |
97 | 26.55 | 3.27902974768795 |
98 | 30.6958 | 3.42412583741652 |
99 | 60.0 | 4.0943445622221 |
100 | 26.0 | 3.25809653802148 |
[4]:
titanic["x"] = 1 - st.exp(-titanic["fare"])
titanic[["fare", "x"]]
[4]:
123 fareNumeric(10,5) | 123 xFloat | |
1 | 151.55 | 1.0 |
2 | 151.55 | 1.0 |
3 | 151.55 | 1.0 |
4 | 0.0 | 0.0 |
5 | 49.5042 | 1.0 |
6 | 227.525 | 1.0 |
7 | 25.925 | 0.999999999994493 |
8 | 247.5208 | 1.0 |
9 | 75.2417 | 1.0 |
10 | 26.0 | 0.999999999994891 |
11 | 35.5 | 1.0 |
12 | 26.55 | 0.999999999997052 |
13 | 30.5 | 0.999999999999943 |
14 | 50.4958 | 1.0 |
15 | 39.6 | 1.0 |
16 | 26.55 | 0.999999999997052 |
17 | 31.0 | 0.999999999999966 |
18 | 5.0 | 0.993262053000915 |
19 | 47.1 | 1.0 |
20 | 47.1 | 1.0 |
21 | 26.0 | 0.999999999994891 |
22 | 78.85 | 1.0 |
23 | 61.175 | 1.0 |
24 | 0.0 | 0.0 |
25 | 136.7792 | 1.0 |
26 | 52.0 | 1.0 |
27 | 25.5875 | 0.999999999992282 |
28 | 83.1583 | 1.0 |
29 | 26.55 | 0.999999999997052 |
30 | 71.0 | 1.0 |
31 | 71.2833 | 1.0 |
32 | 52.0 | 1.0 |
33 | 106.425 | 1.0 |
34 | 29.7 | 0.999999999999874 |
35 | 31.6792 | 0.999999999999983 |
36 | 221.7792 | 1.0 |
37 | 27.75 | 0.999999999999112 |
38 | 263.0 | 1.0 |
39 | 263.0 | 1.0 |
40 | 26.55 | 0.999999999997052 |
41 | 0.0 | 0.0 |
42 | 53.1 | 1.0 |
43 | 38.5 | 1.0 |
44 | 79.2 | 1.0 |
45 | 34.6542 | 0.999999999999999 |
46 | 153.4625 | 1.0 |
47 | 79.2 | 1.0 |
48 | 42.4 | 1.0 |
49 | 83.475 | 1.0 |
50 | 0.0 | 0.0 |
51 | 93.5 | 1.0 |
52 | 42.5 | 1.0 |
53 | 51.8625 | 1.0 |
54 | 50.0 | 1.0 |
55 | 52.0 | 1.0 |
56 | 30.6958 | 0.999999999999953 |
57 | 28.7125 | 0.999999999999661 |
58 | 26.0 | 0.999999999994891 |
59 | 26.0 | 0.999999999994891 |
60 | 211.5 | 1.0 |
61 | 29.7 | 0.999999999999874 |
62 | 51.8625 | 1.0 |
63 | 26.55 | 0.999999999997052 |
64 | 27.7208 | 0.999999999999086 |
65 | 30.0 | 0.999999999999906 |
66 | 45.5 | 1.0 |
67 | 26.0 | 0.999999999994891 |
68 | 53.1 | 1.0 |
69 | 75.2417 | 1.0 |
70 | 51.8625 | 1.0 |
71 | 82.1708 | 1.0 |
72 | 26.55 | 0.999999999997052 |
73 | 90.0 | 1.0 |
74 | 30.5 | 0.999999999999943 |
75 | 42.4 | 1.0 |
76 | 29.7 | 0.999999999999874 |
77 | 113.275 | 1.0 |
78 | 26.0 | 0.999999999994891 |
79 | 61.9792 | 1.0 |
80 | 27.7208 | 0.999999999999086 |
81 | 0.0 | 0.0 |
82 | 28.5 | 0.999999999999581 |
83 | 93.5 | 1.0 |
84 | 66.6 | 1.0 |
85 | 108.9 | 1.0 |
86 | 52.0 | 1.0 |
87 | 0.0 | 0.0 |
88 | 135.6333 | 1.0 |
89 | 227.525 | 1.0 |
90 | 50.4958 | 1.0 |
91 | 50.0 | 1.0 |
92 | 40.125 | 1.0 |
93 | 59.4 | 1.0 |
94 | 26.55 | 0.999999999997052 |
95 | 262.375 | 1.0 |
96 | 55.9 | 1.0 |
97 | 26.55 | 0.999999999997052 |
98 | 30.6958 | 0.999999999999953 |
99 | 60.0 | 1.0 |
100 | 26.0 | 0.999999999994891 |
Conditional Operators#
You can now filter your data with conditional operators like and (’&’), or (‘|’), equals (‘==’), not equals (!=), and more!
Equal Operator (==)
[13]:
# Identifies the passengers who came alone
single_family = titanic[titanic["family_size"] == 1]
single_family
[13]:
123 pclassInt | 123 survivedInt | Abc Varchar(164) | Abc sexVarchar(20) | 123 ageNumeric(6,3) | 123 sibspInt | 123 parchInt | Abc ticketVarchar(36) | 123 fareNumeric(10,5) | Abc cabinVarchar(30) | Abc embarkedVarchar(20) | Abc boatVarchar(100) | 123 bodyInt | Abc Varchar(100) | 123 family_sizeInt | |
1 | 1 | 0 | male | 39.0 | 0 | 0 | 112050 | 0.0 | A36 | S | [null] | [null] | 1 | ||
2 | 1 | 0 | male | 71.0 | 0 | 0 | PC 17609 | 49.5042 | [null] | C | [null] | 22 | 1 | ||
3 | 1 | 0 | male | [null] | 0 | 0 | PC 17318 | 25.925 | [null] | S | [null] | [null] | 1 | ||
4 | 1 | 0 | male | 36.0 | 0 | 0 | 13050 | 75.2417 | C6 | C | A | [null] | 1 | ||
5 | 1 | 0 | male | 25.0 | 0 | 0 | 13905 | 26.0 | [null] | C | [null] | 148 | 1 | ||
6 | 1 | 0 | male | 45.0 | 0 | 0 | 113784 | 35.5 | T | S | [null] | [null] | 1 | ||
7 | 1 | 0 | male | 42.0 | 0 | 0 | 110489 | 26.55 | D22 | S | [null] | [null] | 1 | ||
8 | 1 | 0 | male | 41.0 | 0 | 0 | 113054 | 30.5 | A21 | S | [null] | [null] | 1 | ||
9 | 1 | 0 | male | 48.0 | 0 | 0 | PC 17591 | 50.4958 | B10 | C | [null] | 208 | 1 | ||
10 | 1 | 0 | male | [null] | 0 | 0 | 112379 | 39.6 | [null] | C | [null] | [null] | 1 | ||
11 | 1 | 0 | male | 45.0 | 0 | 0 | 113050 | 26.55 | B38 | S | [null] | [null] | 1 | ||
12 | 1 | 0 | male | [null] | 0 | 0 | 113798 | 31.0 | [null] | S | [null] | [null] | 1 | ||
13 | 1 | 0 | male | 33.0 | 0 | 0 | 695 | 5.0 | B51 B53 B55 | S | [null] | [null] | 1 | ||
14 | 1 | 0 | male | 28.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | 1 | ||
15 | 1 | 0 | male | 17.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | 1 | ||
16 | 1 | 0 | male | 49.0 | 0 | 0 | 19924 | 26.0 | [null] | S | [null] | [null] | 1 | ||
17 | 1 | 0 | male | [null] | 0 | 0 | 112051 | 0.0 | [null] | S | [null] | [null] | 1 | ||
18 | 1 | 0 | male | [null] | 0 | 0 | 110465 | 52.0 | A14 | S | [null] | [null] | 1 | ||
19 | 1 | 0 | male | 47.0 | 0 | 0 | 5727 | 25.5875 | E58 | S | [null] | [null] | 1 | ||
20 | 1 | 0 | male | [null] | 0 | 0 | 113791 | 26.55 | [null] | S | [null] | [null] | 1 | ||
21 | 1 | 0 | male | 39.0 | 0 | 0 | PC 17580 | 29.7 | A18 | C | [null] | 133 | 1 | ||
22 | 1 | 0 | female | 36.0 | 0 | 0 | PC 17531 | 31.6792 | A29 | C | [null] | [null] | 1 | ||
23 | 1 | 0 | male | [null] | 0 | 0 | PC 17483 | 221.7792 | C95 | S | [null] | [null] | 1 | ||
24 | 1 | 0 | male | 30.0 | 0 | 0 | 113051 | 27.75 | C111 | C | [null] | [null] | 1 | ||
25 | 1 | 0 | male | [null] | 0 | 0 | 113778 | 26.55 | D34 | S | [null] | [null] | 1 | ||
26 | 1 | 0 | male | [null] | 0 | 0 | 112058 | 0.0 | B102 | S | [null] | [null] | 1 | ||
27 | 1 | 0 | male | 47.0 | 0 | 0 | 111320 | 38.5 | E63 | S | [null] | 275 | 1 | ||
28 | 1 | 0 | male | 24.0 | 0 | 0 | PC 17593 | 79.2 | B86 | C | [null] | [null] | 1 | ||
29 | 1 | 0 | male | 71.0 | 0 | 0 | PC 17754 | 34.6542 | A5 | C | [null] | [null] | 1 | ||
30 | 1 | 0 | male | 46.0 | 0 | 0 | PC 17593 | 79.2 | B82 B84 | C | [null] | [null] | 1 | ||
31 | 1 | 0 | male | [null] | 0 | 0 | 113796 | 42.4 | [null] | S | [null] | [null] | 1 | ||
32 | 1 | 0 | male | 40.0 | 0 | 0 | 112059 | 0.0 | B94 | S | [null] | 110 | 1 | ||
33 | 1 | 0 | male | 42.0 | 0 | 0 | 113038 | 42.5 | B11 | S | [null] | [null] | 1 | ||
34 | 1 | 0 | male | [null] | 0 | 0 | 17463 | 51.8625 | E46 | S | [null] | [null] | 1 | ||
35 | 1 | 0 | male | 55.0 | 0 | 0 | 680 | 50.0 | C39 | S | [null] | [null] | 1 | ||
36 | 1 | 0 | male | [null] | 0 | 0 | PC 17600 | 30.6958 | [null] | C | 14 | [null] | 1 | ||
37 | 1 | 0 | female | 50.0 | 0 | 0 | PC 17595 | 28.7125 | C49 | C | [null] | [null] | 1 | ||
38 | 1 | 0 | male | 46.0 | 0 | 0 | 694 | 26.0 | [null] | S | [null] | 80 | 1 | ||
39 | 1 | 0 | male | 50.0 | 0 | 0 | 113044 | 26.0 | E60 | S | [null] | [null] | 1 | ||
40 | 1 | 0 | male | 32.5 | 0 | 0 | 113503 | 211.5 | C132 | C | [null] | 45 | 1 | ||
41 | 1 | 0 | male | 58.0 | 0 | 0 | 11771 | 29.7 | B37 | C | [null] | 258 | 1 | ||
42 | 1 | 0 | male | [null] | 0 | 0 | 113028 | 26.55 | C124 | S | [null] | [null] | 1 | ||
43 | 1 | 0 | male | [null] | 0 | 0 | PC 17612 | 27.7208 | [null] | C | [null] | [null] | 1 | ||
44 | 1 | 0 | male | 29.0 | 0 | 0 | 113501 | 30.0 | D6 | S | [null] | 126 | 1 | ||
45 | 1 | 0 | male | 30.0 | 0 | 0 | 113801 | 45.5 | [null] | S | [null] | [null] | 1 | ||
46 | 1 | 0 | male | 30.0 | 0 | 0 | 110469 | 26.0 | C106 | S | [null] | [null] | 1 | ||
47 | 1 | 0 | male | 46.0 | 0 | 0 | 13050 | 75.2417 | C6 | C | [null] | 292 | 1 | ||
48 | 1 | 0 | male | 54.0 | 0 | 0 | 17463 | 51.8625 | E46 | S | [null] | 175 | 1 | ||
49 | 1 | 0 | male | 65.0 | 0 | 0 | 13509 | 26.55 | E38 | S | [null] | 249 | 1 | ||
50 | 1 | 0 | male | 55.0 | 0 | 0 | 113787 | 30.5 | C30 | S | [null] | [null] | 1 | ||
51 | 1 | 0 | male | 47.0 | 0 | 0 | 113796 | 42.4 | [null] | S | [null] | [null] | 1 | ||
52 | 1 | 0 | male | 64.0 | 0 | 0 | 693 | 26.0 | [null] | S | [null] | 263 | 1 | ||
53 | 1 | 0 | male | 28.5 | 0 | 0 | PC 17562 | 27.7208 | D43 | C | [null] | 189 | 1 | ||
54 | 1 | 0 | male | [null] | 0 | 0 | 112052 | 0.0 | [null] | S | [null] | [null] | 1 | ||
55 | 1 | 0 | male | 45.5 | 0 | 0 | 113043 | 28.5 | C124 | S | [null] | 166 | 1 | ||
56 | 1 | 0 | male | 23.0 | 0 | 0 | 12749 | 93.5 | B24 | S | [null] | [null] | 1 | ||
57 | 1 | 0 | male | 47.0 | 0 | 0 | 110465 | 52.0 | C110 | S | [null] | 207 | 1 | ||
58 | 1 | 0 | male | 38.0 | 0 | 0 | 19972 | 0.0 | [null] | S | [null] | [null] | 1 | ||
59 | 1 | 0 | male | 22.0 | 0 | 0 | PC 17760 | 135.6333 | [null] | C | [null] | 232 | 1 | ||
60 | 1 | 0 | male | [null] | 0 | 0 | PC 17757 | 227.525 | [null] | C | [null] | [null] | 1 | ||
61 | 1 | 0 | male | 31.0 | 0 | 0 | PC 17590 | 50.4958 | A24 | S | [null] | [null] | 1 | ||
62 | 1 | 0 | male | [null] | 0 | 0 | 113767 | 50.0 | A32 | S | [null] | [null] | 1 | ||
63 | 1 | 0 | male | 36.0 | 0 | 0 | 13049 | 40.125 | A10 | C | [null] | [null] | 1 | ||
64 | 1 | 0 | male | 33.0 | 0 | 0 | 113790 | 26.55 | [null] | S | [null] | 109 | 1 | ||
65 | 1 | 0 | male | 56.0 | 0 | 0 | 113792 | 26.55 | [null] | S | [null] | [null] | 1 | ||
66 | 1 | 0 | male | 56.0 | 0 | 0 | 17764 | 30.6958 | A7 | C | [null] | [null] | 1 | ||
67 | 1 | 0 | male | [null] | 0 | 0 | 113056 | 26.0 | A19 | S | [null] | [null] | 1 | ||
68 | 1 | 0 | male | 62.0 | 0 | 0 | 113514 | 26.55 | C87 | S | [null] | [null] | 1 | ||
69 | 1 | 0 | male | [null] | 0 | 0 | PC 17605 | 27.7208 | [null] | C | [null] | [null] | 1 | ||
70 | 1 | 0 | male | 61.0 | 0 | 0 | 36963 | 32.3208 | D50 | S | [null] | 46 | 1 | ||
71 | 1 | 0 | male | 40.0 | 0 | 0 | PC 17601 | 27.7208 | [null] | C | [null] | [null] | 1 | ||
72 | 1 | 0 | male | 61.0 | 0 | 0 | 111240 | 33.5 | B19 | S | [null] | 245 | 1 | ||
73 | 1 | 0 | male | 47.0 | 0 | 0 | 36967 | 34.0208 | D46 | S | [null] | [null] | 1 | ||
74 | 1 | 0 | male | 60.0 | 0 | 0 | 113800 | 26.55 | [null] | S | [null] | [null] | 1 | ||
75 | 1 | 0 | male | [null] | 0 | 0 | 113510 | 35.0 | C128 | S | [null] | [null] | 1 | ||
76 | 1 | 0 | male | 62.0 | 0 | 0 | 113807 | 26.55 | [null] | S | [null] | [null] | 1 | ||
77 | 1 | 1 | female | 29.0 | 0 | 0 | 24160 | 211.3375 | B5 | S | 2 | [null] | 1 | ||
78 | 1 | 1 | male | 48.0 | 0 | 0 | 19952 | 26.55 | E12 | S | 3 | [null] | 1 | ||
79 | 1 | 1 | female | 24.0 | 0 | 0 | PC 17477 | 69.3 | B35 | C | 9 | [null] | 1 | ||
80 | 1 | 1 | male | 80.0 | 0 | 0 | 27042 | 30.0 | A23 | S | B | [null] | 1 | ||
81 | 1 | 1 | female | 32.0 | 0 | 0 | 11813 | 76.2917 | D15 | C | 8 | [null] | 1 | ||
82 | 1 | 1 | male | 26.0 | 0 | 0 | 111369 | 30.0 | C148 | C | 5 | [null] | 1 | ||
83 | 1 | 1 | female | 42.0 | 0 | 0 | PC 17757 | 227.525 | [null] | C | 4 | [null] | 1 | ||
84 | 1 | 1 | female | 29.0 | 0 | 0 | PC 17483 | 221.7792 | C97 | S | 8 | [null] | 1 | ||
85 | 1 | 1 | female | 35.0 | 0 | 0 | PC 17760 | 135.6333 | C99 | S | 8 | [null] | 1 | ||
86 | 1 | 1 | male | 28.0 | 0 | 0 | 110564 | 26.55 | C52 | S | D | [null] | 1 | ||
87 | 1 | 1 | male | 40.0 | 0 | 0 | 112277 | 31.0 | A31 | C | 7 | [null] | 1 | ||
88 | 1 | 1 | female | 30.0 | 0 | 0 | 36928 | 164.8667 | C7 | S | 8 | [null] | 1 | ||
89 | 1 | 1 | female | 58.0 | 0 | 0 | 113783 | 26.55 | C103 | S | 8 | [null] | 1 | ||
90 | 1 | 1 | female | 45.0 | 0 | 0 | PC 17608 | 262.375 | [null] | C | 4 | [null] | 1 | ||
91 | 1 | 1 | female | 44.0 | 0 | 0 | PC 17610 | 27.7208 | B4 | C | 6 | [null] | 1 | ||
92 | 1 | 1 | female | 60.0 | 0 | 0 | 11813 | 76.2917 | D15 | C | 8 | [null] | 1 | ||
93 | 1 | 1 | female | 41.0 | 0 | 0 | 16966 | 134.5 | E40 | C | 3 | [null] | 1 | ||
94 | 1 | 1 | male | 42.0 | 0 | 0 | PC 17476 | 26.2875 | E24 | S | 5 | [null] | 1 | ||
95 | 1 | 1 | female | 53.0 | 0 | 0 | PC 17606 | 27.4458 | [null] | C | 6 | [null] | 1 | ||
96 | 1 | 1 | female | [null] | 0 | 0 | 17770 | 27.7208 | [null] | C | 5 | [null] | 1 | ||
97 | 1 | 1 | female | 36.0 | 0 | 0 | PC 17608 | 262.375 | B61 | C | 4 | [null] | 1 | ||
98 | 1 | 1 | female | 30.0 | 0 | 0 | 110152 | 86.5 | B77 | S | 8 | [null] | 1 | ||
99 | 1 | 1 | male | 45.0 | 0 | 0 | PC 17594 | 29.7 | A9 | C | 7 | [null] | 1 | ||
100 | 1 | 1 | female | 22.0 | 0 | 0 | 113781 | 151.55 | [null] | S | 11 | [null] | 1 |
And Operator (&)
[6]:
# Identifies the passengers who came alone and
# who are between 15 and 24 years old...
# ...with comparison operators
single_family[(titanic["age"] >= 15) & (titanic["age"] <= 24)]
[6]:
123 pclassInt | 123 survivedInt | Abc Varchar(164) | Abc sexVarchar(20) | 123 ageNumeric(6,3) | 123 sibspInt | 123 parchInt | Abc ticketVarchar(36) | 123 fareNumeric(10,5) | Abc cabinVarchar(30) | Abc embarkedVarchar(20) | Abc boatVarchar(100) | 123 bodyInt | Abc Varchar(100) | 123 family_sizeInt | 123 ln_fareFloat | 123 xFloat | |
1 | 1 | 0 | male | 17.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | 1 | 3.85227300102237 | 1.0 | ||
2 | 1 | 0 | male | 24.0 | 0 | 0 | PC 17593 | 79.2 | B86 | C | [null] | [null] | 1 | 4.37197629882038 | 1.0 | ||
3 | 1 | 0 | male | 23.0 | 0 | 0 | 12749 | 93.5 | B24 | S | [null] | [null] | 1 | 4.53796143629464 | 1.0 | ||
4 | 1 | 0 | male | 22.0 | 0 | 0 | PC 17760 | 135.6333 | [null] | C | [null] | 232 | 1 | 4.90995492057888 | 1.0 | ||
5 | 1 | 1 | female | 24.0 | 0 | 0 | PC 17477 | 69.3 | B35 | C | 9 | [null] | 1 | 4.23844490619586 | 1.0 | ||
6 | 1 | 1 | female | 22.0 | 0 | 0 | 113781 | 151.55 | [null] | S | 11 | [null] | 1 | 5.02091560350381 | 1.0 | ||
7 | 1 | 1 | female | 19.0 | 0 | 0 | 112053 | 30.0 | B42 | S | 3 | [null] | 1 | 3.40119738166216 | 0.999999999999906 | ||
8 | 1 | 1 | female | 24.0 | 0 | 0 | 11767 | 83.1583 | C54 | C | 7 | [null] | 1 | 4.42074602026042 | 1.0 | ||
9 | 1 | 1 | female | 21.0 | 0 | 0 | 13502 | 77.9583 | D9 | S | 10 | [null] | 1 | 4.35617406834722 | 1.0 | ||
10 | 1 | 1 | female | 16.0 | 0 | 0 | 110152 | 86.5 | B79 | S | 8 | [null] | 1 | 4.46014441393783 | 1.0 | ||
11 | 1 | 1 | female | 24.0 | 0 | 0 | PC 17477 | 69.3 | B35 | C | 9 | [null] | 1 | 4.23844490619586 | 1.0 | ||
12 | 1 | 1 | female | 21.0 | 0 | 0 | 113795 | 26.55 | [null] | S | 8 10 | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
13 | 2 | 0 | male | 18.0 | 0 | 0 | 231945 | 11.5 | [null] | S | [null] | [null] | 1 | 2.4423470353692 | 0.999989869906401 | ||
14 | 2 | 0 | male | 18.0 | 0 | 0 | 29108 | 11.5 | [null] | S | [null] | [null] | 1 | 2.4423470353692 | 0.999989869906401 | ||
15 | 2 | 0 | male | 23.0 | 0 | 0 | C.A. 31030 | 10.5 | [null] | S | [null] | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
16 | 2 | 0 | male | 23.0 | 0 | 0 | 28425 | 13.0 | [null] | S | [null] | [null] | 1 | 2.56494935746154 | 0.999997739670593 | ||
17 | 2 | 0 | male | 19.0 | 0 | 0 | 28424 | 13.0 | [null] | S | [null] | 18 | 1 | 2.56494935746154 | 0.999997739670593 | ||
18 | 2 | 0 | male | 18.0 | 0 | 0 | S.O.C. 14879 | 73.5 | [null] | S | [null] | [null] | 1 | 4.29728540621879 | 1.0 | ||
19 | 2 | 0 | male | 17.0 | 0 | 0 | S.O.C. 14879 | 73.5 | [null] | S | [null] | [null] | 1 | 4.29728540621879 | 1.0 | ||
20 | 2 | 0 | male | 18.0 | 0 | 0 | S.O.C. 14879 | 73.5 | [null] | S | [null] | [null] | 1 | 4.29728540621879 | 1.0 | ||
21 | 2 | 0 | male | 23.0 | 0 | 0 | 29751 | 13.0 | [null] | S | [null] | [null] | 1 | 2.56494935746154 | 0.999997739670593 | ||
22 | 2 | 0 | male | 21.0 | 0 | 0 | 236854 | 13.0 | [null] | S | [null] | [null] | 1 | 2.56494935746154 | 0.999997739670593 | ||
23 | 2 | 0 | male | 18.0 | 0 | 0 | 236171 | 13.0 | [null] | S | [null] | [null] | 1 | 2.56494935746154 | 0.999997739670593 | ||
24 | 2 | 0 | male | 18.0 | 0 | 0 | C.A. 15185 | 10.5 | [null] | S | [null] | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
25 | 2 | 0 | male | 16.0 | 0 | 0 | 239865 | 26.0 | [null] | S | [null] | [null] | 1 | 3.25809653802148 | 0.999999999994891 | ||
26 | 2 | 0 | male | 24.0 | 0 | 0 | 248726 | 13.5 | [null] | S | [null] | 297 | 1 | 2.60268968544438 | 0.999998629040914 | ||
27 | 2 | 0 | male | 24.0 | 0 | 0 | 233866 | 13.0 | [null] | S | [null] | 155 | 1 | 2.56494935746154 | 0.999997739670593 | ||
28 | 2 | 0 | male | 21.0 | 0 | 0 | S.O.C. 14879 | 73.5 | [null] | S | [null] | [null] | 1 | 4.29728540621879 | 1.0 | ||
29 | 2 | 0 | female | 22.0 | 0 | 0 | F.C.C. 13534 | 21.0 | [null] | S | [null] | [null] | 1 | 3.04452243772342 | 0.999999999241744 | ||
30 | 2 | 0 | male | 24.0 | 0 | 0 | C.A. 29566 | 10.5 | [null] | S | [null] | 108 | 1 | 2.35137525716348 | 0.99997246355065 | ||
31 | 2 | 0 | male | 16.0 | 0 | 0 | S.O./P.P. 3 | 10.5 | [null] | S | [null] | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
32 | 2 | 0 | male | 23.0 | 0 | 0 | 244278 | 10.5 | [null] | S | [null] | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
33 | 2 | 0 | male | 19.0 | 0 | 0 | 28665 | 10.5 | [null] | S | [null] | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
34 | 2 | 0 | male | 23.0 | 0 | 0 | SC/PARIS 2133 | 15.0458 | [null] | C | [null] | [null] | 1 | 2.71109888248023 | 0.999999707792012 | ||
35 | 2 | 0 | male | 19.0 | 0 | 0 | 28004 | 10.5 | [null] | S | [null] | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
36 | 2 | 0 | male | 18.5 | 0 | 0 | 248734 | 13.0 | F | S | [null] | 294 | 1 | 2.56494935746154 | 0.999997739670593 | ||
37 | 2 | 0 | male | 23.0 | 0 | 0 | 233639 | 13.0 | [null] | S | [null] | [null] | 1 | 2.56494935746154 | 0.999997739670593 | ||
38 | 2 | 1 | female | 19.0 | 0 | 0 | 28404 | 13.0 | [null] | S | 12 | [null] | 1 | 2.56494935746154 | 0.999997739670593 | ||
39 | 2 | 1 | male | 24.0 | 0 | 0 | 28034 | 10.5 | [null] | S | 9 | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
40 | 2 | 1 | female | 22.0 | 0 | 0 | W./C. 14266 | 10.5 | F33 | S | 14 | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
41 | 2 | 1 | female | 17.0 | 0 | 0 | SO/C 14885 | 10.5 | [null] | S | [null] | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
42 | 2 | 1 | female | 23.0 | 0 | 0 | SC/AH Basle 541 | 13.7917 | D | C | 11 | [null] | 1 | 2.62406696194463 | 0.999998975903707 | ||
43 | 2 | 1 | female | 17.0 | 0 | 0 | SC 1748 | 12.0 | [null] | C | 12 | [null] | 1 | 2.484906649788 | 0.999993855787647 | ||
44 | 2 | 1 | male | 19.0 | 0 | 0 | SW/PP 751 | 10.5 | [null] | S | B | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
45 | 2 | 1 | male | 22.0 | 0 | 0 | W./C. 14260 | 10.5 | [null] | S | 13 | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
46 | 2 | 1 | female | 21.0 | 0 | 0 | C.A. 31026 | 10.5 | [null] | S | 12 | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
47 | 2 | 1 | female | 20.0 | 0 | 0 | C.A. 33112 | 36.75 | [null] | S | 11 | [null] | 1 | 3.60413822565885 | 1.0 | ||
48 | 3 | 0 | male | 20.0 | 0 | 0 | SOTON/O2 3101287 | 7.925 | [null] | S | [null] | [null] | 1 | 2.07002231976334 | 0.99963841015017 | ||
49 | 3 | 0 | male | 24.0 | 0 | 0 | SOTON/O.Q. 3101311 | 7.05 | [null] | S | [null] | [null] | 1 | 1.95302761682418 | 0.999132591042693 | ||
50 | 3 | 0 | male | 18.0 | 0 | 0 | 2223 | 8.3 | [null] | S | [null] | 259 | 1 | 2.11625551480255 | 0.999751483172892 | ||
51 | 3 | 0 | male | 20.0 | 0 | 0 | 347466 | 7.8542 | [null] | S | [null] | [null] | 1 | 2.06104842056294 | 0.999611881557209 | ||
52 | 3 | 0 | male | 24.0 | 0 | 0 | 349911 | 7.775 | [null] | S | [null] | [null] | 1 | 2.0509134580653 | 0.999579892530644 | ||
53 | 3 | 0 | male | 21.0 | 0 | 0 | 2692 | 7.225 | [null] | C | [null] | [null] | 1 | 1.9775472339985 | 0.999271847460911 | ||
54 | 3 | 0 | male | 23.0 | 0 | 0 | SOTON/O.Q. 3101309 | 7.05 | [null] | S | [null] | [null] | 1 | 1.95302761682418 | 0.999132591042693 | ||
55 | 3 | 0 | female | 17.0 | 0 | 0 | 2627 | 14.4583 | [null] | C | [null] | [null] | 1 | 2.67126864412075 | 0.999999474176378 | ||
56 | 3 | 0 | male | 23.0 | 0 | 0 | 347468 | 7.8542 | [null] | S | [null] | [null] | 1 | 2.06104842056294 | 0.999611881557209 | ||
57 | 3 | 0 | male | 20.0 | 0 | 0 | 2679 | 7.225 | [null] | C | [null] | [null] | 1 | 1.9775472339985 | 0.999271847460911 | ||
58 | 3 | 0 | male | 22.0 | 0 | 0 | 324669 | 8.05 | [null] | S | [null] | [null] | 1 | 2.08567209143047 | 0.999680898077519 | ||
59 | 3 | 0 | male | 19.0 | 0 | 0 | 323951 | 8.05 | [null] | S | [null] | [null] | 1 | 2.08567209143047 | 0.999680898077519 | ||
60 | 3 | 0 | male | 22.0 | 0 | 0 | PP 4348 | 9.35 | [null] | S | [null] | [null] | 1 | 2.2353763433006 | 0.999913034580906 | ||
61 | 3 | 0 | male | 20.0 | 0 | 0 | 2648 | 4.0125 | [null] | C | [null] | [null] | 1 | 1.38941448845613 | 0.981911881631624 | ||
62 | 3 | 0 | male | 21.0 | 0 | 0 | 312992 | 7.775 | [null] | S | [null] | [null] | 1 | 2.0509134580653 | 0.999579892530644 | ||
63 | 3 | 0 | male | 18.0 | 0 | 0 | 347090 | 7.75 | [null] | S | [null] | [null] | 1 | 2.04769284336526 | 0.999569257459424 | ||
64 | 3 | 0 | female | 20.0 | 0 | 0 | 347471 | 7.8542 | [null] | S | [null] | [null] | 1 | 2.06104842056294 | 0.999611881557209 | ||
65 | 3 | 0 | male | 22.0 | 0 | 0 | 350045 | 7.7958 | [null] | S | [null] | [null] | 1 | 2.05358512713461 | 0.999588540515181 | ||
66 | 3 | 0 | female | 18.5 | 0 | 0 | 329944 | 7.2833 | [null] | Q | [null] | 299 | 1 | 1.98558405620398 | 0.999313085000176 | ||
67 | 3 | 0 | male | 19.0 | 0 | 0 | 365222 | 6.75 | [null] | Q | [null] | [null] | 1 | 1.90954250488444 | 0.998829120379209 | ||
68 | 3 | 0 | female | 18.0 | 0 | 0 | 330963 | 7.8792 | [null] | Q | [null] | [null] | 1 | 2.06422637587336 | 0.999621464235705 | ||
69 | 3 | 0 | female | 21.0 | 0 | 0 | 315087 | 8.6625 | [null] | S | [null] | [null] | 1 | 2.15900336451602 | 0.999827048612489 | ||
70 | 3 | 0 | male | 18.0 | 0 | 0 | 315091 | 8.6625 | [null] | S | [null] | [null] | 1 | 2.15900336451602 | 0.999827048612489 | ||
71 | 3 | 0 | male | 17.0 | 0 | 0 | 315093 | 8.6625 | [null] | S | [null] | [null] | 1 | 2.15900336451602 | 0.999827048612489 | ||
72 | 3 | 0 | male | 17.0 | 0 | 0 | 315086 | 8.6625 | [null] | S | [null] | [null] | 1 | 2.15900336451602 | 0.999827048612489 | ||
73 | 3 | 0 | female | 21.0 | 0 | 0 | 364846 | 7.75 | [null] | Q | [null] | [null] | 1 | 2.04769284336526 | 0.999569257459424 | ||
74 | 3 | 0 | male | 21.0 | 0 | 0 | 364858 | 7.75 | [null] | Q | [null] | [null] | 1 | 2.04769284336526 | 0.999569257459424 | ||
75 | 3 | 0 | male | 21.0 | 0 | 0 | A./5. 2152 | 8.05 | [null] | S | [null] | [null] | 1 | 2.08567209143047 | 0.999680898077519 | ||
76 | 3 | 0 | male | 24.0 | 0 | 0 | 350409 | 7.8542 | [null] | S | [null] | [null] | 1 | 2.06104842056294 | 0.999611881557209 | ||
77 | 3 | 0 | male | 24.0 | 0 | 0 | 343275 | 8.05 | [null] | S | [null] | [null] | 1 | 2.08567209143047 | 0.999680898077519 | ||
78 | 3 | 0 | male | 21.0 | 0 | 0 | A/5. 13032 | 7.7333 | [null] | Q | [null] | [null] | 1 | 2.04553567965004 | 0.999562003658341 | ||
79 | 3 | 0 | male | 20.0 | 0 | 0 | SOTON/O.Q. 3101307 | 7.05 | [null] | S | [null] | [null] | 1 | 1.95302761682418 | 0.999132591042693 | ||
80 | 3 | 0 | male | 24.0 | 0 | 0 | 371109 | 7.25 | [null] | Q | [null] | [null] | 1 | 1.98100146886658 | 0.999289825611157 | ||
81 | 3 | 0 | male | 24.0 | 0 | 0 | 349209 | 7.4958 | [null] | S | [null] | [null] | 1 | 2.0143428636837 | 0.999444587790457 | ||
82 | 3 | 0 | male | 19.0 | 0 | 0 | 349231 | 7.8958 | [null] | S | [null] | [null] | 1 | 2.06633097252974 | 0.99962769606213 | ||
83 | 3 | 0 | male | 19.0 | 0 | 0 | S.P. 3464 | 8.1583 | [null] | S | [null] | [null] | 1 | 2.09903581393828 | 0.999713651225826 | ||
84 | 3 | 0 | male | 17.0 | 0 | 0 | 315090 | 8.6625 | [null] | S | [null] | [null] | 1 | 2.15900336451602 | 0.999827048612489 | ||
85 | 3 | 0 | male | 22.5 | 0 | 0 | 2698 | 7.225 | [null] | C | [null] | 9 | 1 | 1.9775472339985 | 0.999271847460911 | ||
86 | 3 | 0 | female | 22.0 | 0 | 0 | 7552 | 10.5167 | [null] | S | [null] | [null] | 1 | 2.3529644698862 | 0.99997291959082 | ||
87 | 3 | 0 | male | 19.0 | 0 | 0 | 349228 | 10.1708 | [null] | S | [null] | [null] | 1 | 2.31952086970025 | 0.999961728306189 | ||
88 | 3 | 0 | male | 22.0 | 0 | 0 | SC/A4 23568 | 8.05 | [null] | S | [null] | [null] | 1 | 2.08567209143047 | 0.999680898077519 | ||
89 | 3 | 0 | male | 22.0 | 0 | 0 | A/5 21172 | 7.25 | [null] | S | [null] | [null] | 1 | 1.98100146886658 | 0.999289825611157 | ||
90 | 3 | 0 | male | 17.0 | 0 | 0 | 349232 | 7.8958 | [null] | S | [null] | [null] | 1 | 2.06633097252974 | 0.99962769606213 | ||
91 | 3 | 0 | female | 24.0 | 0 | 0 | 368702 | 7.75 | [null] | Q | [null] | [null] | 1 | 2.04769284336526 | 0.999569257459424 | ||
92 | 3 | 0 | male | 18.0 | 0 | 0 | 349912 | 7.775 | [null] | S | [null] | [null] | 1 | 2.0509134580653 | 0.999579892530644 | ||
93 | 3 | 0 | male | 16.0 | 0 | 0 | 347074 | 7.775 | [null] | S | [null] | [null] | 1 | 2.0509134580653 | 0.999579892530644 | ||
94 | 3 | 0 | male | 18.0 | 0 | 0 | 350036 | 7.7958 | [null] | S | [null] | [null] | 1 | 2.05358512713461 | 0.999588540515181 | ||
95 | 3 | 0 | male | 22.0 | 0 | 0 | 14973 | 8.05 | [null] | S | [null] | 47 | 1 | 2.08567209143047 | 0.999680898077519 | ||
96 | 3 | 0 | male | 20.0 | 0 | 0 | 7534 | 9.8458 | [null] | S | [null] | [null] | 1 | 2.28704496831231 | 0.999947030802892 | ||
97 | 3 | 0 | male | 19.0 | 0 | 0 | 347069 | 7.775 | [null] | S | [null] | [null] | 1 | 2.0509134580653 | 0.999579892530644 | ||
98 | 3 | 0 | female | 24.0 | 0 | 0 | 349236 | 8.85 | [null] | S | [null] | [null] | 1 | 2.18041745901984 | 0.999856618263724 | ||
99 | 3 | 0 | female | 17.0 | 0 | 0 | AQ/3. 30631 | 7.7333 | [null] | Q | [null] | [null] | 1 | 2.04553567965004 | 0.999562003658341 | ||
100 | 3 | 0 | male | 20.0 | 0 | 0 | 345769 | 9.5 | [null] | S | [null] | [null] | 1 | 2.2512917986065 | 0.999925148170112 |
Between Operator (_between)
[7]:
# ...with the 'between' function
single_family[titanic["age"]._between(15, 24)]
[7]:
123 pclassInt | 123 survivedInt | Abc Varchar(164) | Abc sexVarchar(20) | 123 ageNumeric(6,3) | 123 sibspInt | 123 parchInt | Abc ticketVarchar(36) | 123 fareNumeric(10,5) | Abc cabinVarchar(30) | Abc embarkedVarchar(20) | Abc boatVarchar(100) | 123 bodyInt | Abc Varchar(100) | 123 family_sizeInt | 123 ln_fareFloat | 123 xFloat | |
1 | 1 | 0 | male | 17.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | 1 | 3.85227300102237 | 1.0 | ||
2 | 1 | 0 | male | 24.0 | 0 | 0 | PC 17593 | 79.2 | B86 | C | [null] | [null] | 1 | 4.37197629882038 | 1.0 | ||
3 | 1 | 0 | male | 23.0 | 0 | 0 | 12749 | 93.5 | B24 | S | [null] | [null] | 1 | 4.53796143629464 | 1.0 | ||
4 | 1 | 0 | male | 22.0 | 0 | 0 | PC 17760 | 135.6333 | [null] | C | [null] | 232 | 1 | 4.90995492057888 | 1.0 | ||
5 | 1 | 1 | female | 24.0 | 0 | 0 | PC 17477 | 69.3 | B35 | C | 9 | [null] | 1 | 4.23844490619586 | 1.0 | ||
6 | 1 | 1 | female | 22.0 | 0 | 0 | 113781 | 151.55 | [null] | S | 11 | [null] | 1 | 5.02091560350381 | 1.0 | ||
7 | 1 | 1 | female | 19.0 | 0 | 0 | 112053 | 30.0 | B42 | S | 3 | [null] | 1 | 3.40119738166216 | 0.999999999999906 | ||
8 | 1 | 1 | female | 24.0 | 0 | 0 | 11767 | 83.1583 | C54 | C | 7 | [null] | 1 | 4.42074602026042 | 1.0 | ||
9 | 1 | 1 | female | 21.0 | 0 | 0 | 13502 | 77.9583 | D9 | S | 10 | [null] | 1 | 4.35617406834722 | 1.0 | ||
10 | 1 | 1 | female | 16.0 | 0 | 0 | 110152 | 86.5 | B79 | S | 8 | [null] | 1 | 4.46014441393783 | 1.0 | ||
11 | 1 | 1 | female | 24.0 | 0 | 0 | PC 17477 | 69.3 | B35 | C | 9 | [null] | 1 | 4.23844490619586 | 1.0 | ||
12 | 1 | 1 | female | 21.0 | 0 | 0 | 113795 | 26.55 | [null] | S | 8 10 | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
13 | 2 | 0 | male | 18.0 | 0 | 0 | 231945 | 11.5 | [null] | S | [null] | [null] | 1 | 2.4423470353692 | 0.999989869906401 | ||
14 | 2 | 0 | male | 18.0 | 0 | 0 | 29108 | 11.5 | [null] | S | [null] | [null] | 1 | 2.4423470353692 | 0.999989869906401 | ||
15 | 2 | 0 | male | 23.0 | 0 | 0 | C.A. 31030 | 10.5 | [null] | S | [null] | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
16 | 2 | 0 | male | 23.0 | 0 | 0 | 28425 | 13.0 | [null] | S | [null] | [null] | 1 | 2.56494935746154 | 0.999997739670593 | ||
17 | 2 | 0 | male | 19.0 | 0 | 0 | 28424 | 13.0 | [null] | S | [null] | 18 | 1 | 2.56494935746154 | 0.999997739670593 | ||
18 | 2 | 0 | male | 18.0 | 0 | 0 | S.O.C. 14879 | 73.5 | [null] | S | [null] | [null] | 1 | 4.29728540621879 | 1.0 | ||
19 | 2 | 0 | male | 17.0 | 0 | 0 | S.O.C. 14879 | 73.5 | [null] | S | [null] | [null] | 1 | 4.29728540621879 | 1.0 | ||
20 | 2 | 0 | male | 18.0 | 0 | 0 | S.O.C. 14879 | 73.5 | [null] | S | [null] | [null] | 1 | 4.29728540621879 | 1.0 | ||
21 | 2 | 0 | male | 23.0 | 0 | 0 | 29751 | 13.0 | [null] | S | [null] | [null] | 1 | 2.56494935746154 | 0.999997739670593 | ||
22 | 2 | 0 | male | 21.0 | 0 | 0 | 236854 | 13.0 | [null] | S | [null] | [null] | 1 | 2.56494935746154 | 0.999997739670593 | ||
23 | 2 | 0 | male | 18.0 | 0 | 0 | 236171 | 13.0 | [null] | S | [null] | [null] | 1 | 2.56494935746154 | 0.999997739670593 | ||
24 | 2 | 0 | male | 18.0 | 0 | 0 | C.A. 15185 | 10.5 | [null] | S | [null] | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
25 | 2 | 0 | male | 16.0 | 0 | 0 | 239865 | 26.0 | [null] | S | [null] | [null] | 1 | 3.25809653802148 | 0.999999999994891 | ||
26 | 2 | 0 | male | 24.0 | 0 | 0 | 248726 | 13.5 | [null] | S | [null] | 297 | 1 | 2.60268968544438 | 0.999998629040914 | ||
27 | 2 | 0 | male | 24.0 | 0 | 0 | 233866 | 13.0 | [null] | S | [null] | 155 | 1 | 2.56494935746154 | 0.999997739670593 | ||
28 | 2 | 0 | male | 21.0 | 0 | 0 | S.O.C. 14879 | 73.5 | [null] | S | [null] | [null] | 1 | 4.29728540621879 | 1.0 | ||
29 | 2 | 0 | female | 22.0 | 0 | 0 | F.C.C. 13534 | 21.0 | [null] | S | [null] | [null] | 1 | 3.04452243772342 | 0.999999999241744 | ||
30 | 2 | 0 | male | 24.0 | 0 | 0 | C.A. 29566 | 10.5 | [null] | S | [null] | 108 | 1 | 2.35137525716348 | 0.99997246355065 | ||
31 | 2 | 0 | male | 16.0 | 0 | 0 | S.O./P.P. 3 | 10.5 | [null] | S | [null] | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
32 | 2 | 0 | male | 23.0 | 0 | 0 | 244278 | 10.5 | [null] | S | [null] | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
33 | 2 | 0 | male | 19.0 | 0 | 0 | 28665 | 10.5 | [null] | S | [null] | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
34 | 2 | 0 | male | 23.0 | 0 | 0 | SC/PARIS 2133 | 15.0458 | [null] | C | [null] | [null] | 1 | 2.71109888248023 | 0.999999707792012 | ||
35 | 2 | 0 | male | 19.0 | 0 | 0 | 28004 | 10.5 | [null] | S | [null] | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
36 | 2 | 0 | male | 18.5 | 0 | 0 | 248734 | 13.0 | F | S | [null] | 294 | 1 | 2.56494935746154 | 0.999997739670593 | ||
37 | 2 | 0 | male | 23.0 | 0 | 0 | 233639 | 13.0 | [null] | S | [null] | [null] | 1 | 2.56494935746154 | 0.999997739670593 | ||
38 | 2 | 1 | female | 19.0 | 0 | 0 | 28404 | 13.0 | [null] | S | 12 | [null] | 1 | 2.56494935746154 | 0.999997739670593 | ||
39 | 2 | 1 | male | 24.0 | 0 | 0 | 28034 | 10.5 | [null] | S | 9 | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
40 | 2 | 1 | female | 22.0 | 0 | 0 | W./C. 14266 | 10.5 | F33 | S | 14 | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
41 | 2 | 1 | female | 17.0 | 0 | 0 | SO/C 14885 | 10.5 | [null] | S | [null] | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
42 | 2 | 1 | female | 23.0 | 0 | 0 | SC/AH Basle 541 | 13.7917 | D | C | 11 | [null] | 1 | 2.62406696194463 | 0.999998975903707 | ||
43 | 2 | 1 | female | 17.0 | 0 | 0 | SC 1748 | 12.0 | [null] | C | 12 | [null] | 1 | 2.484906649788 | 0.999993855787647 | ||
44 | 2 | 1 | male | 19.0 | 0 | 0 | SW/PP 751 | 10.5 | [null] | S | B | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
45 | 2 | 1 | male | 22.0 | 0 | 0 | W./C. 14260 | 10.5 | [null] | S | 13 | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
46 | 2 | 1 | female | 21.0 | 0 | 0 | C.A. 31026 | 10.5 | [null] | S | 12 | [null] | 1 | 2.35137525716348 | 0.99997246355065 | ||
47 | 2 | 1 | female | 20.0 | 0 | 0 | C.A. 33112 | 36.75 | [null] | S | 11 | [null] | 1 | 3.60413822565885 | 1.0 | ||
48 | 3 | 0 | male | 20.0 | 0 | 0 | SOTON/O2 3101287 | 7.925 | [null] | S | [null] | [null] | 1 | 2.07002231976334 | 0.99963841015017 | ||
49 | 3 | 0 | male | 24.0 | 0 | 0 | SOTON/O.Q. 3101311 | 7.05 | [null] | S | [null] | [null] | 1 | 1.95302761682418 | 0.999132591042693 | ||
50 | 3 | 0 | male | 18.0 | 0 | 0 | 2223 | 8.3 | [null] | S | [null] | 259 | 1 | 2.11625551480255 | 0.999751483172892 | ||
51 | 3 | 0 | male | 20.0 | 0 | 0 | 347466 | 7.8542 | [null] | S | [null] | [null] | 1 | 2.06104842056294 | 0.999611881557209 | ||
52 | 3 | 0 | male | 24.0 | 0 | 0 | 349911 | 7.775 | [null] | S | [null] | [null] | 1 | 2.0509134580653 | 0.999579892530644 | ||
53 | 3 | 0 | male | 21.0 | 0 | 0 | 2692 | 7.225 | [null] | C | [null] | [null] | 1 | 1.9775472339985 | 0.999271847460911 | ||
54 | 3 | 0 | male | 23.0 | 0 | 0 | SOTON/O.Q. 3101309 | 7.05 | [null] | S | [null] | [null] | 1 | 1.95302761682418 | 0.999132591042693 | ||
55 | 3 | 0 | female | 17.0 | 0 | 0 | 2627 | 14.4583 | [null] | C | [null] | [null] | 1 | 2.67126864412075 | 0.999999474176378 | ||
56 | 3 | 0 | male | 23.0 | 0 | 0 | 347468 | 7.8542 | [null] | S | [null] | [null] | 1 | 2.06104842056294 | 0.999611881557209 | ||
57 | 3 | 0 | male | 20.0 | 0 | 0 | 2679 | 7.225 | [null] | C | [null] | [null] | 1 | 1.9775472339985 | 0.999271847460911 | ||
58 | 3 | 0 | male | 22.0 | 0 | 0 | 324669 | 8.05 | [null] | S | [null] | [null] | 1 | 2.08567209143047 | 0.999680898077519 | ||
59 | 3 | 0 | male | 19.0 | 0 | 0 | 323951 | 8.05 | [null] | S | [null] | [null] | 1 | 2.08567209143047 | 0.999680898077519 | ||
60 | 3 | 0 | male | 22.0 | 0 | 0 | PP 4348 | 9.35 | [null] | S | [null] | [null] | 1 | 2.2353763433006 | 0.999913034580906 | ||
61 | 3 | 0 | male | 20.0 | 0 | 0 | 2648 | 4.0125 | [null] | C | [null] | [null] | 1 | 1.38941448845613 | 0.981911881631624 | ||
62 | 3 | 0 | male | 21.0 | 0 | 0 | 312992 | 7.775 | [null] | S | [null] | [null] | 1 | 2.0509134580653 | 0.999579892530644 | ||
63 | 3 | 0 | male | 18.0 | 0 | 0 | 347090 | 7.75 | [null] | S | [null] | [null] | 1 | 2.04769284336526 | 0.999569257459424 | ||
64 | 3 | 0 | female | 20.0 | 0 | 0 | 347471 | 7.8542 | [null] | S | [null] | [null] | 1 | 2.06104842056294 | 0.999611881557209 | ||
65 | 3 | 0 | male | 22.0 | 0 | 0 | 350045 | 7.7958 | [null] | S | [null] | [null] | 1 | 2.05358512713461 | 0.999588540515181 | ||
66 | 3 | 0 | female | 18.5 | 0 | 0 | 329944 | 7.2833 | [null] | Q | [null] | 299 | 1 | 1.98558405620398 | 0.999313085000176 | ||
67 | 3 | 0 | male | 19.0 | 0 | 0 | 365222 | 6.75 | [null] | Q | [null] | [null] | 1 | 1.90954250488444 | 0.998829120379209 | ||
68 | 3 | 0 | female | 18.0 | 0 | 0 | 330963 | 7.8792 | [null] | Q | [null] | [null] | 1 | 2.06422637587336 | 0.999621464235705 | ||
69 | 3 | 0 | female | 21.0 | 0 | 0 | 315087 | 8.6625 | [null] | S | [null] | [null] | 1 | 2.15900336451602 | 0.999827048612489 | ||
70 | 3 | 0 | male | 18.0 | 0 | 0 | 315091 | 8.6625 | [null] | S | [null] | [null] | 1 | 2.15900336451602 | 0.999827048612489 | ||
71 | 3 | 0 | male | 17.0 | 0 | 0 | 315093 | 8.6625 | [null] | S | [null] | [null] | 1 | 2.15900336451602 | 0.999827048612489 | ||
72 | 3 | 0 | male | 17.0 | 0 | 0 | 315086 | 8.6625 | [null] | S | [null] | [null] | 1 | 2.15900336451602 | 0.999827048612489 | ||
73 | 3 | 0 | female | 21.0 | 0 | 0 | 364846 | 7.75 | [null] | Q | [null] | [null] | 1 | 2.04769284336526 | 0.999569257459424 | ||
74 | 3 | 0 | male | 21.0 | 0 | 0 | 364858 | 7.75 | [null] | Q | [null] | [null] | 1 | 2.04769284336526 | 0.999569257459424 | ||
75 | 3 | 0 | male | 21.0 | 0 | 0 | A./5. 2152 | 8.05 | [null] | S | [null] | [null] | 1 | 2.08567209143047 | 0.999680898077519 | ||
76 | 3 | 0 | male | 24.0 | 0 | 0 | 350409 | 7.8542 | [null] | S | [null] | [null] | 1 | 2.06104842056294 | 0.999611881557209 | ||
77 | 3 | 0 | male | 24.0 | 0 | 0 | 343275 | 8.05 | [null] | S | [null] | [null] | 1 | 2.08567209143047 | 0.999680898077519 | ||
78 | 3 | 0 | male | 21.0 | 0 | 0 | A/5. 13032 | 7.7333 | [null] | Q | [null] | [null] | 1 | 2.04553567965004 | 0.999562003658341 | ||
79 | 3 | 0 | male | 20.0 | 0 | 0 | SOTON/O.Q. 3101307 | 7.05 | [null] | S | [null] | [null] | 1 | 1.95302761682418 | 0.999132591042693 | ||
80 | 3 | 0 | male | 24.0 | 0 | 0 | 371109 | 7.25 | [null] | Q | [null] | [null] | 1 | 1.98100146886658 | 0.999289825611157 | ||
81 | 3 | 0 | male | 24.0 | 0 | 0 | 349209 | 7.4958 | [null] | S | [null] | [null] | 1 | 2.0143428636837 | 0.999444587790457 | ||
82 | 3 | 0 | male | 19.0 | 0 | 0 | 349231 | 7.8958 | [null] | S | [null] | [null] | 1 | 2.06633097252974 | 0.99962769606213 | ||
83 | 3 | 0 | male | 19.0 | 0 | 0 | S.P. 3464 | 8.1583 | [null] | S | [null] | [null] | 1 | 2.09903581393828 | 0.999713651225826 | ||
84 | 3 | 0 | male | 17.0 | 0 | 0 | 315090 | 8.6625 | [null] | S | [null] | [null] | 1 | 2.15900336451602 | 0.999827048612489 | ||
85 | 3 | 0 | male | 22.5 | 0 | 0 | 2698 | 7.225 | [null] | C | [null] | 9 | 1 | 1.9775472339985 | 0.999271847460911 | ||
86 | 3 | 0 | female | 22.0 | 0 | 0 | 7552 | 10.5167 | [null] | S | [null] | [null] | 1 | 2.3529644698862 | 0.99997291959082 | ||
87 | 3 | 0 | male | 19.0 | 0 | 0 | 349228 | 10.1708 | [null] | S | [null] | [null] | 1 | 2.31952086970025 | 0.999961728306189 | ||
88 | 3 | 0 | male | 22.0 | 0 | 0 | SC/A4 23568 | 8.05 | [null] | S | [null] | [null] | 1 | 2.08567209143047 | 0.999680898077519 | ||
89 | 3 | 0 | male | 22.0 | 0 | 0 | A/5 21172 | 7.25 | [null] | S | [null] | [null] | 1 | 1.98100146886658 | 0.999289825611157 | ||
90 | 3 | 0 | male | 17.0 | 0 | 0 | 349232 | 7.8958 | [null] | S | [null] | [null] | 1 | 2.06633097252974 | 0.99962769606213 | ||
91 | 3 | 0 | female | 24.0 | 0 | 0 | 368702 | 7.75 | [null] | Q | [null] | [null] | 1 | 2.04769284336526 | 0.999569257459424 | ||
92 | 3 | 0 | male | 18.0 | 0 | 0 | 349912 | 7.775 | [null] | S | [null] | [null] | 1 | 2.0509134580653 | 0.999579892530644 | ||
93 | 3 | 0 | male | 16.0 | 0 | 0 | 347074 | 7.775 | [null] | S | [null] | [null] | 1 | 2.0509134580653 | 0.999579892530644 | ||
94 | 3 | 0 | male | 18.0 | 0 | 0 | 350036 | 7.7958 | [null] | S | [null] | [null] | 1 | 2.05358512713461 | 0.999588540515181 | ||
95 | 3 | 0 | male | 22.0 | 0 | 0 | 14973 | 8.05 | [null] | S | [null] | 47 | 1 | 2.08567209143047 | 0.999680898077519 | ||
96 | 3 | 0 | male | 20.0 | 0 | 0 | 7534 | 9.8458 | [null] | S | [null] | [null] | 1 | 2.28704496831231 | 0.999947030802892 | ||
97 | 3 | 0 | male | 19.0 | 0 | 0 | 347069 | 7.775 | [null] | S | [null] | [null] | 1 | 2.0509134580653 | 0.999579892530644 | ||
98 | 3 | 0 | female | 24.0 | 0 | 0 | 349236 | 8.85 | [null] | S | [null] | [null] | 1 | 2.18041745901984 | 0.999856618263724 | ||
99 | 3 | 0 | female | 17.0 | 0 | 0 | AQ/3. 30631 | 7.7333 | [null] | Q | [null] | [null] | 1 | 2.04553567965004 | 0.999562003658341 | ||
100 | 3 | 0 | male | 20.0 | 0 | 0 | 345769 | 9.5 | [null] | S | [null] | [null] | 1 | 2.2512917986065 | 0.999925148170112 |
In Operator (_in)
[8]:
# Identifies the passengers who came alone in 1st and 3rd class...
# ...with the 'in' method
single_family[titanic["pclass"]._in(1, 3)]
[8]:
123 pclassInt | 123 survivedInt | Abc Varchar(164) | Abc sexVarchar(20) | 123 ageNumeric(6,3) | 123 sibspInt | 123 parchInt | Abc ticketVarchar(36) | 123 fareNumeric(10,5) | Abc cabinVarchar(30) | Abc embarkedVarchar(20) | Abc boatVarchar(100) | 123 bodyInt | Abc Varchar(100) | 123 family_sizeInt | 123 ln_fareFloat | 123 xFloat | |
1 | 1 | 0 | male | 39.0 | 0 | 0 | 112050 | 0.0 | A36 | S | [null] | [null] | 1 | -inf | 0.0 | ||
2 | 1 | 0 | male | 71.0 | 0 | 0 | PC 17609 | 49.5042 | [null] | C | [null] | 22 | 1 | 3.90205751446006 | 1.0 | ||
3 | 1 | 0 | male | [null] | 0 | 0 | PC 17318 | 25.925 | [null] | S | [null] | [null] | 1 | 3.25520775411559 | 0.999999999994493 | ||
4 | 1 | 0 | male | 36.0 | 0 | 0 | 13050 | 75.2417 | C6 | C | A | [null] | 1 | 4.32070559854228 | 1.0 | ||
5 | 1 | 0 | male | 25.0 | 0 | 0 | 13905 | 26.0 | [null] | C | [null] | 148 | 1 | 3.25809653802148 | 0.999999999994891 | ||
6 | 1 | 0 | male | 45.0 | 0 | 0 | 113784 | 35.5 | T | S | [null] | [null] | 1 | 3.56953269648137 | 1.0 | ||
7 | 1 | 0 | male | 42.0 | 0 | 0 | 110489 | 26.55 | D22 | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
8 | 1 | 0 | male | 41.0 | 0 | 0 | 113054 | 30.5 | A21 | S | [null] | [null] | 1 | 3.41772668361337 | 0.999999999999943 | ||
9 | 1 | 0 | male | 48.0 | 0 | 0 | PC 17591 | 50.4958 | B10 | C | [null] | 208 | 1 | 3.92189016450581 | 1.0 | ||
10 | 1 | 0 | male | [null] | 0 | 0 | 112379 | 39.6 | [null] | C | [null] | [null] | 1 | 3.67882911826043 | 1.0 | ||
11 | 1 | 0 | male | 45.0 | 0 | 0 | 113050 | 26.55 | B38 | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
12 | 1 | 0 | male | [null] | 0 | 0 | 113798 | 31.0 | [null] | S | [null] | [null] | 1 | 3.43398720448515 | 0.999999999999966 | ||
13 | 1 | 0 | male | 33.0 | 0 | 0 | 695 | 5.0 | B51 B53 B55 | S | [null] | [null] | 1 | 1.6094379124341 | 0.993262053000915 | ||
14 | 1 | 0 | male | 28.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | 1 | 3.85227300102237 | 1.0 | ||
15 | 1 | 0 | male | 17.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | 1 | 3.85227300102237 | 1.0 | ||
16 | 1 | 0 | male | 49.0 | 0 | 0 | 19924 | 26.0 | [null] | S | [null] | [null] | 1 | 3.25809653802148 | 0.999999999994891 | ||
17 | 1 | 0 | male | [null] | 0 | 0 | 112051 | 0.0 | [null] | S | [null] | [null] | 1 | -inf | 0.0 | ||
18 | 1 | 0 | male | [null] | 0 | 0 | 110465 | 52.0 | A14 | S | [null] | [null] | 1 | 3.95124371858143 | 1.0 | ||
19 | 1 | 0 | male | 47.0 | 0 | 0 | 5727 | 25.5875 | E58 | S | [null] | [null] | 1 | 3.24210395098741 | 0.999999999992282 | ||
20 | 1 | 0 | male | [null] | 0 | 0 | 113791 | 26.55 | [null] | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
21 | 1 | 0 | male | 39.0 | 0 | 0 | PC 17580 | 29.7 | A18 | C | [null] | 133 | 1 | 3.39114704580865 | 0.999999999999874 | ||
22 | 1 | 0 | female | 36.0 | 0 | 0 | PC 17531 | 31.6792 | A29 | C | [null] | [null] | 1 | 3.45566031410212 | 0.999999999999983 | ||
23 | 1 | 0 | male | [null] | 0 | 0 | PC 17483 | 221.7792 | C95 | S | [null] | [null] | 1 | 5.40168229234028 | 1.0 | ||
24 | 1 | 0 | male | 30.0 | 0 | 0 | 113051 | 27.75 | C111 | C | [null] | [null] | 1 | 3.32323584019244 | 0.999999999999112 | ||
25 | 1 | 0 | male | [null] | 0 | 0 | 113778 | 26.55 | D34 | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
26 | 1 | 0 | male | [null] | 0 | 0 | 112058 | 0.0 | B102 | S | [null] | [null] | 1 | -inf | 0.0 | ||
27 | 1 | 0 | male | 47.0 | 0 | 0 | 111320 | 38.5 | E63 | S | [null] | 275 | 1 | 3.65065824129374 | 1.0 | ||
28 | 1 | 0 | male | 24.0 | 0 | 0 | PC 17593 | 79.2 | B86 | C | [null] | [null] | 1 | 4.37197629882038 | 1.0 | ||
29 | 1 | 0 | male | 71.0 | 0 | 0 | PC 17754 | 34.6542 | A5 | C | [null] | [null] | 1 | 3.54541893041153 | 0.999999999999999 | ||
30 | 1 | 0 | male | 46.0 | 0 | 0 | PC 17593 | 79.2 | B82 B84 | C | [null] | [null] | 1 | 4.37197629882038 | 1.0 | ||
31 | 1 | 0 | male | [null] | 0 | 0 | 113796 | 42.4 | [null] | S | [null] | [null] | 1 | 3.74714836223791 | 1.0 | ||
32 | 1 | 0 | male | 40.0 | 0 | 0 | 112059 | 0.0 | B94 | S | [null] | 110 | 1 | -inf | 0.0 | ||
33 | 1 | 0 | male | 42.0 | 0 | 0 | 113038 | 42.5 | B11 | S | [null] | [null] | 1 | 3.74950407593037 | 1.0 | ||
34 | 1 | 0 | male | [null] | 0 | 0 | 17463 | 51.8625 | E46 | S | [null] | [null] | 1 | 3.94859598565899 | 1.0 | ||
35 | 1 | 0 | male | 55.0 | 0 | 0 | 680 | 50.0 | C39 | S | [null] | [null] | 1 | 3.91202300542815 | 1.0 | ||
36 | 1 | 0 | male | [null] | 0 | 0 | PC 17600 | 30.6958 | [null] | C | 14 | [null] | 1 | 3.42412583741652 | 0.999999999999953 | ||
37 | 1 | 0 | female | 50.0 | 0 | 0 | PC 17595 | 28.7125 | C49 | C | [null] | [null] | 1 | 3.35733256801522 | 0.999999999999661 | ||
38 | 1 | 0 | male | 46.0 | 0 | 0 | 694 | 26.0 | [null] | S | [null] | 80 | 1 | 3.25809653802148 | 0.999999999994891 | ||
39 | 1 | 0 | male | 50.0 | 0 | 0 | 113044 | 26.0 | E60 | S | [null] | [null] | 1 | 3.25809653802148 | 0.999999999994891 | ||
40 | 1 | 0 | male | 32.5 | 0 | 0 | 113503 | 211.5 | C132 | C | [null] | 45 | 1 | 5.35422499848633 | 1.0 | ||
41 | 1 | 0 | male | 58.0 | 0 | 0 | 11771 | 29.7 | B37 | C | [null] | 258 | 1 | 3.39114704580865 | 0.999999999999874 | ||
42 | 1 | 0 | male | [null] | 0 | 0 | 113028 | 26.55 | C124 | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
43 | 1 | 0 | male | [null] | 0 | 0 | PC 17612 | 27.7208 | [null] | C | [null] | [null] | 1 | 3.32218303393412 | 0.999999999999086 | ||
44 | 1 | 0 | male | 29.0 | 0 | 0 | 113501 | 30.0 | D6 | S | [null] | 126 | 1 | 3.40119738166216 | 0.999999999999906 | ||
45 | 1 | 0 | male | 30.0 | 0 | 0 | 113801 | 45.5 | [null] | S | [null] | [null] | 1 | 3.8177123259569 | 1.0 | ||
46 | 1 | 0 | male | 30.0 | 0 | 0 | 110469 | 26.0 | C106 | S | [null] | [null] | 1 | 3.25809653802148 | 0.999999999994891 | ||
47 | 1 | 0 | male | 46.0 | 0 | 0 | 13050 | 75.2417 | C6 | C | [null] | 292 | 1 | 4.32070559854228 | 1.0 | ||
48 | 1 | 0 | male | 54.0 | 0 | 0 | 17463 | 51.8625 | E46 | S | [null] | 175 | 1 | 3.94859598565899 | 1.0 | ||
49 | 1 | 0 | male | 65.0 | 0 | 0 | 13509 | 26.55 | E38 | S | [null] | 249 | 1 | 3.27902974768795 | 0.999999999997052 | ||
50 | 1 | 0 | male | 55.0 | 0 | 0 | 113787 | 30.5 | C30 | S | [null] | [null] | 1 | 3.41772668361337 | 0.999999999999943 | ||
51 | 1 | 0 | male | 47.0 | 0 | 0 | 113796 | 42.4 | [null] | S | [null] | [null] | 1 | 3.74714836223791 | 1.0 | ||
52 | 1 | 0 | male | 64.0 | 0 | 0 | 693 | 26.0 | [null] | S | [null] | 263 | 1 | 3.25809653802148 | 0.999999999994891 | ||
53 | 1 | 0 | male | 28.5 | 0 | 0 | PC 17562 | 27.7208 | D43 | C | [null] | 189 | 1 | 3.32218303393412 | 0.999999999999086 | ||
54 | 1 | 0 | male | [null] | 0 | 0 | 112052 | 0.0 | [null] | S | [null] | [null] | 1 | -inf | 0.0 | ||
55 | 1 | 0 | male | 45.5 | 0 | 0 | 113043 | 28.5 | C124 | S | [null] | 166 | 1 | 3.3499040872746 | 0.999999999999581 | ||
56 | 1 | 0 | male | 23.0 | 0 | 0 | 12749 | 93.5 | B24 | S | [null] | [null] | 1 | 4.53796143629464 | 1.0 | ||
57 | 1 | 0 | male | 47.0 | 0 | 0 | 110465 | 52.0 | C110 | S | [null] | 207 | 1 | 3.95124371858143 | 1.0 | ||
58 | 1 | 0 | male | 38.0 | 0 | 0 | 19972 | 0.0 | [null] | S | [null] | [null] | 1 | -inf | 0.0 | ||
59 | 1 | 0 | male | 22.0 | 0 | 0 | PC 17760 | 135.6333 | [null] | C | [null] | 232 | 1 | 4.90995492057888 | 1.0 | ||
60 | 1 | 0 | male | [null] | 0 | 0 | PC 17757 | 227.525 | [null] | C | [null] | [null] | 1 | 5.42726012246342 | 1.0 | ||
61 | 1 | 0 | male | 31.0 | 0 | 0 | PC 17590 | 50.4958 | A24 | S | [null] | [null] | 1 | 3.92189016450581 | 1.0 | ||
62 | 1 | 0 | male | [null] | 0 | 0 | 113767 | 50.0 | A32 | S | [null] | [null] | 1 | 3.91202300542815 | 1.0 | ||
63 | 1 | 0 | male | 36.0 | 0 | 0 | 13049 | 40.125 | A10 | C | [null] | [null] | 1 | 3.69199958145018 | 1.0 | ||
64 | 1 | 0 | male | 33.0 | 0 | 0 | 113790 | 26.55 | [null] | S | [null] | 109 | 1 | 3.27902974768795 | 0.999999999997052 | ||
65 | 1 | 0 | male | 56.0 | 0 | 0 | 113792 | 26.55 | [null] | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
66 | 1 | 0 | male | 56.0 | 0 | 0 | 17764 | 30.6958 | A7 | C | [null] | [null] | 1 | 3.42412583741652 | 0.999999999999953 | ||
67 | 1 | 0 | male | [null] | 0 | 0 | 113056 | 26.0 | A19 | S | [null] | [null] | 1 | 3.25809653802148 | 0.999999999994891 | ||
68 | 1 | 0 | male | 62.0 | 0 | 0 | 113514 | 26.55 | C87 | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
69 | 1 | 0 | male | [null] | 0 | 0 | PC 17605 | 27.7208 | [null] | C | [null] | [null] | 1 | 3.32218303393412 | 0.999999999999086 | ||
70 | 1 | 0 | male | 61.0 | 0 | 0 | 36963 | 32.3208 | D50 | S | [null] | 46 | 1 | 3.4757109858218 | 0.999999999999991 | ||
71 | 1 | 0 | male | 40.0 | 0 | 0 | PC 17601 | 27.7208 | [null] | C | [null] | [null] | 1 | 3.32218303393412 | 0.999999999999086 | ||
72 | 1 | 0 | male | 61.0 | 0 | 0 | 111240 | 33.5 | B19 | S | [null] | 245 | 1 | 3.51154543883102 | 0.999999999999997 | ||
73 | 1 | 0 | male | 47.0 | 0 | 0 | 36967 | 34.0208 | D46 | S | [null] | [null] | 1 | 3.5269721022703 | 0.999999999999998 | ||
74 | 1 | 0 | male | 60.0 | 0 | 0 | 113800 | 26.55 | [null] | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
75 | 1 | 0 | male | [null] | 0 | 0 | 113510 | 35.0 | C128 | S | [null] | [null] | 1 | 3.55534806148941 | 0.999999999999999 | ||
76 | 1 | 0 | male | 62.0 | 0 | 0 | 113807 | 26.55 | [null] | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
77 | 1 | 1 | female | 29.0 | 0 | 0 | 24160 | 211.3375 | B5 | S | 2 | [null] | 1 | 5.35345638166308 | 1.0 | ||
78 | 1 | 1 | male | 48.0 | 0 | 0 | 19952 | 26.55 | E12 | S | 3 | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
79 | 1 | 1 | female | 24.0 | 0 | 0 | PC 17477 | 69.3 | B35 | C | 9 | [null] | 1 | 4.23844490619586 | 1.0 | ||
80 | 1 | 1 | male | 80.0 | 0 | 0 | 27042 | 30.0 | A23 | S | B | [null] | 1 | 3.40119738166216 | 0.999999999999906 | ||
81 | 1 | 1 | female | 32.0 | 0 | 0 | 11813 | 76.2917 | D15 | C | 8 | [null] | 1 | 4.33456415124619 | 1.0 | ||
82 | 1 | 1 | male | 26.0 | 0 | 0 | 111369 | 30.0 | C148 | C | 5 | [null] | 1 | 3.40119738166216 | 0.999999999999906 | ||
83 | 1 | 1 | female | 42.0 | 0 | 0 | PC 17757 | 227.525 | [null] | C | 4 | [null] | 1 | 5.42726012246342 | 1.0 | ||
84 | 1 | 1 | female | 29.0 | 0 | 0 | PC 17483 | 221.7792 | C97 | S | 8 | [null] | 1 | 5.40168229234028 | 1.0 | ||
85 | 1 | 1 | female | 35.0 | 0 | 0 | PC 17760 | 135.6333 | C99 | S | 8 | [null] | 1 | 4.90995492057888 | 1.0 | ||
86 | 1 | 1 | male | 28.0 | 0 | 0 | 110564 | 26.55 | C52 | S | D | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
87 | 1 | 1 | male | 40.0 | 0 | 0 | 112277 | 31.0 | A31 | C | 7 | [null] | 1 | 3.43398720448515 | 0.999999999999966 | ||
88 | 1 | 1 | female | 30.0 | 0 | 0 | 36928 | 164.8667 | C7 | S | 8 | [null] | 1 | 5.10513726860277 | 1.0 | ||
89 | 1 | 1 | female | 58.0 | 0 | 0 | 113783 | 26.55 | C103 | S | 8 | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
90 | 1 | 1 | female | 45.0 | 0 | 0 | PC 17608 | 262.375 | [null] | C | 4 | [null] | 1 | 5.5697747781408 | 1.0 | ||
91 | 1 | 1 | female | 44.0 | 0 | 0 | PC 17610 | 27.7208 | B4 | C | 6 | [null] | 1 | 3.32218303393412 | 0.999999999999086 | ||
92 | 1 | 1 | female | 60.0 | 0 | 0 | 11813 | 76.2917 | D15 | C | 8 | [null] | 1 | 4.33456415124619 | 1.0 | ||
93 | 1 | 1 | female | 41.0 | 0 | 0 | 16966 | 134.5 | E40 | C | 3 | [null] | 1 | 4.90156419904189 | 1.0 | ||
94 | 1 | 1 | male | 42.0 | 0 | 0 | PC 17476 | 26.2875 | E24 | S | 5 | [null] | 1 | 3.26909354102882 | 0.999999999996168 | ||
95 | 1 | 1 | female | 53.0 | 0 | 0 | PC 17606 | 27.4458 | [null] | C | 6 | [null] | 1 | 3.31221315078453 | 0.999999999998797 | ||
96 | 1 | 1 | female | [null] | 0 | 0 | 17770 | 27.7208 | [null] | C | 5 | [null] | 1 | 3.32218303393412 | 0.999999999999086 | ||
97 | 1 | 1 | female | 36.0 | 0 | 0 | PC 17608 | 262.375 | B61 | C | 4 | [null] | 1 | 5.5697747781408 | 1.0 | ||
98 | 1 | 1 | female | 30.0 | 0 | 0 | 110152 | 86.5 | B77 | S | 8 | [null] | 1 | 4.46014441393783 | 1.0 | ||
99 | 1 | 1 | male | 45.0 | 0 | 0 | PC 17594 | 29.7 | A9 | C | 7 | [null] | 1 | 3.39114704580865 | 0.999999999999874 | ||
100 | 1 | 1 | female | 22.0 | 0 | 0 | 113781 | 151.55 | [null] | S | 11 | [null] | 1 | 5.02091560350381 | 1.0 |
Not In Operator (_not_in)
[14]:
# ...with the 'not_in' method
single_family[titanic["pclass"]._not_in(2)]
[14]:
123 pclassInt | 123 survivedInt | Abc Varchar(164) | Abc sexVarchar(20) | 123 ageNumeric(6,3) | 123 sibspInt | 123 parchInt | Abc ticketVarchar(36) | 123 fareNumeric(10,5) | Abc cabinVarchar(30) | Abc embarkedVarchar(20) | Abc boatVarchar(100) | 123 bodyInt | Abc Varchar(100) | 123 family_sizeInt | |
1 | 1 | 0 | male | 39.0 | 0 | 0 | 112050 | 0.0 | A36 | S | [null] | [null] | 1 | ||
2 | 1 | 0 | male | 71.0 | 0 | 0 | PC 17609 | 49.5042 | [null] | C | [null] | 22 | 1 | ||
3 | 1 | 0 | male | [null] | 0 | 0 | PC 17318 | 25.925 | [null] | S | [null] | [null] | 1 | ||
4 | 1 | 0 | male | 36.0 | 0 | 0 | 13050 | 75.2417 | C6 | C | A | [null] | 1 | ||
5 | 1 | 0 | male | 25.0 | 0 | 0 | 13905 | 26.0 | [null] | C | [null] | 148 | 1 | ||
6 | 1 | 0 | male | 45.0 | 0 | 0 | 113784 | 35.5 | T | S | [null] | [null] | 1 | ||
7 | 1 | 0 | male | 42.0 | 0 | 0 | 110489 | 26.55 | D22 | S | [null] | [null] | 1 | ||
8 | 1 | 0 | male | 41.0 | 0 | 0 | 113054 | 30.5 | A21 | S | [null] | [null] | 1 | ||
9 | 1 | 0 | male | 48.0 | 0 | 0 | PC 17591 | 50.4958 | B10 | C | [null] | 208 | 1 | ||
10 | 1 | 0 | male | [null] | 0 | 0 | 112379 | 39.6 | [null] | C | [null] | [null] | 1 | ||
11 | 1 | 0 | male | 45.0 | 0 | 0 | 113050 | 26.55 | B38 | S | [null] | [null] | 1 | ||
12 | 1 | 0 | male | [null] | 0 | 0 | 113798 | 31.0 | [null] | S | [null] | [null] | 1 | ||
13 | 1 | 0 | male | 33.0 | 0 | 0 | 695 | 5.0 | B51 B53 B55 | S | [null] | [null] | 1 | ||
14 | 1 | 0 | male | 28.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | 1 | ||
15 | 1 | 0 | male | 17.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | 1 | ||
16 | 1 | 0 | male | 49.0 | 0 | 0 | 19924 | 26.0 | [null] | S | [null] | [null] | 1 | ||
17 | 1 | 0 | male | [null] | 0 | 0 | 112051 | 0.0 | [null] | S | [null] | [null] | 1 | ||
18 | 1 | 0 | male | [null] | 0 | 0 | 110465 | 52.0 | A14 | S | [null] | [null] | 1 | ||
19 | 1 | 0 | male | 47.0 | 0 | 0 | 5727 | 25.5875 | E58 | S | [null] | [null] | 1 | ||
20 | 1 | 0 | male | [null] | 0 | 0 | 113791 | 26.55 | [null] | S | [null] | [null] | 1 | ||
21 | 1 | 0 | male | 39.0 | 0 | 0 | PC 17580 | 29.7 | A18 | C | [null] | 133 | 1 | ||
22 | 1 | 0 | female | 36.0 | 0 | 0 | PC 17531 | 31.6792 | A29 | C | [null] | [null] | 1 | ||
23 | 1 | 0 | male | [null] | 0 | 0 | PC 17483 | 221.7792 | C95 | S | [null] | [null] | 1 | ||
24 | 1 | 0 | male | 30.0 | 0 | 0 | 113051 | 27.75 | C111 | C | [null] | [null] | 1 | ||
25 | 1 | 0 | male | [null] | 0 | 0 | 113778 | 26.55 | D34 | S | [null] | [null] | 1 | ||
26 | 1 | 0 | male | [null] | 0 | 0 | 112058 | 0.0 | B102 | S | [null] | [null] | 1 | ||
27 | 1 | 0 | male | 47.0 | 0 | 0 | 111320 | 38.5 | E63 | S | [null] | 275 | 1 | ||
28 | 1 | 0 | male | 24.0 | 0 | 0 | PC 17593 | 79.2 | B86 | C | [null] | [null] | 1 | ||
29 | 1 | 0 | male | 71.0 | 0 | 0 | PC 17754 | 34.6542 | A5 | C | [null] | [null] | 1 | ||
30 | 1 | 0 | male | 46.0 | 0 | 0 | PC 17593 | 79.2 | B82 B84 | C | [null] | [null] | 1 | ||
31 | 1 | 0 | male | [null] | 0 | 0 | 113796 | 42.4 | [null] | S | [null] | [null] | 1 | ||
32 | 1 | 0 | male | 40.0 | 0 | 0 | 112059 | 0.0 | B94 | S | [null] | 110 | 1 | ||
33 | 1 | 0 | male | 42.0 | 0 | 0 | 113038 | 42.5 | B11 | S | [null] | [null] | 1 | ||
34 | 1 | 0 | male | [null] | 0 | 0 | 17463 | 51.8625 | E46 | S | [null] | [null] | 1 | ||
35 | 1 | 0 | male | 55.0 | 0 | 0 | 680 | 50.0 | C39 | S | [null] | [null] | 1 | ||
36 | 1 | 0 | male | [null] | 0 | 0 | PC 17600 | 30.6958 | [null] | C | 14 | [null] | 1 | ||
37 | 1 | 0 | female | 50.0 | 0 | 0 | PC 17595 | 28.7125 | C49 | C | [null] | [null] | 1 | ||
38 | 1 | 0 | male | 46.0 | 0 | 0 | 694 | 26.0 | [null] | S | [null] | 80 | 1 | ||
39 | 1 | 0 | male | 50.0 | 0 | 0 | 113044 | 26.0 | E60 | S | [null] | [null] | 1 | ||
40 | 1 | 0 | male | 32.5 | 0 | 0 | 113503 | 211.5 | C132 | C | [null] | 45 | 1 | ||
41 | 1 | 0 | male | 58.0 | 0 | 0 | 11771 | 29.7 | B37 | C | [null] | 258 | 1 | ||
42 | 1 | 0 | male | [null] | 0 | 0 | 113028 | 26.55 | C124 | S | [null] | [null] | 1 | ||
43 | 1 | 0 | male | [null] | 0 | 0 | PC 17612 | 27.7208 | [null] | C | [null] | [null] | 1 | ||
44 | 1 | 0 | male | 29.0 | 0 | 0 | 113501 | 30.0 | D6 | S | [null] | 126 | 1 | ||
45 | 1 | 0 | male | 30.0 | 0 | 0 | 113801 | 45.5 | [null] | S | [null] | [null] | 1 | ||
46 | 1 | 0 | male | 30.0 | 0 | 0 | 110469 | 26.0 | C106 | S | [null] | [null] | 1 | ||
47 | 1 | 0 | male | 46.0 | 0 | 0 | 13050 | 75.2417 | C6 | C | [null] | 292 | 1 | ||
48 | 1 | 0 | male | 54.0 | 0 | 0 | 17463 | 51.8625 | E46 | S | [null] | 175 | 1 | ||
49 | 1 | 0 | male | 65.0 | 0 | 0 | 13509 | 26.55 | E38 | S | [null] | 249 | 1 | ||
50 | 1 | 0 | male | 55.0 | 0 | 0 | 113787 | 30.5 | C30 | S | [null] | [null] | 1 | ||
51 | 1 | 0 | male | 47.0 | 0 | 0 | 113796 | 42.4 | [null] | S | [null] | [null] | 1 | ||
52 | 1 | 0 | male | 64.0 | 0 | 0 | 693 | 26.0 | [null] | S | [null] | 263 | 1 | ||
53 | 1 | 0 | male | 28.5 | 0 | 0 | PC 17562 | 27.7208 | D43 | C | [null] | 189 | 1 | ||
54 | 1 | 0 | male | [null] | 0 | 0 | 112052 | 0.0 | [null] | S | [null] | [null] | 1 | ||
55 | 1 | 0 | male | 45.5 | 0 | 0 | 113043 | 28.5 | C124 | S | [null] | 166 | 1 | ||
56 | 1 | 0 | male | 23.0 | 0 | 0 | 12749 | 93.5 | B24 | S | [null] | [null] | 1 | ||
57 | 1 | 0 | male | 47.0 | 0 | 0 | 110465 | 52.0 | C110 | S | [null] | 207 | 1 | ||
58 | 1 | 0 | male | 38.0 | 0 | 0 | 19972 | 0.0 | [null] | S | [null] | [null] | 1 | ||
59 | 1 | 0 | male | 22.0 | 0 | 0 | PC 17760 | 135.6333 | [null] | C | [null] | 232 | 1 | ||
60 | 1 | 0 | male | [null] | 0 | 0 | PC 17757 | 227.525 | [null] | C | [null] | [null] | 1 | ||
61 | 1 | 0 | male | 31.0 | 0 | 0 | PC 17590 | 50.4958 | A24 | S | [null] | [null] | 1 | ||
62 | 1 | 0 | male | [null] | 0 | 0 | 113767 | 50.0 | A32 | S | [null] | [null] | 1 | ||
63 | 1 | 0 | male | 36.0 | 0 | 0 | 13049 | 40.125 | A10 | C | [null] | [null] | 1 | ||
64 | 1 | 0 | male | 33.0 | 0 | 0 | 113790 | 26.55 | [null] | S | [null] | 109 | 1 | ||
65 | 1 | 0 | male | 56.0 | 0 | 0 | 113792 | 26.55 | [null] | S | [null] | [null] | 1 | ||
66 | 1 | 0 | male | 56.0 | 0 | 0 | 17764 | 30.6958 | A7 | C | [null] | [null] | 1 | ||
67 | 1 | 0 | male | [null] | 0 | 0 | 113056 | 26.0 | A19 | S | [null] | [null] | 1 | ||
68 | 1 | 0 | male | 62.0 | 0 | 0 | 113514 | 26.55 | C87 | S | [null] | [null] | 1 | ||
69 | 1 | 0 | male | [null] | 0 | 0 | PC 17605 | 27.7208 | [null] | C | [null] | [null] | 1 | ||
70 | 1 | 0 | male | 61.0 | 0 | 0 | 36963 | 32.3208 | D50 | S | [null] | 46 | 1 | ||
71 | 1 | 0 | male | 40.0 | 0 | 0 | PC 17601 | 27.7208 | [null] | C | [null] | [null] | 1 | ||
72 | 1 | 0 | male | 61.0 | 0 | 0 | 111240 | 33.5 | B19 | S | [null] | 245 | 1 | ||
73 | 1 | 0 | male | 47.0 | 0 | 0 | 36967 | 34.0208 | D46 | S | [null] | [null] | 1 | ||
74 | 1 | 0 | male | 60.0 | 0 | 0 | 113800 | 26.55 | [null] | S | [null] | [null] | 1 | ||
75 | 1 | 0 | male | [null] | 0 | 0 | 113510 | 35.0 | C128 | S | [null] | [null] | 1 | ||
76 | 1 | 0 | male | 62.0 | 0 | 0 | 113807 | 26.55 | [null] | S | [null] | [null] | 1 | ||
77 | 1 | 1 | female | 29.0 | 0 | 0 | 24160 | 211.3375 | B5 | S | 2 | [null] | 1 | ||
78 | 1 | 1 | male | 48.0 | 0 | 0 | 19952 | 26.55 | E12 | S | 3 | [null] | 1 | ||
79 | 1 | 1 | female | 24.0 | 0 | 0 | PC 17477 | 69.3 | B35 | C | 9 | [null] | 1 | ||
80 | 1 | 1 | male | 80.0 | 0 | 0 | 27042 | 30.0 | A23 | S | B | [null] | 1 | ||
81 | 1 | 1 | female | 32.0 | 0 | 0 | 11813 | 76.2917 | D15 | C | 8 | [null] | 1 | ||
82 | 1 | 1 | male | 26.0 | 0 | 0 | 111369 | 30.0 | C148 | C | 5 | [null] | 1 | ||
83 | 1 | 1 | female | 42.0 | 0 | 0 | PC 17757 | 227.525 | [null] | C | 4 | [null] | 1 | ||
84 | 1 | 1 | female | 29.0 | 0 | 0 | PC 17483 | 221.7792 | C97 | S | 8 | [null] | 1 | ||
85 | 1 | 1 | female | 35.0 | 0 | 0 | PC 17760 | 135.6333 | C99 | S | 8 | [null] | 1 | ||
86 | 1 | 1 | male | 28.0 | 0 | 0 | 110564 | 26.55 | C52 | S | D | [null] | 1 | ||
87 | 1 | 1 | male | 40.0 | 0 | 0 | 112277 | 31.0 | A31 | C | 7 | [null] | 1 | ||
88 | 1 | 1 | female | 30.0 | 0 | 0 | 36928 | 164.8667 | C7 | S | 8 | [null] | 1 | ||
89 | 1 | 1 | female | 58.0 | 0 | 0 | 113783 | 26.55 | C103 | S | 8 | [null] | 1 | ||
90 | 1 | 1 | female | 45.0 | 0 | 0 | PC 17608 | 262.375 | [null] | C | 4 | [null] | 1 | ||
91 | 1 | 1 | female | 44.0 | 0 | 0 | PC 17610 | 27.7208 | B4 | C | 6 | [null] | 1 | ||
92 | 1 | 1 | female | 60.0 | 0 | 0 | 11813 | 76.2917 | D15 | C | 8 | [null] | 1 | ||
93 | 1 | 1 | female | 41.0 | 0 | 0 | 16966 | 134.5 | E40 | C | 3 | [null] | 1 | ||
94 | 1 | 1 | male | 42.0 | 0 | 0 | PC 17476 | 26.2875 | E24 | S | 5 | [null] | 1 | ||
95 | 1 | 1 | female | 53.0 | 0 | 0 | PC 17606 | 27.4458 | [null] | C | 6 | [null] | 1 | ||
96 | 1 | 1 | female | [null] | 0 | 0 | 17770 | 27.7208 | [null] | C | 5 | [null] | 1 | ||
97 | 1 | 1 | female | 36.0 | 0 | 0 | PC 17608 | 262.375 | B61 | C | 4 | [null] | 1 | ||
98 | 1 | 1 | female | 30.0 | 0 | 0 | 110152 | 86.5 | B77 | S | 8 | [null] | 1 | ||
99 | 1 | 1 | male | 45.0 | 0 | 0 | PC 17594 | 29.7 | A9 | C | 7 | [null] | 1 | ||
100 | 1 | 1 | female | 22.0 | 0 | 0 | 113781 | 151.55 | [null] | S | 11 | [null] | 1 |
Or Operator (|)
[12]:
# Or operator
single_family[(titanic["pclass"] == 1) | (titanic["pclass"] == 3)]
[12]:
123 pclassInt | 123 survivedInt | Abc Varchar(164) | Abc sexVarchar(20) | 123 ageNumeric(6,3) | 123 sibspInt | 123 parchInt | Abc ticketVarchar(36) | 123 fareNumeric(10,5) | Abc cabinVarchar(30) | Abc embarkedVarchar(20) | Abc boatVarchar(100) | 123 bodyInt | Abc Varchar(100) | 123 family_sizeInt | 123 ln_fareFloat | 123 xFloat | |
1 | 1 | 0 | male | 39.0 | 0 | 0 | 112050 | 0.0 | A36 | S | [null] | [null] | 1 | -inf | 0.0 | ||
2 | 1 | 0 | male | 71.0 | 0 | 0 | PC 17609 | 49.5042 | [null] | C | [null] | 22 | 1 | 3.90205751446006 | 1.0 | ||
3 | 1 | 0 | male | [null] | 0 | 0 | PC 17318 | 25.925 | [null] | S | [null] | [null] | 1 | 3.25520775411559 | 0.999999999994493 | ||
4 | 1 | 0 | male | 36.0 | 0 | 0 | 13050 | 75.2417 | C6 | C | A | [null] | 1 | 4.32070559854228 | 1.0 | ||
5 | 1 | 0 | male | 25.0 | 0 | 0 | 13905 | 26.0 | [null] | C | [null] | 148 | 1 | 3.25809653802148 | 0.999999999994891 | ||
6 | 1 | 0 | male | 45.0 | 0 | 0 | 113784 | 35.5 | T | S | [null] | [null] | 1 | 3.56953269648137 | 1.0 | ||
7 | 1 | 0 | male | 42.0 | 0 | 0 | 110489 | 26.55 | D22 | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
8 | 1 | 0 | male | 41.0 | 0 | 0 | 113054 | 30.5 | A21 | S | [null] | [null] | 1 | 3.41772668361337 | 0.999999999999943 | ||
9 | 1 | 0 | male | 48.0 | 0 | 0 | PC 17591 | 50.4958 | B10 | C | [null] | 208 | 1 | 3.92189016450581 | 1.0 | ||
10 | 1 | 0 | male | [null] | 0 | 0 | 112379 | 39.6 | [null] | C | [null] | [null] | 1 | 3.67882911826043 | 1.0 | ||
11 | 1 | 0 | male | 45.0 | 0 | 0 | 113050 | 26.55 | B38 | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
12 | 1 | 0 | male | [null] | 0 | 0 | 113798 | 31.0 | [null] | S | [null] | [null] | 1 | 3.43398720448515 | 0.999999999999966 | ||
13 | 1 | 0 | male | 33.0 | 0 | 0 | 695 | 5.0 | B51 B53 B55 | S | [null] | [null] | 1 | 1.6094379124341 | 0.993262053000915 | ||
14 | 1 | 0 | male | 28.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | 1 | 3.85227300102237 | 1.0 | ||
15 | 1 | 0 | male | 17.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | 1 | 3.85227300102237 | 1.0 | ||
16 | 1 | 0 | male | 49.0 | 0 | 0 | 19924 | 26.0 | [null] | S | [null] | [null] | 1 | 3.25809653802148 | 0.999999999994891 | ||
17 | 1 | 0 | male | [null] | 0 | 0 | 112051 | 0.0 | [null] | S | [null] | [null] | 1 | -inf | 0.0 | ||
18 | 1 | 0 | male | [null] | 0 | 0 | 110465 | 52.0 | A14 | S | [null] | [null] | 1 | 3.95124371858143 | 1.0 | ||
19 | 1 | 0 | male | 47.0 | 0 | 0 | 5727 | 25.5875 | E58 | S | [null] | [null] | 1 | 3.24210395098741 | 0.999999999992282 | ||
20 | 1 | 0 | male | [null] | 0 | 0 | 113791 | 26.55 | [null] | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
21 | 1 | 0 | male | 39.0 | 0 | 0 | PC 17580 | 29.7 | A18 | C | [null] | 133 | 1 | 3.39114704580865 | 0.999999999999874 | ||
22 | 1 | 0 | female | 36.0 | 0 | 0 | PC 17531 | 31.6792 | A29 | C | [null] | [null] | 1 | 3.45566031410212 | 0.999999999999983 | ||
23 | 1 | 0 | male | [null] | 0 | 0 | PC 17483 | 221.7792 | C95 | S | [null] | [null] | 1 | 5.40168229234028 | 1.0 | ||
24 | 1 | 0 | male | 30.0 | 0 | 0 | 113051 | 27.75 | C111 | C | [null] | [null] | 1 | 3.32323584019244 | 0.999999999999112 | ||
25 | 1 | 0 | male | [null] | 0 | 0 | 113778 | 26.55 | D34 | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
26 | 1 | 0 | male | [null] | 0 | 0 | 112058 | 0.0 | B102 | S | [null] | [null] | 1 | -inf | 0.0 | ||
27 | 1 | 0 | male | 47.0 | 0 | 0 | 111320 | 38.5 | E63 | S | [null] | 275 | 1 | 3.65065824129374 | 1.0 | ||
28 | 1 | 0 | male | 24.0 | 0 | 0 | PC 17593 | 79.2 | B86 | C | [null] | [null] | 1 | 4.37197629882038 | 1.0 | ||
29 | 1 | 0 | male | 71.0 | 0 | 0 | PC 17754 | 34.6542 | A5 | C | [null] | [null] | 1 | 3.54541893041153 | 0.999999999999999 | ||
30 | 1 | 0 | male | 46.0 | 0 | 0 | PC 17593 | 79.2 | B82 B84 | C | [null] | [null] | 1 | 4.37197629882038 | 1.0 | ||
31 | 1 | 0 | male | [null] | 0 | 0 | 113796 | 42.4 | [null] | S | [null] | [null] | 1 | 3.74714836223791 | 1.0 | ||
32 | 1 | 0 | male | 40.0 | 0 | 0 | 112059 | 0.0 | B94 | S | [null] | 110 | 1 | -inf | 0.0 | ||
33 | 1 | 0 | male | 42.0 | 0 | 0 | 113038 | 42.5 | B11 | S | [null] | [null] | 1 | 3.74950407593037 | 1.0 | ||
34 | 1 | 0 | male | [null] | 0 | 0 | 17463 | 51.8625 | E46 | S | [null] | [null] | 1 | 3.94859598565899 | 1.0 | ||
35 | 1 | 0 | male | 55.0 | 0 | 0 | 680 | 50.0 | C39 | S | [null] | [null] | 1 | 3.91202300542815 | 1.0 | ||
36 | 1 | 0 | male | [null] | 0 | 0 | PC 17600 | 30.6958 | [null] | C | 14 | [null] | 1 | 3.42412583741652 | 0.999999999999953 | ||
37 | 1 | 0 | female | 50.0 | 0 | 0 | PC 17595 | 28.7125 | C49 | C | [null] | [null] | 1 | 3.35733256801522 | 0.999999999999661 | ||
38 | 1 | 0 | male | 46.0 | 0 | 0 | 694 | 26.0 | [null] | S | [null] | 80 | 1 | 3.25809653802148 | 0.999999999994891 | ||
39 | 1 | 0 | male | 50.0 | 0 | 0 | 113044 | 26.0 | E60 | S | [null] | [null] | 1 | 3.25809653802148 | 0.999999999994891 | ||
40 | 1 | 0 | male | 32.5 | 0 | 0 | 113503 | 211.5 | C132 | C | [null] | 45 | 1 | 5.35422499848633 | 1.0 | ||
41 | 1 | 0 | male | 58.0 | 0 | 0 | 11771 | 29.7 | B37 | C | [null] | 258 | 1 | 3.39114704580865 | 0.999999999999874 | ||
42 | 1 | 0 | male | [null] | 0 | 0 | 113028 | 26.55 | C124 | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
43 | 1 | 0 | male | [null] | 0 | 0 | PC 17612 | 27.7208 | [null] | C | [null] | [null] | 1 | 3.32218303393412 | 0.999999999999086 | ||
44 | 1 | 0 | male | 29.0 | 0 | 0 | 113501 | 30.0 | D6 | S | [null] | 126 | 1 | 3.40119738166216 | 0.999999999999906 | ||
45 | 1 | 0 | male | 30.0 | 0 | 0 | 113801 | 45.5 | [null] | S | [null] | [null] | 1 | 3.8177123259569 | 1.0 | ||
46 | 1 | 0 | male | 30.0 | 0 | 0 | 110469 | 26.0 | C106 | S | [null] | [null] | 1 | 3.25809653802148 | 0.999999999994891 | ||
47 | 1 | 0 | male | 46.0 | 0 | 0 | 13050 | 75.2417 | C6 | C | [null] | 292 | 1 | 4.32070559854228 | 1.0 | ||
48 | 1 | 0 | male | 54.0 | 0 | 0 | 17463 | 51.8625 | E46 | S | [null] | 175 | 1 | 3.94859598565899 | 1.0 | ||
49 | 1 | 0 | male | 65.0 | 0 | 0 | 13509 | 26.55 | E38 | S | [null] | 249 | 1 | 3.27902974768795 | 0.999999999997052 | ||
50 | 1 | 0 | male | 55.0 | 0 | 0 | 113787 | 30.5 | C30 | S | [null] | [null] | 1 | 3.41772668361337 | 0.999999999999943 | ||
51 | 1 | 0 | male | 47.0 | 0 | 0 | 113796 | 42.4 | [null] | S | [null] | [null] | 1 | 3.74714836223791 | 1.0 | ||
52 | 1 | 0 | male | 64.0 | 0 | 0 | 693 | 26.0 | [null] | S | [null] | 263 | 1 | 3.25809653802148 | 0.999999999994891 | ||
53 | 1 | 0 | male | 28.5 | 0 | 0 | PC 17562 | 27.7208 | D43 | C | [null] | 189 | 1 | 3.32218303393412 | 0.999999999999086 | ||
54 | 1 | 0 | male | [null] | 0 | 0 | 112052 | 0.0 | [null] | S | [null] | [null] | 1 | -inf | 0.0 | ||
55 | 1 | 0 | male | 45.5 | 0 | 0 | 113043 | 28.5 | C124 | S | [null] | 166 | 1 | 3.3499040872746 | 0.999999999999581 | ||
56 | 1 | 0 | male | 23.0 | 0 | 0 | 12749 | 93.5 | B24 | S | [null] | [null] | 1 | 4.53796143629464 | 1.0 | ||
57 | 1 | 0 | male | 47.0 | 0 | 0 | 110465 | 52.0 | C110 | S | [null] | 207 | 1 | 3.95124371858143 | 1.0 | ||
58 | 1 | 0 | male | 38.0 | 0 | 0 | 19972 | 0.0 | [null] | S | [null] | [null] | 1 | -inf | 0.0 | ||
59 | 1 | 0 | male | 22.0 | 0 | 0 | PC 17760 | 135.6333 | [null] | C | [null] | 232 | 1 | 4.90995492057888 | 1.0 | ||
60 | 1 | 0 | male | [null] | 0 | 0 | PC 17757 | 227.525 | [null] | C | [null] | [null] | 1 | 5.42726012246342 | 1.0 | ||
61 | 1 | 0 | male | 31.0 | 0 | 0 | PC 17590 | 50.4958 | A24 | S | [null] | [null] | 1 | 3.92189016450581 | 1.0 | ||
62 | 1 | 0 | male | [null] | 0 | 0 | 113767 | 50.0 | A32 | S | [null] | [null] | 1 | 3.91202300542815 | 1.0 | ||
63 | 1 | 0 | male | 36.0 | 0 | 0 | 13049 | 40.125 | A10 | C | [null] | [null] | 1 | 3.69199958145018 | 1.0 | ||
64 | 1 | 0 | male | 33.0 | 0 | 0 | 113790 | 26.55 | [null] | S | [null] | 109 | 1 | 3.27902974768795 | 0.999999999997052 | ||
65 | 1 | 0 | male | 56.0 | 0 | 0 | 113792 | 26.55 | [null] | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
66 | 1 | 0 | male | 56.0 | 0 | 0 | 17764 | 30.6958 | A7 | C | [null] | [null] | 1 | 3.42412583741652 | 0.999999999999953 | ||
67 | 1 | 0 | male | [null] | 0 | 0 | 113056 | 26.0 | A19 | S | [null] | [null] | 1 | 3.25809653802148 | 0.999999999994891 | ||
68 | 1 | 0 | male | 62.0 | 0 | 0 | 113514 | 26.55 | C87 | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
69 | 1 | 0 | male | [null] | 0 | 0 | PC 17605 | 27.7208 | [null] | C | [null] | [null] | 1 | 3.32218303393412 | 0.999999999999086 | ||
70 | 1 | 0 | male | 61.0 | 0 | 0 | 36963 | 32.3208 | D50 | S | [null] | 46 | 1 | 3.4757109858218 | 0.999999999999991 | ||
71 | 1 | 0 | male | 40.0 | 0 | 0 | PC 17601 | 27.7208 | [null] | C | [null] | [null] | 1 | 3.32218303393412 | 0.999999999999086 | ||
72 | 1 | 0 | male | 61.0 | 0 | 0 | 111240 | 33.5 | B19 | S | [null] | 245 | 1 | 3.51154543883102 | 0.999999999999997 | ||
73 | 1 | 0 | male | 47.0 | 0 | 0 | 36967 | 34.0208 | D46 | S | [null] | [null] | 1 | 3.5269721022703 | 0.999999999999998 | ||
74 | 1 | 0 | male | 60.0 | 0 | 0 | 113800 | 26.55 | [null] | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
75 | 1 | 0 | male | [null] | 0 | 0 | 113510 | 35.0 | C128 | S | [null] | [null] | 1 | 3.55534806148941 | 0.999999999999999 | ||
76 | 1 | 0 | male | 62.0 | 0 | 0 | 113807 | 26.55 | [null] | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
77 | 1 | 1 | female | 29.0 | 0 | 0 | 24160 | 211.3375 | B5 | S | 2 | [null] | 1 | 5.35345638166308 | 1.0 | ||
78 | 1 | 1 | male | 48.0 | 0 | 0 | 19952 | 26.55 | E12 | S | 3 | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
79 | 1 | 1 | female | 24.0 | 0 | 0 | PC 17477 | 69.3 | B35 | C | 9 | [null] | 1 | 4.23844490619586 | 1.0 | ||
80 | 1 | 1 | male | 80.0 | 0 | 0 | 27042 | 30.0 | A23 | S | B | [null] | 1 | 3.40119738166216 | 0.999999999999906 | ||
81 | 1 | 1 | female | 32.0 | 0 | 0 | 11813 | 76.2917 | D15 | C | 8 | [null] | 1 | 4.33456415124619 | 1.0 | ||
82 | 1 | 1 | male | 26.0 | 0 | 0 | 111369 | 30.0 | C148 | C | 5 | [null] | 1 | 3.40119738166216 | 0.999999999999906 | ||
83 | 1 | 1 | female | 42.0 | 0 | 0 | PC 17757 | 227.525 | [null] | C | 4 | [null] | 1 | 5.42726012246342 | 1.0 | ||
84 | 1 | 1 | female | 29.0 | 0 | 0 | PC 17483 | 221.7792 | C97 | S | 8 | [null] | 1 | 5.40168229234028 | 1.0 | ||
85 | 1 | 1 | female | 35.0 | 0 | 0 | PC 17760 | 135.6333 | C99 | S | 8 | [null] | 1 | 4.90995492057888 | 1.0 | ||
86 | 1 | 1 | male | 28.0 | 0 | 0 | 110564 | 26.55 | C52 | S | D | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
87 | 1 | 1 | male | 40.0 | 0 | 0 | 112277 | 31.0 | A31 | C | 7 | [null] | 1 | 3.43398720448515 | 0.999999999999966 | ||
88 | 1 | 1 | female | 30.0 | 0 | 0 | 36928 | 164.8667 | C7 | S | 8 | [null] | 1 | 5.10513726860277 | 1.0 | ||
89 | 1 | 1 | female | 58.0 | 0 | 0 | 113783 | 26.55 | C103 | S | 8 | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
90 | 1 | 1 | female | 45.0 | 0 | 0 | PC 17608 | 262.375 | [null] | C | 4 | [null] | 1 | 5.5697747781408 | 1.0 | ||
91 | 1 | 1 | female | 44.0 | 0 | 0 | PC 17610 | 27.7208 | B4 | C | 6 | [null] | 1 | 3.32218303393412 | 0.999999999999086 | ||
92 | 1 | 1 | female | 60.0 | 0 | 0 | 11813 | 76.2917 | D15 | C | 8 | [null] | 1 | 4.33456415124619 | 1.0 | ||
93 | 1 | 1 | female | 41.0 | 0 | 0 | 16966 | 134.5 | E40 | C | 3 | [null] | 1 | 4.90156419904189 | 1.0 | ||
94 | 1 | 1 | male | 42.0 | 0 | 0 | PC 17476 | 26.2875 | E24 | S | 5 | [null] | 1 | 3.26909354102882 | 0.999999999996168 | ||
95 | 1 | 1 | female | 53.0 | 0 | 0 | PC 17606 | 27.4458 | [null] | C | 6 | [null] | 1 | 3.31221315078453 | 0.999999999998797 | ||
96 | 1 | 1 | female | [null] | 0 | 0 | 17770 | 27.7208 | [null] | C | 5 | [null] | 1 | 3.32218303393412 | 0.999999999999086 | ||
97 | 1 | 1 | female | 36.0 | 0 | 0 | PC 17608 | 262.375 | B61 | C | 4 | [null] | 1 | 5.5697747781408 | 1.0 | ||
98 | 1 | 1 | female | 30.0 | 0 | 0 | 110152 | 86.5 | B77 | S | 8 | [null] | 1 | 4.46014441393783 | 1.0 | ||
99 | 1 | 1 | male | 45.0 | 0 | 0 | PC 17594 | 29.7 | A9 | C | 7 | [null] | 1 | 3.39114704580865 | 0.999999999999874 | ||
100 | 1 | 1 | female | 22.0 | 0 | 0 | 113781 | 151.55 | [null] | S | 11 | [null] | 1 | 5.02091560350381 | 1.0 |
Not Equal Operator (!=)
[13]:
# ...with the not equal operator
single_family[titanic["pclass"] != 2]
[13]:
123 pclassInt | 123 survivedInt | Abc Varchar(164) | Abc sexVarchar(20) | 123 ageNumeric(6,3) | 123 sibspInt | 123 parchInt | Abc ticketVarchar(36) | 123 fareNumeric(10,5) | Abc cabinVarchar(30) | Abc embarkedVarchar(20) | Abc boatVarchar(100) | 123 bodyInt | Abc Varchar(100) | 123 family_sizeInt | 123 ln_fareFloat | 123 xFloat | |
1 | 1 | 0 | male | 39.0 | 0 | 0 | 112050 | 0.0 | A36 | S | [null] | [null] | 1 | -inf | 0.0 | ||
2 | 1 | 0 | male | 71.0 | 0 | 0 | PC 17609 | 49.5042 | [null] | C | [null] | 22 | 1 | 3.90205751446006 | 1.0 | ||
3 | 1 | 0 | male | [null] | 0 | 0 | PC 17318 | 25.925 | [null] | S | [null] | [null] | 1 | 3.25520775411559 | 0.999999999994493 | ||
4 | 1 | 0 | male | 36.0 | 0 | 0 | 13050 | 75.2417 | C6 | C | A | [null] | 1 | 4.32070559854228 | 1.0 | ||
5 | 1 | 0 | male | 25.0 | 0 | 0 | 13905 | 26.0 | [null] | C | [null] | 148 | 1 | 3.25809653802148 | 0.999999999994891 | ||
6 | 1 | 0 | male | 45.0 | 0 | 0 | 113784 | 35.5 | T | S | [null] | [null] | 1 | 3.56953269648137 | 1.0 | ||
7 | 1 | 0 | male | 42.0 | 0 | 0 | 110489 | 26.55 | D22 | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
8 | 1 | 0 | male | 41.0 | 0 | 0 | 113054 | 30.5 | A21 | S | [null] | [null] | 1 | 3.41772668361337 | 0.999999999999943 | ||
9 | 1 | 0 | male | 48.0 | 0 | 0 | PC 17591 | 50.4958 | B10 | C | [null] | 208 | 1 | 3.92189016450581 | 1.0 | ||
10 | 1 | 0 | male | [null] | 0 | 0 | 112379 | 39.6 | [null] | C | [null] | [null] | 1 | 3.67882911826043 | 1.0 | ||
11 | 1 | 0 | male | 45.0 | 0 | 0 | 113050 | 26.55 | B38 | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
12 | 1 | 0 | male | [null] | 0 | 0 | 113798 | 31.0 | [null] | S | [null] | [null] | 1 | 3.43398720448515 | 0.999999999999966 | ||
13 | 1 | 0 | male | 33.0 | 0 | 0 | 695 | 5.0 | B51 B53 B55 | S | [null] | [null] | 1 | 1.6094379124341 | 0.993262053000915 | ||
14 | 1 | 0 | male | 28.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | 1 | 3.85227300102237 | 1.0 | ||
15 | 1 | 0 | male | 17.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | 1 | 3.85227300102237 | 1.0 | ||
16 | 1 | 0 | male | 49.0 | 0 | 0 | 19924 | 26.0 | [null] | S | [null] | [null] | 1 | 3.25809653802148 | 0.999999999994891 | ||
17 | 1 | 0 | male | [null] | 0 | 0 | 112051 | 0.0 | [null] | S | [null] | [null] | 1 | -inf | 0.0 | ||
18 | 1 | 0 | male | [null] | 0 | 0 | 110465 | 52.0 | A14 | S | [null] | [null] | 1 | 3.95124371858143 | 1.0 | ||
19 | 1 | 0 | male | 47.0 | 0 | 0 | 5727 | 25.5875 | E58 | S | [null] | [null] | 1 | 3.24210395098741 | 0.999999999992282 | ||
20 | 1 | 0 | male | [null] | 0 | 0 | 113791 | 26.55 | [null] | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
21 | 1 | 0 | male | 39.0 | 0 | 0 | PC 17580 | 29.7 | A18 | C | [null] | 133 | 1 | 3.39114704580865 | 0.999999999999874 | ||
22 | 1 | 0 | female | 36.0 | 0 | 0 | PC 17531 | 31.6792 | A29 | C | [null] | [null] | 1 | 3.45566031410212 | 0.999999999999983 | ||
23 | 1 | 0 | male | [null] | 0 | 0 | PC 17483 | 221.7792 | C95 | S | [null] | [null] | 1 | 5.40168229234028 | 1.0 | ||
24 | 1 | 0 | male | 30.0 | 0 | 0 | 113051 | 27.75 | C111 | C | [null] | [null] | 1 | 3.32323584019244 | 0.999999999999112 | ||
25 | 1 | 0 | male | [null] | 0 | 0 | 113778 | 26.55 | D34 | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
26 | 1 | 0 | male | [null] | 0 | 0 | 112058 | 0.0 | B102 | S | [null] | [null] | 1 | -inf | 0.0 | ||
27 | 1 | 0 | male | 47.0 | 0 | 0 | 111320 | 38.5 | E63 | S | [null] | 275 | 1 | 3.65065824129374 | 1.0 | ||
28 | 1 | 0 | male | 24.0 | 0 | 0 | PC 17593 | 79.2 | B86 | C | [null] | [null] | 1 | 4.37197629882038 | 1.0 | ||
29 | 1 | 0 | male | 71.0 | 0 | 0 | PC 17754 | 34.6542 | A5 | C | [null] | [null] | 1 | 3.54541893041153 | 0.999999999999999 | ||
30 | 1 | 0 | male | 46.0 | 0 | 0 | PC 17593 | 79.2 | B82 B84 | C | [null] | [null] | 1 | 4.37197629882038 | 1.0 | ||
31 | 1 | 0 | male | [null] | 0 | 0 | 113796 | 42.4 | [null] | S | [null] | [null] | 1 | 3.74714836223791 | 1.0 | ||
32 | 1 | 0 | male | 40.0 | 0 | 0 | 112059 | 0.0 | B94 | S | [null] | 110 | 1 | -inf | 0.0 | ||
33 | 1 | 0 | male | 42.0 | 0 | 0 | 113038 | 42.5 | B11 | S | [null] | [null] | 1 | 3.74950407593037 | 1.0 | ||
34 | 1 | 0 | male | [null] | 0 | 0 | 17463 | 51.8625 | E46 | S | [null] | [null] | 1 | 3.94859598565899 | 1.0 | ||
35 | 1 | 0 | male | 55.0 | 0 | 0 | 680 | 50.0 | C39 | S | [null] | [null] | 1 | 3.91202300542815 | 1.0 | ||
36 | 1 | 0 | male | [null] | 0 | 0 | PC 17600 | 30.6958 | [null] | C | 14 | [null] | 1 | 3.42412583741652 | 0.999999999999953 | ||
37 | 1 | 0 | female | 50.0 | 0 | 0 | PC 17595 | 28.7125 | C49 | C | [null] | [null] | 1 | 3.35733256801522 | 0.999999999999661 | ||
38 | 1 | 0 | male | 46.0 | 0 | 0 | 694 | 26.0 | [null] | S | [null] | 80 | 1 | 3.25809653802148 | 0.999999999994891 | ||
39 | 1 | 0 | male | 50.0 | 0 | 0 | 113044 | 26.0 | E60 | S | [null] | [null] | 1 | 3.25809653802148 | 0.999999999994891 | ||
40 | 1 | 0 | male | 32.5 | 0 | 0 | 113503 | 211.5 | C132 | C | [null] | 45 | 1 | 5.35422499848633 | 1.0 | ||
41 | 1 | 0 | male | 58.0 | 0 | 0 | 11771 | 29.7 | B37 | C | [null] | 258 | 1 | 3.39114704580865 | 0.999999999999874 | ||
42 | 1 | 0 | male | [null] | 0 | 0 | 113028 | 26.55 | C124 | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
43 | 1 | 0 | male | [null] | 0 | 0 | PC 17612 | 27.7208 | [null] | C | [null] | [null] | 1 | 3.32218303393412 | 0.999999999999086 | ||
44 | 1 | 0 | male | 29.0 | 0 | 0 | 113501 | 30.0 | D6 | S | [null] | 126 | 1 | 3.40119738166216 | 0.999999999999906 | ||
45 | 1 | 0 | male | 30.0 | 0 | 0 | 113801 | 45.5 | [null] | S | [null] | [null] | 1 | 3.8177123259569 | 1.0 | ||
46 | 1 | 0 | male | 30.0 | 0 | 0 | 110469 | 26.0 | C106 | S | [null] | [null] | 1 | 3.25809653802148 | 0.999999999994891 | ||
47 | 1 | 0 | male | 46.0 | 0 | 0 | 13050 | 75.2417 | C6 | C | [null] | 292 | 1 | 4.32070559854228 | 1.0 | ||
48 | 1 | 0 | male | 54.0 | 0 | 0 | 17463 | 51.8625 | E46 | S | [null] | 175 | 1 | 3.94859598565899 | 1.0 | ||
49 | 1 | 0 | male | 65.0 | 0 | 0 | 13509 | 26.55 | E38 | S | [null] | 249 | 1 | 3.27902974768795 | 0.999999999997052 | ||
50 | 1 | 0 | male | 55.0 | 0 | 0 | 113787 | 30.5 | C30 | S | [null] | [null] | 1 | 3.41772668361337 | 0.999999999999943 | ||
51 | 1 | 0 | male | 47.0 | 0 | 0 | 113796 | 42.4 | [null] | S | [null] | [null] | 1 | 3.74714836223791 | 1.0 | ||
52 | 1 | 0 | male | 64.0 | 0 | 0 | 693 | 26.0 | [null] | S | [null] | 263 | 1 | 3.25809653802148 | 0.999999999994891 | ||
53 | 1 | 0 | male | 28.5 | 0 | 0 | PC 17562 | 27.7208 | D43 | C | [null] | 189 | 1 | 3.32218303393412 | 0.999999999999086 | ||
54 | 1 | 0 | male | [null] | 0 | 0 | 112052 | 0.0 | [null] | S | [null] | [null] | 1 | -inf | 0.0 | ||
55 | 1 | 0 | male | 45.5 | 0 | 0 | 113043 | 28.5 | C124 | S | [null] | 166 | 1 | 3.3499040872746 | 0.999999999999581 | ||
56 | 1 | 0 | male | 23.0 | 0 | 0 | 12749 | 93.5 | B24 | S | [null] | [null] | 1 | 4.53796143629464 | 1.0 | ||
57 | 1 | 0 | male | 47.0 | 0 | 0 | 110465 | 52.0 | C110 | S | [null] | 207 | 1 | 3.95124371858143 | 1.0 | ||
58 | 1 | 0 | male | 38.0 | 0 | 0 | 19972 | 0.0 | [null] | S | [null] | [null] | 1 | -inf | 0.0 | ||
59 | 1 | 0 | male | 22.0 | 0 | 0 | PC 17760 | 135.6333 | [null] | C | [null] | 232 | 1 | 4.90995492057888 | 1.0 | ||
60 | 1 | 0 | male | [null] | 0 | 0 | PC 17757 | 227.525 | [null] | C | [null] | [null] | 1 | 5.42726012246342 | 1.0 | ||
61 | 1 | 0 | male | 31.0 | 0 | 0 | PC 17590 | 50.4958 | A24 | S | [null] | [null] | 1 | 3.92189016450581 | 1.0 | ||
62 | 1 | 0 | male | [null] | 0 | 0 | 113767 | 50.0 | A32 | S | [null] | [null] | 1 | 3.91202300542815 | 1.0 | ||
63 | 1 | 0 | male | 36.0 | 0 | 0 | 13049 | 40.125 | A10 | C | [null] | [null] | 1 | 3.69199958145018 | 1.0 | ||
64 | 1 | 0 | male | 33.0 | 0 | 0 | 113790 | 26.55 | [null] | S | [null] | 109 | 1 | 3.27902974768795 | 0.999999999997052 | ||
65 | 1 | 0 | male | 56.0 | 0 | 0 | 113792 | 26.55 | [null] | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
66 | 1 | 0 | male | 56.0 | 0 | 0 | 17764 | 30.6958 | A7 | C | [null] | [null] | 1 | 3.42412583741652 | 0.999999999999953 | ||
67 | 1 | 0 | male | [null] | 0 | 0 | 113056 | 26.0 | A19 | S | [null] | [null] | 1 | 3.25809653802148 | 0.999999999994891 | ||
68 | 1 | 0 | male | 62.0 | 0 | 0 | 113514 | 26.55 | C87 | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
69 | 1 | 0 | male | [null] | 0 | 0 | PC 17605 | 27.7208 | [null] | C | [null] | [null] | 1 | 3.32218303393412 | 0.999999999999086 | ||
70 | 1 | 0 | male | 61.0 | 0 | 0 | 36963 | 32.3208 | D50 | S | [null] | 46 | 1 | 3.4757109858218 | 0.999999999999991 | ||
71 | 1 | 0 | male | 40.0 | 0 | 0 | PC 17601 | 27.7208 | [null] | C | [null] | [null] | 1 | 3.32218303393412 | 0.999999999999086 | ||
72 | 1 | 0 | male | 61.0 | 0 | 0 | 111240 | 33.5 | B19 | S | [null] | 245 | 1 | 3.51154543883102 | 0.999999999999997 | ||
73 | 1 | 0 | male | 47.0 | 0 | 0 | 36967 | 34.0208 | D46 | S | [null] | [null] | 1 | 3.5269721022703 | 0.999999999999998 | ||
74 | 1 | 0 | male | 60.0 | 0 | 0 | 113800 | 26.55 | [null] | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
75 | 1 | 0 | male | [null] | 0 | 0 | 113510 | 35.0 | C128 | S | [null] | [null] | 1 | 3.55534806148941 | 0.999999999999999 | ||
76 | 1 | 0 | male | 62.0 | 0 | 0 | 113807 | 26.55 | [null] | S | [null] | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
77 | 1 | 1 | female | 29.0 | 0 | 0 | 24160 | 211.3375 | B5 | S | 2 | [null] | 1 | 5.35345638166308 | 1.0 | ||
78 | 1 | 1 | male | 48.0 | 0 | 0 | 19952 | 26.55 | E12 | S | 3 | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
79 | 1 | 1 | female | 24.0 | 0 | 0 | PC 17477 | 69.3 | B35 | C | 9 | [null] | 1 | 4.23844490619586 | 1.0 | ||
80 | 1 | 1 | male | 80.0 | 0 | 0 | 27042 | 30.0 | A23 | S | B | [null] | 1 | 3.40119738166216 | 0.999999999999906 | ||
81 | 1 | 1 | female | 32.0 | 0 | 0 | 11813 | 76.2917 | D15 | C | 8 | [null] | 1 | 4.33456415124619 | 1.0 | ||
82 | 1 | 1 | male | 26.0 | 0 | 0 | 111369 | 30.0 | C148 | C | 5 | [null] | 1 | 3.40119738166216 | 0.999999999999906 | ||
83 | 1 | 1 | female | 42.0 | 0 | 0 | PC 17757 | 227.525 | [null] | C | 4 | [null] | 1 | 5.42726012246342 | 1.0 | ||
84 | 1 | 1 | female | 29.0 | 0 | 0 | PC 17483 | 221.7792 | C97 | S | 8 | [null] | 1 | 5.40168229234028 | 1.0 | ||
85 | 1 | 1 | female | 35.0 | 0 | 0 | PC 17760 | 135.6333 | C99 | S | 8 | [null] | 1 | 4.90995492057888 | 1.0 | ||
86 | 1 | 1 | male | 28.0 | 0 | 0 | 110564 | 26.55 | C52 | S | D | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
87 | 1 | 1 | male | 40.0 | 0 | 0 | 112277 | 31.0 | A31 | C | 7 | [null] | 1 | 3.43398720448515 | 0.999999999999966 | ||
88 | 1 | 1 | female | 30.0 | 0 | 0 | 36928 | 164.8667 | C7 | S | 8 | [null] | 1 | 5.10513726860277 | 1.0 | ||
89 | 1 | 1 | female | 58.0 | 0 | 0 | 113783 | 26.55 | C103 | S | 8 | [null] | 1 | 3.27902974768795 | 0.999999999997052 | ||
90 | 1 | 1 | female | 45.0 | 0 | 0 | PC 17608 | 262.375 | [null] | C | 4 | [null] | 1 | 5.5697747781408 | 1.0 | ||
91 | 1 | 1 | female | 44.0 | 0 | 0 | PC 17610 | 27.7208 | B4 | C | 6 | [null] | 1 | 3.32218303393412 | 0.999999999999086 | ||
92 | 1 | 1 | female | 60.0 | 0 | 0 | 11813 | 76.2917 | D15 | C | 8 | [null] | 1 | 4.33456415124619 | 1.0 | ||
93 | 1 | 1 | female | 41.0 | 0 | 0 | 16966 | 134.5 | E40 | C | 3 | [null] | 1 | 4.90156419904189 | 1.0 | ||
94 | 1 | 1 | male | 42.0 | 0 | 0 | PC 17476 | 26.2875 | E24 | S | 5 | [null] | 1 | 3.26909354102882 | 0.999999999996168 | ||
95 | 1 | 1 | female | 53.0 | 0 | 0 | PC 17606 | 27.4458 | [null] | C | 6 | [null] | 1 | 3.31221315078453 | 0.999999999998797 | ||
96 | 1 | 1 | female | [null] | 0 | 0 | 17770 | 27.7208 | [null] | C | 5 | [null] | 1 | 3.32218303393412 | 0.999999999999086 | ||
97 | 1 | 1 | female | 36.0 | 0 | 0 | PC 17608 | 262.375 | B61 | C | 4 | [null] | 1 | 5.5697747781408 | 1.0 | ||
98 | 1 | 1 | female | 30.0 | 0 | 0 | 110152 | 86.5 | B77 | S | 8 | [null] | 1 | 4.46014441393783 | 1.0 | ||
99 | 1 | 1 | male | 45.0 | 0 | 0 | PC 17594 | 29.7 | A9 | C | 7 | [null] | 1 | 3.39114704580865 | 0.999999999999874 | ||
100 | 1 | 1 | female | 22.0 | 0 | 0 | 113781 | 151.55 | [null] | S | 11 | [null] | 1 | 5.02091560350381 | 1.0 |
‘Pythonic’ Invokation of Vertica Functions#
You can easily apply Vertica functions to your vDataFrame. Here, we use Vertica’s COALESCE function to impute the ‘age’ of the passengers in our dataset.
[14]:
titanic["age"].count()
[14]:
997.0
[15]:
import verticapy.stats as st
titanic["age"] = st.coalesce(titanic["age"], titanic["age"].avg())
titanic["age"].count()
[15]:
1234.0
Slicing the vDataFrame#
You can now slice the vDataFrame with indexing operators.
[16]:
titanic[0:30]
[16]:
123 pclassInt | 123 survivedInt | Abc Varchar(164) | Abc sexVarchar(20) | 123 ageNumeric(16,13) | 123 sibspInt | 123 parchInt | Abc ticketVarchar(36) | 123 fareNumeric(10,5) | Abc cabinVarchar(30) | Abc embarkedVarchar(20) | Abc boatVarchar(100) | 123 bodyInt | Abc home.destVarchar(100) | 123 family_sizeInt | 123 ln_fareFloat | 123 xFloat | |
1 | 1 | 0 | female | 2.0 | 1 | 2 | 113781 | 151.55 | C22 C26 | S | [null] | [null] | Montreal, PQ / Chesterville, ON | 4 | 5.02091560350381 | 1.0 | |
2 | 1 | 0 | male | 30.0 | 1 | 2 | 113781 | 151.55 | C22 C26 | S | [null] | 135 | Montreal, PQ / Chesterville, ON | 4 | 5.02091560350381 | 1.0 | |
3 | 1 | 0 | female | 25.0 | 1 | 2 | 113781 | 151.55 | C22 C26 | S | [null] | [null] | Montreal, PQ / Chesterville, ON | 4 | 5.02091560350381 | 1.0 | |
4 | 1 | 0 | male | 39.0 | 0 | 0 | 112050 | 0.0 | A36 | S | [null] | [null] | Belfast, NI | 1 | -inf | 0.0 | |
5 | 1 | 0 | male | 71.0 | 0 | 0 | PC 17609 | 49.5042 | [null] | C | [null] | 22 | Montevideo, Uruguay | 1 | 3.90205751446006 | 1.0 | |
6 | 1 | 0 | male | 47.0 | 1 | 0 | PC 17757 | 227.525 | C62 C64 | C | [null] | 124 | New York, NY | 2 | 5.42726012246342 | 1.0 | |
7 | 1 | 0 | male | 30.1524573721163 | 0 | 0 | PC 17318 | 25.925 | [null] | S | [null] | [null] | New York, NY | 1 | 3.25520775411559 | 0.999999999994493 | |
8 | 1 | 0 | male | 24.0 | 0 | 1 | PC 17558 | 247.5208 | B58 B60 | C | [null] | [null] | Montreal, PQ | 2 | 5.51149461888159 | 1.0 | |
9 | 1 | 0 | male | 36.0 | 0 | 0 | 13050 | 75.2417 | C6 | C | A | [null] | Winnipeg, MN | 1 | 4.32070559854228 | 1.0 | |
10 | 1 | 0 | male | 25.0 | 0 | 0 | 13905 | 26.0 | [null] | C | [null] | 148 | San Francisco, CA | 1 | 3.25809653802148 | 0.999999999994891 | |
11 | 1 | 0 | male | 45.0 | 0 | 0 | 113784 | 35.5 | T | S | [null] | [null] | Trenton, NJ | 1 | 3.56953269648137 | 1.0 | |
12 | 1 | 0 | male | 42.0 | 0 | 0 | 110489 | 26.55 | D22 | S | [null] | [null] | London / Winnipeg, MB | 1 | 3.27902974768795 | 0.999999999997052 | |
13 | 1 | 0 | male | 41.0 | 0 | 0 | 113054 | 30.5 | A21 | S | [null] | [null] | Pomeroy, WA | 1 | 3.41772668361337 | 0.999999999999943 | |
14 | 1 | 0 | male | 48.0 | 0 | 0 | PC 17591 | 50.4958 | B10 | C | [null] | 208 | Omaha, NE | 1 | 3.92189016450581 | 1.0 | |
15 | 1 | 0 | male | 30.1524573721163 | 0 | 0 | 112379 | 39.6 | [null] | C | [null] | [null] | Philadelphia, PA | 1 | 3.67882911826043 | 1.0 | |
16 | 1 | 0 | male | 45.0 | 0 | 0 | 113050 | 26.55 | B38 | S | [null] | [null] | Washington, DC | 1 | 3.27902974768795 | 0.999999999997052 | |
17 | 1 | 0 | male | 30.1524573721163 | 0 | 0 | 113798 | 31.0 | [null] | S | [null] | [null] | [null] | 1 | 3.43398720448515 | 0.999999999999966 | |
18 | 1 | 0 | male | 33.0 | 0 | 0 | 695 | 5.0 | B51 B53 B55 | S | [null] | [null] | New York, NY | 1 | 1.6094379124341 | 0.993262053000915 | |
19 | 1 | 0 | male | 28.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | Montevideo, Uruguay | 1 | 3.85227300102237 | 1.0 | |
20 | 1 | 0 | male | 17.0 | 0 | 0 | 113059 | 47.1 | [null] | S | [null] | [null] | Montevideo, Uruguay | 1 | 3.85227300102237 | 1.0 | |
21 | 1 | 0 | male | 49.0 | 0 | 0 | 19924 | 26.0 | [null] | S | [null] | [null] | Ascot, Berkshire / Rochester, NY | 1 | 3.25809653802148 | 0.999999999994891 | |
22 | 1 | 0 | male | 36.0 | 1 | 0 | 19877 | 78.85 | C46 | S | [null] | 172 | Little Onn Hall, Staffs | 2 | 4.36754731340905 | 1.0 | |
23 | 1 | 0 | male | 46.0 | 1 | 0 | W.E.P. 5734 | 61.175 | E31 | S | [null] | [null] | Amenia, ND | 2 | 4.11373860932874 | 1.0 | |
24 | 1 | 0 | male | 30.1524573721163 | 0 | 0 | 112051 | 0.0 | [null] | S | [null] | [null] | Liverpool, England / Belfast | 1 | -inf | 0.0 | |
25 | 1 | 0 | male | 27.0 | 1 | 0 | 13508 | 136.7792 | C89 | C | [null] | [null] | Los Angeles, CA | 2 | 4.91836794684454 | 1.0 | |
26 | 1 | 0 | male | 30.1524573721163 | 0 | 0 | 110465 | 52.0 | A14 | S | [null] | [null] | Stoughton, MA | 1 | 3.95124371858143 | 1.0 | |
27 | 1 | 0 | male | 47.0 | 0 | 0 | 5727 | 25.5875 | E58 | S | [null] | [null] | Victoria, BC | 1 | 3.24210395098741 | 0.999999999992282 | |
28 | 1 | 0 | male | 37.0 | 1 | 1 | PC 17756 | 83.1583 | E52 | C | [null] | [null] | Lakewood, NJ | 3 | 4.42074602026042 | 1.0 | |
29 | 1 | 0 | male | 30.1524573721163 | 0 | 0 | 113791 | 26.55 | [null] | S | [null] | [null] | Roachdale, IN | 1 | 3.27902974768795 | 0.999999999997052 | |
30 | 1 | 0 | male | 70.0 | 1 | 1 | WE/P 5735 | 71.0 | B22 | S | [null] | 269 | Milwaukee, WI | 3 | 4.26267987704132 | 1.0 |
To access a single row, we just have to specify the index.
[17]:
titanic[0]
[17]:
[1,
0,
'Allison, Miss. Helen Loraine',
'female',
2.0,
1,
2,
'113781',
151.55,
'C22 C26',
'S',
None,
None,
'Montreal, PQ / Chesterville, ON',
4,
5.02091560350381,
1.0]