Tidy Spreadsheet screencast: Unpivoting UK agriculture stats with R

I tidy a dataset of UK agriculture statistics using R to demonstrate tidyxl::xlsx_cells() tidyxl::xlsx_formats() and unpivotr::behead() on a complex pivot table.
The data comes from the UK Department for Environment, Food & Rural Affairs via data.gov.uk, using the breakdown by local authority www.gov.uk/gov...
Read Spreadsheet Munging Strategies for more tips and case studies nacnudus.githu...

[@ahmed007Jaber]

Amazing work. I would love to test this out. over the years I recall spending hours in Excel cleaning such structures

[@santia6756]

I can't thank you enough! Absolutely amazing.

[@rexevan6714]

This is awesome. So many times I have to deal with those merge cells from excel.

[@JOHNSMITH-ve3rq]

sweet vim/R setup dude. Make another video just showing how you got that rolling and why it's better than the IDE! (I just assume it must be).

[@akepilinggiehili5320]

Thank a lot, was looking for this

[@asen7790]

Sir please make a tutorial video on how to analyse factorial RBD agricultural data from the beginning i.e from importing data to anova, graphs, comparison and extraction.

[@maksim0933]

why double NN ?

[@DuncanGarmonsway]

NNW (north northwest) is different from WNW (west northwest). One means to seek the header cell "upwards, and a bit to the left", whereas the other means, "to the left, then up a bit". But it was a poor design that fooled a lot of people, so has been superseded by "up-left", "left-up", etc. See Michael Mahoney's screencast for a demonstration. ruclips.net/video/qUgVhpg-lP4/видео.html

[@maksim0933]

@@DuncanGarmonsway thank you! By the way - the approach is awesome) messy spreadsheets are such a pain