抽奖名单来源于附件 excel文件,分别抽出一等奖,二等奖,三等奖名单并显示出来,要求不允许重复被抽中, 各个奖项的中奖率和奖品。
时间: 2023-06-11 21:06:05 浏览: 114
好的,这个任务可以使用 Python 编写程序来完成,具体步骤如下:
1. 安装必要的库 pandas 和 random:
```
pip install pandas
```
2. 读取附件 excel 文件中的数据:
```python
import pandas as pd
df = pd.read_excel("抽奖名单.xlsx")
```
3. 定义抽奖函数,根据不同奖项的中奖率和奖品,从名单中随机抽取一名幸运儿:
```python
import random
def draw_prize(prize_level):
if prize_level == "一等奖":
prize = "iPhone 12"
win_rate = 0.05
elif prize_level == "二等奖":
prize = "iPad Pro"
win_rate = 0.1
elif prize_level == "三等奖":
prize = "AirPods Pro"
win_rate = 0.2
winners = []
while len(winners) < 1:
for i, row in df.iterrows():
if random.random() < win_rate and row["姓名"] not in winners:
winners.append(row["姓名"])
print(f"{prize_level}:{winners[0]} 获得了 {prize}")
```
4. 分别调用抽奖函数抽出一等奖、二等奖、三等奖名单并显示出来:
```python
draw_prize("一等奖")
draw_prize("二等奖")
draw_prize("三等奖")
```
完整代码如下:
```python
import pandas as pd
import random
df = pd.read_excel("抽奖名单.xlsx")
def draw_prize(prize_level):
if prize_level == "一等奖":
prize = "iPhone 12"
win_rate = 0.05
elif prize_level == "二等奖":
prize = "iPad Pro"
win_rate = 0.1
elif prize_level == "三等奖":
prize = "AirPods Pro"
win_rate = 0.2
winners = []
while len(winners) < 1:
for i, row in df.iterrows():
if random.random() < win_rate and row["姓名"] not in winners:
winners.append(row["姓名"])
print(f"{prize_level}:{winners[0]} 获得了 {prize}")
draw_prize("一等奖")
draw_prize("二等奖")
draw_prize("三等奖")
```
相关推荐
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)