Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Neo4j

Authors: Gregory Jordan

1st Edition

1484200225, 9781484200223

More Books

Students also viewed these Databases questions