Created
May 3, 2021 18:48
-
-
Save albinkjellin/ea6fdc33277549dee68961f8a3bf3eea to your computer and use it in GitHub Desktop.
Sample Scan Output as JSON
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "measurements":[ | |
| { | |
| "metric":"schema", | |
| "value":[ | |
| { | |
| "name":"productid", | |
| "type":"character varying" | |
| }, | |
| { | |
| "name":"productname", | |
| "type":"character varying" | |
| }, | |
| { | |
| "name":"productcategory", | |
| "type":"character varying" | |
| }, | |
| { | |
| "name":"size", | |
| "type":"integer" | |
| }, | |
| { | |
| "name":"weight", | |
| "type":"numeric" | |
| }, | |
| { | |
| "name":"purchaseprice", | |
| "type":"numeric" | |
| }, | |
| { | |
| "name":"sellingprice", | |
| "type":"numeric" | |
| }, | |
| { | |
| "name":"amountinstock", | |
| "type":"integer" | |
| }, | |
| { | |
| "name":"manufacturer", | |
| "type":"character varying" | |
| } | |
| ] | |
| }, | |
| { | |
| "metric":"row_count", | |
| "value":279 | |
| }, | |
| { | |
| "metric":"values_count", | |
| "value":279, | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"valid_count", | |
| "value":279, | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"avg_length", | |
| "value":36.0, | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"min_length", | |
| "value":36, | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"max_length", | |
| "value":36, | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"values_count", | |
| "value":279, | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"valid_count", | |
| "value":279, | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"avg_length", | |
| "value":13.405017921146953, | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"min_length", | |
| "value":3, | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"max_length", | |
| "value":28, | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"values_count", | |
| "value":265, | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"valid_count", | |
| "value":265, | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"avg_length", | |
| "value":6.547169811320755, | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"min_length", | |
| "value":4, | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"max_length", | |
| "value":11, | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"values_count", | |
| "value":279, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"valid_count", | |
| "value":268, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"min", | |
| "value":1, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"max", | |
| "value":95, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"avg", | |
| "value":48.776119402985074, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"sum", | |
| "value":13072, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"variance", | |
| "value":695.0583039856896, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"stddev", | |
| "value":26.363958427855433, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"values_count", | |
| "value":279, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"valid_count", | |
| "value":279, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"min", | |
| "value":2.2, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"max", | |
| "value":49.98, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"avg", | |
| "value":26.391827956989246, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"sum", | |
| "value":7363.32, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"variance", | |
| "value":192.36885743792064, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"stddev", | |
| "value":13.869710070434804, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"values_count", | |
| "value":279, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"valid_count", | |
| "value":279, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"min", | |
| "value":21.48, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"max", | |
| "value":598.46, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"avg", | |
| "value":314.1169534050179, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"sum", | |
| "value":87638.63, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"variance", | |
| "value":28566.88104859854, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"stddev", | |
| "value":169.017398656465, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"values_count", | |
| "value":279, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"valid_count", | |
| "value":279, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"min", | |
| "value":16.37, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"max", | |
| "value":718.15, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"avg", | |
| "value":371.9779211469534, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"sum", | |
| "value":103781.84, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"variance", | |
| "value":42228.218057533326, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"stddev", | |
| "value":205.495056041583, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"values_count", | |
| "value":279, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"valid_count", | |
| "value":279, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"min", | |
| "value":0, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"max", | |
| "value":199, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"avg", | |
| "value":49.85304659498208, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"sum", | |
| "value":13909, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"variance", | |
| "value":3894.4711327712025, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"stddev", | |
| "value":62.40569791910994, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"values_count", | |
| "value":279, | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"valid_count", | |
| "value":279, | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"avg_length", | |
| "value":16.433691756272403, | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"min_length", | |
| "value":7, | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"max_length", | |
| "value":31, | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"missing_percentage", | |
| "value":0.0, | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"missing_count", | |
| "value":0, | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"values_percentage", | |
| "value":100.0, | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"invalid_percentage", | |
| "value":0.0, | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"invalid_count", | |
| "value":0, | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"valid_percentage", | |
| "value":100.0, | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"missing_percentage", | |
| "value":0.0, | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"missing_count", | |
| "value":0, | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"values_percentage", | |
| "value":100.0, | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"invalid_percentage", | |
| "value":0.0, | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"invalid_count", | |
| "value":0, | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"valid_percentage", | |
| "value":100.0, | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"missing_percentage", | |
| "value":5.017921146953405, | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"missing_count", | |
| "value":14, | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"values_percentage", | |
| "value":94.9820788530466, | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"invalid_percentage", | |
| "value":0.0, | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"invalid_count", | |
| "value":0, | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"valid_percentage", | |
| "value":94.9820788530466, | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"missing_percentage", | |
| "value":0.0, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"missing_count", | |
| "value":0, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"values_percentage", | |
| "value":100.0, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"invalid_percentage", | |
| "value":3.942652329749104, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"invalid_count", | |
| "value":11, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"valid_percentage", | |
| "value":96.05734767025089, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"missing_percentage", | |
| "value":0.0, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"missing_count", | |
| "value":0, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"values_percentage", | |
| "value":100.0, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"invalid_percentage", | |
| "value":0.0, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"invalid_count", | |
| "value":0, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"valid_percentage", | |
| "value":100.0, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"missing_percentage", | |
| "value":0.0, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"missing_count", | |
| "value":0, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"values_percentage", | |
| "value":100.0, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"invalid_percentage", | |
| "value":0.0, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"invalid_count", | |
| "value":0, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"valid_percentage", | |
| "value":100.0, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"missing_percentage", | |
| "value":0.0, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"missing_count", | |
| "value":0, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"values_percentage", | |
| "value":100.0, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"invalid_percentage", | |
| "value":0.0, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"invalid_count", | |
| "value":0, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"valid_percentage", | |
| "value":100.0, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"missing_percentage", | |
| "value":0.0, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"missing_count", | |
| "value":0, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"values_percentage", | |
| "value":100.0, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"invalid_percentage", | |
| "value":0.0, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"invalid_count", | |
| "value":0, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"valid_percentage", | |
| "value":100.0, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"missing_percentage", | |
| "value":0.0, | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"missing_count", | |
| "value":0, | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"values_percentage", | |
| "value":100.0, | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"invalid_percentage", | |
| "value":0.0, | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"invalid_count", | |
| "value":0, | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"valid_percentage", | |
| "value":100.0, | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"distinct", | |
| "value":279, | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"unique_count", | |
| "value":279, | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"duplicate_count", | |
| "value":0, | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"uniqueness", | |
| "value":100.0, | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"mins", | |
| "value":[ | |
| "01bd328a-a1aa-11eb-ac84-1e00da0c4374", | |
| "01bd3a3c-a1aa-11eb-ac84-1e00da0c4374", | |
| "01bd3e7e-a1aa-11eb-ac84-1e00da0c4374", | |
| "01bd42a2-a1aa-11eb-ac84-1e00da0c4374", | |
| "01bd4536-a1aa-11eb-ac84-1e00da0c4374" | |
| ], | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"maxs", | |
| "value":[ | |
| "f3a4a930-a1a9-11eb-b0cf-1e00da0c4374", | |
| "f3a4a6ba-a1a9-11eb-b0cf-1e00da0c4374", | |
| "f3a4a2f0-a1a9-11eb-b0cf-1e00da0c4374", | |
| "f3a49f26-a1a9-11eb-b0cf-1e00da0c4374", | |
| "f3a499f4-a1a9-11eb-b0cf-1e00da0c4374" | |
| ], | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"frequent_values", | |
| "value":[ | |
| { | |
| "value":"01bd8b9a-a1aa-11eb-ac84-1e00da0c4374", | |
| "frequency":1 | |
| }, | |
| { | |
| "value":"01bda594-a1aa-11eb-ac84-1e00da0c4374", | |
| "frequency":1 | |
| }, | |
| { | |
| "value":"01bd770e-a1aa-11eb-ac84-1e00da0c4374", | |
| "frequency":1 | |
| }, | |
| { | |
| "value":"f3a456d8-a1a9-11eb-b0cf-1e00da0c4374", | |
| "frequency":1 | |
| }, | |
| { | |
| "value":"01bd5ee0-a1aa-11eb-ac84-1e00da0c4374", | |
| "frequency":1 | |
| } | |
| ], | |
| "columnName":"productid" | |
| }, | |
| { | |
| "metric":"distinct", | |
| "value":210, | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"unique_count", | |
| "value":177, | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"duplicate_count", | |
| "value":33, | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"uniqueness", | |
| "value":75.17985611510791, | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"mins", | |
| "value":[ | |
| "Awesome Chair", | |
| "Awesome Cotton Ball", | |
| "Awesome Mouse", | |
| "Awesome Soft Salad", | |
| "Awesome Wooden Mouse" | |
| ], | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"maxs", | |
| "value":[ | |
| "Wooden Towels", | |
| "Wooden Chips", | |
| "Wooden Cheese", | |
| "Wooden Bacon", | |
| "Used Steel Ball" | |
| ], | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"frequent_values", | |
| "value":[ | |
| { | |
| "value":"Electric Guitar", | |
| "frequency":14 | |
| }, | |
| { | |
| "value":"Chips", | |
| "frequency":7 | |
| }, | |
| { | |
| "value":"Sausages", | |
| "frequency":7 | |
| }, | |
| { | |
| "value":"Chair", | |
| "frequency":6 | |
| }, | |
| { | |
| "value":"Gloves", | |
| "frequency":5 | |
| } | |
| ], | |
| "columnName":"productname" | |
| }, | |
| { | |
| "metric":"distinct", | |
| "value":22, | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"unique_count", | |
| "value":0, | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"duplicate_count", | |
| "value":22, | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"uniqueness", | |
| "value":7.954545454545454, | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"mins", | |
| "value":[ | |
| "Automotive", | |
| "Baby", | |
| "Beauty", | |
| "Books", | |
| "Clothing" | |
| ], | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"maxs", | |
| "value":[ | |
| "Toys", | |
| "Tools", | |
| "Sports", | |
| "Shoes", | |
| "Outdoors" | |
| ], | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"frequent_values", | |
| "value":[ | |
| { | |
| "value":"Grocery", | |
| "frequency":20 | |
| }, | |
| { | |
| "value":"Home", | |
| "frequency":17 | |
| }, | |
| { | |
| "value":"Beauty", | |
| "frequency":17 | |
| }, | |
| { | |
| "value":"Industrial", | |
| "frequency":17 | |
| }, | |
| { | |
| "value":"Health", | |
| "frequency":15 | |
| } | |
| ], | |
| "columnName":"productcategory" | |
| }, | |
| { | |
| "metric":"distinct", | |
| "value":90, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"unique_count", | |
| "value":20, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"duplicate_count", | |
| "value":70, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"uniqueness", | |
| "value":33.333333333333336, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"mins", | |
| "value":[ | |
| 1, | |
| 2, | |
| 3, | |
| 4, | |
| 5 | |
| ], | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"maxs", | |
| "value":[ | |
| 95, | |
| 94, | |
| 93, | |
| 91, | |
| 90 | |
| ], | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"frequent_values", | |
| "value":[ | |
| { | |
| "value":47, | |
| "frequency":7 | |
| }, | |
| { | |
| "value":34, | |
| "frequency":7 | |
| }, | |
| { | |
| "value":65, | |
| "frequency":7 | |
| }, | |
| { | |
| "value":88, | |
| "frequency":6 | |
| }, | |
| { | |
| "value":80, | |
| "frequency":6 | |
| } | |
| ], | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"distinct", | |
| "value":269, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"unique_count", | |
| "value":259, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"duplicate_count", | |
| "value":10, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"uniqueness", | |
| "value":96.40287769784173, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"mins", | |
| "value":[ | |
| 2.2, | |
| 2.35, | |
| 2.57, | |
| 2.69, | |
| 2.81 | |
| ], | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"maxs", | |
| "value":[ | |
| 49.98, | |
| 49.96, | |
| 49.85, | |
| 49.46, | |
| 49.4 | |
| ], | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"frequent_values", | |
| "value":[ | |
| { | |
| "value":39.14, | |
| "frequency":2 | |
| }, | |
| { | |
| "value":8.15, | |
| "frequency":2 | |
| }, | |
| { | |
| "value":12.83, | |
| "frequency":2 | |
| }, | |
| { | |
| "value":19.62, | |
| "frequency":2 | |
| }, | |
| { | |
| "value":43.5, | |
| "frequency":2 | |
| } | |
| ], | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"distinct", | |
| "value":276, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"unique_count", | |
| "value":273, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"duplicate_count", | |
| "value":3, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"uniqueness", | |
| "value":98.92086330935251, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"mins", | |
| "value":[ | |
| 21.48, | |
| 21.93, | |
| 23.31, | |
| 24.61, | |
| 27.48 | |
| ], | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"maxs", | |
| "value":[ | |
| 598.46, | |
| 598.17, | |
| 596.25, | |
| 589.8, | |
| 589.74 | |
| ], | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"frequent_values", | |
| "value":[ | |
| { | |
| "value":89.24, | |
| "frequency":2 | |
| }, | |
| { | |
| "value":589.3, | |
| "frequency":2 | |
| }, | |
| { | |
| "value":549.1, | |
| "frequency":2 | |
| }, | |
| { | |
| "value":436.13, | |
| "frequency":1 | |
| }, | |
| { | |
| "value":532.51, | |
| "frequency":1 | |
| } | |
| ], | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"distinct", | |
| "value":276, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"unique_count", | |
| "value":273, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"duplicate_count", | |
| "value":3, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"uniqueness", | |
| "value":98.92086330935251, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"mins", | |
| "value":[ | |
| 16.37, | |
| 19.17, | |
| 25.78, | |
| 26.32, | |
| 27.97 | |
| ], | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"maxs", | |
| "value":[ | |
| 718.15, | |
| 717.8, | |
| 715.5, | |
| 707.76, | |
| 707.69 | |
| ], | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"frequent_values", | |
| "value":[ | |
| { | |
| "value":707.16, | |
| "frequency":2 | |
| }, | |
| { | |
| "value":107.09, | |
| "frequency":2 | |
| }, | |
| { | |
| "value":658.92, | |
| "frequency":2 | |
| }, | |
| { | |
| "value":555.58, | |
| "frequency":1 | |
| }, | |
| { | |
| "value":230.11, | |
| "frequency":1 | |
| } | |
| ], | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"distinct", | |
| "value":93, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"unique_count", | |
| "value":57, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"duplicate_count", | |
| "value":36, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"uniqueness", | |
| "value":33.093525179856115, | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"mins", | |
| "value":[ | |
| 0, | |
| 1, | |
| 2, | |
| 3, | |
| 4 | |
| ], | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"maxs", | |
| "value":[ | |
| 199, | |
| 197, | |
| 194, | |
| 193, | |
| 192 | |
| ], | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"frequent_values", | |
| "value":[ | |
| { | |
| "value":12, | |
| "frequency":18 | |
| }, | |
| { | |
| "value":9, | |
| "frequency":16 | |
| }, | |
| { | |
| "value":13, | |
| "frequency":15 | |
| }, | |
| { | |
| "value":2, | |
| "frequency":15 | |
| }, | |
| { | |
| "value":11, | |
| "frequency":13 | |
| } | |
| ], | |
| "columnName":"amountinstock" | |
| }, | |
| { | |
| "metric":"distinct", | |
| "value":275, | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"unique_count", | |
| "value":271, | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"duplicate_count", | |
| "value":4, | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"uniqueness", | |
| "value":98.56115107913669, | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"mins", | |
| "value":[ | |
| "Aguilar-Bryant", | |
| "Alexander, Taylor and Hahn", | |
| "Allen, Perez and Campos", | |
| "Anderson Group", | |
| "Anderson, Kidd and Smith" | |
| ], | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"maxs", | |
| "value":[ | |
| "Young-Rhodes", | |
| "Young, Sims and Wilkinson", | |
| "Young, Roberts and Mills", | |
| "Wright-Esparza", | |
| "Wright, Stanton and Adkins" | |
| ], | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"frequent_values", | |
| "value":[ | |
| { | |
| "value":"Butler Ltd", | |
| "frequency":2 | |
| }, | |
| { | |
| "value":"Patterson PLC", | |
| "frequency":2 | |
| }, | |
| { | |
| "value":"Burton and Sons", | |
| "frequency":2 | |
| }, | |
| { | |
| "value":"Smith-Johnson", | |
| "frequency":2 | |
| }, | |
| { | |
| "value":"Johnson-Wong", | |
| "frequency":1 | |
| } | |
| ], | |
| "columnName":"manufacturer" | |
| }, | |
| { | |
| "metric":"histogram", | |
| "value":{ | |
| "boundaries":[ | |
| 1.0, | |
| 5.7, | |
| 10.4, | |
| 15.1, | |
| 19.8, | |
| 24.5, | |
| 29.2, | |
| 33.9, | |
| 38.6, | |
| 43.3, | |
| 48.0, | |
| 52.7, | |
| 57.4, | |
| 62.1, | |
| 66.8, | |
| 71.5, | |
| 76.2, | |
| 80.9, | |
| 85.6, | |
| 90.3, | |
| 95.0 | |
| ], | |
| "frequencies":[ | |
| 11, | |
| 9, | |
| 14, | |
| 9, | |
| 18, | |
| 11, | |
| 17, | |
| 21, | |
| 11, | |
| 12, | |
| 15, | |
| 14, | |
| 10, | |
| 14, | |
| 13, | |
| 15, | |
| 15, | |
| 13, | |
| 19, | |
| 7 | |
| ] | |
| }, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"histogram", | |
| "value":{ | |
| "boundaries":[ | |
| 1.0, | |
| 5.7, | |
| 10.4, | |
| 15.1, | |
| 19.8, | |
| 24.5, | |
| 29.2, | |
| 33.9, | |
| 38.6, | |
| 43.3, | |
| 48.0, | |
| 52.7, | |
| 57.4, | |
| 62.1, | |
| 66.8, | |
| 71.5, | |
| 76.2, | |
| 80.9, | |
| 85.6, | |
| 90.3, | |
| 95.0 | |
| ], | |
| "frequencies":[ | |
| 11, | |
| 9, | |
| 14, | |
| 9, | |
| 18, | |
| 11, | |
| 17, | |
| 21, | |
| 11, | |
| 12, | |
| 15, | |
| 14, | |
| 10, | |
| 14, | |
| 13, | |
| 15, | |
| 15, | |
| 13, | |
| 19, | |
| 7 | |
| ] | |
| }, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"histogram", | |
| "value":{ | |
| "boundaries":[ | |
| 2.2, | |
| 4.589, | |
| 6.978, | |
| 9.367, | |
| 11.756, | |
| 14.145, | |
| 16.534, | |
| 18.923, | |
| 21.312, | |
| 23.701, | |
| 26.09, | |
| 28.479, | |
| 30.868, | |
| 33.257, | |
| 35.646, | |
| 38.035, | |
| 40.424, | |
| 42.813, | |
| 45.202, | |
| 47.591, | |
| 49.98 | |
| ], | |
| "frequencies":[ | |
| 17, | |
| 10, | |
| 13, | |
| 16, | |
| 13, | |
| 11, | |
| 8, | |
| 17, | |
| 25, | |
| 11, | |
| 11, | |
| 12, | |
| 18, | |
| 14, | |
| 7, | |
| 21, | |
| 15, | |
| 10, | |
| 13, | |
| 17 | |
| ] | |
| }, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"histogram", | |
| "value":{ | |
| "boundaries":[ | |
| 1.0, | |
| 5.7, | |
| 10.4, | |
| 15.1, | |
| 19.8, | |
| 24.5, | |
| 29.2, | |
| 33.9, | |
| 38.6, | |
| 43.3, | |
| 48.0, | |
| 52.7, | |
| 57.4, | |
| 62.1, | |
| 66.8, | |
| 71.5, | |
| 76.2, | |
| 80.9, | |
| 85.6, | |
| 90.3, | |
| 95.0 | |
| ], | |
| "frequencies":[ | |
| 11, | |
| 9, | |
| 14, | |
| 9, | |
| 18, | |
| 11, | |
| 17, | |
| 21, | |
| 11, | |
| 12, | |
| 15, | |
| 14, | |
| 10, | |
| 14, | |
| 13, | |
| 15, | |
| 15, | |
| 13, | |
| 19, | |
| 7 | |
| ] | |
| }, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"histogram", | |
| "value":{ | |
| "boundaries":[ | |
| 2.2, | |
| 4.589, | |
| 6.978, | |
| 9.367, | |
| 11.756, | |
| 14.145, | |
| 16.534, | |
| 18.923, | |
| 21.312, | |
| 23.701, | |
| 26.09, | |
| 28.479, | |
| 30.868, | |
| 33.257, | |
| 35.646, | |
| 38.035, | |
| 40.424, | |
| 42.813, | |
| 45.202, | |
| 47.591, | |
| 49.98 | |
| ], | |
| "frequencies":[ | |
| 17, | |
| 10, | |
| 13, | |
| 16, | |
| 13, | |
| 11, | |
| 8, | |
| 17, | |
| 25, | |
| 11, | |
| 11, | |
| 12, | |
| 18, | |
| 14, | |
| 7, | |
| 21, | |
| 15, | |
| 10, | |
| 13, | |
| 17 | |
| ] | |
| }, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"histogram", | |
| "value":{ | |
| "boundaries":[ | |
| 21.48, | |
| 50.329, | |
| 79.178, | |
| 108.027, | |
| 136.876, | |
| 165.725, | |
| 194.574, | |
| 223.423, | |
| 252.272, | |
| 281.121, | |
| 309.97, | |
| 338.819, | |
| 367.668, | |
| 396.517, | |
| 425.366, | |
| 454.215, | |
| 483.064, | |
| 511.913, | |
| 540.762, | |
| 569.611, | |
| 598.46 | |
| ], | |
| "frequencies":[ | |
| 9, | |
| 14, | |
| 22, | |
| 9, | |
| 18, | |
| 16, | |
| 8, | |
| 16, | |
| 17, | |
| 11, | |
| 8, | |
| 16, | |
| 12, | |
| 12, | |
| 15, | |
| 18, | |
| 11, | |
| 18, | |
| 15, | |
| 14 | |
| ] | |
| }, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"histogram", | |
| "value":{ | |
| "boundaries":[ | |
| 1.0, | |
| 5.7, | |
| 10.4, | |
| 15.1, | |
| 19.8, | |
| 24.5, | |
| 29.2, | |
| 33.9, | |
| 38.6, | |
| 43.3, | |
| 48.0, | |
| 52.7, | |
| 57.4, | |
| 62.1, | |
| 66.8, | |
| 71.5, | |
| 76.2, | |
| 80.9, | |
| 85.6, | |
| 90.3, | |
| 95.0 | |
| ], | |
| "frequencies":[ | |
| 11, | |
| 9, | |
| 14, | |
| 9, | |
| 18, | |
| 11, | |
| 17, | |
| 21, | |
| 11, | |
| 12, | |
| 15, | |
| 14, | |
| 10, | |
| 14, | |
| 13, | |
| 15, | |
| 15, | |
| 13, | |
| 19, | |
| 7 | |
| ] | |
| }, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"histogram", | |
| "value":{ | |
| "boundaries":[ | |
| 2.2, | |
| 4.589, | |
| 6.978, | |
| 9.367, | |
| 11.756, | |
| 14.145, | |
| 16.534, | |
| 18.923, | |
| 21.312, | |
| 23.701, | |
| 26.09, | |
| 28.479, | |
| 30.868, | |
| 33.257, | |
| 35.646, | |
| 38.035, | |
| 40.424, | |
| 42.813, | |
| 45.202, | |
| 47.591, | |
| 49.98 | |
| ], | |
| "frequencies":[ | |
| 17, | |
| 10, | |
| 13, | |
| 16, | |
| 13, | |
| 11, | |
| 8, | |
| 17, | |
| 25, | |
| 11, | |
| 11, | |
| 12, | |
| 18, | |
| 14, | |
| 7, | |
| 21, | |
| 15, | |
| 10, | |
| 13, | |
| 17 | |
| ] | |
| }, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"histogram", | |
| "value":{ | |
| "boundaries":[ | |
| 21.48, | |
| 50.329, | |
| 79.178, | |
| 108.027, | |
| 136.876, | |
| 165.725, | |
| 194.574, | |
| 223.423, | |
| 252.272, | |
| 281.121, | |
| 309.97, | |
| 338.819, | |
| 367.668, | |
| 396.517, | |
| 425.366, | |
| 454.215, | |
| 483.064, | |
| 511.913, | |
| 540.762, | |
| 569.611, | |
| 598.46 | |
| ], | |
| "frequencies":[ | |
| 9, | |
| 14, | |
| 22, | |
| 9, | |
| 18, | |
| 16, | |
| 8, | |
| 16, | |
| 17, | |
| 11, | |
| 8, | |
| 16, | |
| 12, | |
| 12, | |
| 15, | |
| 18, | |
| 11, | |
| 18, | |
| 15, | |
| 14 | |
| ] | |
| }, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"histogram", | |
| "value":{ | |
| "boundaries":[ | |
| 16.37, | |
| 51.459, | |
| 86.548, | |
| 121.637, | |
| 156.726, | |
| 191.815, | |
| 226.904, | |
| 261.993, | |
| 297.082, | |
| 332.171, | |
| 367.26, | |
| 402.349, | |
| 437.438, | |
| 472.527, | |
| 507.616, | |
| 542.705, | |
| 577.794, | |
| 612.883, | |
| 647.972, | |
| 683.061, | |
| 718.15 | |
| ], | |
| "frequencies":[ | |
| 10, | |
| 13, | |
| 22, | |
| 10, | |
| 16, | |
| 11, | |
| 17, | |
| 13, | |
| 12, | |
| 17, | |
| 8, | |
| 15, | |
| 12, | |
| 13, | |
| 14, | |
| 18, | |
| 10, | |
| 19, | |
| 15, | |
| 14 | |
| ] | |
| }, | |
| "columnName":"sellingprice" | |
| }, | |
| { | |
| "metric":"histogram", | |
| "value":{ | |
| "boundaries":[ | |
| 1.0, | |
| 5.7, | |
| 10.4, | |
| 15.1, | |
| 19.8, | |
| 24.5, | |
| 29.2, | |
| 33.9, | |
| 38.6, | |
| 43.3, | |
| 48.0, | |
| 52.7, | |
| 57.4, | |
| 62.1, | |
| 66.8, | |
| 71.5, | |
| 76.2, | |
| 80.9, | |
| 85.6, | |
| 90.3, | |
| 95.0 | |
| ], | |
| "frequencies":[ | |
| 11, | |
| 9, | |
| 14, | |
| 9, | |
| 18, | |
| 11, | |
| 17, | |
| 21, | |
| 11, | |
| 12, | |
| 15, | |
| 14, | |
| 10, | |
| 14, | |
| 13, | |
| 15, | |
| 15, | |
| 13, | |
| 19, | |
| 7 | |
| ] | |
| }, | |
| "columnName":"size" | |
| }, | |
| { | |
| "metric":"histogram", | |
| "value":{ | |
| "boundaries":[ | |
| 2.2, | |
| 4.589, | |
| 6.978, | |
| 9.367, | |
| 11.756, | |
| 14.145, | |
| 16.534, | |
| 18.923, | |
| 21.312, | |
| 23.701, | |
| 26.09, | |
| 28.479, | |
| 30.868, | |
| 33.257, | |
| 35.646, | |
| 38.035, | |
| 40.424, | |
| 42.813, | |
| 45.202, | |
| 47.591, | |
| 49.98 | |
| ], | |
| "frequencies":[ | |
| 17, | |
| 10, | |
| 13, | |
| 16, | |
| 13, | |
| 11, | |
| 8, | |
| 17, | |
| 25, | |
| 11, | |
| 11, | |
| 12, | |
| 18, | |
| 14, | |
| 7, | |
| 21, | |
| 15, | |
| 10, | |
| 13, | |
| 17 | |
| ] | |
| }, | |
| "columnName":"weight" | |
| }, | |
| { | |
| "metric":"histogram", | |
| "value":{ | |
| "boundaries":[ | |
| 21.48, | |
| 50.329, | |
| 79.178, | |
| 108.027, | |
| 136.876, | |
| 165.725, | |
| 194.574, | |
| 223.423, | |
| 252.272, | |
| 281.121, | |
| 309.97, | |
| 338.819, | |
| 367.668, | |
| 396.517, | |
| 425.366, | |
| 454.215, | |
| 483.064, | |
| 511.913, | |
| 540.762, | |
| 569.611, | |
| 598.46 | |
| ], | |
| "frequencies":[ | |
| 9, | |
| 14, | |
| 22, | |
| 9, | |
| 18, | |
| 16, | |
| 8, | |
| 16, | |
| 17, | |
| 11, | |
| 8, | |
| 16, | |
| 12, | |
| 12, | |
| 15, | |
| 18, | |
| 11, | |
| 18, | |
| 15, | |
| 14 | |
| ] | |
| }, | |
| "columnName":"purchaseprice" | |
| }, | |
| { | |
| "metric":"histogram", | |
| "value":{ | |
| "boundaries":[ | |
| 16.37, | |
| 51.459, | |
| 86.548, | |
| 121.637, | |
| 156.726, | |
| 191.815, | |
| 226.904, | |
| 261.993, | |
| 297.082, | |
| 332.171, | |
| 367.26, | |
| 402.349, | |
| 437.438, | |
| 472.527, | |
| 507.616, | |
| 542.705, | |
| 577.794, | |
| 612.883, | |
| 647.972, | |
| 683.061, | |
| 718.15 | |
| ], | |
| "frequencies":[ | |
| 10, | |
| 13, | |
| 22, | |
| 10, | |
| 16, | |
| 11, | |
| 17, | |
| 13, | |
| 12, | |
| 17, | |
| 8, | |
| 15, | |
| 12, | |
| 13, | |
| 14, | |
| 18, | |
| 10, | |
| 19, | |
| 15, | |
| 14 | |
| ] | |
| }, | |
| "columnName":"sellingprice" | |
| } | |
| ], | |
| "testResults":[ | |
| { | |
| "id":"{\"expression\":\"row_count > 0\"}", | |
| "title":"test(row_count > 0)", | |
| "description":"test(row_count > 0)", | |
| "expression":"row_count > 0", | |
| "passed":true, | |
| "values":{ | |
| "row_count":279 | |
| } | |
| }, | |
| { | |
| "id":"{\"column\":\"productid\",\"expression\":\"invalid_percentage == 0\"}", | |
| "title":"column(productid) test(invalid_percentage == 0)", | |
| "description":"column(productid) test(invalid_percentage == 0)", | |
| "expression":"invalid_percentage == 0", | |
| "columnName":"productid", | |
| "passed":true, | |
| "values":{ | |
| "invalid_percentage":0.0 | |
| } | |
| }, | |
| { | |
| "id":"{\"column\":\"productcategory\",\"expression\":\"missing_count < 10\"}", | |
| "title":"column(productcategory) test(missing_count < 10)", | |
| "description":"column(productcategory) test(missing_count < 10)", | |
| "expression":"missing_count < 10", | |
| "columnName":"productcategory", | |
| "passed":false, | |
| "values":{ | |
| "missing_count":14 | |
| } | |
| }, | |
| { | |
| "id":"{\"column\":\"size\",\"expression\":\"invalid_percentage < 5\"}", | |
| "title":"column(size) test(invalid_percentage < 5)", | |
| "description":"column(size) test(invalid_percentage < 5)", | |
| "expression":"invalid_percentage < 5", | |
| "columnName":"size", | |
| "passed":true, | |
| "values":{ | |
| "invalid_percentage":3.942652329749104 | |
| } | |
| } | |
| ], | |
| "errors":[ | |
| ] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment