Use {janitor} to clean Excel files with R

Описание к видео Use {janitor} to clean Excel files with R

This video demonstrates the power of the {janitor} package. I show you how to clean messy Excel files and use other powerful functions from {janitor}.

Original blog post: https://albert-rapp.de/post/2022-01-1...
Twitter:   / rappa753  

Time Codes:
00:00 Intro
00:39 Read Excel files and clean names
03:59 Remove empty cells
04:51 Remove constant columns
05:20 Convert dates to actual date format
06:21 Round numbers
09:11 Find similar observations
11:12 table() alternative
14:09 Outro

Music: www.bensound.com and https://ocremix.org/remix/OCR04208

Комментарии

Информация по комментариям в разработке

Похожие видео