corpus.blog
56,966 blogs · [ { "id": "01a08766-4236-72f4-b2ac-7d1b2dbfe8b0", "title": "Version control your data, not just your code, with the pins library for R and Python", "url": "https://dabblingwithdata.amedcalf.com/2026/01/18/version-control-your-data-not-just-your-code-with-the-pins-library-for-r-and-python/", "published_at": "2026-01-18T18:37:58+00:00" }, { "id": "01a08766-4236-72f4-b2ac-7d1b2eb3d8ee", "title": "Are vast numbers of Britons really exiting the workforce due to long term sickness?", "url": "https://dabblingwithdata.amedcalf.com/2025/05/30/are-vast-numbers-of-britons-really-exiting-the-workforce-due-to-long-term-sickness/", "published_at": "2025-05-30T06:54:36+00:00" }, { "id": "01a08766-4236-72f4-b2ac-7d1b2efb4ffd", "title": "You can finally can turn off Microsoft Excel’s incessant desire to mess up your data by auto-converting it to an inappropriate type", "url": "https://dabblingwithdata.amedcalf.com/2025/02/09/you-can-finally-can-turn-off-microsoft-excels-incessant-desire-to-mess-up-your-data-by-auto-converting-it-to-an-inappropriate-type/", "published_at": "2025-02-09T12:24:26+00:00" }, { "id": "01a08766-4236-72f4-b2ac-7d1b2f751b79", "title": "Most Britons favour legalising assisted dying, irrespective of political affiliation", "url": "https://dabblingwithdata.amedcalf.com/2024/11/29/most-britons-favour-legalising-assisted-dying-irrespective-of-political-affiliation/", "published_at": "2024-11-29T08:46:00+00:00" }, { "id": "01a08766-4236-72f4-b2ac-7d1b2fca22ff", "title": "Aggregating and analysing location data using H3 in Snowflake or R", "url": "https://dabblingwithdata.amedcalf.com/2024/11/03/aggregating-and-analysing-location-data-using-h3-in-snowflake-or-r/", "published_at": "2024-11-03T14:48:45+00:00" }, { "id": "01a08766-4236-72f4-b2ac-7d1b309353ab", "title": "Creating a granular “votes cast” dataset for the last century’s worth of UK General Elections", "url": "https://dabblingwithdata.amedcalf.com/2024/10/06/creating-a-granular-votes-cast-dataset-for-the-last-centurys-worth-of-uk-general-elections/", "published_at": "2024-10-06T11:01:06+00:00" }, { "id": "01a08766-4236-72f4-b2ac-7d1b31801705", "title": "How to get a Wikipedia (or other HTML) table into R as a dataframe", "url": "https://dabblingwithdata.amedcalf.com/2024/08/16/how-to-get-a-wikipedia-or-other-html-table-into-r-as-a-dataframe/", "published_at": "2024-08-16T11:19:34+00:00" }, { "id": "01a08766-4236-72f4-b2ac-7d1b31d4d2b7", "title": "Today’s young Britons really seem to dislike the Conservative party", "url": "https://dabblingwithdata.amedcalf.com/2024/06/26/todays-young-britons-really-seem-to-dislike-the-conservative-party/", "published_at": "2024-06-26T06:49:08+00:00" }, { "id": "01a08766-4236-72f4-b2ac-7d1b32978a34", "title": "Situations when multicollinearity in regression model variables isn’t important", "url": "https://dabblingwithdata.amedcalf.com/2024/05/02/situations-when-multicollinearity-in-regression-model-variables-isnt-important/", "published_at": "2024-05-02T06:42:00+00:00" }, { "id": "01a08766-4236-72f4-b2ac-7d1b32daf287", "title": "The great SQL leading vs trailing commas debate", "url": "https://dabblingwithdata.amedcalf.com/2024/04/28/the-great-sql-leading-vs-trailing-commas-debate/", "published_at": "2024-04-28T12:23:22+00:00" }, { "id": "01a0c505-41ea-70fa-97f1-1557c8476f04", "title": "The Data Is Plural newsletter provides a mass of free and fascinating data", "url": "https://dabblingwithdata.amedcalf.com/2024/04/20/the-data-is-plural-newsletter-provides-a-mass-of-free-and-fascinating-data/", "published_at": "2024-04-20T13:42:00+00:00" }, { "id": "01a0c505-41ea-70fa-97f1-1557c923cf4f", "title": "Notes on the book “Becoming a Data Head”", "url": "https://dabblingwithdata.amedcalf.com/2024/04/04/notes-on-the-book-becoming-a-data-head/", "published_at": "2024-04-04T07:03:00+00:00" }, { "id": "01a0c505-41ea-70fa-97f1-1557c9f0a002", "title": "Using ChatGPT’s Data Analysis bot to analyse your data", "url": "https://dabblingwithdata.amedcalf.com/2024/02/18/using-chatgpts-data-analysis-bot-to-analyse-your-data/", "published_at": "2024-02-18T15:37:16+00:00" }, { "id": "01a0c505-41ea-70fa-97f1-1557cac69afc", "title": "The ongoing battle between human creators and AI trainers", "url": "https://dabblingwithdata.amedcalf.com/2024/01/09/the-ongoing-battle-between-human-creators-and-ai-trainers/", "published_at": "2024-01-09T11:16:26+00:00" }, { "id": "01a0c505-41ea-70fa-97f1-1557cb422ae0", "title": "Does protesting work?", "url": "https://dabblingwithdata.amedcalf.com/2023/12/13/does-protesting-work/", "published_at": "2023-12-13T08:41:27+00:00" }, { "id": "01a0c505-41ea-70fa-97f1-1557cbdf9470", "title": "The differences between what Twitter users say they do and what they actually do", "url": "https://dabblingwithdata.amedcalf.com/2023/09/15/the-differences-between-what-twitter-users-say-they-do-and-what-they-actually-do/", "published_at": "2023-09-15T07:36:00+00:00" }, { "id": "01a0c505-41ea-70fa-97f1-1557cc16ff6b", "title": "Is British gas and oil really 4x as good for the environment as imported fuel?", "url": "https://dabblingwithdata.amedcalf.com/2023/08/10/is-british-gas-and-oil-really-4x-as-good-for-the-environment-as-imported-fuel/", "published_at": "2023-08-10T15:24:34+00:00" }, { "id": "01a0c505-41ea-70fa-97f1-1557cccc9bbe", "title": "Writing conditional filter statements in dplyr", "url": "https://dabblingwithdata.amedcalf.com/2023/07/30/writing-conditional-filter-statements-in-dplyr/", "published_at": "2023-07-30T12:44:39+00:00" }, { "id": "01a0c505-41ea-70fa-97f1-1557cd5c4e69", "title": "The risks of using generative AI when writing code", "url": "https://dabblingwithdata.amedcalf.com/2023/07/18/the-risks-of-using-generative-ai-when-writing-code/", "published_at": "2023-07-18T04:31:00+00:00" }, { "id": "01a0c505-41ea-70fa-97f1-1557cd8ee5ed", "title": "Are AIs developing unpredictable new abilities, or are we just measuring them badly?", "url": "https://dabblingwithdata.amedcalf.com/2023/05/29/are-ais-developing-unpredictable-new-abilities-or-are-we-just-measuring-them-badly/", "published_at": "2023-05-29T07:38:00+00:00" }, { "id": "01a0c517-0dc2-7278-b64f-101f6fc3edf1", "title": "Tips and tricks for knitting R Markdown", "url": "https://dabblingwithdata.amedcalf.com/2023/04/10/tips-and-tricks-for-knitting-r-markdown/", "published_at": "2023-04-10T19:46:00+00:00" }, { "id": "01a0c517-0dc2-7278-b64f-101f704dca9b", "title": "Most rainforest carbon offsets may not actually offset any carbon", "url": "https://dabblingwithdata.amedcalf.com/2023/01/23/most-rainforest-carbon-offsets-may-not-actually-offset-any-carbon/", "published_at": "2023-01-23T07:08:00+00:00" }, { "id": "01a0c517-0dc2-7278-b64f-101f70fcbb47", "title": "Easily write your own custom functions in Excel and Google Sheets with LAMBDA", "url": "https://dabblingwithdata.amedcalf.com/2022/12/03/easily-write-your-own-custom-functions-in-excel-and-google-sheets-with-lambda/", "published_at": "2022-12-03T07:44:00+00:00" }, { "id": "01a0c517-0dc2-7278-b64f-101f71a1cf25", "title": "A super fast and flexible near-optimal matching method using the quickmatch library in R", "url": "https://dabblingwithdata.amedcalf.com/2022/11/20/a-super-fast-and-flexible-near-optimal-matching-method-using-the-quickmatch-library-in-r/", "published_at": "2022-11-20T17:03:24+00:00" }, { "id": "01a0c517-0dc2-7278-b64f-101f71e6b538", "title": "How to install a CRAN package that has been archived", "url": "https://dabblingwithdata.amedcalf.com/2022/10/20/how-to-install-a-cran-package-that-has-been-archived/", "published_at": "2022-10-20T06:12:00+00:00" }, { "id": "01a0c517-0dc2-7278-b64f-101f7243cfef", "title": "The Follower – an art project highlighting another way your data can be used to surveil you", "url": "https://dabblingwithdata.amedcalf.com/2022/10/16/the-follower-an-art-project-highlighting-another-way-your-data-can-be-used-to-surveil-you/", "published_at": "2022-10-16T16:05:37+00:00" }, { "id": "01a0c517-0dc2-7278-b64f-101f7283bd13", "title": "Should artificial intelligences win art competitions?", "url": "https://dabblingwithdata.amedcalf.com/2022/09/04/should-artificial-intelligences-win-art-competitions/", "published_at": "2022-09-04T12:57:10+00:00" }, { "id": "01a0c517-0dc2-7278-b64f-101f73552766", "title": "Why the majority of England’s Covid deaths are now from vaccinated people despite the fact that the vaccines work well", "url": "https://dabblingwithdata.amedcalf.com/2022/08/07/why-the-majority-of-englands-covid-deaths-are-now-from-vaccinated-people-despite-the-fact-that-the-vaccines-work-well/", "published_at": "2022-08-07T10:45:16+00:00" }, { "id": "01a0c517-0dc2-7278-b64f-101f73843096", "title": "The Great Resignation of British Ministers", "url": "https://dabblingwithdata.amedcalf.com/2022/07/11/the-great-resignation-of-british-ministers/", "published_at": "2022-07-11T12:31:48+00:00" }, { "id": "01a0c517-0dc2-7278-b64f-101f7409a7d9", "title": "Study estimates that the Covid-19 vaccines saved 15 million lives last year", "url": "https://dabblingwithdata.amedcalf.com/2022/06/29/study-estimates-that-the-covid-19-vaccines-saved-15-million-lives-last-year/", "published_at": "2022-06-29T12:22:43+00:00" }, { "id": "01a0c521-d58b-7163-a13a-36d8d96852a5", "title": "Multi-armed bandits, and the Duolingo example", "url": "https://dabblingwithdata.amedcalf.com/2022/06/05/multi-armed-bandits-and-the-duolingo-example/", "published_at": "2022-06-05T12:13:08+00:00" }, { "id": "01a0c521-d58b-7163-a13a-36d8d9e5a205", "title": "The Roe vs Wade leak and data privacy", "url": "https://dabblingwithdata.amedcalf.com/2022/05/15/the-roe-vs-wade-leak-and-data-privacy/", "published_at": "2022-05-15T10:40:50+00:00" }, { "id": "01a0c521-d58b-7163-a13a-36d8da54398c", "title": "Chebyshev’s inequality – a 68-95-99.7 style rule for all distributions", "url": "https://dabblingwithdata.amedcalf.com/2022/03/20/chebyshevs-inequality-a-68-95-99-7-style-rule-for-all-distributions/", "published_at": "2022-03-20T16:43:49+00:00" }, { "id": "01a0c521-d58b-7163-a13a-36d8dad6402e", "title": "Are you (statistically) smarter than a politican?", "url": "https://dabblingwithdata.amedcalf.com/2022/02/13/are-you-statistically-smarter-than-a-politican/", "published_at": "2022-02-13T17:58:54+00:00" }, { "id": "01a0c521-d58b-7163-a13a-36d8db913c36", "title": "How to evaluate the results of an experiment early and often without increasing false positives", "url": "https://dabblingwithdata.amedcalf.com/2022/01/12/how-to-evaluate-the-results-of-an-experiment-early-and-often-without-increasing-false-positives/", "published_at": "2022-01-12T13:20:58+00:00" }, { "id": "01a0c521-d58b-7163-a13a-36d8dc5dc545", "title": "Accessing your Duolingo data for analysis via Python", "url": "https://dabblingwithdata.amedcalf.com/2021/08/15/accessing-your-duolingo-data-for-analysis-via-python/", "published_at": "2021-08-15T14:48:12+00:00" }, { "id": "01a0c521-d58b-7163-a13a-36d8dd49645b", "title": "The effectiveness of the Covid-19 vaccine: 95% or 0.84%?", "url": "https://dabblingwithdata.amedcalf.com/2021/07/16/the-effectiveness-of-the-covid-19-vaccine-95-or-0-84/", "published_at": "2021-07-16T13:05:38+00:00" }, { "id": "01a0c521-d58b-7163-a13a-36d8de203521", "title": "Create rows for missing combinations of data with R", "url": "https://dabblingwithdata.amedcalf.com/2021/06/26/create-rows-for-missing-combinations-of-data-with-r/", "published_at": "2021-06-26T13:13:53+00:00" }, { "id": "01a0c521-d58b-7163-a13a-36d8dee479bd", "title": "A quick way to count the number of null values in each field of a BigQuery table", "url": "https://dabblingwithdata.amedcalf.com/2021/05/17/a-quick-way-to-count-the-number-of-null-values-in-each-field-of-a-bigquery-table/", "published_at": "2021-05-17T08:52:00+00:00" }, { "id": "01a0c521-d58b-7163-a13a-36d8df684c48", "title": "Travelling through time to query a BigQuery database from the past", "url": "https://dabblingwithdata.amedcalf.com/2021/03/28/travelling-through-time-to-query-a-bigquery-database-from-the-past/", "published_at": "2021-03-28T07:46:32+00:00" }, { "id": "01a0c52d-6801-70d2-b62b-13e1bd4d0302", "title": "Create similar test and control groups by randomising participants with blocking in R", "url": "https://dabblingwithdata.amedcalf.com/2021/03/23/create-similar-test-and-control-groups-by-randomising-participants-with-blocking-in-r/", "published_at": "2021-03-23T17:32:00+00:00" }, { "id": "01a0c52d-6801-70d2-b62b-13e1bd85946a", "title": "Covid-19 testing in England’s secondary schools: the story so far", "url": "https://dabblingwithdata.amedcalf.com/2021/03/15/covid-19-testing-in-englands-secondary-schools-the-story-so-far/", "published_at": "2021-03-15T13:19:15+00:00" }, { "id": "01a0c52d-6801-70d2-b62b-13e1be64d488", "title": "Code-efficient alternatives to CASE WHEN statements in SQL", "url": "https://dabblingwithdata.amedcalf.com/2021/02/28/code-efficient-alternatives-to-case-when-statements-in-sql/", "published_at": "2021-02-28T16:01:11+00:00" }, { "id": "01a0c52d-6801-70d2-b62b-13e1bf3eba2d", "title": "Should an AI’s opinion of your personality affect whether you get a job?", "url": "https://dabblingwithdata.amedcalf.com/2021/02/21/should-an-ais-opinion-of-your-personality-affect-whether-you-get-a-job/", "published_at": "2021-02-21T16:19:08+00:00" }, { "id": "01a0c52d-6801-70d2-b62b-13e1bf5b1e1b", "title": "Official UK Covid-19 vaccination progress data", "url": "https://dabblingwithdata.amedcalf.com/2021/02/20/official-uk-covid-19-vaccination-progress-data/", "published_at": "2021-02-20T09:53:00+00:00" }, { "id": "01a0c52d-6801-70d2-b62b-13e1bffbc2c0", "title": "Solving the the case of the 6cm man with assertive programming", "url": "https://dabblingwithdata.amedcalf.com/2021/02/18/solving-the-the-case-of-the-6cm-man-with-assertive-programming/", "published_at": "2021-02-18T14:19:59+00:00" }, { "id": "01a0c52d-6801-70d2-b62b-13e1c0a977a2", "title": "Do Millennials have no friends?", "url": "https://dabblingwithdata.amedcalf.com/2019/08/15/do-millennials-have-no-friends/", "published_at": "2019-08-15T06:50:49+00:00" }, { "id": "01a0c52d-6801-70d2-b62b-13e1c13c0974", "title": "How to be happy: the data driven answer (part 1)", "url": "https://dabblingwithdata.amedcalf.com/2019/03/12/how-to-be-happy-the-data-driven-answer-part-1/", "published_at": "2019-03-12T12:44:56+00:00" }, { "id": "01a0c52d-6801-70d2-b62b-13e1c1f0d0a1", "title": "Using R to run many hypothesis tests (or other functions) on subsets of your data in one go", "url": "https://dabblingwithdata.amedcalf.com/2019/02/05/using-r-to-run-many-hypothesis-tests-or-other-functions-on-subsets-of-your-data-in-one-go/", "published_at": "2019-02-05T09:37:05+00:00" }, { "id": "01a0c52d-6801-70d2-b62b-13e1c2b77aa2", "title": "Extracting the date and time a UUID was created with Bigquery SQL (with a brief foray into the history of the Gregorian calendar)", "url": "https://dabblingwithdata.amedcalf.com/2018/10/13/extracting-the-date-and-time-a-uuid-was-created-with-bigquery-sql-with-a-brief-foray-into-the-history-of-the-gregorian-calendar/", "published_at": "2018-10-13T10:40:34+00:00" }, { "id": "01a0c538-0bd0-711d-b2d6-8f51693029a7", "title": "Average age at menarche by country", "url": "https://dabblingwithdata.amedcalf.com/2018/09/14/average-age-at-menarche-by-country/", "published_at": "2018-09-14T08:14:29+00:00" }, { "id": "01a0c538-0bd0-711d-b2d6-8f516992db6c", "title": "Analysing your 23andme genetic data in R part 2: exploring the traits associated with your genome", "url": "https://dabblingwithdata.amedcalf.com/2018/09/07/analysing-your-23andme-genetic-data-in-r-part-2-exploring-the-traits-associated-with-your-genome/", "published_at": "2018-09-07T08:15:06+00:00" }, { "id": "01a0c538-0bd0-711d-b2d6-8f5169e3befd", "title": "Analysing your 23andme genetic data in R part 1: importing your genome into R", "url": "https://dabblingwithdata.amedcalf.com/2018/07/16/analysing-your-23andme-genetic-data-in-r-part-1-importing-your-genome-into-r/", "published_at": "2018-07-16T07:50:57+00:00" }, { "id": "01a0c538-0bd0-711d-b2d6-8f516ac33bc8", "title": "R packages for summarising data – part 2", "url": "https://dabblingwithdata.amedcalf.com/2018/02/26/r-packages-for-summarising-data-part-2/", "published_at": "2018-02-26T08:45:42+00:00" }, { "id": "01a0c538-0bd0-711d-b2d6-8f516ac90054", "title": "Books I read in 2017", "url": "https://dabblingwithdata.amedcalf.com/2018/01/09/books-i-read-in-2017/", "published_at": "2018-01-09T12:16:53+00:00" }, { "id": "01a0c538-0bd0-711d-b2d6-8f516b4e4e87", "title": "My favourite R package for: summarising data", "url": "https://dabblingwithdata.amedcalf.com/2018/01/02/my-favourite-r-package-for-summarising-data/", "published_at": "2018-01-02T08:49:22+00:00" }, { "id": "01a0c538-0bd0-711d-b2d6-8f516b7f956d", "title": "My favourite R package for: frequency tables", "url": "https://dabblingwithdata.amedcalf.com/2017/12/20/my-favourite-r-package-for-frequency-tables/", "published_at": "2017-12-20T11:03:12+00:00" }, { "id": "01a0c538-0bd0-711d-b2d6-8f516bdcc761", "title": "My favourite R package for: correlation", "url": "https://dabblingwithdata.amedcalf.com/2017/09/11/my-favourite-r-package-for-correlation/", "published_at": "2017-09-11T07:44:30+00:00" }, { "id": "01a0c538-0bd0-711d-b2d6-8f516c7fcf2c", "title": "Transactions by active subscribers formulae in Tableau", "url": "https://dabblingwithdata.amedcalf.com/2017/09/07/transactions-by-active-subscribers-formulae-in-tableau/", "published_at": "2017-09-07T17:39:25+00:00" }, { "id": "01a0c538-0bd0-711d-b2d6-8f516cb24331", "title": "The Datasaurus: a monstrous Anscombe for the 21st century", "url": "https://dabblingwithdata.amedcalf.com/2017/05/03/the-datasaurus-a-monstrous-anscombe-for-the-21st-century/", "published_at": "2017-05-03T08:22:17+00:00" }, { "id": "01a0c541-9b0d-7104-a3cc-ce56b1fac2ac", "title": "data.world: the place to go for your open data needs?", "url": "https://dabblingwithdata.amedcalf.com/2017/03/11/data-world-the-place-to-go-for-your-open-data-needs/", "published_at": "2017-03-11T15:30:26+00:00" }, { "id": "01a0c541-9b0d-7104-a3cc-ce56b2aed09b", "title": "Lessons from what happened before Snow’s famous cholera map changed the world", "url": "https://dabblingwithdata.amedcalf.com/2017/03/06/8-lessons-from-what-happened-before-snows-famous-cholera-map-changed-the-world/", "published_at": "2017-03-06T08:47:05+00:00" }, { "id": "01a0c541-9b0d-7104-a3cc-ce56b32303df", "title": "Books I read in 2016", "url": "https://dabblingwithdata.amedcalf.com/2017/02/11/books-i-read-in-2016/", "published_at": "2017-02-11T10:51:48+00:00" }, { "id": "01a0c541-9b0d-7104-a3cc-ce56b3978b05", "title": "5 Power BI features that might make Tableau users a little jealous", "url": "https://dabblingwithdata.amedcalf.com/2017/01/27/5-power-bi-features-that-might-make-tableau-users-a-little-jealous/", "published_at": "2017-01-27T09:10:46+00:00" }, { "id": "01a0c541-9b0d-7104-a3cc-ce56b4260bbf", "title": "Retrieving Adobe SiteCatalyst data with R", "url": "https://dabblingwithdata.amedcalf.com/2017/01/05/retrieving-adobe-sitecatalyst-data-with-r/", "published_at": "2017-01-05T17:47:23+00:00" }, { "id": "01a0c541-9b0d-7104-a3cc-ce56b4c23f63", "title": "Actually you can use variables, CTEs and other fancy SQL with Tableau after all", "url": "https://dabblingwithdata.amedcalf.com/2016/12/10/actually-you-can-use-variables-ctes-and-other-fancy-sql-with-tableau-after-all/", "published_at": "2016-12-10T11:24:42+00:00" }, { "id": "01a0c541-9b0d-7104-a3cc-ce56b4ec089a", "title": "Future features coming to Tableau 10.2 and beyond – that they didn’t blog about", "url": "https://dabblingwithdata.amedcalf.com/2016/11/22/future-features-coming-to-tableau-10-2-and-beyond-that-they-didnt-blog-about/", "published_at": "2016-11-22T08:51:12+00:00" }, { "id": "01a0c541-9b0d-7104-a3cc-ce56b59a5fef", "title": "What people claim to believe: Hillary Clinton edition", "url": "https://dabblingwithdata.amedcalf.com/2016/11/03/what-people-claim-to-believe-hillary-clinton-edition/", "published_at": "2016-11-03T18:55:49+00:00" }, { "id": "01a0c541-9b0d-7104-a3cc-ce56b60bac0f", "title": "Do good and bad viz choices exist?", "url": "https://dabblingwithdata.amedcalf.com/2016/10/20/do-good-and-bad-viz-choices-exist/", "published_at": "2016-10-20T23:02:41+00:00" }, { "id": "01a0c541-9b0d-7104-a3cc-ce56b66db7b2", "title": "Remember the exciting new features Tableau demoed at #data15 – have we got them yet?", "url": "https://dabblingwithdata.amedcalf.com/2016/10/18/remember-the-exciting-new-features-tableau-demoed-at-data15-have-we-got-them-yet/", "published_at": "2016-10-18T16:50:44+00:00" }, { "id": "01a0c54a-8035-7203-b614-0a99366197e7", "title": "Clustering categorical data with R", "url": "https://dabblingwithdata.amedcalf.com/2016/10/10/clustering-categorical-data-with-r/", "published_at": "2016-10-10T16:44:16+00:00" }, { "id": "01a0c54a-8036-7392-88b3-da8999f78fc8", "title": "Workaround for the Tableau “custom SQL” restriction on SQL Server variables", "url": "https://dabblingwithdata.amedcalf.com/2016/09/16/workaround-for-the-tableau-custom-sql-restriction-on-sql-server-variables/", "published_at": "2016-09-16T11:56:14+00:00" }, { "id": "01a0c54a-8036-7392-88b3-da899a5e5f44", "title": "Free up-to-date UK postcode latitude longitude data", "url": "https://dabblingwithdata.amedcalf.com/2016/09/14/free-up-to-date-uk-postcode-latitude-longitude-data/", "published_at": "2016-09-14T16:40:14+00:00" }, { "id": "01a0c54a-8036-7392-88b3-da899b2a58de", "title": "A few notes on Tableau 10’s cross-database join feature", "url": "https://dabblingwithdata.amedcalf.com/2016/09/05/a-few-notes-on-tableau-10s-cross-database-join-feature/", "published_at": "2016-09-05T17:10:05+00:00" }, { "id": "01a0c54a-8036-7392-88b3-da899bb3e8d2", "title": "Help decide who self-driving cars should kill", "url": "https://dabblingwithdata.amedcalf.com/2016/09/02/help-decide-who-self-driving-cars-should-kill/", "published_at": "2016-09-02T17:49:46+00:00" }, { "id": "01a0c54a-8036-7392-88b3-da899c6352bd", "title": "Creating my first Tableau web data connector : part 3", "url": "https://dabblingwithdata.amedcalf.com/2016/08/06/creating-my-first-tableau-web-data-connector-part-3/", "published_at": "2016-08-06T15:30:01+00:00" }, { "id": "01a0c54a-8036-7392-88b3-da899d02fa1a", "title": "Creating my first Tableau web data connector – part 2", "url": "https://dabblingwithdata.amedcalf.com/2016/08/03/creating-my-first-tableau-web-data-connector-part-2/", "published_at": "2016-08-03T17:08:48+00:00" }, { "id": "01a0c54a-8036-7392-88b3-da899d6fea34", "title": "The Tableau #MakeoverMonday doesn’t need to be complicated", "url": "https://dabblingwithdata.amedcalf.com/2016/08/02/the-tableau-makeovermonday-doesnt-need-to-be-complicated/", "published_at": "2016-08-02T17:38:00+00:00" }, { "id": "01a0c54a-8036-7392-88b3-da899e1daf00", "title": "Creating my first Tableau web data connector – the highs and the lows: part 1", "url": "https://dabblingwithdata.amedcalf.com/2016/07/29/creating-my-first-tableau-web-data-connector-the-highs-and-the-lows-part-1/", "published_at": "2016-07-29T07:18:20+00:00" }, { "id": "01a0c54a-8036-7392-88b3-da899e793262", "title": "#VisualizeNoMalaria: Let’s all help build an anti-Malaria dataset", "url": "https://dabblingwithdata.amedcalf.com/2016/07/27/visualizenomalaria-lets-all-help-build-an-anti-malaria-dataset/", "published_at": "2016-07-27T07:28:43+00:00" }, { "id": "01a0c552-d15f-702f-b1f4-468aa4ecd629", "title": "Journey complete: a BoardGameGeek collection Tableau web data connector", "url": "https://dabblingwithdata.amedcalf.com/2016/07/15/journey-complete-a-boardgamegeek-collection-tableau-web-data-connector/", "published_at": "2016-07-15T17:34:04+00:00" }, { "id": "01a0c552-d15f-702f-b1f4-468aa50b91ad", "title": "Is the EU referendum actually a great conspiracy?", "url": "https://dabblingwithdata.amedcalf.com/2016/06/23/is-the-eu-referendum-actually-a-great-conspiracy/", "published_at": "2016-06-23T08:16:16+00:00" }, { "id": "01a0c552-d15f-702f-b1f4-468aa5e2c561", "title": "Brexit: Which newspapers support Leave and which Remain?", "url": "https://dabblingwithdata.amedcalf.com/2016/06/21/brexit-which-newspapers-support-leave-and-which-remain/", "published_at": "2016-06-21T17:15:06+00:00" }, { "id": "01a0c552-d15f-702f-b1f4-468aa5e5e453", "title": "The EU referendum: do voters understand what they’re voting on?", "url": "https://dabblingwithdata.amedcalf.com/2016/06/18/the-eu-referendum-do-voters-understand-what-theyre-voting-on/", "published_at": "2016-06-18T10:26:54+00:00" }, { "id": "01a0c552-d15f-702f-b1f4-468aa60fe037", "title": "Future features coming to Alteryx 10.6 and beyond", "url": "https://dabblingwithdata.amedcalf.com/2016/06/14/future-features-coming-to-alteryx-10-6-and-beyond/", "published_at": "2016-06-14T17:53:02+00:00" }, { "id": "01a0c552-d15f-702f-b1f4-468aa6f56a4c", "title": "The EU referendum: voting intention vs voting turnout", "url": "https://dabblingwithdata.amedcalf.com/2016/05/25/the-eu-referendum-voting-intention-vs-voting-turnout/", "published_at": "2016-05-25T17:39:48+00:00" }, { "id": "01a0c552-d15f-702f-b1f4-468aa7018231", "title": "Accessing Adobe Analytics data with Alteryx", "url": "https://dabblingwithdata.amedcalf.com/2016/05/07/accessing-adobe-analytics-data-with-alteryx/", "published_at": "2016-05-07T10:04:21+00:00" }, { "id": "01a0c552-d15f-702f-b1f4-468aa72815d1", "title": "Free interactive data and analysis tools from Public Health England", "url": "https://dabblingwithdata.amedcalf.com/2016/04/20/free-interactive-data-and-analysis-tools-from-public-health-england/", "published_at": "2016-04-20T11:50:59+00:00" }, { "id": "01a0c552-d15f-702f-b1f4-468aa72f2c5f", "title": "Unsafe abortions: visualising the “preventable pandemic”", "url": "https://dabblingwithdata.amedcalf.com/2016/04/19/unsafe-abortions-visualising-the-preventable-pandemic/", "published_at": "2016-04-19T17:11:40+00:00" }, { "id": "01a0c552-d15f-702f-b1f4-468aa743e8d9", "title": "Showing continents on a Tableau map", "url": "https://dabblingwithdata.amedcalf.com/2016/04/13/showing-continents-on-a-tableau-map/", "published_at": "2016-04-13T17:07:45+00:00" }, { "id": "01a0c55b-354e-70de-b943-15fd57481944", "title": "An AI beat the human world Go champion – is the end of the world nigh?", "url": "https://dabblingwithdata.amedcalf.com/2016/03/29/an-ai-beat-the-human-world-go-champion-is-the-end-of-the-world-nigh/", "published_at": "2016-03-29T11:05:21+00:00" }, { "id": "01a0c55b-354e-70de-b943-15fd58247265", "title": "Tableau dashboards quick tip #2: how do I know what size my dashboard should be to fit in a story?", "url": "https://dabblingwithdata.amedcalf.com/2016/03/23/tableau-dashboards-quick-tip-2-how-do-i-know-what-size-my-dashboard-should-be-to-fit-in-a-story/", "published_at": "2016-03-23T08:44:36+00:00" }, { "id": "01a0c55b-354e-70de-b943-15fd58a19b08", "title": "Tableau dashboards quick tip #1: why is my embedded web page blank when published?", "url": "https://dabblingwithdata.amedcalf.com/2016/03/23/tableau-dashboards-quick-tip-1-why-is-my-embedded-web-page-blank-when-published/", "published_at": "2016-03-23T08:28:30+00:00" }, { "id": "01a0c55b-354e-70de-b943-15fd590a2234", "title": "The 2016 UK Budget – what does the data say?", "url": "https://dabblingwithdata.amedcalf.com/2016/03/19/the-2016-uk-budget-what-does-the-data-say/", "published_at": "2016-03-19T10:03:00+00:00" }, { "id": "01a0c55b-354e-70de-b943-15fd59539c71", "title": "Using a Tableau Web Data Connector to access my Moves app location data", "url": "https://dabblingwithdata.amedcalf.com/2016/03/14/using-a-tableau-web-data-connector-to-access-my-moves-app-location-data/", "published_at": "2016-03-14T18:34:54+00:00" }, { "id": "01a0c55b-354e-70de-b943-15fd5a51efb3", "title": "Simpson’s paradox and the importance of segmentation", "url": "https://dabblingwithdata.amedcalf.com/2016/03/10/simpsons-paradox-and-the-importance-of-segmentation/", "published_at": "2016-03-10T07:18:10+00:00" }, { "id": "01a0c55b-354e-70de-b943-15fd5af7ed75", "title": "Stress, depression and anxiety in the workplace – what does the data show?", "url": "https://dabblingwithdata.amedcalf.com/2016/03/06/stress-depression-and-anxiety-in-the-workplace-what-does-the-data-show/", "published_at": "2016-03-06T12:05:00+00:00" }, { "id": "01a0c55b-354e-70de-b943-15fd5b79ce13", "title": "New website launch from the Office of National Statistics", "url": "https://dabblingwithdata.amedcalf.com/2016/02/26/new-website-launch-from-the-office-of-national-statistics/", "published_at": "2016-02-26T12:40:40+00:00" }, { "id": "01a0c55b-354e-70de-b943-15fd5c4ea9e3", "title": "Kaggle now offers free public dataset and script combos", "url": "https://dabblingwithdata.amedcalf.com/2016/02/18/kaggle-now-offers-free-public-dataset-and-script-combos/", "published_at": "2016-02-18T08:50:00+00:00" }, { "id": "01a0c55b-354e-70de-b943-15fd5cf4fa13", "title": "You made a chart. So what?", "url": "https://dabblingwithdata.amedcalf.com/2016/02/17/you-made-a-chart-so-what/", "published_at": "2016-02-17T17:46:16+00:00" } ] posts Claim your blog
Back to dabblingwithdata.amedcalf.com
Blog · corpus.blog/blogs/dabblingwithdata.amedcalf.com/posts

