年华201905241506786

分类

/ 注册

全部文章（共76篇）

题解 | #找出每个学校GPA最低的同学#

select device_id,university,gpa from ( select device_id,university,gpa, row_number() over(partition by university order by gpa ) rn from user_profile)...

2024-12-03

0 52

题解 | #去掉所有包含this的句子#

#!/bin/bash grep -v 'this' ./nowcoder.txt

2024-12-03

0 40

题解 | #转置文件的内容#

#!/bin/bash awk '{printf $1" "}' nowcoder.txt awk '{printf $2" "}' nowcoder.txt

2024-12-03

0 65

题解 | #统计文件的行数#

#!/bin/bash wc -l

2024-12-03

0 46

题解 | #第二列是否有重复#

#!/bin/bash while read -a line;do echo ${line[1]}; done < nowcoder.txt | sort | uniq -c | awk ' $1 > 1 {print $0}' | sort -n

2024-12-03

1 40

题解 | #统计每个单词出现的个数#

#!/bin/bash cat nowcoder.txt | xargs -n1 |sort | uniq -c| sort -n | awk '{print $2,$1}'

2024-12-03

1 59

题解 | #统计所有进程占用内存百分比的和#

#!/bin/bash while read -a line;do echo ${line[3]}; done <nowcoder.txt | awk '{sum+=$1} END {print sum}'

2024-12-03

0 60

题解 | #求最小公倍数#

import java.util.*; public class Main { public static void main(String[] args) { Scanner console = new Scanner(System.in); int m ...

2024-12-02

0 47

题解 | #统计输入正数个数#

import java.util.Scanner; public class Main { public static void main(String[] args) { Scanner scanner = new Scanner(System.in); S...

2024-12-02

0 75

题解 | #牛客网的第10位用户#

import pandas as pd df = pd.read_csv("Nowcoder.csv") print(df.loc[10])

2023-10-10

0 208