vastorbit.VastColumn.fillna

VastColumn.fillna(val: int | float | str | datetime | date = None, method: Literal['auto', 'mode', '0ifnull', 'mean', 'avg', 'median', 'ffill', 'pad', 'bfill', 'backfill'] = 'auto', expr: str | StringSQL = '', by: Annotated[str | list[str], 'STRING representing one column or a list of columns'] | None = None, order_by: Annotated[str | list[str], 'STRING representing one column or a list of columns'] | None = None) → VastFrame

Fills missing elements in the VastColumn with a user-specified rule.

Parameters:

• val (PythonScalar / date, optional) – Value used to impute the VastColumn.

• method (dict, optional) –

  Method used to impute the missing values.

  • auto:

    Mean for the numerical and Mode for the categorical VastColumns.

  • bfill:

    Back Propagation of the next element (Constant Interpolation).

  • ffill:

    Propagation of the first element (Constant Interpolation).

  • mean:

    Average.

  • median:

    Median.

  • mode:

    Mode (most occurent element).

  • 0ifnull:

    0 when the VastColumn is null, 1 otherwise.

• expr (str, optional) – SQL string.

• by (SQLColumns, optional) – VastColumns used in the partition.

• order_by (SQLColumns, optional) – List of the VastColumns used to sort the data when using TS methods.

Returns:

self._parent

Return type:

VastFrame

Examples

We import 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.

For this example, we will use the Titanic dataset.

from vastorbit.datasets import load_titanic
data = 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.

We can see the count of each column to check if any column has missing values.

data.count()

	count
"pclass"	1309.0
"survived"	1309.0
"name"	1309.0
"sex"	1309.0
"age"	1046.0
"sibsp"	1309.0
"parch"	1309.0
"ticket"	1309.0
"fare"	1308.0
"cabin"	295.0
"embarked"	1307.0
"boat"	486.0
"body"	121.0
"home.dest"	745.0

Rows: 1-14 | Columns: 2

From the above table, we can see that the count of boats is less than 1234. This suggests that it is missing some values.

Now we can use the fillna method to fill those values. Let’s use a custom function to fill these values.

