Indexing/Filtering Pairs

import pandas as pd

import faninsar as fis

dates = pd.date_range(start="2020-01-01",end="2024-12-31",freq="12D")
dates

DatetimeIndex(['2020-01-01', '2020-01-13', '2020-01-25', '2020-02-06',
               '2020-02-18', '2020-03-01', '2020-03-13', '2020-03-25',
               '2020-04-06', '2020-04-18',
               ...
               '2024-09-12', '2024-09-24', '2024-10-06', '2024-10-18',
               '2024-10-30', '2024-11-11', '2024-11-23', '2024-12-05',
               '2024-12-17', '2024-12-29'],
              dtype='datetime64[ns]', length=153, freq='12D')

pairs_factory = fis.PairsFactory(dates)
pairs = pairs_factory.from_interval(max_interval=3)
pairs

         Pairs           
       primary  secondary
0   2020-01-01 2020-01-13
1   2020-01-01 2020-01-25
2   2020-01-01 2020-02-06
3   2020-01-13 2020-01-25
4   2020-01-13 2020-02-06
..         ...        ...
448 2024-11-23 2024-12-17
449 2024-11-23 2024-12-29
450 2024-12-05 2024-12-17
451 2024-12-05 2024-12-29
452 2024-12-17 2024-12-29

[453 rows x 2 columns]

faninsar.Pairs

• pairs=453
• dates=153

• faninsar.Pairs

  primary secondary days 0 2020-01-01 2020-01-13 12 1 2020-01-01 2020-01-25 24 ... ... ... ... 451 2024-12-05 2024-12-29 24 452 2024-12-17 2024-12-29 12

