lpzbebetter
lpzbebetter
全部文章
分类
题解(1)
归档
标签
去牛客网
登录
/
注册
lpzbebetter的博客
全部文章
(共6篇)
题解 | #筛选某店铺最有价值用户中消费最多前5名#
from re import A import pandas as pd df = pd.read_csv('sales.csv') r = pd.qcut(df.recency,q=4,labels=[4,3,2,1]) f = pd.qcut(df.frequency,q=4,labels=[...
2023-08-30
0
118
题解 | #用户常用语言有多少#
用分组的方式做的: import pandas as pd df = pd.read_csv('Nowcoder.csv') gp = list(df.groupby('Language')) #对语言列进行分组然后转化为列表格式 print(len(gp),gp,sep='\n')
2023-08-17
0
152
题解 | #累加数与平均值#
li = [int(i) for i in input().split()] sum = 0 count = 0 for j in li: sum += j count += 1 print('{} {:.1f}'.format(sum,sum/count))
2023-07-31
0
165
题解 | #禁止重复注册#
current_users = ['Niuniu','Niumei','GURR','LOLO'] new_users = ['GurR','Niu Ke Le','LoLo','Tuo Rui Chi'] for i in new_users: if i.lower() in [j.low...
2023-07-28
1
160
题解 | #查找在职员工自入职以来的薪水涨幅情况#
没有用到第一个表好像也可以,解法如下: select t1.emp_no,(t2.x-t1.n) growth from (select emp_no,min(from_date),min(salary) n from salaries grou...
Mysql
2022-08-30
0
157
题解 | #网易云音乐推荐(网易校招笔试真题)#
原来我是将distinct和order by一起使用,但是发现运行报错: SQL_ERROR_INFO: "Expression #1of ORDER BY clause is not in SELECT list, references column 'm.id'...
Mysql
2022-05-26
26
511