Data Integration

Data Science    |    Beginner
  • 10 videos | 37m 32s
  • Includes Assessment
  • Earns a Badge
Rating 3.9 of 55 users Rating 3.9 of 55 users (55)
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

  • 3m 29s
    In this video, learn how to use csvjoin to join CSV data. FREE ACCESS
  • 2m 47s
    In this video, find out how to use the cat function to join separate logs into a single file. FREE ACCESS
  • Locked
    3.  Sorting Text Files
    4m 35s
    During this video, you will learn how to sort lines in a text file. FREE ACCESS
  • Locked
    4.  Merging XML Data
    5m 50s
    In this video, you will learn how to merge separate XML files into a single schema. FREE ACCESS
  • Locked
    5.  Aggregating Data
    3m 46s
    In this video, you will aggregate data from a CSV file into a table of summarized values. FREE ACCESS
  • Locked
    6.  Normalizing Data
    3m 11s
    During this video, you will learn how to normalize data from structured sources. FREE ACCESS
  • Locked
    7.  Denormalizing Data
    3m 1s
    In this video, you will normalize data from a structured source. FREE ACCESS
  • Locked
    8.  Pivoting Data Tables
    3m 51s
    Find out how to use pivot tables to cross-tabulate data. FREE ACCESS
  • Locked
    9.  Homogenizing Rows
    4m 56s
    In this video, you will learn how to insert missing values in a data set. FREE ACCESS
  • Locked
    10.  Exercise: Merge Two CSV Documents into One
    2m 6s
    Find out how to use csvjoin to merge two compatible CSV documents into one. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Visualizing Data for Impact: Analyzing Misleading Visualizations
Rating 4.6 of 30 users Rating 4.6 of 30 users (30)
Course CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Channel CompTIA Data+
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Installation & Introduction
Rating 3.3 of 91 users Rating 3.3 of 91 users (91)
Course Software Project Management Communication Skills
Rating 4.5 of 371 users Rating 4.5 of 371 users (371)
Course Azure Data Fundamentals: Modern Data Warehousing
Rating 4.3 of 63 users Rating 4.3 of 63 users (63)