- Видео 18
- Просмотров 21 648
Datacasts
Добавлен 6 ноя 2020
How this dashboard landed me a job as a data analyst
In this video, I share how I landed a data analyst job without prior experience using Power BI, by focusing on storytelling and impactful data visualisation. Discover how a personal data project on gender representation in History Today magazine helped me captivate the interview panel and secure the role.
🔗 LINKS:
🧙 Discover your data profile: quiz.tryinteract.com/#/664a5f11fe86740015036871
📊 The dashboard on Tableau Public: public.tableau.com/app/profile/lee.durbin/viz/History_Today/HisStoryTodayHerStoryTomorrow
✍🏻 My blogpost about the process: leedurbin.co.nz/his-story-today-her-story-tomorrow/
🎭 Archived Storify about the Twitter drama: web.archive.org/web/20171231161500/storify.com/lddurb...
🔗 LINKS:
🧙 Discover your data profile: quiz.tryinteract.com/#/664a5f11fe86740015036871
📊 The dashboard on Tableau Public: public.tableau.com/app/profile/lee.durbin/viz/History_Today/HisStoryTodayHerStoryTomorrow
✍🏻 My blogpost about the process: leedurbin.co.nz/his-story-today-her-story-tomorrow/
🎭 Archived Storify about the Twitter drama: web.archive.org/web/20171231161500/storify.com/lddurb...
Просмотров: 158
Видео
Three lessons World of Warcraft taught me about leadership
Просмотров 212 месяца назад
Learn how leading a guild in World of Warcraft transformed my leadership skills, from clear communication to strategic recruitment and balancing priorities. Watch now to see how gaming can teach real-world management and take my fun data-based fantasy role quiz! 🔗 LINKS: 🧙 Discover your data profile: quiz.tryinteract.com/#/664a5f11fe86740015036871 🍿 WATCH NEXT: • How to get hired as a data anal...
How to get hired as a data analyst in 2024
Просмотров 6633 месяца назад
Hiring managers are looking for more than your ability to churn out SQL queries. In this video I'll share 3 tips based on my experience of being on both sides of the interview process. 🔗 LINKS: 🧙 Discover your data profile: quiz.tryinteract.com/#/664a5f11fe86740015036871 📬 Sign up for my newsletter for more insights and tips: lee-durbin.ck.page/subscribe-general Storytelling With You: www.stor...
5 Tips For Building Your First R Package
Просмотров 963 месяца назад
Are you ready to build your first R package? Before you get started, here are 5 things you need to know that will make the process a lot easier. Stay tuned to the end for the lowdown on a package I built for package builders like you! 🔗 LINKS: 📬 Sign up for my newsletter for more insights and tips: lee-durbin.ck.page/subscribe-general 📦 {packagepal}: github.com/lddurbin/packagepal 🛠️ XCode: dev...
3 ways to start using R
Просмотров 633 месяца назад
Before you even write a line of R code, how do you even get started? Do you install something? Does it work on all operating systems? In this video I'm going to cover what you need to know to get up and running: an easy way, an easier way, and the easiest way. 🔗 LINKS: 📬 Sign up for my newsletter for more insights and tips: lee-durbin.ck.page/subscribe-general 💻 Download R: cloud.r-project.org/...
Convert iPhone Photos to PNG in 12 Lines of R Code!
Просмотров 483 месяца назад
In this video, I guide you through a simple yet powerful R script to convert your .HEIC files into PNG or JPG formats. Whether you're a photographer looking to streamline your workflow or someone who simply needs to make their images more accessible, this tutorial is tailored for you. We'll cover each step, ensuring you can follow along, regardless of your coding experience. 🔗 LINKS: 💻 Download...
Your Guide to Creating Hexbin Maps + Cleaning Census Data in R: A Focus on Māori Language Speakers
Просмотров 95Год назад
Welcome to a comprehensive tutorial where we'll dive deep into the world of R! In this video, I'll guide you through the process of creating visually compelling Hexbin maps and cleaning Census data - all using R. Our focus will be on Auckland's Local Board Areas, specifically the distribution of Māori language speakers according to the 2018 Census. This practical guide will use important R pack...
User Communication in R: Command-Line Messages Explained
Просмотров 91Год назад
In this tutorial, we delve into the core concepts of user communication in R, demonstrating how to efficiently create and manage command-line messages to provide user feedback as they wait for code to execute. Whether you're a beginner just starting out in R or an intermediate user looking to upgrade your skills, this tutorial will provide valuable insights. We'll guide you through the basics o...
Bow, Nod, Scrape: Polite Web Scraping With R
Просмотров 272Год назад
Back with our web scraping series, we're now focusing on the 'polite' package in R! This episode dives into how we use 'polite' to ethically scrape the Guardian Film Review website. This R package ensures we respect the site's rules and don't overwhelm their servers. In this video, you'll learn: - The 'polite' package and its importance - How to revise our existing scraping code with 'polite' -...
Build Your Own Functions in R
Просмотров 119Год назад
When you think about it, R is really just a bunch of functions. So let's create our own - it's easier than you think! LINKS Download the code: github.com/lddurbin/guardian_film_reviews_data/blob/e05dcff501777f0cc5eb8e0652328bdca0d74e5a/datacasts_film_review_data.R ELSEWHERE 🐦 Twitter - lddurbin
Web Scraping With R
Просмотров 539Год назад
In 40 minutes and 60 lines of code, we'll grab everything we need from a film review on the Guardian website using R. LINKS Download the code: github.com/lddurbin/guardian_film_reviews_data/blob/3c210405b794db048130a42e359734a02e011815/datacasts_film_review_data.R ELSEWHERE 🐦 Twitter - lddurbin
Cleaning Excel Data Using R
Просмотров 16 тыс.3 года назад
Excel spreadsheets come in all shapes and sizes. Using just three packages in R (tidyverse, lubridate, and tidyxl), we can whip it into shape in no time. 🔗 LINKS: 🧙 Discover your data profile: quiz.tryinteract.com/#/664a5f11fe86740015036871 📬 Sign up for my newsletter for more insights and tips: lee-durbin.ck.page/subscribe-general 📦 {tidyxl}: nacnudus.github.io/tidyxl/index.html 🛠️ Download th...
File Compression Using R
Просмотров 1643 года назад
We've learned how to extract files from a zip archive using R, but what about compressing files in the first place? We'll look at that, and more, in this video. LINKS Download the code: github.com/lddurbin/R_tutorial rdflib: github.com/ropensci/rdflib Virtuoso homepage: virtuoso.openlinksw.com/ Virtuoso R package: github.com/ropensci/virtuoso R.utils: github.com/HenrikBengtsson/R.utils More on ...
Unzipping with R
Просмотров 2 тыс.3 года назад
If you have a bunch of zip files, R can extract what's inside them using just two lines of code. Let me show you how... LINKS New British National Bibliography records: www.bl.uk/collection-metadata/new-bnb-records ELSEWHERE 🐦 Twitter - lddurbin
Awesome video! It would be better if you used a bigger font size. It's hard to read even with the zoom ins 😢
Great advice, thank you!
The font is small and blurry - hard to see what you are doing.
Hey sorry to hear that. Full code available here: github.com/lddurbin/guardian_film_reviews_data/blob/45d0d4ce7ef74054609ab28d44ddd8c6e92eafa3/datacasts_film_review_data.R
@@datacasts Thanks
You can tell this is the first piece-to-camera I recorded in nearly a year - I didn’t realise I wasn’t looking into the camera for the first minute! 😂
Thanks a million sir
Like cleaning and splitting a WhatsApp group data into various columns/fields; Name; message ; Phone number; Date etc
That’s a great idea, I’ll add it to my list!
I have a video request sir; A data cleaning tutorial on Whatsapp group data using stringr and regex
Thanks a million sir for the video
You’re welcome!
Awesome Your Content
Thank you!
Amazing tutorial, but as a real real beginner in R its a bit advanced for :( since you don't really explain things at that level sometimes or go through some of the explanations quickly. I tried pausing and listening to some of the statements over and over again but was even then very overwhelming. I have an excel file to clean, although not exactly this kind bur rather one downloaded from Survey Monkey, meaning its in a dataframe format I gotta do some cleaning and struggling very much with those. Any reference would be highly appreciated. Thanks.
where is the file mate
I have some data with Na values but in the excel just are white spaces so xlsx _cell can't recognize such values and worst they will move in the wrong position. I solved it changing manually the excel with Na. But maybe there's some other solution?
Lubridate can actually extract the date out of the url easily with just ymd(url)!
I prefer to use glue over paste. Thus glue_collapse(x, sep = " ") does a nice job on the body text.
I think that this wonderful piece would get more reads if it was posted under web scraping rather than reading a web page which is a bit generic. Web scraping is better description of what takes place here.
Good tip, I’ll update the title accordingly. Thanks!
This is well done! Nice break down of how to study a webpage and ferret out what one needs.
What if there is even less consistency. Like tables starting from any cell arbitrarily for each player, instead of always starting at row 6 as shown?
Hey good question! In that case you’d want to search for any character in a row after “Age (years)”, which gives you the row containing the headers for the activities tables.
@@thadremaw Amazing vid, good channel too. As i see it, there is more demand for python from audience. Maybe u could do code part parallelly on R and Python in a single vid. That way, not only would u be teaching 2 langs at once, but also show the advantages and disads of both side by side. Would be hard though.
@@thadremaw oh ur not OP nvm
I am the OP, I accidentally posted from my other account sorry! Good idea about a parallel approach to R & Python, I’ll think about it, thanks!
Why would one do this when one can use Power Query?
Hey, I’ve used both and I think it’s fine if you prefer Power Query. Personally I find the R syntax more intuitive, and I’m also an advocate for open source.
@Vishal Goswami Hi, Im also learning the data anlayst course . If you don't mind would you like to say me the case study ???
sir I need help can you please reply me back
Sure, how can I help?
@@datacasts I got a case study from google data analyst course .. cyclist part . And i just need guidance on how to complete it Your help will mean alot
@@vishalgoswami7512 I can try to provide some guidance. What's the problem you're trying to solve? Which data are you using?
@@datacasts can we talk on WhatsApp then i can explain you
I’d prefer to keep the conversation here. Are you struggling to obtain the data? Or to clean it? Or to analyse it?
Amazing tutorial. hope to implement such a thing soon
Amazing! thank you for doing this. I watched this a year ago and just rewatched it. It makes more sense having got more usage and experience in R. Love this topic as I do come by very messy Excel sheets. My main challenge now is to find the most efficient way to read heaving XLSb files
Hello, Can we use unpivotr package to clean this messy data ?
Good question! Yes, unpivotr is often used with tidyxl, however in this case it took me just as many lines of code to clean the data using unpivotr as it did without it - but that’s maybe because I don’t know unpivotr well enough :)
@@datacasts I tried unpivotr reading the documentation but somehow it is not picking the correct columns. It throws an error saying the values should be unique. I am not so sure but somehow I felt while practicing that unpivotr, it works only on structured pivot data or excel with multiple rows and column headers. But in this example, the data seems like key and value which unpivotr is unable to recognise. I may as well be completely wrong. As I am very new to R, is there a fixed method to clean such messy data or it is like for every messy data we have to take a different approach like you did in here ?
Sorry for replying so late but that’s exactly right, no two messy data files are the same :-)
Thanks for sharing! I used to receive monthly financial reports and cringe. If I ever have to deal with reports like that again, this process would be great for tidying it up for analysis.
Glad I could help!
Already learning new stuff, good job ;)