![Duncan Garmonsway](/img/default-banner.jpg)
- Видео 5
- Просмотров 10 767
Duncan Garmonsway
Добавлен 20 ноя 2006
Robert Benchley speech from The Sky's The Limit (1943)
Robert Benchley's hilarious business statistics speech from the 1943 film The Sky's The Limit, starring Fred Astaire and Joan Leslie.
Просмотров: 5 960
Видео
Tidy Tuesday Screencast: Tidying US PhD data with R
Просмотров 8645 лет назад
This is a participation in the #tidytuesday project: github.com/rfordatascience/tidytuesday The data comes from National Center for Science and Engineering Statistics ncses.nsf.gov/pubs/nsf19301/ via the Tidy Tuesday project github.com/rfordatascience/tidytuesday/tree/master/data/2019/2019-02-19
Tidy Spreadsheet screencast: Unpivoting UK agriculture stats with R
Просмотров 2,4 тыс.5 лет назад
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/government/statistical-data-sets/structure-of-the-agricultural-industry-in-england-and-the-u...
Tidy Tuesday Screencast: tidying invasive species data with R and Python
Просмотров 7795 лет назад
I tidy a dataset of invasive species using R and Python to demonstrate readr::read_file(), regex, tabulizer (R interface to tabula) and Python's pdfplumber. This is a participation in the #tidytuesday project: github.com/rfordatascience/tidytuesday The data comes from GRIIS www.griis.org/ via Paini et al, 2016 www.pnas.org/content/113/27/7575/tab-figures-data
Tidy Tuesday Screencast: tidying US honey production statistics with R
Просмотров 7845 лет назад
I tidy a dataset of US honey production statistics using R to demonstrate readr::melt_csv() and unpivotr::behead(), which are overkill for this data. This is a participation in the #tidytuesday project: github.com/rfordatascience/tidytuesday The data comes from the United States Department of Agriculture usda.mannlib.cornell.edu/MannUsda/viewDocumentInfo.do?documentID=1520 via www.kaggle.com/je...
As good as his movie scenes are, his writing is so much better. Just broke out my old "Benchley Roundup" and it holds up.
Omg! I just saw this in the movie, “The sky’s the limit” with Fred Astaire and Joan Leslie. And it reminded me of Don Knott’s Bravery speech. I laughed out loud! Both are Scrambled, disorganized, and immensely hilarious! Thanks for putting it up.
Amazing work. I would love to test this out. over the years I recall spending hours in Excel cleaning such structures
Thank you for this Duncan. This is amazing you gave me some insights on how to handle such things. I particularly like the read_file() function to parse a whole csv into a vector to wrangle I hope to see more of this amazing work. I really enjoy your chanel for unconventional messy excel files
Absolutely love this work Duncan. I haven't had to work with something similar in the wild but see the potential. good tips and tricks that would come in handy in different scenarios. I hope you do more of such content
Something very adorable about Benchley. And endearing and funny as all get out. Dorothy Parker's buddy.
Always enjoyed Robert Benchley's character in these old movies. Even have a few of his books and are all good reads. The old guy he was introducing was the one who used to play Mr. Honeywell on " My little Margie" with Charles Farrell and Gale Storm.
Clarence Kolb is the old gents name. Vrery funny character actor in lots of films.
Robert Benchley was a gem of a writer performer whose comedy influenced the British comedian, Ronnie Barker.
The American comedian Bob Newhart acknowledged that he was also heavily influenced by Robert Benchley!
I adore Robert Benchley
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).
His brilliance on FULL display! This must have been a standalone piece he wrote himself.
Genius
I can't thank you enough! Absolutely amazing.
Lies, damned lies, and statistics. Even worse if you don't know what years the stats are for. That's jokes, er stats, per capita mind you. Percentage-wise. Just remember, we're all here now.
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
Thank a lot, was looking for this
Statistical analysis still hasnt moved on much since then
Yeah, I've seen Powerpoint presentations that went a lot like this...
keep making more videos
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.
Love these, please keep making them! (when you have the time :) )
After using this method, I am struggling to plot with geom_line. after 23:13, I used spread on metric and value, and tried several times. Despite using [ group = field2 ], a single line tries to connect all the observations. any tips? Thx!
Hi, try dplyr::filter(is.na(field3)) before plotting. For example: spread(metric, value) %>% dplyr::filter(is.na(field3)) %>% ggplot(aes(year, Number, group = field2)) + geom_line()
@@DuncanGarmonsway It worked but I still do not get it. Thank you so much. Looking forward to your next screen cast
As I said it worked for this table, but when I tried another table [sed17-sr-tab015] I get stuck with the same issue
@@oumardiallo7292 you need to filter out the rows that have values in field3, field4 and field5. Then you will be left with exactly one row for each value of field2.
Thank you so much for this 🤗. Recently I also happened to be working with similar data structure.
Very helpful. Thank you for your effort.
This is awesome. So many times I have to deal with those merge cells from excel.
Hey hey, have you ever thought of doing a video outlining some common regex techniques/concepts? Or what other video on this would you recommend? Cheers
Here's a good R-specific introductory blog post medium.com/@kierisi/r4ds-week-7-star-wars-and-string-manipulation-9ab77ebe8a66 and it references Jenny Bryan's excellent STAT545 course notes stat545.com/block022_regular-expression.html. I'm not really a regex specialist so I'll leave it to the experts!
Great video. Would be vastly improved with higher contrast or larger font so that we could read your regex etc. In any case learned a lot about tidying data in R. Thank you.
Thanks, sorry it was hard to see. Would one of the Lucius themes be better? github.com/jonathanfilip/vim-lucius/blob/master/README.md