Setup Environment

Set up environment for data processing and input credentials

Get Country Codes for Analysis Countries

The countries for analysis are :

  • Burkina Faso,
  • Cayman Islands,
  • Morocco,
  • Senegal.

Hint: check out the rest countries api.

region subregion countryName flag countryCode lat lon
0 Africa Western Africa Burkina Faso 🇧🇫 BF 13.00 -2.00
1 Americas Caribbean Cayman Islands 🇰🇾 KY 19.50 -80.50
2 Africa Northern Africa Morocco 🇲🇦 MA 32.00 -5.00
3 Africa Western Africa Senegal 🇸🇳 SN 14.00 -14.00

Display These Locations on A Map

Identify Parties

Extract parties with an account address in the identified country code. Noting the limit is 10,000 per party search - so you may need to use the x-swarmee-after-party-id field from the response header in subsequent requests to retrieve all of the parties with account addresses linked to the identified country codes.

region subregion flag country countryCode partyHitCount
0 Africa Western Africa 🇧🇫 Burkina Faso BF 636
1 Americas Caribbean 🇰🇾 Cayman Islands KY 5883
2 Africa Northern Africa 🇲🇦 Morocco MA 2970
3 Africa Western Africa 🇸🇳 Senegal SN 991

Extract Reports for Identified Parties

Noting that they need to be extracted in batches, due to the limit on partyIds that can be submitted in a transaction report API request.

region subregion flag country countryCode partyHitCount reportCount totalAmount
0 Africa Western Africa 🇧🇫 Burkina Faso BF 636 971 534,575.02
1 Americas Caribbean 🇰🇾 Cayman Islands KY 5883 8938 6,710,487.15
2 Africa Northern Africa 🇲🇦 Morocco MA 2970 4553 3,735,057.91
3 Africa Western Africa 🇸🇳 Senegal SN 991 1579 1,088,194.82

Run through dataframe and based on the role and direction find the top 10 domestic reporters with exposure to these countries.

reporter reportCount totalAmount
5 CBA 632 426,729.17
7 NAB 512 323,399.62
3 MET 479 521,330.29
9 BSA 472 307,209.92
15 SGP 433 232,235.76
12 BML 428 263,545.30
16 HBA 421 221,853.95
13 ANZ 419 249,951.20
1 STG 412 681,930.27
17 CTI 387 217,912.42

Competition Unstructured Extension

Based on the transaction reporting identified for; Burkina Faso, the Cayman Islands, Morocco, and Senegal identify any significant shifts in reporting of transactions over the period. Identify one potential cause of the change in reporting.