To read data from multiple sheets in an Excel workbook, combine them into a single dataframe using R and to deal with mixed date formats using the janitor package
Comparing code queries: Pandas Python and Dplyr R.