standardise to CAMV4 structure

View or edit on GitHub

This page is synchronized from trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/standardise_to_CAMV4_structure.ipynb. Last modified on 2026-06-21 06:35 CEST by GitHub Actions. Please view or edit the original file there; changes should be reflected here after a midnight build (CET time), or manually triggering it with a GitHub action (link).

import pandas as pd

df = pd.read_csv("/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/2024_civ_coops_with_geocodes.csv")
cam = pd.read_csv("/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/out/CAM_coopyear.csv", sep=';')
/var/folders/3r/r9b5rj5s3pb069rsg5zh_1640000gn/T/ipykernel_47536/1129617930.py:4: DtypeWarning: Columns (6,8,9,10,11,19,23,24,27,31,32,34) have mixed types. Specify dtype option on import or set low_memory=False.
  cam = pd.read_csv("/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/out/CAM_coopyear.csv", sep=';')

remove need for DISCL_SUPPLIER_ABRVNAME_CLEANED, DISCL_SUPPLIER_FULLNAME_CLEANED, but check as you go that correct names are in correct place

df
DISCL_TRADER_NAME DISCL_SUPPLIER_ABRVNAME DISCL_AREA_NAME DISCL_CERTIFICATION_NAME DISCL_NUMBER_FARMERS DISCL_LONGITUDE DISCL_LATITUDE DISCL_COUNTRY_NAME DISCL_YEAR COMPANY ... DISTRICT_GEOCODE CAM_BUYERS IS_CAM_V3 IS_JRC JRC_BUYER_ID DISCL_SUPPLIER_TYPE DISCL_SUPPLIER_ABRVNAME_CLEANED DISCL_SUPPLIER_FULLNAME_CLEANED CLEANED_RESIDUAL_NAME DISCL_AREA_NAME_CLEAN
0 BARRY CALLEBAUT AG NaN AGNIBILEKRO NaN NaN -3.204332 7.135274 IVORY_COAST NaN LINDT SPRUNGLI ... CI-3.1.2_1 NaN NaN NaN NaN COOPERATIVE SOCIÉTÉ AFRICAINE DE CACAO SOCIETE COOPERATIVE BENKADI DE SIAKAKRO NaN AGNIBILEKRO
1 BARRY CALLEBAUT AG NaN ABENGOUROU NaN NaN -3.494930 6.720262 IVORY_COAST NaN LINDT SPRUNGLI ... CI-3.1.1_1 NaN NaN NaN NaN COOPERATIVE SOCIÉTÉ AFRICAINE DE CACAO SOCIETE COOPERATIVE ANOUANZE DES PRODUCTEURS D... NaN ABENGOUROU
2 BARRY CALLEBAUT AG NaN BONGOUANOU NaN NaN NaN NaN IVORY_COAST NaN LINDT SPRUNGLI ... CI-6.3.2_1 NaN NaN NaN NaN COOPERATIVE SOCIÉTÉ AFRICAINE DE CACAO SOCIETE COOPERATIVE AGRICOLE AHUANOU D'ARRAH NaN BONGOUANOU
3 BARRY CALLEBAUT AG NaN BANGOLO NaN NaN -7.455261 5.876620 IVORY_COAST NaN LINDT SPRUNGLI ... CI-8.2.1_1 NaN NaN NaN NaN COOPERATIVE SOCIÉTÉ AFRICAINE DE CACAO COOPERATIVE AGRICOLE TELIN NaN BANGOLO
4 BARRY CALLEBAUT AG NaN DIVO NaN NaN NaN NaN IVORY_COAST NaN LINDT SPRUNGLI ... CI-5.2.1_1 NaN NaN NaN NaN COOPERATIVE SOCIÉTÉ AFRICAINE DE CACAO COOPERATIVE AGRICOLE IMAAH, COOPERATIVE SIMPLI... NaN DIVO
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
1742 NaN SCOOPANAB COOP – CA BANGOLO NaN NaN -6.084600 4.956798 IVORY_COAST 2024.0 ECOM ... CI-8.2.1_1 NaN NaN NaN NaN COOPERATIVE COOP CA AB COOPERATIVE AGRICOLE NOUVELLE ALLIANCE DE BANGOLO SCOOPANAB COOP – CA BANGOLO
1743 NaN CAFUGO COOP CA SASSANDRA NaN NaN -6.086585 4.957198 IVORY_COAST 2024.0 ECOM ... CI-2.1.2_1 NaN NaN NaN NaN COOPERATIVE CAFUGO COOPÉRATIVE AGRICOLE DES FRÈRES UNIS DE GOBROKO CAFUGO SASSANDRA
1744 NaN COOP-CCAPUO DUEKOUE NaN NaN -7.362460 6.747380 IVORY_COAST 2024.0 ECOM ... CI-8.2.2_1 NaN NaN NaN NaN COOPERATIVE COOP-CA-CAPUO Cooperative avec Conseil\nd'Administration des... COOP-CCAPUO DUEKOUE
1745 NaN COOP_CA_UDAN DANANE NaN NaN -8.150575 7.252397 IVORY_COAST 2024.0 ECOM ... CI-8.3.2_1 NaN NaN NaN NaN COOPERATIVE COOP-CA-UDAN Societe Cooperative Avec Conseil D’administrat... COOP_CA_UDAN DANANE
1746 NaN YEBOYOKON SCOOPS DIVO NaN NaN NaN NaN IVORY_COAST 2024.0 ECOM ... CI-5.2.1_1 NaN NaN NaN NaN COOPERATIVE YEBOYOKON SOCIETE COOPERATIVE AGRICOLE YEBOYOKON DE DAIR... YEBOYOKON DIVO

1747 rows × 24 columns

df.columns
Index(['DISCL_TRADER_NAME', 'DISCL_SUPPLIER_ABRVNAME', 'DISCL_AREA_NAME',
       'DISCL_CERTIFICATION_NAME', 'DISCL_NUMBER_FARMERS', 'DISCL_LONGITUDE',
       'DISCL_LATITUDE', 'DISCL_COUNTRY_NAME', 'DISCL_YEAR', 'COMPANY',
       'DISCL_SUPPLIER_FULLNAME', 'DISCL_VOLUMES', 'DISCL_VOLUMES_UNIT',
       'DISCL_CERTIFICATION_PCT', 'DISTRICT_GEOCODE', 'CAM_BUYERS',
       'IS_CAM_V3', 'IS_JRC', 'JRC_BUYER_ID', 'DISCL_SUPPLIER_TYPE',
       'DISCL_SUPPLIER_ABRVNAME_CLEANED', 'DISCL_SUPPLIER_FULLNAME_CLEANED',
       'CLEANED_RESIDUAL_NAME', 'DISCL_AREA_NAME_CLEAN'],
      dtype='object')
cam.columns
Index(['COOP_ID', 'YEAR', 'SUPPLIER_ABRVNAME', 'SUPPLIER_FULLNAME', 'LATITUDE',
       'LONGITUDE', 'DISTRICT_NAME', 'DISTRICT_GEOCODE', 'DISCLOSURE_SOURCES',
       'TRADER_NAMES', 'CERTIFIED', 'CERTIFICATIONS',
       'TOTAL_FARMERS_NONTRADER', 'TOTAL_FARMERS_TRADER', 'TOTAL_FARMERS',
       'DISCL_COUNTRY_NAME', 'DISCL_AREA_NAME', 'DISCL_SUPPLIER_ABRVNAME',
       'DISCL_SUPPLIER_FULLNAME', 'DISCL_SUPPLIER_TYPE', 'DISCL_LONGITUDE',
       'DISCL_LATITUDE', 'DISCL_VOLUMES', 'DISCL_VOLUMES_UNIT',
       'DISCL_CERTIFICATION_NAME', 'DISCL_CERTIFICATION_PCT',
       'SIMPLIF_ABRVNAME', 'CCTN_COOP_ID', 'IS_ALL_CAM_V3', 'IS_ANY_CAM_V3',
       'NB_FARMERS_COMPANY_YEAR', '!NOT_RFA', 'unique_rfa_link',
       'TOTAL_FARMERS_RFA', 'LVL_4_NAME', 'REPEATED_FROM_PAST_YEAR'],
      dtype='object')
cam.head()
COOP_ID YEAR SUPPLIER_ABRVNAME SUPPLIER_FULLNAME LATITUDE LONGITUDE DISTRICT_NAME DISTRICT_GEOCODE DISCLOSURE_SOURCES TRADER_NAMES ... SIMPLIF_ABRVNAME CCTN_COOP_ID IS_ALL_CAM_V3 IS_ANY_CAM_V3 NB_FARMERS_COMPANY_YEAR !NOT_RFA unique_rfa_link TOTAL_FARMERS_RFA LVL_4_NAME REPEATED_FROM_PAST_YEAR
0 1 2019 0UBE COOPERATIVE AGRICOLE OUBE DE BANOUFLA 6.878 -6.450 DALOA CI-9.1.1_1 NaN NaN ... 0UBE 0UBE_-6.4_6.9_COOPERATIVE AGRICOLE OUBE DE BAN... True True NaN NaN NaN NaN DALOA False
1 2 2019 2 AD 2 AD 6.720 -3.503 ABENGOUROU CI-3.1.1_1 NaN NaN ... 2 AD 2 AD_-3.5_6.7_2 AD True True NaN NaN NaN NaN ABENGOUROU False
2 3 2019 2A SCCOPS COOPERATIVE LES AGRICULTEURS D'AKOUPE 5.477 -4.151 ABIDJAN CI-1.1.1_1 NaN NaN ... 2A SCCOPS 2A SCCOPS_-4.2_5.5_COOPERATIVE LES AGRICULTEUR... True True NaN NaN NaN NaN ABIDJAN False
3 4 2019 2AP COOPERATIVE AGRICOLE ANOUANZE DE PARA NaN NaN NaN NaN NaN NaN ... 2AP 2AP_NA_NA_COOPERATIVE AGRICOLE ANOUANZE DE PARA True True NaN NaN NaN NaN NaN False
4 5 2019 2A 2A 5.480 -4.155 ABIDJAN CI-1.1.1_1 NaN NaN ... 2A 2A_-4.2_5.5_2A True True NaN NaN NaN NaN ABIDJAN False

5 rows × 36 columns

renaming 2024 coop column names to match CAM_V4

if the disclosing source (company) is a trader then put it there

import pandas as pd
import numpy as np

# 1. Make a list of disclosing traders
traders = [
    'ECOM', 
    'CARGILL', 
    'OFI',
    'TOUTON', 
    'ETG', 
    'BARRY CALLEBAUT AG', 
    'CEMOI VIA TRANSPARANCE COCOA'
]

# 2. Iterate through traders and update
for trader in traders:
    # Create a mask for rows where:
    # A) The trader string is found in the COMPANY column
    # B) The DISCL_TRADER_NAME column is currently empty (NaN)

    # Note: case=False makes it case-insensitive (e.g., finds "Cargill" for "CARGILL")
    # na=False ensures NaN values in 'COMPANY' don't crash the script
    mask = (df['COMPANY'].str.contains(trader, case=False, na=False)) & (df['DISCL_TRADER_NAME'].isna())

    # Apply the trader name to those specific rows
    df.loc[mask, 'DISCL_TRADER_NAME'] = trader

# Check the results
print(df[['COMPANY', 'DISCL_TRADER_NAME']].head())
          COMPANY   DISCL_TRADER_NAME
0  LINDT SPRUNGLI  BARRY CALLEBAUT AG
1  LINDT SPRUNGLI  BARRY CALLEBAUT AG
2  LINDT SPRUNGLI  BARRY CALLEBAUT AG
3  LINDT SPRUNGLI  BARRY CALLEBAUT AG
4  LINDT SPRUNGLI  BARRY CALLEBAUT AG
# Dictionary mapping the "messy" names to the "clean" names
replacements = {
    'BARRY CALLEBAUT AG': 'BARRY CALLEBAUT',
    'BARRY CALLEBEAUT': 'BARRY CALLEBAUT',      # Fixing the typo found in your list
    'ECOM AGROTRADE LTD': 'ECOM',
    'CEMOI VIA TRANSPARANCE COCOA': 'CEMOI',
    'OLAM INTERNATIONAL LIMITED': 'OFI',
    'BLOMMER CHOCOLATE COMPANY': 'BLOMMER'        
}

# Apply the replacements
df['DISCL_TRADER_NAME'] = df['DISCL_TRADER_NAME'].replace(replacements)

# Check the results
print(df['DISCL_TRADER_NAME'].unique())
['BARRY CALLEBAUT' 'BLOMMER' 'ECOM' 'OFI' 'ETG' 'CARGILL' 'FARMSTRONG'
 'GCB' 'JB COCOA' 'SO B GREEN' 'SUCDEN' 'TOUTON' nan 'COCOASOURCE'
 'FILDISI' 'CEMOI' 'SUSCOM']
#df.to_csv('/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/2024_civ_coops_with_geocodes.csv', index=False)
df
DISCL_TRADER_NAME DISCL_SUPPLIER_ABRVNAME DISCL_AREA_NAME DISCL_CERTIFICATION_NAME DISCL_NUMBER_FARMERS DISCL_LONGITUDE DISCL_LATITUDE DISCL_COUNTRY_NAME DISCL_YEAR COMPANY ... DISTRICT_GEOCODE CAM_BUYERS IS_CAM_V3 IS_JRC JRC_BUYER_ID DISCL_SUPPLIER_TYPE DISCL_SUPPLIER_ABRVNAME_CLEANED DISCL_SUPPLIER_FULLNAME_CLEANED CLEANED_RESIDUAL_NAME DISCL_AREA_NAME_CLEAN
0 BARRY CALLEBAUT NaN AGNIBILEKRO NaN NaN -3.204332 7.135274 IVORY_COAST NaN LINDT SPRUNGLI ... CI-3.1.2_1 NaN NaN NaN NaN COOPERATIVE SOCIÉTÉ AFRICAINE DE CACAO SOCIETE COOPERATIVE BENKADI DE SIAKAKRO NaN AGNIBILEKRO
1 BARRY CALLEBAUT NaN ABENGOUROU NaN NaN -3.494930 6.720262 IVORY_COAST NaN LINDT SPRUNGLI ... CI-3.1.1_1 NaN NaN NaN NaN COOPERATIVE SOCIÉTÉ AFRICAINE DE CACAO SOCIETE COOPERATIVE ANOUANZE DES PRODUCTEURS D... NaN ABENGOUROU
2 BARRY CALLEBAUT NaN BONGOUANOU NaN NaN NaN NaN IVORY_COAST NaN LINDT SPRUNGLI ... CI-6.3.2_1 NaN NaN NaN NaN COOPERATIVE SOCIÉTÉ AFRICAINE DE CACAO SOCIETE COOPERATIVE AGRICOLE AHUANOU D'ARRAH NaN BONGOUANOU
3 BARRY CALLEBAUT NaN BANGOLO NaN NaN -7.455261 5.876620 IVORY_COAST NaN LINDT SPRUNGLI ... CI-8.2.1_1 NaN NaN NaN NaN COOPERATIVE SOCIÉTÉ AFRICAINE DE CACAO COOPERATIVE AGRICOLE TELIN NaN BANGOLO
4 BARRY CALLEBAUT NaN DIVO NaN NaN NaN NaN IVORY_COAST NaN LINDT SPRUNGLI ... CI-5.2.1_1 NaN NaN NaN NaN COOPERATIVE SOCIÉTÉ AFRICAINE DE CACAO COOPERATIVE AGRICOLE IMAAH, COOPERATIVE SIMPLI... NaN DIVO
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
1742 ECOM SCOOPANAB COOP – CA BANGOLO NaN NaN -6.084600 4.956798 IVORY_COAST 2024.0 ECOM ... CI-8.2.1_1 NaN NaN NaN NaN COOPERATIVE COOP CA AB COOPERATIVE AGRICOLE NOUVELLE ALLIANCE DE BANGOLO SCOOPANAB COOP – CA BANGOLO
1743 ECOM CAFUGO COOP CA SASSANDRA NaN NaN -6.086585 4.957198 IVORY_COAST 2024.0 ECOM ... CI-2.1.2_1 NaN NaN NaN NaN COOPERATIVE CAFUGO COOPÉRATIVE AGRICOLE DES FRÈRES UNIS DE GOBROKO CAFUGO SASSANDRA
1744 ECOM COOP-CCAPUO DUEKOUE NaN NaN -7.362460 6.747380 IVORY_COAST 2024.0 ECOM ... CI-8.2.2_1 NaN NaN NaN NaN COOPERATIVE COOP-CA-CAPUO Cooperative avec Conseil\nd'Administration des... COOP-CCAPUO DUEKOUE
1745 ECOM COOP_CA_UDAN DANANE NaN NaN -8.150575 7.252397 IVORY_COAST 2024.0 ECOM ... CI-8.3.2_1 NaN NaN NaN NaN COOPERATIVE COOP-CA-UDAN Societe Cooperative Avec Conseil D’administrat... COOP_CA_UDAN DANANE
1746 ECOM YEBOYOKON SCOOPS DIVO NaN NaN NaN NaN IVORY_COAST 2024.0 ECOM ... CI-5.2.1_1 NaN NaN NaN NaN COOPERATIVE YEBOYOKON SOCIETE COOPERATIVE AGRICOLE YEBOYOKON DE DAIR... YEBOYOKON DIVO

1747 rows × 24 columns

mars, unilver, puratos, ferrero are missing trader names

# add in 2024 updated coops from mars

mars_24 = pd.read_csv("/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/mars_2024_coops.csv")
mars_24.head()
DISCL_COUNTRY_NAME DISCL_SUPPLIER_ABRVNAME DISCL_YEAR COMPANY
0 IVORY_COAST SICOPAG COOP CA 2024.0 MARS
1 IVORY_COAST COOPAPIG 2024.0 MARS
2 IVORY_COAST SCOOPS FG 2024.0 MARS
3 IVORY_COAST CPR CANAAN 2024.0 MARS
4 IVORY_COAST CAVA 2024.0 MARS
df[df.COMPANY=="MARS"].head()
DISCL_TRADER_NAME DISCL_SUPPLIER_ABRVNAME DISCL_AREA_NAME DISCL_CERTIFICATION_NAME DISCL_NUMBER_FARMERS DISCL_LONGITUDE DISCL_LATITUDE DISCL_COUNTRY_NAME DISCL_YEAR COMPANY ... DISTRICT_GEOCODE CAM_BUYERS IS_CAM_V3 IS_JRC JRC_BUYER_ID DISCL_SUPPLIER_TYPE DISCL_SUPPLIER_ABRVNAME_CLEANED DISCL_SUPPLIER_FULLNAME_CLEANED CLEANED_RESIDUAL_NAME DISCL_AREA_NAME_CLEAN
1562 NaN ECAM SCOOPS YAMOUSSOUKRO NaN NaN -5.271064 6.818539 IVORY_COAST 2023.0 MARS ... CI-13.1.2_1 NaN NaN NaN NaN COOPERATIVE ECAM NaN ECAM YAMOUSSOUKRO
1563 NaN SOCAG COOP-CA SOUBRE NaN NaN -6.068990 5.692900 IVORY_COAST 2023.0 MARS ... CI-2.2.5_1 NaN NaN NaN NaN COOPERATIVE SOCAG COOP-CA NaN SOCAG SOUBRE
1564 NaN SOCOOPALAO COOP-CA FRESCO NaN NaN -5.584398 5.106291 IVORY_COAST 2023.0 MARS ... CI-2.1.1_1 NaN NaN NaN NaN COOPERATIVE SOCOOPALAO NaN SOCOOPALAO FRESCO
1565 NaN BENKADI COOPS MEAGUI NaN NaN -6.802379 5.821985 IVORY_COAST 2023.0 MARS ... CI-2.2.3_1 NaN NaN NaN NaN COOPERATIVE BENKADI COOPS NaN BENKADI COOPS MEAGUI
1566 NaN COOPAC ALEPE NaN NaN NaN NaN IVORY_COAST 2023.0 MARS ... CI-7.3.3_1 NaN NaN NaN NaN COOPERATIVE COOPACA NaN COOPAC ALEPE

5 rows × 24 columns

# --- 1. Fix Data Types Before Merging ---

# Ensure Year is a number (float) in both dataframes
df['DISCL_YEAR'] = pd.to_numeric(df['DISCL_YEAR'], errors='coerce')
mars_24['DISCL_YEAR'] = pd.to_numeric(mars_24['DISCL_YEAR'], errors='coerce')

# Ensure text columns are treated as Objects (strings) in both
# This fixes the issue where a column of NaNs (floats) tries to merge with a column of names (strings)
text_keys = ['DISCL_SUPPLIER_ABRVNAME', 'DISCL_COUNTRY_NAME', 'COMPANY']

for col in text_keys:
    df[col] = df[col].astype(object)
    mars_24[col] = mars_24[col].astype(object)

# --- 2. Run the Filtering Code ---

keys = ['DISCL_SUPPLIER_ABRVNAME', 'DISCL_COUNTRY_NAME', 'DISCL_YEAR', 'COMPANY']
existing_keys = df[keys].drop_duplicates()

merged = mars_24.merge(existing_keys, on=keys, how='left', indicator=True)
new_rows = merged[merged['_merge'] == 'left_only'].drop(columns=['_merge'])

civ_seipcs = pd.concat([df, new_rows], ignore_index=True)

print(f"Added {len(new_rows)} new rows.")
Added 152 new rows.
#df.to_csv('/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/2024_civ_coops_with_geocodes.csv', index=False)
len(df)
1892
len(df.drop_duplicates(subset=['DISCL_SUPPLIER_ABRVNAME', 'DISCL_SUPPLIER_ABRVNAME_CLEANED', 'COMPANY', 'DISCL_TRADER_NAME', 'DISCL_SUPPLIER_FULLNAME_CLEANED', 'DISCL_LONGITUDE','DISCL_LATITUDE']))
1803
# Define the columns you are checking
subset_cols = ['DISCL_SUPPLIER_ABRVNAME', 'DISCL_SUPPLIER_ABRVNAME_CLEANED', 'COMPANY', 'DISCL_TRADER_NAME', 'DISCL_SUPPLIER_FULLNAME_CLEANED', 'DISCL_LONGITUDE','DISCL_LATITUDE']

# distinct_mask will be True for rows that are duplicates (the ones getting dropped)
# keep='first' is the default, meaning it marks the first occurrence as False (keep) and subsequent ones as True (drop)
dropped_rows = df[df.duplicated(subset=subset_cols, keep='first')]

print(f"Number of rows dropped: {len(dropped_rows)}")
display(dropped_rows)
Number of rows dropped: 89
DISCL_TRADER_NAME DISCL_SUPPLIER_ABRVNAME DISCL_AREA_NAME DISCL_CERTIFICATION_NAME DISCL_NUMBER_FARMERS DISCL_LONGITUDE DISCL_LATITUDE DISCL_COUNTRY_NAME DISCL_YEAR COMPANY ... DISTRICT_GEOCODE CAM_BUYERS IS_CAM_V3 IS_JRC JRC_BUYER_ID DISCL_SUPPLIER_TYPE DISCL_SUPPLIER_ABRVNAME_CLEANED DISCL_SUPPLIER_FULLNAME_CLEANED CLEANED_RESIDUAL_NAME DISCL_AREA_NAME_CLEAN
22 BLOMMER NaN SOUBRE NaN NaN NaN NaN IVORY_COAST NaN LINDT SPRUNGLI ... CI-2.2.5_1 NaN NaN NaN NaN NaN SUCDEN CÔTE D'IVOIRE Centre d'Achat Hassan Kamel Ftouni NaN SOUBRE
23 BLOMMER NaN SOUBRE NaN NaN NaN NaN IVORY_COAST NaN LINDT SPRUNGLI ... CI-2.2.5_1 NaN NaN NaN NaN NaN SUCDEN CÔTE D'IVOIRE Centre d'Achat Hassan Kamel Ftouni NaN SOUBRE
1169 OFI SUD-OUEST SOUBRE NaN NaN NaN NaN IVORY_COAST 2024.0 OFI ... CI-2.2.5_1 NaN NaN NaN NaN COOPERATIVE COOPASM NaN SCOOPS COOP.A.SAM SOUBRE
1180 OFI CENTRE-OUEST MAN NaN NaN -7.499681 6.549998 IVORY_COAST 2024.0 OFI ... CI-8.3.3_1 NaN NaN NaN NaN COOPERATIVE CNAD NaN SCOOPS SCAG MAN
1245 OFI CENTRE-OUEST DALOA NaN NaN -5.683827 5.852091 IVORY_COAST 2024.0 OFI ... CI-9.1.1_1 NaN NaN NaN NaN COOPERATIVE SOCOOPELA NaN SOCOOPELA DALOA
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
1344 OFI CENTRE-OUEST DALOA NaN NaN -6.868830 6.622070 IVORY_COAST 2024.0 OFI ... CI-9.1.1_1 NaN NaN NaN NaN COOPERATIVE CABS WAREHOUSE NaN COOP-CA-CABS DALOA
1345 OFI SUD-OUEST DALOA NaN NaN -6.868830 6.622070 IVORY_COAST 2024.0 OFI ... CI-9.1.1_1 NaN NaN NaN NaN COOPERATIVE CABS WAREHOUSE NaN COOP-CA-CABS DALOA
1346 OFI EST DANANE NaN NaN NaN NaN IVORY_COAST 2024.0 OFI ... CI-8.3.2_1 NaN NaN NaN NaN COOPERATIVE COOP-CA-PAN NaN COOP-CA-PAN DANANE
1347 OFI OUEST DANANE NaN NaN -8.150575 7.252397 IVORY_COAST 2024.0 OFI ... CI-8.3.2_1 NaN NaN NaN NaN COOPERATIVE COOP-CA-UDAN NaN COOP-CA-UDAN DANANE
1494 NaN PCBM YAKASSE-ATTOBROU FAIR FOR LIFE 65.0 -3.640164 6.081502 IVORY_COAST 2023.0 ALTER ECO ... CI-7.3.4_1 NaN NaN NaN NaN NaN PCBM PRODUCTEURS DE CACAO BIOLOGIQUE DE LA MÉ PCBM YAKASSE-ATTOBROU

89 rows × 24 columns

for col in df.columns:
    print(f"--- {col} ---")
    print(df[col].unique())
    print("\n")
--- DISCL_TRADER_NAME ---
['BARRY CALLEBAUT' 'BLOMMER' 'ECOM' 'OFI' 'ETG' 'CARGILL' 'FARMSTRONG'
 'GCB' 'JB COCOA' 'SO B GREEN' 'SUCDEN' 'TOUTON' nan 'COCOASOURCE'
 'FILDISI' 'CEMOI' 'SUSCOM']


