Question

1. Create a new list which increases the salary by 50% if the length of the person’s name is 3 characters or less or starts with 'S'. Print this list.

2. Sort the list created in part e. by salary descending. Write this data to a CSV file called sorted2.csv

3. Create a function that prints the elements of a list as defined in part e in CSV form. Test this function on the list you created in part e

Answer 1

Thanks for the remaining part, here is the last solution part of the question. Let me know for an y help with any other quesitons. thanks ======================================================================= data = data = " 2 Joe 95000 4 Steve 35000 1 Samantha 150000 10 Leah 99000 6 Riley 53215" # Use split to divide up the messy data where fields are separated by spaces. values = data.split() # Create individual lists for the ids, names, and salaries and print out each list. ids = [] names = [] salaries = [] for i in range(0, len(values), 3): ids.append(values[i]) names.append(values[i + 1]) salaries.append(int(values[i + 2])) # Write the data to a CSV file called cleaned.csv in the form: id, name, salary. filename = 'cleaned.csv' with open(filename, 'w+') as outfile: outfile.write('{},{},{}\n'.format('id', 'name', 'salary')) for i in range(len(ids)): outfile.write('{},{},{}\n'.format(ids[i], names[i], salaries[i])) # Create a new list where each element is a list representing a row in the CSV file. with open(filename, 'r') as infile: records = [] for line in infile.readlines()[1:]: line = [(val) for val in line.strip().split(',')] if len(line) == 3: records.append([int(line[0]), line[1], int(line[2])]) # Print this list with each record (i.e. element) on a new line. print(records) # Create and print a new list which includes only rows where the id >= 4 and id <= 8, or the person has a salary > 50000. filtered_list = [] for record in records: if 4 <= record[0] <= 8 and record[2] > 50000: filtered_list.append(record) filtered_list.sort(key=lambda record: record[0]) filename = 'sorted.csv' with open(filename, 'w+') as outfile: outfile.write('{},{},{}\n'.format('id', 'name', 'salary')) for record in filtered_list: outfile.write('{},{},{}\n'.format(record[0], record[1], record[2])) #Create a function that prints the elements of a list as defined in part e in CSV form. def print_list(aList): for record in aList: print(record) #Create a new list which increases the salary by 50% if the length of the person’s name is 3 characters or less or starts with 'S'. updated_list=[] for record in records: if len(record[1])<=3 or record[1][0]=='S': increment_salary = int(record[2]*1.5) updated_list.append([record[0],record[1],increment_salary]) updated_list.sort(key= lambda record:record[2],reverse=True) # Print this list. print_list(updated_list) filename = 'sorted2.csv' with open(filename, 'w+') as outfile: outfile.write('{},{},{}\n'.format('id', 'name', 'salary')) for record in updated_list: outfile.write('{},{},{}\n'.format(record[0], record[1], record[2])) print_list(updated_list)

=================================================================