Question

Design and write a python program that will read the attached excel file into a numpy two-dimensional array. The program should perform the following actions: 1. do not read column 1 into the numpy array since it contains the row headers 2. do not read row 1 into the numpy array since it contains the column headers 3. use the column and row headers to create 2 one-dimensional lists for printing 4. print the array created from the spreadsheet and produce output showing the data with row and column totals and headers 1 Department 2 Apparel 3 Baseball 4 Basketball 5 Bike & Skate 6 Exercise 7 Fishing 8 Footwear 9 Game Room 10 Golf 11 Hockey 12 Hunting 13 Lacrosse 14 Running 15 Winter Sports 16 Total Atlanta 2600.00 Boston 3200.00 1200.00 1800.00 1325.00 2875.00 1035.00 2675.00 1500.00 875.00 1875.00 1000.00 1800.00 2400.00 34350.00 57910.00 Chicago San Diego 3800.00 3700.00 1350.00 2100.00 2250.00 1400.00 1225.00 2450.00 3250.00 3775.00 1250.00 2750.00 3575.00 3250.00 1900.00 1050.00 925.00 5400.00 1950.00 750.00 650.00 725.00 1750.00 1375.00 2800.00 2650.00 2750.00 550.00 29425.00 31925.00 St. Louis 3200.00 2475.00 1750.00 1650.00 2950.00 1450.00 2950.00 1275.00 1250.00 1650.00 950.00 1150.00 2000.00 1550.00 26250.00 Total 16500.00 3500.00 1800.00 1500.00 10625.00 9000.00 8150.00 2650.00 15500.00 2350.00 1875.00 1300.00 4750.00 850.00 2000.00 1750.00 1925.00 8835.00 14325.00 7025.00 13200.00 7075.00 5325.00 7825.00 11775.00 1250.00 30100.00 40450.00 175610.00

          Design and write a python program that will read the attached
excel file into a numpy two-dimensional array. The program should
perform the following actions: 
1. do not read column 1 into the numpy array since it contains
the row headers
2. do not read row 1 into the numpy array since it contains the
column headers
3. use the column and row headers to create 2 one-dimensional
lists for printing
4. print the array created from the spreadsheet and produce
output showing the data with row and column totals and headers
1 Department 2 Apparel 3 Baseball 4 Basketball 5 Bike & Skate 6 Exercise 7 Fishing 8 Footwear 9 Game Room 10 Golf 11 Hockey 12 Hunting 13 Lacrosse 14 Running 15 Winter Sports 16 Total
Atlanta 2600.00
Boston 3200.00 1200.00 1800.00 1325.00 2875.00 1035.00 2675.00 1500.00 875.00 1875.00 1000.00 1800.00 2400.00 34350.00 57910.00
Chicago San Diego 3800.00 3700.00 1350.00 2100.00 2250.00 1400.00 1225.00 2450.00 3250.00 3775.00 1250.00 2750.00 3575.00 3250.00 1900.00 1050.00 925.00 5400.00 1950.00 750.00 650.00 725.00 1750.00 1375.00 2800.00 2650.00 2750.00 550.00 29425.00 31925.00
St. Louis 3200.00 2475.00 1750.00 1650.00 2950.00 1450.00 2950.00 1275.00 1250.00 1650.00 950.00 1150.00 2000.00 1550.00 26250.00
Total
16500.00
3500.00 1800.00 1500.00
10625.00
9000.00
8150.00
2650.00
15500.00
2350.00 1875.00 1300.00 4750.00 850.00 2000.00 1750.00 1925.00
8835.00
14325.00
7025.00
13200.00
7075.00
5325.00
7825.00
11775.00
1250.00 30100.00
40450.00 175610.00

design and write a python program that will read the attached excel file into a numpy two dimensional array the program should perform the following actions 1 do not read column 1 into the n 40176

Added by Marie N.

Question

Please give Ace some feedback