Documentation autogenerated using Great Expectations.

Table of Contents

Overview

Dataset info

Number of variables
22
Number of observations expect_table_row_count_to_be_between
1000
Missing cells
16.78%

Variable types

int
6
float
4
string
10
unknown
0
  • expect_column_values_to_be_in_type_list 22
  • expect_column_unique_value_count_to_be_between 22
  • expect_column_proportion_of_unique_values_to_be_between 22
  • expect_column_values_to_not_be_null 22
  • expect_column_values_to_be_in_set 22
  • expect_column_values_to_not_match_regex 10
  • expect_column_distinct_values_to_be_in_set 6
  • expect_column_min_to_be_between 5
  • expect_column_max_to_be_between 5
  • expect_column_mean_to_be_between 5
  • expect_column_median_to_be_between 5
  • expect_column_quantile_values_to_be_between 5
  • expect_column_kl_divergence_to_be_less_than 5
  • expect_column_stdev_to_be_between 4
  • expect_column_values_to_be_unique 2
  • expect_table_row_count_to_be_between 1
  • expect_table_columns_to_match_ordered_list 1

Record Type expect_column_to_exist

Type: string expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
3
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
0.3%
Missing (n) expect_column_values_to_not_be_null
0
Missing (%) expect_column_values_to_not_be_null
0.0%

Example Values expect_column_values_to_be_in_set

Skip Bounce Stopped_Voting_Or_Skipping

Value Counts expect_column_distinct_values_to_be_in_set

Skip ID expect_column_to_exist

Type: float expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
457
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
100.0%
Missing (n) expect_column_values_to_not_be_null
543
Missing (%) expect_column_values_to_not_be_null
54.3%

Example Values expect_column_values_to_be_in_set

2201887.0 2201888.0 2201889.0 2201891.0 2201892.0 2201893.0 2201894.0 2201895.0 2201896.0 2201897.0 2201898.0 2201899.0 2201900.0 2201901.0 2201902.0 2201903.0 2201904.0 2201905.0 2201906.0 2201907.0

Appearance ID expect_column_to_exist

Type: int expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
1000
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
100.0%
Missing (n) expect_column_values_to_not_be_null
0
Missing (%) expect_column_values_to_not_be_null
0.0%

Example Values expect_column_values_to_be_in_set

37852978 37852979 37852980 37852981 37852982 37852983 37852984 37853008 37853048 37853049 37853050 37853059 37853184 37853185 37853187 37853217 37853221 37853224 37853246 37853289

Session ID expect_column_to_exist

Type: int expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
544
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
54.4%
Missing (n) expect_column_values_to_not_be_null
0
Missing (%) expect_column_values_to_not_be_null
0.0%

Quantiles

0.05 expect_column_quantile_values_to_be_between
5709903
Q1 expect_column_quantile_values_to_be_between
5710070
Median expect_column_quantile_values_to_be_between expect_column_median_to_be_between
5710274
Q3 expect_column_quantile_values_to_be_between
5710371
0.95 expect_column_quantile_values_to_be_between
5710539

Statistics

Mean expect_column_mean_to_be_between
5710227.83
Minimum expect_column_min_to_be_between
5709837.00
Maximum expect_column_max_to_be_between
5710760.00

Histogram expect_column_kl_divergence_to_be_less_than

Example Values expect_column_values_to_be_in_set

5710282 5710194 5710029 5710292 5710274 5710296 5710371 5710540 5710295 5710120 5710142 5710345 5710448 5710559 5709899 5710083 5710329 5710477 5710110 5710202

Wikisurvey ID expect_column_to_exist

Type: int expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
1
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
0.1%
Missing (n) expect_column_values_to_not_be_null
0
Missing (%) expect_column_values_to_not_be_null
0.0%

Example Values expect_column_values_to_be_in_set

17066

Value Counts expect_column_distinct_values_to_be_in_set

Left Choice ID expect_column_to_exist

Type: int expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
57
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
5.7%
Missing (n) expect_column_values_to_not_be_null
0
Missing (%) expect_column_values_to_not_be_null
0.0%

Quantiles

0.05 expect_column_quantile_values_to_be_between
1019654
Q1 expect_column_quantile_values_to_be_between
1019663
Median expect_column_quantile_values_to_be_between expect_column_median_to_be_between
1019676
Q3 expect_column_quantile_values_to_be_between
1019687
0.95 expect_column_quantile_values_to_be_between
1019815

Statistics

Mean expect_column_mean_to_be_between
1019687.87
Minimum expect_column_min_to_be_between
1019653.00
Maximum expect_column_max_to_be_between
1019852.00

