Communicating Results

Question 1

What is the .groupby() method

Answer 1

This allows you to group data by columns and aggregate info about groupings. The numeric_only excludes values that aren’t numeric.

df.groupby(“column_name”).mean(numeric_only=True)
or
df.groupby([“workclass”,”race”], as_index=False)[“capital-gain”].mean()

Question 2

What is summation or .sum()?

Answer 2

It aggregates data vertically .sum(axis=0) or horizontally .sum(axis=1).

df_census[[“capital_gain”,”capital-loss”]].sum()

Question 3

Visualize how to get the sum while using .groupby and then sort the values in descending order

Answer 3

df.groupby(by=”column”).sum(numeric_only=True).sort_values(by=”column2”, ascending=False)

Question 4

What are the measures of center?

Answer 4

Mean = .mean()
Median = .medain()
Mode = .mode()

Question 5

What is the mean?

Answer 5

It is the average or sum of all numbers in set/by number of values in the set

Question 6

What is the median

Answer 6

The center value in a set. Always sort the values first then calculate the median.

Question 7

What is the mode?

Answer 7

It is the value with the highest frequency in a set