Excel Data Cleansing Straight to the Point
Nonfiction, Computers, Application Software, Spreadsheets, Financial Applications
| Author: | Oz du Soleil | ISBN: | 9781615471508 |
| Publisher: | Holy Macro! Books | Publication: | July 23, 2019 |
| Imprint: | Holy Macro! Books | Language: | English |
| Author: | Oz du Soleil |
| ISBN: | 9781615471508 |
| Publisher: | Holy Macro! Books |
| Publication: | July 23, 2019 |
| Imprint: | Holy Macro! Books |
| Language: | English |
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 headersDeleting summary rowsFilling in gapsFlattening a reportMerging and appending data from multiple sourcesPulling data from source X to complete data in source YSplitting names from addressesIdentifying and deleting duplicate recordsConverting units of measurement in multiple sources
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 headersDeleting summary rowsFilling in gapsFlattening a reportMerging and appending data from multiple sourcesPulling data from source X to complete data in source YSplitting names from addressesIdentifying and deleting duplicate recordsConverting units of measurement in multiple sources
