Question: We will build one Python application via which users can perform various analytics tasks on data in 2-D table (similar to Spreadsheet) format which looks

We will build one Python application via which users can perform various analytics tasks on data in 2-D table (similar to Spreadsheet) format which looks like:

Column Name 1

Column Name 2

Column Name 3

Column Name N

As an example, in basketball world, its very common nowadays to collect players statistics for coaches and analysts reference. To this purpose, players numbers such as points made, number of assists, numbers of steals, number of rebounds etc are recorded for each game using the 2-D table format above. The statistics such as average points per game, average assists per game, average rebounds per game for each player are then calculated according to some formula. We like to build an application for this purpose.

For this assignment, you will write a script to implement 2-D table container with the specification given by users. The specification includes the number of columns, the name of each column, the number of rows, and the column values of each row.

The script you write should do the following:

Allows users to enter the table specification and content via command line:

Number of columns of the table

Number of rows of the table

The list of column names

The list of values (one per column) for every row

Implement the 2-D table container defined by user inputs with Python objects that you learned so far and store data in it.

Perform necessary arithmetic operations on the data to collect the pre-defined statistics, e.g. average points per game for each player in our example.

Although your application should work for any kind of data (above basketball data just one example), you could use different sets of data for testing and demo purpose.

Please make sure that you do the following:

Add comments in your code

Attach the test data and results in your deliverable.

Please explain all steps with details

and use the latest version of python

thanks

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!