Description |
1 online resource (56 pages) |
Physical Medium |
polychrome |
Description |
text file |
Contents |
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 MATCHINGExcel'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 |
Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
Subject |
Microsoft Excel (Computer file)
|
|
Microsoft Excel (Computer file) |
|
Microsoft Excel (Computer file) |
|
Electronic spreadsheets -- Computer programs.
|
|
Electronic spreadsheets -- Computer programs. |
|
Business -- Computer programs.
|
|
Business -- Computer programs. |
Genre/Form |
Electronic books.
|
ISBN |
9781615471508 (electronic book) |
|
1615471502 (electronic book) |
|