pyt造数据如何做关联

Question

使用python造数据求各位分析解决一下

问题：我执行一次以下代码即可运行出来一个excel其中全部都是随机值，但是我想要 脚本1和脚本2出来得随机值项目号(project)做关联，应该怎么改pyt代码或者再新增什么呢？

例如 脚本1中生成excel后字段'project'和脚本2中得字段'project'做内关联

脚本1->代码如下

脚本2->因为行数限制暂时不发。

截图为执行pyt以后的项目ID

# -*- coding:utf-8 -*-
import codecs
import time
from faker import Faker   
fake = Faker(locale="zh_CN")
now = int(time.time())
import xlwt 
book = xlwt.Workbook(encoding='utf-8',style_compression=0)
sheet = book.add_sheet('孙尚香',cell_overwrite_ok=True)
col = ('bookanch','branname','custn','custame','bloname','crmcredit','crmindustrytype','crmindustrypename','isbloccus','custrole','project','projename','industryd','industryname','industrynameoneame','headidentifiedclass','hasutstanding','chanoutstanding','DS','DD')

font0 = xlwt.Font()
font0.name = 'Times New Roman'
font0.colour_index = 2
font0.bold = True

style0 = xlwt.XFStyle()
style0.font = font0

for i in range(0,20):  
    sheet.col(i).width = 256 * 20
    sheet.write(0,i,col[i], style0)


data_list =  []

for i in range(100):
    jigou_number = fake.random_int() 
    jigou_name  = fake.province()
    if fake.null_boolean():
       str3 =   "Y"
    else:
       str3 =   "N"  
    import random   
    index = random.randint(0,4) 
    lis = ["正常1","正常2","正常3","正常4","可疑"]
    str4 = lis[index]  
    print(jigou_name, jigou_number,str3,str4)

    data = [jigou_number, jigou_name, fake.credit_card_number(), fake.company(), fake.company(), fake.random_digit(), 
    fake.job(), fake.company_suffix(), str3, fake.name(), fake.uuid4(), fake.sentence() ,fake.mac_address(),fake.job(), 
    fake.job(),str4,str3,fake.numerify(), '', '20220605']
    data_list.append(data)



    kehu_lis =[]
    kehu_numbers =[]
    for i in range(200):
        kuhu_name =fake.company()
        kehu_number =  fake.uuid4()
        kehu_lis.append(kuhu_name)
        kehu_numbers.append(kehu_number)

        da = [jigou_number, jigou_name, fake.credit_card_number(), fake.company(), fake.company(), fake.random_digit(), 
              fake.job(), fake.company_suffix(), str3, fake.name(), fake.uuid4(), fake.sentence() ,fake.mac_address(),fake.job(), 
              fake.job(),str4,str3,fake.numerify(), '', '20220605']
        data_list.append(da)




    for i in range(400):
        index = int(fake.random_digit())
        kehu =kehu_lis[index]
        kehu_number = kehu_numbers[index]
        da = [jigou_number, jigou_name, fake.credit_card_number(), fake.company(), fake.company(), fake.random_digit(), 
              fake.job(), fake.company_suffix(), str3, fake.name(), fake.uuid4(), fake.sentence() ,fake.mac_address(),fake.job(), 
              fake.job(),str4,str3,fake.numerify(), '', '20220605']
        data_list.append(da)

# print(data_list)



a = 0
for value in data_list:
    print(value)
    a += 1
    for i in range(len(value)):
        # print(a,i,value[i])
        sheet.write(a, i, value[i])

savepath='awd.xlsx'
book.save(savepath)

Answer 1

再新建一个关联表，字段为
id,project_no,project1_no,project2_no