Skip to Main Content
Extending Excel with Python and R
book

Extending Excel with Python and R

by Steven Sanderson, David Kun
April 2024
Beginner to intermediate content levelBeginner to intermediate
344 pages
7h 56m
English
Packt Publishing
Content preview from Extending Excel with Python and R

7

Pivot Tables and Summary Tables

In the realm of data analysis and spreadsheet manipulation, a pivot table is a powerful tool that enables users to transform and summarize large datasets into more manageable and insightful formats. By providing an organized and dynamic way to analyze data, pivot tables have become an indispensable asset for professionals across various domains.

So, what is a pivot table? A pivot table is a data processing technique employed in spreadsheet software, such as Microsoft Excel or Google Sheets, to analyze and extract meaningful insights from complex datasets. It allows users to restructure and condense large amounts of information into a concise, comprehensible format, facilitating better decision-making and data ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Data Visualization with Python and JavaScript, 2nd Edition

Data Visualization with Python and JavaScript, 2nd Edition

Kyran Dale
Python for Excel

Python for Excel

Felix Zumstein

Publisher Resources

ISBN: 9781804610695Supplemental Content