9月24日周末作业

9月24日周末作业

# 1. 已知一个数字列表，统计偶数的个数
s1 = [10, 34, 5, 65, 66, 89, 82]
count = 0
for x in s1:
    if x % 2==0:
        count += 1
print(count)

# 2. 已知一个数字列表，计算所有元素的平均值
s1 = [23, 34, 56, 9, 80]
average = sum(s1) / len(s1)
print(average)

# 3.已知一个列表，统计列表中整数的个数
s1=['abc', True, 12.5, 20, 'hello', 10]
count=0
for x in s1:
    if type(x)==int:
        count += 1
print(count)

# 4.已知一个列表，统计列表中非整数的个数
s1=['abc', True, 12.5, 20, 'hello', 10]
count=0
for x in s1:
    if type(x)!=int:
        count += 1
print(count)

# 5.已知一个列表，计算列表中所有数字的和
s1=['abc', True, 12.5, 20, 'hello', 10]
sum1=0
for x in s1:
    if type(x)==int or type(x)==float:
        sum1 += x
print(sum1)

# 6.已知一个列表，计算所有大于100的数的和
s1=['abc', 23, 101, 12, 5, 'hello', 120.8]
sum2 = 0
for x in s1:
    if (type(x)==int or type(x)==float) and x>100:
        sum2 += x
print(sum2)

# 7.已知一个列表，提取列表中所有字符串元素的最后一个字符。
s1=['hello', 'how', 10, 'are', 12.5, True]
for x in s1:
    if type(x)==str:
        print(x[-1])

# 8. 根据要求完成以下功能：已知变量orders中保存一个店家的所有订单数据，每个订单包含：订单ID、用户ID、订单金额、支付金额、订单来源渠道、是否退货。
orders = [
       {'orderID': '254118088', 'userID': '157213', 'goodsID': 'PR000064', 'orderAmount': '272.51', 'payment': '272.51 ', 'chanelID': None, 'chargeback': False},
       {'orderID': '263312190', 'userID': '191121', 'goodsID': 'PR000583', 'orderAmount': '337.93', 'payment': '337.93 ', 'chanelID': '渠道-0765', 'chargeback': True},
       {'orderID': '188208169', 'userID': '211918', 'goodsID': 'PR000082', 'orderAmount': '905.68', 'payment': '891.23 ', 'chanelID': '渠道-0530', 'chargeback': False},
       {'orderID': '203314910', 'userID': '201322', 'goodsID': 'PR000302', 'orderAmount': '786.27', 'payment': '688.88 ', 'chanelID': None, 'chargeback': False},
       {'orderID': '283989279', 'userID': '120872', 'goodsID': 'PR000290', 'orderAmount': '550.77', 'payment': '542.51 ', 'chanelID': '渠道-9527', 'chargeback': False},
       {'orderID': '279103297', 'userID': '146548', 'goodsID': 'PR000564', 'orderAmount': '425.2', 'payment': '425.20 ', 'chanelID': '渠道-0765', 'chargeback': False},
       {'orderID': '316686066', 'userID': '148994', 'goodsID': 'PR000709', 'orderAmount': '1764.37', 'payment': '1707.04 ', 'chanelID': '渠道-0396', 'chargeback': False},
       {'orderID': '306447069', 'userID': '104863', 'goodsID': 'PR000499', 'orderAmount': '499.41', 'payment': '480.42 ', 'chanelID': '渠道-0007', 'chargeback': False},
       {'orderID': '290267674', 'userID': '206155', 'goodsID': 'PR000253', 'orderAmount': '1103', 'payment': '1050.95 ', 'chanelID': '渠道-0330', 'chargeback': False},
       {'orderID': '337079027', 'userID': '211918', 'goodsID': 'PR000768', 'orderAmount': '465.41', 'payment': '465.41 ', 'chanelID': '渠道-9527', 'chargeback': False},
       {'orderID': '417411381', 'userID': '148994', 'goodsID': 'PR000483', 'orderAmount': '279.53', 'payment': '279.53 ', 'chanelID': '渠道-0007', 'chargeback': False},
       {'orderID': '254286596', 'userID': '174586', 'goodsID': 'PR000322', 'orderAmount': '622.7', 'payment': '622.70 ', 'chanelID': '渠道-0283', 'chargeback': False},
       {'orderID': '303647260', 'userID': '178023', 'goodsID': 'PR000685', 'orderAmount': '969.61', 'payment': '913.58 ', 'chanelID': '渠道-0765', 'chargeback': False},
       {'orderID': '347419495', 'userID': '209896', 'goodsID': 'PR000483', 'orderAmount': '279.18', 'payment': '225.15 ', 'chanelID': '渠道-0396', 'chargeback': False},
       {'orderID': '384544993', 'userID': '148994', 'goodsID': 'PR000004', 'orderAmount': '3424.78', 'payment': '3424.78 ', 'chanelID': '渠道-0530', 'chargeback': False},
       {'orderID': '322802617', 'userID': '125220', 'goodsID': 'PR000812', 'orderAmount': '430.69', 'payment': '4223.48 ', 'chanelID': '渠道-0530', 'chargeback': False},
       {'orderID': '399101394', 'userID': '183645', 'goodsID': 'PR000025', 'orderAmount': '703.39', 'payment': '553.37 ', 'chanelID': '渠道-9527', 'chargeback': False},
       {'orderID': '274413321', 'userID': '162256', 'goodsID': 'PR000813', 'orderAmount': '227.42', 'payment': '200.37 ', 'chanelID': '渠道-0530', 'chargeback': False},
       {'orderID': '362677803', 'userID': '217238', 'goodsID': 'PR000400', 'orderAmount': '169.04', 'payment': '106.99 ', 'chanelID': '渠道-0789', 'chargeback': True}
   ]
