代码
# -*- coding: utf-8 -*-
# @Author : markadc
import pandas as pd
import random
import time
ls = []
for j in range(10):
item = {}
item["name"] = f"py-{random.randint(1, 100)}"
item["age"] = random.randint(18, 40)
item["status"] = random.randint(-1, 2)
item["add_time"] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time()))
ls.append(item)
df = pd.DataFrame(ls)
df.to_excel("demo.xlsx", index=False)