python随机生成excel表格（excel练习素材）

import random
first_name = ['Sophie', 'Liam', 'Emily', 'William', 'Ava', 'Oliver', 'Ella', 'Jack', 'Charlotte', 'Henry', 'Madison', 'Lucas', 'Isabella', 'Benjamin', 'Mia', 'Noah', 'Chloe', 'Mason', 'Harper', 'Ethan', 'Evelyn', 'Jacob', 'Zoe', 'Michael', 'Victoria']
last_name = ['Smith', 'Johnson', 'Jones', 'Taylor', 'Brown', 'Davis', 'Wilson', 'Clark', 'Hall', 'Young', 'Allen', 'King', 'Wright', 'Lee', 'Scott', 'Green', 'Baker', 'Adams', 'Nelson', 'Carter', 'Mitchell', 'Perez', 'Roberts', 'Turner', 'Phillips']
#print(random.choice(first_name) + ' ' + random.choice(last_name))

gender = ['Male',"Female"]
def random_list(n,a, b):
    list = [random.randint(a, b)for i in range(n)]
    list.insert(0,random.choice(first_name) + ' ' + random.choice(last_name))
    list.insert(2,random.choice(gender))
    return list

def random_list2(x):
    return [random_list(n,a,b)for i in range(x)]
n = 1
a, b = 1, 100
x=10

lst2 = random_list2(x)

#print(lst2)

import pandas as pd
import test

# 要写入Excel的数据
data = test.random_list2(200)
# 创建一个Pandas DataFrame
df = pd.DataFrame(data, columns=['Name', 'Age', 'Gender'])
# 创建一个新的Excel文件
writer = pd.ExcelWriter('example.xlsx', engine='openpyxl')
# 在指定工作表中写入数据
df.to_excel(writer, sheet_name='Sheet1', index=False)
# 关闭Excel文件
writer.save()