gen_meshgrid¶

In [ ]:

gen_meshgrid(features_ranges: dict)

Generates a dataset using regular steps.

Parameters¶

Name	Type	Optional	Description
features_ranges	dict	❌	Dictionary including the features types and ranges. For str :The subdictionary must include two keys. 'type' must be set to 'str' and 'value' must include the feature categories. For int :The subdictionary must include two keys. 'type' must be set to 'int' and 'range' must include two integers that represent the lower and the upper bound. For float :The subdictionary must include two keys. 'type' must be set to 'float' and 'range' must include two floats that represent the lower and the upper bound. For date :The subdictionary must include two keys. 'type' must be set to 'date' and 'range' must include the start date and the number of days after. For datetime :The subdictionary must include two keys. 'type' must be set to 'date' and 'range' must include the start date and the number of days after. Numerical and date-like features must have an extra key in the dictionary named 'nbins' corresponding to the number of bins used to compute the different categories.

Returns¶

vDataFrame : generated dataset.

Example¶

In [5]:

from verticapy.datasets import gen_meshgrid
import datetime

gen_meshgrid(features_ranges = {"name": {"type": str, "values": ["Badr", "Badr", "Raghu", "Waqas",]},
                                "age": {"type": int, "range": [20, 40], "nbins": 3,},
                                "distance": {"type": float, "range": [1000, 4000], "nbins": 3,},
                                "date": {"type": datetime.date, "range": ["1993-11-03", 365], "nbins": 2,},
                                "datetime": {"type": datetime.datetime, "range": ["1993-11-03", 365], "nbins": 2,},},)

Out[5]:

	Abc name Varchar(5)	123 age Int	123 distance Float	📅 date Date	📅 datetime Timestamp
