Skip to content

Data Science Tutorials

  • Home
  • R
  • Statistics
  • Course
  • Machine Learning
  • Guest Blog
  • Contact
  • About Us
  • Toggle search form
  • How to Standardize Data in R
    How to Standardize Data in R? R
  • Hypothesis Testing in R
    Hypothesis Testing in R R
  • Replace NA with Zero in R
    Replace NA with Zero in R R
  • How to Filter Rows In R
    How to Filter Rows In R? R
  • Checking Missing Values in R
    Checking Missing Values in R R
  • Tips for Rearranging Columns in R
    Tips for Rearranging Columns in R R
  • best books about data analytics
    Best Books to learn Tensorflow Course
  • How to move from Junior Data Scientist
    How to move from Junior Data Scientist Machine Learning
Crosstab calculation in R

Crosstab calculation in R

Posted on June 11June 11 By Jim No Comments on Crosstab calculation in R
Tweet
Share
Share
Pin

Crosstab calculation in R, To create a crosstab using functions from the dplyr and tidyr packages in R, use the following basic syntax.

df %>%
  group_by(var1, var2) %>%
  tally() %>%
  spread(var1, n)

The examples below demonstrate how to utilize this syntax in practice.

Control Chart in Quality Control-Quick Guide – Data Science Tutorials

Example 1: Make a simple crosstab

Let’s say we have the following R data frame:

Let’s create a data frame

df <- data.frame(team=c('X', 'X', 'X', 'X', 'Y', 'Y', 'Y', 'Y'),
                 position=c('A', 'A', 'B', 'C', 'C', 'C', 'D', 'D'),
                 points=c(107, 207, 208, 211, 213, 215, 219, 313))

Now we can view the data frame

df
   team position points
1    X        A    107
2    X        A    207
3    X        B    208
4    X        C    211
5    Y        C    213
6    Y        C    215
7    Y        D    219
8    Y        D    313

To make a crosstab for the ‘team’ and ‘position’ variables, use the following syntax.

How to perform One-Sample Wilcoxon Signed Rank Test in R? – Data Science Tutorials

library(dplyr)
library(tidyr)

Now we can produce the crosstab

df %>%
  group_by(team, position) %>%
  tally() %>%
  spread(team, n)
  position     X     Y
  <chr>    <int> <int>
1 A            2    NA
2 B            1    NA
3 C            1     2
4 D           NA     2

Here’s we can infer the values in the crosstab.

There is 2 player who has a position of ‘A’ and belongs to team ‘X’

There is 1 player who has a position of ‘B’ and belongs to team ‘X’

Arrange Data by Month in R with example – Data Science Tutorials

It’s worth noting that we may change the crosstab’s rows and columns by changing the value used in the spread() function.

library(dplyr)
library(tidyr)

Let’s produce a crosstab with ‘position’ along with columns.

Rejection Region in Hypothesis Testing – Data Science Tutorials

df %>%
  group_by(team, position) %>%
  tally() %>%
  spread(position, n)
team      A     B     C     D
  <chr> <int> <int> <int> <int>
1 X         2     1     1    NA
2 Y        NA    NA     2     2

Check your inbox or spam folder to confirm your subscription.

Tweet
Share
Share
Pin
R Tags:dplyr

Post navigation

Previous Post: Augmented Dickey-Fuller Test in R
Next Post: Filtering for Unique Values in R- Using the dplyr

Related Posts

  • How to Find Unmatched Records in R
    How to Find Unmatched Records in R R
  • Triangular Distribution in R
    Triangular Distribution in R R
  • Filter Using Multiple Conditions in R
    Filter Using Multiple Conditions in R R
  • Subsetting with multiple conditions in R
    Subsetting with multiple conditions in R R
  • How to Get a Job as a Data Engineer
    How to Get a Job as a Data Engineer? R
  • Two-Way ANOVA Example in R
    How to perform a one-sample t-test in R? R

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

  • About Us
  • Contact
  • Disclaimer
  • Guest Blog
  • Privacy Policy
  • YouTube
  • Twitter
  • Facebook
  • Top 7 Skills Required to Become a Data Scientist
  • Learn Hadoop for Data Science
  • How Do Online Criminals Acquire Sensitive Data
  • Top Reasons To Learn R in 2023
  • Linear Interpolation in R-approx

Check your inbox or spam folder to confirm your subscription.

 https://www.r-bloggers.com
  • Hypothesis Testing in R
    Hypothesis Testing in R R
  • How to Replace Inf Values with NA in R
    How to Replace Inf Values with NA in R R
  • glm function in R
    glm function in r-Generalized Linear Models R
  • Get the first value in each group in R
    Get the first value in each group in R? R
  • Best Books to Learn R Programming
    Best Books to Learn R Programming Course
  • Top Data Science Examples You Should Know 2023
    Top Data Science Applications You Should Know 2023 Machine Learning
  • Hypothesis Testing Examples
    Hypothesis Testing Examples-Quick Overview Statistics
  • ggdogs on ggplot2
    ggdogs on ggplot2 R

Copyright © 2023 Data Science Tutorials.

Powered by PressBook News WordPress theme