--- DISCL_SUPPLIER_ABRVNAME ---
[nan "N'DOUCI" 'BINHOUYE' 'KPOUEBO (TOUMODI)' 'HERMANKONO DIES (GUITRY)'
 'BONON' 'BAYOTA (GAGNOA)' 'MENE CENTRE (SAN-PEDRO)' 'CABZOU WAREHOUSE'
 'CEXPAG WAREHOUSE' 'COOTIEN OULA WAREHOUSE' 'DAGADJI'
 'SCAOD SCOOPS WAREHOUSE' 'SCAT WAREHOUSE' 'SCJPAB I WAREHOUSE'
 'SCOOPADOB WAREHOUSE' 'SCOOPAL WAREHOUSE' 'SCOOPAM WAREHOUSE'
 'SCOOPS SPC WAREHOUSE' 'SOCABANCO WAREHOUSE' 'SOCAPROZ WAREHOUSE'
 'SOCOBAD WAREHOUSE' 'SOCOOPAK WAREHOUSE' 'BECIDA' 'BECIDA TLE'
 'BMC VAVOUA' 'COADOSOV' 'SCAFRA' 'SCOAVA' 'SCOOPAAB' 'SCOOPABL'
 'SPAD MAN' 'CANN COOP-CA' 'COOPAAHS' 'COOP-CA CAYAT' 'COOP-CA ECAMOM'
 'GRAND LAHOU' 'COOP-CA SCARDI' 'COOP-CA SECA' 'COOP-CA SOCADAG'
 'COOP-CA-CAPKA' 'LCAG COOP-CA' 'MIEN-SAH SCOOPS' 'SCAES COOP-CA'
 'SCALO COOP-CA' 'SCBG-COOP-CA (GALEBRE)' 'SCNV-CA' 'SCOOPS-SAHS'
 'SOCAS COOP-CA' 'SOCAYEMA COOP-CA' 'SOCODD' 'SOCOOPEM COOP-CA'
 'U.S.C.R.G-COOP-CA' 'UCODEL COOP-CA' 'AHONDJO' 'SCOOPAD' 'SCOOPAK' 'SI3C'
 'UDAN' 'CAF' 'COOPABAK' 'ECEPAG' 'SCAFUD' 'SOCAG' 'SOCAS' 'SOCAYA'
 'SOCOOPAN' 'SOCOPAL' 'SCOOP-CA SPAB' 'SPAD CA' 'ABONGOUA' 'CADB' 'CADEDO'
 'CAEG' 'CAMOBIAN' 'CANK' 'CAPA' 'CAPB' 'CAPM' 'CAPRESSA' 'CEMA' 'COABIA'
 'COOP CA AGOH' 'COOP CA COANI' 'COOP JCAS' 'COOPACA' 'COOPADEF'
 'COOPAGARO' 'COOPAGES' 'COOPAGO' 'COOPAHK' 'COOPAZA' 'COOPRADI' 'ECAB'
 'ECAO' 'ECOPADI' 'SCAANIAS' 'SCAM' 'SCOOPA CA' 'SCOOPASG' 'SCOOPECO'
 'SCOOPS AKY' 'SCOOPS BAD' 'SCOOPS-APRAB' 'SINIKAN-SCOOPAS' 'SOCANOVA'
 'SOCOOPADO COOP CA' 'SOCOOPAM' 'SOLIDARITE' 'SCAPAO' 'SOCAD'
 'SPAD GUIGLO' 'SPAD SOUBRE' 'BARRA GABIADJI' 'CBNB' 'COALIDAN' 'COOKADI'
 'COOP CA DJIGUIYA' 'COOPAGNIPI COOP CA' 'SCAPD COOP CA' 'SOCBPI'
 'CA2S-CA' 'CAEZ-COOP-CA' 'COOPRAMA-CA' 'S.C.P.K COOP-CA'
 'SCOOPAC-COOP-CA' 'SCOOPS ECAPG' 'SOCAET2' 'SCOOWEND' 'SCAGB' 'SOCASS'
 'SCAK' 'SOCAGRI2' 'CAGNAN' 'SCANG' 'SCAPD' 'SAN PEDRO' 'SOCAT' 'SCANFI'
 'SCOOPAGED' 'CAEHS' 'GNATO' 'SCAMED' 'CAFUGO' 'ECSP' 'CAMAYE' 'SOCAMEA'
 'ECAKOOG' 'COOBADI' 'CAYAT' 'ECAM' 'ECOJAD' 'SOCOOPACDI' 'DJOUMAN'
 'SOCASIB' 'SICOPAG' 'SCAWOD' 'AHONTO' 'SOCADA' 'SOCA2PD' 'KAPATCHIVA'
 'ESCOPAG' 'SCOOPAG' 'COODIG' 'CAPUM' 'SCOOPAKAM' 'SCOOWEND COOP-CA'
 'CASIB COOP-CA' 'COOP-CA ADA' 'BARA COOP-CA' 'AGRIAL COOP-CA'
 'COPAWEB COOP-CA' 'ECAPA GZ COOP-CA' 'SOCAAN COOP-CA' 'AHONTO COOP CA'
 'AMIANGOUAN' 'APM DALOA COOP-CA' 'C2AS' 'CAADA COOP-CA' 'CABING'
 'CABS COOP-CA' 'CADESA' 'CADT' 'BIANKOUMAN' 'CAPROD' 'CAPSUD COOP-CA'
 'CAREFSI' 'CARET' 'CASIB' 'CAVA COOP-CA' 'CJPK' 'CMB COOP-CA'
 'COALIDAN COOP-CA' 'COOP CA-JCAS' 'COOPADES' 'GOUDI' 'COOPAGG'
 'COOPAGNIPI' 'MENEE CENTRE/GABIADJI' 'COOPANEK' 'COOPAO'
 'COOPAPAIX-H-S SCOOPS' 'COOPAPEDI' 'COOP-CA APRAB' 'COOP-CA CAPRESSA'
 'COOP-CA SOCAPROZ' 'COOP-CA TEEGA- WENDE' 'COOP-CA-AKK' 'COOPINA COOP-CA'
 'COVIMA COOP-CA' 'CPR CANAAN' 'ECAB GUIGLO' 'ECABLO' 'ECAKO'
 'ECAKOOG COOP-CA' 'ECAM COOP-CA' 'ECAPR' 'ECOJAD COOP-CA'
 'ETC TAABO COOP-CA' 'FAHO COOP-CA' 'HKF /NAWA' 'JAVA' 'JEPRAS'
 'GRAND-BEREBY' 'KANWORI DE YAOU COOP-CA' 'LANAYA COOP-CA'
 'LE ROCHER COOP-CA' 'TINHOU' 'SCAACI' 'SCABK' 'SCALAVA' 'SCAPEN COOP-CA'
 'SCAPUD COOP-CA' 'SCAS' 'SCBPAG COOP-CA' 'SCOAGG' 'SCOM'
 'SCOOP- BINKADI GA' 'SCOOPAB' 'SCOOPANAB COOP – CA' 'SCOOPAVI'
 'SCOOPRAZA COOP-CA' 'SCOOPS CAED' 'SCOOPS SOCA2PD' 'SCOOPS-COOPROSAS'
 'SCOOPS-EK' 'SCOOPS-EKLOEWOU' 'SCPCCT-CA' 'SFED' 'SNAPAL'
 'SOCAK KATANA COOP-CA' 'GRAND-ZATTRY' 'SOCEADAHS' 'SOCONEL-SCOOPS'
 'YAKASSE ATTOBROU' 'SOCOPAD' 'SOCOPLA COOP-CA' 'SODASI' 'SPAD DALOA'
 'SPAD GAGNOA' 'UCA' 'YEYASSO' 'SCOOPS ECAB GUIGLO' 'COOP CA SCAMB'
 'SCOOPS YANKADI' 'CEAA COOP CA' 'COOP CA CAGB BLOLEQUIN'
 'COOP CA DJOUMAN' 'COOP CA LAG' 'COOP CA SCOOPAMOU' 'COOP CA SCOOPUF'
 'COOPATHS SCOOPS' 'ECAO COOP CA' 'MINDOBIE' 'SCAOD SCOOPS' 'SCOOPS CABAG'
 'SCOOPS CAFUC' 'SCOOPS CALB' 'SCOOPS CAPROBLO' 'SCOOPS ECAM'
 'SCOOPS RASSO' 'SOCEADAHS COOP CA' 'SOCOPANS COOP CA'
 'COOP-CA COOPAD (DUEKOUE)' 'COOP-CA COOPANAM' 'ECAFHS-COOP.CA'
 'ECAM-SCOOPS' 'COOP-CA CABID' 'COOP-CA ECAG' 'SAMA-HS-SCOOPS'
 'SOCODS SCOOPS' 'ECSP DUEKOUE' 'CADESA COOP-CA' 'COOP-CA CABF'
 'SCJPAB COOP-CA' 'SCOOPS-ECAPG(LAKOTA)' 'COOP-CA MONT BIAN'
 'SCOOPAA COOP-CA' 'SCOOPS SOCOPA' 'COOP-CA C.A.G' 'SCOOPS- COASABANA'
 'SCOOPS-KRIHIRI' 'SCOOPS-SOCOOPA' 'SOCADA COOP-CA' 'COOP-CA- NOCOOP.A.SI'
 'COOP-CA ETC TAABO' 'COOP-CA-CABEND' 'SCOOPS-EKO' 'COOP-CA ECB'
 'COOP-CA-COOPASOD' 'SCOOPS COASADA' 'SCOOPS-EDIFIE-DOUKOUYA'
 'COOPAWEB COOP-CA' 'SCOOP CAES' 'ECOFAB-SCOOPS' 'SCOOPS-C.A.N.W.G'
 'COOP-CA CAMD' 'COOP-CA-REJA' 'KGS COOP-CA' 'SOCAREBIA COOP-CA'
 'BENKADI COOP-CA' 'COOPYMA COOP-CA' 'SCAREG-COOP-CA' 'SCOSOD COOP-CA'
 'COOP-CA ADEDO' 'COOP-CA CAGNAN' 'COOP-CA CPSL' 'COOP-CA CSC'
 'COOP-CA SCPS' 'COOP-CA-COOP.A.SO' 'SOCABEN COOP-CA'
 'COOP-CA SOUHONTA-KAKO' 'SCOOPS COOP.A.DI' 'SOCOOPENHA COOP-CA'
 'COOBADI COOP-CA' 'COOPAADI COOP-CA' 'COOP-CA-COOPRABED' 'COOPEBIA-CA'
 'SCOOPAKOF COOP-CA' 'SOCOOPAGOS COOP-CA' 'AGBS COOP-CA' 'CJAHS'
 'COOFRADO-COOP-CA' 'COOP CA-CPB' 'COOP-CA SCOOPALO' 'COOP-CA SOCANC'
 'COOP-CA SCAPEN' 'SOCAG COOP-CA' 'SOCARL COOP-CA' 'SOCOOPALAO COOP-CA'
 'S.COOPADOU COOP-CA' 'COOP-CA CABD (DOUGBO)' 'COOP-CA ECATAMEA'
 'COOP-CA SOCOOPAGAGNY' "COOP-CA YAWOUBE D'ANIASSUE" 'SCOAKHS'
 'SCOOPAGED COOP-CA' 'CANWORI COOP-CA' 'COOPAAPROMAN COOP-CA'
 'COOP-CA AGREL' 'SOCODAG COOP-CA' 'SCOOPABINKADI-CA' 'CASODI COOP-CA'
 'COOPAC COOP-CA' 'COOP-CA COASI' 'SCOOP CASO' 'CAMAYE COOP-CA' 'SCOPAYO'
 'COOPABE COOP-CA' 'COOP-CA BB' 'COOP-CA-CABD' 'SCINPA' 'COOPAMA COOP-CA'
 'COOP-CA ANONKLON' 'COOP-CA SCAK' 'ECASO COOP-CA' 'CAFHS-COOP-CA'
 'COOPAGA COOP-CA' 'CAPG' 'COOPRAN' 'GUIBEROUA' 'COOP CAADI'
 'COOP - CA - REF - SI' 'CIPACCA COOP CA' 'ECOOPAK COOP CA' 'SCOOP ABOKA'
 'CAL2B' 'COOPADO' 'UPRAD' 'SCOOPS-AGRIOBIO' 'COOP CABS' 'SCOOP CEDA'
 'CAPO' 'COOPRADA' 'NECAB' 'CAC' 'COOP CATBK' 'COOPASM' 'SCAEPGY'
 'SCOOPS-BADEMAYA' 'COOPATESA' 'SCAAO' 'SOCAHI' 'SOCOOPELA' 'SOCOPADOU'
 'CABA' 'COOP TEEGA WENDE' 'SCOOPS CARET' 'SCOOPS JPK' 'HKF6' 'HKF7'
 'NAWA1' 'SCOOPNAS' 'SOCAGS' 'SCAES' 'SOCOPDAL' 'CAYSI' 'CENTRE-EST' 'EST'
 'SUD-EST' 'OUEST' 'CENTRE-OUEST' 'SUD-OUEST' 'SUD' 'CENTRE' 'NORD'
 'BENKRA COOP-CA' 'CAAM COOP-CA' 'CAB' 'CAEZA' 'CAPG GUIGLO' 'CASODU'
 'CAYEMOS COOP-CA' 'CIPA COOP-CA' 'COAB COOP-CA' 'COOPAA COOP-CA'
 'COOPABOIGNY' 'COOPAHZ' 'COOPAZA COOP-CA' 'COOP-CA COOPAGLI'
 'COOPAAPROMAN' 'COOPEN COOP-CA' 'COPAKCODI' 'COPUK COOP-CA'
 'ECAO COOP-CA' 'ECOOYA' 'NOCAO OUME' 'SCOOPA-CA' 'SCOOPS-ES'
 'SCOOPABINKADI' 'SCOOPANAD' 'CAPEDIG (PART OF ECOOKIM)' 'COODID'
 'COOP CA CPAGB' 'SCPCB' 'COOP CA UPRAD' 'ECAPN COOP CA' 'SCELA COOP CA'
 'SCAP CC COOP CA' 'RELUAINDE COOP CA' 'COOPAGNIPI SCOOPS' 'COOP-CA-CPSL'
 'SOCOOPAGAGNY COOP CA' 'COOP CA COOPAD' 'SCOOPAZEG COOP CA'
 'SCOOPRAH COOP CA' 'SOCOPASG COOP CA' 'COOP-CA-ECAMOG' 'COOP PUSAH'
 'COOP CA AB' 'COOPAME' 'SCOOPS PS' 'USOCAS' 'COOP CA PRO' 'AFFERY'
 'COOPAGO COOP CA' 'ECOODI' 'AJAMI ALY' 'COOP CA PAI' 'COOP CA SCOOPAUDD'
 'SOCOOPAKOKO' 'SAPO' 'SCOODJIBODI COOP CA' 'SCOOPAZAP COOP CA'
 'SCOOPEPASCOOPS-' 'SCOOPS DAKUA' 'SCOOPS ECAB' 'SCOOPS IZ' 'SCOOPS-PAK'
 'SCOOPS MOYE' 'SOCABA SCOOP CA' 'SOCACHIPOLO COOP CA' 'SOCOOPAF SCOOPS'
 'COOP CA A.DI' 'FOUNDARA' 'COOPATESA SCOOPS' 'SOCOOPELA SCOOPS' 'GRABO'
 'DIEGONEFLA' 'SOCABID COOP-CA' 'SCOOPS PAC' 'SCOOPS PAZ' 'SEGUELLA'
 'SOCICAS SCOOPS' 'SOCOPGA SCOOPS' 'TOULEPLEU' 'SOCABL COOP CA'
 'SCOOPS LAFI-BEBE' 'COOP CA ESPOIR' 'SOCAZE COOP CA' 'SCOOPS COOPADO'
 'SCOOPS SODASI' 'SCOAPANI' 'COOP CA LA GLOIRE' 'COOPADO COOP CA'
 'SCINPA COOP CA' 'SCOOPASAВ СООР СА' 'CAWSA SCOOPS' 'NCB COOP CA'
 'SCAW COOP CA' 'CANT COOP CA' 'COOP CA ECAG' 'SCOOPS SAL' 'SCAJP' 'CALZB'
 'HAMAOULA' 'SCOOPA' 'NWM' 'SONAB' 'WEND SONGODO' 'JPAB' 'TEEGAWEND'
 'PCBM' 'APM BENIANSSOU A' 'APM BENIANSSOU B' 'APM BENIANSSOU C'
 'APM DALOA A' 'APM DALOA B' 'APM DALOA C' 'APM MAN B' 'APM MAN C'
 'BECIDA A' 'BECIDA TLE A' 'CAADI' 'CAAM' 'CABK 1' 'CABK 2' 'CAED DALOA'
 'CAED GUIGLO' 'CAEDU' 'CAOSI' 'CASB' 'CNEK' 'COAM DALOA A' 'COAM BONON'
 'CODERLACS TOUMODI' 'COAM DALOA B' 'COOPAEEN' 'COOP-CA EYONIAN'
 'ESPÉRANCE SCOOPAAB' 'ICA' 'COVIMA' 'NOUR' 'SCAGB BLOMMER' 'SCCG' 'SCOAG'
 'SCOOPAB B' 'SCOPACI' 'SCPCCT 2 B' 'SCPCCT 1' 'SICAO B' 'SCPCCT 2 A'
 'SICAO A' 'SOCADJA C' 'SOCA2PD B' 'SOCADJA A' 'SPAD DALOA 1'
 'SPAD DUEKOUE B' 'SPAD DALOA 2' 'SPAD GAGNOA N A' 'SPAD DUEKOUE A'
 'SPAD GAGNOA F' 'SPAD MAN B' 'SPAD SEGUELA' 'SPAD GAGNOA N B'
 'SPAD MAN A' 'SPAD VAVOUA' 'ZAGTOULI' 'ECAM SCOOPS' 'BENKADI COOPS'
 'COOPAC' "SOCIÉTÉ COOPÉRATIVE ESPOIR D'ALEPÉ" 'SCOOPS CAPUM' 'WINPAS'
 'ECOOKIM - COOPAPIG' 'ECOOKIM - CAVA' 'ECOOKIM - CAUD' 'ECOOKIM - CAKIB'
 'YEBOYEKON SCOOPS' 'RADEE TRADING' 'SOCADMV' 'SIVAP' 'ECAMOM'
 'ESPOIR COOP-CA VAVOUA' 'SOCOPRAHNS' 'SCAT' 'COOPAD'
 'SCOOPS-ECAPG (LAKOTA)' 'PLAZA SOUBRE' 'PLAZA GAGNOA' 'SOCOEMA' 'BARA'
 'SCOOPS COASABANA' 'SOCAZM COOP CA' 'ECATIE COOP CA'
 'ECOOKIM - CPR CANAAN' 'SCOOPAAS COOP CA' 'SCAW COOP CA MAN' 'SCAC'
 'SCAB' 'CALTDV' 'APM DALOA' 'APM GAGNOA' 'ECAAF' 'ECOPAS'
 'ECAESB COOP-CA' 'SOCA2PD SCOOPS' 'COOPINA' 'DIBY' 'SOCOOPLAGUE SCOOPS'
 'COOPAYAAF' 'COOPANAM (EX EDY)' 'COOP-CAES' 'COOP CA KWS' 'COOP CA GCT'
 'COOP CA COPACOL' 'COOP-CA-ABOTRE' 'COAM' 'SOCODAN' 'COOP-CA CASODU'
 'CAMAP' 'COOP CA CANS' 'COOP CA CPAL' 'COOPAYAAF COOP-CA' 'WAGAJACA'
 'SCOOPSYAT' 'SCAPCCA' 'SOCNAD' 'CABG SCOOPS' 'COOPANAM' 'SICOPAG COOP CA'
 'COOPAPIG' 'SCOOPS FG' 'CAVA' 'CAUD' 'CAKIB' 'SOCOOPRANHS' 'SCOOPS RADEE'
 'SAUT' 'ESPOIR' 'CAP VA SCOOPS' 'Benianssou / APM Gagnoa' 'APM Daloa'
 'SCAREG COOP-CA' 'ECAFHS' 'SCOOPS-SCOEL BONGOUANOU' 'RASSO'
 'COOP CA COOPANAM' 'SCOOPS-ECAPG (Lakota)' 'BENKADI' 'SOCOPEK'
 'SOCOPADOGBO' 'SOCOOPAGAGNY' 'UPAS COOP CA' 'COOP-CA SO.CO.SA.DA'
 'SCABODI COOP CA' 'CAPO COOP CA' 'SIPAG' "CAPA M'BATO" 'SOCOBIT'
 'ANZUE COOP-CA' 'SCOOPNIA' 'SCALA' 'SOCAGNIPI' 'SO.CC.NA.COOP.CA'
 'COOP CA SOCAMEA' 'COOP-CA ECAMOG' 'COOP CA BIRBA' 'CAGB'
 'COOP-CA SOCOOPL' 'CBPAG' 'COOPRAS' 'COOP CA SCAND' 'SCOAKA'
 'SCOOPS CANGEVA' 'COOP-CA COOPABIN' 'COOPCA WIND PANGA COOPRAZO'
 'SCOOPS-LTDV' 'COOPROYA' 'COOPABENKADI' 'SCSPA' 'IQJ' 'SCAEG' 'COOPYCA'
 'COOP CA PAN' 'COOPAZEG' 'COOP CA ANZUE 2' 'COOP-CA-GCT' 'SOCABB'
 'COESAG' 'COOP-CA JST' 'SCAW COOP-CA MAN' 'COOPCA INCHALA' 'SOCAEK'
 'SOCARIT COOP CA' 'SOCABA COOP CA' 'COOP-CA-UDAN' 'SCOOPS COOP.A.SAM'
 'COOPAM-COOP-CA' 'CABES' 'SCOOPS YAT' 'SOCAET COOP CA'
 'CABG COOP-CA/MANKONO' 'CED COOP CA' 'SCANCCB COOP CA' 'SOCAZM' 'ECATIE'
 'SCAP CCA' 'SCOOPS PUCC' 'SCOOPS ECOOPEZ' 'COOP CA 2 CG'
 'SCOOPS CAPUM (NEW)' 'COOPAB-CI' 'ECYG-COOP-CA' 'CAYSI-SCOOPS'
 'COOP CA ABO' 'COOP-CA ESPOIR' 'SOCAGNIPI COOP-CA' 'COOP-CA-ECABLO'
 'COOP-CA ECAKO' 'NOUVELLE SCOOPRANYD COOP-CA' 'COOP-CA-ZRANSSA'
 'COOP-CA CAPSUD' 'SCOOPS-COOPADES' 'COOPAO SCOOPS' 'S.CO.A.G.G.-COOP-CA'
 'COOP-CA-ECAPR' 'COOP-CA SOCA BANCO' 'PLAZA-COOP-CA SOUBRE' 'SOCOCCI'
 'SCAMED COOP-CA' 'SCOOPAGED COOP CA' 'SCANFI_SCOOPS' 'SCOOPNAG-SCOOPS'
 'SCOOPAM' 'SOCONEL' 'SCOOPS_SAHS' 'ECAFHS COOP-CA' 'SCOOPS-CAP-VA'
 'BARACACAO' 'CASIB-SCOOPS' 'SCOOPAGRO' 'COOPALBA' 'COOPANOU'
 'COOPATHS-SCOOPS' 'COVIMEA' 'ESPOIR COOP-CA' 'FAHO' 'SCAEB' 'SCAETHS'
 'SCOOPS_DAKUA' 'SCAFUB COOP CA' 'COOPCA-COOPANAM' 'COOJEPAWO SCOOPS'
 'COOP CA SOUGRI NONMA' 'ECAM SASSANDRA' 'SCOOPUF-COOP-CA'
 'CAFUGO COOP CA' 'COOP-CCAPUO' 'COOP_CA_UDAN' 'YEBOYOKON SCOOPS']


--- DISCL_AREA_NAME ---
['AGNIBILEKRO' 'ABENGOUROU' 'BONGOUANOU' 'BANGOLO' 'DIVO' 'SINFRA'
 'AGBOVILLE' 'TABOU' 'SOUBRE' 'TOUMODI' 'GAGNOA' 'GUIGLO' 'BIANKOUMA'
 'SEGUELA' 'DUEKOUE' 'TIASSALE' 'MAN' 'SASSANDRA' 'BLOLEQUIN'
 'ZOUAN-HOUNIEN' 'KOUIBLY' 'GUITRY' 'ADZOPE' 'BOUAFLE' 'SAN-PEDRO' 'DALOA'
 'LAKOTA' 'AKOUPE' 'MEAGUI' 'ISSIA' 'ZUENOULA' 'YAKASSE-ATTOBROU'
 "M'BATTO" 'ABOISSO' 'ARRAH' 'TOULEUPLEU' 'VAVOUA' 'GUEYO' 'TAABO' 'TAI'
 'ZOUKOUGBEU' 'DANANE' 'ALEPE' 'OUME' 'FRESCO' 'BUYO' 'YAMOUSSOUKRO'
 'GRAND-LAHOU' 'BETTIE' 'DJEKANOU' 'SIKENSI' 'ADIAKE' 'BEOUMI' 'KOUN-FAO'
 'BONDOUKOU' 'BOCANDA' 'ABIDJAN' 'DAOUKRO' 'SIPILOU' 'KANI' 'SAKASSOU' nan]


--- DISCL_CERTIFICATION_NAME ---
[nan 'RAINFOREST ALLIANCE, NOT CERTIFIED' 'RAINFOREST ALLIANCE'
 'FAIRTRADE, RAINFOREST ALLIANCE, FAIRTRADE, NOT CERTIFIED'
 'FAIRTRADE, RAINFOREST ALLIANCE, RAINFOREST ALLIANCE, NOT CERTIFIED'
 'FAIRTRADE, RAINFOREST ALLIANCE, RAINFOREST ALLIANCE, FAIRTRADE, NOT CERTIFIED'
 'FAIRTRADE, RAINFOREST ALLIANCE, RAINFOREST ALLIANCE'
 'FAIRTRADE, NOT CERTIFIED'
 'FAIRTRADE, RAINFOREST ALLIANCE, RAINFOREST ALLIANCE, NOT CERTIFIED, FAIRTRADE, ORGANICO, RAINFOREST ALLIANCE, ORGANICO, RAINFOREST ALLIANCE'
 'NOT CERTIFIED'
 'FAIRTRADE, FAIRTRADE, RAINFOREST ALLIANCE, NOT CERTIFIED'
 'FAIRTRADE, RAINFOREST ALLIANCE, NOT CERTIFIED, RAINFOREST ALLIANCE'
 'NOT CERTIFIED, FAIRTRADE' 'FAIRTRADE, RAINFOREST ALLIANCE'
 'FAIRTRADE, RAINFOREST ALLIANCE, NOT CERTIFIED, FAIRTRADE, RAINFOREST ALLIANCE'
 'FAIRTRADE, RAINFOREST ALLIANCE, NOT CERTIFIED'
 'RAINFOREST ALLIANCE, FAIRTRADE, RAINFOREST ALLIANCE, NOT CERTIFIED'
 'FAIRTRADE, FAIRTRADE, RAINFOREST ALLIANCE, RAINFOREST ALLIANCE, NOT CERTIFIED'
 'NOT CERTIFIED, RAINFOREST ALLIANCE' 'ORGANICO'
 'RAINFOREST ALLIANCE, NOT CERTIFIED, FAIRTRADE'
 'FAIRTRADE, RAINFOREST ALLIANCE, FAIRTRADE' 'ORGANICO, FAIRTRADE'
 'FAIRTRADE'
 'COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, RAINFOREST ALLIANCE'
 'COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE'
 'COCOA HORIZONS, FERMICOA, COCOA HORIZONS'
 'COCOA HORIZONS, COCOA HORIZONS, FERMICOA' 'COCOA HORIZONS, FERMICOA'
 'COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS' 'COCOA HORIZONS'
 'COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS'
 'COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE'
 'COCOA HORIZONS, FAIRTRADE' 'COCOA HORIZONS, RAINFOREST ALLIANCE'
 'COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, COCOA HORIZONS, RAINFOREST ALLIANCE'
 'COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS, FAIRTRADE, FERMICOA, RAINFOREST ALLIANCE, COCOA HORIZONS, COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, FERMICOA, COCOA HORIZONS, RAINFOREST ALLIANCE'
 'COCOA HORIZONS, COCOA HORIZONS, RAINFOREST ALLIANCE'
 'COCOA HORIZONS, COCOA HORIZONS, FAIRTRADE'
 'COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS'
 'COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS'
 'COCOA HORIZONS, FAIRTRADE, FERMICOA, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, FERMICOA, COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS, FERMICOA'
 'COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS'
 'COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS'
 'COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, FERMICOA, RAINFOREST ALLIANCE, COCOA HORIZONS, FERMICOA, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE'
 'COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS, COCOA HORIZONS, FAIRTRADE'
 'COCOA HORIZONS, COCOA LIFE, FAIRTRADE, COCOA HORIZONS, COCOA LIFE'
 'COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS'
 'COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS, COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE'
 'COCOA HORIZONS, COCOA LIFE, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, COCOA LIFE, FAIRTRADE'
 'COCOA HORIZONS, FAIRTRADE, FERMICOA, COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS, FERMICOA'
 'COCOA HORIZONS, FAIRTRADE, FERMICOA, RAINFOREST ALLIANCE, COCOA HORIZONS, COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS, FERMICOA, RAINFOREST ALLIANCE'
 'COCOA HORIZONS, FAIRTRADE, FERMICOA, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, FERMICOA, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, FERMICOA'
 'COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE'
 'COCOA HORIZONS, FERMICOA, RAINFOREST ALLIANCE, COCOA HORIZONS, FERMICOA'
 'COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS, COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE'
 'COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, RAINFOREST ALLIANCE'
 'COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS, RAINFOREST ALLIANCE'
 'COCOA HORIZONS, FAIRTRADE, FERMICOA, RAINFOREST ALLIANCE, COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS, COCOA HORIZONS, FAIRTRADE, FERMICOA, COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, FERMICOA, COCOA'
 'COCOA HORIZONS, FAIRTRADE, FERMICOA, RAINFOREST ALLIANCE, COCOA HORIZONS, COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, FERMICOA, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS, FAIRT'
 'COCOA HORIZONS, COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE'
 'COCOA HORIZONS, FAIRTRADE, ORGANICO, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, ORGANICO'
 'COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, COCOA HORIZONS, RAINFOREST ALLIANCE'
 'RAINFOREST ALLIANCE, NOT CERTIFIED, RAINFOREST ALLIANCE, TRAINING_2425_BASIQUE, RAINFOREST ALLIANCE, TRAINING_2425_AVANCE, TRAINING_2425_BASIQUE'
 'COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS, COCOA HORIZONS, FERMICOA'
 'COCOA LIFE' 'COCOA LIFE, FAIRTRADE, COCOA LIFE'
 'RAINFOREST ALLIANCE, FAIRTRADE, RAINFOREST ALLIANCE, FAIRTRADE, NOT CERTIFIED'
 'FAIRTRADE, RAINFOREST ALLIANCE, FAIRTRADE, RAINFOREST ALLIANCE, NOT CERTIFIED'
 'COCOA LIFE, FAIRTRADE, ORGANICO, RAINFOREST ALLIANCE, COCOA LIFE, FAIRTRADE, RAINFOREST ALLIANCE, COCOA LIFE, FAIRTRADE, COCOA LIFE, FAIRTRADE, ORGANICO, COCOA LIFE, RAINFOREST ALLIANCE, COCOA LIFE, ORGANICO, RAINFOREST ALLIANCE, COCOA LIFE, ORGANICO'
 'COCOA LIFE, FAIRTRADE, RAINFOREST ALLIANCE, COCOA LIFE, RAINFOREST ALLIANCE, COCOA LIFE, FAIRTRADE, COCOA LIFE'
 'COCOA LIFE, FAIRTRADE, COCOA LIFE, COCOA LIFE, FAIRTRADE, RAINFOREST ALLIANCE'
 'COCOA LIFE, FAIRTRADE, RAINFOREST ALLIANCE'
 'COCOA LIFE, COCOA LIFE, FAIRTRADE, RAINFOREST ALLIANCE, COCOA LIFE, FAIRTRADE, COCOA LIFE, RAINFOREST ALLIANCE'
 'COCOA LIFE, FAIRTRADE, RAINFOREST ALLIANCE, COCOA LIFE, RAINFOREST ALLIANCE, COCOA LIFE, FAIRTRADE'
 'COCOA LIFE, RAINFOREST ALLIANCE, COCOA LIFE'
 'COCOA LIFE, COCOA LIFE, FAIRTRADE, COCOA LIFE, FAIRTRADE, RAINFOREST ALLIANCE, COCOA LIFE, RAINFOREST ALLIANCE'
 'COCOA LIFE, RAINFOREST ALLIANCE'
 'RAINFOREST ALLIANCE, FAIRTRADE, RAINFOREST ALLIANCE, NOT CERTIFIED, FAIRTRADE'
 'FAIRTRADE, RAINFOREST ALLIANCE, FAIRTRADE, RAINFOREST ALLIANCE'
 'COCOA LIFE, FAIRTRADE, RAINFOREST ALLIANCE, COCOA LIFE, FAIRTRADE, COCOA LIFE'
 'COCOA LIFE, COCOA LIFE, RAINFOREST ALLIANCE'
 'COCOA LIFE, RAINFOREST ALLIANCE, COCOA LIFE, COCOA LIFE, FAIRTRADE'
 'COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS'
 'COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS, COCOA HORIZONS, RAINFOREST ALLIANCE'
 'COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, FERMICOA, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, FERMICOA, COCOA HORIZONS, FERMICOA, RAINFOREST ALLIANCE'
 'COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE'
 'COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS, COCOA HORIZONS, FAIRTRADE'
 'COCOA HORIZONS, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, RAINFOREST ALLIANCE, COCOA HORIZONS, FAIRTRADE, COCOA HORIZONS'
 'FAIRTRADE, FAIRTRADE, RAINFOREST ALLIANCE' 'RA' 'PV' 'FAIR FOR LIFE']


