# ---
# title: All ls output csv format files
# ---
files <-
list.files(
path = "C:/zz/data/filesystem",
pattern = "*csv",
full.names = TRUE,
recursive = FALSE
)
lapply(files, function(x) {
print(x)
df <- read.csv(x,header=FALSE)
print(names(df))
print(summary(df))
for (c in 1:ncol(df))
print(head (table(df[c]), 5))
rm(df)
})
## [1] "C:/zz/data/filesystem/ls_debian_192.168.1.70 .csv"
## [1] "V1" "V2" "V3" "V4" "V5" "V6" "V7" "V8" "V9" "V10"
## V1 V2 V3 V4
## 4026531959: 412 0 :50566 -rw-r--r--:44452 Min. :1
## 4026531960: 412 8 :35598 -r--r--r--:33671 1st Qu.:1
## 4026531968: 412 16 : 5812 -rw-rw-r--:13561 Median :1
## 4026531972: 412 24 : 3070 -r--r-----: 3370 Mean :1
## 4026531973: 412 32 : 1815 -r--------: 3129 3rd Qu.:1
## 4026531974: 412 40 : 1188 -rw-rw-rw-: 2568 Max. :3
## (Other) :102371 (Other): 6794 (Other) : 4092 NA's :76
## V5 V6 V7
## : 76 root :97216 Min. :0.000e+00
## bitnami :24211 daemon : 6974 1st Qu.:0.000e+00
## daemon : 90 bitnami: 550 Median :4.290e+02
## mysql : 2 : 76 Mean :1.343e+09
## root :80459 adm : 8 3rd Qu.:3.530e+03
## systemd-network : 4 shadow : 5 Max. :1.407e+14
## systemd-timesync: 1 (Other): 14 NA's :76
## V8 V9
## : 76 15:36:54.4157032510: 1084
## 2019-11-19: 1073 15:36:54.0041313210: 993
## 2020-03-31:52987 15:36:54.4117031440: 789
## 2020-04-04:50707 15:36:54.9801306490: 749
## 15:36:54.0356398070: 709
## 15:36:54.1638587650: 707
## (Other) :99812
## V10
## : 76
## /opt/bitnami/apache2/var/cache/mod_pagespeed/v3/192.168.1.70/http: 38
## /sys/fs/cgroup/cpu : 18
## /sys/devices/pci0000:00/0000:00:05.0/0-0:STAC9700 : 10
## /sys/fs/cgroup/net_cls : 9
## /bin/bash : 1
## (Other) :104691
##
## 10 100 1000 10000 10001
## 8 5 1 1 1
##
## 0 10056 1016 1024
## 28 50566 1 3 4
##
## ---------- --w------- --w--w---- --w--w--w-
## 76 2 838 18 1
##
## 1 2 3
## 104752 12 3
##
## bitnami daemon mysql root
## 76 24211 90 2 80459
##
## adm bitnami crontab daemon
## 76 8 550 1 6974
##
## 0 1 2 3 4
## 44273 20 2 2 9
##
## 2019-11-19 2020-03-31 2020-04-04
## 76 1073 52987 50707
##
## 09:15:29.9359939550 09:15:31.6159859700 09:15:33.3330013570
## 76 6 2 2
## 09:15:33.7890013600
## 2
##
## /bin/bash /bin/bunzip2 /bin/bzcat /bin/bzdiff
## 76 1 1 1 1
## [1] "C:/zz/data/filesystem/ls_debian_192.168.1.71 .csv"
## [1] "V1" "V2" "V3" "V4" "V5" "V6" "V7" "V8" "V9" "V10"
## V1 V2 V3 V4
## 4026531959: 412 0 :50509 -rw-r--r--:34714 1 :85765
## 4026531960: 412 8 :19561 -r--r--r--:33691 : 151
## 4026531968: 412 16 : 4094 -rw-rw-r--: 4976 2 : 12
## 4026531972: 412 24 : 2608 -r--r-----: 3370 3 : 3
## 4026531973: 412 32 : 1614 -r--------: 3096 26_locale=user: 2
## 4026531974: 412 40 : 1109 -rwxr-xr-x: 2173 26context=edit: 1
## (Other) :83464 (Other): 6441 (Other) : 3916 (Other) : 2
## V5 V6 V7 V8
## root :80309 root :80372 0 :44184 : 155
## bitnami : 5266 daemon : 5119 4096 : 6209 2019-11-19: 1075
## daemon : 198 bitnami: 262 10408 : 202 2020-02-19:33872
## : 153 : 155 : 155 2020-04-04:50833
## systemd-network: 4 adm : 8 60 : 143 2Cparent : 1
## 26_locale=user : 2 shadow : 5 173 : 135
## (Other) : 4 (Other): 15 (Other):34908
## V9
## 14:36:11.3344010820: 883
## 14:36:11.3384009550: 775
## 14:36:11.3304012090: 740
## 14:36:11.3264013360: 735
## 14:36:11.3184015910: 716
## 14:36:11.3224014630: 595
## (Other) :81492
## V10
## : 156
## /opt/bitnami/apache2/var/cache/mod_pagespeed/v3/192.168.1.71/http: 118
## /sys/fs/cgroup/cpu : 18
## /sys/devices/pci0000:00/0000:00:05.0/0-0:STAC9700 : 10
## /sys/fs/cgroup/net_cls : 9
## /bin/bash : 1
## (Other) :85624
##
## 10 100 1000 10000 1001
## 8 4 1 1 1
##
## 0 1000 10056 1016
## 28 50509 1 1 2
##
## ---------- --w------- --w--w---- --w--w--w-
## 54 2 838 18 1
##
## 1 2 26_locale=user 26context=edit
## 151 85765 12 2 1
##
## 26_locale=user 26order=asc bitnami daemon
## 153 2 1 5266 198
##
## 26_fields=id adm bitnami crontab
## 155 1 8 262 1
##
## 0 1 10 100
## 155 44184 18 1 12
##
## 2019-11-19 2020-02-19 2020-04-04 2Cparent
## 155 1075 33872 50833 1
##
## 09:47:41.8599948620 09:47:43.2959899930 09:47:44.4519754600
## 155 6 2 1
## 09:47:44.6723797340
## 1
##
## /bin/bash /bin/bunzip2 /bin/bzcat /bin/bzdiff
## 156 1 1 1 1
## [1] "C:/zz/data/filesystem/ls_debian_192.168.1.73 .csv"
## [1] "V1" "V2" "V3" "V4" "V5" "V6" "V7" "V8" "V9" "V10"
## V1 V2 V3 V4
## 4026531959: 178 0 :26828 -rw-r--r--:28626 Min. :1
## 4026531960: 178 8 :13837 -r--r--r--:17290 1st Qu.:1
## 4026531968: 178 16 : 2984 -r--r-----: 1498 Median :1
## 4026531972: 178 24 : 1934 -r--------: 1459 Mean :1
## 4026531973: 178 32 : 1181 -rwxr-xr-x: 1363 3rd Qu.:1
## 4026531974: 178 40 : 831 -rw-rw-rw-: 969 Max. :3
## (Other) :51203 (Other): 4676 (Other) : 1066 NA's :38
## V5 V6 V7
## : 38 root :45880 Min. :0.000e+00
## bitnami : 307 bitnami-admins: 4310 1st Qu.:0.000e+00
## daemon : 1 mysql : 1710 Median :7.160e+02
## mysql : 6020 bitnami : 306 Mean :2.694e+09
## root :45900 : 38 3rd Qu.:4.096e+03
## systemd-network : 4 adm : 8 Max. :1.407e+14
## systemd-timesync: 1 (Other) : 19 NA's :38
## V8 V9
## : 38 21:16:13.6572395280: 155
## 2019-11-19: 78 21:16:13.5972476320: 153
## 2020-03-25:25114 21:16:13.6612389870: 152
## 2020-04-04:27041 12:58:04.6252192450: 150
## 21:16:13.6012470910: 150
## 21:16:13.6172449300: 149
## (Other) :51362
## V10
## : 38
## /sys/fs/cgroup/cpu : 18
## /sys/devices/pci0000:00/0000:00:05.0/0-0:STAC9700: 10
## /sys/fs/cgroup/net_cls : 9
## /bin/bash : 1
## /bin/bunzip2 : 1
## (Other) :52194
##
## 10 100 1000 10000 10001
## 8 5 2 1 1
##
## 0 1016 1024 1032
## 28 26828 2 1 3
##
## ---------- --w------- --w--w---- --w--w--w-
## 38 2 604 18 1
##
## 1 2 3
## 52218 12 3
##
## bitnami daemon mysql root
## 38 307 1 6020 45900
##
## adm bitnami bitnami-admins crontab
## 38 8 306 4310 1
##
## 0 1 2 3 4
## 20535 13 3 1 7
##
## 2019-11-19 2020-03-25 2020-04-04
## 38 78 25114 27041
##
## 10:33:24.8639946100 10:33:25.5439994460 10:33:25.5479993960
## 38 6 50 46
## 10:33:25.5519993460
## 45
##
## /bin/bash /bin/bunzip2 /bin/bzcat /bin/bzdiff
## 38 1 1 1 1
## [1] "C:/zz/data/filesystem/ls_wdlpc_192.168.56.1 192.168.1.69 0.0.0.0 .csv"
## [1] "V1" "V2" "V3" "V4" "V5" "V6" "V7" "V8" "V9" "V10"
## V1 V2 V3 V4 V5
## Min. :5.629e+14 Min. : 0 -rw-r--r--:11 Min. :1 zzz8y9:15
## 1st Qu.:1.126e+15 1st Qu.: 0 -rwxr-xr-x: 4 1st Qu.:1
## Median :2.252e+15 Median : 2 Median :1
## Mean :4.654e+15 Mean : 1469 Mean :1
## 3rd Qu.:5.489e+15 3rd Qu.: 8 3rd Qu.:1
## Max. :1.745e+16 Max. :21968 Max. :1
##
## V6 V7 V8 V9
## None:15 Min. : 0 2020-04-05:15 15:03:24.3209855000:1
## 1st Qu.: 0 15:03:24.3700668000:1
## Median : 204 15:03:24.4116891000:1
## Mean : 750941 15:03:24.4457949000:1
## 3rd Qu.: 1706 15:10:17.5191006000:1
## Max. :11247533 15:16:12.1209869000:1
## (Other) :9
## V10
## /home/zzz8y9/.bash_profile :1
## /home/zzz8y9/.bashrc :1
## /home/zzz8y9/.inputrc :1
## /home/zzz8y9/.profile :1
## /home/zzz8y9/.ssh/known_hosts :1
## /home/zzz8y9/servers/wdlmedia/csv/cron_bash_wdlpc.csv:1
## (Other) :9
##
## 562949953779205 844424930487461 844424930487462 844424930487463
## 1 1 1 1
## 1407374883908770
## 1
##
## 0 2 8 16 21968
## 6 3 3 2 1
##
## -rw-r--r-- -rwxr-xr-x
## 11 4
## 1
## 15
## zzz8y9
## 15
## None
## 15
##
## 0 101 204 245 1236
## 6 1 1 1 1
## 2020-04-05
## 15
##
## 15:03:24.3209855000 15:03:24.3700668000 15:03:24.4116891000 15:03:24.4457949000
## 1 1 1 1
## 15:10:17.5191006000
## 1
##
## /home/zzz8y9/.bash_profile /home/zzz8y9/.bashrc
## 1 1
## /home/zzz8y9/.inputrc /home/zzz8y9/.profile
## 1 1
## /home/zzz8y9/.ssh/known_hosts
## 1
## [[1]]
## NULL
##
## [[2]]
## NULL
##
## [[3]]
## NULL
##
## [[4]]
## NULL