Data Integration
Data Science
| Beginner
- 10 Videos | 37m 32s
- 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 datause the cat function to concatenate separate logs into a single filesort lines in a text filemerge separate xml files into a single schemaaggregate data from a CSV file into a table of summarized values
-
normalize data from unstructured sourcesdenormalize data from a structured sourceuse pivot tables to cross tabulate datainsert missing values in a data setuse 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.