• Indexes: (4)
  • primary
    Acquisition
    2020-01-01 2020-01-01 ... 2024-12-05 2024-12-17

    Acquisition(['2020-01-01', '2020-01-01', '2020-01-01', '2020-01-13',
                 '2020-01-13', '2020-01-13', '2020-01-25', '2020-01-25',
                 '2020-01-25', '2020-02-06',
                 ...
                 '2024-10-30', '2024-11-11', '2024-11-11', '2024-11-11',
                 '2024-11-23', '2024-11-23', '2024-11-23', '2024-12-05',
                 '2024-12-05', '2024-12-17'],
                dtype='datetime64[s]', length=453, freq=None)

    faninsar.Acquisition

    • dates: 453

    • 2020-01-01 2020-01-01 2020-01-01 ... 2024-12-05 2024-12-05 2024-12-17

      array(['2020-01-01T00:00:00', '2020-01-01T00:00:00', '2020-01-01T00:00:00',
             ..., '2024-12-05T00:00:00', '2024-12-05T00:00:00',
             '2024-12-17T00:00:00'], dtype='datetime64[s]')

    • Statistic: (4)

      start	2020-01-01
      end	2024-12-17
      unique	152
      total	453

  • secondary
    Acquisition
    2020-01-13 2020-01-25 ... 2024-12-29 2024-12-29

    Acquisition(['2020-01-13', '2020-01-25', '2020-02-06', '2020-01-25',
                 '2020-02-06', '2020-02-18', '2020-02-06', '2020-02-18',
                 '2020-03-01', '2020-02-18',
                 ...
                 '2024-12-05', '2024-11-23', '2024-12-05', '2024-12-17',
                 '2024-12-05', '2024-12-17', '2024-12-29', '2024-12-17',
                 '2024-12-29', '2024-12-29'],
                dtype='datetime64[s]', length=453, freq=None)

    faninsar.Acquisition

    • dates: 453

    • 2020-01-13 2020-01-25 2020-02-06 ... 2024-12-17 2024-12-29 2024-12-29

      array(['2020-01-13T00:00:00', '2020-01-25T00:00:00', '2020-02-06T00:00:00',
             ..., '2024-12-17T00:00:00', '2024-12-29T00:00:00',
             '2024-12-29T00:00:00'], dtype='datetime64[s]')

    • Statistic: (4)

      start	2020-01-13
      end	2024-12-29
      unique	152
      total	453

  • days
    DaySpan
    12 24 36 12 24 36 12 24 ... 36 12 24 36 12 24 12

    DaySpan([12, 24, 36, 12, 24, 36, 12, 24, 36, 12,
             ...
             36, 12, 24, 36, 12, 24, 36, 12, 24, 12],
            dtype='int32', length=453)

    faninsar.DaySpan

    • days: 453

    • 12 24 36 12 24 36 12 24 36 12 24 ... 24 36 12 24 36 12 24 36 12 24 12

      array([12, 24, 36, ..., 12, 24, 12], dtype=int32)

    • Statistic: (4)

      min	12
      max	36
      unique	3
      total	453

  • dates
    Acquisition
    2020-01-01 2020-01-13 ... 2024-12-17 2024-12-29

    Acquisition(['2020-01-01', '2020-01-13', '2020-01-25', '2020-02-06',
                 '2020-02-18', '2020-03-01', '2020-03-13', '2020-03-25',
                 '2020-04-06', '2020-04-18',
                 ...
                 '2024-09-12', '2024-09-24', '2024-10-06', '2024-10-18',
                 '2024-10-30', '2024-11-11', '2024-11-23', '2024-12-05',
                 '2024-12-17', '2024-12-29'],
                dtype='datetime64[s]', length=153, freq=None)

    faninsar.Acquisition

    • dates: 153

    • 2020-01-01 2020-01-13 2020-01-25 ... 2024-12-05 2024-12-17 2024-12-29

      array(['2020-01-01T00:00:00', '2020-01-13T00:00:00', '2020-01-25T00:00:00',
             '2020-02-06T00:00:00', '2020-02-18T00:00:00', '2020-03-01T00:00:00',
             '2020-03-13T00:00:00', '2020-03-25T00:00:00', '2020-04-06T00:00:00',
             '2020-04-18T00:00:00', '2020-04-30T00:00:00', '2020-05-12T00:00:00',
             '2020-05-24T00:00:00', '2020-06-05T00:00:00', '2020-06-17T00:00:00',
             '2020-06-29T00:00:00', '2020-07-11T00:00:00', '2020-07-23T00:00:00',
             '2020-08-04T00:00:00', '2020-08-16T00:00:00', '2020-08-28T00:00:00',
             '2020-09-09T00:00:00', '2020-09-21T00:00:00', '2020-10-03T00:00:00',
             '2020-10-15T00:00:00', '2020-10-27T00:00:00', '2020-11-08T00:00:00',
             '2020-11-20T00:00:00', '2020-12-02T00:00:00', '2020-12-14T00:00:00',
             '2020-12-26T00:00:00', '2021-01-07T00:00:00', '2021-01-19T00:00:00',
             '2021-01-31T00:00:00', '2021-02-12T00:00:00', '2021-02-24T00:00:00',
             '2021-03-08T00:00:00', '2021-03-20T00:00:00', '2021-04-01T00:00:00',
             '2021-04-13T00:00:00', '2021-04-25T00:00:00', '2021-05-07T00:00:00',
             '2021-05-19T00:00:00', '2021-05-31T00:00:00', '2021-06-12T00:00:00',
             '2021-06-24T00:00:00', '2021-07-06T00:00:00', '2021-07-18T00:00:00',
             '2021-07-30T00:00:00', '2021-08-11T00:00:00', '2021-08-23T00:00:00',
             '2021-09-04T00:00:00', '2021-09-16T00:00:00', '2021-09-28T00:00:00',
             '2021-10-10T00:00:00', '2021-10-22T00:00:00', '2021-11-03T00:00:00',
             '2021-11-15T00:00:00', '2021-11-27T00:00:00', '2021-12-09T00:00:00',
             '2021-12-21T00:00:00', '2022-01-02T00:00:00', '2022-01-14T00:00:00',
             '2022-01-26T00:00:00', '2022-02-07T00:00:00', '2022-02-19T00:00:00',
             '2022-03-03T00:00:00', '2022-03-15T00:00:00', '2022-03-27T00:00:00',
             '2022-04-08T00:00:00', '2022-04-20T00:00:00', '2022-05-02T00:00:00',
             '2022-05-14T00:00:00', '2022-05-26T00:00:00', '2022-06-07T00:00:00',
             '2022-06-19T00:00:00', '2022-07-01T00:00:00', '2022-07-13T00:00:00',
             '2022-07-25T00:00:00', '2022-08-06T00:00:00', '2022-08-18T00:00:00',
             '2022-08-30T00:00:00', '2022-09-11T00:00:00', '2022-09-23T00:00:00',
             '2022-10-05T00:00:00', '2022-10-17T00:00:00', '2022-10-29T00:00:00',
             '2022-11-10T00:00:00', '2022-11-22T00:00:00', '2022-12-04T00:00:00',
             '2022-12-16T00:00:00', '2022-12-28T00:00:00', '2023-01-09T00:00:00',
             '2023-01-21T00:00:00', '2023-02-02T00:00:00', '2023-02-14T00:00:00',
             '2023-02-26T00:00:00', '2023-03-10T00:00:00', '2023-03-22T00:00:00',
             '2023-04-03T00:00:00', '2023-04-15T00:00:00', '2023-04-27T00:00:00',
             '2023-05-09T00:00:00', '2023-05-21T00:00:00', '2023-06-02T00:00:00',
             '2023-06-14T00:00:00', '2023-06-26T00:00:00', '2023-07-08T00:00:00',
             '2023-07-20T00:00:00', '2023-08-01T00:00:00', '2023-08-13T00:00:00',
             '2023-08-25T00:00:00', '2023-09-06T00:00:00', '2023-09-18T00:00:00',
             '2023-09-30T00:00:00', '2023-10-12T00:00:00', '2023-10-24T00:00:00',
             '2023-11-05T00:00:00', '2023-11-17T00:00:00', '2023-11-29T00:00:00',
             '2023-12-11T00:00:00', '2023-12-23T00:00:00', '2024-01-04T00:00:00',
             '2024-01-16T00:00:00', '2024-01-28T00:00:00', '2024-02-09T00:00:00',
             '2024-02-21T00:00:00', '2024-03-04T00:00:00', '2024-03-16T00:00:00',
             '2024-03-28T00:00:00', '2024-04-09T00:00:00', '2024-04-21T00:00:00',
             '2024-05-03T00:00:00', '2024-05-15T00:00:00', '2024-05-27T00:00:00',
             '2024-06-08T00:00:00', '2024-06-20T00:00:00', '2024-07-02T00:00:00',
             '2024-07-14T00:00:00', '2024-07-26T00:00:00', '2024-08-07T00:00:00',
             '2024-08-19T00:00:00', '2024-08-31T00:00:00', '2024-09-12T00:00:00',
             '2024-09-24T00:00:00', '2024-10-06T00:00:00', '2024-10-18T00:00:00',
             '2024-10-30T00:00:00', '2024-11-11T00:00:00', '2024-11-23T00:00:00',
             '2024-12-05T00:00:00', '2024-12-17T00:00:00', '2024-12-29T00:00:00'],
            dtype='datetime64[s]')

    • Statistic: (4)

      start	2020-01-01
      end	2024-12-29
      unique	153
      total	153

Filter Pairs date range

If you want to filter pairs using the start and end dates, you can directly slice the pairs just like you would slice a pandas datetime index.

pairs["2022":"2024-03-15"]

         Pairs           
       primary  secondary
0   2022-01-02 2022-01-14
1   2022-01-02 2022-01-26
2   2022-01-02 2022-02-07
3   2022-01-14 2022-01-26
4   2022-01-14 2022-02-07
..         ...        ...
190 2024-01-28 2024-02-21
191 2024-01-28 2024-03-04
192 2024-02-09 2024-02-21
193 2024-02-09 2024-03-04
194 2024-02-21 2024-03-04

[195 rows x 2 columns]

faninsar.Pairs

• pairs=195
• dates=67

• faninsar.Pairs

  primary secondary days 0 2022-01-02 2022-01-14 12 1 2022-01-02 2022-01-26 24 ... ... ... ... 193 2024-02-09 2024-03-04 24 194 2024-02-21 2024-03-04 12

