corpus.blog
41554 blogs · 4,504,310 posts Claim your blog
Record · corpus.blog/posts/01a0bde1-b510-71ea-8788-9abdd1146b36

What is dirty data and how do I clean it? A great big guide for data journalists

onlinejournalismblog.com · published 18 April 2023

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at onlinejournalismblog.com Wayback capture
0blogs citing
First cited
—
Most recent
—
Rank this month
not ranked
Links from this post
42
Words captured
2,363

Cited by

No blog we hold has cited this post yet.

Links from this post

Link
Host
https://onlinejournalismblog.com/wp-content/uploads/2023/04/cat-isolated-on-the-white-1461322189kwk.jpg
onlinejournalismblog.com
https://www.publicdomainpictures.net/en/view-image.php?image=161671&picture=cat-isolated-on-the-white
publicdomainpictures.net
https://onlinejournalismblog.com/wp-content/uploads/2023/02/dirty-data-problems.png
onlinejournalismblog.com
https://data.police.uk/data/
data.police.uk
https://onlinejournalismblog.com/wp-content/uploads/2023/04/stopandsearch.png
onlinejournalismblog.com
Scientists rename human genes to stop Microsoft Excel from misreading them as dates
theverge.com
https://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7
genomebiology.biomedcentral.com
https://trumpexcel.com/excel-is-function/
trumpexcel.com
https://www.goskills.com/Excel/Resources/LEN-function-Excel
goskills.com
https://exceljet.net/excel-functions/excel-clean-function
exceljet.net
https://onlinejournalismblog.com/2016/07/19/how-to-fix-spreadsheet-dates-that-are-in-both-us-and-uk-formats/
onlinejournalismblog.com
https://support.microsoft.com/en-us/office/change-the-format-of-a-cell-0a45ff85-ee24-4276-94e8-aed6083e8050
support.microsoft.com
https://onlinejournalismblog.com/wp-content/uploads/2023/04/removeduplicates.png
onlinejournalismblog.com
https://support.microsoft.com/en-us/office/find-and-remove-duplicates-00e35bea-b46a-4d5d-b28e-66a552dc138d
support.microsoft.com
https://www.lifewire.com/highlight-duplicates-in-google-sheets-4693470
lifewire.com
https://zapier.com/blog/google-sheets-data-cleanup/
zapier.com
https://onlinejournalismblog.com/wp-content/uploads/2023/04/fingerprint-cluster-popup.png
onlinejournalismblog.com
http://www.padjo.org/tutorials/open-refine/clustering/
padjo.org
https://openrefine.org/download
openrefine.org
https://openrefine.org/docs/technical-reference/clustering-in-depth
openrefine.org
https://onlinejournalismblog.com/2013/02/21/a-sample-dirty-dataset-for-trying-out-google-refine/
onlinejournalismblog.com
https://support.google.com/docs/answer/10098582?hl=en-GB
support.google.com
https://www.myonlinetraininghub.com/excel-upper-lower-and-proper-functions
myonlinetraininghub.com
https://leanpub.com/spreadsheetstories
leanpub.com
https://leanpub.com/excelparaperiodistas
leanpub.com
https://onlinejournalismblog.com/wp-content/uploads/2023/04/screenshot-2023-04-17-at-16.38.24.png
onlinejournalismblog.com
https://onlinejournalismblog.com/wp-content/uploads/2023/04/parserator.png
onlinejournalismblog.com
https://parserator.datamade.us/
parserator.datamade.us
https://datamade.us/blog/parse-name-or-parse-anything-really/
datamade.us
https://cran.r-project.org/web/packages/humaniformat/vignettes/Introduction.html
cran.r-project.org
https://openrefine.org/docs/manual/facets
openrefine.org
https://robertorocha.info/using-chatgpt-to-clean-data-an-experiment/
robertorocha.info
https://onlinejournalismblog.com/wp-content/uploads/2013/11/excel_multiple_headings.png
onlinejournalismblog.com
https://onlinejournalismblog.com/2013/11/13/how-to-clean-up-spreadsheet-headings-that-run-across-multiple-rows-using-open-refine/
onlinejournalismblog.com
https://onlinejournalismblog.com/wp-content/uploads/2023/02/tidydata.png
onlinejournalismblog.com
https://r4ds.had.co.nz/tidy-data.html
r4ds.had.co.nz
https://www.digitalocean.com/community/tutorials/pandas-melt-unmelt-pivot-function
digitalocean.com
https://tidyr.tidyverse.org/reference/pivot_longer.html
tidyr.tidyverse.org
https://tidyr.tidyverse.org/reference/pivot_wider.html
tidyr.tidyverse.org
https://towardsdatascience.com/what-is-tidy-data-d58bb9ad2458
towardsdatascience.com
https://dl.acm.org/doi/abs/10.1145/3544548.3581271
dl.acm.org
https://onlinejournalismblog.com/wp-content/uploads/2023/04/screenshot-2023-04-27-at-13.21.48.png
onlinejournalismblog.com