vastorbit.VastFrame.apply

VastFrame.apply(func: dict) → VastFrame

Applies each function of the dictionary to the input VastColumns.

Parameters:

func (dict) – Dictionary of functions. The dictionary must be in the following format: {column1: func1, …, columnk: funck}. Each function variable must be composed of two flower brackets {}. For example, to apply the function x -> x^2 + 2, use “POWER({}, 2) + 2”.

Returns:

self

Return type:

VastFrame

Examples

Let’s begin by importing vastorbit.

import vastorbit as vo

Hint

By assigning an alias to vastorbit, we mitigate the risk of code collisions with other libraries. This precaution is necessary because vastorbit uses commonly known function names like “average” and “median”, which can potentially lead to naming conflicts. The use of an alias ensures that the functions from vastorbit are used as intended without interfering with functions from other libraries.

Let us work with the Titanic dataset:

from vastorbit.datasets import load_titanic

vdf = load_titanic()

	123 pclass Integer	123 survived Integer	Abc name Varchar(164)	Abc sex Varchar(20)	123 age Double	123 sibsp Integer	123 parch Integer	Abc ticket Varchar(36)	123 fare Double	Abc cabin Varchar(30)	Abc embarked Varchar(20)	Abc boat Varchar(100)	123 body Integer	Abc home.dest Varchar(100)
