Course curriculum

    1. Welcome

    2. Preliminaries

    3. Download Area

    1. Lesson 01: Same data in different formats

    2. Lesson 02: Read standard csv & Paths

    3. Lesson 03: Reading non-standard csv-files

    4. Lesson 04: Reading TSV and TXT files

    5. Lesson 05: Read Excel files

    6. Lesson 06: Read JSON files

    7. Lesson 07: Turning missing values into true NAs

    8. Lesson 08: Transforming/Parsing numbers

    9. Lesson 09: Transforming/Parsing dates & datetimes

    10. Lesson 10: Handle a mix of date(time) formats

    11. Lesson 11: Combining data sets columnwise & rowwise

    12. Interlude: A mental model for join functions

    13. Lesson 12: Combining datasetx by left_ and right_join()

    14. Lesson 13: Other join types

    15. Lesson 14: Joining by multiple criteria

    16. Lesson 15: Rearranging data from wide to long format with pivot_longer()

    17. Lesson 16: Advanced column name tricks with pivot_longer()

    18. Lesson 17: Making long data wide with pivot_wider()

    19. Lesson 18: Cleaning up Excel Pivot Tables

    20. Lesson 19: Beheading with multiple data formats

    21. Lesson 20: Beheading colored cells

    22. Lesson 21: Putting it all together

About this course

  • $99.00
  • 25 lessons
  • 2.5 hours of video content

Discover your potential, starting today

Enroll today