vDataFrame[].dtype¶

In [ ]:

vDataFrame[].dtype()

Returns the vcolumn DB type.

Returns¶

str : vcolumn DB type.

Example¶

In [33]:

from verticapy.datasets import load_amazon
amazon = load_amazon()
display(amazon)

	Abc state Varchar(32)	📅 date Date	123 number Int
1	Acre	1998-01-01	0
2	Alagoas	1998-01-01	0
3	Amapa	1998-01-01	0
4	Amazonas	1998-01-01	0
5	Bahia	1998-01-01	0
6	Ceara	1998-01-01	0
7	Distrito Federal	1998-01-01	0
8	Espirito Santo	1998-01-01	0
9	Goias	1998-01-01	0
10	Maranhao	1998-01-01	0
11	Mato Grosso	1998-01-01	0
12	Mato Grosso	1998-01-01	0
13	Minas Gerais	1998-01-01	0
14	Para	1998-01-01	0
15	Paraiba	1998-01-01	0
16	Paraiba	1998-01-01	0
17	Pernambuco	1998-01-01	0
18	Piau	1998-01-01	0
19	Rio	1998-01-01	0
20	Rio	1998-01-01	0
21	Rio	1998-01-01	0
22	Rondonia	1998-01-01	0
23	Roraima	1998-01-01	0
24	Santa Catarina	1998-01-01	0
25	Sao Paulo	1998-01-01	0
26	Sergipe	1998-01-01	0
27	Tocantins	1998-01-01	0
28	Acre	1998-02-01	0
29	Alagoas	1998-02-01	0
30	Amapa	1998-02-01	0
31	Amazonas	1998-02-01	0
32	Bahia	1998-02-01	0
33	Ceara	1998-02-01	0
34	Distrito Federal	1998-02-01	0
35	Espirito Santo	1998-02-01	0
36	Goias	1998-02-01	0
37	Maranhao	1998-02-01	0
38	Mato Grosso	1998-02-01	0
39	Mato Grosso	1998-02-01	0
40	Minas Gerais	1998-02-01	0
41	Para	1998-02-01	0
42	Paraiba	1998-02-01	0
43	Paraiba	1998-02-01	0
44	Pernambuco	1998-02-01	0
45	Piau	1998-02-01	0
46	Rio	1998-02-01	0
47	Rio	1998-02-01	0
48	Rio	1998-02-01	0
49	Rondonia	1998-02-01	0
50	Roraima	1998-02-01	0
51	Santa Catarina	1998-02-01	0
52	Sao Paulo	1998-02-01	0
53	Sergipe	1998-02-01	0
54	Tocantins	1998-02-01	0
55	Acre	1998-03-01	0
56	Alagoas	1998-03-01	0
57	Amapa	1998-03-01	0
58	Amazonas	1998-03-01	0
59	Bahia	1998-03-01	0
60	Ceara	1998-03-01	0
61	Distrito Federal	1998-03-01	0
62	Espirito Santo	1998-03-01	0
63	Goias	1998-03-01	0
64	Maranhao	1998-03-01	0
65	Mato Grosso	1998-03-01	0
66	Mato Grosso	1998-03-01	0
67	Minas Gerais	1998-03-01	0
68	Para	1998-03-01	0
69	Paraiba	1998-03-01	0
70	Paraiba	1998-03-01	0
71	Pernambuco	1998-03-01	0
72	Piau	1998-03-01	0
73	Rio	1998-03-01	0
74	Rio	1998-03-01	0
75	Rio	1998-03-01	0
76	Rondonia	1998-03-01	0
77	Roraima	1998-03-01	0
78	Santa Catarina	1998-03-01	0
79	Sao Paulo	1998-03-01	0
80	Sergipe	1998-03-01	0
81	Tocantins	1998-03-01	0
82	Acre	1998-04-01	0
83	Alagoas	1998-04-01	0
84	Amapa	1998-04-01	0
85	Amazonas	1998-04-01	0
86	Bahia	1998-04-01	0
87	Ceara	1998-04-01	0
88	Distrito Federal	1998-04-01	0
89	Espirito Santo	1998-04-01	0
90	Goias	1998-04-01	0
91	Maranhao	1998-04-01	0
92	Mato Grosso	1998-04-01	0
93	Mato Grosso	1998-04-01	0
94	Minas Gerais	1998-04-01	0
95	Para	1998-04-01	0
96	Paraiba	1998-04-01	0
97	Paraiba	1998-04-01	0
98	Pernambuco	1998-04-01	0
99	Piau	1998-04-01	0
100	Rio	1998-04-01	0

Rows: 1-100 of 6454 | Columns: 3

In [13]:

amazon["number"].dtype()

Out[13]:

'int'

In [25]:

amazon["state"].dtype()

Out[25]:

'varchar(32)'

In [26]:

amazon["date"].dtype()

Out[26]:

'date'