小亮来给他整个活

分类

/ 注册

全部文章（共123篇）

题解 | #打印字母数小于8的单词#

#!/bin/bash read line < nowcoder.txt for i in $line do if ((${#i} < 8)) then echo $i fi done

2024-10-10

1 56

题解 | #去掉空行#

#!/bin/bash awk NF nowcoder.txt

2024-10-10

0 58

题解 | #打印空行的行号#

#!/bin/bash cat -n nowcoder.txt | awk '$2=="" {print $1}'

2024-10-10

0 56

题解 | #筛选某店铺最有价值用户中消费最多前5名#

import pandas as pd sales = pd.read_csv('sales.csv',delimiter=',') # 设置pandas显示配置,以显示完整的数据框 pd.set_option("display.width", 300) pd.set_opt...

2024-08-13

0 121

题解 | #牛客网的每日练题量#

import pandas as pd df = pd.read_csv('nowcoder.csv',sep=',',dtype=object) pd.set_option('display.width', 300) # 设置字符显示宽度 pd.set_option('display.max_ro...

2024-08-11

0 108

题解 | #牛客网大佬之间的差距#

import pandas as pd df = pd.read_csv('Nowcoder.csv',sep=',') pd.set_option('display.width', 300) # 设置字符显示宽度 pd.set_option('display.max_rows', None) # ...

2024-08-11

0 75

题解 | #牛客网用户练习的平均次日留存率#

import pandas as pd df = pd.read_csv('nowcoder.csv',sep=',',parse_dates=['date']) df['date'] = df.date.dt.date.astype('datetime64[D]') df = df.drop...

2024-08-03

0 113

题解 | #筛选某店铺最有价值用户中消费最多前5名#

import pandas as pd df= pd.read_csv('sales.csv',delimiter=',') df['R_Quartile'] = pd.qcut(df['recency'],4,labels=[4,3,2,1]).astype('str') df['F_Quarti...

2024-08-01

0 129

题解 | #某店铺消费最多的前三名用户#

import pandas as pd df= pd.read_csv('sales.csv') sorted_df = df.sort_values(by='monetary',ascending=False,inplace=False,ignore_index=True)[:3] # 设置pan...

2024-07-31

0 106

题解 | #纠错4#

SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state = 'MI' UNION all SELECT cust_name, cust_contact, cust_email FROM Custom...

2024-07-30

0 85