Tidy Spreadsheet screencast: Unpivoting UK agriculture stats with R
HTML-код
- Опубликовано: 21 авг 2024
- 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...
Amazing work. I would love to test this out. over the years I recall spending hours in Excel cleaning such structures
I can't thank you enough! Absolutely amazing.
This is awesome. So many times I have to deal with those merge cells from excel.
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).
Thank a lot, was looking for this
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.
why double NN ?
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
@@DuncanGarmonsway thank you! By the way - the approach is awesome) messy spreadsheets are such a pain