Get number of occurrences based on Index and Column in Pandas DataFrame to create different view of data [duplicate]

Question

Am trying to get the occurrences of certain pattern based on Index in Dataframe , any help would be appreciated

Have manually added a column as Index and need to get occurrences of pattern based on Index and the column

dataset sample      
a(index)    d   
pattern 1   test    
pattern 1   test    
pattern 1   test2   
pattern 2   test3   
pattern 2   test    
pattern 2   test    

expected output     

Am looking to make a dataframe something like below with the above sample data

pattern  test test2 test3
----------------------------------
pattern 1   2   1        0
pattern 2   2   0        1

Answer 1

If you reset the index, it's a pretty straightforward groupby:

In [18]: df
Out[18]:
               d
a
pattern 1   test
pattern 1   test
pattern 1  test2
pattern 2  test3
pattern 2   test
pattern 2   test

In [19]: df.reset_index().groupby(['a', 'd']).apply(len).reset_index()
Out[19]:
           a      d  0
0  pattern 1   test  2
1  pattern 1  test2  1
2  pattern 2   test  2
3  pattern 2  test3  1