1	3	1	McCormack, Mr. Thomas Joseph	male	[null]	0	0	367228	7.75	[null]	Q	[null]	[null]	[null]
2	3	1	McCoy, Miss. Agnes	female	[null]	2	0	367226	23.25	[null]	Q	16	[null]	[null]
3	3	1	McCoy, Miss. Alicia	female	[null]	2	0	367226	23.25	[null]	Q	16	[null]	[null]
4	3	1	McCoy, Mr. Bernard	male	[null]	2	0	367226	23.25	[null]	Q	16	[null]	[null]
5	3	1	McDermott, Miss. Brigdet Delia	female	[null]	0	0	330932	7.7875	[null]	Q	13	[null]	[null]
6	3	0	McEvoy, Mr. Michael	male	[null]	0	0	36568	15.5	[null]	Q	[null]	[null]	[null]
7	3	1	McGovern, Miss. Mary	female	[null]	0	0	330931	7.8792	[null]	Q	13	[null]	[null]
8	3	1	McGowan, Miss. Anna "Annie"	female	15.0	0	0	330923	8.0292	[null]	Q	[null]	[null]	[null]
9	3	0	McGowan, Miss. Katherine	female	35.0	0	0	9232	7.75	[null]	Q	[null]	[null]	[null]
10	3	0	McMahon, Mr. Martin	male	[null]	0	0	370372	7.75	[null]	Q	[null]	[null]	[null]
11	3	0	McNamee, Mr. Neal	male	24.0	1	0	376566	16.1	[null]	S	[null]	[null]	[null]
12	3	0	McNamee, Mrs. Neal (Eileen O'Leary)	female	19.0	1	0	376566	16.1	[null]	S	[null]	53	[null]
13	3	0	McNeill, Miss. Bridget	female	[null]	0	0	370368	7.75	[null]	Q	[null]	[null]	[null]
14	3	0	Meanwell, Miss. (Marion Ogden)	female	[null]	0	0	SOTON/O.Q. 392087	8.05	[null]	S	[null]	[null]	[null]
15	3	0	Meek, Mrs. Thomas (Annie Louise Rowley)	female	[null]	0	0	343095	8.05	[null]	S	[null]	[null]	[null]
16	3	0	Meo, Mr. Alfonzo	male	55.5	0	0	A.5. 11206	8.05	[null]	S	[null]	201	[null]
17	3	0	Mernagh, Mr. Robert	male	[null]	0	0	368703	7.75	[null]	Q	[null]	[null]	[null]
18	3	1	Midtsjo, Mr. Karl Albert	male	21.0	0	0	345501	7.775	[null]	S	15	[null]	[null]
19	3	0	Miles, Mr. Frank	male	[null]	0	0	359306	8.05	[null]	S	[null]	[null]	[null]
20	3	0	Mineff, Mr. Ivan	male	24.0	0	0	349233	7.8958	[null]	S	[null]	[null]	[null]
21	3	0	Minkoff, Mr. Lazar	male	21.0	0	0	349211	7.8958	[null]	S	[null]	[null]	[null]
22	3	0	Mionoff, Mr. Stoytcho	male	28.0	0	0	349207	7.8958	[null]	S	[null]	[null]	[null]
23	3	0	Mitkoff, Mr. Mito	male	[null]	0	0	349221	7.8958	[null]	S	[null]	[null]	[null]
24	3	1	Mockler, Miss. Helen Mary "Ellie"	female	[null]	0	0	330980	7.8792	[null]	Q	16	[null]	[null]
25	3	0	Moen, Mr. Sigurd Hansen	male	25.0	0	0	348123	7.65	F G73	S	[null]	309	[null]
26	3	1	Moor, Master. Meier	male	6.0	0	1	392096	12.475	E121	S	14	[null]	[null]
27	3	1	Moor, Mrs. (Beila)	female	27.0	0	1	392096	12.475	E121	S	14	[null]	[null]
28	3	0	Moore, Mr. Leonard Charles	male	[null]	0	0	A4. 54510	8.05	[null]	S	[null]	[null]	[null]
29	3	1	Moran, Miss. Bertha	female	[null]	1	0	371110	24.15	[null]	Q	16	[null]	[null]
30	3	0	Moran, Mr. Daniel J	male	[null]	1	0	371110	24.15	[null]	Q	[null]	[null]	[null]
31	3	0	Moran, Mr. James	male	[null]	0	0	330877	8.4583	[null]	Q	[null]	[null]	[null]
32	3	0	Morley, Mr. William	male	34.0	0	0	364506	8.05	[null]	S	[null]	[null]	[null]
33	3	0	Morrow, Mr. Thomas Rowan	male	[null]	0	0	372622	7.75	[null]	Q	[null]	[null]	[null]
34	3	1	Moss, Mr. Albert Johan	male	[null]	0	0	312991	7.775	[null]	S	B	[null]	[null]
35	3	1	Moubarek, Master. Gerios	male	[null]	1	1	2661	15.2458	[null]	C	C	[null]	[null]
36	3	1	Moubarek, Master. Halim Gonios ("William George")	male	[null]	1	1	2661	15.2458	[null]	C	C	[null]	[null]
37	3	1	Moubarek, Mrs. George (Omine "Amenia" Alexander)	female	[null]	0	2	2661	15.2458	[null]	C	C	[null]	[null]
38	3	1	Moussa, Mrs. (Mantoura Boulos)	female	[null]	0	0	2626	7.2292	[null]	C	[null]	[null]	[null]
39	3	0	Moutal, Mr. Rahamin Haim	male	[null]	0	0	374746	8.05	[null]	S	[null]	[null]	[null]
40	3	1	Mullens, Miss. Katherine "Katie"	female	[null]	0	0	35852	7.7333	[null]	Q	16	[null]	[null]
41	3	1	Mulvihill, Miss. Bertha E	female	24.0	0	0	382653	7.75	[null]	Q	15	[null]	[null]
42	3	0	Murdlin, Mr. Joseph	male	[null]	0	0	A./5. 3235	8.05	[null]	S	[null]	[null]	[null]
43	3	1	Murphy, Miss. Katherine "Kate"	female	[null]	1	0	367230	15.5	[null]	Q	16	[null]	[null]
44	3	1	Murphy, Miss. Margaret Jane	female	[null]	1	0	367230	15.5	[null]	Q	16	[null]	[null]
45	3	1	Murphy, Miss. Nora	female	[null]	0	0	36568	15.5	[null]	Q	16	[null]	[null]
46	3	0	Myhrman, Mr. Pehr Fabian Oliver Malkolm	male	18.0	0	0	347078	7.75	[null]	S	[null]	[null]	[null]
47	3	0	Naidenoff, Mr. Penko	male	22.0	0	0	349206	7.8958	[null]	S	[null]	[null]	[null]
48	3	1	Najib, Miss. Adele Kiamie "Jane"	female	15.0	0	0	2667	7.225	[null]	C	C	[null]	[null]
49	3	1	Nakid, Miss. Maria ("Mary")	female	1.0	0	2	2653	15.7417	[null]	C	C	[null]	[null]
50	3	1	Nakid, Mr. Sahid	male	20.0	1	1	2653	15.7417	[null]	C	C	[null]	[null]
51	3	1	Nakid, Mrs. Said (Waika "Mary" Mowad)	female	19.0	1	1	2653	15.7417	[null]	C	C	[null]	[null]
52	3	0	Nancarrow, Mr. William Henry	male	33.0	0	0	A./5. 3338	8.05	[null]	S	[null]	[null]	[null]
53	3	0	Nankoff, Mr. Minko	male	[null]	0	0	349218	7.8958	[null]	S	[null]	[null]	[null]
54	3	0	Nasr, Mr. Mustafa	male	[null]	0	0	2652	7.2292	[null]	C	[null]	[null]	[null]
55	3	0	Naughton, Miss. Hannah	female	[null]	0	0	365237	7.75	[null]	Q	[null]	[null]	[null]
56	3	0	Nenkoff, Mr. Christo	male	[null]	0	0	349234	7.8958	[null]	S	[null]	[null]	[null]
57	3	1	Nicola-Yarred, Master. Elias	male	12.0	1	0	2651	11.2417	[null]	C	C	[null]	[null]
58	3	1	Nicola-Yarred, Miss. Jamila	female	14.0	1	0	2651	11.2417	[null]	C	C	[null]	[null]
59	3	0	Nieminen, Miss. Manta Josefina	female	29.0	0	0	3101297	7.925	[null]	S	[null]	[null]	[null]
60	3	0	Niklasson, Mr. Samuel	male	28.0	0	0	363611	8.05	[null]	S	[null]	[null]	[null]
61	3	1	Nilsson, Miss. Berta Olivia	female	18.0	0	0	347066	7.775	[null]	S	D	[null]	[null]
62	3	1	Nilsson, Miss. Helmina Josefina	female	26.0	0	0	347470	7.8542	[null]	S	13	[null]	[null]
63	3	0	Nilsson, Mr. August Ferdinand	male	21.0	0	0	350410	7.8542	[null]	S	[null]	[null]	[null]
64	3	0	Nirva, Mr. Iisakki Antino Aijo	male	41.0	0	0	SOTON/O2 3101272	7.125	[null]	S	[null]	[null]	Finland Sudbury, ON
65	3	1	Niskanen, Mr. Juha	male	39.0	0	0	STON/O 2. 3101289	7.925	[null]	S	9	[null]	[null]
66	3	0	Nosworthy, Mr. Richard Cater	male	21.0	0	0	A/4. 39886	7.8	[null]	S	[null]	[null]	[null]
67	3	0	Novel, Mr. Mansouer	male	28.5	0	0	2697	7.2292	[null]	C	[null]	181	[null]
68	3	1	Nysten, Miss. Anna Sofia	female	22.0	0	0	347081	7.75	[null]	S	13	[null]	[null]
69	3	0	Nysveen, Mr. Johan Hansen	male	61.0	0	0	345364	6.2375	[null]	S	[null]	[null]	[null]
70	3	0	O'Brien, Mr. Thomas	male	[null]	1	0	370365	15.5	[null]	Q	[null]	[null]	[null]
71	3	0	O'Brien, Mr. Timothy	male	[null]	0	0	330979	7.8292	[null]	Q	[null]	[null]	[null]
72	3	1	O'Brien, Mrs. Thomas (Johanna "Hannah" Godfrey)	female	[null]	1	0	370365	15.5	[null]	Q	[null]	[null]	[null]
73	3	0	O'Connell, Mr. Patrick D	male	[null]	0	0	334912	7.7333	[null]	Q	[null]	[null]	[null]
74	3	0	O'Connor, Mr. Maurice	male	[null]	0	0	371060	7.75	[null]	Q	[null]	[null]	[null]
75	3	0	O'Connor, Mr. Patrick	male	[null]	0	0	366713	7.75	[null]	Q	[null]	[null]	[null]
76	3	0	Odahl, Mr. Nils Martin	male	23.0	0	0	7267	9.225	[null]	S	[null]	[null]	[null]
77	3	0	O'Donoghue, Ms. Bridget	female	[null]	0	0	364856	7.75	[null]	Q	[null]	[null]	[null]
78	3	1	O'Driscoll, Miss. Bridget	female	[null]	0	0	14311	7.75	[null]	Q	D	[null]	[null]
79	3	1	O'Dwyer, Miss. Ellen "Nellie"	female	[null]	0	0	330959	7.8792	[null]	Q	[null]	[null]	[null]
80	3	1	Ohman, Miss. Velin	female	22.0	0	0	347085	7.775	[null]	S	C	[null]	[null]
81	3	1	O'Keefe, Mr. Patrick	male	[null]	0	0	368402	7.75	[null]	Q	B	[null]	[null]
82	3	1	O'Leary, Miss. Hanora "Norah"	female	[null]	0	0	330919	7.8292	[null]	Q	13	[null]	[null]
83	3	1	Olsen, Master. Artur Karl	male	9.0	0	1	C 17368	3.1708	[null]	S	13	[null]	[null]
84	3	0	Olsen, Mr. Henry Margido	male	28.0	0	0	C 4001	22.525	[null]	S	[null]	173	[null]
85	3	0	Olsen, Mr. Karl Siegwart Andreas	male	42.0	0	1	4579	8.4042	[null]	S	[null]	[null]	[null]
86	3	0	Olsen, Mr. Ole Martin	male	[null]	0	0	Fa 265302	7.3125	[null]	S	[null]	[null]	[null]
87	3	0	Olsson, Miss. Elina	female	31.0	0	0	350407	7.8542	[null]	S	[null]	[null]	[null]
88	3	0	Olsson, Mr. Nils Johan Goransson	male	28.0	0	0	347464	7.8542	[null]	S	[null]	[null]	[null]
89	3	1	Olsson, Mr. Oscar Wilhelm	male	32.0	0	0	347079	7.775	[null]	S	A	[null]	[null]
90	3	0	Olsvigen, Mr. Thor Anderson	male	20.0	0	0	6563	9.225	[null]	S	[null]	89	Oslo, Norway Cameron, WI
91	3	0	Oreskovic, Miss. Jelka	female	23.0	0	0	315085	8.6625	[null]	S	[null]	[null]	[null]
92	3	0	Oreskovic, Miss. Marija	female	20.0	0	0	315096	8.6625	[null]	S	[null]	[null]	[null]
93	3	0	Oreskovic, Mr. Luka	male	20.0	0	0	315094	8.6625	[null]	S	[null]	[null]	[null]
94	3	0	Osen, Mr. Olaf Elon	male	16.0	0	0	7534	9.2167	[null]	S	[null]	[null]	[null]
95	3	1	Osman, Mrs. Mara	female	31.0	0	0	349244	8.6833	[null]	S	[null]	[null]	[null]
96	3	0	O'Sullivan, Miss. Bridget Mary	female	[null]	0	0	330909	7.6292	[null]	Q	[null]	[null]	[null]
97	3	0	Palsson, Master. Gosta Leonard	male	2.0	3	1	349909	21.075	[null]	S	[null]	4	[null]
98	3	0	Palsson, Master. Paul Folke	male	6.0	3	1	349909	21.075	[null]	S	[null]	[null]	[null]
99	3	0	Palsson, Miss. Stina Viola	female	3.0	3	1	349909	21.075	[null]	S	[null]	[null]	[null]
100	3	0	Palsson, Miss. Torborg Danira	female	8.0	3	1	349909	21.075	[null]	S	[null]	[null]	[null]

Rows: 1-100 | Columns: 14

Note

vastorbit offers a wide range of sample datasets that are ideal for training and testing purposes. You can explore the full list of available datasets in the Datasets, which provides detailed information on each dataset and how to use them effectively. These datasets are invaluable resources for honing your data analysis and machine learning skills within the vastorbit environment.

Now let us apply two functions on the two different columns.

• “boat”

• “age”

For the “boat” column, we will encode it to a binary form which makes it easier to process in certain ML algorithms.

For the “age” column, we will fill in the missing values based on the columns “pclass” and “sex”.

vdf.apply(func = {
        "boat": "CASE {} WHEN NULL THEN 0 ELSE 1 END",
        "age" : "COALESCE(age, AVG({}) OVER (PARTITION BY pclass, sex))",
    }
)

	123 pclass Integer	123 survived Integer	Abc name Varchar(164)	Abc sex Varchar(20)	123 age Double	123 sibsp Integer	123 parch Integer	Abc ticket Varchar(36)	123 fare Double	Abc cabin Varchar(30)	Abc embarked Varchar(20)	123 boat Integer	123 body Integer	Abc home.dest Varchar(100)
1	1	1	Allen, Miss. Elisabeth Walton	female	29.0	0	0	24160	211.3375	B5	S	1	[null]	St Louis, MO
2	1	0	Allison, Miss. Helen Loraine	female	2.0	1	2	113781	151.55	C22 C26	S	1	[null]	Montreal, PQ / Chesterville, ON
3	1	0	Allison, Mrs. Hudson J C (Bessie Waldo Daniels)	female	25.0	1	2	113781	151.55	C22 C26	S	1	[null]	Montreal, PQ / Chesterville, ON
4	1	1	Andrews, Miss. Kornelia Theodosia	female	63.0	1	0	13502	77.9583	D7	S	1	[null]	Hudson, NY
5	1	1	Appleton, Mrs. Edward Dale (Charlotte Lamson)	female	53.0	2	0	11769	51.4792	C101	S	1	[null]	Bayside, Queens, NY
6	1	1	Astor, Mrs. John Jacob (Madeleine Talmadge Force)	female	18.0	1	0	PC 17757	227.525	C62 C64	C	1	[null]	New York, NY
7	1	1	Aubart, Mme. Leontine Pauline	female	24.0	0	0	PC 17477	69.3	B35	C	1	[null]	Paris, France
8	1	1	Barber, Miss. Ellen "Nellie"	female	26.0	0	0	19877	78.85	[null]	S	1	[null]	[null]
9	1	1	Baxter, Mrs. James (Helene DeLaudeniere Chaput)	female	50.0	0	1	PC 17558	247.5208	B58 B60	C	1	[null]	Montreal, PQ
10	1	1	Bazzani, Miss. Albina	female	32.0	0	0	11813	76.2917	D15	C	1	[null]	[null]
11	1	1	Beckwith, Mrs. Richard Leonard (Sallie Monypeny)	female	47.0	1	1	11751	52.5542	D35	S	1	[null]	New York, NY
12	1	1	Bidois, Miss. Rosalie	female	42.0	0	0	PC 17757	227.525	[null]	C	1	[null]	[null]
13	1	1	Bird, Miss. Ellen	female	29.0	0	0	PC 17483	221.7792	C97	S	1	[null]	[null]
14	1	1	Bishop, Mrs. Dickinson H (Helen Walton)	female	19.0	1	0	11967	91.0792	B49	C	1	[null]	Dowagiac, MI
15	1	1	Bissette, Miss. Amelia	female	35.0	0	0	PC 17760	135.6333	C99	S	1	[null]	[null]
16	1	1	Bonnell, Miss. Caroline	female	30.0	0	0	36928	164.8667	C7	S	1	[null]	Youngstown, OH
17	1	1	Bonnell, Miss. Elizabeth	female	58.0	0	0	113783	26.55	C103	S	1	[null]	Birkdale, England Cleveland, Ohio
18	1	1	Bowen, Miss. Grace Scott	female	45.0	0	0	PC 17608	262.375	[null]	C	1	[null]	Cooperstown, NY
19	1	1	Bowerman, Miss. Elsie Edith	female	22.0	0	1	113505	55.0	E33	S	1	[null]	St Leonards-on-Sea, England Ohio
20	1	1	Brown, Mrs. James Joseph (Margaret Tobin)	female	44.0	0	0	PC 17610	27.7208	B4	C	1	[null]	Denver, CO
21	1	1	Brown, Mrs. John Murray (Caroline Lane Lamson)	female	59.0	2	0	11769	51.4792	C101	S	1	[null]	Belmont, MA
22	1	1	Bucknell, Mrs. William Robert (Emma Eliza Ward)	female	60.0	0	0	11813	76.2917	D15	C	1	[null]	Philadelphia, PA
23	1	1	Burns, Miss. Elizabeth Margaret	female	41.0	0	0	16966	134.5	E40	C	1	[null]	[null]
24	1	1	Candee, Mrs. Edward (Helen Churchill Hungerford)	female	53.0	0	0	PC 17606	27.4458	[null]	C	1	[null]	Washington, DC
25	1	1	Cardeza, Mrs. James Warburton Martinez (Charlotte Wardle Drake)	female	58.0	0	1	PC 17755	512.3292	B51 B53 B55	C	1	[null]	Germantown, Philadelphia, PA
26	1	1	Carter, Miss. Lucile Polk	female	14.0	1	2	113760	120.0	B96 B98	S	1	[null]	Bryn Mawr, PA
27	1	1	Carter, Mrs. William Ernest (Lucile Polk)	female	36.0	1	2	113760	120.0	B96 B98	S	1	[null]	Bryn Mawr, PA
28	1	1	Cassebeer, Mrs. Henry Arthur Jr (Eleanor Genevieve Fosdick)	female	37.037593984962406	0	0	17770	27.7208	[null]	C	1	[null]	New York, NY
29	1	1	Cavendish, Mrs. Tyrell William (Julia Florence Siegel)	female	76.0	1	0	19877	78.85	C46	S	1	[null]	Little Onn Hall, Staffs
30	1	1	Chaffee, Mrs. Herbert Fuller (Carrie Constance Toogood)	female	47.0	1	0	W.E.P. 5734	61.175	E31	S	1	[null]	Amenia, ND
31	1	1	Chambers, Mrs. Norman Campbell (Bertha Griggs)	female	33.0	1	0	113806	53.1	E8	S	1	[null]	New York, NY / Ithaca, NY
32	1	1	Chaudanson, Miss. Victorine	female	36.0	0	0	PC 17608	262.375	B61	C	1	[null]	[null]
33	1	1	Cherry, Miss. Gladys	female	30.0	0	0	110152	86.5	B77	S	1	[null]	London, England
34	1	1	Chibnall, Mrs. (Edith Martha Bowerman)	female	37.037593984962406	0	1	113505	55.0	E33	S	1	[null]	St Leonards-on-Sea, England Ohio
35	1	1	Clark, Mrs. Walter Miller (Virginia McDowell)	female	26.0	1	0	13508	136.7792	C89	C	1	[null]	Los Angeles, CA
36	1	1	Cleaver, Miss. Alice	female	22.0	0	0	113781	151.55	[null]	S	1	[null]	[null]
37	1	1	Compton, Miss. Sara Rebecca	female	39.0	1	1	PC 17756	83.1583	E49	C	1	[null]	Lakewood, NJ
38	1	1	Compton, Mrs. Alexander Taylor (Mary Eliza Ingersoll)	female	64.0	0	2	PC 17756	83.1583	E45	C	1	[null]	Lakewood, NJ
39	1	1	Cornell, Mrs. Robert Clifford (Malvina Helen Lamson)	female	55.0	2	0	11770	25.7	C101	S	1	[null]	New York, NY
40	1	1	Crosby, Miss. Harriet R	female	36.0	0	2	WE/P 5735	71.0	B22	S	1	[null]	Milwaukee, WI
41	1	1	Crosby, Mrs. Edward Gifford (Catherine Elizabeth Halstead)	female	64.0	1	1	112901	26.55	B26	S	1	[null]	Milwaukee, WI
42	1	1	Cumings, Mrs. John Bradley (Florence Briggs Thayer)	female	38.0	1	0	PC 17599	71.2833	C85	C	1	[null]	New York, NY
43	1	1	Daniels, Miss. Sarah	female	33.0	0	0	113781	151.55	[null]	S	1	[null]	[null]
44	1	1	Davidson, Mrs. Thornton (Orian Hays)	female	27.0	1	2	F.C. 12750	52.0	B71	S	1	[null]	Montreal, PQ
45	1	1	Dick, Mrs. Albert Adrian (Vera Gillespie)	female	17.0	1	0	17474	57.0	B20	S	1	[null]	Calgary, AB
46	1	1	Dodge, Mrs. Washington (Ruth Vidaver)	female	54.0	1	1	33638	81.8583	A34	S	1	[null]	San Francisco, CA
47	1	1	Douglas, Mrs. Frederick Charles (Mary Helene Baxter)	female	27.0	1	1	PC 17558	247.5208	B58 B60	C	1	[null]	Montreal, PQ
48	1	1	Douglas, Mrs. Walter Donald (Mahala Dutton)	female	48.0	1	0	PC 17761	106.425	C86	C	1	[null]	Deephaven, MN / Cedar Rapids, IA
49	1	1	Duff Gordon, Lady. (Lucille Christiana Sutherland) ("Mrs Morgan")	female	48.0	1	0	11755	39.6	A16	C	1	[null]	London / Paris
50	1	1	Earnshaw, Mrs. Boulton (Olive Potter)	female	23.0	0	1	11767	83.1583	C54	C	1	[null]	Mt Airy, Philadelphia, PA
51	1	1	Endres, Miss. Caroline Louise	female	38.0	0	0	PC 17757	227.525	C45	C	1	[null]	New York, NY
52	1	1	Eustis, Miss. Elizabeth Mussey	female	54.0	1	0	36947	78.2667	D20	C	1	[null]	Brookline, MA
53	1	0	Evans, Miss. Edith Corse	female	36.0	0	0	PC 17531	31.6792	A29	C	1	[null]	New York, NY
54	1	1	Flegenheim, Mrs. Alfred (Antoinette)	female	37.037593984962406	0	0	PC 17598	31.6833	[null]	S	1	[null]	New York, NY
55	1	1	Fleming, Miss. Margaret	female	37.037593984962406	0	0	17421	110.8833	[null]	C	1	[null]	[null]
56	1	1	Fortune, Miss. Alice Elizabeth	female	24.0	3	2	19950	263.0	C23 C25 C27	S	1	[null]	Winnipeg, MB
57	1	1	Fortune, Miss. Ethel Flora	female	28.0	3	2	19950	263.0	C23 C25 C27	S	1	[null]	Winnipeg, MB
58	1	1	Fortune, Miss. Mabel Helen	female	23.0	3	2	19950	263.0	C23 C25 C27	S	1	[null]	Winnipeg, MB
59	1	1	Fortune, Mrs. Mark (Mary McDougald)	female	60.0	1	4	19950	263.0	C23 C25 C27	S	1	[null]	Winnipeg, MB
60	1	1	Francatelli, Miss. Laura Mabel	female	30.0	0	0	PC 17485	56.9292	E36	C	1	[null]	[null]
61	1	1	Frauenthal, Mrs. Henry William (Clara Heinsheimer)	female	37.037593984962406	1	0	PC 17611	133.65	[null]	S	1	[null]	New York, NY
62	1	1	Frolicher, Miss. Hedwig Margaritha	female	22.0	0	2	13568	49.5	B39	C	1	[null]	Zurich, Switzerland
63	1	1	Frolicher-Stehli, Mrs. Maxmillian (Margaretha Emerentia Stehli)	female	48.0	1	1	13567	79.2	B41	C	1	[null]	Zurich, Switzerland
64	1	1	Futrelle, Mrs. Jacques Heath (Lily May Peel)	female	35.0	1	0	113803	53.1	C123	S	1	[null]	Scituate, MA
65	1	1	Geiger, Miss. Amalie	female	35.0	0	0	113503	211.5	C130	C	1	[null]	[null]
66	1	1	Gibson, Miss. Dorothy Winifred	female	22.0	0	1	112378	59.4	[null]	C	1	[null]	New York, NY
67	1	1	Gibson, Mrs. Leonard (Pauline C Boeson)	female	45.0	0	1	112378	59.4	[null]	C	1	[null]	New York, NY
68	1	1	Goldenberg, Mrs. Samuel L (Edwiga Grabowska)	female	37.037593984962406	1	0	17453	89.1042	C92	C	1	[null]	Paris, France / New York, NY
69	1	1	Graham, Miss. Margaret Edith	female	19.0	0	0	112053	30.0	B42	S	1	[null]	Greenwich, CT
70	1	1	Graham, Mrs. William Thompson (Edith Junkins)	female	58.0	0	1	PC 17582	153.4625	C125	S	1	[null]	Greenwich, CT
71	1	1	Greenfield, Mrs. Leo David (Blanche Strouse)	female	45.0	0	1	PC 17759	63.3583	D10 D12	C	1	[null]	New York, NY
72	1	1	Harder, Mrs. George Achilles (Dorothy Annan)	female	25.0	1	0	11765	55.4417	E50	C	1	[null]	Brooklyn, NY
73	1	1	Harper, Mrs. Henry Sleeper (Myna Haxtun)	female	49.0	1	0	PC 17572	76.7292	D33	C	1	[null]	New York, NY
74	1	1	Harris, Mrs. Henry Birkhardt (Irene Wallach)	female	35.0	1	0	36973	83.475	C83	S	1	[null]	New York, NY
75	1	1	Hays, Miss. Margaret Bechstein	female	24.0	0	0	11767	83.1583	C54	C	1	[null]	New York, NY
76	1	1	Hays, Mrs. Charles Melville (Clara Jennings Gregg)	female	52.0	1	1	12749	93.5	B69	S	1	[null]	Montreal, PQ
77	1	1	Hippach, Miss. Jean Gertrude	female	16.0	0	1	111361	57.9792	B18	C	1	[null]	Chicago, IL
78	1	1	Hippach, Mrs. Louis Albert (Ida Sophia Fischer)	female	44.0	0	1	111361	57.9792	B18	C	1	[null]	Chicago, IL
79	1	1	Hogeboom, Mrs. John C (Anna Andrews)	female	51.0	1	0	13502	77.9583	D11	S	1	[null]	Hudson, NY
80	1	1	Holverson, Mrs. Alexander Oskar (Mary Aline Towner)	female	35.0	1	0	113789	52.0	[null]	S	1	[null]	New York, NY
81	1	1	Hoyt, Mrs. Frederick Maxfield (Jane Anne Forby)	female	35.0	1	0	19943	90.0	C93	S	1	[null]	New York, NY / Stamford CT
82	1	1	Icard, Miss. Amelie	female	38.0	0	0	113572	80.0	B28	[null]	1	[null]	[null]
83	1	0	Isham, Miss. Ann Elizabeth	female	50.0	0	0	PC 17595	28.7125	C49	C	1	[null]	Paris, France New York, NY
84	1	1	Kenyon, Mrs. Frederick R (Marion)	female	37.037593984962406	1	0	17464	51.8625	D21	S	1	[null]	Southington / Noank, CT
85	1	1	Kimball, Mrs. Edwin Nelson Jr (Gertrude Parsons)	female	45.0	1	0	11753	52.5542	D19	S	1	[null]	Boston, MA
86	1	1	Kreuchen, Miss. Emilie	female	39.0	0	0	24160	211.3375	[null]	S	1	[null]	[null]
87	1	1	Leader, Dr. Alice (Farnham)	female	49.0	0	0	17465	25.9292	D17	S	1	[null]	New York, NY
88	1	1	LeRoy, Miss. Bertha	female	30.0	0	0	PC 17761	106.425	[null]	C	1	[null]	[null]
89	1	1	Lindstrom, Mrs. Carl Johan (Sigrid Posse)	female	55.0	0	0	112377	27.7208	[null]	C	1	[null]	Stockholm, Sweden
90	1	1	Lines, Miss. Mary Conover	female	16.0	0	1	PC 17592	39.4	D28	S	1	[null]	Paris, France
91	1	1	Lines, Mrs. Ernest H (Elizabeth Lindsey James)	female	51.0	0	1	PC 17592	39.4	D28	S	1	[null]	Paris, France
92	1	1	Longley, Miss. Gretchen Fiske	female	21.0	0	0	13502	77.9583	D9	S	1	[null]	Hudson, NY
93	1	1	Lurette, Miss. Elise	female	58.0	0	0	PC 17569	146.5208	B80	C	1	[null]	[null]
94	1	1	Madill, Miss. Georgette Alexandra	female	15.0	0	1	24160	211.3375	B5	S	1	[null]	St Louis, MO
95	1	1	Maioni, Miss. Roberta	female	16.0	0	0	110152	86.5	B79	S	1	[null]	[null]
96	1	1	Marvin, Mrs. Daniel Warner (Mary Graham Carmichael Farquarson)	female	18.0	1	0	113773	53.1	D30	S	1	[null]	New York, NY
97	1	1	Mayne, Mlle. Berthe Antonine ("Mrs de Villiers")	female	24.0	0	0	PC 17482	49.5042	C90	C	1	[null]	Belgium Montreal, PQ
98	1	1	Meyer, Mrs. Edgar Joseph (Leila Saks)	female	37.037593984962406	1	0	PC 17604	82.1708	[null]	C	1	[null]	New York, NY
99	1	1	Minahan, Miss. Daisy E	female	33.0	1	0	19928	90.0	C78	Q	1	[null]	Green Bay, WI
100	1	1	Minahan, Mrs. William Edward (Lillian E Thorpe)	female	37.0	1	0	19928	90.0	C78	Q	1	[null]	Fond du Lac, WI

Rows: 1-100 | Columns: 14

Note

Applying a function will alter the VastColumn structure. It’s advisable to check the current relation of the VastFrame to ensure it aligns with the intended outcome. For more information on achieving that, check out the current_relation documentation.

See also

VastFrame.analytic() : Advanced Analytical functions.

VastFrame.applymap() : Apply functions to all columns.