Skip to Content
Data Analysis with R, Second Edition - Second Edition
book

Data Analysis with R, Second Edition - Second Edition

by Tony Fischetti
March 2018
Beginner to intermediate
570 pages
13h 42m
English
Packt Publishing
Content preview from Data Analysis with R, Second Edition - Second Edition

Reshaping, melting, and pivoting data

In this final subsection, we will show how to perform another very common operation quickly and efficiently in data.table. This operation has many names—pivot-table-ing, reshaping, melting/casting, spreading/gathering, converting from long to wide (or vice-versa). But while the nomenclature, I admit, can get pretty complicated, understanding the concept doesn’t have to be! The best first step to explaining this is by the following example:

Here is an example of data that we will, heretofore, refer to as in long format:

     year themonth   N 1: 2016      Sep 225 2: 2016      Aug 215 3: 2016      Jul 411 4: 2016      Jun 169 5: 2016      May 478 ---                 103: 2008      Feb 984104: 2008      Jan 877105: 2016      Mar 360106: 2016      Oct 258107: 2016 Nov 124 ...
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.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

R Data Analysis Cookbook, Second Edition - Second Edition

R Data Analysis Cookbook, Second Edition - Second Edition

Kuntal Ganguly, Davor Lozić, Mzabalazo Z. Ngwenya, Andrew Bauman, Shanthi Viswanathan, Viswa Viswanathan
Regression Analysis with R

Regression Analysis with R

Giuseppe Ciaburro, Pierre Paquay, Manoj Kumar, Shaikh Salamatullah
R: Data Analysis and Visualization

R: Data Analysis and Visualization

Tony Fischetti, Brett Lantz, Jaynal Abedin, Hrishi V. Mittal, Bater Makhabel, Edina Berlinger, Ferenc Illés, Milán Badics, Ádám Banai, Gergely Daróczi, Barbara Dömötör, Gergely Gabler, Dániel Havran, Péter Juhász, István Margitai, Balázs Márkus, Péter Medvegyev, Julia Molnár, Balázs Árpád Szucs, Ágnes Tuza, Tamás Vadász, Kata Váradi, Ágnes Vidovics-Dancs

Publisher Resources

ISBN: 9781788393720