不精独乐乐
不精独乐乐
全部文章
分类
归档
标签
去牛客网
登录
/
注册
不精独乐乐的博客
全部文章
(共156篇)
题解 | #牛客网的每日练题量#
import pandas as pd a = pd.read_csv('nowcoder.csv', sep=',') a['date'] = a['date'].astype('datetime64[D]') b = a[a['date'].between('2021-12-01','2021...
2023-04-16
0
187
题解 | #统一最后刷题日期的格式#
import pandas as pd a = pd.read_csv('Nowcoder.csv', sep=',',dtype=object) a['Last_submission_time'] = pd.to_datetime(a['Last_submission_time'],format=...
2023-04-16
0
238
题解 | #解决牛客网用户重复的数据#
import pandas as pd a = pd.read_csv('Nowcoder.csv', sep=',') b = a.drop_duplicates(keep='first') pd.set_option('display.width',300) pd.set_option('di...
2023-04-16
0
242
题解 | #修补缺失的用户数据#
import pandas as pd a = pd.read_csv('Nowcoder.csv', sep=',') b = a['Graduate_year'].max() c = round(a['Achievement_value'].mean(),0) values = {'Gradua...
2023-04-16
0
241
题解 | #去掉信息不全的用户#
import pandas as pd a = pd.read_csv('Nowcoder.csv', sep=',', dtype=object) b = a.dropna(axis=0,how='any') pd.set_option('display.width',300) pd.set_op...
2023-04-16
0
259
题解 | #牛客网用户最高的正确率#
import pandas as pd a = pd.read_csv('Nowcoder.csv', sep=',') b = a[a['Num_of_exercise']>10] c = round((b['Num_of_exercise']/b['Number_of_submission...
2023-04-16
0
253
题解 | #大佬用户成就值比例#
import pandas as pd a = pd.read_csv('Nowcoder.csv', sep=',') b = a['Achievement_value'].sum() c = a[a['Level']==7]['Achievement_value']/b print(c)
2023-04-16
0
215
题解 | #获取每个部门中当前员工薪水最高的相关信息#
#思路:①用窗口函数选出每个部门在职员工最高薪水;②选出最高薪水对应的员工相关信息即可。 select dept_no, emp_no, maxSalary from( select dept_no, emp_no, salary, max(salary)over(partition by de...
2023-04-16
0
354
题解 | #牛客网大佬之间的差距#
import pandas as pd import numpy as np a = pd.read_csv('Nowcoder.csv',sep=',') b = a[a['Level']==7]['Achievement_value'].max() c = a[a['Level']==7][...
2023-04-15
0
204
题解 | #用分位数分析牛客网用户活动#
import pandas as pd import numpy as np a = pd.read_csv('Nowcoder.csv',sep=',') b = a[['Achievement_value','Continuous_check_in_days']].quantile(q=0....
2023-04-15
0
178
首页
上一页
1
2
3
4
5
6
7
8
9
10
下一页
末页