dabblingwithdata.amedcalf.com

dabblingwithdata.amedcalf.com

2026

Version control your data, not just your code, with the pins library for R and Pythonoriginal ↗
18 Jan 2026

2025

Are vast numbers of Britons really exiting the workforce due to long term sickness?original ↗
30 May 2025
You can finally can turn off Microsoft Excel’s incessant desire to mess up your data by auto-converting it to an inappropriate typeoriginal ↗
9 Feb 2025

2024

Most Britons favour legalising assisted dying, irrespective of political affiliationoriginal ↗
29 Nov 2024
Aggregating and analysing location data using H3 in Snowflake or Roriginal ↗
3 Nov 2024
Creating a granular “votes cast” dataset for the last century’s worth of UK General Electionsoriginal ↗
6 Oct 2024
How to get a Wikipedia (or other HTML) table into R as a dataframeoriginal ↗
16 Aug 2024
Today’s young Britons really seem to dislike the Conservative partyoriginal ↗
26 Jun 2024
Situations when multicollinearity in regression model variables isn’t importantoriginal ↗
2 May 2024
The great SQL leading vs trailing commas debateoriginal ↗
28 Apr 2024
The Data Is Plural newsletter provides a mass of free and fascinating dataoriginal ↗
20 Apr 2024
Notes on the book “Becoming a Data Head”original ↗
4 Apr 2024
Using ChatGPT’s Data Analysis bot to analyse your dataoriginal ↗
18 Feb 2024
The ongoing battle between human creators and AI trainersoriginal ↗
9 Jan 2024