data["age"].fillna(method = "avg", 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)	Abc boat Varchar(100)	123 body Integer	Abc home.dest Varchar(100)
1	1	1	Allison, Master. Hudson Trevor	male	0.92	1	2	113781	151.55	C22 C26	S	11	[null]	Montreal, PQ / Chesterville, ON
2	1	0	Allison, Mr. Hudson Joshua Creighton	male	30.0	1	2	113781	151.55	C22 C26	S	[null]	135	Montreal, PQ / Chesterville, ON
3	1	1	Anderson, Mr. Harry	male	48.0	0	0	19952	26.55	E12	S	3	[null]	New York, NY
4	1	0	Andrews, Mr. Thomas Jr	male	39.0	0	0	112050	0.0	A36	S	[null]	[null]	Belfast, NI
5	1	0	Artagaveytia, Mr. Ramon	male	71.0	0	0	PC 17609	49.5042	[null]	C	[null]	22	Montevideo, Uruguay
6	1	0	Astor, Col. John Jacob	male	47.0	1	0	PC 17757	227.525	C62 C64	C	[null]	124	New York, NY
7	1	1	Barkworth, Mr. Algernon Henry Wilson	male	80.0	0	0	27042	30.0	A23	S	B	[null]	Hessle, Yorks
8	1	0	Baumann, Mr. John D	male	41.02927152317881	0	0	PC 17318	25.925	[null]	S	[null]	[null]	New York, NY
9	1	0	Baxter, Mr. Quigg Edmond	male	24.0	0	1	PC 17558	247.5208	B58 B60	C	[null]	[null]	Montreal, PQ
10	1	0	Beattie, Mr. Thomson	male	36.0	0	0	13050	75.2417	C6	C	A	[null]	Winnipeg, MN
11	1	1	Beckwith, Mr. Richard Leonard	male	37.0	1	1	11751	52.5542	D35	S	5	[null]	New York, NY
12	1	1	Behr, Mr. Karl Howell	male	26.0	0	0	111369	30.0	C148	C	5	[null]	New York, NY
13	1	0	Birnbaum, Mr. Jakob	male	25.0	0	0	13905	26.0	[null]	C	[null]	148	San Francisco, CA
14	1	1	Bishop, Mr. Dickinson H	male	25.0	1	0	11967	91.0792	B49	C	7	[null]	Dowagiac, MI
15	1	1	Bjornstrom-Steffansson, Mr. Mauritz Hakan	male	28.0	0	0	110564	26.55	C52	S	D	[null]	Stockholm, Sweden / Washington, DC
16	1	0	Blackwell, Mr. Stephen Weart	male	45.0	0	0	113784	35.5	T	S	[null]	[null]	Trenton, NJ
17	1	1	Blank, Mr. Henry	male	40.0	0	0	112277	31.0	A31	C	7	[null]	Glen Ridge, NJ
18	1	0	Borebank, Mr. John James	male	42.0	0	0	110489	26.55	D22	S	[null]	[null]	London / Winnipeg, MB
19	1	1	Bradley, Mr. George ("George Arthur Brayton")	male	41.02927152317881	0	0	111427	26.55	[null]	S	9	[null]	Los Angeles, CA
20	1	0	Brady, Mr. John Bertram	male	41.0	0	0	113054	30.5	A21	S	[null]	[null]	Pomeroy, WA
21	1	0	Brandeis, Mr. Emil	male	48.0	0	0	PC 17591	50.4958	B10	C	[null]	208	Omaha, NE
22	1	0	Brewe, Dr. Arthur Jackson	male	41.02927152317881	0	0	112379	39.6	[null]	C	[null]	[null]	Philadelphia, PA
23	1	0	Butt, Major. Archibald Willingham	male	45.0	0	0	113050	26.55	B38	S	[null]	[null]	Washington, DC
24	1	0	Cairns, Mr. Alexander	male	41.02927152317881	0	0	113798	31.0	[null]	S	[null]	[null]	[null]
25	1	1	Calderhead, Mr. Edward Pennington	male	42.0	0	0	PC 17476	26.2875	E24	S	5	[null]	New York, NY
26	1	1	Cardeza, Mr. Thomas Drake Martinez	male	36.0	0	1	PC 17755	512.3292	B51 B53 B55	C	3	[null]	Austria-Hungary / Germantown, Philadelphia, PA
27	1	0	Carlsson, Mr. Frans Olof	male	33.0	0	0	695	5.0	B51 B53 B55	S	[null]	[null]	New York, NY
28	1	0	Carrau, Mr. Francisco M	male	28.0	0	0	113059	47.1	[null]	S	[null]	[null]	Montevideo, Uruguay
29	1	0	Carrau, Mr. Jose Pedro	male	17.0	0	0	113059	47.1	[null]	S	[null]	[null]	Montevideo, Uruguay
30	1	1	Carter, Master. William Thornton II	male	11.0	1	2	113760	120.0	B96 B98	S	4	[null]	Bryn Mawr, PA
31	1	1	Carter, Mr. William Ernest	male	36.0	1	2	113760	120.0	B96 B98	S	C	[null]	Bryn Mawr, PA
32	1	0	Case, Mr. Howard Brown	male	49.0	0	0	19924	26.0	[null]	S	[null]	[null]	Ascot, Berkshire / Rochester, NY
33	1	0	Cavendish, Mr. Tyrell William	male	36.0	1	0	19877	78.85	C46	S	[null]	172	Little Onn Hall, Staffs
34	1	0	Chaffee, Mr. Herbert Fuller	male	46.0	1	0	W.E.P. 5734	61.175	E31	S	[null]	[null]	Amenia, ND
35	1	1	Chambers, Mr. Norman Campbell	male	27.0	1	0	113806	53.1	E8	S	5	[null]	New York, NY / Ithaca, NY
36	1	1	Chevre, Mr. Paul Romaine	male	45.0	0	0	PC 17594	29.7	A9	C	7	[null]	Paris, France
37	1	0	Chisholm, Mr. Roderick Robert Crispin	male	41.02927152317881	0	0	112051	0.0	[null]	S	[null]	[null]	Liverpool, England / Belfast
38	1	0	Clark, Mr. Walter Miller	male	27.0	1	0	13508	136.7792	C89	C	[null]	[null]	Los Angeles, CA
39	1	0	Clifford, Mr. George Quincy	male	41.02927152317881	0	0	110465	52.0	A14	S	[null]	[null]	Stoughton, MA
40	1	0	Colley, Mr. Edward Pomeroy	male	47.0	0	0	5727	25.5875	E58	S	[null]	[null]	Victoria, BC
41	1	0	Compton, Mr. Alexander Taylor Jr	male	37.0	1	1	PC 17756	83.1583	E52	C	[null]	[null]	Lakewood, NJ
42	1	0	Crafton, Mr. John Bertram	male	41.02927152317881	0	0	113791	26.55	[null]	S	[null]	[null]	Roachdale, IN
43	1	0	Crosby, Capt. Edward Gifford	male	70.0	1	1	WE/P 5735	71.0	B22	S	[null]	269	Milwaukee, WI
44	1	0	Cumings, Mr. John Bradley	male	39.0	1	0	PC 17599	71.2833	C85	C	[null]	[null]	New York, NY
45	1	1	Daly, Mr. Peter Denis	male	51.0	0	0	113055	26.55	E17	S	5 9	[null]	Lima, Peru
46	1	1	Daniel, Mr. Robert Williams	male	27.0	0	0	113804	30.5	[null]	S	3	[null]	Philadelphia, PA
47	1	0	Davidson, Mr. Thornton	male	31.0	1	0	F.C. 12750	52.0	B71	S	[null]	[null]	Montreal, PQ
48	1	1	Dick, Mr. Albert Adrian	male	31.0	1	0	17474	57.0	B20	S	3	[null]	Calgary, AB
49	1	1	Dodge, Dr. Washington	male	53.0	1	1	33638	81.8583	A34	S	13	[null]	San Francisco, CA
50	1	1	Dodge, Master. Washington	male	4.0	0	2	33638	81.8583	A34	S	5	[null]	San Francisco, CA
51	1	0	Douglas, Mr. Walter Donald	male	50.0	1	0	PC 17761	106.425	C86	C	[null]	62	Deephaven, MN / Cedar Rapids, IA
52	1	1	Duff Gordon, Sir. Cosmo Edmund ("Mr Morgan")	male	49.0	1	0	PC 17485	56.9292	A20	C	1	[null]	London / Paris
53	1	0	Dulles, Mr. William Crothers	male	39.0	0	0	PC 17580	29.7	A18	C	[null]	133	Philadelphia, PA
54	1	0	Farthing, Mr. John	male	41.02927152317881	0	0	PC 17483	221.7792	C95	S	[null]	[null]	[null]
55	1	1	Flynn, Mr. John Irwin ("Irving")	male	36.0	0	0	PC 17474	26.3875	E25	S	5	[null]	Brooklyn, NY
56	1	0	Foreman, Mr. Benjamin Laventall	male	30.0	0	0	113051	27.75	C111	C	[null]	[null]	New York, NY
57	1	0	Fortune, Mr. Charles Alexander	male	19.0	3	2	19950	263.0	C23 C25 C27	S	[null]	[null]	Winnipeg, MB
58	1	0	Fortune, Mr. Mark	male	64.0	1	4	19950	263.0	C23 C25 C27	S	[null]	[null]	Winnipeg, MB
59	1	0	Franklin, Mr. Thomas Parham	male	41.02927152317881	0	0	113778	26.55	D34	S	[null]	[null]	Westcliff-on-Sea, Essex
60	1	1	Frauenthal, Dr. Henry William	male	50.0	2	0	PC 17611	133.65	[null]	S	5	[null]	New York, NY
61	1	1	Frauenthal, Mr. Isaac Gerald	male	43.0	1	0	17765	27.7208	D40	C	5	[null]	New York, NY
62	1	1	Frolicher-Stehli, Mr. Maxmillian	male	60.0	1	1	13567	79.2	B41	C	5	[null]	Zurich, Switzerland
63	1	0	Fry, Mr. Richard	male	41.02927152317881	0	0	112058	0.0	B102	S	[null]	[null]	[null]
64	1	0	Futrelle, Mr. Jacques Heath	male	37.0	1	0	113803	53.1	C123	S	[null]	[null]	Scituate, MA
65	1	0	Gee, Mr. Arthur H	male	47.0	0	0	111320	38.5	E63	S	[null]	275	St Anne's-on-Sea, Lancashire
66	1	0	Giglio, Mr. Victor	male	24.0	0	0	PC 17593	79.2	B86	C	[null]	[null]	[null]
67	1	1	Goldenberg, Mr. Samuel L	male	49.0	1	0	17453	89.1042	C92	C	5	[null]	Paris, France / New York, NY
68	1	0	Goldschmidt, Mr. George B	male	71.0	0	0	PC 17754	34.6542	A5	C	[null]	[null]	New York, NY
69	1	1	Gracie, Col. Archibald IV	male	53.0	0	0	113780	28.5	C51	C	B	[null]	Washington, DC
70	1	0	Graham, Mr. George Edward	male	38.0	0	1	PC 17582	153.4625	C91	S	[null]	147	Winnipeg, MB
71	1	1	Greenfield, Mr. William Bertram	male	23.0	0	1	PC 17759	63.3583	D10 D12	C	7	[null]	New York, NY
72	1	0	Guggenheim, Mr. Benjamin	male	46.0	0	0	PC 17593	79.2	B82 B84	C	[null]	[null]	New York, NY
73	1	1	Harder, Mr. George Achilles	male	25.0	1	0	11765	55.4417	E50	C	5	[null]	Brooklyn, NY
74	1	1	Harper, Mr. Henry Sleeper	male	48.0	1	0	PC 17572	76.7292	D33	C	3	[null]	New York, NY
75	1	0	Harrington, Mr. Charles H	male	41.02927152317881	0	0	113796	42.4	[null]	S	[null]	[null]	[null]
76	1	0	Harris, Mr. Henry Birkhardt	male	45.0	1	0	36973	83.475	C83	S	[null]	[null]	New York, NY
77	1	0	Harrison, Mr. William	male	40.0	0	0	112059	0.0	B94	S	[null]	110	[null]
78	1	1	Hassab, Mr. Hammad	male	27.0	0	0	PC 17572	76.7292	D49	C	3	[null]	[null]
79	1	1	Hawksford, Mr. Walter James	male	41.02927152317881	0	0	16988	30.0	D45	S	3	[null]	Kingston, Surrey
80	1	0	Hays, Mr. Charles Melville	male	55.0	1	1	12749	93.5	B69	S	[null]	307	Montreal, PQ
81	1	0	Head, Mr. Christopher	male	42.0	0	0	113038	42.5	B11	S	[null]	[null]	London / Middlesex
82	1	0	Hilliard, Mr. Herbert Henry	male	41.02927152317881	0	0	17463	51.8625	E46	S	[null]	[null]	Brighton, MA
83	1	0	Hipkins, Mr. William Edward	male	55.0	0	0	680	50.0	C39	S	[null]	[null]	London / Birmingham
84	1	0	Holverson, Mr. Alexander Oskar	male	42.0	1	0	113789	52.0	[null]	S	[null]	38	New York, NY
85	1	1	Homer, Mr. Harry ("Mr E Haven")	male	35.0	0	0	111426	26.55	[null]	C	15	[null]	Indianapolis, IN
86	1	1	Hoyt, Mr. Frederick Maxfield	male	38.0	1	0	19943	90.0	C93	S	D	[null]	New York, NY / Stamford CT
87	1	0	Hoyt, Mr. William Fisher	male	41.02927152317881	0	0	PC 17600	30.6958	[null]	C	14	[null]	New York, NY
88	1	1	Ismay, Mr. Joseph Bruce	male	49.0	0	0	112058	0.0	B52 B54 B56	S	C	[null]	Liverpool
89	1	0	Jones, Mr. Charles Cresson	male	46.0	0	0	694	26.0	[null]	S	[null]	80	Bennington, VT
90	1	0	Julian, Mr. Henry Forbes	male	50.0	0	0	113044	26.0	E60	S	[null]	[null]	London
91	1	0	Keeping, Mr. Edwin	male	32.5	0	0	113503	211.5	C132	C	[null]	45	[null]
92	1	0	Kent, Mr. Edward Austin	male	58.0	0	0	11771	29.7	B37	C	[null]	258	Buffalo, NY
93	1	0	Kenyon, Mr. Frederick R	male	41.0	1	0	17464	51.8625	D21	S	[null]	[null]	Southington / Noank, CT
94	1	1	Kimball, Mr. Edwin Nelson Jr	male	42.0	1	0	11753	52.5542	D19	S	5	[null]	Boston, MA
95	1	0	Klaber, Mr. Herman	male	41.02927152317881	0	0	113028	26.55	C124	S	[null]	[null]	Portland, OR
96	1	1	Lesurer, Mr. Gustave J	male	35.0	0	0	PC 17755	512.3292	B101	C	3	[null]	[null]
97	1	0	Lewy, Mr. Ervin G	male	41.02927152317881	0	0	PC 17612	27.7208	[null]	C	[null]	[null]	Chicago, IL
98	1	0	Lindeberg-Lind, Mr. Erik Gustaf ("Mr Edward Lingrey")	male	42.0	0	0	17475	26.55	[null]	S	[null]	[null]	Stockholm, Sweden
99	1	0	Long, Mr. Milton Clyde	male	29.0	0	0	113501	30.0	D6	S	[null]	126	Springfield, MA
100	1	0	Loring, Mr. Joseph Holland	male	30.0	0	0	113801	45.5	[null]	S	[null]	[null]	London / New York, NY

Rows: 1-100 of 1309 | Columns: 14

See also

VastFrame.interpolate() : Fill missing values by interpolating.

VastColumn.fill_outliers() : Fill the outliers using the input method.