Data Integration
Data Science
10 Videos | 42m 2s - Includes Assessment
- Earns a Badge
Data integration is the last step in the data wrangling process where data is put into its useable and structured format for analysis. Explore examples of practical tools and techniques for data integration.
WHAT YOU WILL LEARN
-
use csvjoin to concatenate CSV data
use the cat function to concatenate separate logs into a single file
sort lines in a text file
merge separate xml files into a single schema
aggregate data from a CSV file into a table of summarized values -
normalize data from unstructured sources
denormalize data from a structured source
use pivot tables to cross tabulate data
insert missing values in a data set
use csvjoin to merge two compatible CSV documents into one
IN THIS COURSE
-
1.Joining CSV Data3m 29sUP NEXT
-
2.Concatenating Log Files2m 47s
-
3.Sorting Text Files4m 35s
-
4.Merging XML Data5m 50s
-
5.Aggregating Data3m 46s
-
6.Normalizing Data3m 11s
-
7.Denormalizing Data3m 1s
-
8.Pivoting Data Tables3m 51s
-
9.Homogenizing Rows4m 56s
-
10.Exercise: Merge Two CSV Documents into One2m 6s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.