--- DISCL_NUMBER_FARMERS ---
[   nan  4921.   859.   474.   456.   725.  1130.   300.   467.  2819.
  1153. 10160.   277.  3338.   678.   789.   243.   514.   303.   259.
   360.   516.   602.  1538.  3623.   234.   643.   423.   452.   983.
   703.   749.   964.   869.   192.   787.   520.   513.  1057.   390.
   438.   573.   443.   499.   709.   376.   498.   208.   445.   391.
   461.  1479.  1194.   706.   455.   659.   522.   582.   153.   447.
   737.  1162.   539.   888.   557.   915.   386.  1136.   827.   339.
   720.   644.   334.   395.   111.   554.   444.   788.   784.   176.
   831.   304.   782.   577.   157.   460.  1066.   736.   458.   312.
   465.   410.  1177.   945.   766.   402.  2244.  2275.   640.   305.
   624.   509.  1391.   196.   688.  3034.   597.   353.  1113.  1714.
  2177.   628.   895.   424.  1009.   751.  1594.   836.  4111.   375.
  1452.   635.   367.  1334.   875.   551.  1444.   302.   803.  3126.
   284.   595.  1000.  1110.   336.   801.   928.   816.   854.   251.
   257.  2437.   955.   702.   490.  1178.  1016.   999.  1214.   563.
   748.  1374.   632.   542.  1059.   776.  3154.   759.  1446.   951.
  1758.  1468.  1029.  2243.   818.   935.  1373.  3824.   721.  2022.
   559.   758.   855.  1832.  1664.  1148.  2462.  1079.  1491.  1771.
   613.  1770.  1058.   963.   655.   526.   601.   521.  1436.   440.
   620.   936.   943.   598.   288.   301.   326.  1645.   429.  3298.
   327.  3220.  1155.  1962.  1390.  2992.   538.   727.  1747.   472.
  1378.  3094.   914.   479.  2790.  1922.   523.  1215.  4181.  1884.
  1627.  2299.  2154.  2429.   835.   670.   953.  1285.   618.   430.
   860.  1147.   755.   740.   492.   894.   508.  1985.   952.   619.
  1267.  1036.  1377.   883.   260.   822.   683.   469.  1003.   791.
   579.  1044.   790.   927.   901.  1367.  1090.   412.   265.  1820.
   406.   478.   648.   642.   675.  1696.  1797.  1718.   957.  1050.
  1426.   852.   744.   625.   800.   817.   385.   314.   654.   724.
   223.  1081.   669.  2071.  1595.   781.    50.   707.   290.   830.
   599.   500.   532.    65.  1306.   714.   639.  1363.  4120.  1190.
  2634.   712.  1020.   495.   778.  3486.  2314.  1296.   403.   723.
  1195.   897.  1666.  1803.  1518.  1132.]


--- DISCL_LONGITUDE ---
[-3.20433245 -3.49493033         nan -7.45526061 -5.35640788 -5.35451335
 -6.55888428 -5.58379172 -6.44323    -5.6811     -3.48565    -3.88731
 -3.96067    -6.54965    -7.35344    -6.59324    -6.563192   -6.64378
 -6.60885    -6.55522    -6.44275    -6.58944    -6.63095    -6.93491
 -6.37428    -6.04719    -7.47582    -3.63937    -6.60751    -7.35917
 -4.36066    -5.68268    -3.48705    -7.34648    -6.08584    -7.41549
 -6.54108    -3.10829    -7.35196    -5.36365    -5.68861    -6.5598
 -3.88271    -6.459778   -7.494868   -7.3466     -5.24171    -3.48297
 -5.68322    -7.34602    -7.34608    -5.93207    -4.12976    -7.4775
 -7.306045   -7.78406    -4.095231   -3.53188    -4.76465    -8.29711
 -6.48137    -7.39305    -7.35404    -6.04186    -7.73144    -4.8607
 -4.196      -6.59397    -3.50027    -6.47223    -7.48602    -7.34444
 -5.59624    -6.84717    -7.4931     -4.21928    -6.448765   -7.93018
 -7.5525     -6.08246    -4.13154    -6.8231     -7.5074     -6.55356
 -5.82588    -6.58209    -6.59963    -6.84694    -6.48146    -7.48048
 -5.67931    -6.04339    -5.10593    -3.26977    -3.66014    -5.36363
 -8.15208    -3.4978121  -7.57396    -5.3549     -7.362764   -5.347317
 -7.348449   -7.35506    -3.33729    -3.50792    -5.36482    -5.57943
 -6.47603    -5.19937    -5.50781    -6.56111    -6.63651    -3.49507
 -3.4862065  -5.52285    -6.56573    -6.27737    -6.56324    -7.32953
 -5.15632    -3.17484    -6.41515    -6.67154    -6.82824    -6.30785
 -5.93528    -6.44336    -3.17234    -4.12883    -7.30605    -6.5599
 -6.1099     -7.55147    -7.71154    -7.50952    -7.32959    -6.43184
 -7.33006    -7.99495    -5.83939    -8.00152    -6.43264    -6.43195
 -5.27713    -5.9077     -5.36159    -3.15585    -4.82206    -6.64427
 -3.03106    -5.91308    -5.90956    -6.83225    -3.36108    -5.36497
 -7.34353    -5.45108    -5.36613    -5.22241    -6.04463    -6.60209
 -5.35554    -5.02254    -3.34713    -3.96722    -5.94689    -5.79739
 -7.47186    -5.06908    -5.35533    -5.0178     -5.96246    -6.43538
 -8.01206    -6.86883    -5.94728    -4.21772    -7.4883     -3.50066
 -3.24023    -7.28541    -7.46364    -8.00961    -7.55495    -5.73685
 -7.0097     -3.428657   -8.00269    -5.67969    -7.4902     -7.5101
 -8.34315    -5.90796    -7.23377    -5.0005     -7.50973    -5.2958
 -5.81248    -5.909193   -5.83917    -5.91461    -5.96827    -5.67978
 -5.6401     -4.422377   -5.02965    -5.27093    -5.36446    -6.45235
 -7.50632    -5.32458    -5.02172    -5.90844    -6.70458    -4.82498
 -6.40013    -5.01948    -6.70001    -6.72768    -5.58417    -5.37127
 -7.55031    -6.04989    -6.48121    -5.95217    -6.47674    -7.48887
 -6.04912    -5.7089     -6.2625     -7.34725    -5.94247    -4.75984
 -3.29233    -8.00213    -7.41689    -8.13786    -6.64554    -6.81082
 -5.78323    -7.35408    -5.36354    -4.22093    -7.35062    -5.9624
 -6.4267     -7.50549    -5.6718     -6.07532    -7.32794    -3.21352
 -7.93769    -5.67819    -7.35647    -6.55611    -5.57021    -5.00853
 -5.96861    -7.35083    -5.97451    -6.06239    -3.4874511  -6.11525
 -5.90627    -7.6204     -5.9321     -5.95496    -6.35756    -6.1833
 -7.84239    -7.21395    -6.55818    -7.51635    -5.68065    -5.3571
 -4.35926    -5.96175    -6.59215    -6.65328    -7.3502     -6.676
 -6.668127   -6.56214    -7.01537    -6.19367    -7.35955    -3.50169
 -7.35829    -3.392795   -4.21871    -6.24182    -4.22008    -7.48292
 -5.57476    -6.83304    -5.36422    -6.56125    -5.9171     -3.2116
 -6.70606    -6.56018    -6.59453    -6.46219    -5.68059    -7.48561
 -8.00331    -6.5567     -6.520959   -3.851661   -6.552599   -7.3467608
 -7.353241   -7.356466   -6.652974   -8.162288   -8.1254     -3.85664
 -6.87012093 -7.8347     -7.34666667 -6.63784991 -7.7112     -6.704575
 -6.64080838 -5.95296265 -6.6417508  -6.45067651 -6.400127   -4.555085
 -3.8491     -6.481207   -6.48171667 -7.168839   -6.43173306 -3.857004
 -6.5611     -5.16222954 -5.36440974 -6.070833   -6.64267908 -6.45615886
 -6.553      -6.09015662 -3.211596   -6.99735508 -6.2936861  -6.47077116
 -6.58267748 -5.199369   -6.63500064 -7.37062176 -5.87710146 -5.677351
 -7.20309386 -8.15057525 -6.58957    -7.48854115 -5.8637     -6.06899
 -6.77945    -5.9543603  -5.688606   -5.0053767  -4.56734707 -8.0031
 -6.86740825 -7.48978942 -3.48765    -6.55833767 -3.501692   -3.2
 -6.64696407 -5.94401023 -5.1784     -7.4043     -3.49223995 -5.36008
 -6.67245    -6.594525   -5.3145     -6.08460011 -7.35249657 -5.42210053
 -4.21655875 -7.99367712 -7.23854543 -6.64841125 -7.343681   -3.50647439
 -6.8449     -5.364817   -6.99410517 -6.631      -7.015374   -6.047193
 -7.48926676 -4.20541847 -7.485607   -6.8046     -6.060278   -6.08505679
 -3.95046799 -6.08867538 -6.64875488 -6.44428769 -7.44766589 -6.4579531
 -5.94696279 -6.08917668 -6.08658549 -6.08093208 -5.67948163 -6.620243
 -5.736848   -5.27106416 -5.362552   -7.36246    -3.664859   -6.6533
 -6.06377843 -6.85937062 -6.09445563 -5.95481524 -6.832245   -6.4535
 -6.45640242 -6.556695   -5.839596   -5.9067     -5.2057     -6.661711
 -8.00371044 -6.432641   -5.91333959 -7.49009231 -5.942472   -5.9467328
 -7.24320488 -6.602087   -5.10992008 -3.49815268 -7.34261398 -5.36216949
 -4.83452364 -6.08009295 -5.941951   -7.51389    -6.09563609 -6.4572633
 -3.363095   -7.35388889 -6.08736704 -4.758804   -5.682681   -7.353888
 -6.45265523 -5.946887   -6.443231   -5.68624698 -5.814289   -7.50974643
 -8.00325    -7.49666    -3.488898   -7.99428    -7.3465     -7.5968
 -6.34589    -7.353287   -6.474121   -7.469358   -5.8639     -5.570223
 -6.24473    -7.457475   -8.00553    -7.837393   -5.498731   -4.2177
 -6.449265   -6.613104   -7.56070876 -7.35412    -6.66058    -6.52423363
 -7.7217739  -6.64554926 -6.83539038 -6.677864   -6.5537439  -5.828002
 -5.5851     -7.48987388 -5.67839    -6.44642    -6.96774    -6.44745
 -7.5560545  -5.35573    -7.35326    -6.52185    -5.0222441  -6.561166
 -6.24276    -5.9450992  -6.1498757  -3.66106    -5.907545   -5.73682
 -5.06902185 -7.35084388 -5.95617    -6.826496   -7.2365326  -3.1391
 -5.94007    -7.330489   -4.858894   -5.52476667 -8.000518   -6.644
 -3.2406426  -6.05811    -6.10266    -7.35070374 -5.5224644  -3.34435662
 -3.18859197 -6.80237938 -2.92488967 -7.4962127  -6.34206734 -5.41118874
 -3.85185939 -6.81943049 -6.37417304 -6.70353629 -6.14718639 -7.3472
 -6.8084054  -7.01498174 -7.11633343 -7.35322482 -5.36454555 -5.57065813
 -7.39310523 -3.14079156 -5.36174751 -3.20824576 -4.57382833 -6.24363833
 -5.39057701 -6.25047371 -5.02159823 -6.55476514 -4.95664396 -6.17097468
 -6.21165058 -6.93656087 -4.75999545 -6.03083909 -6.64198    -6.16684341
 -5.11644436 -7.41270933 -7.49064947 -6.68230042 -6.74422551 -3.67978221
 -6.22791805 -5.03341023 -3.86084512 -3.65360987 -3.29084585 -5.68628491
 -5.10373    -5.27106142 -6.58656443 -5.5784504  -3.40619654 -6.55782568
 -6.59361363 -5.23882291 -3.21162732 -3.02775744 -5.68349763 -3.49773601
 -6.27857763 -6.4627076  -3.34823854 -3.41196454 -7.35692752 -4.22140622
 -3.28432037 -3.19868916 -3.95046798 -6.59671165 -6.46114029 -6.54967578
 -6.07299    -3.27702    -6.1717     -3.3374     -4.469261   -5.00112
 -4.47413    -4.53946    -4.52545    -6.2639     -6.06931    -6.105
 -5.9293     -6.86919    -6.47201    -3.65112    -6.05387    -6.59258
 -6.04297    -6.5338     -7.05085    -7.45634    -7.01513    -6.83364
 -7.459      -6.96691    -7.31518    -6.81059    -8.162362   -5.71078
 -5.4169     -5.55923    -5.35354    -5.29014    -5.6794     -5.30065
 -7.39763    -7.63597    -8.12682    -7.63388    -6.60882    -6.422647
 -6.607168   -6.595349   -6.5605     -5.683      -4.5728     -5.6829
 -3.49860064 -7.57234    -6.4573547  -6.928      -5.35967707 -6.059567
 -6.08379329 -5.68382717 -6.08019976 -3.4249     -5.909557   -6.08681813
 -6.7494     -7.358287   -3.49201886 -6.818      -5.9462783  -6.055
 -8.00517271 -6.58427983 -6.09196797 -6.64451249 -5.371273   -3.2031
 -7.456335   -6.63556948 -6.09206808 -6.630953   -5.364219   -6.64176798
 -3.4926042  -3.50041626 -5.366133   -6.05144124 -6.5616     -3.954
 -4.9554     -6.64491439 -7.36971932 -6.2025     -6.7168618  -6.810822
 -6.472824   -6.57928639 -5.5592324  -7.5677     -4.822064   -7.49968131
 -5.24233    -7.13109466 -6.588293   -7.009655   -5.6770015  -6.083333
 -3.50327506 -7.550314   -6.64682037 -5.353538   -6.58542357 -3.86857782
 -7.35008409 -8.00265436 -6.563239   -7.36907283 -6.63364544 -5.36025385
 -3.40174693 -6.6402459  -4.759842   -6.08082253 -6.6426     -6.55876097
 -6.56217618 -6.5594309  -6.193665   -7.4690875  -4.2881     -6.0799218
 -6.463      -7.3493     -5.7253     -6.696      -6.64648052 -5.917104
 -5.270927   -5.574757   -6.64442998 -7.012278   -5.41153479 -7.0759
 -6.09196784 -6.64793752 -6.63709429 -7.35817524 -5.368657   -6.08571464
 -6.65959448 -3.174839   -7.34229231 -3.21117138 -3.4062244  -5.2592
 -3.337286   -8.00362921 -6.65951711 -3.20386994 -6.99350665 -7.54375848
 -6.64061004 -6.28222851 -7.35651528 -6.65657711 -7.236528   -3.640165
 -5.94428    -7.5203     -4.5684     -4.5376     -6.602707   -6.44
 -7.479756   -7.36547    -4.43916    -6.0503     -6.042      -3.17508
 -6.482501   -6.862772   -6.4259     -4.82727    -5.1034     -7.5094
 -3.3629     -7.3511     -5.001224   -5.7483     -6.449372   -3.1321
 -6.48099    -6.4355     -5.1991     -4.9982     -6.5921     -4.7868
 -4.7822     -5.3741     -6.4438     -7.3469     -5.9459     -7.5506
 -6.691148   -6.4803     -8.1203     -5.58439753 -6.80237938 -3.6602
 -7.386513   -5.357162   -6.96714    -7.34545503 -3.5056     -6.47063607
 -7.083      -6.44751323 -6.45927004 -5.67839    -5.021721   -6.54911351
 -6.5337     -6.1162     -4.129761   -6.5703     -6.55855631 -7.3699
 -6.452      -3.65263602 -3.4899     -5.592      -7.34459187 -3.6595
 -3.909      -5.9459282  -7.4915     -6.6311     -7.9952     -7.2378
 -7.3512     -7.5499     -7.4859     -7.3625     -7.5537     -6.6439
 -7.4976     -7.5057     -6.6018     -7.5054     -5.0022     -6.1709
 -6.6457     -3.0336     -5.968      -4.4222     -6.645      -6.5588
 -5.41839165 -7.4005     -6.3852     -5.88061207 -6.63884092 -4.21606418
 -6.67712497 -7.39319761]


--- DISCL_LATITUDE ---
[7.13527403 6.72026165        nan 5.87661963 5.82264717 5.82912356
 5.39663473 5.11110623 6.86002    5.8609     6.71527    6.38532
 6.31796    5.02259    5.19181    5.95055    5.421334   5.674
 5.78715    5.0223     6.86022    5.5252     5.63189    4.75058
 6.32008    7.43006    4.77831    6.18801    5.78246    6.74973
 6.47182    5.85244    6.72917    6.74301    5.015263   5.11315
 6.11298    5.7258     6.74616    5.83621    5.84465    5.02861
 6.37705    6.883046   6.54831    5.52343    6.86252    5.86443
 6.74005    6.74013    6.1117     6.69704    4.77767    5.382799
 7.27769    6.057676   7.09261    5.86512    6.52508    7.36082
 6.787      6.73518    5.55116    7.63746    6.03545    5.9098
 6.48565    6.72979    6.87997    6.21472    6.72425    6.12233
 6.87326    7.01367    5.92909    6.875234   7.22444    7.441
 5.14087    6.69682    5.2879     6.5441     5.40012    6.3066
 6.75659    5.78186    4.76298    7.36622    6.52983    5.84583
 5.55397    5.9127     6.66153    5.50068    5.81056    7.26117
 6.7311176  7.426377   5.8225     6.749486   5.83393    6.732148
 6.73756    6.56694    6.72612    5.58347    6.28335    4.89786
 5.89924    6.72911    5.41382    5.2324     6.7224     6.7172683
 5.28478    5.10334    6.48791    5.40997    5.51432    5.89695
 5.96594    5.09587    4.77088    6.13511    5.02887    6.31545
 6.8597     5.87829    6.69637    5.3828     5.02408    5.34833
 7.3946     6.56903    6.5427     5.51235    5.05445    5.51019
 6.56384    5.48347    6.56627    4.94655    5.05498    6.81199
 6.6119     5.83192    5.60645    5.89257    5.66778    5.42085
 6.63126    6.62796    5.20003    7.00311    5.82647    6.74459
 5.18975    5.58482    6.15525    6.62072    5.61167    5.82178
 5.92283    6.3781     6.67308    6.46503    6.65349    6.00057
 6.27562    5.83292    5.93408    6.12246    5.98755    6.57323
 6.62207    6.46413    5.93173    7.01863    6.73188    6.91217
 5.36496    5.04201    6.56598    7.40316    5.99025    6.24921
 6.550084   6.57649    5.84645    7.0101     7.4119     6.50829
 6.61744    7.25405    5.2494     6.54332    6.1896     6.1723
 5.97132    5.96828    6.75866    6.11991    5.8496     5.76208
 6.246892   6.17117    6.80323    5.83622    6.8754     6.544
 5.93834    5.92578    6.61565    5.2031     5.89626    5.0605
 5.92937    5.20466    4.85312    6.27887    5.26283    7.41235
 6.93054    7.37443    6.46453    7.39408    6.21015    6.93258
 6.47413    4.94039    6.73728    6.46391    5.86095    6.19794
 6.56983    5.10753    7.26482    5.66971    5.12329    6.42426
 6.73512    5.83717    5.93067    6.61518    6.73746    6.12224
 6.8897     6.54353    5.87401    5.68804    5.51863    6.134
 7.2228     5.84633    6.73211    5.41035    6.28815    5.27395
 6.11917    6.73757    6.11794    5.30327    6.7176093  5.89505
 6.61721    7.74703    6.3082     5.89585    6.47742    6.2488
 6.62675    6.44587    5.39712    6.54155    5.85463    5.827
 6.46855    6.12283    5.23838    4.77635    4.76625    7.977078
 5.420209   4.76857    4.96398    6.74939    6.7263     6.7505
 6.263267   5.93272    4.94959    5.93062    6.22004    6.2901
 5.19911    5.57914    5.41715    6.61319    6.11019    5.2044
 5.0238     5.77776    5.0626     5.8498     6.54346    6.57566
 5.40389    6.632994   6.098987   5.39945    6.73483    6.73587
 4.773501   7.238634   7.0352     6.111883   6.76355373 6.5732
 6.73888889 6.28815    4.76092697 6.9979     5.203103   4.75629286
 6.12936519 4.75843397 6.87554613 5.0605     6.071506   6.101837
 7.374427   7.37901783 6.7333058  6.85899112 6.107021   5.414
 5.39401054 5.83064529 5.687778   4.75932076 6.88057305 5.028
 4.96082478 6.110191   6.27635647 6.0043378  7.37700982 6.48473507
 5.899244   4.76094709 4.41465671 6.12771002 5.859473   6.73512
 6.47998045 7.25239668 5.77869    7.00814125 5.1298     5.6929
 4.98999    6.13212313 5.844649   5.24588252 5.67171709 6.5242
 6.75763956 7.01053795 6.731245   5.39489331 6.726298   5.466667
 4.76906662 6.13439119 5.9536     6.676      6.72627446 5.83885
 4.767894   5.777757   6.0236     4.9567985  6.74303666 6.37937782
 5.92907976 6.56684418 7.26106892 4.765233   6.747242   6.72543715
 7.07233    5.583472   6.27400464 5.732      4.768565   7.430056
 7.00659816 5.93441495 6.543459   5.2915     6.924401   4.96120473
 6.32259348 4.94944571 4.76206668 6.87897659 5.8766721  6.87425245
 6.14005079 4.94721888 4.95719789 4.95225137 5.84596803 5.779526
 5.990246   6.81853895 5.84154    6.74738    5.500668   4.775047
 6.92565971 6.76823314 4.94895002 6.12569434 5.200028   6.8674
 5.410353   6.87974952 5.403888   6.62207    5.483477   6.6152
 6.4379     5.792314   6.57061683 4.946546   6.74459    6.61455879
 7.00623115 6.463912   6.61749763 7.26197501 5.611673   6.19818083
 6.73464067 6.74717041 5.82183507 5.89852033 4.95510734 6.137386
 6.541004   4.95095182 6.87976372 6.65349    6.429375   6.74388889
 4.94449788 5.867998   5.852441   6.743888   6.88451439 6.465032
 6.860018   5.84965444 6.629836   5.606453   6.54337487 6.57319
 6.54585    6.719049   6.56386    6.7364     6.545      5.08763
 6.738726   6.879565   4.711316   5.4439     6.288144   6.903758
 5.874375   6.5757     6.555867   6.92856    5.9315     6.870341
 5.805783   6.9696239  6.73497    4.77801    6.57778344 7.36999499
 6.55590583 5.27389272 7.96241    5.10865564 5.486898   5.1598
 7.00943038 5.86653    6.87381    4.70346    6.8737     7.4096509
 5.8219     5.51432    6.73588    7.60704    5.9270111  5.41685
 6.12818    6.127606   6.6754495  5.50084    6.619093   5.990233
 6.27568128 6.7447672  5.0541351  6.133245   7.2516635  5.7973
 5.226158   6.735326   5.505495   6.50525    6.566657   5.66965
 6.910787   6.924      6.1429     6.74556186 6.32777354 5.64355606
 6.01060985 5.82198466 5.40410279 6.55179661 6.9201677  6.38501775
 6.09938247 5.29757781 5.3483092  5.20426105 5.06494541 6.733978
 5.12460343 4.7720092  6.73919798 5.19161874 5.58374203 6.28834252
 6.78760665 5.79718525 5.8237795  5.46397724 5.67065635 6.90191532
 6.34517292 5.91587886 5.92569058 5.46093322 5.92391665 6.23670728
 6.89397681 6.60407757 5.86006933 5.38779483 4.76434    6.11031612
 6.46674414 5.11252602 4.97733306 5.44312571 5.05103249 6.64948909
 6.78233646 5.92620788 6.09583148 6.18070893 6.8426306  5.8468602
 6.124102   6.80321872 6.48772746 6.29339207 5.73683672 5.40873099
 5.79177506 5.52173459 6.10977535 5.41813793 5.85085867 6.73109932
 6.4890946  6.19986562 6.38087841 6.0749947  6.73464154 5.9323287
 6.84271592 7.11601802 5.78476526 6.89103136 5.02228957 5.68457
 6.65675    6.2364     6.5669     6.077196   5.25074    6.07783
 6.21972    5.73484    5.06677    5.24191    5.34167    6.30568
 6.62216    6.88001    6.1822     6.92852    5.57192    5.55039
 6.17389    4.94515    5.052      4.76664    5.19679    5.05236
 4.70411    5.27002    5.12453    7.238986   6.4737     6.3809
 6.42748    5.82309    6.18913    5.8458     6.11898    6.95411
 6.91706    7.03472    6.91476    5.7872     5.987522   5.782079
 5.797665   5.4169     5.8654     5.6765     5.8524     6.71835421
 7.44567    6.88334557 4.651      5.82841329 5.34199    4.94724373
 5.85209148 4.95077505 6.2034     6.627962   4.96154542 5.3568
 6.7505     6.72876854 5.118      6.13182968 6.922      6.56956768
 6.49463773 4.94633311 4.75457357 5.262833   7.1303     5.051998
 4.75329255 4.94823487 5.579143   4.75479258 6.72262447 6.73501125
 5.584824   7.42739699 5.41234    6.317      6.4252     4.76008826
 4.41651452 7.0091     4.8833341  5.12329    7.379993   6.424257
 6.48863928 6.42748458 7.4275     5.892574   6.54999837 5.522924
 6.90141489 5.785205   6.249216   5.8443349  4.95       6.7333273
 7.412353   4.75602337 5.823086   6.49169405 6.10108503 6.74492645
 6.57045542 5.409965   4.42235756 4.76142078 5.82747921 5.341667
 5.73366971 4.76170341 5.86095    5.83192    4.95106398 5.6645
 5.86443    5.39985435 5.05445    5.40711635 5.40169571 4.963975
 6.54896534 5.9256     4.95002008 5.064      6.6307     5.8478
 5.204      4.7693172  5.0445     6.613185   6.803234   6.290103
 4.75515647 6.124102   6.742222   6.38699667 4.7876     4.95565741
 4.75261924 4.75327078 6.73414891 5.87567    4.94862113 4.76956777
 5.965944   6.74528294 7.12763638 5.73410448 5.7772     6.566939
 6.57188119 4.77020385 7.34431345 6.27091454 7.40986755 4.75242197
 6.48598266 4.41300249 4.76779446 5.87401    7.251318   6.081503
 6.13335    7.4085     5.8963     5.897358   8.46596182 6.888295
 6.529845   6.75393    5.72357    6.925557   5.8781     7.355993
 6.761812   6.889892   6.315099   6.123407   7.4108     6.42964
 6.736108   5.250917   6.984775   6.87634    5.785546   7.37419
 5.98753    5.901382   5.2379     5.785447   5.8723     5.870625
 5.822349   6.871208   6.735385   6.129645   7.411638   7.959493
 7.377072   7.2625     5.10629149 5.82198466 5.5005     7.050013
 5.82693    4.70372    6.74538264 6.9117     7.38950383 4.668
 6.87978836 6.87436764 5.86653    5.925777   5.40180316 5.7662
 6.1931     6.697043   5.6699     5.40735525 6.7615     6.8708
 6.18482918 5.68804    6.728654   5.475      6.73978836 6.1859
 6.356      6.13390226 6.5473     5.6319     6.5693     7.2526
 6.7348     7.4034     6.2239     6.7473     7.4133     5.6656
 6.5489     6.5416     5.6117     6.5435     5.246      6.236
 6.19311    4.7592     5.4128     6.1198     6.2469     5.6685
 5.4299     6.12224    6.3851811  6.7953     5.0576     6.95206484
 4.755113   5.92932433 7.96448675 6.78542344]


--- DISCL_COUNTRY_NAME ---
['IVORY_COAST']


--- DISCL_YEAR ---
[  nan 2024. 2023.]


--- COMPANY ---
['LINDT SPRUNGLI' 'BARRY CALLEBAUT AG' 'NESTLE' 'PURATOS'
 'TONYS CHOCOLONELY' 'ONEM' 'ALFRED RITTER' 'FERRERO' 'CARGILL'
 'BLOMMER CHOCOLATE COMPANY' 'OFI' 'UNILEVER' 'VALRHONA' 'GODIVA VIA ONEM'
 'CEMOI VIA TRANSPARANCE COCOA' nan 'ALTER ECO' 'ETG' 'MARS' ' MARS'
 'TOUTON' 'ECOM']


