-
Notifications
You must be signed in to change notification settings - Fork 0
/
mappingfile.txt
106 lines (106 loc) · 2.26 KB
/
mappingfile.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
{
"search_table_name":"company",
"column_exists":{
"column_list":[
"countrycode",
"customerid",
"paperlessdate",
"invoicenumber",
"invoicedate",
"duedate",
"invoiceamount",
"disputed",
"settleddate",
"paperlessbill",
"daystosettle1",
"dayslate1"]
},
"column_mean_range":{
"column_list":[
"invoiceamount",
"daystosettle",
"dayslate"
],
"column_mean_max":[
55,
28,
5
],
"column_mean_min":[
35,
30,
5
]
},
"column_value_range":{
"column_list":[
"invoiceamount",
"daystosettle",
"dayslate"
],
"column_max_value":[
300,
100,
40
],
"column_min_value":[
3,
1,
1
]
},
"col_value_validation":{
"column_list":[
"customerid",
"paperlessbill",
"invoicedate"
],
"column_regex":[
"^[0-9]{4}[-][A-Z]{5}$",
"^(Paper|Electronics)$",
"^([0-9]{4}[-/]?((0[13-9]|1[012])[-/]?(0[1-9]|[12][0-9]|30)|(0[13578]|1[02])[-/]?31|02[-/]?(0[1-9]|1[0-9]|2[0-8]))|([0-9]{2}(([2468][048]|[02468][48])|[13579][26])|([13579][26]|[02468][048]|0[0-9]|1[0-6])00)[-/]?02[-/]?29)$"
]
},
"col_value_category":{
"column_list":[
"disputed",
"paperlessbill"
],
"column_set":{
"disputed":[
"No",
"Yes",
"dontknow"
],
"paperlessbill":[
"Paper",
"Electronic",
"Furniture"
]
}
},
"null_values_allowed":{
"column_list":[
"invoicenumber",
"invoicedate"
],
"max_allow_null_per":[
20,
30
]
},
"overall_null_values_allowed":0,
"source_target_dtype":{
"column_list":[
"invoicenumber",
"invoicedate",
"invoiceamount"
],
"col_dtype":[
"int",
"datetime",
"int"
]
},
"duplicate_rows_threshold":10
}