pythonでサンプルデータを作成

pythonで統計で使えそうなサンプルデータを作成し、エクセルにぶち込んでみました。

import openpyxl as px
import random
wb = px.load_workbook("data.xlsx")
ws = wb["Sheet"]

title_list = ["id","sex","age"]
random_sex = ["f","m"]
cnt = 0
for i in title_list:
    cnt+=1
    ws.cell(row=1, column=cnt, value=i)
for answers in range(1,31):
    cnt+=1
    ws.cell(row=1,column=cnt,value="T%d" %answers)
for i in range(1,101):
    ws.cell(row=i+1,column=1,value=i)
    j = random.randint(0,1)
    ws.cell(row=i+1,column=2,value=random_sex[j])
    ws.cell(row=i+1,column=3,value=random.randint(18,30))
    for k in range(4,34):
        ws.cell(row=i+1,column=k,value=random.randint(1,5))
wb.save("data.xlsx")