学习生1

分类

/ 注册

全部文章（共175篇）

题解 | #统计每种性别的人数#

select substring_index(profile,',',-1) as gender, count(*) as number from user_submit group by gender;

2024-11-19

0 67

题解 | #统计每个用户的平均刷题数#

select user_profile.university as university, question_detail.difficult_level as difficult_level, round(count(question_practice_detail.que...

2024-11-19

0 62

题解 | #统计每个学校各难度的用户平均刷题数#

select user_profile.university as university, question_detail.difficult_level as difficult_level, round(count(question_practice_detail.que...

2024-11-19

0 72

题解 | #21年8月份练题总数#

select count(distinct device_id) as did_cnt, count(question_id) as question_cnt from question_practice_detail where date >= '2021-0...

2024-11-19

0 44

题解 | #查找后降序排列#

select device_id, gpa, age from user_profile order by gpa desc,age desc;

2024-11-19

0 50

题解 | #查找后多列排序#

select device_id, gpa, age from user_profile order by gpa,age;

2024-11-19

0 51

题解 | #查找后排序#

select device_id, age from user_profile order by age;

2024-11-19

0 62

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

import pandas as pd test1=pd.read_csv('Nowcoder.csv',encoding='utf-8') print(test1['Language'].iloc[10:21])

2024-11-19

0 70

题解 | #牛客网用户数据集的大小#

import pandas as pd test1=pd.read_csv('Nowcoder.csv',encoding='utf-8') a=len(test1) b=len(test1.columns) print((a,b))

2024-11-19

0 49

题解 | #用pandas查看牛客网用户数据#

import sys import pandas as pd test1=pd.read_csv('Nowcoder.csv',encoding='utf-8',dtype=object) print(test1.head(6))

2024-11-19

0 52