GrokkingDataScientist.tar.gz

jupyter_job

Master the skills that can get you a $100K+ salary even if you bunked your statistics classes. 

No need to waste hours and hours on browsing from one article to the next and piecing together the info you need to grasp important topics. No need to get overwhelmed by the information overload. Find easy to follow, hands-on, and fun explanations of all the essential topics in one place so you can quickly and efficiently learn what you need to thrive as a data scientist.

"Is this course right for me?" Continue to read to decide for yourself!

- "I want to understand this data science concept. Let me Google it". Then after hours of surfing, reading random articles, and invoking the heavens, you are more confused than before.
- "Data science is the sexiest and highest paying job of the 21st century. I want to become a data scientist too".
- "I have a basic knowledge of Python, willingness to learn, and commitment to become a great data scientist."

Is that you? If yes, you are at the right place.

Grokking Data Science

### 11. Pivot Table

We have seen how grouping lets us explore relationships within a dataset. A pivot table is a similar operation. You have probably encountered it in spreadsheets or some other programs that operate on tables. If you have ever worked with Excel, Pandas can be used to create Excel style pivot tables.

The pivot table takes simple column-wise data as input, and groups the entries into a two-dimensional table to give a multidimensional summary of the data. ***Hard to understand? Let's understand the concept with an example!***

Say we want to **compare the *$$$* earned by the various directors per year**. We can create a pivot table using `pivot_table`; we can set *index ='Director'* (row of the pivot table) and get the yearly revenue information by setting *columns = 'Year'*:


# 11. Pivot Table

We have seen how grouping lets us explore relationships within a dataset. A pivot table is a similar operation. You have probably encountered it in spreadsheets or some other programs that operate on tables. If you have ever worked with Excel, Pandas can be used to create Excel style pivot tables.

The pivot table takes simple column-wise data as input, and groups the entries into a two-dimensional table to give a multidimensional summary of the data. ***Hard to understand? Let's understand the concept with an example!***

Say we want to **compare the *$$$* earned by the various directors per year**. We can create a pivot table using `pivot_table`; we can set *index ='Director'* (row of the pivot table) and get the yearly revenue information by setting *columns = 'Year'*:


Python Fundamentals for Data Science

The Fundamentals of Statistics

Machine Learning 101

End-to-End Machine Learning Project

The Real Talk

Pandas DataFrame Operations - Pivot Tables and Functions

11. Pivot Table