--- DISCL_SUPPLIER_FULLNAME ---
["SOCIETE COOPERATIVE AVEC CONSEIL D'ADMINISTRATION BENKADI DE SIAKAKRO"
 "SOCIETE COOPERATIVE AVEC CONSEIL D'ADMINISTRATION ANOUANZE DES PRODUCTEURS DE L'INDENIE"
 "SOCIETE COOPERATIVE AGRICOLE AHUANOU D'ARRAH AVEC CONSEIL D'ADMINISTRATION"
 "SOCIETE COOPERATIVE AGRICOLE GUELANIN AVEC CONSEIL D'ADMINISTRATION"
 'SOCIETE COOPERATIVE AGRICOLE IMAAH, SOCIETE COOPERATIVE SIMPLIFIÉE'
 "SOCIETE COOPERATIVE AVEC CONSEIL D'ADMINISTRATION MOYE"
 'SOCIETE COOPERATIVE SIMPLIFIÉE RASSO'
 'SOCIETE COOPERATIVE AGRICOLE NOUVELLE DE DJOUROUTOU'
 "SOCIETE COOPERATIVE AGRICOLE N'ZASSA DE DIVO"
 'SOCIETE COOPERATIVE DES AGRICULTEURS DE WONSEA'
 'SOCIETE COOPERATIVE ENTENTE DE DJEKANOU'
 'SOCIETE COOPERATIVE DE NEGOCE CAFE CACAO DE BAYOTA'
 'SOCIETE COOPERATIVE DES MEILLEURS AGRICULTEURS DE GAGNOA'
 'SOCIETE COOPERATIVE DES PRODUCTEURS AGRICOLE DE DIVO'
 'SOCIETE COOPERATIVE DES PRODUCTEURS DE GUEYA'
 'SOCIETE COOPERATIVE SIMPLIFIÉE TIPHERET DE BLOLEQUIN'
 'SOCIETE COOPERATIVE SIMPLIFIÉE AGRICOLE DES PRODUCTEURS DE DJITEKO'
 "SOCIETE COOPERATIVE D'APPUI AUX PRODUCTEURS DE BLOLEQUIN"
 'SOCIETE COOPERATIVE DES PRODUCTEURS AGRCOLE DE KEIBLY'
 'SOCIETE COOPERATIVE SIMPLIFIÉE VICTOIRE DE LA MARAHOUE'
 'SOCIETE COOPERATIVE SIMPLIFIÉE WEND YA WENDE DE NANE'
 "CENTRE D'ACHAT HASSAN KAMEL FTOUNI (HKF6)"
 "CENTRE D'ACHAT HASSAN KAMEL FTOUNI (HKF7)"
 "CENTRE D'ACHAT HASSAN KAMEL FTOUNI (GROUPE NAWAL)"
 'SOCIÉTÉ COOPÉRATIVE DES AGRICULTEURS DE GBLÉTIA SOUBRÉ'
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE ALLAH EN DEMIN'
 'SOCIÉTÉ COOPÉRATIVE DES JEUNES PRODUCTEURS AGRICOLES DU WORODOUGOU (COOJEPAWO SCOOPS)'
 "SOCIÉTÉ COOPÉRATIVE AVEC CONSEIL D'ADMINISTRATION SOUGRI NOMAN (COOPCA SOUGRI NONMA)"
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE NOUVELLE ALLIANCE DE BANGOLO (SCOOPANAB)'
 'SOCIÉTÉ COOPÉRATIVE DES PRODUCTEURS DE CAFÉ CACAO DE TIASALÉ 1 (SCPCCT)'
 'SOCIÉTÉ COOPÉRATIVE DES AMIS DE LA NATURE DE MAN (COOPCA-COOPANAM)'
 'ENTREPRISE COOPÉRATIVE DES AGRICULTEURS DE MÉAGUI-SASSANDRA (ECAM SASSANDRA)'
 'SOCIÉTÉ COOPÉRATIVE DES PLANTEURS UNIS DE FENGOLO 2 (SCOOPUF 2)'
 "SOCIÉTÉ COOPÉRATIVE AVEC CONSEIL D'ADMINISTRATION-DJOUMAN DE KONGO KOUASSIKRO (COOP CA DJOUMAN)"
 'SOCIÉTÉ COOPÉRATIVE SUCCÈS DE TOULEPLEU (COOP CA CASUT)'
 'SOCIÉTÉ COOPÉRATIVE DE CAFÉ CACAO DE BIN-HOUYÉ (CA2CB)'
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE TARWINDPANGA DE ZEAGLO (TARWINDPAGA)'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DIEU EST GRAND DE DALEU (COOP CA DEG DALEU)'
 'COOPÉRATIVE POUR LE DÉVELOPPEMENT DE LA RÉGION DES LACS'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE GBADRIKRO DE GODEYAOKRO'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE GAGNOA'
 "SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE AGRICOLE AVENIR D'ADZOPÉ"
 'COOPÉRATIVE DES PRODUCTEURS AGRICOLE DE CACAOKRO DE DIES'
 'ENTREPRISE COOPÉRATIVE POUR LE DEVELOPPEMENT DE BONON'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE BOGNAN DE DIVO'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DU BANDAMA'
 'SOCIÉTÉ COOPÉRATIVE POUR LE BONHEUR DES PRODUCTEURS AGRICOLE DE GAGNOA'
 'UNION DES PRODUCTEURS AGRICOLES DE SAN-PÉDRO' nan
 'SOCIÉTÉ COOPERATIVE WEND BARK' 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE GBAGBAM'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE SABARY DE SAGO'
 'SOCIÉTÉ COOPERATIVE AGRICOLE DE FATOUAKRO'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE GRIHIRI 2'
 'SOCIÉTÉ AGRICOLE DE GNANPOADJI' 'SOCIETE AGRICOLE DE GRABO'
 'SOCIETE COOPERATIVE AGRICOLE DES PRODUCTEURS DE DOGBO'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE MONOGAGA CARREFOUR'
 'SOCIÉTÉ AGRICOLE COOPERATIVE DE TABOU'
 'SOCIÉTÉ COOPERATIVE AGRICOLE NIAMKEY ET FAMILLE DE L’INDENIE'
 'SOCIETÉ COOPERATIVE GARO EST DIVO'
 'COOPÉRATIVE AGRICOLE ETY-EWOUN-ANIEN DU HAUT SASSANDRA'
 'SOCIÉTÉ COOPÉRATIVE DES NOUVEAUX AGRICULTEURS DE GUEYO'
 'SOCIÉTÉ COOPERATIVE AGRICOLE POUR LA MAITRISE DE L’ENTRAIDE DURABLE'
 'SOCIETÉ COOPERATIVE DES FRERES UNIS GOBROKO'
 'ENTREPRISE COOPERATIVE DE SAINT PAUL' 'CAMAYÉ COOPERATIVE'
 'SOCIETE COOPERATIVE MAN EDI ANOUANZE'
 'COOPÉRATIVE AGRICOLE KOOGNANAN DE GROGOUYA EN ABRÉGÉ'
 "SOCIÉTÉ COOPÉRATIVE AVEC CONSEIL D'ADMINISTRATION DES AGRICULTEURS DE DAHORO"
 'SOCIÉTÉ COOPERATIVE AGRICOLE AHONTO DE L’INDENIÉ'
 'SOCIÉTÉ COPÉRATIVE AGRICOLE AMIANGOUAN DE APPROMPRONOU'
 'SOCIÉTÉ COOPERATIVE AGRICOLE AGIR POUR MAN DE DALOA'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE BARA DE BANGOLO'
 'COOPÉRATIVE AGRICOLE ANOUAZE DE SOFOCI'
 'COOPÉRATIVE AGRICOLE AWANE DE DALOA'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE BINKADI DE GUEPAHOUO'
 "SOCIÉTÉ COPÉRATIVE AVEC CONSEIL D'ADMINISTRATRATION BÉNI DE SE"
 'COOPÉRATIVE AGRICOLE POUR LE DÉVELOPPEMENT DE SASSANDRA'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DJIGUIYA DE TEAPLEU'
 'COOPÉRATIVE AGRICOLE DES MONTAGNES DE BIANKOUMA'
 'COOPERATIVE AGRICOLE LE PROGRÈS DE DUÉKOUÉ'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DES PRODUCTEURS SUCCES DE DUEKOUE'
 'COOPÉRATIVE AGRICOLE RÉFÉRENCE DE SINFRA'
 "SOCIÉTÉ COOPÉRATIVE POUR RASSEMBLEMENT ET L'EMERGENCE DU TONPKI"
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE SIBOULAKA DE BEOUA'
 'COOPÉRATIVE AGRICOLE DE VAVOUA'
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE DES JEUNES DE KAHEN'
 "SOCIÉTÉ COPÉRATIVE AGRICOLE AVEC CONSEIL D'ADMINISTRATION MODERNE DE BANG"
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE LIBERTÉ DE DANIA'
 'SOCIÉTÉ COOPÉRATIVE JEUNESSE COOPÉRATIVE AGRICOLE DE SOUROUGOU'
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIE POUR LE DÉVELOPPEMENT DE SEMIEN'
 'COOPÉRATIVE AGRICOLE EYO ENIAN DE NOUVEAU'
 'SOCIÉTÉ COPÉRATIVE AGRICOLE DE GUEYO G'
 'SOCIÉTÉ COPÉRATIVE AGRICOLE DE GNIPI 2'
 'COPÉRATIVE AGRICOLE DE COUDOUKO'
 'COOPÉRATIVE AGRICOLE HERE DE KRANZADOUGOU'
 'COOPÉRATIVE AGRICOLE DE LANSSINA BONGO'
 'COOPÉRATIVE AGRIOLE NAN ETITINOU DE KRANZADOUGOU'
 'SOCIÉTÉ COOPÉRATIVE DES AGRICULTEURS DE PETIT OUAGA'
 'SOCIÉTÉ COOPERATIVE SIMPLIFIÉE AGRICOLE LA PAIX DU HAUT-SASSANDRA'
 'COOPÉRATIVE DES PRODUCTEURS AGRICOLES DE PÉTIT DIDIEVI'
 'SOCIÉTÉ COOPÉRATIVE DES PRODUCTEURS AGRICOLES DE BANGOLO'
 "SOCIÉTÉ COOPÉRATIVE CAPRESSA AGNITIE D'APPROMPRON"
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DES PRODUCTEURS DE ZAGNE'
 'COOPÉRATIVE AGRICOLE TEEGAWENDE DE BANGOLO'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE "ALLAH KABO"'
 'SOCIÉTÉ COOPÉRATIVE IVOIRIENNE DES NOUVEAUX AGRICULTEURS'
 'SOCIÉTÉ COOPÉRATIVE DES PRODUCTEURS ANGABE DE DUEKOUE'
 'COOPÉRATIVE DES FEMMES POUR LA PRODUCTION,TRANSFORMATION ET COMMERCIALISATION DU VIVRIER DE LA MARAHOUÉ'
 'SOCIÉTÉ COOPÉRATIVE DES PRODUITS DE RENTE'
 'SOCIÉTÉ COOPÉRATIVE ECAB GUIGLO'
 'ENTREPRISE COOPÉRATIVE AGRICOLE DE BLOLEQUIN'
 'ENTREPRISE COOPÉRATIVE AGRICOLE DE KOUIBLY'
 'COOPÉRATIVE AGRICOLE KOOGNANAN DE GROGOUYA'
 'ENTREPRISE COOPÉRATIVE DES AGRICULTEURS DE MEAGUI'
 'ENTREPRISE COOPÉRATIVE AGRICOLE DES PRODUCTEURS DE CAFE-CACAO DE ROBERT-PORTE'
 'ENTREPRISE COOPÉRATIVE DES JEUNES AGRICULTEURS DE DALOA'
 'ENTREPRISE COOPÉRATIVE DE SAINT-PAUL' 'SOCIÉTÉ COOPÉRATIVE ETC TAABO'
 'SOCIÉTÉ COOPÉRATIVE FARMERS HOPE' 'HASSAN KAMEL FTOUNI SA'
 'SOCIÉTÉ COOPÉRATIVE DES JEUNES AGRICULTEURS DE VAVOUA'
 "SOCIÉTÉ COOPÉRATIVE AVEC CONSEIL D'ADMINISTRATION DES JEUNES PRODUCTEURS AGRICOLES D'ASSONVON"
 'SOCIÉTÉ COOPÉRATIVE AVEC CONSEIL D’ADMINISTRATION  DE KAKO'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE KANWORI DE YAOU'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE LANAYA DE KORHOGO'
 "SOCIÉTÉ COOPERATIVE AVEC CONSEIL D'ADMINISTRATION LE ROCHER"
 "SOCIÉTÉ COOPÉRATIVE AVEC CONSEIL D'ADMINISTRATION COOP CA NIHIPRI DE BLOLÉQUIN"
 "SOCIÉTÉ COOPÉRATIVE DES ALLIÉS DE CÔTE D'IVOIRE"
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE BINKADI DE KAHEN'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE BARAKAGNI DU HAUT SASSANDRA'
 "SOCIÉTÉ COOPÉRATIVE AGRICOLE N'ZASSA DE DIVO"
 'SOCIÉTÉ AGRICOLE DES PLANTEURS UNIS DE DAPKADOU'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE SOCOFI'
 'SOCIÉTÉ COOPÉRATIVE POUR LE BONHEUR DES PRODUCTEURS AGRICOLES DE GAGNOA'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE GLOIRE DE GUIGLO'
 'SOCIÉTÉ COOPÉRATIVE DE MÉAGUI'
 "SOCIÉTÉ COOPÉRATIVE AVEC CONSEIL D'ADMINISTRATION BINKADI DE GAGNOA"
 'SOCIÉTÉ COOPÉRATIVE DES PRODUCTEURS AGRICOLE DE BETESSO'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE NOUVELLE ALLIANCE DE BANGOLO'
 'SOCIÉTÉ COOPERATIVE ETRAYAWLEN DE LA COTIÈRE DE FRESCO'
 'SOCIÉTÉ COOPÉRATIVE DES PRODUCTEURS AGRICOLES DU ZABOUO'
 'COOPÉRATIVE AGRICOLE EMERGENTE DE DALOA'
 'SOCIÉTÉ COOPÉRATIVE ANOUANZÈ DES PETITS PRODUCTEURS DE DIDOKO'
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIE DES PRODUCTEURS DE SADA ET SECTEURS'
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIEE ESPOIR DE KOTOBI'
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE EKLOEWOU DE GBAPLEU'
 "SOCIÉTÉ COOPÉRATIVE DES PRODUCTEURS DE CAFÉ CACAO DE TIASSALÉ AVEC CONSEIL D'ADMINISTRATION"
 'SOCIÉTÉ COOPÉRATIVE DES FEMMES DYNAMIQUES'
 "SOCIÉTÉ NOUVELLE D'ACHAT DES PRODUITS AGRICOLES A LAKOTA"
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE KATANA'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE KIPIRI'
 'SOCIÉTÉ COOPÉRATIVE DES EXPLOITANTS AGRICOLES DES ANTILOPES DU HAUT SASSANDRA'
 'SOCIÉTÉ COPÉRATIVE DE NEGOCE DE LAKOTA'
 'SOCIÉTÉ COOPÉRATIVE NOUVELLE DES PRODUCTEURS AGRICOLES DE YAKASSÉ ATTOBROU'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE CAFÉ ET CACAO DE DIVO'
 'SOCIÉTÉ DE COMMERCIALISATION DES PRODUITS AGRICOLES DE DALOA'
 'SOCIÉTÉ COOPÉRATIVE DES PRODUCTEURS DE LAHOU'
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE SOLIDARITÉ DE SINFRA'
 'SOCIÉTÉ DE PRODUITS AGRICOLES DE DALOA'
 "UNION DES SOCIÉTÉS COOPÉRATIVE DE LA SOUS-PRÉFECTURE D'AYAMÉ"
 "SOCIÉTÉ COOPÉRATIVE AVEC CONSEIL D'ADMINISTRATION YEYASSO DE MAN"
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DES 2 SAMBA'
 'SOCIÉTÉ COOPÉRATIVE BENKADI DE KRAGUI'
 'SOCIÉTÉ COOPÉRATIVE AVEC CA COOPÉRATIVE AGRICOLE ANOUANZE MEAGUI'
 'SOCIÉTÉ COOPÉRATIVE DES AGRICULTEURS DE BALOKUYA'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE BAHE SEBON'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DJIDJIYA DE BLOLÉQUIN'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE ESPOIR DE ZAGNE'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE LA PAIX DE GUIGLO'
 'SOCIÉTÉ COOPÉRATIVE AVEC CA AGNITIÉ APROMPRON'
 'SOCIÉTÉ COOPÉRATIVE AGRICULTEURS SOLIDAIRES DUÉKOUÉ'
 'SOCIÉTÉ COOPÉRATIVE YÉYONIAN DE MOUSSAKRO'
 "SOCIÉTÉ COOPÉRATIVE IVOIRIENNE DES PRODUCTEURS DE L'AGNÉBY"
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE BAGRÉ'
 'SOCIÉTÉ COOPÉRATIVE BASSADOUGOU DE DIES'
 "COOPÉRATIVE DES PRODUCTEURS ASSOCIÉS DE L'AGNÉBY"
 'COOPÉRATIVE AGRICOLE DE BOIGNYKRO'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE HERE DE ZAGNE'
 'SOCIÉTÉ COOPÉRATIVE DES PRODUCTEURS AGRICOLES DE ZARANOU'
 'COOPÉRATIVE AGRICOLE ELÉPHANT DE LAKOTA)'
 'COOPÉRATIVE AGRICOLE BREDI DE BETTIÉ'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE GLIGBEUADJI'
 'COOPÉRATIVE AGRICOLE ANOUANZE DES PRODUCTEURS DE MANZANOUAN'
 'COOPÉRATIVE AGRICOLE ENTENTE'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE AVEC CA KISHWENSIDA COCHEM DIDA'
 'COOPÉRATIVE DES PLANTEURS UNIS KPATAWERE'
 'ENTENTE COOPÉRATIVE APAH-TOU DE OUPOYO AVEC CA'
 'ENTREPRISE COOPÉRATIVE AGRICOLE DE YAOKRO'
 "SOCIÉTÉ NOUVELLE COOPÉRATIVE AGRICOLE D'OUMÉ"
 'SOCIÉTÉ COOPÉRATIVE DES PRODUCTEURS DE ADAMAKOUAMEKRO'
 "COOPÉRATIVE AVEC CONSEIL D'ADMINISTRATION SIAKAKRO"
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE ENTENTE DE SONGAN'
 'COOPÉRATIVE AGRICOLE BINKADI DE YAMOUSSOUKRO'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE NOUVELLE ALLIANCE DE DIÉGONEFLA'
 'SOCIÉTÉ COOPÉRATIVE BENKADI DE JEROMEKRO'
 'SOCIÉTÉ COOPÉRATIVE POUR LE DÉVELOPPEMENT AGRICOLE DE GUITRY'
 'PRODUCTEURS DE CACAO BIOLOGIQUE DE LA MÉ'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE GNATO AVEC CONSEIL D’ADMINISTRATION (SOCAG)'
 'COOPERATIVE DES PRODUCTEURS DE YAKASSE ATTOBROU (COOPROYA)'
 'COOPERATIVE YEYONIAN DU CANTON ANIASSUE (COOPYCA)'
 'COOPÉRATIVE DES PRODUCTEURS AGRICOLES DE NIABLÉ (COOP CA PAN)'
 'COOPERATIVE AGRICOLE ZEMESS TAABA DE GBABAM (COOPAZEG)'
 "SOCIÉTÉ COOPÉRATIVE AVEC CONSEIL D'ADMINISTRATION ENTENTE DE SÉGUÉLA"
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE YEYASSO DE MAN'
 'CABES (COOPERATIVE AGRICOLE BACON ESPOIR)'
 'Societe Cooperative Simplifiee Agricole Kambonou de Arrah'
 'Société Coopérative Agricole de Gnato avec Conseil d’Administration'
 'Cooperative des Producteurs de Yakasse Attobrou'
 'Cooperative Yeyonian du Canton Aniassue'
 'Coopérative des Producteurs Agricoles de Niablé'
 "Cooperative Agricole d'Agnanfoutou"
 "Société coopérative avec Conseil d'Administration entente de Séguéla"
 'Société Coopérative Agricole de Bayota'
 'SOCIETE COOPERATIVE DES FRERES UNIS DE LA MARAHOUE'
 'SOCIETE COOPERATIVE DE CAFE CACAO IVOIRIEN'
 'SOCIETE COOPERATIVE AGRICOLE POUR LA MAITRISE DE L’ENTRAIDE DURABLE'
 'SOCIETE COOPERATIVE AGRICOLE GARO-EST DE DIVO'
 'SOCIETE COOPERATIVE AGRICOLE DES ALLIES DE COTE D`IVOIRE'
 'SOCIETE COOPERATIVE AGRICOLE DE KOBOUO'
 "SOCIETE COOPERATIVE AGRICOLE NIAMKEY ET FAMILLE DE L'INDENIE"
 'SOCIETE COOPERATIVE DES NOUVEAUX AGRICULTEURS DE GUEYO'
 'SOCIETE COOPERATIVE AGRICOLE LANAYA DE VAVOUA'
 'SOCIETE COOPERATIVE AGRICOLE DE DONHIO'
 'SOCIETE COOPERATIVE AMITIE DE GNAGBODOUGNOA'
 'SOCIETE COOPERATIVE ALLIANCE DE MABOUO'
 'SOCIETE COOPERATIVE DES NOUVEAUX AGRICULTEURS DE SOUBRE'
 'SOCIETE IVOIRIENNE DE COMMERCIALISATION DE CAFE ET CACAO'
 'ENTERPRISE COOPERATIVE DES AGRICULTEURS MODERNES DE MEAGUI'
 'SOCIETE COOPPERATIVE DE NEGOCE DE LAKOTA'
 'SOCIETE COOPERATIVE SABARIKAGNI DU HAUT SASSANDRA'
 'SOCIETE COOPERATIVE DE MEAGUI'
 'SOCIETE COOPERATIVE ANOUANZE DES PETITS PRODUCTEURS DE DIDOKO'
 'SOCIETE COOPERATIVE AGRICOLE DE TABOU'
 "SOCIETE COOPERATIVE AGRICOLE ANOUANZE D'ANIASSUE"
 'COOPERATIVE AGRICOLE DE LA REGION DU CAVALLY'
 'SOCIETE COOPERATIVE SIMPLIFIEE RADEE POUR LE DEVELOPPEMENT AGRICOLE'
 'SOCIETE COOPERATIVE AGRICOLE DE SOFOCI'
 'OCIETE COOPERATIVE AGRICOLE ENTENTE'
 'ENTREPRISE COOPERATIVE AGRICOLE FRATERNITE DU HAUT SASSANDRA'
 'SOCIETE COOPERATIVE SITA BALO DE DALOA'
 'SOCIETE COOPERATIVE AGRICOLE DE TOUIH'
 'SOCIETE IVOIRIENNE ACHAT DE PRODUIT AGRICOLE'
 'SOCIETE COOPERATIVE AAGRICOLE DIEU MERCI' 'AHONDJO'
 'BAH RAMATOULAYE CACAO' 'COOPERATIVE AGRICOLE BINKELEMAN DE BELLE-VILLE'
 'COOPERATIVE AGRICOLE ETY-EWOUN-ANIEN DU HAUT SASSANDRA'
 'COOPERATIVE AGRICOLE SIBOULAKA DE BEOUA'
 'SOCIETE COOPERATIVE AGRICOLE DE GROGBONOU DAN'
 'COOPERATIVE AGRICOLE DE LASSINA BANGO'
 'COOPERATIVE AGRICOLE DE COOPANOU'
 'SOCIETE COOPERATIVE SIMPLIFIEE AGRICOLE TOUMTOUMDA DU HAUT SASSANDRA'
 'COOPERATIVE VICTOIRE DE MEAGUI'
 'ENTERPRISE COOPERATIVE DES AGRICULTEURS DE MEAGUI'
 "SOCIETE COOPERATIVE AVEC CONSEIL D'ADMINISTRATION ESPOIR DE VAVAOUA"
 'FARMERS HOPE' 'COOPERATIVE AGRICOLE ESPOIR BLOLEQUIN'
 'SOCIETE COOPERATIVE AGRICOLE ELIE TIKPA DE DALOA' 'SCOOP-DAKUA'
 'SOCIETE COOPERATIVE DES PRODUCTEURS AGRICOLES ‘NANTABA’ DU HAUT SASSANDRA'
 'SOCIETE COOPERATIVE AGRICOLE DES FRERES UNIS DE BOUREIMAKRO'
 'SOCIETE COOPERATIVE DES AMIS DE LA NATURE DE MAN'
 'SOCIETE COOPERATIVE DES JEUNES PRODUCTEURS AGRICOLES DU WORODOUGOU'
 'SOCIETE COOPERATIVE AVEC CONSEIL D`ADMINISTRATION COOPERATIVE AGRICOLE SOUGRI NONMA'
 'SOCIETE COOPERATIVE AVEC CONSEIL D`ADMINISTRATION DES PRODUCTEURS ANGABE DE BIANKOUMAN'
 'ENTREPRISE COOPERATIVE DES AGRICULTEURS DE MEAGUI SOCIETE COOPERATIVE AVEC CONSEIL D`ADMINISTRATION'
 'COOPERATIVE AGRICOLE DES PLANTEURS UNIS DE FENGOLO'
 'SOCIETE COOPERATIVE DJOUMAN DE KONGOKOUASSIKRO'
 'SOCIETE COOPERATIVE AVEC CONSEIL D’ADMINISTRATION. COOPERATIVE AGRICOLE SUCCES DE TOULEPLEU'
 'SOCIETE COOPERATIVE AGRICOLE NOUVELLE ALLIANCE DE BANGOLO'
 'COOPÉRATIVE AGRICOLE DES FRÈRES UNIS DE GOBROKO'
 'SOCIETE COOPERATIVE AVEC CONSEIL D`ADMINISTRATION COOPERATIVE AGRICOLE DES PRODUCTEURS UNIS DE L`OUEST'
 'SOCIETE COOPERATIVE AVEC CONSEIL D’ADMINISTRATION UNITE DE DANANE'
 'SOCIETE COOPERATIVE AGRICOLE YEBOYOKON DE DAIRO-DIDIZO']


--- DISCL_VOLUMES ---
[nan]


--- DISCL_VOLUMES_UNIT ---
[nan]


--- DISCL_CERTIFICATION_PCT ---
[  nan 1807. 1091. 1270. 1119. 1087. 1143. 1867. 1454.  707.  801. 1108.
  829.  881.  876. 1069.  759. 1206. 2127.  981. 1938. 1156. 2670. 2455.
 1802. 3018. 5282. 1424.  655.  810.  721.  865. 3582. 2737. 1257. 4290.
 4106. 1510. 1457. 1153. 2248. 2788. 1047. 4666. 3603. 1599. 1010. 2479.
  546. 1317.  931. 2224. 1566.  809. 2910. 3455. 2595. 1116. 2247. 2370.
  861. 1008. 1928. 2959.  796. 5876. 2775. 1584. 1304.  830. 2044. 1462.
 1351. 2163. 1409. 1356. 2971. 1090. 1968. 3716.  663. 3566. 1134. 1400.
 1144. 1126.  540. 1669. 1341. 1089.  659. 2914. 1221. 2444. 3146. 1180.
 1176. 1025. 1368.  684. 1352. 1384. 2491. 1782. 1463. 1437.  539. 2957.
 4931. 2387. 5576. 1678. 3499. 4318. 4791. 1246. 1311. 4005. 1559. 2254.
  755. 1417. 1013. 1551. 1991. 1063. 3404. 3826. 1051.  610. 1128. 4652.
 2203.  602. 1320.  989.  399.  786. 5193. 1508. 1113. 1133. 1215. 1425.
 1586. 2223.]


--- DISTRICT_GEOCODE ---
['CI-3.1.2_1' 'CI-3.1.1_1' 'CI-6.3.2_1' 'CI-8.2.1_1' 'CI-5.2.1_1'
 'CI-9.2.2_1' 'CI-7.1.1_1' 'CI-2.3.2_1' 'CI-2.2.5_1' 'CI-6.1.4_1'
 'CI-5.1.1_1' 'CI-8.1.2_1' 'CI-8.3.1_1' 'CI-12.3.2_1' 'CI-8.2.2_1'
 'CI-7.1.4_1' 'CI-8.3.3_1' 'CI-2.1.2_1' 'CI-8.1.1_1' 'CI-8.3.5_1'
 'CI-8.2.4_1' 'CI-5.2.2_1' 'CI-7.3.1_1' 'CI-9.2.1_1' 'CI-2.3.1_1'
 'CI-9.1.1_1' 'CI-5.2.3_1' 'CI-7.3.2_1' 'CI-2.2.3_1' 'CI-9.1.2_1'
 'CI-9.2.3_1' 'CI-7.3.4_1' 'CI-6.3.3_1' 'CI-3.2.1_1' 'CI-6.3.1_1'
 'CI-8.1.4_1' 'CI-9.1.3_1' 'CI-2.2.2_1' 'CI-7.1.3_1' 'CI-8.1.3_1'
 'CI-9.1.4_1' 'CI-8.3.2_1' 'CI-7.3.3_1' 'CI-5.1.2_1' 'CI-2.1.1_1'
 'CI-2.2.1_1' 'CI-13.1.2_1' 'CI-7.2.2_1' 'CI-3.1.3_1' 'CI-6.1.2_1'
 'CI-7.1.2_1' 'CI-3.2.2_1' 'CI-11.1.1_1' 'CI-14.2.2_1' 'CI-14.2.1_1'
 'CI-6.4.1_1' 'CI-1.1.1_1' 'CI-6.2.1_1' 'CI-8.3.4_1' 'CI-12.3.1_1'
 'CI-11.1.5_1' nan]


--- CAM_BUYERS ---
[nan]


--- IS_CAM_V3 ---
[nan]


--- IS_JRC ---
[nan]


--- JRC_BUYER_ID ---
[nan]


--- DISCL_SUPPLIER_TYPE ---
['COOPERATIVE' nan]


