Question: 13) In this question you will analyze the docking data of a fleet of futuristic spaceships at various space stations. Given a file named data.csv

 13) In this question you will analyze the docking data of

13) In this question you will analyze the docking data of a fleet of futuristic spaceships at various space stations. Given a file named data.csv which is a text file in which each line records the number of visits of a particular spacecraft at various space stations in a given month: The line headings represent the names of the spaceships and the column headers represent names of the Space stations. The different fields in the file are separated by a comma and therefore if we look directly at the file, it will look like as follows:. Earth-Alpha LunarDocks MarsStation DeepSpace1 DeepSpace2 USS-Enterprise USS-Voyager 3 USS-Peres 10 4 USS-Pathfinder USS-Enterprise USS-Voyager USS-Peres 4 USS-Pathfinder EarthAlpha, LunarDocks, MarsStation, DeepSpacel, DeepSpace2 USS-Enterprise, 6,6,6,6,6 USS-Voyager,2,3,0,4,1 <....> In the above table, each spacecraft may appear several times, since each line represents the number of visits that a spacecraft makes in a single month. Develop a python program to create a summary table as shown below as a console output. You MUST use a dictionary that will map to each spacecraft to its list of visiting amounts at the space stations. Don't use any python libraries. EarthAlpha DeepSpace1 LunarDocks MarsStation DeepSpace2 USS-Enterprise USS-Voyager 4 4. USS-Peres 18 9. USS-Pathfinder 9

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!