2023

Does protesting work?original ↗
13 Dec 2023
The differences between what Twitter users say they do and what they actually dooriginal ↗
15 Sept 2023
Is British gas and oil really 4x as good for the environment as imported fuel?original ↗
10 Aug 2023
Writing conditional filter statements in dplyroriginal ↗
30 Jul 2023
The risks of using generative AI when writing codeoriginal ↗
18 Jul 2023
Are AIs developing unpredictable new abilities, or are we just measuring them badly?original ↗
29 May 2023
Tips and tricks for knitting R Markdownoriginal ↗
10 Apr 2023
Most rainforest carbon offsets may not actually offset any carbonoriginal ↗
23 Jan 2023

2022

Easily write your own custom functions in Excel and Google Sheets with LAMBDAoriginal ↗
3 Dec 2022
A super fast and flexible near-optimal matching method using the quickmatch library in Roriginal ↗
20 Nov 2022
How to install a CRAN package that has been archivedoriginal ↗
20 Oct 2022
The Follower – an art project highlighting another way your data can be used to surveil youoriginal ↗
16 Oct 2022
Should artificial intelligences win art competitions?original ↗
4 Sept 2022
Why the majority of England’s Covid deaths are now from vaccinated people despite the fact that the vaccines work welloriginal ↗
7 Aug 2022
The Great Resignation of British Ministersoriginal ↗
11 Jul 2022
Study estimates that the Covid-19 vaccines saved 15 million lives last yearoriginal ↗
29 Jun 2022
Multi-armed bandits, and the Duolingo exampleoriginal ↗
5 Jun 2022
The Roe vs Wade leak and data privacyoriginal ↗
15 May 2022
Chebyshev’s inequality – a 68-95-99.7 style rule for all distributionsoriginal ↗
20 Mar 2022
Are you (statistically) smarter than a politican?original ↗
13 Feb 2022
How to evaluate the results of an experiment early and often without increasing false positivesoriginal ↗
12 Jan 2022

