OReilly eBooks Page 64

What is bad data? Some people consider it a technical phenomenon, like missing values or malformed records, but bad data includes a lot more. In this handbook, data expert Q. Ethan McCallum has gathered 19 colleagues from every corner of the data arena to reveal how they've recovered from nasty data problems. From cranky storage to poor representation to misguided policy, there are many paths to bad data. Bottom line? Bad data is data that gets in the way. This book explains effective ways to get around it. Among the many topics covered, you'll discover how to: Test drive your data to see if it's ready for analysis Work spreadsheet data into a usable form Handle encoding problems that lurk in text data Develop a successful web-scraping effort Use NLP...

SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. If you're working with a relational database--whether you're writing applications, performing administrative tasks, or generating reports--you need to know how to interact with your data. Even if you are using a tool that generates SQL for you, such as a reporting tool, there may still be cases where you need to bypass the automatic generation feature and write your own SQL statements. To help you attain this fundamental SQL knowledge, look to Learning SQL, an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language. Learning SQL moves you quickly through ...

Makers around the globe are building low-cost devices to monitor the environment, and with this hands-on guide, so can you. Through succinct tutorials, illustrations, and clear step-by-step instructions, you'll learn how to create gadgets for examining the quality of our atmosphere, using Arduino and several inexpensive sensors. Detect harmful gases, dust particles such as smoke and smog, and upper atmospheric haze-substances and conditions that are often invisible to your senses. You'll also discover how to use the scientific method to help you learn even more from your atmospheric tests. Get up to speed on Arduino with a quick electronics primer Build a tropospheric gas sensor to detect carbon monoxide, LPG, butane, methane, benzene, and many other...

Want to create animated graphics for iPhone, iPad, and the Web, using familiar Adobe features? You've come to the right guide. Adobe Edge Animate Preview 7: The Missing Manual shows you how to build HTML5 graphics with Adobe visual tools. No programming experience? No problem. Adobe Edge Animate writes all the code for you. With this book, you'll be designing great-looking web elements in no time. The important stuff you need to know: Get to know the workspace. Learn how Adobe Edge Animate performs its magic. Create and import graphics. Make drawings with Animate's tools, or use art you've designed in other programs. Work with text. Build menus, label buttons, provide instructions, and perform other tasks. Jump into animation. Master Animate's elemen...