1, read the data from the Excel spreadsheet to python 2 d list (15 points)
2, the results of the analysis the first line of the file needs to include: student id, name, time (5 points)
3, the calculation of two rooms one hall and three rooms two hall two family house, how many sets sold separately, and the average unit price, rounded integer (15 points)
4, two rooms one hall and three rooms two hall two family house, respectively, the total amount of the maximum and minimum rounded integer (15 points)
5, a, b, c three salesman sold many houses respectively, as well as the total amount of sales, rounded integer (15 points)
6, find out the highest total amount of sales champion salesman, sold the house the largest number of ace salesman (15 points)
7, to cover an analysis result written to TXT documents, document name, student number _ name. TXT, and py files in the same directory, utf-8 encoding (10)
8, detailed code comments, variable definitions meaning clear (10)
The analysis results of TXT document content reference as follows, part of the calculation result of X said:
Owner name contact number room door area unit price salesman
Customer 1 13557112358 5-101 two rooms one hall 125.12 6821 b
Customer 2 13557112359 5-102-3 rooms two hall 158.23 7024 c
Customer 3 13557112360 5-201 two rooms one hall 125.12 7125 b
Customer 4 13557112361 5-202-3 rooms two hall 158.23 7257 b
Customer 5 13557112362 5-301 - two rooms one hall 125.12 7529 c
Customer 6 13557112363 5-302-3 rooms two hall 158.23 7622 b
Customer 7 13557112364 5-401 two rooms one hall 125.12 8023 personnel
Customer 8 13557112365 5-402-3 rooms two hall 158.23 8120 b
Client 9, 13557112366-501, two rooms one hall 125.12 8621 b
Customers 10, 13557112367 5-502-3 rooms two hall 158.23 8710 personnel
The customer 11 13557112368 5-601 two rooms one hall 125.12 8925 c
Customer 12 13557112369 5-602-3 rooms two hall 158.23 9213 personnel
Customer 13 13557112370 5-701 two rooms one hall 125.12 9358 b
Customer's 14, 13557112371 5-702-3 rooms two hall 158.23 9458 personnel
Customer 15 13557112372 5-801 two rooms one hall 125.12 9624 b
Customer 16 13557112373 5-802-3 rooms two hall 158.23 9810 b
Customer 17 13557112374 5-901 two rooms one hall 125.12 9950 personnel
Customer 18 13557112375 5-902-3 rooms two hall 158.23 10250 personnel
Customer 19 13557112376 5-1001 two rooms one hall 125.12 11235 personnel
Customer 20 13557112377 5-1002-3 rooms two hall 158.23 12548 b
Customer 21 13557112378 5-1101 two rooms one hall 125.12 13658 c
Customer 22 13557112379 5-1102-3 rooms two hall 158.23 13562 personnel
Customer 23, 13557112380-1201 two rooms one hall 125.12 14521 c
Customer 24 13557112381 5-1202-3 rooms two hall 158.23 15400 personnel