vDataFrame.sample

In [ ]:
vDataFrame.sample(n = None, 
                  x = None, 
                  method: str = "random", 
                  by: list = [])

Downsamples the input vDataFrame.

⚠ Warning: The result might change for each SQL code generation if the data are not ordered.

Parameters

Name Type Optional Description
n
int
✓
Approximate number of element to consider in the sample.
x
float
✓
The sample size. For example it has to be equal to 0.33 to downsample to approximatively 33% of the relation.
method
str
✓
The Sample method.
  • random : random sampling.
  • systematic : systematic sampling.
  • stratified : stratified sampling.
by
list
✓
vcolumns used in the partition.

Returns

vDataFrame : sample vDataFrame

Example

In [3]:
from verticapy.datasets import load_titanic
titanic = load_titanic()
display(titanic)
123
pclass
Int
123
survived
Int
Abc
Varchar(164)
Abc
sex
Varchar(20)
123
age
Numeric(6,3)
123
sibsp
Int
123
parch
Int
Abc
ticket
Varchar(36)
123
fare
Numeric(10,5)
Abc
cabin
Varchar(30)
Abc
embarked
Varchar(20)
Abc
boat
Varchar(100)
123
body
Int
Abc
home.dest
Varchar(100)
110female2.012113781151.55C22 C26S[null][null]Montreal, PQ / Chesterville, ON
210male30.012113781151.55C22 C26S[null]135Montreal, PQ / Chesterville, ON
310female25.012113781151.55C22 C26S[null][null]Montreal, PQ / Chesterville, ON
410male39.0001120500.0A36S[null][null]Belfast, NI
510male71.000PC 1760949.5042[null]C[null]22Montevideo, Uruguay
610male47.010PC 17757227.525C62 C64C[null]124New York, NY
710male[null]00PC 1731825.925[null]S[null][null]New York, NY
810male24.001PC 17558247.5208B58 B60C[null][null]Montreal, PQ
910male36.0001305075.2417C6CA[null]Winnipeg, MN
1010male25.0001390526.0[null]C[null]148San Francisco, CA
1110male45.00011378435.5TS[null][null]Trenton, NJ
1210male42.00011048926.55D22S[null][null]London / Winnipeg, MB
1310male41.00011305430.5A21S[null][null]Pomeroy, WA
1410male48.000PC 1759150.4958B10C[null]208Omaha, NE
1510male[null]0011237939.6[null]C[null][null]Philadelphia, PA
1610male45.00011305026.55B38S[null][null]Washington, DC
1710male[null]0011379831.0[null]S[null][null][null]
1810male33.0006955.0B51 B53 B55S[null][null]New York, NY
1910male28.00011305947.1[null]S[null][null]Montevideo, Uruguay
2010male17.00011305947.1[null]S[null][null]Montevideo, Uruguay
2110male49.0001992426.0[null]S[null][null]Ascot, Berkshire / Rochester, NY
2210male36.0101987778.85C46S[null]172Little Onn Hall, Staffs
2310male46.010W.E.P. 573461.175E31S[null][null]Amenia, ND
2410male[null]001120510.0[null]S[null][null]Liverpool, England / Belfast
2510male27.01013508136.7792C89C[null][null]Los Angeles, CA
2610male[null]0011046552.0A14S[null][null]Stoughton, MA
2710male47.000572725.5875E58S[null][null]Victoria, BC
2810male37.011PC 1775683.1583E52C[null][null]Lakewood, NJ
2910male[null]0011379126.55[null]S[null][null]Roachdale, IN
3010male70.011WE/P 573571.0B22S[null]269Milwaukee, WI
3110male39.010PC 1759971.2833C85C[null][null]New York, NY
3210male31.010F.C. 1275052.0B71S[null][null]Montreal, PQ
3310male50.010PC 17761106.425C86C[null]62Deephaven, MN / Cedar Rapids, IA
3410male39.000PC 1758029.7A18C[null]133Philadelphia, PA
3510female36.000PC 1753131.6792A29C[null][null]New York, NY
3610male[null]00PC 17483221.7792C95S[null][null][null]
3710male30.00011305127.75C111C[null][null]New York, NY
3810male19.03219950263.0C23 C25 C27S[null][null]Winnipeg, MB
3910male64.01419950263.0C23 C25 C27S[null][null]Winnipeg, MB
4010male[null]0011377826.55D34S[null][null]Westcliff-on-Sea, Essex
4110male[null]001120580.0B102S[null][null][null]
4210male37.01011380353.1C123S[null][null]Scituate, MA
4310male47.00011132038.5E63S[null]275St Anne's-on-Sea, Lancashire
4410male24.000PC 1759379.2B86C[null][null][null]
4510male71.000PC 1775434.6542A5C[null][null]New York, NY
4610male38.001PC 17582153.4625C91S[null]147Winnipeg, MB
4710male46.000PC 1759379.2B82 B84C[null][null]New York, NY
4810male[null]0011379642.4[null]S[null][null][null]
4910male45.0103697383.475C83S[null][null]New York, NY
5010male40.0001120590.0B94S[null]110[null]
5110male55.0111274993.5B69S[null]307Montreal, PQ
5210male42.00011303842.5B11S[null][null]London / Middlesex
5310male[null]001746351.8625E46S[null][null]Brighton, MA
5410male55.00068050.0C39S[null][null]London / Birmingham
5510male42.01011378952.0[null]S[null]38New York, NY
5610male[null]00PC 1760030.6958[null]C14[null]New York, NY
5710female50.000PC 1759528.7125C49C[null][null]Paris, France New York, NY
5810male46.00069426.0[null]S[null]80Bennington, VT
5910male50.00011304426.0E60S[null][null]London
6010male32.500113503211.5C132C[null]45[null]
6110male58.0001177129.7B37C[null]258Buffalo, NY
6210male41.0101746451.8625D21S[null][null]Southington / Noank, CT
6310male[null]0011302826.55C124S[null][null]Portland, OR
6410male[null]00PC 1761227.7208[null]C[null][null]Chicago, IL
6510male29.00011350130.0D6S[null]126Springfield, MA
6610male30.00011380145.5[null]S[null][null]London / New York, NY
6710male30.00011046926.0C106S[null][null]Brockton, MA
6810male19.01011377353.1D30S[null][null]New York, NY
6910male46.0001305075.2417C6C[null]292Vancouver, BC
7010male54.0001746351.8625E46S[null]175Dorchester, MA
7110male28.010PC 1760482.1708[null]C[null][null]New York, NY
7210male65.0001350926.55E38S[null]249East Bridgewater, MA
7310male44.0201992890.0C78Q[null]230Fond du Lac, WI
7410male55.00011378730.5C30S[null][null]Montreal, PQ
7510male47.00011379642.4[null]S[null][null]Washington, DC
7610male37.001PC 1759629.7C118C[null][null]Brooklyn, NY
7710male58.00235273113.275D48C[null]122Lexington, MA
7810male64.00069326.0[null]S[null]263Isle of Wight, England
7910male65.00111350961.9792B30C[null]234Providence, RI
8010male28.500PC 1756227.7208D43C[null]189?Havana, Cuba
8110male[null]001120520.0[null]S[null][null]Belfast
8210male45.50011304328.5C124S[null]166Surbiton Hill, Surrey
8310male23.0001274993.5B24S[null][null]Montreal, PQ
8410male29.01011377666.6C2S[null][null]Isleworth, England
8510male18.010PC 17758108.9C65C[null][null]Madrid, Spain
8610male47.00011046552.0C110S[null]207Worcester, MA
8710male38.000199720.0[null]S[null][null]Rotterdam, Netherlands
8810male22.000PC 17760135.6333[null]C[null]232[null]
8910male[null]00PC 17757227.525[null]C[null][null][null]
9010male31.000PC 1759050.4958A24S[null][null]Trenton, NJ
9110male[null]0011376750.0A32S[null][null]Seattle, WA
9210male36.0001304940.125A10C[null][null]Winnipeg, MB
9310male55.010PC 1760359.4[null]C[null][null]New York, NY
9410male33.00011379026.55[null]S[null]109London
9510male61.013PC 17608262.375B57 B59 B63 B66C[null][null]Haverford, PA / Cooperstown, NY
9610male50.0101350755.9E44S[null][null]Duluth, MN
9710male56.00011379226.55[null]S[null][null]New York, NY
9810male56.0001776430.6958A7C[null][null]St James, Long Island, NY
9910male24.0101369560.0C31S[null][null]Huntington, WV
10010male[null]0011305626.0A19S[null][null]Streatham, Surrey
Rows: 1-100 | Columns: 14
In [4]:
# random sampling using x

