要求python读excel数据量后，按照指定人名指定数量进行分配。例如这个excel有100条，随机分配，给a某某分10条，给 b某某分50条，c某某40条。总之数据肯定分完，但是不是均分。最后执行完输出，excel里就是新增一列这个分配记录！

```python
import random
import pandas as pd

data = pd.read_excel(r'C:\Users\123\Desktop\1.xlsx')
excel_len = len(data['类名'])
quantity = ['a','b','c']
quantity_list = []

for i in range(len(quantity) - 1):
    allocation = random.randint(1,excel_len)
    quantity_list += [quantity[i]] * allocation
    excel_len = excel_len - allocation
    if excel_len == 0:
        break
quantity_list += quantity[-1] * excel_len
data['姓名'] = quantity_list
data.to_excel(r'C:\Users\123\Desktop\1.xlsx')

```

浅学一下

import random
import pandas as pd
data = pd.read_excel(r'0.xlsx')
excel_len = len(data['类名'])
quantity = ['a','b','c']
quantity_list = []
for i in range(len(quantity) - 1):
    allocation = random.randint(1,excel_len)
    quantity_list += [quantity[i]] * allocation
    excel_len = excel_len - allocation
    if excel_len == 0:
        break
quantity_list += quantity[-1] * excel_len
data['姓名'] = quantity_list
data.to_excel(r'1.xlsx')