Import NumPy under the alias np
.
Import pandas under the alias pd
.
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
.
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
#Solution goes here
Given the dataset data
, print a new DataFrame that shows the total sales for each Organization
.
Given the dataset data
, print a new DataFrame that applies the describe
method to each organization.