2021

Accessing your Duolingo data for analysis via Pythonoriginal ↗
15 Aug 2021
The effectiveness of the Covid-19 vaccine: 95% or 0.84%?original ↗
16 Jul 2021
Create rows for missing combinations of data with Roriginal ↗
26 Jun 2021
A quick way to count the number of null values in each field of a BigQuery tableoriginal ↗
17 May 2021
Travelling through time to query a BigQuery database from the pastoriginal ↗
28 Mar 2021
Create similar test and control groups by randomising participants with blocking in Roriginal ↗
23 Mar 2021
Covid-19 testing in England’s secondary schools: the story so faroriginal ↗
15 Mar 2021
Code-efficient alternatives to CASE WHEN statements in SQLoriginal ↗
28 Feb 2021
Should an AI’s opinion of your personality affect whether you get a job?original ↗
21 Feb 2021
Official UK Covid-19 vaccination progress dataoriginal ↗
20 Feb 2021
Solving the the case of the 6cm man with assertive programmingoriginal ↗
18 Feb 2021

2019

Do Millennials have no friends?original ↗
15 Aug 2019
How to be happy: the data driven answer (part 1)original ↗
12 Mar 2019
Using R to run many hypothesis tests (or other functions) on subsets of your data in one gooriginal ↗
5 Feb 2019