titanic.sample(x = 0.33)
Out[4]:
123
pclass
Int
123
survived
Int
Abc
Varchar(164)
Abc
sex
Varchar(20)
123
age
Numeric(6,3)
123
sibsp
Int
123
parch
Int
Abc
ticket
Varchar(36)
123
fare
Numeric(10,5)
Abc
cabin
Varchar(30)
Abc
embarked
Varchar(20)
Abc
boat
Varchar(100)
123
body
Int
Abc
Varchar(100)
110female25.012113781151.55C22 C26S[null][null]
210male36.0001305075.2417C6CA[null]
310male41.00011305430.5A21S[null][null]
410male45.00011305026.55B38S[null][null]
510male[null]0011379831.0[null]S[null][null]
610male36.0101987778.85C46S[null]172
710male46.010W.E.P. 573461.175E31S[null][null]
810male[null]001120510.0[null]S[null][null]
910male27.01013508136.7792C89C[null][null]
1010male37.011PC 1775683.1583E52C[null][null]
1110male31.010F.C. 1275052.0B71S[null][null]
1210male19.03219950263.0C23 C25 C27S[null][null]
1310male[null]0011377826.55D34S[null][null]
1410male24.000PC 1759379.2B86C[null][null]
1510male45.0103697383.475C83S[null][null]
1610male55.0111274993.5B69S[null]307
1710male[null]001746351.8625E46S[null][null]
1810male55.00068050.0C39S[null][null]
1910male46.00069426.0[null]S[null]80
2010male58.0001177129.7B37C[null]258
2110male[null]00PC 1761227.7208[null]C[null][null]
2210male46.0001305075.2417C6C[null]292
2310male65.0001350926.55E38S[null]249
2410male44.0201992890.0C78Q[null]230
2510male55.00011378730.5C30S[null][null]
2610male[null]001120520.0[null]S[null][null]
2710male45.50011304328.5C124S[null]166
2810male23.0001274993.5B24S[null][null]
2910male47.00011046552.0C110S[null]207
3010male22.000PC 17760135.6333[null]C[null]232
3110male31.000PC 1759050.4958A24S[null][null]
3210male33.00011379026.55[null]S[null]109
3310male57.010PC 17569146.5208B78C[null][null]
3410male62.00011351426.55C87S[null][null]
3510male61.0003696332.3208D50S[null]46
3610male49.01117421110.8833C68C[null][null]
3710male40.000PC 1760127.7208[null]C[null][null]
3810male60.00011380026.55[null]S[null][null]
3910male27.002113503211.5C82C[null][null]
4010male51.001PC 1759761.3792[null]C[null][null]
4110male62.00011380726.55[null]S[null][null]
4211female29.00024160211.3375B5S2[null]
4311female18.010PC 17757227.525C62 C64C4[null]
4411male80.0002704230.0A23SB[null]
4511female50.001PC 17558247.5208B58 B60C6[null]
4611male37.0111175152.5542D35S5[null]
4711female42.000PC 17757227.525[null]C4[null]
4811female22.00111350555.0E33S6[null]
4911female59.0201176951.4792C101SD[null]
5011male42.000PC 1747626.2875E24S5[null]
5111female58.001PC 17755512.3292B51 B53 B55C3[null]
5211female47.010W.E.P. 573461.175E31S4[null]
5311male45.000PC 1759429.7A9C7[null]
5411female39.011PC 1775683.1583E49C14[null]
5511female64.002PC 1775683.1583E45C14[null]
5611female55.0201177025.7C101S2[null]
5711female36.002WE/P 573571.0B22S7[null]
5811female64.01111290126.55B26S7[null]
5911male27.00011380430.5[null]S3[null]
6011male4.0023363881.8583A34S5[null]
6111female48.010PC 17761106.425C86C2[null]
6211female23.0011176783.1583C54C7[null]
6311female23.03219950263.0C23 C25 C27S10[null]
6411female60.01419950263.0C23 C25 C27S10[null]
6511female48.0111356779.2B41C5[null]
6611female35.000113503211.5C130C4[null]
6711female45.00111237859.4[null]C7[null]
6811male49.0101745389.1042C92C5[null]
6911female[null]101745389.1042C92C5[null]
7011female19.00011205330.0B42S3[null]
7111female45.001PC 1775963.3583D10 D12C7[null]
7211male[null]001698830.0D45S3[null]
7311female24.0001176783.1583C54C7[null]
7411female16.00111136157.9792B18C4[null]
7511female44.00111136157.9792B18C4[null]
7611female51.0101350277.9583D11S10[null]
7711female35.0101994390.0C93SD[null]
7811female38.00011357280.0B28[null]6[null]
7911male42.0101175352.5542D19S5[null]
8011female30.000PC 17761106.425[null]C2[null]
8111male35.000PC 17755512.3292B101C3[null]
8211female55.00011237727.7208[null]C6[null]
8311female51.001PC 1759239.4D28S9[null]
8411female21.0001350277.9583D9S10[null]
8511male[null]00F.C. 1299825.7417[null]C7[null]
8611female17.010PC 17758108.9C65C8[null]
8711female30.0001274993.5B73S3[null]
8811male52.00011378630.5C104S6[null]
8911female56.0011176783.1583C50C7[null]
9011female33.00011015286.5B77S8[null]
9111female54.010PC 1760359.4[null]C6[null]
9211male13.022PC 17608262.375B57 B59 B63 B66C4[null]
9311female24.000PC 1747769.3B35C9[null]
9411male24.0102122882.2667B45S7[null]
9511female43.0101177855.4417C116C5[null]
9611female18.00211041379.65E68S8[null]
9711female[null]101999652.0C126S5 7[null]
9811male31.000254328.5375C53C7[null]
9911female50.011113503211.5C80C4[null]
10020male25.000C.A. 3405010.5[null]S[null][null]
Rows: 1-100 of 397 | Columns: 14
In [5]:
# random sampling using n

