PacktLib: Using OpenRefine

Using OpenRefine

Credits

Foreword

About the Authors

About the Reviewers

www.PacktPub.com

Preface

Diving Into OpenRefine

Introducing OpenRefine

Recipe 1 – installing OpenRefine

Recipe 2 – creating a new project

Recipe 3 – exploring your data

Recipe 4 – manipulating columns

Recipe 5 – using the project history

Recipe 6 – exporting a project

Recipe 7 – going for more memory

Summary

Analyzing and Fixing Data

Recipe 1 – sorting data

Recipe 2 – faceting data

Recipe 3 – detecting duplicates

Recipe 4 – applying a text filter

Recipe 5 – using simple cell transformations

Recipe 6 – removing matching rows

Summary

Advanced Data Operations

Recipe 1 – handling multi-valued cells

Recipe 2 – alternating between rows and records mode

Recipe 3 – clustering similar cells

Recipe 4 – transforming cell values

Recipe 5 – adding derived columns

Recipe 6 – splitting data across columns

Recipe 7 – transposing rows and columns

Summary

Linking Datasets

Recipe 1 – reconciling values with Freebase

Recipe 2 – installing extensions

Recipe 3 – adding a reconciliation service

Recipe 4 – reconciling with Linked Data

Recipe 5 – extracting named entities

Summary

Regular Expressions and GREL

Regular Expressions and GREL

Regular Expressions and GREL

Regular Expressions and GREL

Index