2018

Extracting the date and time a UUID was created with Bigquery SQL (with a brief foray into the history of the Gregorian calendar)original ↗
13 Oct 2018
Average age at menarche by countryoriginal ↗
14 Sept 2018
Analysing your 23andme genetic data in R part 2: exploring the traits associated with your genomeoriginal ↗
7 Sept 2018
Analysing your 23andme genetic data in R part 1: importing your genome into Roriginal ↗
16 Jul 2018
R packages for summarising data – part 2original ↗
26 Feb 2018
Books I read in 2017original ↗
9 Jan 2018
My favourite R package for: summarising dataoriginal ↗
2 Jan 2018

2017

My favourite R package for: frequency tablesoriginal ↗
20 Dec 2017
My favourite R package for: correlationoriginal ↗
11 Sept 2017
Transactions by active subscribers formulae in Tableauoriginal ↗
7 Sept 2017
The Datasaurus: a monstrous Anscombe for the 21st centuryoriginal ↗
3 May 2017
data.world: the place to go for your open data needs?original ↗
11 Mar 2017
Lessons from what happened before Snow’s famous cholera map changed the worldoriginal ↗
6 Mar 2017
Books I read in 2016original ↗
11 Feb 2017
5 Power BI features that might make Tableau users a little jealousoriginal ↗
27 Jan 2017
Retrieving Adobe SiteCatalyst data with Roriginal ↗
5 Jan 2017

