Create a Python program that takes a badly formatted data set and converts it into CSV. Details:

• The data has three fields which we will assume are always present: a number, a name (that contains no spaces), and a salary. The data may have multiple spaces between the fields and all fields for the same row may be on different lines. Data set is here:

  2   Joe    95000 4 Steve
     35000    1  Samantha   150000     10 Leah   99000
   6   Riley   53215     7   Ashley   23424
   15    Sheyanne 225000   9  Dave  35235
      

• Put a comment at the top of the Python file called lab5q2with your name and student number. 
• Put the data above into the Python code file using a triple quoted string. 
• Use split to divide up the messy data where fields are separated by spaces. 
• Create individual lists for the ids, names, and salaries and print out each list. 
• Output the data in CSV form:id,name,salary. 
• Create a new list where each element is a list representing a row in the CSV file. Print this list. 
• Create and print a new list which includes only rows where the id >= 4 and id <= 8, or the person has a salary > 50000. 
• Output the original list in CSV form sorted by id ascending. 
• Create and print a new list which for each row increases the salary by 50% if the length of the person's name is 3 characters or less or starts with'S'. 
• Output the original list in CSV form sorted by salary descending. 
• Create a function to output in CSV form and use it multiple times rather than duplicating code.

APlusGrades

Not Rated (0)

Status NEW Posted 21 Jul 2017 01:07 PM My Price 12.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m Â----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I

Not Rated(0)

• Buy Answer