pandas: final assessment

This covers the whole course. Take it after the last module.

Final quiz

1. What is a pandas Series?
2. How do you select the column 'price' from df?
3. What does df.head(3) return?
4. What does fillna(0) do?
5. Which join keeps only keys present in both tables?
6. df.iloc[0:2] returns…
7. Which gives the mean salary per department?
8. What does s.str.strip().str.lower() do to ' Hello '?
9. (df['end'] - df['start']).dt.days gives…
10. Which read_csv option keeps zip codes like 02134 intact?
11. What does pd.concat([a, b], ignore_index=True) do with a column only a has?
12. A merge on customer_id doubles some orders. The cause is most likely…
13. Why is apply(axis=1) slow on large DataFrames?
14. A pivot_table cell is NaN. What does that mean?
15. Under Copy-on-Write, df[df.a > 0]['b'] = 1 …
16. NumPy's std and pandas' std give different values for the same data because…

Practical assessment: An order analysis

Without using hints, analyse a set of order, product and customer files with pandas and produce a short checked report.

Final project

A monthly sales report: A shop exports raw sales, products and customers as CSV files. Build a pandas script that cleans them, merges them with checks and produces a monthly report by category, region and customer.

How it is evaluated

To complete this course