--- DISCL_SUPPLIER_ABRVNAME_CLEANED ---
['SOCIÉTÉ AFRICAINE DE CACAO' "SUCDEN CÔTE D'IVOIRE"
 'COMPAGNIE CACAOYERE DU BANDAMA (CCB)' 'IVORY COCOA PRODUCTS (ICP)'
 'OLAM COCOA PROCESSING' 'SOCOPAD WAREHOUSE' 'AJAMI ALY WAREHOUSE'
 'CAPA WAREHOUSE' 'COOPAAAKO WAREHOUSE' 'COOPAAF WAREHOUSE'
 'COOPAGA COOP CA WAREHOUSE' 'SOCOOPENHA WAREHOUSE' 'CPAY WAREHOUSE'
 'ECAM SCOOPS WAREHOUSE' 'SCASOU WAREHOUSE' 'HKF WAREHOUSE'
 'ECOGA WAREHOUSE' 'SCAEDA WAREHOUSE' 'COOP CA NECAAYO WAREHOUSE'
 'COOP CA ABO WAREHOUSE' 'ECOAN WAREHOUSE' 'COOPRAGA SCOOPS WAREHOUSE'
 'NCATEZ WAREHOUSE' 'COOP CA SOCAGNA WAREHOUSE' 'COOPADYA WAREHOUSE'
 'SCOOPS GORY WAREHOUSE' 'SCJPAB WAREHOUSE' 'CAEMBA WAREHOUSE'
 'SNAPAL WAREHOUSE' 'CAMATIE COOP CA WAREHOUSE' 'SOCOOPAM WAREHOUSE'
 'ANZUE II COOP CA WAREHOUSE' 'SOCOSOM COOP CA WAREHOUSE'
 'SOCAKI COOP CA WAREHOUSE' 'COOPAME COOP CA WAREHOUSE'
 'SCOOPS CASD WAREHOUSE' 'SOCA IIPD WAREHOUSE' 'SOCOPAL WAREHOUSE'
 'SOCOSAM WAREHOUSE' 'SCOOP CCA WAREHOUSE' 'SCOOPS CADUD WAREHOUSE'
 'SCOOPS YANKADI WAREHOUSE' 'COOP CA PRO WAREHOUSE'
 'SCOOPAGAGBA WAREHOUSE' 'CAESI COOPCA WAREHOUSE' 'SOCOPDAL WAREHOUSE'
 'SOCONOVD WAREHOUSE' 'PHENIPRAD WAREHOUSE' 'SCOPAF DIEGONEFLA WAREHOUSE'
 'SOCOEMA WAREHOUSE' 'SOCONI WAREHOUSE' 'SOCAAB COOP CA WAREHOUSE'
 'SOCARIT COOP CA WAREHOUSE' 'KANY SCOOPS WAREHOUSE'
 'PROUCCA.AM SCOOPS WAREHOUSE' 'SCACCN SCOOPS WAREHOUSE'
 'SCOOPAT WAREHOUSE' 'S IIDV WAREHOUSE' 'WENDE COOP CA WAREHOUSE'
 'SCOOPS ANADUE WAREHOUSE' 'SCOOPAZ WAREHOUSE'
 'BARA COOP CA BIANKOUMA WAREHOUSE' 'SCEB WAREHOUSE'
 'COOPARA  SCOOPS WAREHOUSE' 'SCAW COOP CA WAREHOUSE'
 'COOP CA AHONTO WAREHOUSE' 'CEDA SCOOPS WAREHOUSE' 'SCOOP IZ  WAREHOUSE'
 'COOP CA TEEGA WENDE WAREHOUSE' 'SCOOPS CPI WAREHOUSE'
 'ECAOZOU WAREHOUSE' 'COOPAD BANGOLO WAREHOUSE' 'SCINPA WAREHOUSE'
 'SCOOPAL WAREHOUSE' 'KAKEWA COOP CA WAREHOUSE' 'LAFIBEBE WAREHOUSE'
 'CAPKO WAREHOUSE' 'SCAEK WAREHOUSE' 'SOCAT WAREHOUSE'
 'HAMAOULA WAREHOUSE' 'S IIAM WAREHOUSE' 'SOCAK COOP CA WAREHOUSE'
 'SCOOP BAG WAREHOUSE' 'UPCG WAREHOUSE' 'SOCADJA SCOOPS WAREHOUSE'
 'COADOSOV WAREHOUSE' 'SCOOPS WAF WAREHOUSE' 'SOCOOPELA WAREHOUSE'
 'SOCCACI SCOOPS WAREHOUSE' 'CAC WAREHOUSE' 'COOPRAN COOP CA WAREHOUSE'
 'SCOOPS SCODIPAC WAREHOUSE' 'SCAPAD WAREHOUSE' 'SOCAN COOP CA WAREHOUSE'
 'CAMAYE COOP CA WAREHOUSE' 'SPB WAREHOUSE' 'COOPAD WAREHOUSE'
 'COOP CA CAEB WAREHOUSE' 'SCOOPECO WAREHOUSE' 'PURAMAX WAREHOUSE'
 'DJIGUIYA WAREHOUSE' 'CADI WAREHOUSE' 'CAYAWA WAREHOUSE'
 'COOBADI WAREHOUSE' 'COOPAEB WAREHOUSE' 'COOPAFA WAREHOUSE'
 'SOCAS WAREHOUSE' 'CASABO WAREHOUSE' 'ECAMOM WAREHOUSE'
 'SCAPA AMIDOUKRO WAREHOUSE' 'COOP CA NANTEBESSOU WAREHOUSE'
 'COOPAZA WAREHOUSE' 'ECOOD WAREHOUSE' 'ECAG COOP WAREHOUSE'
 'CAWSA WAREHOUSE' 'SCAT I WAREHOUSE' 'SCOOPS SOCOPA WAREHOUSE'
 'SOCOAEK WAREHOUSE' 'USOCAS WAREHOUSE' 'SOCAZEMS WAREHOUSE'
 'UPRAD WAREHOUSE' 'QUALOG WAREHOUSE' 'SCAGREM COOP CA WAREHOUSE'
 'AZIEL SCOOPS WAREHOUSE' 'CAED WAREHOUSE' 'SOCAEK SCOOPS WAREHOUSE'
 'SCOOPS EK WAREHOUSE' 'SCASB COOP CA WAREHOUSE' 'CAEL SCOOPS WAREHOUSE'
 'SOCABD COOP CA WAREHOUSE' 'COOP CA GCT WAREHOUSE' 'NEEB NONMA WAREHOUSE'
 'ENTENTE COOP CA  WAREHOUSE' 'SCOANPA COOP CA WAREHOUSE' 'UPAS WAREHOUSE'
 'SCAEP WAREHOUSE' 'ALLAH KABO SCOOPS WAREHOUSE' 'CADESA WAREHOUSE'
 'COABOB WAREHOUSE' 'COOPAGG WAREHOUSE' 'COOPALBA COOP CA WAREHOUSE'
 'SOCOPROCY WAREHOUSE' 'COOP CA REFSI WAREHOUSE' 'SOCABB WAREHOUSE'
 'UCA WAREHOUSE' 'SCAC WAREHOUSE' 'COOPAGNIPI WAREHOUSE' 'CASMA WAREHOUSE'
 'SCOOPS SODASI WAREHOUSE' 'CANS WAREHOUSE' 'ADA WAREHOUSE'
 'CAGRAMIA WAREHOUSE' 'SCOPRODJI WAREHOUSE' 'COOPANEK WAREHOUSE'
 'SOCOOPADO WAREHOUSE' 'CPACD WAREHOUSE' 'COOPAB KO WAREHOUSE'
 'VIMA WAREHOUSE' 'ECAPR WAREHOUSE' 'SCABK WAREHOUSE'
 'SOCOOPASAHG WAREHOUSE' 'JEPRAS WAREHOUSE' 'COOP CA C IIIA WAREHOUSE'
 'SOCONEL WAREHOUSE' 'SCOOPAVI WAREHOUSE' 'SOCOOPPAK COOPCA WAREHOUSE'
 'SCED WAREHOUSE' 'SCOOPRADI WAREHOUSE' 'SCAPEN DIVO WAREHOUSE'
 'SCOOPINECC WAREHOUSE' 'SCOOPAB WAREHOUSE' 'SCOOPS SCOPG WAREHOUSE'
 'CABS WAREHOUSE' 'SCNCCB WAREHOUSE' 'RASSO WAREHOUSE'
 'COOP CA CMB WAREHOUSE' 'SCANFI SCOOPS WAREHOUSE' 'BENKADI WAREHOUSE'
 'SCAND II WAREHOUSE' 'SOCOAG COOP CA WAREHOUSE'
 'SCOOPS TIPHERET WAREHOUSE' 'SOCAMEA COOP CA WAREHOUSE'
 'ECAKOOG COOP WAREHOUSE' 'SCAW WAREHOUSE' 'COOP CA API WAREHOUSE'
 'SOCAPBLO COOP CA WAREHOUSE' 'COOPAGO COOP CA WAREHOUSE'
 'COOP CA GUELANIN  WAREHOUSE' 'WEND YA WENDE WAREHOUSE'
 'MOYE COOP CA WAREHOUSE' 'SCOEL WAREHOUSE' 'ECAB GUIGLO  WAREHOUSE'
 'IMAAH WAREHOUSE' 'SCOOP MAG WAREHOUSE' 'SCOOPS CCI WAREHOUSE'
 'SCOOPAG WAREHOUSE' 'SOCOPAT WAREHOUSE' 'SCATI WAREHOUSE'
 'NECOPRAL WAREHOUSE' 'SCOOPS APROZ WAREHOUSE' 'SCOOPAC WAREHOUSE'
 'ANOUANZE WAREHOUSE' 'BINKADI WAREHOUSE' 'CAAG WAREHOUSE'
 'CABZOU WAREHOUSE' 'CEXPAG WAREHOUSE' 'COOPAAD WAREHOUSE'
 'SCOOPALO WAREHOUSE' 'CPM WAREHOUSE' 'SCOOPADOB WAREHOUSE'
 'EWOUNBO WAREHOUSE' 'SOCOOPAK WAREHOUSE' 'SCAPEN WAREHOUSE'
 'COOANZUE WAREHOUSE' 'ECADA WAREHOUSE' 'SCANDI WAREHOUSE'
 'COPACOL WAREHOUSE' 'CAYEM WAREHOUSE' 'COFUMA WAREHOUSE'
 'SCOAVA WAREHOUSE' 'SOCABA  WAREHOUSE' 'CABAK VAVOUA WAREHOUSE'
 'SOCAPROZ WAREHOUSE' 'CALBO WAREHOUSE' 'SCOES WAREHOUSE'
 'LAFILA BOUMBOU WAREHOUSE' 'COOTIEN OULA WAREHOUSE' 'COOPINA WAREHOUSE'
 'SOCABA WAREHOUSE' 'COOJAB WAREHOUSE' 'ECAB WAREHOUSE'
 'CASIB COOP CA WAREHOUSE' 'SOCAFU CA WAREHOUSE' 'SOCAD SCOOPS WAREHOUSE'
 'SCAT WAREHOUSE' 'ECOPAS COOP CA WAREHOUSE' 'LE PROGRES WAREHOUSE'
 'SCOOPS PAZ WAREHOUSE' 'SCAN WAREHOUSE' 'SCOOPAAT SCOOPS WAREHOUSE'
 'PASI WAREHOUSE' 'ALLAKABO WAREHOUSE' 'SOCOCCI WAREHOUSE'
 'SOCOEXPAHS WAREHOUSE' 'SOCABANCO WAREHOUSE' 'SOCOOPLAGUE WAREHOUSE'
 'SCOOPS  IIAP WAREHOUSE' 'CAREA SCOOPS WAREHOUSE' 'EM COOP CA WAREHOUSE'
 'SCAP CC WAREHOUSE' 'SCOOPS EKLOEWOU WAREHOUSE' 'C IIAS WAREHOUSE'
 'SCAOD SCOOPS WAREHOUSE' 'SIPAG COOP CA  WAREHOUSE'
 'SCOOPS SCAG WAREHOUSE' 'SCOOPS SPC WAREHOUSE' 'SCOOPS CI WAREHOUSE'
 'CABID II WAREHOUSE' 'SCJPAB I WAREHOUSE' 'SOCOOPAT WAREHOUSE'
 'SCOOPAM WAREHOUSE' 'COOP CA JST WAREHOUSE' 'SCAPAO WAREHOUSE'
 'SCOOPNIA WAREHOUSE' 'SCOOPS CAPA WAREHOUSE' 'UPB WAREHOUSE'
 'SOCOBIT WAREHOUSE' 'SCOOPS ASBK WAREHOUSE' 'SCPLB WAREHOUSE'
 'COOPAWD WAREHOUSE' 'SCALA  SCOOPS WAREHOUSE'
 'SCOOPASAB COOP CA WAREHOUSE' "SOCAAN M'BATTO WAREHOUSE"
 'SCOOPEG  WAREHOUSE' 'SOCOBAD WAREHOUSE' 'CAFUGO WAREHOUSE'
 'SOGAD WAREHOUSE' 'ECEAGN WAREHOUSE' 'YARA ESPOIR WAREHOUSE'
 'CAEPOG WAREHOUSE' 'CA IIS CA WAREHOUSE' 'COOPCA AB WAREHOUSE'
 'CABA WAREHOUSE' 'CAPRESSA WAREHOUSE' 'CASODU WAREHOUSE'
 'CAYEMOS WAREHOUSE' 'CIPA  WAREHOUSE' 'COAB COOP.CA WAREHOUSE'
 'COOPAA WAREHOUSE' 'COOPAHZ WAREHOUSE' 'SCOOPANAD WAREHOUSE'
 'COOPEN WAREHOUSE' 'COOPAKCODI WAREHOUSE' 'COOP CA BENKRA WAREHOUSE'
 'COOP CA ECOOYA WAREHOUSE' 'SCOOPS ES WAREHOUSE' 'COOPAGLI WAREHOUSE'
 'COPUK WAREHOUSE' 'ECAO WAREHOUSE' 'COOPABOIGNY WAREHOUSE'
 'SCOOPA CA WAREHOUSE' 'CAPG WAREHOUSE' 'CADB WAREHOUSE'
 'COOP CA CAAM WAREHOUSE' 'ECAFHS WAREHOUSE' 'CAYAT WAREHOUSE'
 'CPSL WAREHOUSE' 'PMB WAREHOUSE' 'CAG WAREHOUSE'
 'IVOIRE GUEMON WAREHOUSE' 'SOCOB WAREHOUSE' 'BADEMAYA WAREHOUSE'
 'SCARET WAREHOUSE' 'SCASPAG WAREHOUSE' 'ECABEZOU' 'SCAND'
 'SCAOD WAREHOUSE' 'SCJPAB 1' 'COOP.AL' 'COOPAM' 'SPC WAREHOUSE'
 'SOCABANCO' 'SOCAPROS' 'SOCBAD' 'BECIDA' 'BECIDA Tle' 'BMC VAVOUA'
 'COADOSOV' 'SCAFRA' 'CAAB' 'SCOOPABL' 'SPAD MAN' 'CAN' 'COOPAAHS'
 'SPAD DUEKOUE' 'COOP-CA SCAPEKO' 'COOP-CA SCARDI' 'COOP-CA SECA'
 'COOP-CA SOCADAG' 'COOP-CA CAPKA' 'CAG' 'MIE.SA' 'COOPES WAREHOUSE'
 'SCALO COOP-CA' 'SCBG-COOP-CA (GALEBRE)' 'ECAESB COOP-CA' 'SCOOPAS'
 'SOCAMA' 'SCAB' 'SOCOOPEM' 'USCRG COOP-CA' 'UCODEL COOP-CA' 'AHONDJO'
 'COOPAK' 'SI3C' 'COOP-CA-UDAN' 'CAF' 'COOPANBAK' 'ECEPAG'
 'COOP-CA SCAPUD' 'SOCAG COOP-CA' 'SOCAYA' 'SOCOOPA' 'COOP-CA SCPAB'
 'SCOOPAD COOP-CA' 'CAAA' 'CADEDO' 'CAEG' 'CAMOBIAN' 'CANK'
 'CAPA COOP-CA WAREHOUSE' 'CAPB' 'CAPM' 'CEMA' 'SCOABIA WAREHOUSE'
 'COOPAGO' 'COANI' 'CAS' 'COOPACA' 'COOPADEF' 'COOPAGARO' 'COOPAGES'
 'COOPAHK' 'COOPRADI' 'ECOPADI WAREHOUSE' 'SCAANIAS' 'SCAM' 'COOP CA AB'
 'ASAG' 'ECCO' 'AKY' 'COOP BAD' 'COOPARAB COOP-CA' 'SINIKAN-SCOOPAS'
 'SOCANOVA' 'COOP-CA SOLIDARITE' 'SCAPAO' 'SOCAD' 'SPAD GUIGLO'
 'SPAD SOUBRE' 'BARRA GABIADJI' 'cnb' 'DJIGUIYA' 'SCAPD' 'SOCBPI'
 'CA2S-CA WAREHOUSE' 'CATEZ WAREHOUSE' 'COOPRAMA CA' 'SCAPK COOP-CA'
 'COOPAC COOP-CA' 'SOCAET2' 'SCOOWEND WAREHOUSE' 'SCAGB' 'SOCASS COOP-CA'
 'COOP-CA SCAK' 'COOP-CA SOCAGRI' 'COOP-CA CAGNAN' 'CANG'
 'SOCOAMO COOP-CA' 'SCANFI' 'SCOOPAGED' 'COAB WAREHOUSE'
 'COOP-CA NACOOPAG' 'CAMED' 'CAFUGO' 'COOP-CA ECSP' 'MOAYE COOP-CA'
 'SOCAMEA WAREHOUSE' 'ECAKOOG WAREHOUSE' 'ECAM' 'ecojad' 'SOCOOPACDI'
 'COOP-CA DJOUMAN' 'CASIB COOP-CA' 'sicopag' 'COOP-CA AHONTO WAREHOUSE'
 'SOCADA-CA WAREHOUSE' 'SOCA2PD WAREHOUSE' 'COOPERATIVE' 'COOPAG' 'COODIG'
 nan 'AMIANGOUAN' 'APM Daloa' 'COOPARA' 'C2AS WAREHOUSE' 'CAADA COOP-CA'
 'CAAM WAREHOUSE' 'CADT' 'SOCOPADOGBO' 'CAZA' 'CAET' 'cava' 'CJPK' 'CAMB'
 'COOPADES' 'COOPAEEN' 'COOPALBA' 'COOPAO' 'COOPAPAIX HS' 'coopapedi'
 'COOP TEEGA WENDE' 'AKK' 'COVIMA' 'cpr-canaan' 'ECAB GUIGLO WAREHOUSE'
 'ECABLO' 'ECAKO' 'COOP-CA ETC TAABO' 'FAHO' 'HKF NAWA' 'JAVA' 'KAKO'
 'COOP-CA KANWORI DE YAOU' 'COOP-CA LANAYA' 'coop-ca le rocher'
 'COOP-CA NIHIPRI DE BLOLEQUIN (CNB)' 'SCAACI' 'SCALAVA' 'COOP-CA SCAPEN'
 'SCAS' 'SCBPAG WAREHOUSE' 'SCOAGG COOP-CA' 'SECOM WAREHOUSE'
 'SCOOP BINKADI GA' 'COOPAB' 'SCANT' 'COOPRAS' 'COOPEK' 'EKLOEWOU'
 'SCPCCT-CA' 'SFED' 'SOCAK KATANA COOP-CA' 'SOCAKI COOP-CA'
 'SOCEADAHS COOP-CA' 'SOCONPAYAT COOP-CA' 'SOCOPLA COOP-CA' 'SODASI'
 'SPAD Daloa' 'SPAD Gagnoa' 'YEYASSO' 'SCAPMB' 'YANKADI' 'CEAA COOP-CA'
 'CADB BLOLEQUIN' 'COOP-CA LAG' 'COOPAOU' 'COOPUF' 'MINDOBIE' 'CAFUC'
 'CAL2B' 'CAPROBLO' 'RASSO' 'SOCOPAS' 'COOPAD_DUEKOUE' 'COOPANAM'
 'ECAFHS-COOP.CA' 'CABID WAREHOUSE' 'ECAG-COOP WAREHOUSE' 'SAMA HS '
 'SOCOS' 'COOP-CA CABF' 'SCJPAB1' 'SCOOPS-ECAPG(LAKOTA)'
 'COOP-CA MONT BIAN' 'SOCOPA' 'SCOOPS- COASABANA' 'KRIHIRI'
 'AGRIAL COOP-CA' 'NOCOOPASI' 'CABEN' 'EKO' 'COOPASO'
 'SCOOPS-EDIFIE-DOUKOUYA' 'COOPAWEB' 'ECEAGN COOP-CA' 'COOP CAES' 'ECOAB'
 'CANWG' 'COOP-CA-REJA' 'KGS COOP-CA' 'SOCAREBIA COOP-CA' 'COOPYMA'
 'SCAEG' 'SCOSOD COOP-CA' 'COOP-CA CPSL' 'COOP-CA CSC' 'COOP-CA SCPS'
 'SOCABEN COOP-CA' 'COOP-CA SOUHONTA-KAKO' 'COOPADI' 'SOCOOPENHA'
 'COOPABE' 'COOPEBIA-CA' 'SCOOPAKOF COOP-CA' 'SOCOOPAG' 'AGBS COOP-CA'
 'COOPABENKADI' 'COOFRADO-COOP-CA' 'COOP-CA CPB' 'COOP-CA SOCANC'
 'SOCARL COOP-CA' 'SOCOOPALAO' 'COOPADOU' 'COOP-CA CABD (DOUGBO)'
 'COOP-CA ECATAMEA' 'COOPAGAGNY' "COOP-CA YAWOUBE D'ANIASSUE"
 'SOCAAN COOP-CA' 'kanwori' 'COOPAAPROMAN' 'COOPAGREL' 'SOCODAG COOP-CA'
 'BENKADI COOP-CA' 'COOP-CA COASI' 'CASO' 'SCOPAYO' 'ECAPA GZ COOP-CA'
 'COOP-CA BB' 'CABD' 'SCINPA' 'COOPAMA' 'COOP-CA ANONKLON' 'ECAFHS'
 'COOPAGA WAREHOUSE' 'COOPAN' 'CAADI COOP-CA' 'SICAO' 'CAREF SI' 'CIPACC'
 'ECOOPAK' 'ABOKA' 'COOPADO' 'AGRIOBIO' 'CEDA' 'SNCC ' 'SCODEMA COOP-CA'
 'CAC' 'COOP-CA COANGNA' 'CATBK' 'COOPASM' 'SCAEPGY' 'COOP-CA SOCOSADA'
 'BADEMAYA' 'COOPATESA' 'SCAAO' 'COOPAKAM' 'SOCAHI' 'SOCOOPELA' 'SOCOPEK'
 'NAWA1' 'SCOOPNAS' 'SOCAGS' 'CAYSI' 'CAAA SAND BOX' 'CAABRO SAND BOX'
 'CAAN' 'CAAN SAND BOX' 'CABA SAND BOX' 'CABES' 'CABES SAND BOX' 'CABG'
 'CAGB' 'CABGB SAND BOX' 'CABID SAND BOX' 'CABING SAND BOX' 'CABOHGA'
 'CAC SAND BOX' 'CADA' 'CADA SAND BOX' 'CADB SAND BOX' 'CADEDO SAND BOX'
 'CADT SAND BOX' 'CAEG SAND BOX' 'CAL2B SAND BOX' 'SOCAB COOP-CA'
 'CAMAP SAND BOX' 'CAMOBIAN SAND BOX' 'CANK SAND BOX' 'CAPA SAND BOX'
 'CAPB SAND BOX' 'CAL' 'CAPL SAND BOX' 'CAPO SAND BOX' 'CAPRESSA SAND BOX'
 'CAPROD SAND BOX' 'CARET SAND BOX' 'CASODU SAND BOX' 'CATBK SAND BOX'
 'CEDA SAND BOX' 'CIPACCA SAND BOX' 'CJPK SAND BOX' 'CNAD' 'CNAD SAND BOX'
 'COABIA SAND BOX' 'COAKA' 'COAKA SAND BOX' 'COAM' 'COAM SAND BOX'
 'CODERLACS' 'CODERLACS SAND BOX' 'COESAG' 'COESAG SAND BOX' 'COOPAAB'
 'COOAAB SAND BOX' 'COOBADI SAND BOX' 'COOPABOTE' 'ABOTRE SAND BOX'
 'ANZUE II' 'ANZUE II SAND BOX' 'COOP-CA BIRBA' 'BIRBA SAND BOX'
 'COANI SAND BOX' 'COOPAA SAND BOX' 'ESPOIR COOP-CA' 'ESPOIR SAND BOX'
 'GCT' 'GCT SAND BOX' 'KWS' 'KWS SAND BOX' 'NOBIELTO' 'NOBIELTO SAND BOX'
 'WEND SONGDA' 'CAES SAND BOX' 'JCAS SAND BOX' 'TEEGA WENDE SAND BOX'
 'CAGNAN SAND BOX' 'COANGNA SAND BOX' 'COOPABI' 'COOPABIN SAND BOX'
 'COOPADO SAND BOX' 'NECAB SAND BOX' 'ABO WAREHOUSE' 'CABS SAND BOX'
 'COOP-CA-PAN' 'PAN SAND BOX' 'UDAN SAND BOX' 'COOPABENKADI SAND BOX'
 'COOPADEF SAND BOX' 'COOPAGARO SAND BOX' 'COOPAGES SAND BOX'
 'COOPAGO SAND BOX' 'COOPAHK SAND BOX' 'COOPALBA SAND BOX' 'COOPAMDI'
 'COOPAMDI SAND BOX' 'COOPANAM SAND BOX' 'COOPAOU SAND BOX'
 'COOPASM SAND BOX' 'COOPATESA SAND BOX' 'COOPAYAF' 'COOPAYAF SAND BOX'
 'COOPAZA SAND BOX' 'COOPAZEG' 'COOPAZEG SAND BOX' 'COOPINA SAND BOX'
 'COOPRADI SAND BOX' 'COOPRAS SAND BOX' 'COOPRAZO' 'COOPRAZO SAND BOX'
 'COOPROYA' 'COOPROYA SAND BOX' 'COOPYCA' 'COOPYCA SAND BOX' 'CP2A'
 'CP2A SAND BOX' 'CPACD SAND BOX' 'CAPI-COOP-CA' 'CPSL SAND BOX'
 'SCPCCT 2' 'ECAAF SAND BOX' 'ECAB SAND BOX' 'ECAESB SAND BOX'
 'COOP-CA-ECAMOG' 'ECAMOG SAND BOX' 'ECODEBO' 'ECODEBO SAND BOX'
 'ECOOPAK SAND BOX' 'ECOPADI SAND BOX' 'ECOPAS COOP-CA WAREHOUSE'
 'ECOPAS SAND BOX' 'ECSP PURATOS' 'ECSP SAND BOX' 'FLRI COOPADIM'
 'FLRI NANTEBESSOU' 'FLRI SOCAMA' 'Ecookim - CAVA' 'IQJ SAND BOX'
 'LAFI BEBE DE MAN' 'LE PROGRES SAND BOX' 'NWK' 'NWK SAND BOX' 'COOPADIAS'
 'S COOPRADA SAND BOX' 'SAND BOX SCAAO' 'SAND BOX SCAB' 'SAND BOX SCAGG'
 'SAND BOX SCAPCC' 'SAND BOX SCAPUD' 'SAND BOX SCASOU' 'SAND BOX SCOAPANI'
 'SAND BOX AC' 'SAND BOX ASG' 'SAND BOX SCSPA' 'SAND BOX SINIKAN AS'
 'SAND BOX SOCAEK' 'SANS BOX LAFI BEBE DE MAN' 'SCAACI SAND BOX'
 'SCAANIAS SAND BOX' 'COOPANAM (Ex EDY)' 'SCABK SAND BOX' 'SCABODI'
 'SCABODI SAND BOX' 'SCAC SAND BOX' 'SCAEG SAND BOX' 'SCAGB SAND BOX'
 'SCAGG' 'SCAK SAND BOX' 'SCAM SAND BOX' 'SCAND SAND BOX' 'SCANG SAND BOX'
 'COPAL' 'SCAPD SAND BOX' 'SCAPEKO SAND BOX' 'SCARDI SAND BOX'
 'SCBPAG SAND BOX' 'COOP-CA SCELA' 'SCO SACI' 'SCO SACI SAND BOX' 'COAANI'
 'SCOWWASI' 'SCOAWWASI SAND BOX' 'CAYEM SAND BOX' 'A CA SAND BOX'
 'A SAND BOX' 'AAS SAND BOX' 'CADJI' 'ADJI SAND BOX' 'AKAM SAND BOX'
 'Olakoko' 'AKOKO SAND BOX' 'COOPAT' 'ECO SAND BOX' 'COOP-CA-3A'
 'ABOKA SAND BOX' 'AGRIBIO' 'AGRIBIO SAND BOX' 'AKY SAND BOX'
 'AL SAND BOX' 'COOPASAM SAND BOX' 'COOP-CA EPUG' 'EPG SAND BOX' 'JST'
 'JST SAND BOX' 'LA PAIX' 'LA PAIX SAND BOX' 'SCAG SAND BOX'
 'SCAT 1 WAREHOUSE' 'COOP-CA SCAG' 'SCSAG SAND BOX' 'SCC COOP-CA'
 'SNCC SAND BOX' 'WEBE' 'WEBE SAND BOX' 'YAT SAND BOX' 'AH' 'AH SAND BOX'
 'APRAB SAND BOX' 'CODEMA SAND BOX' 'LTDV' 'LTDV SAND BOX'
 'UPRAD SAND BOX' 'SCOOWEND SAND BOX' 'SCAA CI' 'SCUW COOP-CA'
 'SCUW SAND BOX' 'SOCNAD' 'SOCCNA SAND BOX' 'SOCOSADA SAND BOX'
 'SOCOAMO SAND BOX' 'SOCABA SAND BOX' 'SOCABB SAND BOX' 'COOP-CA SOCADJO'
 'SOCADJO SAND BOX' 'SOCAEK' 'SOCAG SAND BOX' 'CA2B' 'SOCAGNIPI SAND BOX'
 'SOCAGRI2 SAND BOX' 'SOCAHI SAND BOX' 'SOCADJA COOP-CA WAREHOUSE'
 'SOCAJ SAND BOX' 'SOCOOPELA SAND BOX' 'SOCOPADOGBO SAND BOX'
 'SOCOPADOU SAND BOX' 'ASANKRAGWA' 'SOCOPEK SAND BOX' 'SOCOOM'
 'SOCOSOM SAND BOX' 'UPAS SAND BOX' 'CAFUVA' 'INCHALA' 'COOP-CA BENKRA'
 'CAB WAREHOUSE' 'CAPG GUIGLO' 'CINPA' 'COOPAZ' 'COOP-CA-ECOOYA WAREHOUSE'
 'NOCAO OUME' 'COOPANAD WAREHOUSE' 'CAPEDIG PART OF ECOOKIM' 'ECOODI'
 'CPAGB-COOP-CA WAREHOUSE' 'SCPCB' 'ECAPN' 'SCAP-CC' 'RELUAINDE COOP CA'
 'SCOOPRAH' 'SOCOPASG' 'COOP PUSAH' 'COOPAME' 'PS' 'COOP-CA-PRO'
 'SCOOPAGEA' 'AJAMI ALY' 'PAI' 'SCOOPAUDD' 'SOCOOPAKOKO' 'SAPO' 'SCCG'
 'SCOODJIBODI COOP CA' 'TEPA' 'APROCAO' 'DAKUA' 'IZ' 'PAK COOP-CA' 'MOYE'
 'SOCAFAK CA' 'SOCACHIPOLO-COOP-CA' 'FOUNDARA' 'SCEG1 ' 'COOP-CA CPAC'
 'COOP-CA PAZ' 'COOJEPAWO ' 'SOCOPGA' 'KYGNON' 'SCOOPS LAFI BEBE'
 'LA GLOIRE' 'ASAВ СООР СА' 'NCB' 'COOP-CA SCAP' 'CALZB' 'HAMAOULA' 'NWM'
 'SONAB' 'WEND SONGODO' 'JPAB' 'PCBM' 'APM Benianssou' 'APM Man' 'CABK 1'
 'CABK 2' 'CAED Daloa' 'CAED GUIGLO' 'CAEDU' 'CAOSI' 'CAREBO' 'CASB'
 'CNEK' 'COAM DALOA A' 'COAM BONON' 'CODERLACS TOUMODI' 'COAM DALOA B'
 'EYENIAN' 'ESPÉRANCE AAB' 'SICA' 'NOUR' 'SCAGB BLOMMER' 'SCOAG' 'AB B'
 'SCOPACI' 'SCPCCT 1' 'SPAD Daloa 1' 'SPAD Daloa 2' 'SPAD SEGUELA'
 'SPAD VAVOUA' 'ZAGTOULI' 'BENKADI COOPS'
 "Société Coopérative Espoir d'Alepé" 'WINPAS' 'Ecookim - COOPAPIG'
 'EBO-YEKON' 'RADEE TRADING' 'SOCADMV' 'ESPOIR VAVOUA' 'SOCOOPRANHS'
 'SIVAP' 'PLAZA GAGNOA' 'COOP-CA SOCAM' 'COOP-CA ECATIE' 'SCAW MAN'
 'Société Coopérative avec conseil d’Administration Nainere de Gnato'
 'CALTDV' 'APM GAGNOA'
 'SOCIETE COOPERATIVE DES PRODUCTEURS DE YAKASSE-ATTOBROU'
 "SOCIETE COOPERATIVE YEYONIAN DU CANTON D'ANIASSUE"
 "Société Coopérative avec Conseil d'Administration des Producteurs Agricoles de Niablé"
 'COOPAYAAF' 'SOCIETE COOPERATIVE AGRICOLE ZEMESS TAABA DE GBAGBAM'
 "Société Coopérative Agricole avec Conseil d'Administration Entente de Seguela"
 'Société Coopérative Yeyasso de Man' 'WAGAJACA' 'SCOOPSYAT'
 'COOPERATIVE AGRICOLE BACON ESPOIR' 'ECYG-COOP-CA' 'CAYSI '
 'NOUVELLE SCOOPRANYD COOP-CA' 'COOP-CA ZRANSSA' 'SOCA BANCO WAREHOUSE'
 'SOCOFUMA' 'NAG ' 'CAREVA' 'RADEE' 'CAP VA' 'BARACACAO' 'COOPAGRO'
 'COOPANOU' 'COVIMEA' 'SCAEB-COOP-CA' 'SCAFUB' 'COOPAAM SCOOPS'
 'SOUGRI-NONMA' 'ECAM SASSANDRA' 'CASUT' 'COOP-CA-CAPUO' 'YEBOYOKON ']


