宇宙最强超级无敌暴龙战神

分类

/ 注册

全部文章（共4篇）

python筛选某店铺最有价值用户中消费最多前5名

#多注意小细节 import pandas as pd sales = pd.read_csv('sales.csv') # 按照结果要求转换类型 sales[['monetary']] = sales[['monetary']].astype('float32') # 求百分位 des = sa...

2023-06-27

4 216

业务分析提取值

awk '{ if ($0 ~ /Server version/) { sub(/.*:/, "", $0) printf("serverVersion:%s\n", $0) next } if ($0 ~ /Server nu...

2023-06-27

0 207

求平均值

len='' i=0 sum=0 while read num; do if [ -z "${len}" ]; then len=$num continue fi (( sum += num )) (( i++ )) if [ ${...

2023-06-27

0 124

最大连续回答问题天数大于等于3天的用户及其对应等级

with tab as( select *,ROW_NUMBER()over(partition by author_id order by rk3) as days from( SELECT answer_date,author_id ,date_sub(answer...

2023-06-26

3 341