AutoDataPrep¶

In [ ]:

class AutoDataPrep(name: str = "",
                   cursor=None,
                   cat_method: str = "ooe",
                   num_method: str = "none",
                   nbins: int = 20,
                   outliers_threshold: float = 4.0,
                   na_method: str = "auto",
                   cat_topk: int = 10,
                   normalize: bool = True,
                   normalize_min_cat: int = 6,
                   id_method: int = "drop",
                   apply_pca: bool = False,
                   rule: (str, datetime.timedelta) = "auto",
                   identify_ts: bool = True,
                   save: bool = True,)

Automatically find relations between the different features to preprocess the data according to each column type.

Parameters¶

Name	Type	Optional	Description
name	str	❌	Name of the model.
cursor	DBcursor	✓	Vertica database cursor.
cat_method	str	✓	Method for encoding categorical features. This can be set to 'label' for label encoding and 'ooe' for One-Hot Encoding.
num_method	str	✓	[Only used for non-time series datasets] Method for encoding numerical features. This can be set to 'same_freq' to encode using frequencies, 'same_width' to encode using regular bins, or 'none' to not encode numerical features.
nbins	int	✓	[Only used for non-time series datasets] Number of bins used to discretize numerical features.
outliers_threshold	float	✓	[Only used for non-time series datasets] How to deal with outliers. If a number is used, all elements with an absolute z-score greater than the threshold will be converted to NULL values. Otherwise, outliers are treated as regular values.
na_method	str	✓	Method for handling missing values. auto: Mean for the numerical features and creates a new category for the categorical vcolumns. For time series datasets, 'constant' interpolation is used for categorical features and 'linear' for the others. drop: Drops the missing values.
cat_topk	int	✓	Keeps the top-k most frequent categories and merges the others into one unique category. If unspecified, all categories are kept.
normalize	bool	✓	If True, the data will be normalized using the z-score. The 'num_method' parameter must be set to 'none'.
normalize_min_cat	int	✓	Minimum feature cardinality before using normalization.
id_method	str	✓	Method for handling ID features. drop : Drops any feature detected as ID. none : Does not change ID features.
apply_pca	bool	✓	[Only used for non-time series datasets] If True, a PCA is applied at the end of the preprocessing.
rule	str / time	✓	[Only used for time series datasets] Interval to use to slice the time. For example, '5 minutes' will create records separated by '5 minutes' time interval. If set to auto, the rule will be detected using aggregations.
identify_ts	bool	✓	If True and parameter 'ts' is undefined when fitting the model, the function will try to automatically detect the parameter 'ts'.
print_info	bool	✓	If True, prints the model information at each step.

Attributes¶

Name	Type	Description
X_in	list	Variables used to fit the model.
X_out	list	Variables created by the model.
ts	str	TS component.
by	list	vcolumns used in the partition.
sql_	str	SQL needed to deploy the model.
final_relation_	vDataFrame	Relation created after fitting the model.
model_grid_	tablesample	Grid containing the different models information.

Main Methods¶

Name	Description
fit	Trains the model.

AutoDataPrep also inherits the vModel methods.

Example¶

In [4]:

from verticapy.learn.delphi import AutoDataPrep

model = AutoDataPrep("titanic_autodataprep")
model.fit("public.titanic",)

Out[4]:

	123 pclass Int	123 survived Int	123 age Numeric(45,29)	123 sibsp Numeric(33,15)	123 parch Numeric(33,15)	123 fare Numeric(48,30)	123 body Numeric(60,29)	123 sex_female Int	123 sex_male Int	123 ticket_113781 Int	123 ticket_1601 Int	123 ticket_19950 Int	123 ticket_3101295 Int	123 ticket_347077 Int	123 ticket_347082 Int	123 ticket_347088 Int	123 ticket_CA_2144 Int	123 ticket_CA._2343 Int	123 ticket_Others Int	123 ticket_S.O.C._14879 Int	123 cabin_A34 Int	123 cabin_B57_B59_B63_B66 Int	123 cabin_B96_B98 Int	123 cabin_C22_C26 Int	123 cabin_C23_C25_C27 Int	...	123 embarked_C Int	123 embarked_Q Int	123 embarked_S Int	123 boat_10 Int	123 boat_13 Int	123 boat_14 Int	123 boat_15 Int	123 boat_3 Int	123 boat_4 Int	123 boat_5 Int	123 boat_8 Int	123 boat_C Int	123 boat_NULL Int	123 boat_Others Int	123 home.dest_Cornwall___Akron__OH Int	123 home.dest_London Int	123 home.dest_Montreal__PQ Int	123 home.dest_NULL Int	123 home.dest_New_York__NY Int	123 home.dest_Others Int	123 home.dest_Paris__France Int	123 home.dest_Philadelphia__PA Int	123 home.dest_Sweden_Winnipeg__MN Int	123 Int	123 home.dest_Winnipeg__MB Int
