Unique values of two columns for pandas dataframe [duplicate]

You need groupby + size + Series.reset_index:

df = df.groupby(['Col1', 'Col2']).size().reset_index(name="Freq")
print (df)
   Col1  Col2  Freq
0     1     1     1
1     1     2     3
2     3     4     2