python按规则自动填充excel 0,1值

今天有个任务是生成，用户和资源的点击记录。
以下为代码

import pandas as pd
import random

data=pd.read_excel('path.xls')
for i in range(0,50):
    for j in range(0,153):
        data[j].at[i]=0

for i in range(0,10):
    for voice in range(0,32):
        num=random.randint(0,3)
        if num > 1:
            data[voice].at[i] = 1
    for thing in range(32,53):
        num = random.randint(0, 3)
        if num > 1:
            data[thing].at[i] = 1
    for space in range(53,76):
        num = random.randint(0, 3)
        if num > 0:
            data[space].at[i] = 1
    for shape in range(76,153):
        num = random.randint(0, 3)
        if num > 0:
            data[shape].at[i] = 1

for i in range(10,20):
    for voice in range(0, 32):
        num = random.randint(0, 3)
        if num > 1:
            data[voice].at[i] = 1
    for thing in range(32, 53):
        num = random.randint(0, 3)
        if num > 0:
            data[thing].at[i] = 1
    for space in range(53, 76):
        num = random.randint(0, 3)
        if num > 1:
            data[space].at[i] = 1
    for shape in range(76, 153):
        num = random.randint(0, 3)
        if num > 1:
            data[shape].at[i] = 1

for i in range(20,30):
    for voice in range(0, 32):
        num = random.randint(0, 3)
        if num > 0:
            data[voice].at[i] = 1
    for thing in range(32, 53):
        num = random.randint(0, 3)
        if num > 1:
            data[thing].at[i] = 1
    for space in range(53, 76):
        num = random.randint(0, 3)
        if num > 1:
            data[space].at[i] = 1
    for shape in range(76, 153):
        num = random.randint(0, 3)
        if num > 1:
            data[shape].at[i] = 1

for i in range(30,40):
    for voice in range(0, 32):
        num = random.randint(0, 3)
        if num > 2:
            data[voice].at[i] = 1
    for thing in range(32, 53):
        num = random.randint(0, 3)
        if num > 0:
            data[thing].at[i] = 1
    for space in range(53, 76):
        num = random.randint(0, 3)
        if num > 2:
            data[space].at[i] = 1
    for shape in range(76, 153):
        num = random.randint(0, 3)
        if num > 1:
            data[shape].at[i] = 1

for i in range(40,50):
    for voice in range(0, 32):
        num = random.randint(0, 3)
        if num > 1:
            data[voice].at[i] = 1
    for thing in range(32, 53):
        num = random.randint(0, 3)
        if num > 2:
            data[thing].at[i] = 1
    for space in range(53, 76):
        num = random.randint(0, 3)
        if num > 0:
            data[space].at[i] = 1
    for shape in range(76, 153):
        num = random.randint(0, 3)
        if num > 2:
            data[shape].at[i] = 1

data.to_excel('output.xls')

print(data)