![]() 99 Chart Design Principles 103 Google Sheets Charts 113 Bar and Column Charts 114 Histograms 121 Pie, Line, and Area Charts 126 Datawrapper Charts 131 Annotated Charts 132 Range Charts 137 Scatter and Bubble Charts 139 Tableau Public Charts 146 Scatter Charts with Tableau Public 147 Filtered Line Chart 152 iv | Table of Contentsħ. 87 Precisely Describe Comparisons 87 Normalize Your Data 90 Beware of Biased Comparisons 93 Part II. 67 Smart Cleanup with Google Sheets 68 Find and Replace with Blank 69 Transpose Rows and Columns 71 Split Data into Separate Columns 72 Combine Data into One Column 75 Extract Tables from PDFs with Tabula 76 Clean Data with OpenRefine 79 5. 47 Guiding Questions for Your Search 48 Public and Private Data 52 Mask or Aggregate Sensitive Data 56 Open Data Repositories 57 Source Your Data 59 Recognize Bad Data 60 Question Your Data 64 4. 13 Select Your Spreadsheet Tools 15 Download to CSV or ODS Format 17 Make a Copy of a Google Sheet 19 Share Your Google Sheets 20 Upload and Convert to Google Sheets 21 Geocode Addresses in Google Sheets 23 Collect Data with Google Forms 26 Sort and Filter Data 28 Calculate with Formulas 31 Summarize Data with Pivot Tables 33 Match Columns with VLOOKUP 38 Spreadsheet Versus Relational Database 42 iiiģ. 1 Start Sketching Your Data Story 1 Ten Factors When Considering Tools 4 Our Recommended Tools 9 Use a Password Manager 11 2. If any code samples or other technology this work contains or describes is subject to open source licenses or the intellectual property rights of others, it is your responsibility to ensure that your use thereof complies with such licenses and/or rights. Use of the information and instructions contained in this work is at your own risk. While the publisher and the authors have used good faith efforts to ensure that the information and instructions contained in this work are accurate, the publisher and the authors disclaim all responsibility for errors or omissions, including without limitation responsibility for damages resulting from the use of or reliance on this work. The views expressed in this work are those of the authors, and do not represent the publisher’s views. Hands-On Data Visualization, the cover image, and related trade dress are trademarks of O’Reilly Media, Inc. The O’Reilly logo is a registered trademark of O’Reilly Media, Inc. Acquisitions Editor: Andy Kwan Indexer: Sue Klefstad Development Editor: Amelia Blevins Interior Designer: David Futato Production Editor: Katherine Tozer Cover Designer: Karen Montgomery Copyeditor: Stephanie English Illustrator: O’Reilly Media Proofreader: Piper Editorial Consulting, LLC Revision History for the First Edition : First Release See for release details. For more information, contact our corporate/institu‐ tional sales department: 80 or. Online editions are also available for most titles ( ). O’Reilly books may be purchased for educational, business, or sales promotional use. Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472. 978-0-0 Hands-On Data Visualization by Jack Dougherty and Ilya Ilyankou Copyright © 2021 Jack Dougherty and Picturedigits Ltd.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |