Problem 1

Import NumPy under the alias np.

In [ ]:
 

Problem 2

Import pandas under the alias pd.

In [ ]:
 

Problem 3

We will again be using salesperson data to test your knowledge of the groupby method. Given the dataset data, print a new DataFrame that shows the mean sales per salesperson, grouped by Organization.

In [ ]:
data = pd.DataFrame([ ['Coca-Cola', 'Nick', 200],

                    ['Coca-Cola', 'Joel', 120],

                    ['Pepsi','Taylor', 125],

                    ['Pepsi','Josiah', 250],

                    ['Dr. Pepper','Josh', 150],

                    ['Dr. Pepper','Micaiah', 500]], 
                    columns = ['Organization', 'Salesperson Name', 'Sales'])

data
In [ ]:
#Solution goes here

Problem 4

Given the dataset data, print a new DataFrame that shows the total sales for each Organization.

In [ ]:
 

Problem 5

Given the dataset data, print a new DataFrame that applies the describe method to each organization.

In [ ]: