Some Excel files are a real challenge to deal with. I found the unheadr package to be helpful in combination with some of the tidyverse packages (tidyr). It also helps to know a little bit about regular expressions (regex).
Thank you so much! This is exactly what I was looking for and couldn’t find anywhere else. You did a great job explaining, and I really appreciated the summarizing slide at the end comparing the different packages because that was something I was still unclear about.
Some Excel files are a real challenge to deal with. I found the unheadr package to be helpful in combination with some of the tidyverse packages (tidyr). It also helps to know a little bit about regular expressions (regex).
Thank you so much! This is exactly what I was looking for and couldn’t find anywhere else. You did a great job explaining, and I really appreciated the summarizing slide at the end comparing the different packages because that was something I was still unclear about.
thank you for this. I have come across the two packages but never heard about unpivotr::rectify. Thank you for sharing. This is really helpful