Chapter 1: Extract the data you need

In this chapter, you will learn how to :

  • select rows and columns
  • order the rows and columns
  • create new column based on existing ones
  • combine these operations into a one line command
  • group and summarize rows