[{"_1":2,"_64":-5,"_65":-5},"loaderData",{"_3":4,"_33":34,"_62":-5,"_63":-5},"root",{"_5":-5,"_6":-5,"_7":8,"_20":-5,"_21":22,"_23":24,"_27":28},"user","shoppingCartId","shoppingCart",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":12},"count",0,"free",true,"updatedAt","2026-01-01T20:24:40.907Z","paymentGateway","STRIPE","cartItems",[],"loading","toast","locale","en","constants",{"_25":26},"paypalClientId","AX53Cwz8jR6rVVzzZiZNWWXl0dGagi-GZrjG-S3Ua14E5nrKMn7DxDQ730O4R8LusLPp49ALn6aRVaEy","publishers",{"_29":30,"_31":32},"companies",[],"universities",[],"routes/_store+/_readers+/email_author.$slug/route",{"_35":36,"_61":-5},"book",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48},"id","Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6Qm9va1Byb2R1Y3QvMzgzNw","title","Making Data Play Nice","state","unpublished","contactAuthorMethod","email","aboutText","

Getting data for a story is only the start of the process - sometimes it just won't play nice.

Making Data Play Nice covers the skills to get your data into the right shape to give you answers to the questions you need to ask. Techniques include:

Using data cleaning tools including Google Refine\n
\nExtracting data from data - getting years from dates, splitting postcodes and other common problems
\nDealing with names - how to deal with titles, middle names and other peculiarities
\nMaking data work with pivot tables - tackling headers spread across multiple rows, merged cells and other issues
\nGrabbing extra data using spreadsheets
Grabbing extra data using APIs\n
\nCombining multiple spreadsheets into one
Advanced cleaning using Google Refine Expression Language (GREL)

","authors",[49],{"_37":50,"_51":52,"_5":53},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci8zOTgx","name","Paul Bradshaw",{"_54":55},"avatar",{"_56":57,"_58":59,"_60":12},"url","https://d39qdlcrvnra4b.cloudfront.net/avatars/27713/medium/paulbradshaw_Amsterdam.jpeg?1425583071","styleName","medium","exists","currentUser","routes/_store+/_layout","routes/_store+/_readers+/_layout","actionData","errors"]

Email the Author