不精独乐乐

分类

/ 注册

全部文章（共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