7318AFE Business Data Analytics

Data Analysis/Analytics is a process of transforming data into useful information for supporting decision-making. In this course, we cover a wide range of basic analytical techniques, visual, descriptive, inferential, predictive and prescriptive - to interpret and analyse business/market data in order to develop solutions for real-world business problems. The course heavily emphasizes practical problem-solving exercises and using Business Analytics through software applications.

Assignment 1

Use the dataset NBA2018.xlsx to answer the following questions with Python.

In [ ]:

import pandas as pd
nba=pd.read_excel('NBA2018.xlsx')

Use "info" to get the information of the dataset. How many players? What are the columns?

How many teams are in the dataset? Get the number of players of each team.

Obain the 10 players with highest salary.

Get the highest salary of each team.

Who are the highest pay players of each team?

How many players earn between 20,000,000 and 25,000,000?

Obtain the list of players with first name 'Mike'. Hint: df.str.match()

Get a subset of Golden State Warriors (GSW). Report the top 5 highest pay players of GSW.

Get a subset of Cleveland Caveliers (CLE), the Runner-up team in the season. Who is the highest pay of CLE? Who is the lowest? How many times the highest-pay player than more than the lowest?

Combine the two subsets (GSW & CLE) created in questions 8 & 9. Find the top 4 pay players in the combined set. Compute the total salary of these 4 players