• Indexes: (4)
  • primary
    Acquisition
    2022-01-02 2022-01-02 ... 2024-02-09 2024-02-21

    Acquisition(['2022-01-02', '2022-01-02', '2022-01-02', '2022-01-14',
                 '2022-01-14', '2022-01-14', '2022-01-26', '2022-01-26',
                 '2022-01-26', '2022-02-07',
                 ...
                 '2024-01-04', '2024-01-16', '2024-01-16', '2024-01-16',
                 '2024-01-28', '2024-01-28', '2024-01-28', '2024-02-09',
                 '2024-02-09', '2024-02-21'],
                dtype='datetime64[s]', length=195, freq=None)

    faninsar.Acquisition

    • dates: 195

    • 2022-01-02 2022-01-02 2022-01-02 ... 2024-02-09 2024-02-09 2024-02-21

      array(['2022-01-02T00:00:00', '2022-01-02T00:00:00', '2022-01-02T00:00:00',
             '2022-01-14T00:00:00', '2022-01-14T00:00:00', '2022-01-14T00:00:00',
             '2022-01-26T00:00:00', '2022-01-26T00:00:00', '2022-01-26T00:00:00',
             '2022-02-07T00:00:00', '2022-02-07T00:00:00', '2022-02-07T00:00:00',
             '2022-02-19T00:00:00', '2022-02-19T00:00:00', '2022-02-19T00:00:00',
             '2022-03-03T00:00:00', '2022-03-03T00:00:00', '2022-03-03T00:00:00',
             '2022-03-15T00:00:00', '2022-03-15T00:00:00', '2022-03-15T00:00:00',
             '2022-03-27T00:00:00', '2022-03-27T00:00:00', '2022-03-27T00:00:00',
             '2022-04-08T00:00:00', '2022-04-08T00:00:00', '2022-04-08T00:00:00',
             '2022-04-20T00:00:00', '2022-04-20T00:00:00', '2022-04-20T00:00:00',
             '2022-05-02T00:00:00', '2022-05-02T00:00:00', '2022-05-02T00:00:00',
             '2022-05-14T00:00:00', '2022-05-14T00:00:00', '2022-05-14T00:00:00',
             '2022-05-26T00:00:00', '2022-05-26T00:00:00', '2022-05-26T00:00:00',
             '2022-06-07T00:00:00', '2022-06-07T00:00:00', '2022-06-07T00:00:00',
             '2022-06-19T00:00:00', '2022-06-19T00:00:00', '2022-06-19T00:00:00',
             '2022-07-01T00:00:00', '2022-07-01T00:00:00', '2022-07-01T00:00:00',
             '2022-07-13T00:00:00', '2022-07-13T00:00:00', '2022-07-13T00:00:00',
             '2022-07-25T00:00:00', '2022-07-25T00:00:00', '2022-07-25T00:00:00',
             '2022-08-06T00:00:00', '2022-08-06T00:00:00', '2022-08-06T00:00:00',
             '2022-08-18T00:00:00', '2022-08-18T00:00:00', '2022-08-18T00:00:00',
             '2022-08-30T00:00:00', '2022-08-30T00:00:00', '2022-08-30T00:00:00',
             '2022-09-11T00:00:00', '2022-09-11T00:00:00', '2022-09-11T00:00:00',
             '2022-09-23T00:00:00', '2022-09-23T00:00:00', '2022-09-23T00:00:00',
             '2022-10-05T00:00:00', '2022-10-05T00:00:00', '2022-10-05T00:00:00',
             '2022-10-17T00:00:00', '2022-10-17T00:00:00', '2022-10-17T00:00:00',
             '2022-10-29T00:00:00', '2022-10-29T00:00:00', '2022-10-29T00:00:00',
             '2022-11-10T00:00:00', '2022-11-10T00:00:00', '2022-11-10T00:00:00',
             '2022-11-22T00:00:00', '2022-11-22T00:00:00', '2022-11-22T00:00:00',
             '2022-12-04T00:00:00', '2022-12-04T00:00:00', '2022-12-04T00:00:00',
             '2022-12-16T00:00:00', '2022-12-16T00:00:00', '2022-12-16T00:00:00',
             '2022-12-28T00:00:00', '2022-12-28T00:00:00', '2022-12-28T00:00:00',
             '2023-01-09T00:00:00', '2023-01-09T00:00:00', '2023-01-09T00:00:00',
             '2023-01-21T00:00:00', '2023-01-21T00:00:00', '2023-01-21T00:00:00',
             '2023-02-02T00:00:00', '2023-02-02T00:00:00', '2023-02-02T00:00:00',
             '2023-02-14T00:00:00', '2023-02-14T00:00:00', '2023-02-14T00:00:00',
             '2023-02-26T00:00:00', '2023-02-26T00:00:00', '2023-02-26T00:00:00',
             '2023-03-10T00:00:00', '2023-03-10T00:00:00', '2023-03-10T00:00:00',
             '2023-03-22T00:00:00', '2023-03-22T00:00:00', '2023-03-22T00:00:00',
             '2023-04-03T00:00:00', '2023-04-03T00:00:00', '2023-04-03T00:00:00',
             '2023-04-15T00:00:00', '2023-04-15T00:00:00', '2023-04-15T00:00:00',
             '2023-04-27T00:00:00', '2023-04-27T00:00:00', '2023-04-27T00:00:00',
             '2023-05-09T00:00:00', '2023-05-09T00:00:00', '2023-05-09T00:00:00',
             '2023-05-21T00:00:00', '2023-05-21T00:00:00', '2023-05-21T00:00:00',
             '2023-06-02T00:00:00', '2023-06-02T00:00:00', '2023-06-02T00:00:00',
             '2023-06-14T00:00:00', '2023-06-14T00:00:00', '2023-06-14T00:00:00',
             '2023-06-26T00:00:00', '2023-06-26T00:00:00', '2023-06-26T00:00:00',
             '2023-07-08T00:00:00', '2023-07-08T00:00:00', '2023-07-08T00:00:00',
             '2023-07-20T00:00:00', '2023-07-20T00:00:00', '2023-07-20T00:00:00',
             '2023-08-01T00:00:00', '2023-08-01T00:00:00', '2023-08-01T00:00:00',
             '2023-08-13T00:00:00', '2023-08-13T00:00:00', '2023-08-13T00:00:00',
             '2023-08-25T00:00:00', '2023-08-25T00:00:00', '2023-08-25T00:00:00',
             '2023-09-06T00:00:00', '2023-09-06T00:00:00', '2023-09-06T00:00:00',
             '2023-09-18T00:00:00', '2023-09-18T00:00:00', '2023-09-18T00:00:00',
             '2023-09-30T00:00:00', '2023-09-30T00:00:00', '2023-09-30T00:00:00',
             '2023-10-12T00:00:00', '2023-10-12T00:00:00', '2023-10-12T00:00:00',
             '2023-10-24T00:00:00', '2023-10-24T00:00:00', '2023-10-24T00:00:00',
             '2023-11-05T00:00:00', '2023-11-05T00:00:00', '2023-11-05T00:00:00',
             '2023-11-17T00:00:00', '2023-11-17T00:00:00', '2023-11-17T00:00:00',
             '2023-11-29T00:00:00', '2023-11-29T00:00:00', '2023-11-29T00:00:00',
             '2023-12-11T00:00:00', '2023-12-11T00:00:00', '2023-12-11T00:00:00',
             '2023-12-23T00:00:00', '2023-12-23T00:00:00', '2023-12-23T00:00:00',
             '2024-01-04T00:00:00', '2024-01-04T00:00:00', '2024-01-04T00:00:00',
             '2024-01-16T00:00:00', '2024-01-16T00:00:00', '2024-01-16T00:00:00',
             '2024-01-28T00:00:00', '2024-01-28T00:00:00', '2024-01-28T00:00:00',
             '2024-02-09T00:00:00', '2024-02-09T00:00:00', '2024-02-21T00:00:00'],
            dtype='datetime64[s]')

    • Statistic: (4)

      start	2022-01-02
      end	2024-02-21
      unique	66
      total	195

  • secondary
    Acquisition
    2022-01-14 2022-01-26 ... 2024-03-04 2024-03-04

    Acquisition(['2022-01-14', '2022-01-26', '2022-02-07', '2022-01-26',
                 '2022-02-07', '2022-02-19', '2022-02-07', '2022-02-19',
                 '2022-03-03', '2022-02-19',
                 ...
                 '2024-02-09', '2024-01-28', '2024-02-09', '2024-02-21',
                 '2024-02-09', '2024-02-21', '2024-03-04', '2024-02-21',
                 '2024-03-04', '2024-03-04'],
                dtype='datetime64[s]', length=195, freq=None)

    faninsar.Acquisition

    • dates: 195

    • 2022-01-14 2022-01-26 2022-02-07 ... 2024-02-21 2024-03-04 2024-03-04

      array(['2022-01-14T00:00:00', '2022-01-26T00:00:00', '2022-02-07T00:00:00',
             '2022-01-26T00:00:00', '2022-02-07T00:00:00', '2022-02-19T00:00:00',
             '2022-02-07T00:00:00', '2022-02-19T00:00:00', '2022-03-03T00:00:00',
             '2022-02-19T00:00:00', '2022-03-03T00:00:00', '2022-03-15T00:00:00',
             '2022-03-03T00:00:00', '2022-03-15T00:00:00', '2022-03-27T00:00:00',
             '2022-03-15T00:00:00', '2022-03-27T00:00:00', '2022-04-08T00:00:00',
             '2022-03-27T00:00:00', '2022-04-08T00:00:00', '2022-04-20T00:00:00',
             '2022-04-08T00:00:00', '2022-04-20T00:00:00', '2022-05-02T00:00:00',
             '2022-04-20T00:00:00', '2022-05-02T00:00:00', '2022-05-14T00:00:00',
             '2022-05-02T00:00:00', '2022-05-14T00:00:00', '2022-05-26T00:00:00',
             '2022-05-14T00:00:00', '2022-05-26T00:00:00', '2022-06-07T00:00:00',
             '2022-05-26T00:00:00', '2022-06-07T00:00:00', '2022-06-19T00:00:00',
             '2022-06-07T00:00:00', '2022-06-19T00:00:00', '2022-07-01T00:00:00',
             '2022-06-19T00:00:00', '2022-07-01T00:00:00', '2022-07-13T00:00:00',
             '2022-07-01T00:00:00', '2022-07-13T00:00:00', '2022-07-25T00:00:00',
             '2022-07-13T00:00:00', '2022-07-25T00:00:00', '2022-08-06T00:00:00',
             '2022-07-25T00:00:00', '2022-08-06T00:00:00', '2022-08-18T00:00:00',
             '2022-08-06T00:00:00', '2022-08-18T00:00:00', '2022-08-30T00:00:00',
             '2022-08-18T00:00:00', '2022-08-30T00:00:00', '2022-09-11T00:00:00',
             '2022-08-30T00:00:00', '2022-09-11T00:00:00', '2022-09-23T00:00:00',
             '2022-09-11T00:00:00', '2022-09-23T00:00:00', '2022-10-05T00:00:00',
             '2022-09-23T00:00:00', '2022-10-05T00:00:00', '2022-10-17T00:00:00',
             '2022-10-05T00:00:00', '2022-10-17T00:00:00', '2022-10-29T00:00:00',
             '2022-10-17T00:00:00', '2022-10-29T00:00:00', '2022-11-10T00:00:00',
             '2022-10-29T00:00:00', '2022-11-10T00:00:00', '2022-11-22T00:00:00',
             '2022-11-10T00:00:00', '2022-11-22T00:00:00', '2022-12-04T00:00:00',
             '2022-11-22T00:00:00', '2022-12-04T00:00:00', '2022-12-16T00:00:00',
             '2022-12-04T00:00:00', '2022-12-16T00:00:00', '2022-12-28T00:00:00',
             '2022-12-16T00:00:00', '2022-12-28T00:00:00', '2023-01-09T00:00:00',
             '2022-12-28T00:00:00', '2023-01-09T00:00:00', '2023-01-21T00:00:00',
             '2023-01-09T00:00:00', '2023-01-21T00:00:00', '2023-02-02T00:00:00',
             '2023-01-21T00:00:00', '2023-02-02T00:00:00', '2023-02-14T00:00:00',
             '2023-02-02T00:00:00', '2023-02-14T00:00:00', '2023-02-26T00:00:00',
             '2023-02-14T00:00:00', '2023-02-26T00:00:00', '2023-03-10T00:00:00',
             '2023-02-26T00:00:00', '2023-03-10T00:00:00', '2023-03-22T00:00:00',
             '2023-03-10T00:00:00', '2023-03-22T00:00:00', '2023-04-03T00:00:00',
             '2023-03-22T00:00:00', '2023-04-03T00:00:00', '2023-04-15T00:00:00',
             '2023-04-03T00:00:00', '2023-04-15T00:00:00', '2023-04-27T00:00:00',
             '2023-04-15T00:00:00', '2023-04-27T00:00:00', '2023-05-09T00:00:00',
             '2023-04-27T00:00:00', '2023-05-09T00:00:00', '2023-05-21T00:00:00',
             '2023-05-09T00:00:00', '2023-05-21T00:00:00', '2023-06-02T00:00:00',
             '2023-05-21T00:00:00', '2023-06-02T00:00:00', '2023-06-14T00:00:00',
             '2023-06-02T00:00:00', '2023-06-14T00:00:00', '2023-06-26T00:00:00',
             '2023-06-14T00:00:00', '2023-06-26T00:00:00', '2023-07-08T00:00:00',
             '2023-06-26T00:00:00', '2023-07-08T00:00:00', '2023-07-20T00:00:00',
             '2023-07-08T00:00:00', '2023-07-20T00:00:00', '2023-08-01T00:00:00',
             '2023-07-20T00:00:00', '2023-08-01T00:00:00', '2023-08-13T00:00:00',
             '2023-08-01T00:00:00', '2023-08-13T00:00:00', '2023-08-25T00:00:00',
             '2023-08-13T00:00:00', '2023-08-25T00:00:00', '2023-09-06T00:00:00',
             '2023-08-25T00:00:00', '2023-09-06T00:00:00', '2023-09-18T00:00:00',
             '2023-09-06T00:00:00', '2023-09-18T00:00:00', '2023-09-30T00:00:00',
             '2023-09-18T00:00:00', '2023-09-30T00:00:00', '2023-10-12T00:00:00',
             '2023-09-30T00:00:00', '2023-10-12T00:00:00', '2023-10-24T00:00:00',
             '2023-10-12T00:00:00', '2023-10-24T00:00:00', '2023-11-05T00:00:00',
             '2023-10-24T00:00:00', '2023-11-05T00:00:00', '2023-11-17T00:00:00',
             '2023-11-05T00:00:00', '2023-11-17T00:00:00', '2023-11-29T00:00:00',
             '2023-11-17T00:00:00', '2023-11-29T00:00:00', '2023-12-11T00:00:00',
             '2023-11-29T00:00:00', '2023-12-11T00:00:00', '2023-12-23T00:00:00',
             '2023-12-11T00:00:00', '2023-12-23T00:00:00', '2024-01-04T00:00:00',
             '2023-12-23T00:00:00', '2024-01-04T00:00:00', '2024-01-16T00:00:00',
             '2024-01-04T00:00:00', '2024-01-16T00:00:00', '2024-01-28T00:00:00',
             '2024-01-16T00:00:00', '2024-01-28T00:00:00', '2024-02-09T00:00:00',
             '2024-01-28T00:00:00', '2024-02-09T00:00:00', '2024-02-21T00:00:00',
             '2024-02-09T00:00:00', '2024-02-21T00:00:00', '2024-03-04T00:00:00',
             '2024-02-21T00:00:00', '2024-03-04T00:00:00', '2024-03-04T00:00:00'],
            dtype='datetime64[s]')

    • Statistic: (4)

      start	2022-01-14
      end	2024-03-04
      unique	66
      total	195

  • days
    DaySpan
    12 24 36 12 24 36 12 24 ... 36 12 24 36 12 24 12

    DaySpan([12, 24, 36, 12, 24, 36, 12, 24, 36, 12,
             ...
             36, 12, 24, 36, 12, 24, 36, 12, 24, 12],
            dtype='int32', length=195)

    faninsar.DaySpan

    • days: 195

    • 12 24 36 12 24 36 12 24 36 12 24 ... 24 36 12 24 36 12 24 36 12 24 12

      array([12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36,
             12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36,
             12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36,
             12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36,
             12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36,
             12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36,
             12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36,
             12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36,
             12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36,
             12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36,
             12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 12], dtype=int32)

    • Statistic: (4)

      min	12
      max	36
      unique	3
      total	195

  • dates
    Acquisition
    2022-01-02 2022-01-14 ... 2024-02-21 2024-03-04

    Acquisition(['2022-01-02', '2022-01-14', '2022-01-26', '2022-02-07',
                 '2022-02-19', '2022-03-03', '2022-03-15', '2022-03-27',
                 '2022-04-08', '2022-04-20', '2022-05-02', '2022-05-14',
                 '2022-05-26', '2022-06-07', '2022-06-19', '2022-07-01',
                 '2022-07-13', '2022-07-25', '2022-08-06', '2022-08-18',
                 '2022-08-30', '2022-09-11', '2022-09-23', '2022-10-05',
                 '2022-10-17', '2022-10-29', '2022-11-10', '2022-11-22',
                 '2022-12-04', '2022-12-16', '2022-12-28', '2023-01-09',
                 '2023-01-21', '2023-02-02', '2023-02-14', '2023-02-26',
                 '2023-03-10', '2023-03-22', '2023-04-03', '2023-04-15',
                 '2023-04-27', '2023-05-09', '2023-05-21', '2023-06-02',
                 '2023-06-14', '2023-06-26', '2023-07-08', '2023-07-20',
                 '2023-08-01', '2023-08-13', '2023-08-25', '2023-09-06',
                 '2023-09-18', '2023-09-30', '2023-10-12', '2023-10-24',
                 '2023-11-05', '2023-11-17', '2023-11-29', '2023-12-11',
                 '2023-12-23', '2024-01-04', '2024-01-16', '2024-01-28',
                 '2024-02-09', '2024-02-21', '2024-03-04'],
                dtype='datetime64[s]', freq=None)

    faninsar.Acquisition

    • dates: 67

    • 2022-01-02 2022-01-14 2022-01-26 ... 2024-02-09 2024-02-21 2024-03-04

      array(['2022-01-02T00:00:00', '2022-01-14T00:00:00', '2022-01-26T00:00:00',
             '2022-02-07T00:00:00', '2022-02-19T00:00:00', '2022-03-03T00:00:00',
             '2022-03-15T00:00:00', '2022-03-27T00:00:00', '2022-04-08T00:00:00',
             '2022-04-20T00:00:00', '2022-05-02T00:00:00', '2022-05-14T00:00:00',
             '2022-05-26T00:00:00', '2022-06-07T00:00:00', '2022-06-19T00:00:00',
             '2022-07-01T00:00:00', '2022-07-13T00:00:00', '2022-07-25T00:00:00',
             '2022-08-06T00:00:00', '2022-08-18T00:00:00', '2022-08-30T00:00:00',
             '2022-09-11T00:00:00', '2022-09-23T00:00:00', '2022-10-05T00:00:00',
             '2022-10-17T00:00:00', '2022-10-29T00:00:00', '2022-11-10T00:00:00',
             '2022-11-22T00:00:00', '2022-12-04T00:00:00', '2022-12-16T00:00:00',
             '2022-12-28T00:00:00', '2023-01-09T00:00:00', '2023-01-21T00:00:00',
             '2023-02-02T00:00:00', '2023-02-14T00:00:00', '2023-02-26T00:00:00',
             '2023-03-10T00:00:00', '2023-03-22T00:00:00', '2023-04-03T00:00:00',
             '2023-04-15T00:00:00', '2023-04-27T00:00:00', '2023-05-09T00:00:00',
             '2023-05-21T00:00:00', '2023-06-02T00:00:00', '2023-06-14T00:00:00',
             '2023-06-26T00:00:00', '2023-07-08T00:00:00', '2023-07-20T00:00:00',
             '2023-08-01T00:00:00', '2023-08-13T00:00:00', '2023-08-25T00:00:00',
             '2023-09-06T00:00:00', '2023-09-18T00:00:00', '2023-09-30T00:00:00',
             '2023-10-12T00:00:00', '2023-10-24T00:00:00', '2023-11-05T00:00:00',
             '2023-11-17T00:00:00', '2023-11-29T00:00:00', '2023-12-11T00:00:00',
             '2023-12-23T00:00:00', '2024-01-04T00:00:00', '2024-01-16T00:00:00',
             '2024-01-28T00:00:00', '2024-02-09T00:00:00', '2024-02-21T00:00:00',
             '2024-03-04T00:00:00'], dtype='datetime64[s]')

    • Statistic: (4)

      start	2022-01-02
      end	2024-03-04
      unique	67
      total	67

