No video
Cleaning Excel Data Using R
Рет қаралды 16,059
Күн бұрын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.tryintera...
📬 Sign up for my newsletter for more insights and tips: lee-durbin.ck....
📦 {tidyxl}: nacnudus.githu...
🛠️ Download the code: github.com/ldd...
📈 RESOURCES:
💻 Download R: cloud.r-projec...
📊 Download RStudio Desktop: posit.co/downl...
🍿 WATCH NEXT:
• 3 Ways to Start Using R: • 3 ways to start using R
• Unzipping with R: • Unzipping with R
MY OTHER SOCIALS:
💼 Connect with me on LinkedIn (I share lots of useful content): / lee-durbin
🐦 Twitter/X - / lddurbin
WHO AM I?
Hello, I'm Lee, and this is where I share the inside track on how to wrangle your data into shape like a pro, as well as time-saving tips and tricks for solving common data problems that will make you stand out at your workplace.
📝 If you want to start or enhance your journey in R coding and data analysis, subscribe and turn on notifications for more updates!
@whynotfandy 2 жыл бұрын
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.
@datacasts 2 жыл бұрын
Glad I could help!
@ahmed007Jaber 2 жыл бұрын
Amazing tutorial. hope to implement such a thing soon
@ahmed007Jaber 7 ай бұрын
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
@basharathhussainmohammed5585 Жыл бұрын
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?
@thadremaw Жыл бұрын
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.
@basharathhussainmohammed5585 Жыл бұрын
@@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.
@basharathhussainmohammed5585 Жыл бұрын
@@thadremaw oh ur not OP nvm
@datacasts Жыл бұрын
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!
@MizanurShuvraRidwan 5 ай бұрын
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.
@draprincesa01 9 ай бұрын
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?
@rajarshimaity6838 2 жыл бұрын
Hello, Can we use unpivotr package to clean this messy data ?
@datacasts 2 жыл бұрын
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 :)
@rajarshimaity6838 2 жыл бұрын
@@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 ?
@datacasts 2 жыл бұрын
Sorry for replying so late but that’s exactly right, no two messy data files are the same :-)
@anshikabhusal2741 Жыл бұрын
@Vishal Goswami Hi, Im also learning the data anlayst course . If you don't mind would you like to say me the case study ???
@Phoenixspin Жыл бұрын
Why would one do this when one can use Power Query?
@datacasts Жыл бұрын
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.
@joys8943 6 ай бұрын
where is the file mate
@vishalgoswami7512 Жыл бұрын
sir I need help can you please reply me back
@datacasts Жыл бұрын
Sure, how can I help?
@vishalgoswami7512 Жыл бұрын
@@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
@datacasts Жыл бұрын
@@vishalgoswami7512 I can try to provide some guidance. What's the problem you're trying to solve? Which data are you using?
@vishalgoswami7512 Жыл бұрын
@@datacasts can we talk on WhatsApp then i can explain you
@datacasts Жыл бұрын
I’d prefer to keep the conversation here. Are you struggling to obtain the data? Or to clean it? Or to analyse it?
Cool Items Official
Рет қаралды 51 МЛН
R Programming 101
Рет қаралды 76 М.