titanic.sample(n = 200)
Out[5]:
123
pclass
Int
123
survived
Int
Abc
Varchar(164)
Abc
sex
Varchar(20)
123
age
Numeric(6,3)
123
sibsp
Int
123
parch
Int
Abc
ticket
Varchar(36)
123
fare
Numeric(10,5)
Abc
cabin
Varchar(30)
Abc
embarked
Varchar(20)
Abc
boat
Varchar(100)
123
body
Int
Abc
Varchar(100)
110female25.012113781151.55C22 C26S[null][null]
210male48.000PC 1759150.4958B10C[null]208
310male28.00011305947.1[null]S[null][null]
410male36.0101987778.85C46S[null]172
510male47.000572725.5875E58S[null][null]
610male30.00011305127.75C111C[null][null]
710male[null]0011377826.55D34S[null][null]
810male46.000PC 1759379.2B82 B84C[null][null]
910male[null]0011379642.4[null]S[null][null]
1010male58.0001177129.7B37C[null]258
1110male37.001PC 1759629.7C118C[null][null]
1210male58.00235273113.275D48C[null]122
1310male65.00111350961.9792B30C[null]234
1410male23.0001274993.5B24S[null][null]
1510male[null]00PC 17757227.525[null]C[null][null]
1610male[null]0011376750.0A32S[null][null]
1710male36.0001304940.125A10C[null][null]
1810male62.00011351426.55C87S[null][null]
1910male[null]00PC 1760527.7208[null]C[null][null]
2010male67.010PC 17483221.7792C55 C57S[null]96
2110male61.00011124033.5B19S[null]245
2210male57.01136928164.8667[null]S[null][null]
2310male27.002113503211.5C82C[null][null]
2411female53.0201176951.4792C101SD[null]
2511male28.00011056426.55C52SD[null]
2611female58.00011378326.55C103S8[null]
2711female22.00111350555.0E33S6[null]
2811male36.001PC 17755512.3292B51 B53 B55C3[null]
2911male11.012113760120.0B96 B98S4[null]
3011male27.01011380653.1E8S5[null]
3111male45.000PC 1759429.7A9C7[null]
3211female38.010PC 1759971.2833C85C4[null]
3311female38.000PC 17757227.525C45C4[null]
3411female54.0103694778.2667D20C4[null]
3511female45.00111237859.4[null]C7[null]
3611female[null]101745389.1042C92C5[null]
3711female49.010PC 1757276.7292D33C3[null]
3811female35.0103697383.475C83SD[null]
3911female35.01011378952.0[null]S8[null]
4011female39.00024160211.3375[null]S2[null]
4111female30.000PC 17761106.425[null]C2[null]
4211female[null]10PC 1760482.1708[null]C6[null]
4311female33.0101992890.0C78Q14[null]
4411male30.0101323657.75C78C11[null]
4511female30.0001274993.5B73S3[null]
4611male52.00011378630.5C104S6[null]
4711male56.0001321335.5A26C3[null]
4811female40.01116966134.5E34C3[null]
4911male48.0101999652.0C126S5 7[null]
5011female60.01011081375.25D37C5[null]
5111female55.000PC 17760135.6333C32C8[null]
5211female31.00236928164.8667C7S8[null]
5311female21.00011379526.55[null]S8 10[null]
5411male21.001PC 1759761.3792[null]CA[null]
5511male[null]001994735.5C52SD[null]
5611female36.000PC 17760135.6333C32C8[null]
5720male30.010P/PP 338124.0[null]C[null][null]
5820male34.01022687526.0[null]S[null][null]
5920male54.01024425226.0[null]S[null][null]
6020male52.00024873113.5[null]S[null]130
6120male29.010200326.0[null]S[null][null]
6220male29.000W./C. 1426310.5[null]S[null][null]
6320male40.010292626.0[null]S[null]286
6420male38.0102866421.0[null]S[null][null]
6520male16.00023986526.0[null]S[null][null]
6620male21.0102813311.5[null]S[null][null]
6720male52.00025064713.0[null]S[null]19
6820male30.000W/C 1420810.5[null]S[null][null]
6920male49.01222084565.0[null]S[null][null]
7020female18.01125065013.0[null]S[null][null]
7120male23.0212910411.5[null]S[null][null]
7220male50.00025064313.0[null]S[null]149
7320male35.00023373412.35[null]Q[null][null]
7420female26.01125065126.0[null]S[null][null]
7520male36.000SC/Paris 216312.875DC[null][null]
7620male24.000C.A. 2956610.5[null]S[null]108
7720male61.00023550912.35[null]Q[null][null]
7820male30.00023347813.0[null]S[null][null]
7920male46.0002840326.0[null]S[null][null]
8020male27.00021153613.0[null]S[null][null]
8120male27.000SC/PARIS 216815.0333[null]C[null][null]
8220male25.00024436113.0[null]S[null][null]
8321female12.02123013639.0F4S13[null]
8421female36.00323013639.0F4S11[null]
8521male8.011C.A. 3311236.75[null]S14[null]
8621female18.00123191923.0[null]S[null][null]
8721female34.0112822032.5[null]S10[null]
8821female27.010SC/PARIS 214913.8583[null]C12[null]
8921female34.00024388013.0[null]S12[null]
9021male62.000S.W./PP 75210.5[null]S15[null]
9121female55.00024870616.0[null]S13[null]
9221male42.00023779813.0[null]S10[null]
9321female42.010SC/AH 308526.0[null]S[null][null]
9421male[null]00SC/PARIS 214613.8625[null]C9[null]
9521male29.000SC/PARIS 214713.8583[null]C9[null]
9621female50.00123043326.0[null]S12[null]
9721male30.000C.A. 3464412.7375[null]C14[null]
9821female30.0303102721.0[null]S[null][null]
9921female4.0112910323.0[null]S14[null]
10021female24.010SC/PARIS 216727.7208[null]C12[null]
Rows: 1-100 of 192 | Columns: 14
In [7]:
# stratified sampling

