首页 > 试题广场 >

Nginx日志分析1-IP访问次数统计

[编程题]Nginx日志分析1-IP访问次数统计

热度指数：16345 时间限制：C/C++ 1秒，其他语言2秒空间限制：C/C++ 256M，其他语言512M
算法知识视频讲解

假设 Nginx 的日志存储在 nowcoder.txt 里，内容如下：

192.168.1.20 - - [21/Apr/2020:14:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.21 - - [21/Apr/2020:15:27:49 +0800] "GET /2/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.22 - - [21/Apr/2020:21:27:49 +0800] "GET /3/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.23 - - [21/Apr/2020:22:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.24 - - [22/Apr/2020:15:27:49 +0800] "GET /2/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.25 - - [22/Apr/2020:15:26:49 +0800] "GET /3/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.20 - - [23/Apr/2020:08:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.21 - - [23/Apr/2020:09:20:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.22 - - [23/Apr/2020:10:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.22 - - [23/Apr/2020:10:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.20 - - [23/Apr/2020:14:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.21 - - [23/Apr/2020:15:27:49 +0800] "GET /2/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.22 - - [23/Apr/2020:15:27:49 +0800] "GET /3/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.25 - - [23/Apr/2020:16:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.24 - - [23/Apr/2020:20:27:49 +0800] "GET /2/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.25 - - [23/Apr/2020:20:27:49 +0800] "GET /3/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.20 - - [23/Apr/2020:20:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.21 - - [23/Apr/2020:20:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.22 - - [23/Apr/2020:20:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.22 - - [23/Apr/2020:15:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.21 - - [23/Apr/2020:20:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"

现在需要编写 Shell 脚本统计出 2020 年 4 月 23 号访问 IP 的对应次数，并且按照次数降序排序。你的脚本应该输出：

5 192.168.1.22
4 192.168.1.21
3 192.168.1.20
2 192.168.1.25
1 192.168.1.24

输入描述:

输出描述:

示例1

输入

192.168.1.20 - - [21/Apr/2020:14:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.21 - - [21/Apr/2020:15:27:49 +0800] "GET /2/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.22 - - [21/Apr/2020:21:27:49 +0800] "GET /3/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.23 - - [21/Apr/2020:22:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.24 - - [22/Apr/2020:15:27:49 +0800] "GET /2/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.25 - - [22/Apr/2020:15:26:49 +0800] "GET /3/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.20 - - [23/Apr/2020:08:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.21 - - [23/Apr/2020:09:20:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.22 - - [23/Apr/2020:10:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.22 - - [23/Apr/2020:10:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.20 - - [23/Apr/2020:14:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.21 - - [23/Apr/2020:15:27:49 +0800] "GET /2/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.22 - - [23/Apr/2020:15:27:49 +0800] "GET /3/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.25 - - [23/Apr/2020:16:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.24 - - [23/Apr/2020:20:27:49 +0800] "GET /2/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.25 - - [23/Apr/2020:20:27:49 +0800] "GET /3/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.20 - - [23/Apr/2020:20:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.21 - - [23/Apr/2020:20:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.22 - - [23/Apr/2020:20:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.22 - - [23/Apr/2020:15:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"
192.168.1.21 - - [23/Apr/2020:20:27:49 +0800] "GET /1/index.php HTTP/1.1" 404 490 "-" "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0"

输出

5 192.168.1.22
4 192.168.1.21
3 192.168.1.20
2 192.168.1.25
1 192.168.1.24

算法知识视频讲解

查看答案及解析

bash

小小菜鸡鸟

grep "23/Apr/2020" |awk -F "- -" '{print $1}' | sort | uniq -c |sort -r

发表于 2024-06-16 20:44:36 回复(0)

bash

吃鸡是吃不到的

grep '23/Apr/2020' nowcoder.txt | awk '{print $1}' | sort | uniq -c | sort -nr | sed 's/^ *//g'

发表于 2023-08-17 21:09:28 回复(0)

bash

二两007

# 方法1：
grep '23/Apr/2020' nowcoder.txt | awk '{print $1}'   | sort  | uniq -c | sort -rk1 |awk '{print $1" "$2}'

# 方法2：
awk 'BEGIN{}{
    if(substr($4,2,11)=="23/Apr/2020"){
        dict[$1]++
    }
}END{
    for(each_ip in dict){
        printf("%d %s\n", dict[each_ip], each_ip)
    }
}' nowcoder.txt | sort -rk1

发表于 2023-03-21 22:10:35 回复(0)

Bash

牛客995180755号

grep+awk+sort

grep "23/Apr/2020" | awk -v FS=" - - " '{
    a[$1]++
}
END{
    for(i in a){
        print(a[i]" "i)
    }
}' | sort -nr

发表于 2022-08-27 22:11:42 回复(0)

Bash

执笔人丶

awk 'BEGIN{} /23.Apr/ {a[$1]++}END{for(i in a){print a[i],i}}' nowcoder.txt | sort -r

发表于 2022-08-24 09:41:38 回复(0)

Bash

久梦柒

grep "23/Apr/2020" nowcoder.txt|awk '{ip[$1]++}END{for(i in ip) {print ip[i],i}}'|sort -k1 -rn

发表于 2022-08-22 16:31:50 回复(0)

Bash

牛客357957991号

awk '/23\/Apr\/2020/{a[$1]++}END{for(i in a) print a[i],i}' nowcoder.txt |sort -r

发表于 2022-07-21 15:58:42 回复(0)

Bash

pardon110

grep -E 23/Apr/2020 nowcoder.txt | cut -d ' ' -f 1 | sort | uniq -c | sort -r | awk '{print $1,$2}'

发表于 2022-07-10 15:13:27 回复(0)

Bash

已注销

awk -F ' ' '$4~/^(\[23\/Apr\/2020)/{print $1}'|sort|uniq -c|sort -r|sed 's/^ */''/g'

发表于 2022-06-24 12:10:26 回复(0)

Bash

bjwizj

grep "23/Apr" nowcoder.txt | awk -F ' - - ' '{  print $1 }' | sort -n | uniq -c | sort -r | sed 's/^ *//'

发表于 2022-06-09 18:53:07 回复(0)

Bash

Liypoi

sed -n '/\[23\/Apr/p' nowcoder.txt | awk '{print $1}' | sort  | uniq -c | awk '{print $1,$2}' | sort -rk1

sed -n '/\[23\/Apr/p' nowcoder.txt  #正则匹配23号的IP

awk '{print $1}' | sort  | uniq -c  # 打印IP，去重加重复次数

awk '{print $1,$2}' | sort -rk1  # 打印次数和IP，按重复次数逆序排序

发表于 2022-06-08 22:50:00 回复(0)

Bash

qkyjs6

awk '$0 ~ /23\/Apr/ {print $0}' nowcoder.txt | awk '{arr[$1]+=1;}END{for(i in arr){print arr[i],i}}' | sort -r -n

发表于 2022-06-02 17:29:30 回复(0)

Bash

JianYue

awk -F " " '$4~/^\[23\/Apr\/2020/ {
a[$1]+=1
}END{
for(x in a)
{
print a[x],x
}}'|sort -r -k 1

发表于 2022-05-10 17:06:40 回复(0)

Bash

暗夜随风

sed -n '/\[23/,/Apr\/2020/p'|awk '{print $1}'| sort | uniq -c | sort -r |awk '{print $1,$2}'

sed -n '/\[23/,/Apr\/2020/p'|awk '{print $1}'| sort | uniq -c | sort -r 摁要我把他pirn在前

发表于 2022-05-01 20:22:38 回复(0)

Bash

可爱的考拉

awk '{if($0~/23\/Apr\/2020/) print $1}'|sort|uniq -c|sort -r|awk '{print $1,$2}'

发表于 2022-04-23 15:17:15 回复(0)

Bash

牛客605469699号

cat nowcoder.txt|

grep '23/Apr/2020'|

grep -o "192.168.1.[0-9]\{1,3\}"|

sort|

uniq -c|

sort -rk 1|

awk -F ' ' '{print $1 " " ptint $2}'

发表于 2022-04-22 17:36:37 回复(0)

Bash

牛客69381151号

#!/usr/bin/env bash
awk '$0~/23\/Apr\/2020/{a[$1]+=1}END{for(i in a) print a[i],i}' nowcoder.txt | sort -k1rn

发表于 2022-03-25 13:43:38 回复(0)

Bash

罗大昭

cat nowcoder.txt|grep '23/Apr/2020'|cut -d "-" -f 1|sort|uniq -c|sort -r -k 1|awk '{print $1" "$2}'

发表于 2022-03-22 20:08:52 回复(0)

Bash

Paul💤

grep -E "23/Apr/2020" nowcoder.txt|awk '{print $1}'|sort|uniq -c|sort -nr|awk '{print $1,$2}'

发表于 2022-03-11 13:58:53 回复(0)

提交观点

问题信息

shell

难度：

39条回答 28收藏 858浏览

通过挑战的用户

查看代码

stevenL270

2022-09-16 10:46:43
已注销

2022-09-15 17:37:07
牛客93592...

2022-09-14 16:23:28
牛客27372...

2022-09-14 16:07:59
端午不发粽子中...

2022-09-14 15:06:52

Nginx日志分析1-IP访问次数统计

输入描述:

输出描述:

输入

输出

grep+awk+sort

问题信息

热门推荐

通过挑战的用户

相关试题