Question

Create a program (Lab9_Act1_Write.py) that will read in data from the keyboard and store it in a file. Your program should prompt the user for the name of the file to use and then request values be entered until the user is done. This data should be written to two files: a text file, user_file_name.txt and a comma separated value file, user_file_name.csv.

To help you with decision making, we suggest that you ask the user to input data representing students’ grades for different assignments (that is, create a grade book with at least four grade columns as shown below). The first row will contain the column headers, the second row will contain the assignment point values. Starting with row three (3), each row will contain a student name (first and last) and the grades earned by the student. Note the required formatting of the text file: choose a column width (may vary from column to column); the first column is left-justified; all other columns are right-justified.

user_file_name.txt

Name hw1 hw2 mid-term final

Point value 10 10 100 100

Petr Little 9 8 85 78

Sam Tarley 10 10 99 100

Joff King 4 2 55 61

user_file_name.csv

Name,hw1,hw2,mid-term,final

Point value,10,10,100,100

Petr Little,9,8,85,78

Sam Tarley,10,10,99,100

Joff King,4,2,55,61

a) As an example, you might first ask for a file name and open the two files for writing, Lab Assignment # 9 2

b) You may want to ask about the number of columns in the data table or not (your choice)

c) Prompt the user to enter the data for row 1 (header row), then row 2 (another header row), then row 3, etc.

i. You need to tell the user how to enter data, for example: “enter data separating columns by colon, or semicolon, or vertical bar, etc.” (please, do not use comma)

ii. You’ll need some way to stop the process (e.g. the user types nothing and presses the Enter key or the user enters -1, etc.)

iii. Suggestion: please build a pyramid, not an arch (you know what this means, right?)

d) Your program should write each row of the table to the files. i. It’s your choice as to whether you do this as the data is read, or wait until all the data is entered before saving. ii. Note that the data should be formatted before writing to the output files.

e) To test this code, enter at least five rows of data (see the example given above). Then open the files you created with a text editor and Excel and check that the code worked properly

PYTHON PLEASE!!!!!!

Answer 1

Х Lè driver.py - C:\Users\krishna Downloads\driver.py (3.8.5) File Edit Format Run Options Window Help 1 # importing csv module 2 import csv 3 4 # reading file name from user 5 file_name = input("Enter the name of the file: ") 6 9 row 7 # temporary variables 8 data = [] [] 10 11 # suggesting the user to enter data in required format 12 print("Enter the data seperating columns by semicolon(;).") 13 14 # taking first header from user 15 header1 = input("Enter the header1 : ") 16 # splitting the data with semicolon as delimiter 17 row = header1.split(";") 18 string 19 # iterating over the row 20 for index in range(len(row)): 21 if index == 0:

22 # left justifing the first element 23 string += row[index].ljust(15) 24 else: 25 # right justifying the remaining elements 26 string += row[index].rjust(10) 27 # adding header to the data(list) 28 data.append(string) 29 30 # header2 same as header1 31 header2 = input("Enter the header2: ") 32 row = header2.split(";") 33 string 34 for index in range(len(row)): 35 if index == 0: 36 string += row[index].ljust(15) 37 else: 38 string row[index].rjust(10) 39 data.append(string) 40 41 # while loops until user want to exit +=

43 42 while(True): # taking data from user and storing in row 44 input("Enter the data: ") row = 45 46 47 # checking if user wants to break or not if row = = or string "-1" or string break == == "\n": 48 49 50 51 52 53 54 55 # if not splitting the data with semicolon as delimiter row = row.split(";") string # justifying the data same as header for index in range(len( row)): if index == 0: string += row[index].ljust(15) else: string += row[index].rjust(10) else: data.append(string) 56 57 58 59 60 61