titanic.sample(x = 0.33,
               method = "stratified", 
               by = ["pclass", "sex"])
Out[7]:
123
pclass
Int
123
survived
Int
Abc
Varchar(164)
Abc
sex
Varchar(20)
123
age
Numeric(6,3)
123
sibsp
Int
123
parch
Int
Abc
ticket
Varchar(36)
123
fare
Numeric(10,5)
Abc
cabin
Varchar(30)
Abc
embarked
Varchar(20)
Abc
boat
Varchar(100)
123
body
Int
Abc
home.dest
Varchar(100)
111female21.00011379526.55[null]S8 10[null]Duluth, MN
211female31.00236928164.8667C7S8[null]Youngstown, OH
311female35.000PC 17755512.3292[null]C3[null][null]
411female[null]101999652.0C126S5 7[null]London /  East Orange, NJ
511female48.0001746625.9292D17S8[null]Brooklyn, NY
611female43.0101177855.4417C116C5[null]Newark, NJ
711female23.0102122882.2667B45S7[null]Minneapolis, MN
811female40.000PC 17582153.4625C125S3[null]New York, NY / Greenwich CT
911female24.000PC 1747769.3B35C9[null][null]
1011female54.010PC 1760359.4[null]C6[null]New York, NY
1111female43.00124160211.3375B3S2[null]St Louis, MO
1211female17.010PC 17758108.9C65C8[null]Madrid, Spain
1311female39.000PC 17758108.9C105C8[null][null]
1411female31.01035273113.275D36C6[null]Lexington, MA
1511female[null]10PC 1760482.1708[null]C6[null]New York, NY
1611female15.00124160211.3375B5S2[null]St Louis, MO
1711female51.001PC 1759239.4D28S9[null]Paris, France
1811female49.0001746525.9292D17S8[null]New York, NY
1911female45.0101175352.5542D19S5[null]Boston, MA
2011female35.0101994390.0C93SD[null]New York, NY /  Stamford CT
2111female44.00111136157.9792B18C4[null]Chicago, IL
2211female24.0001176783.1583C54C7[null]New York, NY
2311female25.0101176555.4417E50C5[null]Brooklyn, NY
2411female19.00011205330.0B42S3[null]Greenwich, CT
2511female22.00111237859.4[null]C7[null]New York, NY
2611female48.0111356779.2B41C5[null]Zurich, Switzerland
2711female30.000PC 1748556.9292E36C1[null][null]
2811female28.03219950263.0C23 C25 C27S10[null]Winnipeg, MB
2911female[null]00PC 1759831.6833[null]S7[null]New York, NY
3011female23.0011176783.1583C54C7[null]Mt Airy, Philadelphia, PA
3111female54.0113363881.8583A34S5[null]San Francisco, CA
3211female33.000113781151.55[null]S8[null][null]
3311female36.002WE/P 573571.0B22S7[null]Milwaukee, WI
3411female39.011PC 1775683.1583E49C14[null]Lakewood, NJ
3511female[null]0111350555.0E33S6[null]St Leonards-on-Sea, England Ohio
3611female33.01011380653.1E8S5[null]New York, NY / Ithaca, NY
3711female[null]001777027.7208[null]C5[null]New York, NY
3811female58.001PC 17755512.3292B51 B53 B55C3[null]Germantown, Philadelphia, PA
3911female60.0001181376.2917D15C8[null]Philadelphia, PA
4011female22.00111350555.0E33S6[null]St Leonards-on-Sea, England Ohio
4111female30.00036928164.8667C7S8[null]Youngstown, OH
4211female29.000PC 17483221.7792C97S8[null][null]
4311female32.0001181376.2917D15C8[null][null]
4411female18.010PC 17757227.525C62 C64C4[null]New York, NY
4511female29.00024160211.3375B5S2[null]St Louis, MO
4610female36.000PC 1753131.6792A29C[null][null]New York, NY
4711male[null]001994735.5C52SD[null]London, England
4811male17.00217421110.8833C70CB[null]Haverford, PA
4911male32.0001321430.5B50C3[null]Basel, Switzerland
5011male24.0102122882.2667B45S7[null]Minneapolis, MN
5111male35.000PC 1747526.2875E24S5[null]St Louis, MO
5211male[null]001998830.5C106S3[null]Manchester, England
5311male52.00011378630.5C104S6[null]Toronto, ON
5411male36.000PC 1747326.2875E25S7[null]Philadelphia, PA
5511male42.0101175352.5542D19S5[null]Boston, MA
5611male[null]001698830.0D45S3[null]Kingston, Surrey
5711male25.0101176555.4417E50C5[null]Brooklyn, NY
5811male49.0101745389.1042C92C5[null]Paris, France / New York, NY
5911male50.020PC 17611133.65[null]S5[null]New York, NY
6011male31.0101747457.0B20S3[null]Calgary, AB
6111male45.000PC 1759429.7A9C7[null]Paris, France
6211male11.012113760120.0B96 B98S4[null]Bryn Mawr, PA
6311male40.00011227731.0A31C7[null]Glen Ridge, NJ
6411male26.00011136930.0C148C5[null]New York, NY
6511male48.0001995226.55E12S3[null]New York, NY
6610male[null]0011351035.0C128S[null][null]London, England
6710male50.011113503211.5C80C[null][null]Elkins Park, PA
6810male54.0013528177.2875D26S[null][null]Brunswick, ME
6910male47.0003696734.0208D46S[null][null]East Orange, NJ
7010male49.01117421110.8833C68C[null][null]Haverford, PA
7110male67.010PC 17483221.7792C55 C57S[null]96New York, NY
7210male57.010PC 17569146.5208B78C[null][null]Paris, France
7310male56.0001776430.6958A7C[null][null]St James, Long Island, NY
7410male61.013PC 17608262.375B57 B59 B63 B66C[null][null]Haverford, PA / Cooperstown, NY
7510male36.0001304940.125A10C[null][null]Winnipeg, MB
7610male[null]00PC 17757227.525[null]C[null][null][null]
7710male47.00011046552.0C110S[null]207Worcester, MA
7810male23.0001274993.5B24S[null][null]Montreal, PQ
7910male28.500PC 1756227.7208D43C[null]189?Havana, Cuba
8010male58.00235273113.275D48C[null]122Lexington, MA
8110male55.00011378730.5C30S[null][null]Montreal, PQ
8210male28.010PC 1760482.1708[null]C[null][null]New York, NY
8310male19.01011377353.1D30S[null][null]New York, NY
8410male29.00011350130.0D6S[null]126Springfield, MA
8510male41.0101746451.8625D21S[null][null]Southington / Noank, CT
8610male50.00011304426.0E60S[null][null]London
8710male42.01011378952.0[null]S[null]38New York, NY
8810male42.00011303842.5B11S[null][null]London / Middlesex
8910male45.0103697383.475C83S[null][null]New York, NY
9010male38.001PC 17582153.4625C91S[null]147Winnipeg, MB
9110male47.00011132038.5E63S[null]275St Anne's-on-Sea, Lancashire
9210male[null]0011377826.55D34S[null][null]Westcliff-on-Sea, Essex
9310male30.00011305127.75C111C[null][null]New York, NY
9410male50.010PC 17761106.425C86C[null]62Deephaven, MN / Cedar Rapids, IA
9510male70.011WE/P 573571.0B22S[null]269Milwaukee, WI
9610male47.000572725.5875E58S[null][null]Victoria, BC
9710male[null]001120510.0[null]S[null][null]Liverpool, England / Belfast
9810male49.0001992426.0[null]S[null][null]Ascot, Berkshire / Rochester, NY
9910male33.0006955.0B51 B53 B55S[null][null]New York, NY
10010male[null]0011237939.6[null]C[null][null]Philadelphia, PA
Rows: 1-100 of 411 | Columns: 14
In [8]:
# systematic sampling