1	1	0	-1.9502503129565278	1.0	2.0	3.246526416143475	1.75500630588542e-15	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
2	1	0	-0.9111312652771447	0.0	0.0	0.46590320451047	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
3	1	0	-0.8418566620985193	1.0	0.0	2.1111163637150625	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
4	1	0	-0.7725820589198937	1.0	0.0	0.6256326374429547	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0		0
5	1	0	-0.7725820589198937	3.0	2.0	2.49988404095323e-16	1.75500630588542e-15	0	1	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	1	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0		1
6	1	0	-0.6340328525626426	0.0	1.0	1.2695419139520339	0.050280930663622686	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
7	1	0	-0.5647582493840171	0.0	0.0	2.822798838617395	0.7026167745612807	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0		0
8	1	0	-0.49548364620539154	0.0	0.0	1.7011441525216853	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0		0
9	1	0	-0.426209043026766	0.0	0.0	1.3204556706992634	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0		0
10	1	0	-0.426209043026766	0.0	1.0	2.49988404095323e-16	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0		0
11	1	0	-0.426209043026766	1.0	0.0	0.8093214853153121	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
12	1	0	-0.35693443984814044	0.0	0.0	-0.09581196796876795	-0.16716435063559665	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
13	1	0	-0.35693443984814044	1.0	2.0	3.246526416143475	1.75500630588542e-15	1	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
14	1	0	-0.21838523349088937	0.0	2.0	4.842489666860551	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
15	1	0	-0.21838523349088937	1.0	0.0	2.853304498150284	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
16	1	0	-0.14911063031226382	0.0	0.0	0.46590320451047	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
17	1	0	-0.14911063031226382	1.0	0.0	1.3995430372585675	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0		0
18	1	0	-0.11447332872295105	0.0	0.0	-0.050001566603731326	0.2573716747581173	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
19	1	0	-0.07983602713363827	0.0	0.0	0.010674320652888538	-0.3949641691395407	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
20	1	0	-0.07983602713363827	1.0	0.0	0.9850238615410454	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
21	1	0	-0.010561423955012732	0.0	0.0	-0.09581196796876795	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
22	1	0	-0.010561423955012732	0.0	0.0	-0.049224216696793235	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0		0
23	1	0	-0.010561423955012732	0.0	0.0	0.4233086890618074	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
24	1	0	-0.010561423955012732	1.0	2.0	3.246526416143475	-0.30177333429701814	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
25	1	0	3.39772125921244e-15	0.0	0.0	-0.787972844009535	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
26	1	0	3.39772125921244e-15	0.0	0.0	-0.787972844009535	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
27	1	0	3.39772125921244e-15	0.0	0.0	-0.787972844009535	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0		0
28	1	0	3.39772125921244e-15	0.0	0.0	-0.097808585880424	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0		0
29	1	0	3.39772125921244e-15	0.0	0.0	-0.09581196796876795	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
30	1	0	3.39772125921244e-15	0.0	0.0	-0.08117010328329018	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
31	1	0	3.39772125921244e-15	0.0	0.0	-0.08117010328329018	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
32	1	0	3.39772125921244e-15	0.0	0.0	-0.08117010328329018	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
33	1	0	3.39772125921244e-15	0.0	0.0	-0.050001566603731326	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
34	1	0	3.39772125921244e-15	0.0	0.0	-0.050001566603731326	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
35	1	0	3.39772125921244e-15	0.0	0.0	0.029197610558625683	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0		0
36	1	0	3.39772125921244e-15	0.0	0.0	0.03729589280830266	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0		0
37	1	0	3.39772125921244e-15	0.0	0.0	0.14378218142995913	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
38	1	0	3.39772125921244e-15	0.0	0.0	0.2662414133448641	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	0		0
39	1	0	3.39772125921244e-15	0.0	0.0	0.3407818153800236	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0		0
40	1	0	3.39772125921244e-15	0.0	0.0	0.5431057637611709	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
41	1	0	3.39772125921244e-15	0.0	0.0	0.5926884419006297	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
42	1	0	3.39772125921244e-15	0.0	0.0	0.5963489080719993	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
43	1	0	3.39772125921244e-15	0.0	0.0	5.116138131360485	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0		0
44	1	0	3.39772125921244e-15	0.0	0.0	5.269100360651063	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0		0
45	1	0	0.058713179223612806	0.0	0.0	0.5563047392358252	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
46	1	0	0.058713179223612806	1.0	0.0	0.5963489080719993	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	1	0	0	0	0	0	0		0
47	1	0	0.16262508399155112	0.0	0.0	4.842489666860551	-1.2336816827222439	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0		0
48	1	0	0.1972623855808639	0.0	0.0	-0.6548649832324644	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0		0
49	1	0	0.1972623855808639	0.0	0.0	-0.08117010328329018	-0.5709913016198611	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	1	0	0	0	0	0	0	0		0
50	1	0	0.4050861951167405	0.0	0.0	0.05537726461625993	1.75500630588542e-15	1	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0		0
51	1	0	0.4050861951167405	0.0	0.0	0.2802177387264565	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0		1
52	1	0	0.4050861951167405	0.0	0.0	1.2150795016364875	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0		0
53	1	0	0.4050861951167405	1.0	0.0	1.3111381204448684	0.08134454227779687	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
54	1	0	0.47436079829536604	0.0	1.0	0.0026878490062643007	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
55	1	0	0.47436079829536604	1.0	0.0	0.6256326374429547	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
56	1	0	0.47436079829536604	1.0	1.0	1.425831839762039	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
57	1	0	0.5436354014739916	0.0	0.0	-0.787972844009535	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
58	1	0	0.5436354014739916	0.0	1.0	3.2974401728907043	-0.17751888784032135	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0		1
59	1	0	0.6129100046526171	0.0	0.0	-0.787972844009535	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
60	1	0	0.6129100046526171	0.0	0.0	0.0026878490062643007	-0.3224824087064676	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	1	0		0
61	1	0	0.6129100046526171	1.0	0.0	1.1097006704164962	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0		0
62	1	0	0.6821846078312427	0.0	0.0	-0.787972844009535	-0.5606367644151363	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	1	0	0	0	0	0		0
63	1	0	0.6821846078312427	0.0	0.0	-0.050001566603731326	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
64	1	0	0.7514592110098682	0.0	0.0	0.023985106730595597	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
65	1	0	0.7514592110098682	1.0	0.0	0.5926884419006297	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
66	1	0	0.8207338141884938	0.0	0.0	-0.08117010328329018	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
67	1	0	0.8207338141884938	0.0	0.0	0.34344397259556503	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
68	1	0	0.8207338141884938	1.0	0.0	0.5963489080719993	-1.3061634431553169	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0		0
69	1	0	0.9592830205457449	2.0	0.0	1.6079686499777357	0.6819077001518312	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	1	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
70	1	0	1.0285576237243703	0.0	0.0	-0.08117010328329018	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
71	1	0	1.0285576237243703	0.0	0.0	0.15709296750766621	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
72	1	0	1.0285576237243703	1.0	0.0	1.4342628916636586	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0		0
73	1	0	1.0631949253136832	0.0	0.0	-0.029258037580232644	0.019217319049448497	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
74	1	0	1.0978322269029959	0.0	0.0	-0.09581196796876795	-0.8712728805568782	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	0	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
75	1	0	1.0978322269029959	0.0	0.0	1.2150795016364875	1.3238890068447644	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	1	0	0	0		0
76	1	0	1.0978322269029959	0.0	0.0	1.3204556706992634	1.75500630588542e-15	0	1	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	...	1	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	1	0	0	0	0		0
77	1	0	1.0978322269029959	1.0	0.0	0.8406018325979238	1.75500630588542e-15	0	1	0	0