Question

1. Create a single list that contains the following collection of data in the order provided:

   [1121, "Jackie Grainger", 22.22,

   1122, "Jignesh Thrakkar", 25.25,

   1127, "Dion Green", 28.75, False,

   24.32, 1132, "Jacob Gerber",

   "Sarah Sanderson", 23.45, 1137, True,

   "Brandon Heck", 1138, 25.84, True,

   1152, "David Toma", 22.65,

   23.75, 1157, "Charles King", False,

   "Jackie Grainger", 1121, 22.22, False,

   22.65, 1152, "David Toma"]

   
   The data above represents employee information exported from an Excel spreadsheet. Whomever typed the data in originally didn't give much care to how the information was formatted, unfortunately. Each line of data has in it employee information (the whole number), the name of the employee (the string), and the employee's hourly wage (the decimal number). Some rows have extra information in them from a column in the spreadsheet that no one can remember what its purpose was.
   
   Note that the presence of a couple of new data types in the above - "float" values (the numbers with the decimals in them) and "bool" [short for boolean] values (True and False).
   
2. Assume that the above information is a small sample of the company's data. Programmatically sort the information into three different lists: one for employee numbers, one for employee names, and one for employee salary information.
   
3. No duplicate data should make its way into the new lists.
   
4. For each value in the list containing hourly wage information, multiply the current value by 1.3 (since benefits are about 30% of a person's salary) and store each value in a list called total_hourly_rate. Programmatically determine the maximum value in the list and if it's over over 37.30, throw a warning message that someone's salary may be a budget concern.
   
5. Determine if anyone's total hourly rate is between 28.15 and 30.65. If they are, add the hourly rate a new list called underpaid_salaries.
   
6. For each value in the list that contains unmodified salary information, calculate a raise in dollars according to the following rules:
   
   If the hourly rate is between 22 and 24 dollars per hour, apply a 5% raise to the current rate. If the hourly rate is between 24 and 26 dollars per hour, apply a 4% raise to the current rate. If the hourly rate is between 26 and 28 dollars per hour, apply a 3% raise to the current rate. All other salary ranges should get a standard 2% raise to the current rate.
   
   Add each new value you calculate to a new list called company_raises.
   
7. Design your own complex condition with no fewer than four different truth tests in it (all conditions must be on one line, in other words). Above your condition, write out in comments the exact behavior you are implementing with Python.

Answer 1

#list that stores employee numbers
employeee_numbers=[1121,1122,1127,1132,1137,1138,1152,1157]
#list that stores employee names
employee_name=["Jackie Grainger","Jignesh Thrakkar","Dion Green","Jacob Gerber","Sarah Sanderson","Brandon Heck","David Toma","Charles King"]
#list that stores wages per hour employee
hourly_rate=[22.22,25.25,28.75,24.32,23.45,25.84,22.65,23.75]
#list that stores salary employee
company_raises=[]
max_value=0
#list used to store total_hourly_rate
total_hourly_rate=[]

underpaid_salaries=[]

#loop used to musltiply values in hourly_wages with 1.3
#and store in new list called total_hourly_rate
#len() is used to get length of list
for i in range(0,len(hourly_rate)):

#append value to the list total_hourly_rate
total_hourly_rate.append(hourly_rate[i]*1.3)

for i in range(0,len(total_hourly_rate)):

#finds the maximum value
if(total_hourly_rate[i]>max_value):

max_value=total_hourly_rate[i] #stores the maximum value

if(max_value>37.30):

print("\nSomeone's salary may be a budget concern.\n")

for i in range(0,len(total_hourly_rate)):

#check anyone's total_hourly_rate is between 28.15 and 30.65
if(total_hourly_rate[i]>=28.15 and total_hourly_rate[i]<=28.15):

underpaid_salaries.append(total_hourly_rate[i])

for i in range(0,len(hourly_rate)):

#check anyone's hourly_rate is between 22 and 24
if(hourly_rate[i]>22 and hourly_rate[i]<24):

#adding 5%
hourly_rate[i]+=((hourly_rate[i]/100)*5)

elif(hourly_rate[i]>24 and hourly_rate[i]<26):

#adding 4%
hourly_rate[i]+=((hourly_rate[i]/100)*4)

elif(hourly_rate[i]>26 and hourly_rate[i]<28):

#adding 3%
hourly_rate[i]+=((hourly_rate[i]/100)*3)

else:

#adding 2% for all other salaries
hourly_rate[i]+=((hourly_rate[i]/100)*2)

#adding all raised value to company_raises
company_raises.extend(hourly_rate)

#The comparison in single line
for i in range(0,len(hourly_rate)):

"""here i used ternary operator"""
hourly_rate[i]= (hourly_rate[i]+((hourly_rate[i]/100)*5)) if (hourly_rate[i]>22 and hourly_rate[i]<24) else (hourly_rate[i]+((hourly_rate[i]/100)*4)) if (hourly_rate[i]>24 and hourly_rate[i]<26) else hourly_rate[i]+((hourly_rate[i]/100)*2)

0 File Edit Foat Ran Options Widow Help list that stores enplcyee numbers employeee numbers-1121, 1122,1127, 1132, 113, 1138, 1152 ,11s #11 st that 5tarM mplay e name enployee name "Jackie Grainger", "Jǐgnesh Thrakkar , Dịcn Green", "Jdeob Gerber", "Sarah Sanderson" , "Drandon lleck", "David Poma", "Charles 4list that stores wages per hour employee hourly-ra te-[22.22.25.25, 2ล.75, 24.32, 23.45, 25.84, 22.65, 23.751 tlist LheL 브Lures salary employee company raises-) max value-0 King" tiisL used Lu 느Lure LuLa1-hourly-rdLe total hourly rate-] unnderpaid salaries [l loo 5od to masltiply valucs in hourly wagcs with 1.3 tand store in new list called total _hourly rate i1en is used to get length of list for i in rangC(Orlan(hourly-ratc)); append value to the list. total_hourly_tate total hourly rate.append(hourly_ratelil1.3) tor i in range(0,len(total hourly_rate)) finds the maxium value if (total_hourlyratelinax_valua max-value=total-hourly-ra teril #stores the maximum value if (max_value>37.30) print("nsomeone's salary may be a budget concern.in" tor i in range (0,len (total_hourly rate) キcheck anyone's tntal hourly rat는 15 b는tw는en 2白. 15 and 30.65 if (total hourly ratelil>-20.15 and total hourly rate i1s-20.15): underpaid salarias,appand total hourly rateli]) tor i In range(0,len (hourly_rate)): cheCK anyone's hourly rate is between 22 and 24 fIhourly rat322 and hourly_ rati24: tadding 5 hourly ratelil(hourly rate Lil/100)5) elif (hourly rate i>24 and hourly ratei]<26) tadding hourly ratelil(hourly rate il/100)4) elifくhourly-ra te [i]>26 and hourly-rate [i]<281 : nourly rateil+- (hourly ratei/1o)3) clsc:

newPythonList.py-sers/svs97/Desktop/newPythonListpy (370 0 Eile Edit at Bun Options Window Help otal ourly rate-I] uriderpaid salaries 11 loop sod to musltiply valucs in hourly wagcs with 1.3 tand store in new list called total _hourly rate 1en is used to get 1ength ot list for i in rango (0,lon (hourly rato)) #append value to the list total-hourly-rate total hourly_rate.append(hourly_ratelil1.3) or i in range (0,len(total hourly_rate)) finds the maxir.um value if (total hourly rateli]ax_valua max-value=total-hourly-ra teri! キstares maximum value the it (max value 37.30) print.("nSomeone's salary may be a hudget concern.in" tor i in range (0,lan (total hourly rate) :heck anyone's tntal h u riv rata, 1 betw:en 2ล. 15 and 30.65 ir (total _hourly rateli-20.15 and total_hourly_rateil-20.15): underpaid salaries.append total hourly ratelil! for i range(Orlen(hourly-rate)) : check anyone's hourly rate is between 22 and 24 if{hourly-rate [1] >22 and h urly-rate [i124): fadding 5 hourly ratelil(hourly rate il/100)5) elifくhourly-rate [1]>24 and hourly-rate [i]<26): #auding 4 hourly rateil(hourly rateil/100)4) clif (hourly rat2 and hourly ratei]<28) #edding 3 nourly rateil+-hourly ratei1/100) 3) clsc: in #edding 2% for all other salaries nourly rateil+-hourly ratei1/100) 2) adding all raiscd valuc to companyraiscs ccmpany rais는s.exterd (hourly rate) Tho corparison in singlo linc or i in range(0,len thourly rate)): ""here i used ternary operator"" hourly rateli] (hourly rate [1]+/ (hourly rata [Í)/100) 5)) İf {hourly rate(1)22 and hourly rata [ İjc24) 0150 (hourly rate [1]+/ (hourly rata [Í)/100) 4)) İf (hourly rate [i]>24 and hourly r