--- DISCL_SUPPLIER_FULLNAME_CLEANED ---
['SOCIETE COOPERATIVE BENKADI DE SIAKAKRO'
 "SOCIETE COOPERATIVE ANOUANZE DES PRODUCTEURS DE L'INDENIE"
 "SOCIETE COOPERATIVE AGRICOLE AHUANOU D'ARRAH"
 'COOPERATIVE AGRICOLE TELIN'
 'COOPERATIVE AGRICOLE IMAAH, COOPERATIVE SIMPLIFIÉE'
 "COOPERATIVE AVEC CONSEIL D'ADMINISTRATION MOYE"
 'COOPERATIVE SIMPLIFIÉE RASSO'
 'SOCIETE COOPERATIVE AGRICOLE NOUVELLE DE DJOUROUTOU'
 "SOCIETE COOPERATIVE AGRICOLE N'ZASSA DE DIVO"
 'SOCIETE COOPERATIVE DES AGRICULTEURS DE WONSEALY'
 'SOCIETE COOPERATIVE ENTENTE DE DJEKANOU'
 'SOCIETE COOPERATIVE DE NEGOCE CAFE CACAO DE BAYOTA'
 'COOPERATIVE DES MEILLEURS AGRICULTEURS DE GAGNOA'
 'COOPERATIVE AGRICOLE DES PRODUCTEURS DE DIVO'
 'COOPERATIVE AGRICOLE DES PRODUCTEURS DE GUEYO'
 'COOPERATIVE SIMPLIFIÉE TIPHERET DE BLOLEQUIN'
 'SOCIETE COOPERATIVE SIMPLIFIEE AGRICOLE DES PRODUCTEURS DE DJITEKO'
 "COOPERATIVE D'APPUI AUX PRODUCTEURS DE BLOLEQUIN"
 'SOCIETE COOPERATIVE DES PRODUCTEURS AGRICOLES DE KEIBLY'
 'COOPERATIVE SIMPLIFIÉE VICTOIRE DE LA MARAHOUE'
 'COOPERATIVE SIMPLIFIÉE WEND YA WENDE DE NANE'
 "Centre d'Achat Hassan Kamel Ftouni"
 'Société Coopérative des Agriculteurs de Soubré'
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE ALLAH EN DEMIN'
 'SOCIÉTÉ COOPÉRATIVE DES JEUNES PRODUCTEURS AGRICOLES DU WORODOUGOU (COOJEPAWO SCOOPS)'
 "SOCIÉTÉ COOPÉRATIVE AVEC CONSEIL D'ADMINISTRATION SOUGRI NOMAN (COOPCA SOUGRI NONMA)"
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE NOUVELLE ALLIANCE DE BANGOLO (SCOOPANAB)'
 "Société Coopérative des Producteurs de Café Cacao de Tiassalé avec Conseil d'Administration"
 'SOCIÉTÉ COOPÉRATIVE DES AMIS DE LA NATURE DE MAN (COOPCA-COOPANAM)'
 'ENTREPRISE COOPÉRATIVE DES AGRICULTEURS DE MÉAGUI-SASSANDRA (ECAM SASSANDRA)'
 'SOCIÉTÉ COOPÉRATIVE DES PLANTEURS UNIS DE FENGOLO 2 (SCOOPUF 2)'
 "SOCIÉTÉ COOPÉRATIVE AVEC CONSEIL D'ADMINISTRATION-DJOUMAN DE KONGO KOUASSIKRO (COOP CA DJOUMAN)"
 'SOCIÉTÉ COOPÉRATIVE SUCCÈS DE TOULEPLEU (COOP CA CASUT)'
 'SOCIÉTÉ COOPÉRATIVE DE CAFÉ CACAO DE BIN-HOUYÉ (CA2CB)'
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE TARWINDPANGA DE ZEAGLO (TARWINDPAGA)'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DIEU EST GRAND DE DALEU (COOP CA DEG DALEU)'
 'Coopérative pour le Développement de la Région des Lacs'
 "Sociéte Coopérative Avec Conseil d'Administration Agricole Gbadrikro de Godeyaokro"
 'Société Coopérative Agricole de Gagny'
 "SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE AGRICOLE AVENIR D'ADZOPÉ"
 'Coopérative des Producteurs Agricoles de Cacaokro de Dies'
 'ENTREPRISE COOPERATIVE POUR LE DEVELOPPEMENT DE BONON'
 'Société Coopérative Agricole de Boua'
 'Société Coopérative Agricole du Bandaman'
 'Société Coopérative pour le Bonheur des Producteurs Agricole de Gagnoa'
 'Union des Producteurs Agricoles de San Pedro' nan
 'SOCIÉTÉ COOPERATIVE WEND BARK' 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE GBAGBAM'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE SABARY DE SAGO'
 'SOCIÉTÉ COOPERATIVE AGRICOLE DE FATOUAKRO'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE GRIHIRI 2'
 'SOCIÉTÉ AGRICOLE DE GNANPOADJI' 'SOCIETE AGRICOLE DE GRABO'
 'COOPERATIVE AGRICOLE DES PRODUCTEURS DE DOGBO'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE MONOGAGA CARREFOUR'
 'SOCIÉTÉ AGRICOLE COOPERATIVE DE TABOU'
 'SOCIÉTÉ COOPERATIVE AGRICOLE NIAMKEY ET FAMILLE DE L’INDENIE'
 'SOCIETÉ COOPERATIVE GARO EST DIVO'
 'COOPÉRATIVE AGRICOLE ETY-EWOUN-ANIEN DU HAUT SASSANDRA'
 'Société Coopérative des Agriculteurs de Gnato'
 'SOCIÉTÉ COOPERATIVE AGRICOLE POUR LA MAITRISE DE L’ENTRAIDE DURABLE'
 'SOCIETÉ COOPERATIVE DES FRERES UNIS GOBROKO' 'COOPERATIVE DE SAINT PAUL'
 'CAMAYÉ COOPERATIVE' 'SOCIETE COOPERATIVE AGRICOLE MAN EDI ANOUANZE'
 'COOPÉRATIVE AGRICOLE KOOGNANAN DE GROGOUYA EN ABRÉGÉ'
 'KAPATCHIVA COOP-CA' 'ESCOPAG COOP-CA'
 "SOCIÉTÉ COOPÉRATIVE AVEC CONSEIL D'ADMINISTRATION DES AGRICULTEURS DE DAHORO"
 'SOCIÉTÉ COOPERATIVE AGRICOLE AHONTO DE L’INDENIÉ'
 'SOCIÉTÉ COPÉRATIVE AGRICOLE AMIANGOUAN DE APPROMPRONOU'
 'SOCIÉTÉ COOPERATIVE AGRICOLE AGIR POUR MAN DE DALOA'
 'Société Coopérative Agricole Bara de\nBangolo'
 'COOPÉRATIVE AGRICOLE ANOUAZE DE SOFOCI'
 'COOPÉRATIVE AGRICOLE AWANE DE DALOA'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE BINKADI DE GUEPAHOUO'
 "SOCIÉTÉ COPÉRATIVE AVEC CONSEIL D'ADMINISTRATRATION BÉNI DE SE"
 'COOPÉRATIVE AGRICOLE POUR LE DÉVELOPPEMENT DE SASSANDRA'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DJIGUIYA DE TEAPLEU'
 'COOPÉRATIVE AGRICOLE DES MONTAGNES DE BIANKOUMA'
 'COOPERATIVE AGRICOLE LE PROGRÈS DE DUÉKOUÉ'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DES PRODUCTEURS SUCCES DE DUEKOUE'
 'COOPÉRATIVE AGRICOLE RÉFÉRENCE DE SINFRA'
 "SOCIÉTÉ COOPÉRATIVE POUR RASSEMBLEMENT ET L'EMERGENCE DU TONPKI"
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE SIBOULAKA DE BEOUA'
 'COOPÉRATIVE AGRICOLE DE VAVOUA'
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE DES JEUNES DE KAHEN'
 "SOCIÉTÉ COPÉRATIVE AGRICOLE AVEC CONSEIL D'ADMINISTRATION MODERNE DE BANG"
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE LIBERTÉ DE DANIA'
 'SOCIÉTÉ COOPÉRATIVE JEUNESSE COOPÉRATIVE AGRICOLE DE SOUROUGOU'
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIE POUR LE DÉVELOPPEMENT DE SEMIEN'
 'COOPÉRATIVE AGRICOLE EYO ENIAN DE NOUVEAU'
 'SOCIÉTÉ COPÉRATIVE AGRICOLE DE GUEYO G'
 'SOCIÉTÉ COPÉRATIVE AGRICOLE DE GNIPI 2'
 'COPÉRATIVE AGRICOLE DE COUDOUKO'
 'COOPÉRATIVE AGRICOLE HERE DE KRANZADOUGOU'
 'COOPÉRATIVE AGRICOLE DE LANSSINA BONGO'
 'COOPÉRATIVE AGRIOLE NAN ETITINOU DE KRANZADOUGOU'
 'SOCIÉTÉ COOPÉRATIVE DES AGRICULTEURS DE PETIT OUAGA'
 'SOCIÉTÉ COOPERATIVE SIMPLIFIÉE AGRICOLE LA PAIX DU HAUT-SASSANDRA'
 'COOPÉRATIVE DES PRODUCTEURS AGRICOLES DE PÉTIT DIDIEVI'
 'Société Coopérative des Producteurs Agricole de Betesso'
 "SOCIÉTÉ COOPÉRATIVE CAPRESSA AGNITIE D'APPROMPRON"
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DES PRODUCTEURS DE ZAGNE'
 'Coopérative Agricole Demaidemai de Bangolo'
 "Société Coopérative Agricole Allakabo d'Oume"
 'SOCIÉTÉ COOPÉRATIVE IVOIRIENNE DES NOUVEAUX AGRICULTEURS'
 'SOCIÉTÉ COOPÉRATIVE DES PRODUCTEURS ANGABE DE DUEKOUE'
 'COOPÉRATIVE DES FEMMES POUR LA PRODUCTION,TRANSFORMATION ET COMMERCIALISATION DU VIVRIER DE LA MARAHOUÉ'
 'SOCIÉTÉ COOPÉRATIVE DES PRODUITS DE RENTE'
 'SOCIÉTÉ COOPÉRATIVE ECAB GUIGLO'
 'ENTREPRISE COOPÉRATIVE AGRICOLE DE BLOLEQUIN'
 'ENTREPRISE COOPÉRATIVE AGRICOLE DE KOUIBLY'
 'COOPÉRATIVE AGRICOLE KOOGNANAN DE GROGOUYA'
 'ENTREPRISE COOPÉRATIVE DES AGRICULTEURS DE MEAGUI'
 'ENTREPRISE COOPERATIVE AGRICOLE DES PRODUCTEURS CAFE ET CACAO DE ROBERT-PORTE'
 'ENTREPRISE COOPÉRATIVE DES JEUNES AGRICULTEURS DE DALOA'
 'ENTREPRISE COOPÉRATIVE DE SAINT-PAUL' 'Société Coopérative ETC TAABO'
 'SOCIÉTÉ COOPÉRATIVE FARMERS HOPE' 'HASSAN KAMEL FTOUNI SA'
 'SOCIÉTÉ COOPÉRATIVE DES JEUNES AGRICULTEURS DE VAVOUA'
 "SOCIÉTÉ COOPÉRATIVE AVEC CONSEIL D'ADMINISTRATION DES JEUNES PRODUCTEURS AGRICOLES D'ASSONVON"
 "Société Coopérative Avec Conseil\nd'Administration Yeyasso de Man"
 'Société Coopérative Agricole Kanwori de Yaou'
 'Société Coopérative Agricole Lanaya de Korhogo'
 "Société Cooperative avec Conseil d'Administration le Rocher"
 "SOCIÉTÉ COOPÉRATIVE AVEC CONSEIL D'ADMINISTRATION COOP CA NIHIPRI DE BLOLÉQUIN"
 "SOCIÉTÉ COOPÉRATIVE DES ALLIÉS DE CÔTE D'IVOIRE"
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE BINKADI DE KAHEN'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE BARAKAGNI DU HAUT SASSANDRA'
 "SOCIÉTÉ COOPÉRATIVE AGRICOLE N'ZASSA DE DIVO"
 'SOCIÉTÉ AGRICOLE DES PLANTEURS UNIS DE DAPKADOU'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE SOCOFI'
 'SOCIÉTÉ COOPÉRATIVE POUR LE BONHEUR DES PRODUCTEURS AGRICOLES DE GAGNOA'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE GLOIRE DE GUIGLO'
 'SOCIÉTÉ COOPÉRATIVE DE MÉAGUI'
 "Société Coopérative avec Conseil d'Administration Benkadi de Siakakro"
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE NOUVELLE ALLIANCE DE BANGOLO'
 'Coopérative agricole pour le développement\nde Sassandra'
 'SOCIÉTÉ COOPERATIVE ETRAYAWLEN DE LA COTIÈRE DE FRESCO'
 'Société Coopérative des Producteurs Agricoles du Zabouo'
 'COOPÉRATIVE AGRICOLE EMERGENTE DE DALOA'
 'SOCIÉTÉ COOPÉRATIVE ANOUANZÈ DES PETITS PRODUCTEURS DE DIDOKO'
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIE DES PRODUCTEURS DE SADA ET SECTEURS'
 'Société Coopérative Simplifiee Espoir\nde Kotobi'
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE EKLOEWOU DE GBAPLEU'
 "SOCIÉTÉ COOPÉRATIVE DES PRODUCTEURS DE CAFÉ CACAO DE TIASSALÉ AVEC CONSEIL D'ADMINISTRATION"
 'SOCIÉTÉ COOPÉRATIVE DES FEMMES DYNAMIQUES'
 "SOCIÉTÉ NOUVELLE D'ACHAT DES PRODUITS AGRICOLES A LAKOTA"
 'Société Coopérative Agricole Katana'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE KIPIRI'
 'SOCIÉTÉ COOPÉRATIVE DES EXPLOITANTS AGRICOLES DES ANTILOPES DU HAUT SASSANDRA'
 'Société Copérative de Negoce de Lakota'
 'SOCIÉTÉ COOPÉRATIVE NOUVELLE DES PRODUCTEURS AGRICOLES DE YAKASSÉ ATTOBROU'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE CAFÉ ET CACAO DE DIVO'
 'SOCIÉTÉ DE COMMERCIALISATION DES PRODUITS AGRICOLES DE DALOA'
 'SOCIÉTÉ COOPÉRATIVE DES PRODUCTEURS DE LAHOU'
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE SOLIDARITÉ DE SINFRA'
 'SOCIÉTÉ DE PRODUITS AGRICOLES DE DALOA'
 "UNION DES SOCIÉTÉS COOPÉRATIVE DE LA SOUS-PRÉFECTURE D'AYAMÉ"
 "SOCIÉTÉ COOPÉRATIVE AVEC CONSEIL D'ADMINISTRATION YEYASSO DE MAN"
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DES 2 SAMBA'
 'SOCIÉTÉ COOPÉRATIVE AVEC CA COOPÉRATIVE AGRICOLE ANOUANZE MEAGUI'
 'SOCIÉTÉ COOPÉRATIVE DES AGRICULTEURS DE BALOKUYA'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE BAHE SEBON'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DJIDJIYA DE BLOLÉQUIN'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE ESPOIR DE ZAGNE'
 'Société Coopérative Agricole de Goua'
 'SOCIÉTÉ COOPÉRATIVE AVEC CA AGNITIÉ APROMPRON'
 'SOCIÉTÉ COOPÉRATIVE AGRICULTEURS SOLIDAIRES DUÉKOUÉ'
 'SOCIÉTÉ COOPÉRATIVE YÉYONIAN DE MOUSSAKRO'
 "SOCIÉTÉ COOPÉRATIVE IVOIRIENNE DES PRODUCTEURS DE L'AGNÉBY"
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE BAGRÉ'
 'SOCIÉTÉ COOPÉRATIVE BASSADOUGOU DE DIES'
 "COOPÉRATIVE DES PRODUCTEURS ASSOCIÉS DE L'AGNÉBY"
 'COOPÉRATIVE AGRICOLE DE BOIGNYKRO'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE HERE DE ZAGNE'
 'SOCIÉTÉ COOPÉRATIVE DES PRODUCTEURS AGRICOLES DE ZARANOU'
 'COOPÉRATIVE AGRICOLE ELÉPHANT DE LAKOTA)'
 'COOPÉRATIVE AGRICOLE BREDI DE BETTIÉ'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE DE GLIGBEUADJI'
 'COOPERATIVE AGRICOLE ANOUANZE DES PRODUCTEURS DE MANZANOUAN'
 'COOPÉRATIVE AGRICOLE ENTENTE'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE AVEC CA KISHWENSIDA COCHEM DIDA'
 'SOCIETE COOPERATIVE DES PLANTEURS UNIS DE KPATAWERE'
 'ENTENTE COOPÉRATIVE APAH-TOU DE OUPOYO AVEC CA'
 'ENTREPRISE COOPÉRATIVE AGRICOLE DE YAOKRO'
 'SOCIÉTÉ COOPÉRATIVE DES PRODUCTEURS DE ADAMAKOUAMEKRO'
 "COOPÉRATIVE AVEC CONSEIL D'ADMINISTRATION SIAKAKRO"
 'SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE ENTENTE DE SONGAN'
 'COOPERATIVE AGRICOLE BINKADI DE YAMOUSSOUKRO'
 'SOCIÉTÉ COOPÉRATIVE AGRICOLE NOUVELLE ALLIANCE DE DIÉGONEFLA'
 'SOCIÉTÉ COOPÉRATIVE BENKADI DE JEROMEKRO'
 'SOCIÉTÉ COOPÉRATIVE POUR LE DÉVELOPPEMENT AGRICOLE DE GUITRY'
 'PRODUCTEURS DE CACAO BIOLOGIQUE DE LA MÉ'
 'Société Coopérative avec conseil d’Administration\nNainere de Gnato'
 'SOCIETE COOPERATIVE DES PRODUCTEURS DE YAKASSE-ATTOBROU'
 "SOCIETE COOPERATIVE YEYONIAN DU CANTON D'ANIASSUE"
 "Société Coopérative avec Conseil d'Administration des Producteurs Agricoles de Niablé"
 'SOCIETE COOPERATIVE AGRICOLE ZEMESS TAABA DE GBAGBAM'
 "Société Coopérative Agricole avec Conseil d'Administration Entente de Seguela"
 'Société Coopérative Yeyasso de Man' 'COOPERATIVE AGRICOLE BACON ESPOIR'
 'COOPERATIVE DES FRERES UNIS DE LA MARAHOUE'
 'COOPERATIVE CAFE ET CACAO IVOIRIEN'
 'COOPERATIVE AGRICOLE POUR LA MAITRISE DE L’ENTRAIDE DURABLE'
 'SOCIETE COOPERATIVE AGRICOLE GARO-EST DE DIVO'
 'COOPERATIVE AGRICOLE DES ALLIES DE COTE D`IVOIRE'
 'societe cooperative agricole de kobouo'
 "COOPERATIVE AGRICOLE NIAMKEY ET FAMILLE DE L'INDENIE"
 'SOCIETE COOPERATIVE DES NOUVEAUX AGRICULTEURS DE LAHOUDA'
 'COOPERATIVE AGRICOLE LANAYA DE VAVOUA'
 'societe cooperative agricole de donhio'
 'societe cooperative amitie de gnagbodougnoa'
 'societe cooperative alliance de mabouo'
 'societe cooperative des nouveaux agriculteurs de soubre'
 'SOCIETE IVOIRIENNE DE COMMERCIALISATION CAFE ET CACAO'
 'ENTERPRISE COOPERATIVE DES AGRICULTEURS MODERNES DE MEAGUI'
 'SOCIETE COOPPERATIVE DE NEGOCE DE LAKOTA'
 'Societe Cooperative Sabarikagni Du Haut Sassandra'
 'COOPERATIVE DE MEAGUI'
 'COOPERATIVE ANOUANZE DES PETITS PRODUCTEURS DE DIDOKO'
 'COOPERATIVE AGRICOLE DE TABOU'
 "COOPERATIVE AGRICOLE ANOUANZE D'ANIASSUE"
 'COOPERATIVE AGRICOLE DE LA REGION DU CAVALLY'
 'SOCIETE COOPERATIVE SIMPLIFIEE AGRICOLE POUR LE DEVELOPPEMENT DE KEIBLY'
 'COOPERATIVE AGRICOLE DE SOFOCI' 'OCIETE COOPERATIVE AGRICOLE ENTENTE'
 'COOPERATIVE AGRICOLE FRATERNITE DU HAUT SASSANDRA'
 'COOPERATIVE SITA BALO DE DALOA' 'COOPERATIVE AGRICOLE DE TOUIH'
 'SOCIETE IVOIRIENNE ACHAT DE PRODUIT AGRICOLE'
 'COOPERATIVE AAGRICOLE DIEU MERCI' 'BAH RAMATOULAYE CACAO'
 'COOPERATIVE AGRICOLE BINKELEMAN DE BELLE-VILLE'
 'COOPERATIVE AGRICOLE ETY-EWOUN-ANIEN DU HAUT SASSANDRA'
 'COOPERATIVE AGRICOLE SIBOULAKA DE BEOUA'
 'COOPERATIVE AGRICOLE DE GROGBONOU DAN'
 'COOPERATIVE AGRICOLE DE LASSINA BANGO'
 'COOPERATIVE AGRICOLE DE COOPANOU'
 'COOPERATIVE SIMPLIFIEE AGRICOLE TOUMTOUMDA DU HAUT SASSANDRA'
 'COOPERATIVE VICTOIRE DE MEAGUI'
 'ENTERPRISE COOPERATIVE DES AGRICULTEURS DE MEAGUI'
 "societe cooperative avec conseil d'administration espoir de vavaoua"
 'Farmers Hope' 'COOPERATIVE AGRICOLE ESPOIR BLOLEQUIN'
 'COOPERATIVE AGRICOLE ELIE TIKPA DE DALOA' 'SCOOP-DAKUA'
 'COOPERATIVE DES PRODUCTEURS AGRICOLES ‘NANTABA’ DU HAUT SASSANDRA'
 'COOPERATIVE AGRICOLE DES FRERES UNIS DE BOUREIMAKRO'
 'COOPERATIVE DES AMIS DE LA NATURE DE MAN'
 'COOPERATIVE DES JEUNES PRODUCTEURS AGRICOLES DU WORODOUGOU'
 'COOPERATIVE AVEC CONSEIL D`ADMINISTRATION COOPERATIVE AGRICOLE SOUGRI NONMA'
 'COOPERATIVE AVEC CONSEIL D`ADMINISTRATION DES PRODUCTEURS ANGABE DE BIANKOUMAN'
 "COOPERATIVE AVEC CONSEILD'ADMINISTRATION DES AGRICULTEURS DU GOH"
 'COOPERATIVE DES PLANTEURS UNIS DE FENGOLO'
 "SOCIETE COOPERATIVE AVEC CONSEIL D'ADMINISTRATION DJOUMAN DE KONGOKOUASSIKRO"
 'COOPERATIVE AVEC CONSEIL D’ADMINISTRATION. COOPERATIVE AGRICOLE SUCCES DE TOULEPLEU'
 'COOPERATIVE AGRICOLE NOUVELLE ALLIANCE DE BANGOLO'
 'COOPÉRATIVE AGRICOLE DES FRÈRES UNIS DE GOBROKO'
 "Cooperative avec Conseil\nd'Administration des Producteurs Agricoles de Petit Didievi"
 'Societe Cooperative Avec Conseil D’administration Unite De Danane'
 'SOCIETE COOPERATIVE AGRICOLE YEBOYOKON DE DAIRO DIDIZO']


