vastorbit.VastColumn.dropna

VastColumn.dropna() → VastFrame

Filters the VastFrame where the VastColumn is missing.

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

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

In the above dataset, notice that the first and last entries are identical i.e. duplicates.

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.

vdf.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 there are a lot of missing values in “boat” column.

Using dropna, we can filter the entire dataset to drop the rows where “boats” does not have a value:

vdf["boat"].dropna()

	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	McCoy, Miss. Agnes	female	[null]	2	0	367226	23.25	[null]	Q	16	[null]	[null]
2	3	1	McCoy, Miss. Alicia	female	[null]	2	0	367226	23.25	[null]	Q	16	[null]	[null]
3	3	1	McCoy, Mr. Bernard	male	[null]	2	0	367226	23.25	[null]	Q	16	[null]	[null]
4	3	1	McDermott, Miss. Brigdet Delia	female	[null]	0	0	330932	7.7875	[null]	Q	13	[null]	[null]
5	3	1	McGovern, Miss. Mary	female	[null]	0	0	330931	7.8792	[null]	Q	13	[null]	[null]
6	3	1	Midtsjo, Mr. Karl Albert	male	21.0	0	0	345501	7.775	[null]	S	15	[null]	[null]
7	3	1	Mockler, Miss. Helen Mary "Ellie"	female	[null]	0	0	330980	7.8792	[null]	Q	16	[null]	[null]
8	3	1	Moor, Master. Meier	male	6.0	0	1	392096	12.475	E121	S	14	[null]	[null]
9	3	1	Moor, Mrs. (Beila)	female	27.0	0	1	392096	12.475	E121	S	14	[null]	[null]
10	3	1	Moran, Miss. Bertha	female	[null]	1	0	371110	24.15	[null]	Q	16	[null]	[null]
11	3	1	Moss, Mr. Albert Johan	male	[null]	0	0	312991	7.775	[null]	S	B	[null]	[null]
12	3	1	Moubarek, Master. Gerios	male	[null]	1	1	2661	15.2458	[null]	C	C	[null]	[null]
13	3	1	Moubarek, Master. Halim Gonios ("William George")	male	[null]	1	1	2661	15.2458	[null]	C	C	[null]	[null]
14	3	1	Moubarek, Mrs. George (Omine "Amenia" Alexander)	female	[null]	0	2	2661	15.2458	[null]	C	C	[null]	[null]
15	3	1	Mullens, Miss. Katherine "Katie"	female	[null]	0	0	35852	7.7333	[null]	Q	16	[null]	[null]
16	3	1	Mulvihill, Miss. Bertha E	female	24.0	0	0	382653	7.75	[null]	Q	15	[null]	[null]
17	3	1	Murphy, Miss. Katherine "Kate"	female	[null]	1	0	367230	15.5	[null]	Q	16	[null]	[null]
18	3	1	Murphy, Miss. Margaret Jane	female	[null]	1	0	367230	15.5	[null]	Q	16	[null]	[null]
19	3	1	Murphy, Miss. Nora	female	[null]	0	0	36568	15.5	[null]	Q	16	[null]	[null]
20	3	1	Najib, Miss. Adele Kiamie "Jane"	female	15.0	0	0	2667	7.225	[null]	C	C	[null]	[null]
21	3	1	Nakid, Miss. Maria ("Mary")	female	1.0	0	2	2653	15.7417	[null]	C	C	[null]	[null]
22	3	1	Nakid, Mr. Sahid	male	20.0	1	1	2653	15.7417	[null]	C	C	[null]	[null]
23	3	1	Nakid, Mrs. Said (Waika "Mary" Mowad)	female	19.0	1	1	2653	15.7417	[null]	C	C	[null]	[null]
24	3	1	Nicola-Yarred, Master. Elias	male	12.0	1	0	2651	11.2417	[null]	C	C	[null]	[null]
25	3	1	Nicola-Yarred, Miss. Jamila	female	14.0	1	0	2651	11.2417	[null]	C	C	[null]	[null]
26	3	1	Nilsson, Miss. Berta Olivia	female	18.0	0	0	347066	7.775	[null]	S	D	[null]	[null]
27	3	1	Nilsson, Miss. Helmina Josefina	female	26.0	0	0	347470	7.8542	[null]	S	13	[null]	[null]
28	3	1	Niskanen, Mr. Juha	male	39.0	0	0	STON/O 2. 3101289	7.925	[null]	S	9	[null]	[null]
29	3	1	Nysten, Miss. Anna Sofia	female	22.0	0	0	347081	7.75	[null]	S	13	[null]	[null]
30	3	1	O'Driscoll, Miss. Bridget	female	[null]	0	0	14311	7.75	[null]	Q	D	[null]	[null]
31	3	1	Ohman, Miss. Velin	female	22.0	0	0	347085	7.775	[null]	S	C	[null]	[null]
32	3	1	O'Keefe, Mr. Patrick	male	[null]	0	0	368402	7.75	[null]	Q	B	[null]	[null]
33	3	1	O'Leary, Miss. Hanora "Norah"	female	[null]	0	0	330919	7.8292	[null]	Q	13	[null]	[null]
34	3	1	Olsen, Master. Artur Karl	male	9.0	0	1	C 17368	3.1708	[null]	S	13	[null]	[null]
35	3	1	Olsson, Mr. Oscar Wilhelm	male	32.0	0	0	347079	7.775	[null]	S	A	[null]	[null]
36	3	1	Persson, Mr. Ernst Ulrik	male	25.0	1	0	347083	7.775	[null]	S	15	[null]	[null]
37	3	1	Peter, Master. Michael J	male	[null]	1	1	2668	22.3583	[null]	C	C	[null]	[null]
38	3	1	Peter, Miss. Anna	female	[null]	1	1	2668	22.3583	F E69	C	D	[null]	[null]
39	3	1	Peter, Mrs. Catherine (Catherine Rizk)	female	[null]	0	2	2668	22.3583	[null]	C	D	[null]	[null]
40	3	1	Pickard, Mr. Berk (Berk Trembisky)	male	32.0	0	0	SOTON/O.Q. 392078	8.05	E10	S	9	[null]	[null]
41	3	1	Riordan, Miss. Johanna "Hannah"	female	[null]	0	0	334915	7.7208	[null]	Q	13	[null]	[null]
42	3	1	Roth, Miss. Sarah A	female	[null]	0	0	342712	8.05	[null]	S	C	[null]	[null]
43	3	1	Ryan, Mr. Edward	male	[null]	0	0	383162	7.75	[null]	Q	14	[null]	[null]
44	3	1	Salkjelsvik, Miss. Anna Kristine	female	21.0	0	0	343120	7.65	[null]	S	C	[null]	[null]
45	3	1	Sandstrom, Miss. Beatrice Irene	female	1.0	1	1	PP 9549	16.7	G6	S	13	[null]	[null]
46	3	1	Sandstrom, Mrs. Hjalmar (Agnes Charlotta Bengtsson)	female	24.0	0	2	PP 9549	16.7	G6	S	13	[null]	[null]
47	3	1	Sandstrom, Miss. Marguerite Rut	female	4.0	1	1	PP 9549	16.7	G6	S	13	[null]	[null]
48	3	1	Sap, Mr. Julius	male	25.0	0	0	345768	9.5	[null]	S	11	[null]	[null]
49	3	1	Sheerlinck, Mr. Jan Baptist	male	29.0	0	0	345779	9.5	[null]	S	11	[null]	[null]
50	3	1	Sjoblom, Miss. Anna Sofia	female	18.0	0	0	3101265	7.4958	[null]	S	16	[null]	[null]
51	3	1	Smyth, Miss. Julia	female	[null]	0	0	335432	7.7333	[null]	Q	13	[null]	[null]
52	3	1	Stanley, Miss. Amy Zillah Elsie	female	23.0	0	0	CA. 2314	7.55	[null]	S	C	[null]	[null]
53	3	1	Stranden, Mr. Juho	male	31.0	0	0	STON/O 2. 3101288	7.925	[null]	S	9	[null]	[null]
54	3	1	Sunderland, Mr. Victor Francis	male	16.0	0	0	SOTON/OQ 392089	8.05	[null]	S	B	[null]	[null]
55	3	1	Sundman, Mr. Johan Julian	male	44.0	0	0	STON/O 2. 3101269	7.925	[null]	S	15	[null]	[null]
56	3	1	Svensson, Mr. Johan Cervin	male	14.0	0	0	7538	9.225	[null]	S	13	[null]	[null]
57	3	1	Tenglin, Mr. Gunnar Isidor	male	25.0	0	0	350033	7.7958	[null]	S	13 15	[null]	[null]
58	3	1	Thomas, Master. Assad Alexander	male	0.42	0	1	2625	8.5167	[null]	C	16	[null]	[null]
59	3	1	Thomas, Mrs. Alexander (Thamine "Thelma")	female	16.0	1	1	2625	8.5167	[null]	C	14	[null]	[null]
60	3	1	Thorneycroft, Mrs. Percival (Florence Kate White)	female	[null]	1	0	376564	16.1	[null]	S	10	[null]	[null]
61	3	1	Tornquist, Mr. William Henry	male	25.0	0	0	LINE	0.0	[null]	S	15	[null]	[null]
62	3	1	Touma, Master. Georges Youssef	male	7.0	1	1	2650	15.2458	[null]	C	C	[null]	[null]
63	3	1	Touma, Miss. Maria Youssef	female	9.0	1	1	2650	15.2458	[null]	C	C	[null]	[null]
64	3	1	Touma, Mrs. Darwis (Hanne Youssef Razi)	female	29.0	0	2	2650	15.2458	[null]	C	C	[null]	[null]
65	3	1	Turja, Miss. Anna Sofia	female	18.0	0	0	4138	9.8417	[null]	S	15	[null]	[null]
66	3	1	Turkula, Mrs. (Hedwig)	female	63.0	0	0	4134	9.5875	[null]	S	15	[null]	[null]
67	3	1	Vartanian, Mr. David	male	22.0	0	0	2658	7.225	[null]	C	13 15	[null]	[null]
68	3	1	Whabee, Mrs. George Joseph (Shawneene Abi-Saab)	female	38.0	0	0	2688	7.2292	[null]	C	C	[null]	[null]
69	3	0	Yasbeck, Mr. Antoni	male	27.0	1	0	2659	14.4542	[null]	C	C	[null]	[null]
70	1	1	Allen, Miss. Elisabeth Walton	female	29.0	0	0	24160	211.3375	B5	S	2	[null]	St Louis, MO
71	1	1	Allison, Master. Hudson Trevor	male	0.92	1	2	113781	151.55	C22 C26	S	11	[null]	Montreal, PQ / Chesterville, ON
72	1	1	Anderson, Mr. Harry	male	48.0	0	0	19952	26.55	E12	S	3	[null]	New York, NY
73	1	1	Andrews, Miss. Kornelia Theodosia	female	63.0	1	0	13502	77.9583	D7	S	10	[null]	Hudson, NY
74	1	1	Appleton, Mrs. Edward Dale (Charlotte Lamson)	female	53.0	2	0	11769	51.4792	C101	S	D	[null]	Bayside, Queens, NY
75	1	1	Astor, Mrs. John Jacob (Madeleine Talmadge Force)	female	18.0	1	0	PC 17757	227.525	C62 C64	C	4	[null]	New York, NY
76	1	1	Aubart, Mme. Leontine Pauline	female	24.0	0	0	PC 17477	69.3	B35	C	9	[null]	Paris, France
77	1	1	Barber, Miss. Ellen "Nellie"	female	26.0	0	0	19877	78.85	[null]	S	6	[null]	[null]
78	1	1	Barkworth, Mr. Algernon Henry Wilson	male	80.0	0	0	27042	30.0	A23	S	B	[null]	Hessle, Yorks
79	1	1	Baxter, Mrs. James (Helene DeLaudeniere Chaput)	female	50.0	0	1	PC 17558	247.5208	B58 B60	C	6	[null]	Montreal, PQ
80	1	1	Bazzani, Miss. Albina	female	32.0	0	0	11813	76.2917	D15	C	8	[null]	[null]
81	1	0	Beattie, Mr. Thomson	male	36.0	0	0	13050	75.2417	C6	C	A	[null]	Winnipeg, MN
82	1	1	Beckwith, Mr. Richard Leonard	male	37.0	1	1	11751	52.5542	D35	S	5	[null]	New York, NY
83	1	1	Beckwith, Mrs. Richard Leonard (Sallie Monypeny)	female	47.0	1	1	11751	52.5542	D35	S	5	[null]	New York, NY
84	1	1	Behr, Mr. Karl Howell	male	26.0	0	0	111369	30.0	C148	C	5	[null]	New York, NY
85	1	1	Bidois, Miss. Rosalie	female	42.0	0	0	PC 17757	227.525	[null]	C	4	[null]	[null]
86	1	1	Bird, Miss. Ellen	female	29.0	0	0	PC 17483	221.7792	C97	S	8	[null]	[null]
87	1	1	Bishop, Mr. Dickinson H	male	25.0	1	0	11967	91.0792	B49	C	7	[null]	Dowagiac, MI
88	1	1	Bishop, Mrs. Dickinson H (Helen Walton)	female	19.0	1	0	11967	91.0792	B49	C	7	[null]	Dowagiac, MI
89	1	1	Bissette, Miss. Amelia	female	35.0	0	0	PC 17760	135.6333	C99	S	8	[null]	[null]
90	1	1	Bjornstrom-Steffansson, Mr. Mauritz Hakan	male	28.0	0	0	110564	26.55	C52	S	D	[null]	Stockholm, Sweden / Washington, DC
91	1	1	Blank, Mr. Henry	male	40.0	0	0	112277	31.0	A31	C	7	[null]	Glen Ridge, NJ
92	1	1	Bonnell, Miss. Caroline	female	30.0	0	0	36928	164.8667	C7	S	8	[null]	Youngstown, OH
93	1	1	Bonnell, Miss. Elizabeth	female	58.0	0	0	113783	26.55	C103	S	8	[null]	Birkdale, England Cleveland, Ohio
94	1	1	Bowen, Miss. Grace Scott	female	45.0	0	0	PC 17608	262.375	[null]	C	4	[null]	Cooperstown, NY
95	1	1	Bowerman, Miss. Elsie Edith	female	22.0	0	1	113505	55.0	E33	S	6	[null]	St Leonards-on-Sea, England Ohio
96	1	1	Bradley, Mr. George ("George Arthur Brayton")	male	[null]	0	0	111427	26.55	[null]	S	9	[null]	Los Angeles, CA
97	1	1	Brown, Mrs. James Joseph (Margaret Tobin)	female	44.0	0	0	PC 17610	27.7208	B4	C	6	[null]	Denver, CO
98	1	1	Brown, Mrs. John Murray (Caroline Lane Lamson)	female	59.0	2	0	11769	51.4792	C101	S	D	[null]	Belmont, MA
99	1	1	Bucknell, Mrs. William Robert (Emma Eliza Ward)	female	60.0	0	0	11813	76.2917	D15	C	8	[null]	Philadelphia, PA
100	1	1	Burns, Miss. Elizabeth Margaret	female	41.0	0	0	16966	134.5	E40	C	3	[null]	[null]

Rows: 1-100 of 486 | Columns: 14

Now again, if we look at the count, we will notice that the total count has decreased based on the “boats” column.

vdf.count()

	count
"pclass"	486.0
"survived"	486.0
"name"	486.0
"sex"	486.0
"age"	417.0
"sibsp"	486.0
"parch"	486.0
"ticket"	486.0
"fare"	486.0
"cabin"	193.0
"embarked"	484.0
"boat"	486.0
"body"	0.0
"home.dest"	341.0

Rows: 1-14 | Columns: 2

See also

VastFrame.dropna() : Drops the VastFrame missing values.

VastFrame.drop() : Drops the VastFrame input columns.