学习生1

分类

/ 注册

全部文章（共175篇）

题解 | #广告点击的高峰期#

select hour(click_time) as click_hour, count(hour(click_time)) as click_cnt from user_ad_click_time group by hour(click_time) order by...

2024-11-25

0 65

题解 | #输出提交且通过次数大于2 的用户ID且升序排列#

select user_id from done_questions_record where result_info=1 group by user_id having count(result_info)>2 order by us...

2024-11-25

0 60

题解 | #输出提交次数大于2次的用户ID且倒序排列#

select user_id from done_questions_record group by user_id having count(question_id)>2 order by user_id desc;

2024-11-25

0 73

题解 | #牛客网最多的用户等级#

import pandas as pd Nowcoder=pd.read_csv('Nowcoder.csv',sep=',') print(Nowcoder.loc[:,['Level']].mode()) #x.mode()表示众数。

2024-11-24

0 43

题解 | #用户常用语言有多少#

import pandas as pd Nowcoder=pd.read_csv('Nowcoder.csv',sep=',') print(Nowcoder['Language'].nunique()) print(Nowcoder['Language'].unique())

2024-11-24

0 34

题解 | #牛客网用户等级的中位数#

import pandas as pd Nowcoder=pd.read_csv('Nowcoder.csv') df1=Nowcoder.query("Num_of_exercise>=10") print(int(df1['Level'].median()))

2024-11-24

0 44

题解 | #Python用户的平均提交次数#

import pandas as pd Nowcoder=pd.read_csv('Nowcoder.csv') Nowcoder1=Nowcoder.query("Language=='Python'") avg=Nowcoder1['Number_of_submissio...

2024-11-24

0 47

题解 | #牛客网用户最近的最长与最短连续签到天数#

import pandas as pd Nowcoder=pd.read_csv('Nowcoder.csv') df1=Nowcoder['Continuous_check_in_days'].max() df2=Nowcoder['Continuous_check_in_days'].min...

2024-11-24

0 50

题解 | #牛客网不同语言使用人数#

import pandas as pd Nowcoder=pd.read_csv('Nowcoder.csv',sep=',') counts=Nowcoder['Language'].value_counts() print(counts) Nowder[].value_counts()表示...

2024-11-24

0 59

题解 | #统计牛客网刷题数量500以上的大佬#

import sys import pandas as pd Nowcoder=pd.read_csv('Nowcoder.csv',sep=',') index=Nowcoder['Num_of_exercise']>=500 print(Nowcoder[index][['Leve...

2024-11-24

0 56