from faker import Faker

# 創(chuàng)建Faker對象
fake = Faker('zh_CN')

class User:
    def __init__(self):
        self.id = fake.random_int(min=1, max=1000)
        self.name = fake.name()
        self.password = fake.password()
        self.nickname = fake.user_name()
        self.phone = fake.phone_number()
        self.introduction = fake.text(max_nb_chars=200)
        self.avatar_url = fake.image_url(width=None, height=None)
        self.created_at = fake.date_time_this_decade().strftime('%Y-%m-%d %H:%M:%S')
        self.updated_at = fake.date_time_this_month().strftime('%Y-%m-%d %H:%M:%S')

# 創(chuàng)建一個用戶實例
user = User()

# 打印用戶屬性
print("ID:", user.id)
print("姓名:", user.name)
print("密碼:", user.password)
print("昵稱:", user.nickname)
print("電話:", user.phone)
print("自我介紹:", user.introduction)
print("頭像地址:", user.avatar_url)
print("創(chuàng)建時間:", user.created_at)
print("更新時間:", user.updated_at)

# 生成120條用戶數(shù)據(jù)
users = [User() for _ in range(120)]

import pandas as pd

# 將用戶數(shù)據(jù)轉換為DataFrame
data = {
    "ID": [user.id for user in users],
    "姓名": [user.name for user in users],
    "密碼": [user.password for user in users],
    "昵稱": [user.nickname for user in users],
    "電話": [user.phone for user in users],
    "自我介紹": [user.introduction for user in users],
    "頭像地址": [user.avatar_url for user in users],
    "創(chuàng)建時間": [user.created_at for user in users],
    "更新時間": [user.updated_at for user in users]
}
df = pd.DataFrame(data)

# 保存DataFrame為Excel文件
filename = "users.xlsx"
df.to_excel(filename, index=False)

print(f"數(shù)據(jù)已保存到文件'{filename}'")

(base) ~  $ excel -h
usage: excel_reader.py [-h] [-f file] [-r ROW] [-s START] [-e END] [-p PAGESIZE]

在控制臺查看 Excel 文件的內(nèi)容

optional arguments:
  -h, --help            show this help message and exit
  -f file, --file_path file
                        Excel 文件路徑
  -r ROW, --row ROW     第幾行
  -s START, --start START
                        起始行
  -e END, --end END     結束行
  -p PAGESIZE, --pagesize PAGESIZE
                        每頁顯示的行數(shù)

excel -f ~/temp/python/推文文章/users.xlsx -r 10

excel -f ~/temp/python/推文文章/users.xlsx -s 10 -e 12

excel -f ~/temp/python/推文文章/users.xlsx