1	Badr	20	1000.0	1993-11-03	1993-11-03 00:00:00
2	Badr	20	1000.0	1993-11-03	1994-05-04 12:00:00
3	Badr	20	1000.0	1993-11-03	1994-11-03 00:00:00
4	Badr	20	1000.0	1994-05-04	1993-11-03 00:00:00
5	Badr	20	1000.0	1994-05-04	1994-05-04 12:00:00
6	Badr	20	1000.0	1994-05-04	1994-11-03 00:00:00
7	Badr	20	1000.0	1994-11-03	1993-11-03 00:00:00
8	Badr	20	1000.0	1994-11-03	1994-05-04 12:00:00
9	Badr	20	1000.0	1994-11-03	1994-11-03 00:00:00
10	Badr	20	2000.0	1993-11-03	1993-11-03 00:00:00
11	Badr	20	2000.0	1993-11-03	1994-05-04 12:00:00
12	Badr	20	2000.0	1993-11-03	1994-11-03 00:00:00
13	Badr	20	2000.0	1994-05-04	1993-11-03 00:00:00
14	Badr	20	2000.0	1994-05-04	1994-05-04 12:00:00
15	Badr	20	2000.0	1994-05-04	1994-11-03 00:00:00
16	Badr	20	2000.0	1994-11-03	1993-11-03 00:00:00
17	Badr	20	2000.0	1994-11-03	1994-05-04 12:00:00
18	Badr	20	2000.0	1994-11-03	1994-11-03 00:00:00
19	Badr	20	3000.0	1993-11-03	1993-11-03 00:00:00
20	Badr	20	3000.0	1993-11-03	1994-05-04 12:00:00
21	Badr	20	3000.0	1993-11-03	1994-11-03 00:00:00
22	Badr	20	3000.0	1994-05-04	1993-11-03 00:00:00
23	Badr	20	3000.0	1994-05-04	1994-05-04 12:00:00
24	Badr	20	3000.0	1994-05-04	1994-11-03 00:00:00
25	Badr	20	3000.0	1994-11-03	1993-11-03 00:00:00
26	Badr	20	3000.0	1994-11-03	1994-05-04 12:00:00
27	Badr	20	3000.0	1994-11-03	1994-11-03 00:00:00
28	Badr	20	4000.0	1993-11-03	1993-11-03 00:00:00
29	Badr	20	4000.0	1993-11-03	1994-05-04 12:00:00
30	Badr	20	4000.0	1993-11-03	1994-11-03 00:00:00
31	Badr	20	4000.0	1994-05-04	1993-11-03 00:00:00
32	Badr	20	4000.0	1994-05-04	1994-05-04 12:00:00
33	Badr	20	4000.0	1994-05-04	1994-11-03 00:00:00
34	Badr	20	4000.0	1994-11-03	1993-11-03 00:00:00
35	Badr	20	4000.0	1994-11-03	1994-05-04 12:00:00
36	Badr	20	4000.0	1994-11-03	1994-11-03 00:00:00
37	Badr	27	1000.0	1993-11-03	1993-11-03 00:00:00
38	Badr	27	1000.0	1993-11-03	1994-05-04 12:00:00
39	Badr	27	1000.0	1993-11-03	1994-11-03 00:00:00
40	Badr	27	1000.0	1994-05-04	1993-11-03 00:00:00
41	Badr	27	1000.0	1994-05-04	1994-05-04 12:00:00
42	Badr	27	1000.0	1994-05-04	1994-11-03 00:00:00
43	Badr	27	1000.0	1994-11-03	1993-11-03 00:00:00
44	Badr	27	1000.0	1994-11-03	1994-05-04 12:00:00
45	Badr	27	1000.0	1994-11-03	1994-11-03 00:00:00
46	Badr	27	2000.0	1993-11-03	1993-11-03 00:00:00
47	Badr	27	2000.0	1993-11-03	1994-05-04 12:00:00
48	Badr	27	2000.0	1993-11-03	1994-11-03 00:00:00
49	Badr	27	2000.0	1994-05-04	1993-11-03 00:00:00
50	Badr	27	2000.0	1994-05-04	1994-05-04 12:00:00
51	Badr	27	2000.0	1994-05-04	1994-11-03 00:00:00
52	Badr	27	2000.0	1994-11-03	1993-11-03 00:00:00
53	Badr	27	2000.0	1994-11-03	1994-05-04 12:00:00
54	Badr	27	2000.0	1994-11-03	1994-11-03 00:00:00
55	Badr	27	3000.0	1993-11-03	1993-11-03 00:00:00
56	Badr	27	3000.0	1993-11-03	1994-05-04 12:00:00
57	Badr	27	3000.0	1993-11-03	1994-11-03 00:00:00
58	Badr	27	3000.0	1994-05-04	1993-11-03 00:00:00
59	Badr	27	3000.0	1994-05-04	1994-05-04 12:00:00
60	Badr	27	3000.0	1994-05-04	1994-11-03 00:00:00
61	Badr	27	3000.0	1994-11-03	1993-11-03 00:00:00
62	Badr	27	3000.0	1994-11-03	1994-05-04 12:00:00
63	Badr	27	3000.0	1994-11-03	1994-11-03 00:00:00
64	Badr	27	4000.0	1993-11-03	1993-11-03 00:00:00
65	Badr	27	4000.0	1993-11-03	1994-05-04 12:00:00
66	Badr	27	4000.0	1993-11-03	1994-11-03 00:00:00
67	Badr	27	4000.0	1994-05-04	1993-11-03 00:00:00
68	Badr	27	4000.0	1994-05-04	1994-05-04 12:00:00
69	Badr	27	4000.0	1994-05-04	1994-11-03 00:00:00
70	Badr	27	4000.0	1994-11-03	1993-11-03 00:00:00
71	Badr	27	4000.0	1994-11-03	1994-05-04 12:00:00
72	Badr	27	4000.0	1994-11-03	1994-11-03 00:00:00
73	Badr	33	1000.0	1993-11-03	1993-11-03 00:00:00
74	Badr	33	1000.0	1993-11-03	1994-05-04 12:00:00
75	Badr	33	1000.0	1993-11-03	1994-11-03 00:00:00
76	Badr	33	1000.0	1994-05-04	1993-11-03 00:00:00
77	Badr	33	1000.0	1994-05-04	1994-05-04 12:00:00
78	Badr	33	1000.0	1994-05-04	1994-11-03 00:00:00
79	Badr	33	1000.0	1994-11-03	1993-11-03 00:00:00
80	Badr	33	1000.0	1994-11-03	1994-05-04 12:00:00
81	Badr	33	1000.0	1994-11-03	1994-11-03 00:00:00
82	Badr	33	2000.0	1993-11-03	1993-11-03 00:00:00
83	Badr	33	2000.0	1993-11-03	1994-05-04 12:00:00
84	Badr	33	2000.0	1993-11-03	1994-11-03 00:00:00
85	Badr	33	2000.0	1994-05-04	1993-11-03 00:00:00
86	Badr	33	2000.0	1994-05-04	1994-05-04 12:00:00
87	Badr	33	2000.0	1994-05-04	1994-11-03 00:00:00
88	Badr	33	2000.0	1994-11-03	1993-11-03 00:00:00
89	Badr	33	2000.0	1994-11-03	1994-05-04 12:00:00
90	Badr	33	2000.0	1994-11-03	1994-11-03 00:00:00
91	Badr	33	3000.0	1993-11-03	1993-11-03 00:00:00
92	Badr	33	3000.0	1993-11-03	1994-05-04 12:00:00
93	Badr	33	3000.0	1993-11-03	1994-11-03 00:00:00
94	Badr	33	3000.0	1994-05-04	1993-11-03 00:00:00
95	Badr	33	3000.0	1994-05-04	1994-05-04 12:00:00
96	Badr	33	3000.0	1994-05-04	1994-11-03 00:00:00
97	Badr	33	3000.0	1994-11-03	1993-11-03 00:00:00
98	Badr	33	3000.0	1994-11-03	1994-05-04 12:00:00
99	Badr	33	3000.0	1994-11-03	1994-11-03 00:00:00
100	Badr	33	4000.0	1993-11-03	1993-11-03 00:00:00

Rows: 1-100 | Columns: 5