
Excel Data Cleansing Straight to the Point
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Content
- Intro
- _GoBack
- a
- About the Author
- Acknowledgments
- INTRODUCTION
- A Data Cleansing Example
- Data Cleansing as a Skill
- The Straight to the Point Ethos
- CORRECTING NAMES: PROPER CASE
- COMPARING LISTS: WHAT'S OVER HERE THAT'S NOT OVER THERE?
- Invitations and Responses (Match It All Up!)
- Determining What's over There That's Not over Here
- A Word About Strategy
- PEELING, PARSING, AND SEGMENTING
- Extracting the First Name (Using Flash Fill)
- Splitting by a Single Delimiter: Separating the City from the Name
- Splitting into Rows: Getting Those People Out of There!
- IDENTIFYING DUPLICATE RECORDS: FUZZY MATCHING
- Excel's Duplicate Remover: The Hazard!
- Reality, Context, and Strategy: Flagging Records for Review Instead of Clearing Duplicates
- MERGING AND APPENDING MULTIPLE WORKBOOKS
- FROM USELESS TO USEFUL: FLATTENING A REPORT
- Let's Flatten Some Stuff!
- FINAL THOUGHTS
- Index
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.