Character
日本 (47)
日本: 47 (100.00%)
Not NA: 100.00%
NA0 (0.00%)
Unique Values1
Min Length2
Max Length2
都道府県
Character
三重県 (1)
三重県: 1 (2.13%)
京都府 (1)
京都府: 1 (2.13%)
佐賀県 (1)
佐賀県: 1 (2.13%)
兵庫県 (1)
兵庫県: 1 (2.13%)
北海道 (1)
北海道: 1 (2.13%)
千葉県 (1)
千葉県: 1 (2.13%)
(Others) (41)
(Others): 41 (87.23%)
Not NA: 100.00%
NA0 (0.00%)
Unique Values47
Min Length3
Max Length4
2020-01-13
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min100
Max100
Median100
Average100
Std Dev0.00
2020-01-14
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min85.5
Max124.98
Median99.53
Average100.75
Std Dev8.34
2020-01-15
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min88.48
Max125.13
Median101.86
Average104.02
Std Dev7.73
2020-01-16
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min91.31
Max144.64
Median113.44
Average114.93
Std Dev13.03
2020-01-17
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min107
Max229
Median151.3
Average152.5
Std Dev23.05
2020-01-18
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min125.6
Max209.3
Median164.9
Average163.1
Std Dev17.72
2020-01-19
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min96.66
Max121.64
Median107.71
Average108.11
Std Dev5.95
2020-01-20
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min89.48
Max137.53
Median105.59
Average106.78
Std Dev10.50
2020-01-21
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min91.69
Max132.74
Median104.67
Average107.87
Std Dev10.59
2020-01-22
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min82.97
Max129.67
Median102.34
Average102.68
Std Dev11.28
2020-01-23
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min94.51
Max146.42
Median110.7
Average112.32
Std Dev9.93
2020-01-24
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min121.3
Max227.4
Median157.8
Average157.3
Std Dev17.11
2020-01-25
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min125.5
Max242.1
Median163.1
Average164.3
Std Dev21.79
2020-01-26
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min83.83
Max143.96
Median102.7
Average105.24
Std Dev11.19
2020-01-27
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min71.6
Max145.7
Median101.2
Average102
Std Dev14.38
2020-01-28
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min86.97
Max150.49
Median105.85
Average108.4
Std Dev12.83
2020-01-29
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min90.45
Max187.51
Median109.74
Average112.31
Std Dev16.32
2020-01-30
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min84.71
Max147.15
Median110.38
Average112.61
Std Dev11.63
2020-01-31
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min106.1
Max218.4
Median152.8
Average153.4
Std Dev19.75
2020-02-01
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min123.3
Max275
Median161.2
Average163.5
Std Dev29.21
2020-02-02
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min96.9
Max183.9
Median117.7
Average119.8
Std Dev15.13
2020-02-03
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min101.1
Max187.2
Median118.7
Average122
Std Dev16.53
2020-02-04
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min94.4
Max195.5
Median116.8
Average121.4
Std Dev18.01
2020-02-05
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min90.32
Max173.4
Median117.05
Average118.9
Std Dev17.08
2020-02-06
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min96.63
Max168.93
Median119.13
Average122.84
Std Dev16.90
2020-02-07
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min122.1
Max264.2
Median154.9
Average158.1
Std Dev24.85
2020-02-08
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min132.7
Max333.7
Median180.8
Average186.7
Std Dev37.52
2020-02-09
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min106.6
Max207.6
Median129.2
Average134.8
Std Dev19.83
2020-02-10
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min118.9
Max226.9
Median148.1
Average151
Std Dev20.06
2020-02-11
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min96.54
Max185.39
Median123.15
Average128.21
Std Dev15.96
2020-02-12
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min94.1
Max190.4
Median127
Average129.7
Std Dev17.68
2020-02-13
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min92.24
Max179.91
Median131.06
Average134.28
Std Dev18.75
2020-02-14
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min124.2
Max219.7
Median163.3
Average164
Std Dev22.97
2020-02-15
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min108.5
Max233.9
Median152.6
Average156.7
Std Dev29.67
2020-02-16
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min93.47
Max171.95
Median124.6
Average126.44
Std Dev14.03
2020-02-17
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min92.37
Max181.67
Median126.01
Average128.05
Std Dev17.41
2020-02-18
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min100.8
Max194.2
Median130.4
Average132.8
Std Dev18.46
2020-02-19
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min103
Max188.4
Median132.4
Average133.8
Std Dev18.29
2020-02-20
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min105.3
Max184.3
Median134.9
Average138.9
Std Dev18.82
2020-02-21
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min100.8
Max228.9
Median165.5
Average163.2
Std Dev27.56
2020-02-22
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min121.8
Max290.6
Median188.8
Average194.7
Std Dev39.94
2020-02-23
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min114.4
Max261.4
Median172.5
Average177.1
Std Dev35.86
2020-02-24
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min105.1
Max217.5
Median141.8
Average146.7
Std Dev27.88
2020-02-25
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min92.4
Max192.9
Median131.6
Average132.6
Std Dev23.51
2020-02-26
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min94.78
Max184.43
Median126.42
Average128.14
Std Dev20.84
2020-02-27
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min88.67
Max162.02
Median119.96
Average120.49
Std Dev17.48
2020-02-28
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min73.84
Max169.4
Median126.5
Average124.65
Std Dev19.12
2020-02-29
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min61.64
Max183
Median137.78
Average135.58
Std Dev20.41
2020-03-01
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min70.56
Max159.5
Median127.95
Average127.39
Std Dev21.10
2020-03-02
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min75.68
Max188.03
Median139.24
Average137.67
Std Dev21.68
2020-03-03
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min77.32
Max173.39
Median132.03
Average129.16
Std Dev23.72
2020-03-04
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min68.22
Max176.53
Median132.71
Average132.6
Std Dev20.78
2020-03-05
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min71.51
Max180.81
Median140.2
Average140.32
Std Dev21.34
2020-03-06
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min77.22
Max195.95
Median143.73
Average143.02
Std Dev21.41
2020-03-07
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min72.69
Max183.37
Median137.14
Average134.48
Std Dev27.38
2020-03-08
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min78.44
Max203.63
Median149.08
Average148.49
Std Dev25.49
2020-03-09
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min77.31
Max206.79
Median137.01
Average134.74
Std Dev24.96
2020-03-10
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min75.68
Max198.48
Median154.29
Average154.39
Std Dev24.97
2020-03-11
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min83.94
Max228.41
Median166.1
Average166.86
Std Dev29.62
2020-03-12
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min80.16
Max204.77
Median164.08
Average157.45
Std Dev23.38
2020-03-13
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min83.67
Max189.29
Median145.21
Average144.39
Std Dev27.11
2020-03-14
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min84.32
Max194.58
Median156.47
Average153.78
Std Dev22.60
2020-03-15
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min83.92
Max194.03
Median143.15
Average145.49
Std Dev22.05
2020-03-16
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min89.69
Max250.38
Median161.14
Average160.54
Std Dev28.22
2020-03-17
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min96.16
Max256.77
Median170.26
Average166.15
Std Dev27.30
2020-03-18
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min97.43
Max246.75
Median169.75
Average169.19
Std Dev28.49
2020-03-19
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min90.95
Max217.88
Median168.8
Average167.94
Std Dev26.01
2020-03-20
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min99.63
Max267.56
Median179.29
Average183.67
Std Dev32.63
2020-03-21
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min98.79
Max219.34
Median167.2
Average166.53
Std Dev24.63
2020-03-22
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min94.37
Max226.87
Median167.62
Average164.84
Std Dev25.18
2020-03-23
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min91.37
Max227.1
Median165.18
Average164.91
Std Dev26.07
2020-03-24
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min106.2
Max252.2
Median176.7
Average174.3
Std Dev28.39
2020-03-25
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min109.1
Max257.6
Median172.4
Average172.8
Std Dev28.22
2020-03-26
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min105
Max207.1
Median148.9
Average151.3
Std Dev24.25
2020-03-27
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min76.62
Max215.52
Median147.6
Average143.42
Std Dev25.98
2020-03-28
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min39.56
Max202.96
Median139.87
Average139.56
Std Dev37.94
2020-03-29
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min71.29
Max228.31
Median145.39
Average149.84
Std Dev31.58
2020-03-30
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min76.4
Max211.8
Median143.8
Average146.9
Std Dev30.15
2020-03-31
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min66.71
Max187.83
Median136.63
Average132.83
Std Dev26.24
2020-04-01
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min70.03
Max206.32
Median139.65
Average139
Std Dev29.82
2020-04-02
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min72.94
Max199.28
Median138.67
Average141.26
Std Dev28.23
2020-04-03
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min73.92
Max194.34
Median138.64
Average137.9
Std Dev26.92
2020-04-04
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min53.77
Max193.16
Median127.42
Average122.78
Std Dev27.52
2020-04-05
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min63.07
Max174.1
Median125.44
Average124.45
Std Dev25.64
2020-04-06
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min60.73
Max204.58
Median124.89
Average124.31
Std Dev30.75
2020-04-07
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min55.64
Max182.85
Median123.9
Average120.49
Std Dev30.07
2020-04-08
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min53.91
Max163.62
Median111.43
Average110.52
Std Dev26.19
2020-04-09
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min49.08
Max186.25
Median104.45
Average103.89
Std Dev24.58
2020-04-10
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min49.35
Max163.93
Median104.92
Average103.25
Std Dev23.72
2020-04-11
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min32.61
Max139.44
Median83.16
Average80.39
Std Dev22.29
2020-04-12
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min29.88
Max127.42
Median72.26
Average74.02
Std Dev21.74
2020-04-13
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min42.4
Max148.78
Median90.22
Average90.63
Std Dev21.43
2020-04-14
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min47.39
Max133.55
Median99.21
Average96.66
Std Dev19.34
2020-04-15
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min47.21
Max148.78
Median95.27
Average94.29
Std Dev20.28
2020-04-16
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min40.73
Max157.5
Median84.52
Average85.61
Std Dev20.27
2020-04-17
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min31.16
Max113.88
Median70.67
Average71.26
Std Dev20.80
2020-04-18
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min38.16
Max125.06
Median80.71
Average80.74
Std Dev17.59
2020-04-19
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min31.94
Max103.68
Median73.07
Average72.15
Std Dev14.87
356 Columns   47 Rows
356 Columns   47 Rows
# Set libPaths.
.libPaths("/Users/takato/.exploratory/R/4.4")

# Load required packages.
library(janitor)
library(lubridate)
library(hms)
library(tidyr)
library(stringr)
library(readr)
library(cpp11)
library(forcats)
library(RcppRoll)
library(dplyr)
library(tibble)
library(bit64)
library(zipangu)
library(exploratory)
library(crayon)

# Steps to produce the output
 exploratory::read_parquet_file("/Users/takato/.exploratory/projects/Excel_series_Cwe6Nfl4/data/jDV9fbB7.parquet") %>%
  exploratory::clean_data_frame()