I have the following data as an excel file:
| X |
|---|
| 0 |
| 0 |
| 1 |
| 1 |
| 0 |
| 0 |
I want to count the number of times I have the following sequence:
00
11
10
01
I desire the following output:
Sequence Count
00 2
11 1
01 1
10 1
I tried using count but I could not come up with anything useful. count.seq serves a similar purpose but it estimates for DNA or RNA sequence data.