titanic.sample(x = 0.33,
               method = "systematic")
Out[8]:
123
pclass
Int
123
survived
Int
Abc
Varchar(164)
Abc
sex
Varchar(20)
123
age
Numeric(6,3)
123
sibsp
Int
123
parch
Int
Abc
ticket
Varchar(36)
123
fare
Numeric(10,5)
Abc
cabin
Varchar(30)
Abc
embarked
Varchar(20)
Abc
boat
Varchar(100)
123
body
Int
Abc
Varchar(100)
110female25.012113781151.55C22 C26S[null][null]
210male47.010PC 17757227.525C62 C64C[null]124
310male36.0001305075.2417C6CA[null]
410male42.00011048926.55D22S[null][null]
510male[null]0011237939.6[null]C[null][null]
610male33.0006955.0B51 B53 B55S[null][null]
710male49.0001992426.0[null]S[null][null]
810male[null]001120510.0[null]S[null][null]
910male47.000572725.5875E58S[null][null]
1010male70.011WE/P 573571.0B22S[null]269
1110male50.010PC 17761106.425C86C[null]62
1210male[null]00PC 17483221.7792C95S[null][null]
1310male64.01419950263.0C23 C25 C27S[null][null]
1410male37.01011380353.1C123S[null][null]
1510male71.000PC 1775434.6542A5C[null][null]
1610male[null]0011379642.4[null]S[null][null]
1710male55.0111274993.5B69S[null]307
1810male55.00068050.0C39S[null][null]
1910female50.000PC 1759528.7125C49C[null][null]
2010male32.500113503211.5C132C[null]45
2110male[null]0011302826.55C124S[null][null]
2210male30.00011380145.5[null]S[null][null]
2310male46.0001305075.2417C6C[null]292
2410male65.0001350926.55E38S[null]249
2510male47.00011379642.4[null]S[null][null]
2610male64.00069326.0[null]S[null]263
2710male[null]001120520.0[null]S[null][null]
2810male29.01011377666.6C2S[null][null]
2910male38.000199720.0[null]S[null][null]
3010male31.000PC 1759050.4958A24S[null][null]
3110male55.010PC 1760359.4[null]C[null][null]
3210male50.0101350755.9E44S[null][null]
3310male24.0101369560.0C31S[null][null]
3410male62.00011351426.55C87S[null][null]
3510female63.010PC 17483221.7792C55 C57S[null][null]
3610male49.01117421110.8833C68C[null][null]
3710male47.0003696734.0208D46S[null][null]
3810male54.0013528177.2875D26S[null][null]
3910male50.011113503211.5C80C[null][null]
4010male[null]0011351035.0C128S[null][null]
4111male0.9212113781151.55C22 C26S11[null]
4211female53.0201176951.4792C101SD[null]
4311male80.0002704230.0A23SB[null]
4411male37.0111175152.5542D35S5[null]
4511female42.000PC 17757227.525[null]C4[null]
4611female19.0101196791.0792B49C7[null]
4711male40.00011227731.0A31C7[null]
4811female45.000PC 17608262.375[null]C4[null]
4911female59.0201176951.4792C101SD[null]
5011male42.000PC 1747626.2875E24S5[null]
5111female58.001PC 17755512.3292B51 B53 B55C3[null]
5211male36.012113760120.0B96 B98SC[null]
5311female76.0101987778.85C46S6[null]
5411female33.01011380653.1E8S5[null]
5511male45.000PC 1759429.7A9C7[null]
5611female22.000113781151.55[null]S11[null]
5711female55.0201177025.7C101S2[null]
5811female38.010PC 1759971.2833C85C4[null]
5911female33.000113781151.55[null]S8[null]
6011female17.0101747457.0B20S3[null]
6111female54.0113363881.8583A34S5[null]
6211female23.0011176783.1583C54C7[null]
6311female[null]00PC 1759831.6833[null]S7[null]
6411female28.03219950263.0C23 C25 C27S10[null]
6511female30.000PC 1748556.9292E36C1[null]
6611female[null]10PC 17611133.65[null]S5[null]
6711female48.0111356779.2B41C5[null]
6811female22.00111237859.4[null]C7[null]
6911female[null]101745389.1042C92C5[null]
7011female58.001PC 17582153.4625C125S3[null]
7111male25.0101176555.4417E50C5[null]
7211female49.010PC 1757276.7292D33C3[null]
7311male[null]001698830.0D45S3[null]
7411female16.00111136157.9792B18C4[null]
7511female35.01011378952.0[null]S8[null]
7611female38.00011357280.0B28[null]6[null]
7711male42.0101175352.5542D19S5[null]
7811female30.000PC 17761106.425[null]C2[null]
7911female55.00011237727.7208[null]C6[null]
8011female21.0001350277.9583D9S10[null]
8111female16.00011015286.5B79S8[null]
8211male36.000PC 1747326.2875E25S7[null]
8311female37.0101992890.0C78Q14[null]
8411female23.01035273113.275D36C6[null]
8511male[null]00F.C. 1299825.7417[null]C7[null]
8611female17.010PC 17758108.9C65C8[null]
8711female56.0011176783.1583C50C7[null]
8811female33.000PC 1761327.7208A11C11[null]
8911male13.022PC 17608262.375B57 B59 B63 B66C4[null]
9011male[null]001998830.5C106S3[null]
9111female35.0101323657.75C28C11[null]
9211female40.000PC 17582153.4625C125S3[null]
9311male56.0001321335.5A26C3[null]
9411male24.0102122882.2667B45S7[null]
9511male45.01116966134.5E34C3[null]
9611male32.0001321430.5B50C3[null]
9711female52.0103694778.2667D20C4[null]
9811female18.00211041379.65E68S8[null]
9911female[null]101999652.0C126S5 7[null]
10011female[null]00PC 1758579.2[null]CD[null]
Rows: 1-100 of 411 | Columns: 14