Bowling lab based on the pdf ive shared below but you cannot use victors. Beginner programBowling7.cpp// Header files for I/O and string#include <iostream>#include <iomanip>#include <fstream>#include <string>using namespace std;// declaration of functions sumArray() and printArray()// declaration of main programint main(){// 1) connect to the input fileifstream fin("bowling.txt");// declare arrays belowstring Team, Member;int Score;// 2) initialize array accumulators to zero// 3) display a descriptive messagecout << "This program reads the lines from the file bowling.txt to determine\n"<< "the winner of a bowling match.The winning team, members and scores\n"<< "are displayed on the monitor.\n";// 4) attempt to input the first line of the filefin >> Member >> Team >> Score;// 5) test ifstream.eof() conditionwhile (!fin.eof()){// 6) test team color is blue // 7) then store blue member and score// 8) increase blue array accumulator // 9) else store white member and score// 10) increase white array accumulator// 11) attempt to input next line from filefin >> Member >> Team >> Score;}// 12) if blue team score is larger// 13 then display blue team as winner with the team// 14) else display white team as winner with the team}// implement function sumArray() below/* 1. initialize accumulator to 02. loop over initialized array indices3. increase accumulator by indexed array element4. return accumulator*/// implement function printArray() below/* 1. displaythe team name as the winner2. loop over initialized array indices3. display member and score for that array index*/

Using the attached CSV,Step 1: Read the CSV data into NumPy and Pandas.Step 2: Use Statistics/Linear Algebra concepts and determine PatientID, count (No-Shows=Yes).Step 3: Calculate Neighbourhood, count (No-Shows=Yes).Step 4: Create output dataset.For your submission, include the following:Attach a Python script.An output screenshot.

ObjectivesCreate, edit, save and print an Excel WorkbookEnter data and apply basic formatting to a WorksheetCreate, modify and format charts to display informationCreate, sort and filter an Excel TableCreate, modify and use formulas and functions to return informationOverviewMs. Chavez has asked you to create a spreadsheet for three of the top Realtors for the past month for the company you created the newsletter for in the last module. In the spreadsheet, she would like to be able to see the total sales by city and by realtor as well as the income to the Realtor and the company at 4% each commission on each selling price. Include a separate worksheet in the spreadsheet document with the name and logo of the company you created in the previous module (copy/paste from Word to Excel for these).Sales are as follows:Murray – Sold 8 houses in the cities shown at the prices below:Denver - 115,000Brighton - 362,000Louisville - 657,000Aurora - 539,000Lakewood - 282,000Lafayette - 795,000Lone Tree - 604,000Broomfield - 436,000Guled – Sold 4 houses at the following prices:Lousiville - 748,000Broomfield - 133,800Aurora - 352,000Thornton - 579,000Gutierrez – Sold 5 houses at the following prices:Aurora - 1,782,072Denver - 922,000Broomfield - 728,200Lakewood - 255,000Thornton - 499,000InstructionsCreate a Spreadsheet:The layout for your spreadsheet needs to have the ability to calculate:Total sales for each RealtorTotal sales per city in the Metro areaAverage Sale per cityAverage Sale per RealtorTotal Commission per RealtorTotal Commission for the moving companyAverage Commission per RealtorTo complete the calculations based on commissions, enter the commission percentage (4%) one time on your spreadsheet, and use an Absolute Reference to calculate each individual commission amount. Do not create a new formula for each cell for those calculations.Format:Use the formatting techniques learned in this Module, and include the following at a minimum:Borders and ShadingMerged CellsUse proper cell format for each cell based on the information in the cellInclude the company Logo (from Module 2) on the Spreadsheet in a separate worksheetChart:Create two Charts and place them in a New WorksheetOne Chart for total sales by RealtorOne Chart for total sales by CityUse the Chart Format of your choice