website_user_action_logs
  • Project Information
    Project Name
    ホテル比較サイトのログ解析
    Dataframe Name
    access_log
    Created By
    sugiaki _
    Created Date
    1/31/2020 5:26:04 PM UTC
    Updated Date
    1/31/2020 5:26:04 PM UTC
    Desktop Version
    5.4.1.4
    Schedule
    Scheduling is not supported because:
    • No Data Source to Refresh
  
  
Sampledata Accessdata Weblogs
session_id
Character
8cf2da4e913bc44a4cde0575ead5744e (388)
8cf2da4e913bc44a4cde0575ead5744e: 388 (0.22%)
bb90c7e67037c65468ef4a1aaa6d7db1 (275)
bb90c7e67037c65468ef4a1aaa6d7db1: 275 (0.16%)
7e2e88958fea1f4b9437bc1ef8ebae8c (273)
7e2e88958fea1f4b9437bc1ef8ebae8c: 273 (0.15%)
52a6360cbc7a72d2514e591e916511c2 (247)
52a6360cbc7a72d2514e591e916511c2: 247 (0.14%)
70f5fc3d9d3ac9590235ed7aaf51c061 (239)
70f5fc3d9d3ac9590235ed7aaf51c061: 239 (0.14%)
420e6b8168bf1fee826225545fe65288 (235)
420e6b8168bf1fee826225545fe65288: 235 (0.13%)
(Other) (175,177)
(Other) : 175,177 (99.06%)
Not NA: 100.00%
NA0 (0.00%)
Unique Values11,103
Min Length32
Max Length32
date_time
POSIXct
Not NA: 100.00%
NA0 (0.00%)
Min2010-05-13 00:00:03
Max2010-05-18 23:59:58
Median2010-05-16 09:51:40
Average2010-05-16 05:03:03
hits_no
Integer
Not NA: 100.00%
NA0 (0.00%)
Min1
Max388
Median11
Average19.88
Std Dev27.09
elapsed_time_sec
Numeric
Not NA: 100.00%
NA0 (0.00%)
Min0
Max10,817
Median118
Average218.1
Std Dev435.37
action_tag
Character
ShowList (77,419)
ShowList : 77,419 (43.78%)
DoSearch (62,180)
DoSearch : 62,180 (35.16%)
ShowDetail (20,154)
ShowDetail : 20,154 (11.40%)
SearchStart (17,081)
SearchStart: 17,081 (9.66%)
Not NA: 100.00%
NA0 (0.00%)
Unique Values4
Min Length8
Max Length11
url_params
Character
?sort=LowPrice (16,697)
?sort=LowPrice : 16,697 (9.44%)
?sort=LowPrice&region=Hawaii (7,736)
?sort=LowPrice®ion=Hawaii : 7,736 (4.37%)
?sort=LowPrice&region=Europe (4,723)
?sort=LowPrice®ion=Europe : 4,723 (2.67%)
?sort=LowPrice&region=Asia (4,085)
?sort=LowPrice®ion=Asia : 4,085 (2.31%)
?sort=LowPrice&region=Hawaii&country=Oahu (3,393)
?sort=LowPrice®ion=Hawaii&country=Oahu: 3,393 (1.92%)
(Other) (120,046)
(Other) : 120,046 (67.89%)
Not NA: 88.60%
NA: 11.40%
NA20,154 (11.40%)
Unique Values5,505
Min Length14
Max Length94
6 Columns   176,834 Rows
6 Columns   176,834 Rows
Description

ホテル比較サイトのユーザーのサイト回遊データ。

Data Dictionary
Column Name
Description
session_id
date_time
hits_no
elapsed_time_sec
action_tag
url_params
Other Information
Size
19M bytes
Type
CSV - Local
Details
Parameter
Value
File
access_log.csv
Folder
/committed_data
First Row as Header
FALSE
Encoding
SHIFT_JIS
dataDisplayName
/Users/aki/.exploratory/projects/______________bnr8arW0/committed_data/access_log.csv