Filter Pairs by custom condition

For example, if you want to keep only pairs that month of primary dates are in [8,9], you can achieve this by using the following code:

mask = pairs.primary.month.map(lambda x: x in [8, 9])
pairs[mask]

        Pairs           
      primary  secondary
0  2020-08-04 2020-08-16
1  2020-08-04 2020-08-28
2  2020-08-04 2020-09-09
3  2020-08-16 2020-08-28
4  2020-08-16 2020-09-09
..        ...        ...
73 2024-09-12 2024-10-06
74 2024-09-12 2024-10-18
75 2024-09-24 2024-10-06
76 2024-09-24 2024-10-18
77 2024-09-24 2024-10-30

[78 rows x 2 columns]

faninsar.Pairs

• pairs=78
• dates=41

• faninsar.Pairs

  primary secondary days 0 2020-08-04 2020-08-16 12 1 2020-08-04 2020-08-28 24 ... ... ... ... 76 2024-09-24 2024-10-18 24 77 2024-09-24 2024-10-30 36

• Indexes: (4)
  • primary
    Acquisition
    2020-08-04 2020-08-04 ... 2024-09-24 2024-09-24

    Acquisition(['2020-08-04', '2020-08-04', '2020-08-04', '2020-08-16',
                 '2020-08-16', '2020-08-16', '2020-08-28', '2020-08-28',
                 '2020-08-28', '2020-09-09', '2020-09-09', '2020-09-09',
                 '2020-09-21', '2020-09-21', '2020-09-21', '2021-08-11',
                 '2021-08-11', '2021-08-11', '2021-08-23', '2021-08-23',
                 '2021-08-23', '2021-09-04', '2021-09-04', '2021-09-04',
                 '2021-09-16', '2021-09-16', '2021-09-16', '2021-09-28',
                 '2021-09-28', '2021-09-28', '2022-08-06', '2022-08-06',
                 '2022-08-06', '2022-08-18', '2022-08-18', '2022-08-18',
                 '2022-08-30', '2022-08-30', '2022-08-30', '2022-09-11',
                 '2022-09-11', '2022-09-11', '2022-09-23', '2022-09-23',
                 '2022-09-23', '2023-08-01', '2023-08-01', '2023-08-01',
                 '2023-08-13', '2023-08-13', '2023-08-13', '2023-08-25',
                 '2023-08-25', '2023-08-25', '2023-09-06', '2023-09-06',
                 '2023-09-06', '2023-09-18', '2023-09-18', '2023-09-18',
                 '2023-09-30', '2023-09-30', '2023-09-30', '2024-08-07',
                 '2024-08-07', '2024-08-07', '2024-08-19', '2024-08-19',
                 '2024-08-19', '2024-08-31', '2024-08-31', '2024-08-31',
                 '2024-09-12', '2024-09-12', '2024-09-12', '2024-09-24',
                 '2024-09-24', '2024-09-24'],
                dtype='datetime64[s]', freq=None)

    faninsar.Acquisition

    • dates: 78

    • 2020-08-04 2020-08-04 2020-08-04 ... 2024-09-24 2024-09-24 2024-09-24

      array(['2020-08-04T00:00:00', '2020-08-04T00:00:00', '2020-08-04T00:00:00',
             '2020-08-16T00:00:00', '2020-08-16T00:00:00', '2020-08-16T00:00:00',
             '2020-08-28T00:00:00', '2020-08-28T00:00:00', '2020-08-28T00:00:00',
             '2020-09-09T00:00:00', '2020-09-09T00:00:00', '2020-09-09T00:00:00',
             '2020-09-21T00:00:00', '2020-09-21T00:00:00', '2020-09-21T00:00:00',
             '2021-08-11T00:00:00', '2021-08-11T00:00:00', '2021-08-11T00:00:00',
             '2021-08-23T00:00:00', '2021-08-23T00:00:00', '2021-08-23T00:00:00',
             '2021-09-04T00:00:00', '2021-09-04T00:00:00', '2021-09-04T00:00:00',
             '2021-09-16T00:00:00', '2021-09-16T00:00:00', '2021-09-16T00:00:00',
             '2021-09-28T00:00:00', '2021-09-28T00:00:00', '2021-09-28T00:00:00',
             '2022-08-06T00:00:00', '2022-08-06T00:00:00', '2022-08-06T00:00:00',
             '2022-08-18T00:00:00', '2022-08-18T00:00:00', '2022-08-18T00:00:00',
             '2022-08-30T00:00:00', '2022-08-30T00:00:00', '2022-08-30T00:00:00',
             '2022-09-11T00:00:00', '2022-09-11T00:00:00', '2022-09-11T00:00:00',
             '2022-09-23T00:00:00', '2022-09-23T00:00:00', '2022-09-23T00:00:00',
             '2023-08-01T00:00:00', '2023-08-01T00:00:00', '2023-08-01T00:00:00',
             '2023-08-13T00:00:00', '2023-08-13T00:00:00', '2023-08-13T00:00:00',
             '2023-08-25T00:00:00', '2023-08-25T00:00:00', '2023-08-25T00:00:00',
             '2023-09-06T00:00:00', '2023-09-06T00:00:00', '2023-09-06T00:00:00',
             '2023-09-18T00:00:00', '2023-09-18T00:00:00', '2023-09-18T00:00:00',
             '2023-09-30T00:00:00', '2023-09-30T00:00:00', '2023-09-30T00:00:00',
             '2024-08-07T00:00:00', '2024-08-07T00:00:00', '2024-08-07T00:00:00',
             '2024-08-19T00:00:00', '2024-08-19T00:00:00', '2024-08-19T00:00:00',
             '2024-08-31T00:00:00', '2024-08-31T00:00:00', '2024-08-31T00:00:00',
             '2024-09-12T00:00:00', '2024-09-12T00:00:00', '2024-09-12T00:00:00',
             '2024-09-24T00:00:00', '2024-09-24T00:00:00', '2024-09-24T00:00:00'],
            dtype='datetime64[s]')

    • Statistic: (4)

      start	2020-08-04
      end	2024-09-24
      unique	26
      total	78

  • secondary
    Acquisition
    2020-08-16 2020-08-28 ... 2024-10-18 2024-10-30

    Acquisition(['2020-08-16', '2020-08-28', '2020-09-09', '2020-08-28',
                 '2020-09-09', '2020-09-21', '2020-09-09', '2020-09-21',
                 '2020-10-03', '2020-09-21', '2020-10-03', '2020-10-15',
                 '2020-10-03', '2020-10-15', '2020-10-27', '2021-08-23',
                 '2021-09-04', '2021-09-16', '2021-09-04', '2021-09-16',
                 '2021-09-28', '2021-09-16', '2021-09-28', '2021-10-10',
                 '2021-09-28', '2021-10-10', '2021-10-22', '2021-10-10',
                 '2021-10-22', '2021-11-03', '2022-08-18', '2022-08-30',
                 '2022-09-11', '2022-08-30', '2022-09-11', '2022-09-23',
                 '2022-09-11', '2022-09-23', '2022-10-05', '2022-09-23',
                 '2022-10-05', '2022-10-17', '2022-10-05', '2022-10-17',
                 '2022-10-29', '2023-08-13', '2023-08-25', '2023-09-06',
                 '2023-08-25', '2023-09-06', '2023-09-18', '2023-09-06',
                 '2023-09-18', '2023-09-30', '2023-09-18', '2023-09-30',
                 '2023-10-12', '2023-09-30', '2023-10-12', '2023-10-24',
                 '2023-10-12', '2023-10-24', '2023-11-05', '2024-08-19',
                 '2024-08-31', '2024-09-12', '2024-08-31', '2024-09-12',
                 '2024-09-24', '2024-09-12', '2024-09-24', '2024-10-06',
                 '2024-09-24', '2024-10-06', '2024-10-18', '2024-10-06',
                 '2024-10-18', '2024-10-30'],
                dtype='datetime64[s]', freq=None)

    faninsar.Acquisition

    • dates: 78

    • 2020-08-16 2020-08-28 2020-09-09 ... 2024-10-06 2024-10-18 2024-10-30

      array(['2020-08-16T00:00:00', '2020-08-28T00:00:00', '2020-09-09T00:00:00',
             '2020-08-28T00:00:00', '2020-09-09T00:00:00', '2020-09-21T00:00:00',
             '2020-09-09T00:00:00', '2020-09-21T00:00:00', '2020-10-03T00:00:00',
             '2020-09-21T00:00:00', '2020-10-03T00:00:00', '2020-10-15T00:00:00',
             '2020-10-03T00:00:00', '2020-10-15T00:00:00', '2020-10-27T00:00:00',
             '2021-08-23T00:00:00', '2021-09-04T00:00:00', '2021-09-16T00:00:00',
             '2021-09-04T00:00:00', '2021-09-16T00:00:00', '2021-09-28T00:00:00',
             '2021-09-16T00:00:00', '2021-09-28T00:00:00', '2021-10-10T00:00:00',
             '2021-09-28T00:00:00', '2021-10-10T00:00:00', '2021-10-22T00:00:00',
             '2021-10-10T00:00:00', '2021-10-22T00:00:00', '2021-11-03T00:00:00',
             '2022-08-18T00:00:00', '2022-08-30T00:00:00', '2022-09-11T00:00:00',
             '2022-08-30T00:00:00', '2022-09-11T00:00:00', '2022-09-23T00:00:00',
             '2022-09-11T00:00:00', '2022-09-23T00:00:00', '2022-10-05T00:00:00',
             '2022-09-23T00:00:00', '2022-10-05T00:00:00', '2022-10-17T00:00:00',
             '2022-10-05T00:00:00', '2022-10-17T00:00:00', '2022-10-29T00:00:00',
             '2023-08-13T00:00:00', '2023-08-25T00:00:00', '2023-09-06T00:00:00',
             '2023-08-25T00:00:00', '2023-09-06T00:00:00', '2023-09-18T00:00:00',
             '2023-09-06T00:00:00', '2023-09-18T00:00:00', '2023-09-30T00:00:00',
             '2023-09-18T00:00:00', '2023-09-30T00:00:00', '2023-10-12T00:00:00',
             '2023-09-30T00:00:00', '2023-10-12T00:00:00', '2023-10-24T00:00:00',
             '2023-10-12T00:00:00', '2023-10-24T00:00:00', '2023-11-05T00:00:00',
             '2024-08-19T00:00:00', '2024-08-31T00:00:00', '2024-09-12T00:00:00',
             '2024-08-31T00:00:00', '2024-09-12T00:00:00', '2024-09-24T00:00:00',
             '2024-09-12T00:00:00', '2024-09-24T00:00:00', '2024-10-06T00:00:00',
             '2024-09-24T00:00:00', '2024-10-06T00:00:00', '2024-10-18T00:00:00',
             '2024-10-06T00:00:00', '2024-10-18T00:00:00', '2024-10-30T00:00:00'],
            dtype='datetime64[s]')

    • Statistic: (4)

      start	2020-08-16
      end	2024-10-30
      unique	36
      total	78

  • days
    DaySpan
    12 24 36 12 24 36 12 24 ... 36 12 24 36 12 24 36

    DaySpan([12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24,
             36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12,
             24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36,
             12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24,
             36, 12, 24, 36, 12, 24, 36, 12, 24, 36],
            dtype='int32')

    faninsar.DaySpan

    • days: 78

    • 12 24 36 12 24 36 12 24 36 12 24 ... 24 36 12 24 36 12 24 36 12 24 36

      array([12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36,
             12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36,
             12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36,
             12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36, 12, 24, 36,
             12, 24, 36, 12, 24, 36], dtype=int32)

    • Statistic: (4)

      min	12
      max	36
      unique	3
      total	78

  • dates
    Acquisition
    2020-08-04 2020-08-16 ... 2024-10-18 2024-10-30

    Acquisition(['2020-08-04', '2020-08-16', '2020-08-28', '2020-09-09',
                 '2020-09-21', '2020-10-03', '2020-10-15', '2020-10-27',
                 '2021-08-11', '2021-08-23', '2021-09-04', '2021-09-16',
                 '2021-09-28', '2021-10-10', '2021-10-22', '2021-11-03',
                 '2022-08-06', '2022-08-18', '2022-08-30', '2022-09-11',
                 '2022-09-23', '2022-10-05', '2022-10-17', '2022-10-29',
                 '2023-08-01', '2023-08-13', '2023-08-25', '2023-09-06',
                 '2023-09-18', '2023-09-30', '2023-10-12', '2023-10-24',
                 '2023-11-05', '2024-08-07', '2024-08-19', '2024-08-31',
                 '2024-09-12', '2024-09-24', '2024-10-06', '2024-10-18',
                 '2024-10-30'],
                dtype='datetime64[s]', freq=None)

    faninsar.Acquisition

    • dates: 41

    • 2020-08-04 2020-08-16 2020-08-28 ... 2024-10-06 2024-10-18 2024-10-30

      array(['2020-08-04T00:00:00', '2020-08-16T00:00:00', '2020-08-28T00:00:00',
             '2020-09-09T00:00:00', '2020-09-21T00:00:00', '2020-10-03T00:00:00',
             '2020-10-15T00:00:00', '2020-10-27T00:00:00', '2021-08-11T00:00:00',
             '2021-08-23T00:00:00', '2021-09-04T00:00:00', '2021-09-16T00:00:00',
             '2021-09-28T00:00:00', '2021-10-10T00:00:00', '2021-10-22T00:00:00',
             '2021-11-03T00:00:00', '2022-08-06T00:00:00', '2022-08-18T00:00:00',
             '2022-08-30T00:00:00', '2022-09-11T00:00:00', '2022-09-23T00:00:00',
             '2022-10-05T00:00:00', '2022-10-17T00:00:00', '2022-10-29T00:00:00',
             '2023-08-01T00:00:00', '2023-08-13T00:00:00', '2023-08-25T00:00:00',
             '2023-09-06T00:00:00', '2023-09-18T00:00:00', '2023-09-30T00:00:00',
             '2023-10-12T00:00:00', '2023-10-24T00:00:00', '2023-11-05T00:00:00',
             '2024-08-07T00:00:00', '2024-08-19T00:00:00', '2024-08-31T00:00:00',
             '2024-09-12T00:00:00', '2024-09-24T00:00:00', '2024-10-06T00:00:00',
             '2024-10-18T00:00:00', '2024-10-30T00:00:00'], dtype='datetime64[s]')

    • Statistic: (4)

      start	2020-08-04
      end	2024-10-30
      unique	41
      total	41