# 1. （数据清洗）删除orders中支付金额大于订单金额的订单
new_orders=[order for order in orders if float(order['payment'])<=float(order['orderAmount'])]
del orders  #删掉原来的数据
print(new_orders)
# 方法2
# new_orders = orders.copy()
# for order in new_orders[:]:  # 为以防删不干净，遍历删除加[:]
#     if float(order['payment'])>float(order['orderAmount']):
#         new_orders.remove(order)
# print(new_orders)

# 2. 计算这个店家的总订单金额和总支付金额以及实际销售额（店家真正拿到手中钱）
sum1=0
sum2=0
sum3=0
for order in new_orders:
    sum1+=float(order['orderAmount'])
    sum2+=float(order['payment'])
    if order['chargeback']==False:
        sum3+=float(order['payment'])
print('总订单金额:', sum1)
print('总支付金额:', sum2)
print('实际销售额:', sum3)
# 3. 统计这个店家的订单的订单来源渠道的数量
total=[]
for order in new_orders:
    if order['chanelID']!=None and order['chanelID'] not in total:
        total.append(order['chanelID'])
print(len(total))

# 方法二
# chanels=set([order['chanelID'] for order in new_orders if order['chanelID']!=None])
# print(len(chanels))
# 4. 计算订单退货率
count=0
for order in new_orders:
    if order['chargeback']==True:
        count+=1
print(count/len(new_orders))
# 5. 获取最优广告渠道
chanel1 = [order['chanelID'] for order in new_orders if order['chanelID']!=None]
print(chanel1)

chanel1_count=[]
for chanel in chanel1:
    count=0
    for order in new_orders:
        if order['chanelID']==chanel:
            count+=1
    chanel1_count.append(count)
max_count=max(chanel1_count)
best=[]
for index in range(len(chanel1_count)):
    if chanel1_count[index]==max_count:
        best.append(chanel1[index])
print('最优渠道:', best)



# 6. 将订单渠道为None的订单的渠道值修改成最优广告渠道
for order in new_orders:
    if order['chanelID']==None:
        order['chanelID']='渠道-0530'
print(new_orders)
# 7. 在每个订单数据中添加一个键值对保存订单的折扣值
for order in new_orders:
    order.setdefault('折扣值', float(order['payment'])/float(order['orderAmount']))
print(new_orders)