Hello:
I have some code, which is not finished yet:
nanedtuple: Q1Sales. Some kind of nested namedtuples list.
Please advise on how to show the best salesman's quarterly results (lQ1Sales).
I have some code, which is not finished yet:
import collections Sales = collections.namedtuple('Sales', ['ID', 'QuarterNo', 'QuarterSales', 'TotalSales']) Q1Sales = collections.namedtuple('Q1Sales', ['ID', 'QuarterNo', 'QuarterSales']) lSales = [] lQ1Sales = [] sale1_1 = Sales(ID = 1, QuarterNo = 1, QuarterSales = 100, TotalSales = 100) sale1_2 = Sales(ID = 1, QuarterNo = 2, QuarterSales = 200, TotalSales = 300) sale1_3 = Sales(ID = 1, QuarterNo = 3, QuarterSales = 300, TotalSales = 600) sale1_4 = Sales(ID = 1, QuarterNo = 4, QuarterSales = 400, TotalSales = 1000) sale2_1 = Sales(ID = 2, QuarterNo = 1, QuarterSales = 10, TotalSales = 10) sale2_2 = Sales(ID = 2, QuarterNo = 2, QuarterSales = 20, TotalSales = 30) sale2_3 = Sales(ID = 2, QuarterNo = 3, QuarterSales = 30, TotalSales = 60) sale2_4 = Sales(ID = 2, QuarterNo = 4, QuarterSales = 40, TotalSales = 100) sale3_1 = Sales(ID = 3, QuarterNo = 1, QuarterSales = 30, TotalSales = 30) sale3_2 = Sales(ID = 3, QuarterNo = 2, QuarterSales = 400, TotalSales = 430) sale3_3 = Sales(ID = 3, QuarterNo = 3, QuarterSales = 500, TotalSales = 930) sale3_4 = Sales(ID = 3, QuarterNo = 4, QuarterSales = 600, TotalSales = 1530) lSales.append(sale1_1) lSales.append(sale1_2) lSales.append(sale1_3) lSales.append(sale1_4) lSales.append(sale2_1) lSales.append(sale2_2) lSales.append(sale2_3) lSales.append(sale2_4) lSales.append(sale3_1) lSales.append(sale3_2) lSales.append(sale3_3) lSales.append(sale3_4) Q1Sale1_1 = Q1Sales(ID = 1, QuarterNo = 1, QuarterSales = 100) Q1Sale1_2 = Q1Sales(ID = 1, QuarterNo = 2, QuarterSales = 200) Q1Sale1_3 = Q1Sales(ID = 1, QuarterNo = 3, QuarterSales = 300) Q1Sale1_4 = Q1Sales(ID = 1, QuarterNo = 4, QuarterSales = 400) Q1Sale2_1 = Q1Sales(ID = 2, QuarterNo = 1, QuarterSales = 10) Q1Sale2_2 = Q1Sales(ID = 2, QuarterNo = 2, QuarterSales = 20) Q1Sale2_3 = Q1Sales(ID = 2, QuarterNo = 3, QuarterSales = 30) Q1Sale2_4 = Q1Sales(ID = 2, QuarterNo = 4, QuarterSales = 40) Q1Sale3_1 = Q1Sales(ID = 3, QuarterNo = 1, QuarterSales = 30) Q1Sale3_2 = Q1Sales(ID = 3, QuarterNo = 2, QuarterSales = 400) Q1Sale3_3 = Q1Sales(ID = 3, QuarterNo = 3, QuarterSales = 500) Q1Sale3_4 = Q1Sales(ID = 3, QuarterNo = 4, QuarterSales = 600) lQ1Sales.append(Q1Sale1_1) lQ1Sales.append(Q1Sale1_2) lQ1Sales.append(Q1Sale1_3) lQ1Sales.append(Q1Sale1_4) lQ1Sales.append(Q1Sale2_1) lQ1Sales.append(Q1Sale2_2) lQ1Sales.append(Q1Sale2_3) lQ1Sales.append(Q1Sale2_4) lQ1Sales.append(Q1Sale3_1) lQ1Sales.append(Q1Sale3_2) lQ1Sales.append(Q1Sale3_3) lQ1Sales.append(Q1Sale3_4) lSales.sort(key=lambda tup: -tup[3]) print(lSales[0])For the employees who have achived the sales records, I want to sort them with total sales, and show the people with the maximum total sale, but I want to show his quarterly sales from
nanedtuple: Q1Sales. Some kind of nested namedtuples list.
Please advise on how to show the best salesman's quarterly results (lQ1Sales).