Data Transformation


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
Once data is filtered the next step is to transform it into a usable format. In this course, you'll explore examples of practical tools and techniques for data transformation.

Target Audience
Individuals with some programming and math experience working toward implementing data science in their everyday work

Prerequisites
None

Expected Duration (hours)
0.8

Lesson Objectives

Data Transformation

  • start the course
  • convert CSV data to JSON format
  • convert XML data to JSON format
  • create SQL inserts from CSV data
  • extract CSV data from SQL
  • change delimiters in a csv file from commas to tabs
  • convert basic date formats to standard ISO 8601 format
  • convert numeric formats within a CSV document
  • round floating point decimals to two places within a CSV document
  • use optical character recognition (OCR) to extract text from a jpeg image
  • use optical character recognition (OCR) to extract text from a pdf document
  • read various date formats and convert to standard compliant ISO 8601 format

    • Course Number:
    df_dses_a04_it_enus

    Expertise Level
    Beginner