Histogram expect_column_kl_divergence_to_be_less_than

Example Values expect_column_values_to_be_in_set

1019690 1019663 1019653 1019654 1019668 1019687 1019688 1019666 1019667 1019681 1019656 1019691 1019672 1019675 1019676 1019677 1019678 1019682 1019680 1019686

Left Choice Text expect_column_to_exist

Type: string expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
54
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
5.6%
Missing (n) expect_column_values_to_not_be_null
32
Missing (%) expect_column_values_to_not_be_null
3.2%

Example Values expect_column_values_to_be_in_set

merge conflict master branch cleaned_df2_clean dag podcast kaggle scatterplot cleaned_df df untitled notebook SQL distribution bootstrap conference dataframe deployment repo random forest tensor tree

Right Choice ID expect_column_to_exist

Type: int expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
59
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
5.9%
Missing (n) expect_column_values_to_not_be_null
0
Missing (%) expect_column_values_to_not_be_null
0.0%

Quantiles

0.05 expect_column_quantile_values_to_be_between
1019654
Q1 expect_column_quantile_values_to_be_between
1019664
Median expect_column_quantile_values_to_be_between expect_column_median_to_be_between
1019677
Q3 expect_column_quantile_values_to_be_between
1019687
0.95 expect_column_quantile_values_to_be_between
1019818

Statistics

Mean expect_column_mean_to_be_between
1019689.13
Minimum expect_column_min_to_be_between
1019653.00
Maximum expect_column_max_to_be_between
1019852.00

Histogram expect_column_kl_divergence_to_be_less_than

Example Values expect_column_values_to_be_in_set

1019654 1019690 1019666 1019681 1019661 1019682 1019680 1019676 1019683 1019653 1019673 1019687 1019688 1019658 1019663 1019668 1019677 1019686 1019691 1019657

Right Choice Text expect_column_to_exist

Type: string expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
56
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
5.8%
Missing (n) expect_column_values_to_not_be_null
27
Missing (%) expect_column_values_to_not_be_null
2.7%

Example Values expect_column_values_to_be_in_set

podcast merge conflict untitled notebook df bootstrap list tensor bag kaggle repo cacophany dag scatterplot kernel master branch SQL cleaned_df2_clean deployment random forest excel sheet

Prompt ID expect_column_to_exist

Type: int expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
800
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
80.0%
Missing (n) expect_column_values_to_not_be_null
0
Missing (%) expect_column_values_to_not_be_null
0.0%

Quantiles

0.05 expect_column_quantile_values_to_be_between
38425799
Q1 expect_column_quantile_values_to_be_between
38426163
Median expect_column_quantile_values_to_be_between expect_column_median_to_be_between
38426684
Q3 expect_column_quantile_values_to_be_between
38427151
0.95 expect_column_quantile_values_to_be_between
38430611

Statistics

Mean expect_column_mean_to_be_between
38427230.42
Minimum expect_column_min_to_be_between
38425691.00
Maximum expect_column_max_to_be_between
38432042.00

Histogram expect_column_kl_divergence_to_be_less_than

Example Values expect_column_values_to_be_in_set

38426254 38426765 38425729 38425899 38425913 38425918 38425954 38426000 38426016 38426053 38426330 38426332 38426411 38426526 38426670 38426759 38426881 38427074 38427110 38427151

Reason expect_column_to_exist

Type: string expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
7
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
1.5%
Missing (n) expect_column_values_to_not_be_null
543
Missing (%) expect_column_values_to_not_be_null
54.3%

Example Values expect_column_values_to_be_in_set

dislike_both other dont_know_both like_both dont_know_left dont_know_right both_same

Value Counts expect_column_distinct_values_to_be_in_set

Created at expect_column_to_exist

Type: string expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
925
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
92.5%
Missing (n) expect_column_values_to_not_be_null
0
Missing (%) expect_column_values_to_not_be_null
0.0%

Example Values expect_column_values_to_be_in_set

2020-01-07 18:37:12 UTC 2020-01-07 17:42:29 UTC 2020-01-07 19:10:32 UTC 2020-01-07 14:20:09 UTC 2020-01-07 14:20:15 UTC 2020-01-07 15:37:35 UTC 2020-01-07 15:41:07 UTC 2020-01-07 15:44:21 UTC 2020-01-07 15:44:58 UTC 2020-01-07 15:45:00 UTC 2020-01-07 15:45:12 UTC 2020-01-07 15:50:47 UTC 2020-01-07 15:51:30 UTC 2020-01-07 15:51:53 UTC 2020-01-07 15:52:01 UTC 2020-01-07 15:52:05 UTC 2020-01-07 15:52:16 UTC 2020-01-07 15:52:38 UTC 2020-01-07 15:52:50 UTC 2020-01-07 15:53:24 UTC

