curl --request GET \
--url https://api-dev.narrative.io/datasets/{dataset_id}/columns-stats \
--header 'Authorization: Bearer <token>'{
"advanced_statistics_metadata": {
"snapshot_range": {
"from_snapshot": null,
"until_snapshot": null,
"from_snapshot_timestamp": null,
"until_snapshot_timestamp": null
},
"configuration": {
"value_histogram": {
"columns": [
"firstName",
"secondName",
"firstChars",
"age"
]
},
"completeness": {
"columns": [
"firstName",
"secondName",
"firstChars",
"age"
]
},
"approx_count_distinct": {
"columns": [
"firstChars",
"age"
]
},
"count_distinct": {
"columns": [
"firstName",
"secondName"
]
},
"observed_types_histogram": {
"columns": [
"firstName"
]
},
"mean": {
"columns": [
"age"
]
},
"deviation": {
"columns": [
"age"
]
}
}
},
"columns_summary": [
{
"name": "age",
"type": "LONG",
"basic_statistics": {
"nan_value_count": null,
"null_value_count": 0,
"lower_bound": 22,
"upper_bound": 52,
"value_count": 60,
"column_store_bytes": 655
},
"advanced_statistics": {
"approx_count_distinct": 13,
"count_distinct": null,
"histogram": {
"values": {
"22": {
"absolute": 3,
"ratio": 0.0667
},
"25": {
"absolute": 3,
"ratio": 0.0667
},
"28": {
"absolute": 9,
"ratio": 0.2
},
"31": {
"absolute": 3,
"ratio": 0.0667
},
"32": {
"absolute": 3,
"ratio": 0.0667
},
"34": {
"absolute": 3,
"ratio": 0.0667
},
"36": {
"absolute": 3,
"ratio": 0.0667
},
"39": {
"absolute": 3,
"ratio": 0.0667
},
"40": {
"absolute": 3,
"ratio": 0.0667
},
"45": {
"absolute": 3,
"ratio": 0.0667
},
"47": {
"absolute": 3,
"ratio": 0.0667
},
"50": {
"absolute": 3,
"ratio": 0.0667
},
"52": {
"absolute": 3,
"ratio": 0.0667
}
},
"number_of_bins": 13
},
"mean": 35.8,
"standard_deviation": 9.064215354899726,
"completeness": 1,
"observed_types": null
}
}
]
}Get statistics for each column.
curl --request GET \
--url https://api-dev.narrative.io/datasets/{dataset_id}/columns-stats \
--header 'Authorization: Bearer <token>'{
"advanced_statistics_metadata": {
"snapshot_range": {
"from_snapshot": null,
"until_snapshot": null,
"from_snapshot_timestamp": null,
"until_snapshot_timestamp": null
},
"configuration": {
"value_histogram": {
"columns": [
"firstName",
"secondName",
"firstChars",
"age"
]
},
"completeness": {
"columns": [
"firstName",
"secondName",
"firstChars",
"age"
]
},
"approx_count_distinct": {
"columns": [
"firstChars",
"age"
]
},
"count_distinct": {
"columns": [
"firstName",
"secondName"
]
},
"observed_types_histogram": {
"columns": [
"firstName"
]
},
"mean": {
"columns": [
"age"
]
},
"deviation": {
"columns": [
"age"
]
}
}
},
"columns_summary": [
{
"name": "age",
"type": "LONG",
"basic_statistics": {
"nan_value_count": null,
"null_value_count": 0,
"lower_bound": 22,
"upper_bound": 52,
"value_count": 60,
"column_store_bytes": 655
},
"advanced_statistics": {
"approx_count_distinct": 13,
"count_distinct": null,
"histogram": {
"values": {
"22": {
"absolute": 3,
"ratio": 0.0667
},
"25": {
"absolute": 3,
"ratio": 0.0667
},
"28": {
"absolute": 9,
"ratio": 0.2
},
"31": {
"absolute": 3,
"ratio": 0.0667
},
"32": {
"absolute": 3,
"ratio": 0.0667
},
"34": {
"absolute": 3,
"ratio": 0.0667
},
"36": {
"absolute": 3,
"ratio": 0.0667
},
"39": {
"absolute": 3,
"ratio": 0.0667
},
"40": {
"absolute": 3,
"ratio": 0.0667
},
"45": {
"absolute": 3,
"ratio": 0.0667
},
"47": {
"absolute": 3,
"ratio": 0.0667
},
"50": {
"absolute": 3,
"ratio": 0.0667
},
"52": {
"absolute": 3,
"ratio": 0.0667
}
},
"number_of_bins": 13
},
"mean": 35.8,
"standard_deviation": 9.064215354899726,
"completeness": 1,
"observed_types": null
}
}
]
}Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Unique identifier for a dataset.
The maximum number of bins to return for the histograms.
OK
Show child attributes
{
"snapshot_range": {
"from_snapshot": null,
"until_snapshot": null,
"from_snapshot_timestamp": null,
"until_snapshot_timestamp": null
},
"configuration": {
"value_histogram": {
"columns": [
"firstName",
"secondName",
"firstChars",
"age"
]
},
"completeness": {
"columns": [
"firstName",
"secondName",
"firstChars",
"age"
]
},
"approx_count_distinct": { "columns": ["firstChars", "age"] },
"count_distinct": { "columns": ["firstName", "secondName"] },
"observed_types_histogram": { "columns": ["firstName"] },
"mean": { "columns": ["age"] },
"deviation": { "columns": ["age"] }
}
}Show child attributes