--- CLEANED_RESIDUAL_NAME ---
[nan 'CABZOU WAREHOUSE' 'CEXPAG WAREHOUSE' 'COOTIEN OULA WAREHOUSE'
 'SCANDI WAREHOUSE' 'SCAOD WAREHOUSE' 'SCAT WAREHOUSE'
 'SCJPAB I WAREHOUSE' 'SCOOPADOB WAREHOUSE' 'SCOOPAL WAREHOUSE'
 'SCOOPAM WAREHOUSE' 'SCOOPS SPC WAREHOUSE' 'SOCABANCO WAREHOUSE'
 'SOCAPROZ WAREHOUSE' 'SOCOBAD WAREHOUSE' 'SOCOOPAK WAREHOUSE' 'BECIDA'
 'BECIDA TLE' 'BMC VAVOUA' 'COADOSOV' 'SCAFRA' 'SCOAVA' 'SCOOPAAB'
 'SCOOPABL' 'SPAD MAN' 'CANN' 'COOPAAHS' 'COOP-CA CAYAT' 'COOP-CA ECAMOM'
 'COOP-CA SCAPEKO' 'COOP-CA SCARDI' 'COOP-CA SECA' 'COOP-CA SOCADAG'
 'COOP-CA-CAPKA' 'LCAG' 'MIEN-SAH' 'SCAES' 'SCALO' 'SCAND-COOP CA'
 'SCBG-COOP-CA (GALEBRE)' 'SCNV-CA' 'SCOOPS-SAHS' 'SOCAS' 'SOCAYEMA'
 'SOCODD' 'SOCOOPEM' 'U.S.C.R.G-COOP-CA' 'UCODEL' 'AHONDJO' 'SCOOPAD'
 'SCOOPAK' 'SI3C' 'UDAN' 'CAF' 'COOPABAK' 'ECEPAG' 'SCAFUD' 'SOCAG'
 'SOCAYA' 'SOCOOPAN' 'SOCOPAL' 'SCOOP-CA SPAB' 'SPAD CA' 'CAAA' 'CADB'
 'CADEDO' 'CAEG' 'CAMOBIAN' 'CANK' 'CAPA' 'CAPB' 'CAPM' 'CAPRESSA' 'CEMA'
 'COABIA' 'COOP CA AGOH' 'COOP CA COANI' 'COOP JCAS' 'COOPACA' 'COOPADEF'
 'COOPAGARO' 'COOPAGES' 'COOPAGO' 'COOPAHK' 'COOPAZA' 'COOPRADI' 'ECAB'
 'ECAO' 'ECOPADI' 'SCAANIAS' 'SCAM' 'SCOOPA CA' 'SCOOPASG' 'SCOOPECO'
 'SCOOPS AKY' 'SCOOPS BAD' 'SCOOPS-APRAB' 'SINIKAN-SCOOPAS' 'SOCANOVA'
 'SOCOOPADO' 'SOCOOPAM' 'SOLIDARITE' 'SCAPAO' 'SOCAD' 'SPAD GUIGLO'
 'SPAD SOUBRE' 'BARRA GABIADJI' 'CBNB' 'COALIDAN' 'COOKADI'
 'COOP CA DJIGUIYA' 'COOPAGNIPI' 'SCAPD' 'SOCBPI' 'CA2S-CA' 'CAEZ-COOP-CA'
 'COOPRAMA-CA' 'S.C.P.K' 'SCOOPAC-COOP-CA' 'SCOOPS ECAPG' 'SOCAET2'
 'SCOOWEND' 'SCAGB' 'SOCASS' 'SCAK' 'SOCAGRI2' 'CAGNAN' 'SCANG' 'SOCOAMO'
 'SOCAT' 'SCANFI' 'SCOOPAGED' 'CAEHS' 'SCOOPNAG' 'SCAMED' 'CAFUGO' 'ECSP'
 'CAMAYE' 'SOCAMEA' 'ECAKOOG' 'COOBADI' 'CAYAT' 'ECAM' 'ECOJAD'
 'SOCOOPACDI' 'DJOUMAN' 'SOCASIB' 'SICOPAG' 'SCAWOD' 'AHONTO' 'SOCADA'
 'SOCA2PD' 'SCOOPAG' 'COODIG' 'CAPUM' 'ADA' 'AMIANGOUAN' 'APM DALOA'
 'BARA' 'C2AS' 'CAADA' 'CABING' 'CABS' 'CADESA' 'CADT' 'CAPROD' 'CAPSUD'
 'CAREFSI' 'CARET' 'CASIB' 'CAVA' 'CJPK' 'CMB' 'COOP CA-JCAS' 'COOPADES'
 'COOPAEEN' 'COOPAGG' 'COOPALBA' 'COOPANEK' 'COOPAO' 'COOPAPAIX-H-S'
 'COOPAPEDI' 'COOP-CA APRAB' 'COOP-CA CAPRESSA' 'COOP-CA SOCAPROZ'
 'COOP-CA TEEGA- WENDE' 'COOP-CA-AKK' 'COOPINA' 'COOPRAD' 'COVIMA'
 'CPR CANAAN' 'ECAB GUIGLO' 'ECABLO' 'ECAKO' 'ECAPR' 'ETC TAABO' 'FAHO'
 'HKF /NAWA' 'JAVA' 'JEPRAS' 'KAKO' 'KANWORI DE YAOU' 'LANAYA' 'LE ROCHER'
 'NIHIPRI DE BLOLEQUIN (CNB)' 'SCAACI' 'SCABK' 'SCALAVA' 'SCAPEN' 'SCAPUD'
 'SCAS' 'SCBPAG' 'SCOAGG' 'SCOM' 'SCOOP- BINKADI GA' 'SCOOPAB'
 'SCOOPANAB COOP – CA' 'SCOOPAVI' 'SCOOPRAZA' 'SCOOPS CAED'
 'SCOOPS SOCA2PD' 'SCOOPS-COOPROSAS' 'SCOOPS-EK' 'SCOOPS-EKLOEWOU'
 'SCPCCT-CA' 'SFED' 'SNAPAL' 'SOCAK KATANA' 'SOCAKI' 'SOCEADAHS'
 'SOCONEL-SCOOPS' 'SOCONPAYAT' 'SOCOPAD' 'SOCOPLA' 'SODASI' 'SPAD DALOA'
 'SPAD GAGNOA' 'UCA' 'YEYASSO' 'SCOOPS ECAB GUIGLO' 'COOP CA SCAMB'
 'SCOOPS YANKADI' 'CEAA' 'COOP CA CAGB BLOLEQUIN' 'COOP CA DJOUMAN'
 'COOP CA LAG' 'COOP CA SCOOPAMOU' 'COOP CA SCOOPUF' 'COOPATHS' 'MINDOBIE'
 'SCAOD' 'SCOOPS CABAG' 'SCOOPS CAFUC' 'SCOOPS CALB' 'SCOOPS CAPROBLO'
 'SCOOPS ECAM' 'SCOOPS RASSO' 'SOCOPANS' 'COOP-CA COOPAD (DUEKOUE)'
 'COOP-CA COOPANAM' 'ECAFHS-COOP.CA' 'ECAM-SCOOPS' 'COOP-CA CABID'
 'COOP-CA ECAG' 'SAMA-HS-SCOOPS' 'SOCODS' 'ECSP DUEKOUE' 'COOP-CA CABF'
 'SCJPAB' 'SCOOPS-ECAPG(LAKOTA)' 'COOP-CA MONT BIAN' 'SCOOPAA'
 'SCOOPS SOCOPA' 'COOP-CA C.A.G' 'SCOOPS- COASABANA' 'SCOOPS-KRIHIRI'
 'SCOOPS-SOCOOPA' 'AGRIAL' 'COOP-CA- NOCOOP.A.SI' 'COOP-CA ETC TAABO'
 'COOP-CA-CABEND' 'SCOOPS-EKO' 'COOP-CA ECB' 'COOP-CA-COOPASOD'
 'SCOOPS COASADA' 'SCOOPS-EDIFIE-DOUKOUYA' 'COOPAWEB' 'ECAGNI'
 'SCOOP CAES' 'ECOFAB-SCOOPS' 'SCOOPS-C.A.N.W.G' 'COOP-CA CAMD'
 'COOP-CA-REJA' 'KGS' 'SOCAREBIA' 'BENKADI' 'COOPYMA' 'SCAREG-COOP-CA'
 'SCOSOD' 'COOP-CA ADEDO' 'COOP-CA CAGNAN' 'COOP-CA CPSL' 'COOP-CA CSC'
 'COOP-CA SCPS' 'COOP-CA-COOP.A.SO' 'SOCABEN' 'COOP-CA SOUHONTA-KAKO'
 'SCOOPS COOP.A.DI' 'SOCOOPENHA' 'COOPAADI' 'COOP-CA-COOPRABED'
 'COOPEBIA-CA' 'SCOOPAKOF' 'SOCOOPAGOS' 'AGBS' 'CJAHS' 'COOFRADO-COOP-CA'
 'COOP CA-CPB' 'COOP-CA SCOOPALO' 'COOP-CA SOCANC' 'COOP-CA SCAPEN'
 'SOCARL' 'SOCOOPALAO' 'S.COOPADOU' 'COOP-CA CABD (DOUGBO)'
 'COOP-CA ECATAMEA' 'COOP-CA SOCOOPAGAGNY' "COOP-CA YAWOUBE D'ANIASSUE"
 'SCOAKHS' 'SOCAAN' 'CANWORI' 'COOPAAPROMAN' 'COOP-CA AGREL' 'SOCODAG'
 'SCOOPABINKADI-CA' 'CASODI' 'COOPAC' 'COOP-CA COASI' 'SCOOP CASO'
 'SCOPAYO' 'ECAPA GZ' 'COOPABE' 'COOP-CA BB' 'COOP-CA-CABD' 'SCINPA'
 'COOPAMA' 'COOP-CA ANONKLON' 'COOP-CA SCAK' 'ECASO' 'CAFHS-COOP-CA'
 'COOPAGA' 'CAPG' 'COOPRAN' 'SCOOPS-COODIG' 'COOP CAADI' 'COOP SICAO'
 'COOP - CA - REF - SI' 'CIPACCA' 'ECOOPAK' 'SCOOP ABOKA' 'CAL2B'
 'COOPADO' 'UPRAD' 'SCOOPS-AGRIOBIO' 'COOP CABS' 'SCOOP CEDA' 'SNCC'
 'CODEMA' 'CAPO' 'COOPRADA' 'NECAB' 'CAC' 'COANGNA' 'COOP CATBK' 'COOPASM'
 'ECEAGN' 'SCAEPGY' 'SOCOSADA' 'SCOOPS-BADEMAYA' 'COOPATESA' 'SCAAO'
 'SCOOPAKAM' 'SOCAHI' 'SOCOOPELA' 'SOCOPADOU' 'CABA' 'COOP TEEGA WENDE'
 'SCOOPS CARET' 'SCOOPS JPK' 'HKF6' 'HKF7' 'NAWA1' 'SCOOPNAS' 'SOCAGS'
 'SOCOPDAL' 'CAYSI' 'CAABRO' 'CAAN' 'CABES' 'CABG' 'CABGB' 'CABID'
 'CABOHGA' 'CADA' 'CAKB' 'CAMAP' 'CANS' 'CAPL' 'CASODU' 'CATBK' 'CEDA'
 'CNAD' 'COAKA' 'COAM' 'CODERLACS' 'COESAG' 'COOAAB-COOP CA'
 'COOP CA ABOTRE' 'COOP CA ANZUE II' 'COOP CA BIRBA' 'COOP CA COOPAA'
 'COOP CA COPACOL' 'COOP CA ESPOIR' 'COOP CA GCT' 'COOP CA KWS'
 'COOP CA NOBIELTO' 'COOP CA WEND SONGDA' 'COOP CAES' 'COOP-CA COALIDAN'
 'COOP-CA COANGNA' 'COOP-CA COOPABIN' 'COOP-CA COOPADO' 'COOP-CA NECAB'
 'COOP-CA-ABO' 'COOP-CA-CABS' 'COOP-CA-PAN' 'COOP-CA-UDAN' 'COOPABENKADI'
 'COOPAKCODI' 'COOPAMDI' 'COOPANAM' 'COOPAOU' 'COOPAYAF' 'COOPAZEG'
 'COOPRAS' 'COOPRAZO' 'COOPROYA' 'COOPYCA' 'CP2A' 'CPACD' 'CPI' 'CPSL'
 'ECAAF' 'ECAESB' 'ECAMOG' 'ECODEBO' 'ECOPAS' 'ECSP PURATOS'
 'FLRI COOPADIM' 'FLRI NANTEBESSOU' 'FLRI SOCAMA' 'IQJ' 'LAFI BEBE DE MAN'
 'LE PROGRES' 'NWK' 'S-COOP COOPRADA' 'SCAB' 'SCAGG' 'SCAPCC' 'SCASOU'
 'SCOAPANI' 'SCOOPAC' 'SCSPA' 'SOCAEK' 'SCABODI' 'SCAC' 'SCAEG' 'SCAESG'
 'SCAG' 'SCAND' 'SCAPEKO' 'SCARDI' 'SCAW' 'SCELA' 'SCO SACI' 'SCOAWWASI'
 'SCOOP CAYEM' 'SCOOPA' 'SCOOPAAS' 'SCOOPADJI' 'SCOOPAKOKO' 'SCOOPAT'
 'SCOOPS 3A' 'SCOOPS ABOKA' 'SCOOPS AGRI.BIO' 'SCOOPS AL'
 'SCOOPS BADEMAYA' 'SCOOPS COOP.A.SAM' 'SCOOPS COOPAA' 'SCOOPS EPG'
 'SCOOPS JST' 'SCOOPS LA PAIX' 'SCOOPS SCAG' 'SCOOPS SCAT 1'
 'SCOOPS SCSAG' 'SCOOPS SNCC' 'SCOOPS WEBE' 'SCOOPS YAT' 'SCOOPS-AH'
 'SCOOPS-CODEMA' 'SCOOPS-LTDV' 'SCOOPS-UPRAD' 'SCUW' 'SO.CC.NA'
 'SO.CO.SA.DA' 'SO.COA.MO' 'SOCABA' 'SOCABB' 'SOCADJO' 'SOCAGNIPI' 'SOCAJ'
 'SOCOPADOGBO' 'SOCOPEK' 'SOCOSOM' 'UPAS' 'CAFUVA' 'COOP CA CAPLI'
 'COOP CA SPAM MAN' 'COOP-CA INCHALA' 'BENKRA' 'CAAM' 'CAB' 'CAEZA'
 'CAPG GUIGLO' 'CAYEMOS' 'CIPA' 'COAB' 'COOPAA' 'COOPABOIGNY' 'COOPAHZ'
 'COOP-CA COOPAGLI' 'COOPEN' 'COPAKCODI' 'COPUK' 'ECOOYA' 'NOCAO OUME'
 'SCOOPA-CA' 'SCOOPS-ES' 'SCOOPABINKADI' 'SCOOPANAD'
 'CAPEDIG (PART OF ECOOKIM)' 'COODID' 'COOP CA CPAGB' 'COOP-CA-ECOAS'
 'SCPCB' 'COOP CA UPRAD' 'ECAPN' 'SCAP CC' 'RELUAINDE' 'COOP-CA-CPSL'
 'SOCOOPAGAGNY' 'COOP CA COOPAD' 'SCOOPAZEG' 'SCOOPRAH' 'SOCOPASG'
 'COOP-CA-ECAMOG' 'SCOOPS SCAB' 'COOP PUSAH' 'COOP CA AB' 'COOPAME'
 'SCOOPS PS' 'USOCAS' 'COOP CA PRO' 'SCOOPAGEA' 'ECOODI' 'AJAMI ALY'
 'COOP CA PAI' 'COOP CA SCOOPAUDD' 'SOCOOPAKOKO' 'SAPO' 'SCCG'
 'SCOODJIBODI' 'SCOOPAZAP' 'SCOOPEPASCOOPS-' 'SCOOPS APROCAO'
 'SCOOPS COODIG' 'SCOOPS DAKUA' 'SCOOPS ECAB' 'SCOOPS IZ' 'SCOOPS-PAK'
 'SCOOPS MOYE' 'SOCABA SCOOP CA' 'SOCACHIPOLO' 'SOCOOPAF' 'COOP CA A.DI'
 'FOUNDARA' 'COOP-CA SOCOSADA' 'SCEG1-SCOOPS' 'SCANDI' 'SCOOPS-AM'
 'SOCABID' 'SOCONPAYAT-COOP CA' 'SCOOPS PAC' 'SCOOPS PAZ'
 'COOJEPAWO-SCOOPS' 'SOCICAS' 'SOCOPGA' 'KYGNON' 'SOCABL'
 'SCOOPS LAFI-BEBE' 'SOCAZE' 'SCOOPS COOPADO' 'SCOOPS SODASI'
 'COOP CA LA GLOIRE' 'SCOOPASAВ СООР СА' 'CAWSA' 'NCB' 'CANT'
 'COOP CA ECAG' 'SCOOPS SAL' 'SCAJP' 'CALZB' 'HAMAOULA' 'NWM' 'SONAB'
 'WEND SONGODO' 'JPAB' 'TEEGAWEND' 'PCBM' 'APM BENIANSSOU A'
 'APM BENIANSSOU B' 'APM BENIANSSOU C' 'APM DALOA A' 'APM DALOA B'
 'APM DALOA C' 'APM MAN B' 'APM MAN C' 'BECIDA A' 'BECIDA TLE A' 'CAADI'
 'CABK 1' 'CABK 2' 'CAED DALOA' 'CAED GUIGLO' 'CAEDU' 'CAOSI' 'CAREBO'
 'CASB' 'CNEK' 'COAM DALOA A' 'COAM BONON' 'CODERLACS TOUMODI'
 'COAM DALOA B' 'COOP-CA EYONIAN' 'ESPÉRANCE SCOOPAAB' 'ICA' 'NOUR'
 'SCAGB BLOMMER' 'SCOAG' 'SCOOPAB B' 'SCOPACI' 'SCPCCT 2 B' 'SCPCCT 1'
 'SICAO B' 'SCPCCT 2 A' 'SICAO A' 'SOCADJA C' 'SOCA2PD B' 'SOCADJA A'
 'SPAD DALOA 1' 'SPAD DUEKOUE B' 'SPAD DALOA 2' 'SPAD GAGNOA N A'
 'SPAD DUEKOUE A' 'SPAD GAGNOA F' 'SPAD MAN B' 'SPAD SEGUELA'
 'SPAD GAGNOA N B' 'SPAD MAN A' 'SPAD VAVOUA' 'ZAGTOULI' 'BENKADI COOPS'
 "SOCIÉTÉ COOPÉRATIVE ESPOIR D'ALEPÉ" 'SCOOPS CAPUM' 'WINPAS'
 'ECOOKIM - COOPAPIG' 'ECOOKIM - CAVA' 'ECOOKIM - CAUD' 'ECOOKIM - CAKIB'
 'YEBOYEKON' 'RADEE TRADING' 'SOCADMV' 'SIVAP' 'ECAMOM' 'ESPOIR VAVOUA'
 'SOCOPRAHNS' 'SCAT' 'COOPAD' 'SCOOPS-ECAPG (LAKOTA)' 'PLAZA SOUBRE'
 'PLAZA GAGNOA' 'SOCOEMA' 'SCOOPS COASABANA' 'SOCAZM' 'ECATIE'
 'ECOOKIM - CPR CANAAN' 'SCAW MAN' 'COOP CA SCAND' 'CALTDV' 'APM GAGNOA'
 'SOCOOPLAGUE' 'COOPAYAAF' 'COOPANAM (EX EDY)' 'COOP-CA-ABOTRE' 'SOCODAN'
 'COOP-CA CASODU' 'COOP CA CANS' 'COOP CA CPAL' 'WAGAJACA' 'SCOOPSYAT'
 'SCAPCCA' 'SOCNAD' 'ECYG-COOP-CA' 'CAYSI-SCOOPS' 'COOP CA ABO'
 'COOP-CA ESPOIR' 'COOP-CA-ECABLO' 'COOP-CA ECAKO' 'NOUVELLE SCOOPRANYD'
 'COOP-CA-ZRANSSA' 'COOP-CA CAPSUD' 'SCOOPS-COOPADES'
 'S.CO.A.G.G.-COOP-CA' 'COOP-CA-ECAPR' 'COOP-CA SOCA BANCO'
 'COOP-CA SOCOPLA' 'CAJPG-SCOOPS' 'PLAZA-COOP-CA GAGNOA'
 'PLAZA-COOP-CA SOUBRE' 'SOCOFUMA' 'SOCOCCI' 'SCAA CI' 'SCANFI_SCOOPS'
 'SCOOPNAG-SCOOPS' 'SCOOPAM' 'SOCONEL' 'SCOOPS_SAHS' 'SCOOPS C.A.R.E.C.A'
 'SCOOPS RADEE' 'COOPEN-COOP-CA' 'ECAFHS' 'SCOOPS-CAP-VA' 'BARACACAO'
 'CA2B' 'CASIB-SCOOPS' 'SCOOPAGRO' 'COOPANOU' 'COOPATHS-SCOOPS' 'COVIMEA'
 'ESPOIR' 'SCAEB' 'SCAETHS' 'SCOOPS_DAKUA' 'SOCOOPRANHS' 'SCAFUB'
 'COOPCA-COOPANAM' 'COOJEPAWO' 'COOP CA SOUGRI NONMA' 'COOP CA COOPRAD'
 'ECAM SASSANDRA' 'SCOOPUF-COOP-CA' 'COOP CA CASUT' 'COOP-CCAPUO'
 'COOP_CA_UDAN' 'YEBOYOKON']


--- DISCL_AREA_NAME_CLEAN ---
['AGNIBILEKRO' 'ABENGOUROU' 'BONGOUANOU' 'BANGOLO' 'DIVO' 'SINFRA'
 'AGBOVILLE' 'TABOU' 'SOUBRE' 'TOUMODI' 'GAGNOA' 'GUIGLO' 'BIANKOUMA'
 'SEGUELA' 'DUEKOUE' 'TIASSALE' 'MAN' 'SASSANDRA' 'BLOLEQUIN'
 'ZOUAN-HOUNIEN' 'KOUIBLY' 'GUITRY' 'ADZOPE' 'BOUAFLE' 'SAN-PEDRO' 'DALOA'
 'LAKOTA' 'AKOUPE' 'MEAGUI' 'ISSIA' 'ZUENOULA' 'YAKASSE-ATTOBROU'
 "M'BATTO" 'ABOISSO' 'ARRAH' 'TOULEUPLEU' 'VAVOUA' 'GUEYO' 'TAABO' 'TAI'
 'ZOUKOUGBEU' 'DANANE' 'ALEPE' 'OUME' 'FRESCO' 'BUYO' 'YAMOUSSOUKRO'
 'GRAND-LAHOU' 'BETTIE' 'DJEKANOU' 'SIKENSI' 'ADIAKE' 'BEOUMI' 'KOUN-FAO'
 'BONDOUKOU' 'BOCANDA' 'ABIDJAN' 'DAOUKRO' 'SIPILOU' 'KANI' 'SAKASSOU' nan]
df.DISCL_YEAR=2024
import numpy as np

# 1. Set Supplier Type based on whether 'WAREHOUSE' is in the name
# We use str.contains with case=False to catch 'Warehouse', 'WAREHOUSE', etc.
# na=False ensures NaN values are treated as False (not a warehouse)
df['DISCL_SUPPLIER_TYPE'] = np.where(
    df['DISCL_SUPPLIER_ABRVNAME_CLEANED'].str.contains('WAREHOUSE', case=False, na=False),
    'WAREHOUSE',
    'COOPERATIVE'
)

# 2. If Trader Name is 'OFI', replace Supplier Abrv Name with Residual Name
# Note: This keeps the original Supplier Abrv Name if Trader is NOT 'OFI'
df['DISCL_SUPPLIER_ABRVNAME'] = np.where(
    df['COMPANY'] == 'OFI',
    df['CLEANED_RESIDUAL_NAME'],
    df['DISCL_SUPPLIER_ABRVNAME']
)

# Verify the changes
display(df[df.COMPANY=='OFI'])
DISCL_TRADER_NAME DISCL_SUPPLIER_ABRVNAME DISCL_AREA_NAME DISCL_CERTIFICATION_NAME DISCL_NUMBER_FARMERS DISCL_LONGITUDE DISCL_LATITUDE DISCL_COUNTRY_NAME DISCL_YEAR COMPANY ... DISTRICT_GEOCODE CAM_BUYERS IS_CAM_V3 IS_JRC JRC_BUYER_ID DISCL_SUPPLIER_TYPE DISCL_SUPPLIER_ABRVNAME_CLEANED DISCL_SUPPLIER_FULLNAME_CLEANED CLEANED_RESIDUAL_NAME DISCL_AREA_NAME_CLEAN
826 OFI CAAA ABENGOUROU NaN NaN NaN NaN IVORY_COAST 2024 OFI ... CI-3.1.1_1 NaN NaN NaN NaN COOPERATIVE CAAA NaN CAAA ABENGOUROU
827 OFI CAAA ABENGOUROU NaN NaN NaN NaN IVORY_COAST 2024 OFI ... CI-3.1.1_1 NaN NaN NaN NaN COOPERATIVE CAAA SAND BOX NaN CAAA ABENGOUROU
828 OFI CAABRO ABENGOUROU NaN NaN -3.498601 6.718354 IVORY_COAST 2024 OFI ... CI-3.1.1_1 NaN NaN NaN NaN WAREHOUSE SOCOPDAL WAREHOUSE NaN CAABRO ABENGOUROU
829 OFI CAABRO ABENGOUROU NaN NaN NaN NaN IVORY_COAST 2024 OFI ... CI-3.1.1_1 NaN NaN NaN NaN COOPERATIVE CAABRO SAND BOX NaN CAABRO ABENGOUROU
830 OFI CAAN ABENGOUROU NaN NaN NaN NaN IVORY_COAST 2024 OFI ... CI-3.1.1_1 NaN NaN NaN NaN COOPERATIVE CAAN NaN CAAN ABENGOUROU
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
1343 OFI COOP-CA NECAB SOUBRE NaN NaN -6.672450 4.767894 IVORY_COAST 2024 OFI ... CI-2.2.5_1 NaN NaN NaN NaN WAREHOUSE ECAB WAREHOUSE NaN COOP-CA NECAB SOUBRE
1344 OFI COOP-CA-CABS DALOA NaN NaN -6.868830 6.622070 IVORY_COAST 2024 OFI ... CI-9.1.1_1 NaN NaN NaN NaN WAREHOUSE CABS WAREHOUSE NaN COOP-CA-CABS DALOA
1345 OFI COOP-CA-CABS DALOA NaN NaN -6.868830 6.622070 IVORY_COAST 2024 OFI ... CI-9.1.1_1 NaN NaN NaN NaN WAREHOUSE CABS WAREHOUSE NaN COOP-CA-CABS DALOA
1346 OFI COOP-CA-PAN DANANE NaN NaN NaN NaN IVORY_COAST 2024 OFI ... CI-8.3.2_1 NaN NaN NaN NaN COOPERATIVE COOP-CA-PAN NaN COOP-CA-PAN DANANE
1347 OFI COOP-CA-UDAN DANANE NaN NaN -8.150575 7.252397 IVORY_COAST 2024 OFI ... CI-8.3.2_1 NaN NaN NaN NaN COOPERATIVE COOP-CA-UDAN NaN COOP-CA-UDAN DANANE

522 rows × 24 columns

#df.to_csv('/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/2024_civ_coops_with_geocodes.csv', index=False)
df['DISCL_SUPPLIER_ABRVNAME'] = np.where(
    df['COMPANY'] == 'BARRY CALLEBAUT AG',
    df['DISCL_SUPPLIER_ABRVNAME_CLEANED'],
    df['DISCL_SUPPLIER_ABRVNAME']
)
# fix coop names for LINDT_SPRUNGLI
df['DISCL_SUPPLIER_FULLNAME'] = np.where(
    df['COMPANY'] == 'LINDT SPRUNGLI',
    df['DISCL_SUPPLIER_FULLNAME_CLEANED'],
    df['DISCL_SUPPLIER_FULLNAME'])
# List of columns to drop
cols_to_drop = [
    'DISCL_SUPPLIER_ABRVNAME_CLEANED', 
    'DISCL_SUPPLIER_FULLNAME_CLEANED', 
    'CLEANED_RESIDUAL_NAME', 
    'DISCL_AREA_NAME_CLEAN'
]

# Drop them (errors='ignore' prevents a crash if you accidentally run this cell twice)
df.drop(columns=cols_to_drop, inplace=True, errors='ignore')