Updated at expect_column_to_exist

Type: string expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
925
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
92.5%
Missing (n) expect_column_values_to_not_be_null
0
Missing (%) expect_column_values_to_not_be_null
0.0%

Example Values expect_column_values_to_be_in_set

2020-01-07 18:37:12 UTC 2020-01-07 17:42:29 UTC 2020-01-07 19:10:32 UTC 2020-01-07 14:20:09 UTC 2020-01-07 14:20:15 UTC 2020-01-07 15:37:35 UTC 2020-01-07 15:41:07 UTC 2020-01-07 15:44:21 UTC 2020-01-07 15:44:58 UTC 2020-01-07 15:45:00 UTC 2020-01-07 15:45:12 UTC 2020-01-07 15:50:47 UTC 2020-01-07 15:51:30 UTC 2020-01-07 15:51:53 UTC 2020-01-07 15:52:01 UTC 2020-01-07 15:52:05 UTC 2020-01-07 15:52:16 UTC 2020-01-07 15:52:38 UTC 2020-01-07 15:52:50 UTC 2020-01-07 15:53:24 UTC

Response Time (s) expect_column_to_exist

Type: float expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
447
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
97.8%
Missing (n) expect_column_values_to_not_be_null
543
Missing (%) expect_column_values_to_not_be_null
54.3%

Quantiles

0.05 expect_column_quantile_values_to_be_between
2.325
Q1 expect_column_quantile_values_to_be_between
3.3960000000000004
Median expect_column_quantile_values_to_be_between expect_column_median_to_be_between
4.961
Q3 expect_column_quantile_values_to_be_between
7.96
0.95 expect_column_quantile_values_to_be_between
19.511

Statistics

Mean expect_column_mean_to_be_between
7.16
Minimum expect_column_min_to_be_between
1.64
Maximum expect_column_max_to_be_between
126.56

Example Values expect_column_values_to_be_in_set

2.259 3.31 3.315 3.3160000000000003 3.3569999999999998 3.8680000000000003 3.909 4.021 4.107 9.068999999999999 3.1310000000000002 3.432 3.9189999999999996 4.255 4.44 4.507 4.57 4.961 6.0520000000000005 32.183

Missing Response Time Explanation expect_column_to_exist

Type: float expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
0
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
--
Missing (n) expect_column_values_to_not_be_null
1000
Missing (%) expect_column_values_to_not_be_null
100.0%

Example Values expect_column_values_to_be_in_set

Valid expect_column_to_exist

Type: bool expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
1
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
0.1%
Missing (n) expect_column_values_to_not_be_null
0
Missing (%) expect_column_values_to_not_be_null
0.0%

Example Values expect_column_values_to_be_in_set

True

Value Counts expect_column_distinct_values_to_be_in_set

Hashed IP Address expect_column_to_exist

Type: string expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
403
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
40.3%
Missing (n) expect_column_values_to_not_be_null
0
Missing (%) expect_column_values_to_not_be_null
0.0%

Example Values expect_column_values_to_be_in_set

d7a155b7566e66964b1524be97efbeba 86d86ee1f544a9cd5a6ce3a8dfe05fa0 7de801e390b443432b1ae6aa2bdadb13 dde75a930a1901039ad2be3db7810568 0731cccf02cc734756737a85e00d3256 e9b775624a2698c4d7f6f0c6b731d00f 7266862ad6e0ef7f17d64a225dda3ec1 4a24fd9f8309f184e2d6b043780aa1df ee348f0c4ba820ab877e57d99507e7b8 b3ad09347706d1984c16846e4036062a 4d980d20c27704f8161e825fc597702e a7515444efd0bdd8288509fcef837d38 ea8b72a9d8348c8126f35f265dd9f9e2 28091268f1173920a3fd4035b325efe9 709d4378e8efa6e3e7c2fe9823240321 71b5acb135192780948232998b97196c 7de3adab653e9d9b790c46aec39827a6 f87398fa68c930c8062ff578b8587401 f9a62dd09366081276a16fd0309751bf f744f2c551cfca875bbfd9b6efb949c4

URL Alias expect_column_to_exist

Type: string expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
1
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
0.1%
Missing (n) expect_column_values_to_not_be_null
0
Missing (%) expect_column_values_to_not_be_null
0.0%

Example Values expect_column_values_to_be_in_set

