I need help using Python to generate usernames and passwords with excel documents

[Jannejannesson]

Hey guys, I need some serious help and guidance with creating a script. I realize I'm well over my head here but I still feel somehow I'm on the verge of "making something great". Worth noting is I'm incredibly new to python modules.

So, what I want is a python script that takes the existing content out of 1 excel file (called names.xsl) and then creates a new excel file but with an additional 2 columns, Username & Password. Now I have a function that generates a random 8 letter password. But I also need a function that generates a username based upon their names and room number(Which anybody is welcome to come with suggestions how to solve).

Layout of names.xsl:
A , B ,C , D
Name, socialsecuritynr, room, tel
Amy Anderson, 12345678, 636, 070xxx
etc etc (there are 33 names)

Layout of names_mod.xsl:
A , B , C , D , E , F
Name, socialsecuritynr, room, tel, Username, Password
Amy Anderson, 12345678, 636, 070xxx, amy636, randpa55

 1 import pandas as pd 2 from pandas import ExcelWriter 3 from pandas import ExcelFile 4 import numpy as np 5 import xlsxwriter 6 7 import random 8 import string 9 10 def randompassword(stringLength=6): 11 lettersAndDigits = string.ascii_letters + string.digits 12 return ''.join(random.choice(lettersAndDigits) for i in range(stringLength)) 13 print (randompassword(8)) 14 15 df = pd.read_excel('names.xls', sheet_name='Sheet1') 16 17 workbook = xlsxwriter.Workbook('names_mod.xls') 18 worksheet = workbook.add_worksheet() 19 20 worksheet.write('E1', 'Username') 21 worksheet.write('F1', 'Password') 22 worksheet.write('F2-34',(randompassword(8)) 23 workbook.close() 24 25 df1 = pd.read_excel('names_mod.xls', sheet_name='Sheet1') 26 print(df1) 

I realize this is A LOT to ask and the whole sript is a complete mess at the moment.. but any help is muchly appreciated, I've been at this for a good week now and could really use some help. Please let me know if I'm breaking any forum rules or need to clarify anything. Thanks in advance.

[Yoriz]

To get the username from

Output:
Amy Anderson, 12345678, 636, 070xxx

to

Output:
amy636

Use split on the name and pair it with room.

[Jannejannesson]

Any chance you could be more specific? I know how to use split, just not when there's an excel file involved.

[Jannejannesson]

Hey guys, I'm incredibly new to Python and even more so to its modules.

I have an excel file (names.xsxl) with 33 names and info. I'm trying to create a script that generates a random username as well as a password for each user in the 'E' and 'F' column respectively. How would I do this with the help of my two functions?


I hope I'm making myself clear, if I'm not, don't hesitate to ask for a clarification. Here's my code so far:

 1 import random 2 import string 8 from openpyxl import workbook 9 from openpyxl import load_workbook 10 import xlrd 11 12 wb = load_workbook('names.xlsx') #reads the names.xlsx file 13 wb.save('names_mod.xlsx') #saves it with the name: names_mod.xslx 14 15 def randompassword(stringLength=8): #creates a random password 16 lettersAndDigits = string.ascii_letters + string.digits 17 return ''.join(random.choice(lettersAndDigits) for i in range(stringLength)) 18 19 def username(stringLength=5): #creates a random username 20 lettersAndDigits = string.ascii_letters + string.digits 21 return ''.join(random.choice(lettersAndDigits) for i in range(stringLength))

Thankful for any help.