Data Transformation

Data Science    |    Beginner
  • 11 videos | 42m 58s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 59 users Rating 4.4 of 59 users (59)
After filtering data, the next step is to transform it into a usable format. Explore examples of practical tools and techniques for data transformation.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 3m 12s
    In this video, you will convert CSV data to JSON format. FREE ACCESS
  • 3m 44s
    In this video, you will learn how to convert XML data to JSON format. FREE ACCESS
  • Locked
    3.  Converting CSV to SQL
    3m 52s
    In this video, learn how to insert CSV data into an SQL database. FREE ACCESS
  • Locked
    4.  Converting SQL to CSV
    3m 53s
    In this video, you will extract CSV data from a SQL database. FREE ACCESS
  • Locked
    5.  Changing CSV Delimiters
    3m 52s
    In this video, you will change the delimiters in a csv file from commas to tabs. FREE ACCESS
  • Locked
    6.  Converting Dates
    4m 49s
    During this video, you will learn how to convert basic date formats to the standard ISO 8601 format. FREE ACCESS
  • Locked
    7.  Converting Numbers
    3m 33s
    In this video, learn how to convert numeric formats within a CSV document. FREE ACCESS
  • Locked
    8.  Rounding Numbers
    3m 24s
    Learn how to round floating point decimals to two places within a CSV document. FREE ACCESS
  • Locked
    9.  OCR JPEG Images
    5m 28s
    In this video, you will use optical character recognition (OCR) to extract text from a JPEG image. FREE ACCESS
  • Locked
    10.  Extracting Text from PDF Files
    4m 56s
    During this video, you will learn how to use optical character recognition (OCR) to extract text from a PDF document. FREE ACCESS
  • Locked
    11.  Exercise: Convert Dates to ISO 8601
    2m 17s
    Learn how to read various date formats and convert them to the standard compliant ISO 8601 format. 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 Leading through Change
Rating 4.7 of 40 users Rating 4.7 of 40 users (40)
Channel Data and Analytics at Work
Rating 2.0 of 1 users Rating 2.0 of 1 users (1)
Channel Data Visualization
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Using Data to Find Data: Data Discovery & Exploration
Rating 4.0 of 37 users Rating 4.0 of 37 users (37)
Course Data Literacy for All Bootcamp: Session 1 Replay
Rating 4.4 of 430 users Rating 4.4 of 430 users (430)
Course Fundamentals of AI & ML: Introduction to Artificial Intelligence
Rating 4.4 of 2070 users Rating 4.4 of 2070 users (2070)