使用trandesc查找频繁的trncd，然后查找频繁的trnamt。月与月之间的频繁交易

Question

我想从具有相同帐户持有人的数据集中查找频繁交易。我的意图是根据先前数据中的频繁交易建议下个月的交易。下面是示例数据集

     Acno  Year    Month  Trncd                             Trndescr     Trnamt
      1    2018    12     711    transfer to sarah Account no: 00123     100
      1    2018    12     711      transfer to mom Account no: 00222     300
      1    2018    12     711      transfer to AIA Account no: 12345     150
      1    2018    12     811           bil payment Water Code: 1100      55
      1    2018    12     811        bil payment Electric Code: 2200      20
      1    2019    1      711      transfer to mom Account no: 00222     200
      1    2019    1      711  transfer to natasya Account no: 14235      50
      1    2019    1      811           bil payment Water Code: 1100      45
      1    2019    2      711      transfer to mom Account no: 00222     300
      1    2019    2      711    transfer to sarah Account no: 00123      95
      1    2019    2      711      transfer to dad Account no: 00333     300
      1    2019    2      811           bil payment Water Code: 1100      45 

我的预期结果应该是这样的：

  Acno  Year  Month  Trncd                          Trndescr  Trnamt
    1  2019      3    711  transfer to mom Account no:00222     300
    1  2019      3    811     bill payment Water Code: 1100      45

有人能帮我解决这件事吗？任何帮助都将不胜感激。先谢谢你