Excel Data Cleansing : Straight to the Point
(2019)

Nonfiction

eBook

Provider: hoopla

Details

PUBLISHED
[United States] : Holy Macro! Books, 2019
Made available through hoopla
DESCRIPTION

1 online resource

ISBN/ISSN
9781615471508 (electronic bk.) MWT12432500, 1615471502 (electronic bk.) 12432500
LANGUAGE
English
NOTES

This Straight to the Point guide provides an introduction to data cleansing, which also goes by names such as data munging and data wrangling. Whatever the name, it basically means doing what needs to be done to make data useful and trustworthy. Data cleansing can include the following tasks: Deleting unnecessary headers, Deleting summary rows, Filling in gaps, Flattening a report, Merging and appending data from multiple sources. Pulling data from source X to complete data in source Splitting names from addresses, Identifying and deleting duplicate records, Converting units of measurement in multiple sources

Mode of access: World Wide Web

Additional Credits