2016

Actually you can use variables, CTEs and other fancy SQL with Tableau after alloriginal ↗
10 Dec 2016
Future features coming to Tableau 10.2 and beyond – that they didn’t blog aboutoriginal ↗
22 Nov 2016
What people claim to believe: Hillary Clinton editionoriginal ↗
3 Nov 2016
Do good and bad viz choices exist?original ↗
20 Oct 2016
Remember the exciting new features Tableau demoed at #data15 – have we got them yet?original ↗
18 Oct 2016
Clustering categorical data with Roriginal ↗
10 Oct 2016
Workaround for the Tableau “custom SQL” restriction on SQL Server variablesoriginal ↗
16 Sept 2016
Free up-to-date UK postcode latitude longitude dataoriginal ↗
14 Sept 2016
A few notes on Tableau 10’s cross-database join featureoriginal ↗
5 Sept 2016
Help decide who self-driving cars should killoriginal ↗
2 Sept 2016
Creating my first Tableau web data connector : part 3original ↗
6 Aug 2016
Creating my first Tableau web data connector – part 2original ↗
3 Aug 2016
The Tableau #MakeoverMonday doesn’t need to be complicatedoriginal ↗
2 Aug 2016
Creating my first Tableau web data connector – the highs and the lows: part 1original ↗
29 Jul 2016
#VisualizeNoMalaria: Let’s all help build an anti-Malaria datasetoriginal ↗
27 Jul 2016
Journey complete: a BoardGameGeek collection Tableau web data connectororiginal ↗
15 Jul 2016
Is the EU referendum actually a great conspiracy?original ↗
23 Jun 2016
Brexit: Which newspapers support Leave and which Remain?original ↗
21 Jun 2016
The EU referendum: do voters understand what they’re voting on?original ↗
18 Jun 2016
Future features coming to Alteryx 10.6 and beyondoriginal ↗
14 Jun 2016
The EU referendum: voting intention vs voting turnoutoriginal ↗
25 May 2016
Accessing Adobe Analytics data with Alteryxoriginal ↗
7 May 2016
Free interactive data and analysis tools from Public Health Englandoriginal ↗
20 Apr 2016
Unsafe abortions: visualising the “preventable pandemic”original ↗
19 Apr 2016
Showing continents on a Tableau maporiginal ↗
13 Apr 2016
An AI beat the human world Go champion – is the end of the world nigh?original ↗
29 Mar 2016
Tableau dashboards quick tip #2: how do I know what size my dashboard should be to fit in a story?original ↗
23 Mar 2016
Tableau dashboards quick tip #1: why is my embedded web page blank when published?original ↗
23 Mar 2016
The 2016 UK Budget – what does the data say?original ↗
19 Mar 2016
Using a Tableau Web Data Connector to access my Moves app location dataoriginal ↗
14 Mar 2016
Simpson’s paradox and the importance of segmentationoriginal ↗
10 Mar 2016
Stress, depression and anxiety in the workplace – what does the data show?original ↗
6 Mar 2016
New website launch from the Office of National Statisticsoriginal ↗
26 Feb 2016
Kaggle now offers free public dataset and script combosoriginal ↗
18 Feb 2016
You made a chart. So what?original ↗
17 Feb 2016
Next