- Видео 120
- Просмотров 23 871
Harold Thomas
Добавлен 27 апр 2023
A channel for video tutorials on software and apps. Microsoft Office all apps (specialize in Excel) Power BI, Sway, ChatGPT and whatever other rabbit hole I go down.
Data Cleaning in R Tidyr: Pivot_Longer, Pivot_Wider
2nd of 4 videos on tidying data for analysis with Tidyr. Here I explain how to pivot data wider and longer. Getting your data in and out of tidy format. Includes values_fn argument for pivoting with aggregation.
Просмотров: 3
Видео
Data Cleaning in R Tidyr: Nest, Unnest & Hoist
Просмотров 3019 часов назад
First of 3 videos on tidying data for analysis with Tidyr. Here I explain how to nest data into lists, unnest data from lists, and hoist specific columns.
R Wars: 100 tidyverse Puzzles 86 - 91 GGPLOT2
Просмотров 719 часов назад
R Wars: A series where I show the solutions to the 100 Star War tidyverse puzzles posted on my github repo: github.com/hthomas229/PurpleCrown/blob/main/100starwarspuzzles.R github.com/hthomas229/PurpleCrown/blob/main/100starwarspuzzles_with_solutions.R 100 problems from beginner to advanced levels. Give them a try. You might even have some fun. MAY THE FORCE BE WITH YOU
R Data Visualization & Analysis: Impute Missing Values With MICE
Просмотров 3714 дней назад
Use the MICE package to impute missing values. Advanced regression and classification techniques. You choose the method, or MICE will choose for you. Excellent data visualization. github.com/hthomas229/PurpleCrown
R Data Visualization & Analysis: Impute Missing Values With VIM
Просмотров 3714 дней назад
Use the VIM package to impute missing values. kNN, hotdeck, matchImpute, IRMI, regressionImp and rangerImpute. Excellent before and after imputation data visualization. github.com/hthomas229/PurpleCrown
R Wars: 100 tidyverse Puzzles 78 - 84 Working with Dates and ggplot
Просмотров 1121 день назад
R Wars: A series where I show the solutions to the 100 Star War tidyverse puzzles posted on my github repo: github.com/hthomas229/PurpleCrown/blob/main/100starwarspuzzles.R github.com/hthomas229/PurpleCrown/blob/main/100starwarspuzzles_with_solutions.R 100 problems from beginner to advanced levels. Give them a try. You might even have some fun. MAY THE FORCE BE WITH YOU
R Data Visualization & Analysis: Impute Missing Values With Zoo
Просмотров 4021 день назад
Using the ZOO R package na.* functions to impute missing values/NAs in a data frame. Starts with a short primer on why, when and how to impute. You can get the code at my github repository: github.com/hthomas229/PurpleCrown Additional Resources: www.bookdown.org/rwnahhas/RMPH/mi.html cran.r-project.org/web/packages/zoo/zoo.pdf (see the vignettes)
R skimr janitor ggally psych VIM : Data Visualization and Analysis
Просмотров 3928 дней назад
5 more excellent data visualization and summary statistical packages are explored. See how your data is distributed. View correlations. Check for missingness and imputed values and more , , ,
R Wars: 100 tidyverse Puzzles 69 -77 DISTINCT, FILL, MAP, & Forcats
Просмотров 25Месяц назад
R Wars: A series where I show the solutions to the 100 Star War tidyverse puzzles posted on my github repo: github.com/hthomas229/PurpleCrown/blob/main/100starwarspuzzles.R github.com/hthomas229/PurpleCrown/blob/main/100starwarspuzzles_with_solutions.R 100 problems from beginner to advanced levels. Give them a try. You might even have some fun. MAY THE FORCE BE WITH YOU
R inspectdf : Data Visualization and Analysis
Просмотров 62Месяц назад
The R inspectdf package lets you visualize metadata about your data frame in both tabular form and really cool plots. Categorical and numerical distribution and imbalances, NAs and missingness, correlations, datatypes, and memory usage. And again really cool plots!
Advanced Dax: Maven Halloween Challenge
Просмотров 54Месяц назад
This is the 4th in a series where I show how I handled the Maven Data Challenge. For the Halloween Challenge I used R and the Tidyverse to clean and transform the data and then displayed it visually in Power BI with some DAX measures added. The files are available here: github.com/hthomas229/PurpleCrown.git
R Wars: 100 tidyverse Puzzles 63 - 68 RANK, DENSE_RANK, NTILE, PERCENT_RANK, CUMSUM
Просмотров 11Месяц назад
R Wars: A series where I show the solutions to the 100 Star War tidyverse puzzles posted on my github repo: github.com/hthomas229/PurpleCrown/blob/main/100starwarspuzzles.R github.com/hthomas229/PurpleCrown/blob/main/100starwarspuzzles_with_solutions.R 100 problems from beginner to advanced levels. Give them a try. You might even have some fun. MAY THE FORCE BE WITH YOU
R VisDat: Get A Good Look at Your Data
Просмотров 38Месяц назад
Use the R package visdat to get a view of the quality of your data. View data types, missingness (NAs), differences between 2 datasets, correlation of variables and more in colorful plots.
R Wars: 100 tidyverse Puzzles 58 - 62 Window Functions Lead Lag & RowNumber
Просмотров 5Месяц назад
R Wars: A series where I show the solutions to the 100 Star War tidyverse puzzles posted on my github repo: github.com/hthomas229/PurpleCrown/blob/main/100starwarspuzzles.R github.com/hthomas229/PurpleCrown/blob/main/100starwarspuzzles_with_solutions.R 100 problems from beginner to advanced levels. Give them a try. You might even have some fun. MAY THE FORCE BE WITH YOU
R Wars: 100 tidyverse Puzzles 55-56 Count, Proportion, Top N
Просмотров 6Месяц назад
R Wars: A series where I show the solutions to the 100 Star War tidyverse puzzles posted on my github repo: github.com/hthomas229/PurpleCrown/blob/main/100starwarspuzzles.R github.com/hthomas229/PurpleCrown/blob/main/100starwarspuzzles_with_solutions.R 100 problems from beginner to advanced levels. Give them a try. You might even have some fun. MAY THE FORCE BE WITH YOU
R Wars: 100 tidyverse Puzzles 51 - 54 group_by
Просмотров 12 месяца назад
R Wars: 100 tidyverse Puzzles 51 - 54 group_by
R Wars: 100 tidyverse Puzzles 47 - 50 count & Intro to ggplot
Просмотров 122 месяца назад
R Wars: 100 tidyverse Puzzles 47 - 50 count & Intro to ggplot
R Wars: 100 tidyverse Puzzles 41 - 46 Stringr & Calculated Columns
Просмотров 42 месяца назад
R Wars: 100 tidyverse Puzzles 41 - 46 Stringr & Calculated Columns
R Wars: 100 tidyverse Puzzles 34 - 40 Stringr, Unite & Separate
Просмотров 82 месяца назад
R Wars: 100 tidyverse Puzzles 34 - 40 Stringr, Unite & Separate
R Wars: 100 tidyverse Puzzles 27 - 33 Dplyr Continued
Просмотров 52 месяца назад
R Wars: 100 tidyverse Puzzles 27 - 33 Dplyr Continued
R Wars: 100 tidyverse Puzzles 13 - 26 Dplyr Select
Просмотров 82 месяца назад
R Wars: 100 tidyverse Puzzles 13 - 26 Dplyr Select
R Wars: 100 tidyverse Puzzles 1 - 12 Getting Started & Getting to Know Your Data
Просмотров 132 месяца назад
R Wars: 100 tidyverse Puzzles 1 - 12 Getting Started & Getting to Know Your Data
Data Cleaning in the R tidyverse: Cleaning Up
Просмотров 262 месяца назад
Data Cleaning in the R tidyverse: Cleaning Up
Data Cleaning in the R tidyverse: Getting Started
Просмотров 672 месяца назад
Data Cleaning in the R tidyverse: Getting Started
Data Cleaning: SQL v Python Pandas v Power BI Power Query: Find & Remove Duplicates
Просмотров 452 месяца назад
Data Cleaning: SQL v Python Pandas v Power BI Power Query: Find & Remove Duplicates
Advanced Dax: Maven Rewards Challenge
Просмотров 1783 месяца назад
Advanced Dax: Maven Rewards Challenge
Data Cleaning: SQL v Python Pandas v Power BI Power Query: REPLACE, DROP COLUMNS, HANDLE NULLS
Просмотров 273 месяца назад
Data Cleaning: SQL v Python Pandas v Power BI Power Query: REPLACE, DROP COLUMNS, HANDLE NULLS
Data Cleaning: SQL v Python Pandas v Power BI Power Query: COALESCE, BFILL, FIRST NON BLANK VALUE
Просмотров 313 месяца назад
Data Cleaning: SQL v Python Pandas v Power BI Power Query: COALESCE, BFILL, FIRST NON BLANK VALUE
Data Cleaning: SQL v Python Pandas v Power BI Power Query: Splitting Columns
Просмотров 1803 месяца назад
Data Cleaning: SQL v Python Pandas v Power BI Power Query: Splitting Columns
Data Cleaning: SQL v Python Pandas v Power BI Power Query: Cleaning Text Strings
Просмотров 1063 месяца назад
Data Cleaning: SQL v Python Pandas v Power BI Power Query: Cleaning Text Strings
Thanks so much! it works!
This has been updated, you can find visual level formatting in the properties pane of the viz.
+1
Thanks! Just what I was looking for
Glad I could help!
Good morning sir excellent teaching
It's really helpful to me thank you
Glad to hear that
My favourite: Power Query.
me too for ease -- i do like to play with Pandas for fun though
Thank You so much
You're most welcome
Forget about it..👍
Very helpful. Thank you.
Glad it was helpful! Thanks for the comment. schlemiel schlimazel
nice. please put excel file in the description
Very helpful video. Just what I was looking for. Fair play to you.
'Promo sm' ✌️
Good. Give the excel files
Nice job. Please put excel file in the description