counter_for_data_scientists

Value Counts expect_column_distinct_values_to_be_in_set

User Agent expect_column_to_exist

Type: string expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
183
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
18.4%
Missing (n) expect_column_values_to_not_be_null
3
Missing (%) expect_column_values_to_not_be_null
0.3%

Example Values expect_column_values_to_be_in_set

  • Mozilla/5.0 (iPhone; CPU iPhone OS 13_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148
  • Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.88 Safari/537.36
  • Mozilla/5.0 (Linux; Android 10; Pixel 3 XL Build/QQ1A.191205.008; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/79.0.3945.93 Mobile Safari/537.36
  • Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.88 Safari/537.36
  • Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.88 Safari/537.36
  • Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:71.0) Gecko/20100101 Firefox/71.0
  • Mozilla/5.0 (iPhone; CPU iPhone OS 13_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.4 Mobile/15E148 Safari/604.1
  • Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.88 Safari/537.36
  • Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36
  • Mozilla/5.0 (Linux; Android 9; SM-G960U) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.93 Mobile Safari/537.36
  • Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:71.0) Gecko/20100101 Firefox/71.0
  • Mozilla/5.0 (Linux; Android 8.1.0) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/77.0.3865.92 Mobile Safari/537.36 DuckDuckGo/5
  • Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36
  • Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.88 Safari/537.36
  • Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:71.0) Gecko/20100101 Firefox/71.0
  • Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.88 Safari/537.36
  • Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.88 Safari/537.36
  • Mozilla/5.0 (iPhone; CPU iPhone OS 13_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/79.0.3945.73 Mobile/15E148 Safari/604.1
  • Mozilla/5.0 (Linux; Android 9; moto g(6) play Build/PPPS29.55-35-12-5; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/79.0.3945.93 Mobile Safari/537.36
  • Mozilla/5.0 (X11; Linux x86_64; rv:47.0) Gecko/20100101 Firefox/47.0

Referrer expect_column_to_exist

Type: string expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
24
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
2.4%
Missing (n) expect_column_values_to_not_be_null
0
Missing (%) expect_column_values_to_not_be_null
0.0%

Example Values expect_column_values_to_be_in_set

  • DIRECT_VISIT
  • REFERRER_NOT_FOUND
  • https://www.reddit.com/r/datasets/comments/elda2w/what_do_you_call_a_group_of_data_scientists/
  • http://allourideas.org/
  • https://www.reddit.com/
  • http://allourideas.org/counter_for_data_scientists/about
  • http://allourideas.org/counter_for_data_scientists
  • http://allourideas.org/counter_for_data_scientists/results
  • http://allourideas.org/counter_for_data_scientists/results?page=1
  • https://old.reddit.com/r/datasets/comments/elda2w/what_do_you_call_a_group_of_data_scientists/
  • https://t.co/zTNRT188xk?amp=1
  • https://old.reddit.com/r/Citrix+DataHoarder+Dell+EMC2+HyperV+ITManagers+ITdept+PowerShell+SCCM+SQLServer+Splunk+WindowsServer+bigdata+cyberlaws+datacenter+datahorder+devops+exchangeserver+microsoft+msp+netsec+networking+sharepoint+storage+sysadmintools+us
  • http://allourideas.org/counter_for_data_scientists/results?all=true
  • https://www.reddit.com/r/datascience/comments/eld2yp/what_do_you_call_a_group_of_data_scientists/
  • http://m.facebook.com/
  • https://www.reddit.com/r/datasets/comments/elda2w/what_do_you_call_a_group_of_data_scientists/?st=k54dwx8m&sh=c2910f09
  • http://www.allourideas.org/counter_for_data_scientists/admin
  • https://old.reddit.com/r/Python/
  • https://t.co/zTNRT188xk
  • https://www.reddit.com/r/datasets/

Widget expect_column_to_exist

Type: bool expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
1
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
0.1%
Missing (n) expect_column_values_to_not_be_null
0
Missing (%) expect_column_values_to_not_be_null
0.0%

Example Values expect_column_values_to_be_in_set

False

Value Counts expect_column_distinct_values_to_be_in_set

Info expect_column_to_exist

Type: float expect_column_values_to_be_of_type
expect_column_values_to_be_in_type_list

Properties

Distinct (n) expect_column_unique_value_count_to_be_between
0
Distinct (%) expect_column_proportion_of_unique_values_to_be_between
--
Missing (n) expect_column_values_to_not_be_null
1000
Missing (%) expect_column_values_to_not_be_null
100.0%

Example Values expect_column_values_to_be_in_set

Documentation autogenerated using Great Expectations.