Joining Data with data.table in R
This course will show you how to combine and merge datasets with data.table.
Comienza El Curso Gratis4 horas13 vídeos47 ejercicios16.254 aprendicesDeclaración de cumplimiento
Crea Tu Cuenta Gratuita
o
Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.¿Entrenar a 2 o más personas?
Probar DataCamp for BusinessPreferido por estudiantes en miles de empresas
Descripción del curso
In the real world, data sets typically come split across many tables while most data analysis functions in R are designed to work with single tables of data. In this course, you'll learn how to effectively combine data sets into single tables using data.table. You'll learn how to add columns from one table to another table,
how to filter a table based on observations in another table, and how to identify records across multiple tables matching complex criteria. Along the way, you'll learn how to troubleshoot failed join operations and best practices for working with complex data sets. After completing this course you'll be well on your way to be a data.table master!
¿Entrenar a 2 o más personas?
Obtén a tu equipo acceso a la plataforma DataCamp completa, incluidas todas las funciones.- 1
Joining Multiple data.tables
GratuitoThis chapter will show you how to perform simple joins that will enable you to combine information spread across multiple tables.
- 2
Joins Using data.table Syntax
In this chapter you will perform joins using the data.table syntax, set and view data.table keys, and perform anti-joins.
Joins using data.table syntax50 xpRight join with the data.table syntax100 xpInner join with the data.table syntax100 xpAnti-joins100 xpSetting and viewing data.table keys50 xpSetting keys100 xpGetting keys100 xpIncorporating joins into your data.table workflow50 xpExploring the Australian population100 xpFinding multiple matches100 xpExploring world life expectancy100 xp - 3
Diagnosing and Fixing Common Join Problems
This chapter will discuss common problems and errors encountered when performing data.table joins and show you how to troubleshoot and avoid them.
- 4
Concatenating and Reshaping data.tables
In the last chapter of this course you'll learn how to concatenate observations from multiple tables together, how to identify observations present in one table but not another, and how to reshape tables between long and wide formats.
Concatenating two or more data.tables50 xpConcatenating data.table variables100 xpConcatenating a list of data.tables100 xpSet operations50 xpIdentifying observations shared by multiple tables100 xpRemoving duplicates while combining tables100 xpIdentifying observations unique to a table100 xpMelting data.tables50 xpMelting a wide table100 xpMore melts100 xpCasting data.tables50 xpCasting a long table100 xpCasting multiple columns100 xpSplitting by multiple groups100 xp
¿Entrenar a 2 o más personas?
Obtén a tu equipo acceso a la plataforma DataCamp completa, incluidas todas las funciones.conjuntos de datos
IMDBNetflixAustralia PopulationLife ExpectancySchool DatabaseHeart DiseaseEbola CasesGDPcolaboradores
requisitos previos
Data Manipulation with data.table in RScott Ritchie
Ver MásPostdoctoral Researcher in Systems Genomics
¿Qué tienen que decir otros alumnos?
¡Únete a 15 millones de estudiantes y empieza Joining Data with data.table in R hoy mismo!
Crea Tu Cuenta Gratuita
o
Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.