I want to know what are the unique values in a column given a value from another column, for exmple, I have the following data frame:
| name | category |
|---|---|
| A | Pr |
| A | Pr |
| B | Pr |
| A | N |
| B | N |
The result should be like this:
| A | B | |
|---|---|---|
| Pr | 2 | 1 |
| N | 1 | 1 |
Asked
Active
Viewed 11 times
0
-
In base you could try `tapply(data$Name, data$category, table)` – Daniel O Feb 28 '21 at 03:10
-
`df %>% dplyr::count(name, category) %>% tidyr::pivot_wider(names_from = name, values_from = n)` – Ronak Shah Feb 28 '21 at 03:11