牛客794288350号

分类

/ 注册

全部文章（共51篇）

题解 | 每天登陆最早的用户的内容喜好

SELECT T.log_day, ut.user_id, ut.hobby FROM ( SELECT MIN(log_time) AS earliest, DATE(log_time) as l...

2025-06-03

0 37

题解 | 统计加班员工占比

SELECT st.department, CONCAT ( ROUND( SUM( CASE WHEN TIMESTAMPDIFF (MINUTE, at.first_c...

2025-06-03

0 44

题解 | 更新用户积分信息？

SELECT ut.user_id, ut.point+a.order_price AS point FROM (SELECT user_id, sum(order_price) as order_price FROM ...

2025-05-10

0 39

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

import pandas as pd df=pd.read_csv('Nowcoder.csv') #df['Num_of_exercise'] = pd.to_numeric(df['Num_of_exercise'], errors='coerce') print(df.query('Nu...

2025-05-10

0 29

题解 | 牛客网Python用户的成就值

import pandas as pd file=pd.read_csv('Nowcoder.csv',dtype=object) print(file.query('Language=="Python"').Achievement_value.astype('int64')...

2025-05-10

0 36

题解 | 查看牛客网哪些用户使用Python

import pandas as pd file=pd.read_csv('Nowcoder.csv',dtype=object) print(file.query('Language=="Python"')) print(file.query('Language==&qu...

2025-05-07

0 83

题解 | 牛客网用户没有补全的信息

import pandas as pd file=pd.read_csv('Nowcoder.csv',dtype=object) print(file.isna().any(axis=0)) # 1) any () 函数用于判断给定的可迭代参数 iterable 是否都为 Fals...

2025-05-06

0 46

题解 | 统计牛客网部分用户使用语言

import pandas as pd file=pd.read_csv('Nowcoder.csv',dtype=object) print(file.loc[10:20]['Language']) # loc左闭右闭# iloc左闭右开

2025-05-06

0 44

题解 | 查询下订单用户访问次数？

SELECT o.user_id, COUNT(*) as visit_nums FROM ( SELECT DISTINCT user_id FROM order_tb ot W...

2025-05-06

0 36

题解 | 每个商品的销售总额

SELECT name AS product_name, total_sales, RANK() OVER ( PARTITION BY category ORDER BY total_sales...

2025-04-29

0 37