62 63 # opening the given file in write text mode 64 with open((file_name + ".txt"), "wt") as textfile: 65 # iterating over each row in data(list) 66 for row in data: 67 # writing each row to textfile 68 textfile.write(row) 69 # appending the new line character to each row textfile.write("\n") 70 71 72 # opening the given file in csv write mode 73 with open((file_name + ".csv"), "w", newline = "") as csvfile: 74 # iterating over each row in data(list) 75 for index in range(len(data)): 76 Ist = [] 77 if index != 0 : 78 # making each row(string) into list(lst) by splitting with space("") as delimiter 79 lst = data[index].split() 80 # concatinating the first and last name of student

81 82 83 Ist[0] = lst[0] + + lst[1] # deleting the last name from the data(lst) del lst[1] else: Ist = data[index].split() 84 85 86 87 88 89 90 # creating writer object on csvfile writer = csv.writer(csvfile) # writing each ist(list) to the csvfile writer.writerow(lst)

========== RESTART: C:\Users\krishna\Downloads\driver.py ========== ========== Enter the name of the file: user_file_name Enter the data seperating columns by semicolon(;). Enter the header1 : Name; hw1; hw2; mid-term; final Enter the header2: Point value; 10; 10; 100; 100 Enter the data: Petr Little; 9; 8; 85; 78 Enter the data: Sam Tarley; 10; 10; 99; 100 Enter the data: Joff King; 4; 2; 55; 61 Enter the data: >> | Ln: 19 Col: 4

A1 fic Name hw1 1 Name 2 Point value 3 Petr Little 4 Sam Tarley 5 Joff King 6 hw2 10 9 10 mid-term final 10 8 8 10 2 4

- х user_file_name - Notepad File Edit Format View Help Name Point value Petr Little Sam Tarley Joff King hw1 10 9 10 hw2 mid-term 10 100 8 85 10 99 2 55 final 100 78 100 61 4

Raw_code:

# importing csv module
import csv

# reading file name from user
file_name = input("Enter the name of the file: ")

# temporary variables
data = []
row = []

# suggesting the user to enter data in required format
print("Enter the data seperating columns by semicolon(;).")

# taking first header from user
header1 = input("Enter the header1 : ")
# splitting the data with semicolon as delimiter
row = header1.split(";")
string = ""
# iterating over the row
for index in range(len(row)):
if index == 0:
# left justifing the first element
string += row[index].ljust(15)
else:
# right justifying the remaining elements
string += row[index].rjust(10)
# adding header to the data(list)
data.append(string)

# header2 same as header1
header2 = input("Enter the header2: ")
row = header2.split(";")
string = ""
for index in range(len(row)):
if index == 0:
string += row[index].ljust(15)
else:
string += row[index].rjust(10)
data.append(string)

# while loops until user want to exit
while(True):
# taking data from user and storing in row
row = input("Enter the data: ")

# checking if user wants to break or not
if row == "" or string == "-1" or string == "\n":
break

# if not splitting the data with semicolon as delimiter
row = row.split(";")
string = ""
# justifying the data same as header
for index in range(len(row)):
if index == 0:
string += row[index].ljust(15)
else:
string += row[index].rjust(10)
else:
data.append(string)

# opening the given file in write text mode
with open((file_name + ".txt"), "wt") as textfile:
# iterating over each row in data(list)
for row in data:
# writing each row to textfile
textfile.write(row)
# appending the new line character to each row
textfile.write("\n")

# opening the given file in csv write mode
with open((file_name + ".csv"), "w", newline = "") as csvfile:
# iterating over each row in data(list)
for index in range(len(data)):
lst = []
if index != 0:
# making each row(string) into list(lst) by splitting with space("") as delimiter
lst = data[index].split()
# concatinating the first and last name of student
lst[0] = lst[0] + " " + lst[1]
# deleting the last name from the data(lst)
del lst[1]
else:
lst = data[index].split()
  
# creating writer object on csvfile
writer = csv.writer(csvfile)
# writing each lst(list) to the csvfile
writer.writerow(lst)