python之王

分类

/ 注册

全部文章（共38篇）

查询投递最低最高薪资差别大于2的职位投递用户user_id

select user_id from deliver_record_detail where (max_salary - min_salary) > 2

2023-12-22

1 177

题解 | #查询在pc上投递的所有投递记录#

select * from deliver_record_detail where device = 'pc'

2023-12-22

0 194

题解 | #查询表总行数#

select count(*) as cnt from deliver_record

2023-12-22

0 185

题解 | #将查询列重新命名#

select job_salary as '职位工资' from deliver_record

2023-12-22

0 176

题解 | #查询限制行数#

select * from deliver_record limit 2

2023-12-22

0 187

题解 | #查询所有投递用户user_id并去重#

select distinct(user_id) from deliver_record

2023-12-22

0 240

题解 | #不同等级会员的购买力#

import pandas as pd import numpy as np data = pd.read_csv(r'Order.csv') print(data.groupby('VIP_level')['price'].mean()) data1 = data.drop_duplica...

2023-12-22

0 208

题解 | #多部门的打工人#

class Nowcoder: def __init__(self, name, ID, num): self.name = name self.ID = ID self.num = num def print_information...

2023-12-22

0 214

题解 | #网页的生成#

h1 = input() l1 = h1.split(" ") # print(l1) for h in l1: h = int(h)*2 print(h)

2023-12-22

0 175

题解 | #获得积分最多的人(三)#

select user_id, name, grade_num from( select distinct(user_id), name, grade_num, m...

2023-12-20

0 159