python脚本密码生成器修改版本

import random
import pandas
import re

ip_address = []
password_list1 = []
# 1.读取原始文件。获取ip，原始密码
# 读取表格
filename = r'C:\Users\Administrator\Desktop\12312.xlsx'
df = pandas.read_excel(filename, sheet_name=0)

# 2.生成新密码，替换原始密码
password_string = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz1234567890'
str_list = list(password_string)

l1 = str_list[-10:]
print(l1)


# 生成密码
def get_password(length):
    password_list = []
    a = 0
    while a <= length - 1:
        index = random.randint(0, len(str_list) - 1)
        password = str_list[index]
        password_list.append(password)

        a += 1
    password_str = ''.join(password_list)
    # 判断是否符合密码规则
    if re.search("[0-9]+", password_str) and re.search("[a-z]+", password_str) and re.search("[A-Z]+", password_str):
        return password_str
    else:
        return None


# 重组数据ip地址和密码
for i in df.get('ip地址'):
    ip_address.append(i)
    pa = get_password(15)
    if pa is None:
        print(str(i))
        print('密码不符合规则')
        while pa is None:
            pa = get_password(15)
    password_list1.append(pa)

# 3.重新写入表格
new_row = pandas.DataFrame({'ip地址': ip_address, '密码': password_list1})
print(new_row)
with pandas.ExcelWriter('密码修改.xlsx', engine='openpyxl', mode='w') as w:
    new_row.to_excel(w, index=False, sheet_name='sheet2')
    print('更新成功')