# Verify they are gone
print("Columns remaining:", df.columns.tolist())
Columns remaining: ['DISCL_TRADER_NAME', 'DISCL_SUPPLIER_ABRVNAME', 'DISCL_AREA_NAME', 'DISCL_CERTIFICATION_NAME', 'DISCL_NUMBER_FARMERS', 'DISCL_LONGITUDE', 'DISCL_LATITUDE', 'DISCL_COUNTRY_NAME', 'DISCL_YEAR', 'COMPANY', 'DISCL_SUPPLIER_FULLNAME', 'DISCL_VOLUMES', 'DISCL_VOLUMES_UNIT', 'DISCL_CERTIFICATION_PCT', 'DISTRICT_GEOCODE', 'CAM_BUYERS', 'IS_CAM_V3', 'IS_JRC', 'JRC_BUYER_ID', 'DISCL_SUPPLIER_TYPE']
df.DISCL_SUPPLIER_FULLNAME[df['COMPANY'] == 'LINDT SPRUNGLI']
0               SOCIETE COOPERATIVE BENKADI DE SIAKAKRO
1     SOCIETE COOPERATIVE ANOUANZE DES PRODUCTEURS D...
2          SOCIETE COOPERATIVE AGRICOLE AHUANOU D'ARRAH
3                            COOPERATIVE AGRICOLE TELIN
4     COOPERATIVE AGRICOLE IMAAH, COOPERATIVE SIMPLI...
5        COOPERATIVE AVEC CONSEIL D'ADMINISTRATION MOYE
6                          COOPERATIVE SIMPLIFIÉE RASSO
7     SOCIETE COOPERATIVE AGRICOLE NOUVELLE DE DJOUR...
8          SOCIETE COOPERATIVE AGRICOLE N'ZASSA DE DIVO
9      SOCIETE COOPERATIVE DES AGRICULTEURS DE WONSEALY
10              SOCIETE COOPERATIVE ENTENTE DE DJEKANOU
11    SOCIETE COOPERATIVE DE NEGOCE CAFE CACAO DE BA...
12     COOPERATIVE DES MEILLEURS AGRICULTEURS DE GAGNOA
13         COOPERATIVE AGRICOLE DES PRODUCTEURS DE DIVO
14        COOPERATIVE AGRICOLE DES PRODUCTEURS DE GUEYO
15         COOPERATIVE SIMPLIFIÉE TIPHERET DE BLOLEQUIN
16    SOCIETE COOPERATIVE SIMPLIFIEE AGRICOLE DES PR...
17     COOPERATIVE D'APPUI AUX PRODUCTEURS DE BLOLEQUIN
18    SOCIETE COOPERATIVE DES PRODUCTEURS AGRICOLES ...
19       COOPERATIVE SIMPLIFIÉE VICTOIRE DE LA MARAHOUE
20         COOPERATIVE SIMPLIFIÉE WEND YA WENDE DE NANE
21                   Centre d'Achat Hassan Kamel Ftouni
22                   Centre d'Achat Hassan Kamel Ftouni
23                   Centre d'Achat Hassan Kamel Ftouni
24       Société Coopérative des Agriculteurs de Soubré
25        SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE ALLAH EN DEMIN
26    SOCIÉTÉ COOPÉRATIVE DES JEUNES PRODUCTEURS AGR...
27    SOCIÉTÉ COOPÉRATIVE AVEC CONSEIL D'ADMINISTRAT...
28    SOCIÉTÉ COOPÉRATIVE AGRICOLE NOUVELLE ALLIANCE...
29    Société Coopérative des Producteurs de Café Ca...
30    SOCIÉTÉ COOPÉRATIVE DES AMIS DE LA NATURE DE M...
31    ENTREPRISE COOPÉRATIVE DES AGRICULTEURS DE MÉA...
32    SOCIÉTÉ COOPÉRATIVE DES PLANTEURS UNIS DE FENG...
33    SOCIÉTÉ COOPÉRATIVE AVEC CONSEIL D'ADMINISTRAT...
34    SOCIÉTÉ COOPÉRATIVE SUCCÈS DE TOULEPLEU (COOP ...
35    SOCIÉTÉ COOPÉRATIVE DE CAFÉ CACAO DE BIN-HOUYÉ...
36    SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE TARWINDPANGA DE...
37    SOCIÉTÉ COOPÉRATIVE AGRICOLE DIEU EST GRAND DE...
38    Coopérative pour le Développement de la Région...
39    Sociéte Coopérative Avec Conseil d'Administrat...
40                Société Coopérative Agricole de Gagny
41    SOCIÉTÉ COOPÉRATIVE SIMPLIFIÉE AGRICOLE AVENIR...
42    Coopérative des Producteurs Agricoles de Cacao...
43    ENTREPRISE COOPERATIVE POUR LE DEVELOPPEMENT D...
44                 Société Coopérative Agricole de Boua
45             Société Coopérative Agricole du Bandaman
46    Société Coopérative pour le Bonheur des Produc...
Name: DISCL_SUPPLIER_FULLNAME, dtype: object
# 1. Identify the rows belonging to MARS
is_mars = df['COMPANY'] == 'MARS'

# 2. Create a temporary 'cleaned' series for the MARS rows
#    We use .copy() to ensure we don't affect the original dataframe
#    .fillna('') handles any empty values so the code doesn't crash
cleaned_names = df.loc[is_mars, 'DISCL_SUPPLIER_ABRVNAME'].fillna('').astype(str).copy()

# 3. Apply the cleaning rules
#    We remove the specific terms you listed.
#    IMPORTANT: We remove "SCOOPS" before "SCOOP" and "COOP" to avoid partial matches
#    (e.g., preventing "SCOOPS" from becoming "S" if "COOP" was removed first)
terms_to_remove = ["SCOOPS", "SCOOP", "COOP", "-CA", "CA", "COOP CA", "COOP-CA"]

for term in terms_to_remove:
    # Remove the term (regex=False treats it as plain text)
    cleaned_names = cleaned_names.str.replace(term, "", regex=False)

# 4. Remove all blank spaces
cleaned_names = cleaned_names.str.replace(" ", "", regex=False)

# 5. Find duplicates based on this cleaned name
#    keep='first' marks the first instance as False (Safe) and duplicates as True (Drop)
duplicates_mask = cleaned_names.duplicated(keep='first')

# 6. Get the indices of the rows to drop
indices_to_drop = duplicates_mask[duplicates_mask].index

# 7. Drop them from the main dataframe
df = df.drop(indices_to_drop)

# Verify results
print(f"Dropped {len(indices_to_drop)} duplicate MARS rows.")
Dropped 10 duplicate MARS rows.
import pandas as pd
import numpy as np

# --- 1. Helper Function to Clean Names ---
def get_cleaned_names(series):
    # Convert to string and handle NaNs
    clean = series.fillna('').astype(str).str.upper()
    # Remove terms (Longer terms first to avoid partial deletion issues)
    terms_to_remove = ["SCOOPS", "SCOOP", "COOP", "-CA", "CA", "COOP CA", "COOP-CA"]
    for term in terms_to_remove:
        clean = clean.str.replace(term, "", regex=False)
    # Remove all spaces
    clean = clean.str.replace(" ", "", regex=False)
    return clean

# --- 2. Prepare the Data ---
# Create a temporary 'MATCH_KEY' column for efficient lookup
df['MATCH_KEY'] = get_cleaned_names(df['DISCL_SUPPLIER_ABRVNAME'])

# Split into MARS (Target) and Non-MARS (Source)
mars_mask = df['COMPANY'] == 'MARS'
df_mars = df[mars_mask].copy()
df_others = df[~mars_mask].copy()

# --- 3. Create a Lookup Dictionary from Non-MARS Rows ---
# We group by the clean name and take the first valid value for every column
# This creates a "Master Record" for each supplier found in the other companies
lookup_table = df_others.groupby('MATCH_KEY').first()

# --- 4. Fill Missing Values in MARS Rows ---
# We loop through columns to fill NaNs
# Note: 'lookup_table' index is now the MATCH_KEY
cols_to_fill = [c for c in df.columns if c not in ['COMPANY', 'MATCH_KEY']]

for col in cols_to_fill:
    if col in lookup_table.columns:
        # Map the cleaned name to the value in the lookup table
        mapped_values = df_mars['MATCH_KEY'].map(lookup_table[col])

        # Fill NaN values in df_mars with the mapped values
        df_mars[col] = df_mars[col].fillna(mapped_values)

# --- 5. Update the Original DataFrame ---
# Update the original df with the filled MARS rows
df.loc[mars_mask] = df_mars

# Drop the temporary key column
df.drop(columns=['MATCH_KEY'], inplace=True)

# Verify
print("Missing values filled using cross-company matches.")
# Show a sample check: Rows that are MARS and have a Latitude filled (assuming it was missing before)
print(df[df['COMPANY'] == 'MARS'][['DISCL_SUPPLIER_ABRVNAME', 'DISCL_LATITUDE']].head())
Missing values filled using cross-company matches.
     DISCL_SUPPLIER_ABRVNAME  DISCL_LATITUDE
1556             ECAM SCOOPS        6.818539
1557           SOCAG COOP-CA        5.692900
1558      SOCOOPALAO COOP-CA        5.106291
1559           BENKADI COOPS        5.821985
1560                  COOPAC        5.736837
#df.to_csv('/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/2024_civ_coops_with_geocodes.csv', index=False)
# Create a mask for the specific company
mask_bc = df['COMPANY'] == "BARRY CALLEBAUT AG"

# Replace " WAREHOUSE" with an empty string for those rows
# regex=False ensures it treats " WAREHOUSE" as literal text
df.loc[mask_bc, 'DISCL_SUPPLIER_ABRVNAME'] = df.loc[mask_bc, 'DISCL_SUPPLIER_ABRVNAME'].str.replace(" WAREHOUSE", "", regex=False)

# Verify a few examples
print(df.loc[mask_bc, ['COMPANY', 'DISCL_SUPPLIER_ABRVNAME']].head())
               COMPANY DISCL_SUPPLIER_ABRVNAME
47  BARRY CALLEBAUT AG                 SOCOPAD
48  BARRY CALLEBAUT AG               AJAMI ALY
49  BARRY CALLEBAUT AG                    CAPA
50  BARRY CALLEBAUT AG               COOPAAAKO
51  BARRY CALLEBAUT AG                 COOPAAF

match column names to CAM_coopyear.csv

df.columns, cam.columns
(Index(['DISCL_TRADER_NAME', 'DISCL_SUPPLIER_ABRVNAME', 'DISCL_AREA_NAME',
        'DISCL_CERTIFICATION_NAME', 'DISCL_NUMBER_FARMERS', 'DISCL_LONGITUDE',
        'DISCL_LATITUDE', 'DISCL_COUNTRY_NAME', 'DISCL_YEAR', 'COMPANY',
        'DISCL_SUPPLIER_FULLNAME', 'DISCL_VOLUMES', 'DISCL_VOLUMES_UNIT',
        'DISCL_CERTIFICATION_PCT', 'DISTRICT_GEOCODE', 'CAM_BUYERS',
        'IS_CAM_V3', 'IS_JRC', 'JRC_BUYER_ID', 'DISCL_SUPPLIER_TYPE'],
       dtype='object'),
 Index(['COOP_ID', 'YEAR', 'SUPPLIER_ABRVNAME', 'SUPPLIER_FULLNAME', 'LATITUDE',
        'LONGITUDE', 'DISTRICT_NAME', 'DISTRICT_GEOCODE', 'DISCLOSURE_SOURCES',
        'TRADER_NAMES', 'CERTIFIED', 'CERTIFICATIONS',
        'TOTAL_FARMERS_NONTRADER', 'TOTAL_FARMERS_TRADER', 'TOTAL_FARMERS',
        'DISCL_COUNTRY_NAME', 'DISCL_AREA_NAME', 'DISCL_SUPPLIER_ABRVNAME',
        'DISCL_SUPPLIER_FULLNAME', 'DISCL_SUPPLIER_TYPE', 'DISCL_LONGITUDE',
        'DISCL_LATITUDE', 'DISCL_VOLUMES', 'DISCL_VOLUMES_UNIT',
        'DISCL_CERTIFICATION_NAME', 'DISCL_CERTIFICATION_PCT',
        'SIMPLIF_ABRVNAME', 'CCTN_COOP_ID', 'IS_ALL_CAM_V3', 'IS_ANY_CAM_V3',
        'NB_FARMERS_COMPANY_YEAR', '!NOT_RFA', 'unique_rfa_link',
        'TOTAL_FARMERS_RFA', 'LVL_4_NAME', 'REPEATED_FROM_PAST_YEAR'],
       dtype='object'))
import pandas as pd

df = pd.read_csv("/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/2024_civ_coops_with_geocodes.csv")

# 1. Define a mapping for columns that exist in both but have different names.
column_mapping = {
    'DISCL_YEAR': 'YEAR',
    'DISCL_AREA_NAME':'DISTRICT_NAME', 
    'DISCL_TRADER_NAME': 'TRADER_NAMES',
    'DISCL_NUMBER_FARMERS': 'TOTAL_FARMERS',
    'DISCL_LATITUDE':'LATITUDE',
    'DISCL_LONGITUDE':'LONGITUDE'
}

# 2. Rename the columns in df
df = df.rename(columns=column_mapping)

# 3. Reindex df to match cam exactly
# This adds missing columns (filled with NaN), drops extras, and fixes the order.
df = df.reindex(columns=cam.columns)

df.SUPPLIER_ABRVNAME, df.SUPPLIER_FULLNAME = df.DISCL_SUPPLIER_ABRVNAME, df.DISCL_SUPPLIER_FULLNAME
df.COOP_ID = df.index

# Verify the result
print("Columns match:", df.columns.equals(cam.columns))
Columns match: True
df
COOP_ID YEAR SUPPLIER_ABRVNAME SUPPLIER_FULLNAME LATITUDE LONGITUDE DISTRICT_NAME DISTRICT_GEOCODE DISCLOSURE_SOURCES TRADER_NAMES ... SIMPLIF_ABRVNAME CCTN_COOP_ID IS_ALL_CAM_V3 IS_ANY_CAM_V3 NB_FARMERS_COMPANY_YEAR !NOT_RFA unique_rfa_link TOTAL_FARMERS_RFA LVL_4_NAME REPEATED_FROM_PAST_YEAR
0 0 2024 NaN SOCIETE COOPERATIVE BENKADI DE SIAKAKRO 7.135274 -3.204332 AGNIBILEKRO CI-3.1.2_1 NaN BARRY CALLEBAUT ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1 1 2024 NaN SOCIETE COOPERATIVE ANOUANZE DES PRODUCTEURS D... 6.720262 -3.494930 ABENGOUROU CI-3.1.1_1 NaN BARRY CALLEBAUT ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
2 2 2024 NaN SOCIETE COOPERATIVE AGRICOLE AHUANOU D'ARRAH NaN NaN BONGOUANOU CI-6.3.2_1 NaN BARRY CALLEBAUT ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
3 3 2024 NaN COOPERATIVE AGRICOLE TELIN 5.876620 -7.455261 BANGOLO CI-8.2.1_1 NaN BARRY CALLEBAUT ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
4 4 2024 NaN COOPERATIVE AGRICOLE IMAAH, COOPERATIVE SIMPLI... NaN NaN DIVO CI-5.2.1_1 NaN BARRY CALLEBAUT ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
1803 1803 2024 SCOOPANAB COOP – CA SOCIETE COOPERATIVE AGRICOLE NOUVELLE ALLIANCE... 4.956798 -6.084600 BANGOLO CI-8.2.1_1 NaN ECOM ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1804 1804 2024 CAFUGO COOP CA COOPÉRATIVE AGRICOLE DES FRÈRES UNIS DE GOBROKO 4.957198 -6.086585 SASSANDRA CI-2.1.2_1 NaN ECOM ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1805 1805 2024 COOP-CCAPUO SOCIETE COOPERATIVE AVEC CONSEIL D`ADMINISTRAT... 6.747380 -7.362460 DUEKOUE CI-8.2.2_1 NaN ECOM ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1806 1806 2024 COOP_CA_UDAN SOCIETE COOPERATIVE AVEC CONSEIL D’ADMINISTRAT... 7.252397 -8.150575 DANANE CI-8.3.2_1 NaN ECOM ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
1807 1807 2024 YEBOYOKON SCOOPS SOCIETE COOPERATIVE AGRICOLE YEBOYOKON DE DAIR... NaN NaN DIVO CI-5.2.1_1 NaN ECOM ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN

1808 rows × 36 columns

df.to_csv('/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/2024_civ_coops_cam_format.csv', index=False)
import pandas as pd

# 1. LOAD DATA
new_df = pd.read_csv("/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/2024_civ_coops_cam_format.csv")
old_df = pd.read_csv("/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/out/CAM_coopyear.csv", sep=';', na_values=['NA', 'nan', ''])

# 2. FILTER OLD DATA
old_df = old_df[old_df.YEAR == 2023]

# 3. DEFINE THE MATCHING KEY
join_key = 'SUPPLIER_ABRVNAME'

# Clean the key column (remove extra spaces) to ensure matches work
new_df[join_key] = new_df[join_key].astype(str).str.strip()
old_df[join_key] = old_df[join_key].astype(str).str.strip()

# 4. IMPUTE MISSING VALUES
# Identify columns that exist in both files
common_cols = [col for col in new_df.columns if col in old_df.columns and col != join_key]

print(f"Imputing data based on key: {join_key}...")

# Create a reference dictionary from the old dataframe (remove duplicates to keep unique keys)
old_df_clean = old_df.dropna(subset=[join_key]).drop_duplicates(subset=[join_key])

for col in common_cols:
    # Check how many empty values we have before filling
    missing_before = new_df[col].isna().sum()

    # Create a map: { 'Supplier Name' : 'Old Value' }
    mapping = old_df_clean.set_index(join_key)[col]

    # Fill NaN values in the new_df using the map
    new_df[col] = new_df[col].fillna(new_df[join_key].map(mapping))

    # Check improvements
    missing_after = new_df[col].isna().sum()
    filled_count = missing_before - missing_after

    if filled_count > 0:
        print(f"  -> Filled {filled_count} missing values in column '{col}'")

# --- NEW STEP: Fill any remaining NaN values with 'NA' ---
new_df.REPEATED_FROM_PAST_YEAR = 'NA'
new_df = new_df.fillna('NA')

# 5. SAVE THE RESULT
output_csv_path = '/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/2024_civ_coops_cam_format_imputed.csv'
new_df.to_csv(output_csv_path, sep=';', index=False, na_rep='NA')

print(f"\nSuccess! Imputed file saved to: {output_csv_path}")
Imputing data based on key: SUPPLIER_ABRVNAME...
  -> Filled 738 missing values in column 'SUPPLIER_FULLNAME'
  -> Filled 133 missing values in column 'LATITUDE'
  -> Filled 133 missing values in column 'LONGITUDE'
  -> Filled 2 missing values in column 'DISTRICT_NAME'
  -> Filled 2 missing values in column 'DISTRICT_GEOCODE'
  -> Filled 818 missing values in column 'DISCLOSURE_SOURCES'
  -> Filled 70 missing values in column 'TRADER_NAMES'
  -> Filled 818 missing values in column 'CERTIFIED'
  -> Filled 746 missing values in column 'CERTIFICATIONS'
  -> Filled 818 missing values in column 'TOTAL_FARMERS_NONTRADER'
  -> Filled 818 missing values in column 'TOTAL_FARMERS_TRADER'
  -> Filled 647 missing values in column 'TOTAL_FARMERS'
  -> Filled 363 missing values in column 'DISCL_AREA_NAME'
  -> Filled 305 missing values in column 'DISCL_SUPPLIER_FULLNAME'
  -> Filled 430 missing values in column 'DISCL_LONGITUDE'
  -> Filled 430 missing values in column 'DISCL_LATITUDE'
  -> Filled 12 missing values in column 'DISCL_VOLUMES'
  -> Filled 12 missing values in column 'DISCL_VOLUMES_UNIT'
  -> Filled 549 missing values in column 'DISCL_CERTIFICATION_NAME'
  -> Filled 14 missing values in column 'DISCL_CERTIFICATION_PCT'
  -> Filled 883 missing values in column 'SIMPLIF_ABRVNAME'
  -> Filled 818 missing values in column 'CCTN_COOP_ID'
  -> Filled 921 missing values in column 'IS_ALL_CAM_V3'
  -> Filled 921 missing values in column 'IS_ANY_CAM_V3'
  -> Filled 393 missing values in column 'NB_FARMERS_COMPANY_YEAR'
  -> Filled 818 missing values in column '!NOT_RFA'
  -> Filled 818 missing values in column 'unique_rfa_link'
  -> Filled 818 missing values in column 'TOTAL_FARMERS_RFA'
  -> Filled 670 missing values in column 'LVL_4_NAME'
  -> Filled 921 missing values in column 'REPEATED_FROM_PAST_YEAR'

Success! Imputed file saved to: /Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/2024_civ_coops_cam_format_imputed.csv


/var/folders/3r/r9b5rj5s3pb069rsg5zh_1640000gn/T/ipykernel_47536/1812401427.py:5: DtypeWarning: Columns (6,8,9,10,11,19,23,24,27,31,32,34) have mixed types. Specify dtype option on import or set low_memory=False.
  old_df = pd.read_csv("/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/out/CAM_coopyear.csv", sep=';', na_values=['NA', 'nan', ''])
import pandas as pd

# 1. LOAD DATA
new_df = pd.read_csv("/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/2024_civ_coops_cam_format_imputed.csv",sep=';', na_values=['NA', 'nan', ''])
old_df = pd.read_csv("/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/out/CAM_coopyear.csv", sep=';', na_values=['NA', 'nan', ''])

# 2. FILTER OLD DATA
old_df = old_df[old_df.YEAR == 2023]

# 3. DEFINE THE MATCHING KEY
join_key = 'SUPPLIER_FULLNAME'

# Clean the key column (remove extra spaces) to ensure matches work
new_df[join_key] = new_df[join_key].astype(str).str.strip()
old_df[join_key] = old_df[join_key].astype(str).str.strip()

# 4. IMPUTE MISSING VALUES
# Identify columns that exist in both files
common_cols = [col for col in new_df.columns if col in old_df.columns and col != join_key]

print(f"Imputing data based on key: {join_key}...")

# Create a reference dictionary from the old dataframe (remove duplicates to keep unique keys)
old_df_clean = old_df.dropna(subset=[join_key]).drop_duplicates(subset=[join_key])

for col in common_cols:
    # Check how many empty values we have before filling
    missing_before = new_df[col].isna().sum()

    # Create a map: { 'Supplier Name' : 'Old Value' }
    mapping = old_df_clean.set_index(join_key)[col]

    # Fill NaN values in the new_df using the map
    new_df[col] = new_df[col].fillna(new_df[join_key].map(mapping))

    # Check improvements
    missing_after = new_df[col].isna().sum()
    filled_count = missing_before - missing_after

    if filled_count > 0:
        print(f"  -> Filled {filled_count} missing values in column '{col}'")

# --- NEW STEP: Fill any remaining NaN values with 'NA' ---
new_df.REPEATED_FROM_PAST_YEAR = 'NA'
new_df = new_df.fillna('NA')

# 5. SAVE THE RESULT
output_csv_path = '/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/2024_civ_coops_cam_format_imputed.csv'
new_df.to_csv(output_csv_path, sep=';', index=False, na_rep='NA')

print(f"\nSuccess! Imputed file saved to: {output_csv_path}")
Imputing data based on key: SUPPLIER_FULLNAME...
  -> Filled 3 missing values in column 'SUPPLIER_ABRVNAME'
  -> Filled 9 missing values in column 'LATITUDE'
  -> Filled 9 missing values in column 'LONGITUDE'
  -> Filled 759 missing values in column 'DISCLOSURE_SOURCES'
  -> Filled 48 missing values in column 'TRADER_NAMES'
  -> Filled 759 missing values in column 'CERTIFIED'
  -> Filled 4 missing values in column 'CERTIFICATIONS'
  -> Filled 759 missing values in column 'TOTAL_FARMERS_NONTRADER'
  -> Filled 759 missing values in column 'TOTAL_FARMERS_TRADER'
  -> Filled 603 missing values in column 'TOTAL_FARMERS'
  -> Filled 12 missing values in column 'DISCL_AREA_NAME'
  -> Filled 3 missing values in column 'DISCL_SUPPLIER_ABRVNAME'
  -> Filled 4 missing values in column 'DISCL_SUPPLIER_FULLNAME'
  -> Filled 11 missing values in column 'DISCL_LONGITUDE'
  -> Filled 11 missing values in column 'DISCL_LATITUDE'
  -> Filled 3 missing values in column 'DISCL_CERTIFICATION_NAME'
  -> Filled 759 missing values in column 'SIMPLIF_ABRVNAME'
  -> Filled 759 missing values in column 'CCTN_COOP_ID'
  -> Filled 756 missing values in column 'IS_ALL_CAM_V3'
  -> Filled 756 missing values in column 'IS_ANY_CAM_V3'
  -> Filled 11 missing values in column 'NB_FARMERS_COMPANY_YEAR'
  -> Filled 759 missing values in column '!NOT_RFA'
  -> Filled 759 missing values in column 'unique_rfa_link'
  -> Filled 759 missing values in column 'TOTAL_FARMERS_RFA'
  -> Filled 9 missing values in column 'LVL_4_NAME'
  -> Filled 1532 missing values in column 'REPEATED_FROM_PAST_YEAR'

Success! Imputed file saved to: /Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/2024_civ_coops_cam_format_imputed.csv


/var/folders/3r/r9b5rj5s3pb069rsg5zh_1640000gn/T/ipykernel_47536/2882326006.py:5: DtypeWarning: Columns (6,8,9,10,11,19,23,24,27,31,32,34) have mixed types. Specify dtype option on import or set low_memory=False.
  old_df = pd.read_csv("/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/out/CAM_coopyear.csv", sep=';', na_values=['NA', 'nan', ''])
new_df.columns
Index(['COOP_ID', 'YEAR', 'SUPPLIER_ABRVNAME', 'SUPPLIER_FULLNAME', 'LATITUDE',
       'LONGITUDE', 'DISTRICT_NAME', 'DISTRICT_GEOCODE', 'DISCLOSURE_SOURCES',
       'TRADER_NAMES', 'CERTIFIED', 'CERTIFICATIONS',
       'TOTAL_FARMERS_NONTRADER', 'TOTAL_FARMERS_TRADER', 'TOTAL_FARMERS',
       'DISCL_COUNTRY_NAME', 'DISCL_AREA_NAME', 'DISCL_SUPPLIER_ABRVNAME',
       'DISCL_SUPPLIER_FULLNAME', 'DISCL_SUPPLIER_TYPE', 'DISCL_LONGITUDE',
       'DISCL_LATITUDE', 'DISCL_VOLUMES', 'DISCL_VOLUMES_UNIT',
       'DISCL_CERTIFICATION_NAME', 'DISCL_CERTIFICATION_PCT',
       'SIMPLIF_ABRVNAME', 'CCTN_COOP_ID', 'IS_ALL_CAM_V3', 'IS_ANY_CAM_V3',
       'NB_FARMERS_COMPANY_YEAR', '!NOT_RFA', 'unique_rfa_link',
       'TOTAL_FARMERS_RFA', 'LVL_4_NAME', 'REPEATED_FROM_PAST_YEAR'],
      dtype='object')
new_df = pd.read_csv("/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/2024_civ_coops_cam_format_imputed.csv",sep=';', na_values=['NA', 'nan', ''])

new_df.drop(columns="COOP_ID", inplace=True)

print(len(new_df))
new_df.drop_duplicates(inplace=True)
print(len(new_df))

new_df.reset_index(drop=True, inplace=True)

# Insert the new COOP_ID at the very beginning (position 0)
new_df.insert(0, 'COOP_ID', new_df.index)

# Save the file
# na_rep='NA' ensures empty values are saved as 'NA' instead of empty strings
new_df.to_csv(output_csv_path, sep=';', index=False, na_rep='NA')
1808
1531
# The file I have made matches the structure of cam_coopyear. Make a second file with flow ids (i.e. with format of cam_long)

# REMOVE DUPLICATES -----------------------------
# At this point, within a year, several rows can reflect the same coop obviously 
# (as several companies may have disclosed to buy from the same coop), 
# but also the same link can come from different sources of disclosure data - typically, the previous CAM and data scraped by UCLouvain team). 

# We thus remove duplicates (i.e. make row ids) in 2 different ways: 
# 1- one row per coop per year (aggregating across links) - which is what we publish 
# 2- one row per actual link (aggregating across sources) - which is what is inputed in SEI-PCS. 

# (we DON'T try to make one row per sourcing flow (links to several companies that are on different stages of the supply chain are merged))

coops_24 = pd.read_csv("/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/2024_civ_coops_cam_format_imputed.csv",sep=';', na_values=['NA', 'nan', ''])

print(len(coops_24))
civ_coopyear = coops_24.drop_duplicates(subset='SUPPLIER_ABRVNAME')
print(len(civ_coopyear))

civ_coopyear.to_csv("/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/2024_civ_coops_like_cam_coopyear.csv", sep=';', index=False, na_rep='NA')
1531
1085
import pandas as pd
import numpy as np

# Load source data
cam_long_23 = pd.read_csv("/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/out/CAM_seipcs_2023.csv", sep=';', na_values=['NA', 'nan', ''])

# Create a copy to avoid SettingWithCopy warnings
civ_seipcs = coops_24.copy()

civ_seipcs = civ_seipcs.replace(r'^\s*$', np.nan, regex=True)

# 1. Handle ABRVNAME (fill in both directions)
civ_seipcs['SUPPLIER_ABRVNAME'] = civ_seipcs['SUPPLIER_ABRVNAME'].fillna(civ_seipcs['DISCL_SUPPLIER_ABRVNAME'])
civ_seipcs['SUPPLIER_ABRVNAME'] = civ_seipcs['SUPPLIER_ABRVNAME'].fillna(civ_seipcs['SUPPLIER_FULLNAME'])
civ_seipcs['SUPPLIER_ABRVNAME'] = civ_seipcs['SUPPLIER_ABRVNAME'].fillna(civ_seipcs['DISCL_SUPPLIER_FULLNAME'])
civ_seipcs['DISCL_SUPPLIER_ABRVNAME'] = civ_seipcs['DISCL_SUPPLIER_ABRVNAME'].fillna(civ_seipcs['SUPPLIER_ABRVNAME'])

# 2. Handle FULLNAME (fill in both directions)
civ_seipcs['SUPPLIER_FULLNAME'] = civ_seipcs['SUPPLIER_FULLNAME'].fillna(civ_seipcs['DISCL_SUPPLIER_FULLNAME'])
civ_seipcs['SUPPLIER_FULLNAME'] = civ_seipcs['SUPPLIER_FULLNAME'].fillna(civ_seipcs['SUPPLIER_ABRVNAME'])
civ_seipcs['SUPPLIER_FULLNAME'] = civ_seipcs['SUPPLIER_FULLNAME'].fillna(civ_seipcs['DISCL_SUPPLIER_ABRVNAME'])
civ_seipcs['DISCL_SUPPLIER_FULLNAME'] = civ_seipcs['DISCL_SUPPLIER_FULLNAME'].fillna(civ_seipcs['SUPPLIER_FULLNAME'])

print(civ_seipcs.columns)

# --- 1. Create BUYER Variable ---
civ_seipcs['BUYER'] = np.where(
    (civ_seipcs['TRADER_NAMES'].isna()) & (civ_seipcs['DISCLOSURE_SOURCES'] != "RAINFOREST ALLIANCE"),
    civ_seipcs['DISCLOSURE_SOURCES'],
    civ_seipcs['TRADER_NAMES']
)

# --- 2. Handle Certifications ---
def aggregate_certs(series):
    items = []
    for x in series:
        if isinstance(x, list):
            items.extend(x)
        elif pd.notna(x):
            items.append(x)
    unique_items = sorted(list(set(items)))
    return " + ".join(unique_items)

civ_seipcs['CERTIFICATIONS'] = civ_seipcs.groupby(['COOP_ID', 'YEAR', 'BUYER'])['DISCL_CERTIFICATION_NAME'].transform(aggregate_certs)

# --- 3. Distinct (Slice the first row per group) ---
civ_seipcs = civ_seipcs.drop_duplicates(
    subset=['COOP_ID', 'YEAR', 'BUYER'], 
    keep='first'
)

# --- 4. Create FLOW_ID ---
civ_seipcs['row_num'] = civ_seipcs.groupby('YEAR').cumcount() + 1
civ_seipcs['FLOW_ID'] = civ_seipcs['YEAR'].astype(str) + "-" + civ_seipcs['row_num'].astype(str)

# --- 5. Select and Drop Columns ---
cert_cols = [c for c in civ_seipcs.columns if c.startswith('CERT_') and c != 'CERTIFICATIONS']
cols_to_drop = [
    'DISCL_TRADER_NAME', 'LOCALITY_NAME', 'CAM_BUYERS', 'NOT_RFA',
    'unique_company_link', 'unique_trader_link', 'row_num'
] + cert_cols

civ_seipcs = civ_seipcs.drop(columns=[c for c in cols_to_drop if c in civ_seipcs.columns])

# Fix: Use civ_seipcs instead of df (assuming typo in original snippet)
civ_seipcs['COMPANY'] = civ_seipcs['DISCLOSURE_SOURCES']

# --- IMPUTATION STEP ---
# Prepare lookup table from cam_long_23 (remove duplicates to ensure 1-to-1 match on supplier)
cam_lookup = cam_long_23[['SUPPLIER_ABRVNAME', 'NUM_FARMERS', 'NUM_FARMERS_EXTRAPOLATED']].drop_duplicates(subset=['SUPPLIER_ABRVNAME'])

# Merge into civ_seipcs
# suffixes=('_old', '') ensures that if these columns existed, the new ones from CAM are kept as the main columns
civ_seipcs = civ_seipcs.merge(
    cam_lookup, 
    on='SUPPLIER_ABRVNAME', 
    how='left', 
    suffixes=('_old', '')
)

# Optional: Clean up if columns existed previously (remove _old versions)
cols_to_clean = ['NUM_FARMERS_old', 'NUM_FARMERS_EXTRAPOLATED_old']
civ_seipcs.drop(columns=[c for c in cols_to_clean if c in civ_seipcs.columns], inplace=True)

# --- 6. Reorder Columns ---
front_cols = [
    'FLOW_ID', 'COOP_ID', 'YEAR', 'SUPPLIER_ABRVNAME', 'SUPPLIER_FULLNAME', 
    'LATITUDE', 'LONGITUDE', 'DISTRICT_NAME', 'DISTRICT_GEOCODE',
    'BUYER', 'COMPANY', 'TRADER_NAMES', 'CERTIFICATIONS',
    'NUM_FARMERS', 'NUM_FARMERS_EXTRAPOLATED',
    'TOTAL_FARMERS_NONTRADER', 'TOTAL_FARMERS_TRADER', 'TOTAL_FARMERS_RFA', 'TOTAL_FARMERS'
]

# Append remaining columns that are not in front_cols
remaining_cols = [c for c in civ_seipcs.columns if c not in front_cols]
civ_seipcs = civ_seipcs[front_cols + remaining_cols]

civ_seipcs['IS_TRADER'] = civ_seipcs['DISCLOSURE_SOURCES'] == civ_seipcs['TRADER_NAMES']
civ_seipcs['LVL_4_NAME'] = civ_seipcs['DISTRICT_GEOCODE']
Index(['COOP_ID', 'YEAR', 'SUPPLIER_ABRVNAME', 'SUPPLIER_FULLNAME', 'LATITUDE',
       'LONGITUDE', 'DISTRICT_NAME', 'DISTRICT_GEOCODE', 'DISCLOSURE_SOURCES',
       'TRADER_NAMES', 'CERTIFIED', 'CERTIFICATIONS',
       'TOTAL_FARMERS_NONTRADER', 'TOTAL_FARMERS_TRADER', 'TOTAL_FARMERS',
       'DISCL_COUNTRY_NAME', 'DISCL_AREA_NAME', 'DISCL_SUPPLIER_ABRVNAME',
       'DISCL_SUPPLIER_FULLNAME', 'DISCL_SUPPLIER_TYPE', 'DISCL_LONGITUDE',
       'DISCL_LATITUDE', 'DISCL_VOLUMES', 'DISCL_VOLUMES_UNIT',
       'DISCL_CERTIFICATION_NAME', 'DISCL_CERTIFICATION_PCT',
       'SIMPLIF_ABRVNAME', 'CCTN_COOP_ID', 'IS_ALL_CAM_V3', 'IS_ANY_CAM_V3',
       'NB_FARMERS_COMPANY_YEAR', '!NOT_RFA', 'unique_rfa_link',
       'TOTAL_FARMERS_RFA', 'LVL_4_NAME', 'REPEATED_FROM_PAST_YEAR'],
      dtype='object')


/var/folders/3r/r9b5rj5s3pb069rsg5zh_1640000gn/T/ipykernel_47536/2804419595.py:5: DtypeWarning: Columns (7,9,10,11,12,23,28,29,32,35,37,38,39,40,41) have mixed types. Specify dtype option on import or set low_memory=False.
  cam_long_23 = pd.read_csv("/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/out/CAM_seipcs_2023.csv", sep=';', na_values=['NA', 'nan', ''])
civ_seipcs.NUM_FARMERS.describe()
count     339.000000
mean      784.601770
std       548.883378
min       145.000000
25%       429.000000
50%       614.000000
75%       950.000000
max      3477.000000
Name: NUM_FARMERS, dtype: float64
civ_seipcs.to_csv("/Users/niamhfrench/Library/CloudStorage/OneDrive-SEI/Documents/TRASE/trase/data/cote_divoire/cocoa/logistics/q4_2025/clean/2024_civ_coops_like_cam_long.csv", sep=';', index=False, na_rep='NA')