Data Transformation
Data Science
| Beginner
- 11 Videos | 42m 58s
- Includes Assessment
- Earns a Badge
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 formatconvert XML data to JSON formatcreate SQL inserts from CSV dataextract CSV data from SQLchange delimiters in a csv file from commas to tabsconvert basic date formats to standard ISO 8601 format
-
convert numeric formats within a CSV documentround floating point decimals to two places within a CSV documentuse optical character recognition (OCR) to extract text from a jpeg imageuse optical character recognition (OCR) to extract text from a pdf documentread various date formats and convert to standard compliant ISO 8601 format
IN THIS COURSE
-
1.Converting CSV to JSON3m 12sUP NEXT
-
2.Converting XML to JSON3m 44s
-
3.Converting CSV to SQL3m 52s
-
4.Converting SQL to CSV3m 53s
-
5.Changing CSV Delimiters3m 52s
-
6.Converting Dates4m 49s
-
7.Converting Numbers3m 33s
-
8.Rounding Numbers3m 24s
-
9.OCR JPEG Images5m 28s
-
10.Extracting Text from PDF Files4m 56s
-
11.Exercise: Convert Dates to ISO 86012m 17s
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.