|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9910786702603321 |
|
|
Autore |
Hogarth Margaret |
|
|
Titolo |
Data clean-up and management : a practical guide for librarians / / Margaret Hogarth with contributions from Kenneth Furuta |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Oxford : , : Chandos Publishing, , 2012 |
|
|
|
|
|
|
|
ISBN |
|
|
|
|
|
|
Edizione |
[1st edition] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (579 p.) |
|
|
|
|
|
|
Collana |
|
Chandos information professional series |
|
|
|
|
|
|
Altri autori (Persone) |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
|
|
Soggetti |
|
Libraries - Data processing |
Data editing |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
Description based upon print version of record. |
|
|
|
|
|
|
Nota di bibliografia |
|
Includes bibliographical references and index. |
|
|
|
|
|
|
Nota di contenuto |
|
Cover; Data Clean-up and Management: A practical guide for librarians; Copyright; Contents; List of figures; List of tables; About the authors; 1 Introduction (why this book is needed); What makes this book unique?; Why library data is important; The book's outline; 2 Commonalities; Microsoft Office Excel; MarcEdit; Microsoft Access; XML; Commonalities; Capture and use; Standardization; Data import issues; Technical skills; Project management challenges; 3 Defining data; Rule 1: define data points; Rule 2: apply data point definitions; Rule 3: count the right apples |
Rule 4: avoid capturing redundant data4 Types of data issues; Microsoft Excel vs Microsoft Access; General data-handling edicts; Data issues: importing data; 5 Microsoft Excel techniques; Creating datasheets; Selecting cells; Copying; Sorting; Filter; AutoSum; Sum; Fill; 6 Data clean-up in Excel; Common dirty data scenarios; The usefulness of delimiting; System limitations; Removing extra characters; 7 Excel: combining data; IF statements; The TEXT function; PivotTables and filtering; VLOOKUP; HLOOKUP; MATCH; 8 Additional tools; PDFs; Notepad; Microsoft Word |
Global update in an integrated library systemRegular expressions; Excel; Access; Macros; XML; MarcEdit; The MARC tools window; 9 Access techniques; What is a database?; Access; Planning a database; Preparing data for a database; Adding a table to a database; 10 Access |
|
|
|
|