to_tablesample¶

In [ ]:

to_tablesample(query: str,
               title: str = "")

Returns the result of a SQL query as a tablesample object.

Parameters¶

Name	Type	Optional	Description
query	str	❌	SQL Query.
title	str	✓	Query title when the query is displayed.

Returns¶

tablesample : An object containing the result. For more information, see utilities.tablesample.

Example¶

In [20]:

from verticapy.utilities import *
to_tablesample("SELECT * FROM public.titanic LIMIT 5")

	123 pclass Integer	123 survived Integer	Abc Varchar(164)	Abc sex Varchar(20)	123 age Numeric(6,3)	123 sibsp Integer	123 parch Integer	Abc ticket Varchar(36)	123 fare Numeric(10,5)	Abc cabin Varchar(30)	Abc embarked Varchar(20)	Abc boat Varchar(100)	123 body Integer	Abc home.dest Varchar(100)
1	1	0		female	2.000	1	2	113781	151.55000	C22 C26	S	[null]	[null]	Montreal, PQ / Chesterville, ON
2	1	0		male	30.000	1	2	113781	151.55000	C22 C26	S	[null]	135	Montreal, PQ / Chesterville, ON
3	1	0		female	25.000	1	2	113781	151.55000	C22 C26	S	[null]	[null]	Montreal, PQ / Chesterville, ON
4	1	0		male	39.000	0	0	112050	0.00000	A36	S	[null]	[null]	Belfast, NI
5	1	0		male	71.000	0	0	PC 17609	49.50420	[null]	C	[null]	22	Montevideo, Uruguay

Out[20]:

Rows: 1-5 of 0 | Columns: 14

See Also¶

Object in memory created for rendering purposes.