Book Image

Data Manipulation with R - Second Edition

By : Jaynal Abedin, Kishor Kumar Das
Book Image

Data Manipulation with R - Second Edition

By: Jaynal Abedin, Kishor Kumar Das

Overview of this book

<p>This book starts with the installation of R and how to go about using R and its libraries. We then discuss the mode of R objects and its classes and then highlight different R data types with their basic operations.</p> <p>The primary focus on group-wise data manipulation with the split-apply-combine strategy has been explained with specific examples. The book also contains coverage of some specific libraries such as lubridate, reshape2, plyr, dplyr, stringr, and sqldf. You will not only learn about group-wise data manipulation, but also learn how to efficiently handle date, string, and factor variables along with different layouts of datasets using the reshape2 package.</p> <p>By the end of this book, you will have learned about text manipulation using stringr, how to extract data from twitter using twitteR library, how to clean raw data, and how to structure your raw data for data mining.</p>

Related Content you might be interested in

Current Title:

Small book image
Data Manipulation with R - Second Edition
Jaynal Abedin | Kishor Kumar Das
Mar, 2015 | 130 pages
No titles found
Table of Contents (13 chapters)
Data Manipulation with R Second Edition
Data Manipulation with R Second Edition
Credits
Credits
About the Authors
About the Authors
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Introduction to R Data Types and Basic Operations
Introduction to R Data Types and Basic Operations
Getting different versions of R
Installing R on different platforms
Installing and using R libraries
Comparing R with other software
R as an enterprise solution
Writing commands in R
R data types and basic operations
The R object structure and mode conversion
Factor and its types
Missing values in R
Summary
2
Basic Data Manipulation
Basic Data Manipulation
Acquiring data
Vector and matrix operations
Factor manipulation
Factors from numeric variables
Date processing using lubridate
Character manipulation
Subscripting and subsetting
Summary
3
Data Manipulation Using plyr and dplyr
Data Manipulation Using plyr and dplyr
Applying the split-apply-combine strategy
Introducing the plyr and dplyr libraries
Comparing base R and plyr
Powerful data manipulation with dplyr
Summary
4
Reshaping Datasets
Reshaping Datasets
Typical layout of a dataset
New layout of a dataset
Reshaping the dataset from the typical layout
Reshaping the dataset with the reshape package
The reshape2 package
Summary
5
R and Databases
R and Databases
R and different databases
Relational databases in R
R and sqldf
Data manipulation using sqldf
Summary
6
Text Manipulation
Text Manipulation
Text data and its source
Text processing using default functions
Working with Twitter data
Summary
Index
Index

Relational databases in R

In this section, we will try to provide a concise overview of different packages in R for handling massive data and illustrate some of them.

A popular approach to dealing with bigger datasets is the use of SQL, a different programming language. It might not be difficult for someone to learn another programming language, but as we are dealing with and talking about using R, the community of R users try to develop specialized packages to deal with large datasets. Those contributed packages successfully create interfaces between R and different database software packages that use relational database management systems, such as MySQL (RMySQL), PostgreSQL (RPgSQL), and Oracle (ROracle). To get the full benefit of these specialized packages, we have to install third-party software, and one of the most popular packages is RMySQL. This package allows us to make connections between R and the MySQL server.

MySQL, which can deal with a mid-size, multi-platform RDBMS is a popular...

Previous Section
End of Section 3
Next Section