Hello! I have started a new series of videos dedicated to those who are already familiar with Excel and are seeking to learn R the easy way. Through a side by side comparison with Excel, you will learn how R works until you master it! Here is Episode #1. Let me know if you like the series and if I should keep it going.
I noted that a previous post about Pivot Tables in R with melt and cast has gained quite some popularity, so I thought to write on the same topic but using this time a different R function: aggregate. While aggregate is not as powerful as melt and cast from the reshape package, it may result sometimes simpler and more intuitive to use, so it is worth to learn how it works.
Suppose you are editing your video in Final Cut Pro X and you are pretty ahead in your workflow. You have already placed the background (bed) music along the video and have properly key-framed it around the dialogs.
Then, while reviewing the almost finished version, you realize that a piece of music does not really fit with the context. It definitely needs to be replaced, but doing so you will be losing all your key-framing work on that part. What a waste of time! But wait. Here is a trick that can help you.