Skip to content

Instantly share code, notes, and snippets.

@tbicr

tbicr/aid2_belarus.ipynb

Created July 8, 2014 20:00
Show Gist options
  • Save tbicr/eafd1bd5c09cb2cb25d6 to your computer and use it in GitHub Desktop.
Save tbicr/eafd1bd5c09cb2cb25d6 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
aid2_belarus.ipynb
{
"metadata": {
"name": "",
"signature": "sha256:8b8c7d2333095636639ed83eb3ec9d86f02936231a9e861be38a165b49e2396e"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "code",
"collapsed": false,
"input": [
"import pandas as pd\n",
"\n",
"\n",
"INPUT_DATA_FILE = 'aiddata2-1_research release.csv'\n",
"OUTPUT_DATA_FILE = 'aiddata_belarus.csv'\n",
"\n",
"\n",
"df = pd.read_csv(INPUT_DATA_FILE)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stderr",
"text": [
"/home/tbicr/Project/env34/lib/python3.4/site-packages/pandas/io/excel.py:626: UserWarning: Installed openpyxl is not supported at this time. Use >=1.6.1 and <2.0.0.\n",
" .format(openpyxl_compat.start_ver, openpyxl_compat.stop_ver))\n",
"/home/tbicr/Project/env34/lib/python3.4/site-packages/pandas/io/parsers.py:1130: DtypeWarning: Columns (0,2,8,10,17,20,21,22,23,33,38,40,41,42,47,48,49,50,52,53,54,61,72,73,74,77,87) have mixed types. Specify dtype option on import or set low_memory=False.\n",
" data = self._reader.read(nrows)\n"
]
}
],
"prompt_number": 1
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"show all columns"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"sorted(df.columns)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 2,
"text": [
"['additional_info',\n",
" 'additional_info_original_language',\n",
" 'aiddata_activity_code',\n",
" 'aiddata_activity_name',\n",
" 'aiddata_feasibility_study',\n",
" 'aiddata_id',\n",
" 'aiddata_is_conflict',\n",
" 'aiddata_purpose_code',\n",
" 'aiddata_purpose_name',\n",
" 'aiddata_technical_assistance',\n",
" 'arrears_interest_amount_usd_nominal',\n",
" 'arrears_principal_amount_usd_nominal',\n",
" 'associated_financing',\n",
" 'beneficiary',\n",
" 'bi_multi',\n",
" 'biodiversity',\n",
" 'borrower',\n",
" 'cancelled',\n",
" 'channel_code',\n",
" 'climate',\n",
" 'coalesced_purpose_code',\n",
" 'coalesced_purpose_name',\n",
" 'commitment_amount',\n",
" 'commitment_amount_currency',\n",
" 'commitment_amount_usd_constant',\n",
" 'commitment_amount_usd_nominal',\n",
" 'commitment_date',\n",
" 'crs_flow_name',\n",
" 'crs_purpose_code',\n",
" 'crs_purpose_name',\n",
" 'crsid',\n",
" 'desertification',\n",
" 'disbursement_amount',\n",
" 'disbursement_amount_currency',\n",
" 'disbursement_amount_usd_constant',\n",
" 'disbursement_amount_usd_nominal',\n",
" 'donor',\n",
" 'donor_iso2',\n",
" 'donor_iso3',\n",
" 'donor_project_id',\n",
" 'donor_type',\n",
" 'end_date',\n",
" 'environment',\n",
" 'environmental_impact_assessment',\n",
" 'expert_commitment_amount_usd_nominal',\n",
" 'expert_extended_amount_usd_nominal',\n",
" 'export_credit_amount_usd_nominal',\n",
" 'finance_t',\n",
" 'financing_agency',\n",
" 'flow_type',\n",
" 'ftc',\n",
" 'future_ds_interest_amount_usd_nominal',\n",
" 'future_ds_principal_amount_usd_nominal',\n",
" 'gender',\n",
" 'grace_period',\n",
" 'grant_element',\n",
" 'guarantor',\n",
" 'implementing_agency',\n",
" 'initial_report',\n",
" 'interest_rate',\n",
" 'investment_project',\n",
" 'irtc_amount_usd_nominal',\n",
" 'language',\n",
" 'loan_term',\n",
" 'location',\n",
" 'long_description',\n",
" 'long_description_original_language',\n",
" 'number_repayments_per_year',\n",
" 'other_involved_institutions',\n",
" 'outstanding_amount_usd_nominal',\n",
" 'partial_tied_amount_usd_nominal',\n",
" 'pdgg',\n",
" 'private_recipient',\n",
" 'received_amount_usd_nominal',\n",
" 'recipient',\n",
" 'recipient_iso2',\n",
" 'recipient_iso3',\n",
" 'region',\n",
" 'repay_date_first',\n",
" 'repay_date_last',\n",
" 'repay_type',\n",
" 'second_interest_rate',\n",
" 'sector',\n",
" 'sector_code',\n",
" 'sector_programme',\n",
" 'short_description',\n",
" 'short_description_original_language',\n",
" 'source',\n",
" 'start_date',\n",
" 'tied_amount_usd_nominal',\n",
" 'title',\n",
" 'total_project_cost',\n",
" 'total_project_cost_currency',\n",
" 'total_project_cost_usd_constant',\n",
" 'total_project_cost_usd_nominal',\n",
" 'trade',\n",
" 'umbrella',\n",
" 'untied_amount_usd_nominal',\n",
" 'year']"
]
}
],
"prompt_number": 2
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"show coluns only wit coutry iso"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"[column for column in sorted(df.columns) if 'iso' in column]"
],
"language": "python",
"metadata": {},
"outputs": [
{
"metadata": {},
"output_type": "pyout",
"prompt_number": 3,
"text": [
"['donor_iso2', 'donor_iso3', 'recipient_iso2', 'recipient_iso3']"
]
}
],
"prompt_number": 3
},
{
"cell_type": "raw",
"metadata": {},
"source": [
"show Belarus donors"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"df[df.donor_iso2 == 'BY']"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>aiddata_id</th>\n",
" <th>year</th>\n",
" <th>commitment_date</th>\n",
" <th>start_date</th>\n",
" <th>end_date</th>\n",
" <th>donor</th>\n",
" <th>donor_iso2</th>\n",
" <th>donor_iso3</th>\n",
" <th>umbrella</th>\n",
" <th>donor_project_id</th>\n",
" <th>...</th>\n",
" <th>investment_project</th>\n",
" <th>aiddata_purpose_code</th>\n",
" <th>aiddata_purpose_name</th>\n",
" <th>aiddata_activity_code</th>\n",
" <th>aiddata_activity_name</th>\n",
" <th>aiddata_feasibility_study</th>\n",
" <th>aiddata_technical_assistance</th>\n",
" <th>coalesced_purpose_code</th>\n",
" <th>coalesced_purpose_name</th>\n",
" <th>aiddata_is_conflict</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" </tbody>\n",
"</table>\n",
"<p>0 rows \u00d7 99 columns</p>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 4,
"text": [
"Empty DataFrame\n",
"Columns: [aiddata_id, year, commitment_date, start_date, end_date, donor, donor_iso2, donor_iso3, umbrella, donor_project_id, crsid, financing_agency, donor_type, bi_multi, recipient, recipient_iso2, recipient_iso3, private_recipient, implementing_agency, channel_code, borrower, beneficiary, guarantor, other_involved_institutions, commitment_amount, commitment_amount_currency, commitment_amount_usd_nominal, commitment_amount_usd_constant, disbursement_amount, disbursement_amount_currency, disbursement_amount_usd_nominal, disbursement_amount_usd_constant, total_project_cost, total_project_cost_currency, total_project_cost_usd_nominal, total_project_cost_usd_constant, title, short_description, short_description_original_language, long_description, long_description_original_language, additional_info, additional_info_original_language, flow_type, crs_flow_name, number_repayments_per_year, repay_type, loan_term, grace_period, interest_rate, second_interest_rate, grant_element, cancelled, repay_date_first, repay_date_last, untied_amount_usd_nominal, partial_tied_amount_usd_nominal, tied_amount_usd_nominal, received_amount_usd_nominal, irtc_amount_usd_nominal, expert_commitment_amount_usd_nominal, expert_extended_amount_usd_nominal, export_credit_amount_usd_nominal, outstanding_amount_usd_nominal, arrears_principal_amount_usd_nominal, arrears_interest_amount_usd_nominal, future_ds_principal_amount_usd_nominal, future_ds_interest_amount_usd_nominal, region, location, source, language, biodiversity, climate, desertification, crs_purpose_code, crs_purpose_name, gender, trade, pdgg, ftc, sector_programme, sector, sector_code, associated_financing, initial_report, finance_t, environmental_impact_assessment, environment, investment_project, aiddata_purpose_code, aiddata_purpose_name, aiddata_activity_code, aiddata_activity_name, aiddata_feasibility_study, aiddata_technical_assistance, coalesced_purpose_code, coalesced_purpose_name, aiddata_is_conflict]\n",
"Index: []\n",
"\n",
"[0 rows x 99 columns]"
]
}
],
"prompt_number": 4
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"show Belarus recipients"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"df[df.recipient_iso2 == 'BY']"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>aiddata_id</th>\n",
" <th>year</th>\n",
" <th>commitment_date</th>\n",
" <th>start_date</th>\n",
" <th>end_date</th>\n",
" <th>donor</th>\n",
" <th>donor_iso2</th>\n",
" <th>donor_iso3</th>\n",
" <th>umbrella</th>\n",
" <th>donor_project_id</th>\n",
" <th>...</th>\n",
" <th>investment_project</th>\n",
" <th>aiddata_purpose_code</th>\n",
" <th>aiddata_purpose_name</th>\n",
" <th>aiddata_activity_code</th>\n",
" <th>aiddata_activity_name</th>\n",
" <th>aiddata_feasibility_study</th>\n",
" <th>aiddata_technical_assistance</th>\n",
" <th>coalesced_purpose_code</th>\n",
" <th>coalesced_purpose_name</th>\n",
" <th>aiddata_is_conflict</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>333 </th>\n",
" <td> 95978951</td>\n",
" <td> 2010</td>\n",
" <td> NaN</td>\n",
" <td> 2010-01-01 00:00:00</td>\n",
" <td> 2010-12-31 00:00:00</td>\n",
" <td> Sweden</td>\n",
" <td> SE</td>\n",
" <td> SWE</td>\n",
" <td> NaN</td>\n",
" <td> SI2010-8</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 16061</td>\n",
" <td> Culture and recreation</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>640 </th>\n",
" <td> 27398238</td>\n",
" <td> 2003</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Switzerland</td>\n",
" <td> CH</td>\n",
" <td> CHE</td>\n",
" <td> NaN</td>\n",
" <td> 7F-01654.02.01</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 72020</td>\n",
" <td> Emergency health services/support</td>\n",
" <td> 72020.01|72050.01</td>\n",
" <td> All emergency health services/support activiti...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 72020</td>\n",
" <td> Emergency health services/support</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2164 </th>\n",
" <td> 27292579</td>\n",
" <td> 2002</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> United States</td>\n",
" <td> US</td>\n",
" <td> USA</td>\n",
" <td> NaN</td>\n",
" <td> 113021-1093-H</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> 15150.02|15150.01</td>\n",
" <td> Community participation and development|Streng...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3019 </th>\n",
" <td> 10461081</td>\n",
" <td> 1995</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> European Communities (EC)</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 72010</td>\n",
" <td> Material relief assistance and services</td>\n",
" <td> 72010.01</td>\n",
" <td> All non-food relief items and assistance</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 72010</td>\n",
" <td> Material relief assistance and services</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3051 </th>\n",
" <td> 40889426</td>\n",
" <td> 2008</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Lithuania</td>\n",
" <td> LT</td>\n",
" <td> LTU</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> f</td>\n",
" <td> 16010</td>\n",
" <td> Social/ welfare services</td>\n",
" <td> 11120.06|16010.07|16010.02</td>\n",
" <td> Colloquia, seminars, lectures, etc.|Culture an...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 16010</td>\n",
" <td> Social/ welfare services</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3151 </th>\n",
" <td> 26941614</td>\n",
" <td> 1996</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Sweden</td>\n",
" <td> SE</td>\n",
" <td> SWE</td>\n",
" <td> NaN</td>\n",
" <td> 4615530401</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> 15150.08</td>\n",
" <td> Free flow of information</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4035 </th>\n",
" <td> 97591452</td>\n",
" <td> 2010</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Japan</td>\n",
" <td> JP</td>\n",
" <td> JPN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 32171</td>\n",
" <td> Engineering</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5082 </th>\n",
" <td> 27465282</td>\n",
" <td> 2004</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Switzerland</td>\n",
" <td> CH</td>\n",
" <td> CHE</td>\n",
" <td> NaN</td>\n",
" <td> 7F-01764.02.01</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 72010</td>\n",
" <td> Material relief assistance and services</td>\n",
" <td> 72010.01</td>\n",
" <td> All non-food relief items and assistance</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 72010</td>\n",
" <td> Material relief assistance and services</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5143 </th>\n",
" <td> 40887835</td>\n",
" <td> 2008</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Lithuania</td>\n",
" <td> LT</td>\n",
" <td> LTU</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> f</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> 15150.01|15150.08|15110.03</td>\n",
" <td> Strengthening civil society, activity unspecif...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5263 </th>\n",
" <td> 27231625</td>\n",
" <td> 2001</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> United States</td>\n",
" <td> US</td>\n",
" <td> USA</td>\n",
" <td> NaN</td>\n",
" <td> 113-0210-NS-EGOT</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> 15110.01|15150.02|15150.05|31120.01|15140.04|2...</td>\n",
" <td> Economic and development policy/planning, acti...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5476 </th>\n",
" <td> 98613055</td>\n",
" <td> 2010</td>\n",
" <td> NaN</td>\n",
" <td> 2010-10-01 00:00:00</td>\n",
" <td> 2010-11-30 00:00:00</td>\n",
" <td> Germany</td>\n",
" <td> DE</td>\n",
" <td> DEU</td>\n",
" <td> NaN</td>\n",
" <td> 4</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 11430</td>\n",
" <td> Advanced tech. &amp; managerial training</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5879 </th>\n",
" <td> 27409403</td>\n",
" <td> 2004</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Switzerland</td>\n",
" <td> CH</td>\n",
" <td> CHE</td>\n",
" <td> NaN</td>\n",
" <td> 7F-01655.02.01</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 92005</td>\n",
" <td> Support to non-governmental organizations and ...</td>\n",
" <td> 92005.01</td>\n",
" <td> Support to non-governmental organizations and ...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 92005</td>\n",
" <td> Support to non-governmental organizations and ...</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5881 </th>\n",
" <td> 27284789</td>\n",
" <td> 2002</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Germany</td>\n",
" <td> DE</td>\n",
" <td> DEU</td>\n",
" <td> NaN</td>\n",
" <td> 199617689</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 99810</td>\n",
" <td> Sectors not specified</td>\n",
" <td> 99810.01</td>\n",
" <td> All other activities when sector is not specified</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 99810</td>\n",
" <td> Sectors not specified</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6252 </th>\n",
" <td> 27365190</td>\n",
" <td> 2003</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> United States</td>\n",
" <td> US</td>\n",
" <td> USA</td>\n",
" <td> NaN</td>\n",
" <td> 03DCT00031</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 15210</td>\n",
" <td> Security system management and reform</td>\n",
" <td> 15210.01</td>\n",
" <td> Security system management and reform, activit...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 15210</td>\n",
" <td> Security system management and reform</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6264 </th>\n",
" <td> 27209784</td>\n",
" <td> 2001</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> United States</td>\n",
" <td> US</td>\n",
" <td> USA</td>\n",
" <td> NaN</td>\n",
" <td> 113-ES-HRDF</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 16020</td>\n",
" <td> Employment policy and administrative management</td>\n",
" <td> 16020.03|15150.07</td>\n",
" <td> Labor law and labor unions|Human rights</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 16020</td>\n",
" <td> Employment policy and administrative management</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6485 </th>\n",
" <td> 97075657</td>\n",
" <td> 2010</td>\n",
" <td> NaN</td>\n",
" <td> 2010-01-01 00:00:00</td>\n",
" <td> 2010-12-31 00:00:00</td>\n",
" <td> Spain</td>\n",
" <td> ES</td>\n",
" <td> ESP</td>\n",
" <td> NaN</td>\n",
" <td> 2010-BIL-EELL-31490</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 93010</td>\n",
" <td> Refugees in donor countries</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6881 </th>\n",
" <td> 27008498</td>\n",
" <td> 1998</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Canada</td>\n",
" <td> CA</td>\n",
" <td> CAN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 72010</td>\n",
" <td> Material relief assistance and services</td>\n",
" <td> 72010.01</td>\n",
" <td> All non-food relief items and assistance</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 72010</td>\n",
" <td> Material relief assistance and services</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7133 </th>\n",
" <td> 40889439</td>\n",
" <td> 2008</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Lithuania</td>\n",
" <td> LT</td>\n",
" <td> LTU</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> f</td>\n",
" <td> 11420</td>\n",
" <td> Higher education</td>\n",
" <td> 11420.01|15150.01|11120.06|22040.03|16020.03</td>\n",
" <td> Post-secondary education, activity unspecified...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 11420</td>\n",
" <td> Higher education</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7162 </th>\n",
" <td> 41003530</td>\n",
" <td> 2007</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Lithuania</td>\n",
" <td> LT</td>\n",
" <td> LTU</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> f</td>\n",
" <td> 22030</td>\n",
" <td> Radio/television/print media</td>\n",
" <td> 22030.03|16010.05|16010.07</td>\n",
" <td> Print media activities|Support for vulnerable ...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 22030</td>\n",
" <td> Radio/television/print media</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9579 </th>\n",
" <td> 50014315</td>\n",
" <td> 2009</td>\n",
" <td> NaN</td>\n",
" <td> 2009-01-01 00:00:00</td>\n",
" <td> 2009-12-31 00:00:00</td>\n",
" <td> Germany</td>\n",
" <td> DE</td>\n",
" <td> DEU</td>\n",
" <td> NaN</td>\n",
" <td> RUB Bochum04</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 11430</td>\n",
" <td> Advanced tech. &amp; managerial training</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10391 </th>\n",
" <td> 27025468</td>\n",
" <td> 1999</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> United Nations Development Programme (UNDP)</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> BYE97006</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> 15150.08</td>\n",
" <td> Free flow of information</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10941 </th>\n",
" <td> 27299036</td>\n",
" <td> 2002</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Norway</td>\n",
" <td> NO</td>\n",
" <td> NOR</td>\n",
" <td> NaN</td>\n",
" <td> 3020160</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 21005</td>\n",
" <td> Transport and Storage, purpose unspecified or ...</td>\n",
" <td> 21005.01</td>\n",
" <td> Transport and Storage, activity unspecified or...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 21005</td>\n",
" <td> Transport and Storage, purpose unspecified or ...</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11297 </th>\n",
" <td> 26977804</td>\n",
" <td> 1998</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> France</td>\n",
" <td> FR</td>\n",
" <td> FRA</td>\n",
" <td> NaN</td>\n",
" <td> 4A4</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 15130</td>\n",
" <td> Legal and judicial development</td>\n",
" <td> 11420.04|15130.04|15130.03</td>\n",
" <td> Formal and non-formal post-secondary education...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 15130</td>\n",
" <td> Legal and judicial development</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12314 </th>\n",
" <td> 50014393</td>\n",
" <td> 2009</td>\n",
" <td> NaN</td>\n",
" <td> 2009-01-01 00:00:00</td>\n",
" <td> 2009-12-31 00:00:00</td>\n",
" <td> Germany</td>\n",
" <td> DE</td>\n",
" <td> DEU</td>\n",
" <td> NaN</td>\n",
" <td> 6700950</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 11120</td>\n",
" <td> Education facilities and training</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14019 </th>\n",
" <td> 27481402</td>\n",
" <td> 2004</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Switzerland</td>\n",
" <td> CH</td>\n",
" <td> CHE</td>\n",
" <td> NaN</td>\n",
" <td> 7F-02955.02.01</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 12220</td>\n",
" <td> Basic health care</td>\n",
" <td> 13020.03|12220.05</td>\n",
" <td> Prenatal and postnatal care including delivery...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 12220</td>\n",
" <td> Basic health care</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14111 </th>\n",
" <td> 50014312</td>\n",
" <td> 2009</td>\n",
" <td> NaN</td>\n",
" <td> 2009-12-30 00:00:00</td>\n",
" <td> 2012-12-29 00:00:00</td>\n",
" <td> Germany</td>\n",
" <td> DE</td>\n",
" <td> DEU</td>\n",
" <td> NaN</td>\n",
" <td> 209810128</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 31130</td>\n",
" <td> Agricultural land resources</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14474 </th>\n",
" <td> 50046480</td>\n",
" <td> 2009</td>\n",
" <td> NaN</td>\n",
" <td> 2009-01-01 00:00:00</td>\n",
" <td> NaN</td>\n",
" <td> Spain</td>\n",
" <td> ES</td>\n",
" <td> ESP</td>\n",
" <td> NaN</td>\n",
" <td> 5586</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 15130</td>\n",
" <td> Legal and judicial development</td>\n",
" <td> 15130.06</td>\n",
" <td> Law enforcement and crime prevention</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 15130</td>\n",
" <td> Legal and judicial development</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14875 </th>\n",
" <td> 27221396</td>\n",
" <td> 2001</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Netherlands</td>\n",
" <td> NL</td>\n",
" <td> NLD</td>\n",
" <td> NaN</td>\n",
" <td> BY001901</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> 15150.08|15150.03|92005.01</td>\n",
" <td> Free flow of information|Cooperatives|Support ...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14950 </th>\n",
" <td> 27328686</td>\n",
" <td> 2003</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Switzerland</td>\n",
" <td> CH</td>\n",
" <td> CHE</td>\n",
" <td> NaN</td>\n",
" <td> 7F-02913.01.01</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 72010</td>\n",
" <td> Material relief assistance and services</td>\n",
" <td> 72010.01</td>\n",
" <td> All non-food relief items and assistance</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 72010</td>\n",
" <td> Material relief assistance and services</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15034 </th>\n",
" <td> 27418850</td>\n",
" <td> 2004</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Switzerland</td>\n",
" <td> CH</td>\n",
" <td> CHE</td>\n",
" <td> NaN</td>\n",
" <td> 7F-01544.04.01</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 72020</td>\n",
" <td> Emergency health services/support</td>\n",
" <td> 72020.01|72030.01</td>\n",
" <td> All emergency health services/support activiti...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 72020</td>\n",
" <td> Emergency health services/support</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1095825</th>\n",
" <td> 40888294</td>\n",
" <td> 2008</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Lithuania</td>\n",
" <td> LT</td>\n",
" <td> LTU</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> f</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> 22030.03|15150.08</td>\n",
" <td> Print media activities|Free flow of information</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1097332</th>\n",
" <td> 10442468</td>\n",
" <td> 1994</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> United States</td>\n",
" <td> US</td>\n",
" <td> USA</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 11110</td>\n",
" <td> EDUCATION POLICY &amp; ADMIN. MANAGEMENT</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1098145</th>\n",
" <td> 10449254</td>\n",
" <td> 1994</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> United States</td>\n",
" <td> US</td>\n",
" <td> USA</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 12250</td>\n",
" <td> INFECTIOUS DISEASE CONTROL</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1101009</th>\n",
" <td> 3003030</td>\n",
" <td> 2008</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Hungary</td>\n",
" <td> HU</td>\n",
" <td> HUN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> f</td>\n",
" <td> 15110</td>\n",
" <td> Economic and development policy/planning</td>\n",
" <td> 15110.03</td>\n",
" <td> Institutional capacity building, Government</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 15110</td>\n",
" <td> Economic and development policy/planning</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1108619</th>\n",
" <td> 40888320</td>\n",
" <td> 2008</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Lithuania</td>\n",
" <td> LT</td>\n",
" <td> LTU</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> f</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> 15150.06</td>\n",
" <td> Elections</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1109916</th>\n",
" <td> 50064652</td>\n",
" <td> 2009</td>\n",
" <td> NaN</td>\n",
" <td> 2009-01-01 00:00:00</td>\n",
" <td> 2009-12-31 00:00:00</td>\n",
" <td> United States</td>\n",
" <td> US</td>\n",
" <td> USA</td>\n",
" <td> NaN</td>\n",
" <td> UEI64393</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 15150</td>\n",
" <td> Democratic participation and civil society</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1110468</th>\n",
" <td> 40888138</td>\n",
" <td> 2008</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Lithuania</td>\n",
" <td> LT</td>\n",
" <td> LTU</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> f</td>\n",
" <td> 11420</td>\n",
" <td> Higher education</td>\n",
" <td> 11420.01|11420.02|11420.03</td>\n",
" <td> Post-secondary education, activity unspecified...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 11420</td>\n",
" <td> Higher education</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1111321</th>\n",
" <td> 10442658</td>\n",
" <td> 1994</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> United States</td>\n",
" <td> US</td>\n",
" <td> USA</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> 15150.06|15150.05</td>\n",
" <td> Elections|Other participatory planning and dec...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1113349</th>\n",
" <td> 10446826</td>\n",
" <td> 1994</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> United States</td>\n",
" <td> US</td>\n",
" <td> USA</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> 15150.04</td>\n",
" <td> Grassroots organizations</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1113652</th>\n",
" <td> 27274483</td>\n",
" <td> 2002</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Germany</td>\n",
" <td> DE</td>\n",
" <td> DEU</td>\n",
" <td> NaN</td>\n",
" <td> 200201707</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 15130</td>\n",
" <td> Legal and judicial development</td>\n",
" <td> 15130.01</td>\n",
" <td> Legal and judicial development, activity unspe...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 15130</td>\n",
" <td> Legal and judicial development</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1113655</th>\n",
" <td> 40923396</td>\n",
" <td> 2007</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Lithuania</td>\n",
" <td> LT</td>\n",
" <td> LTU</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> f</td>\n",
" <td> 31220</td>\n",
" <td> Forestry development</td>\n",
" <td> 31210.03|31220.03</td>\n",
" <td> Institution capacity building, Forestry|Exploi...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 31220</td>\n",
" <td> Forestry development</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1115521</th>\n",
" <td> 10443512</td>\n",
" <td> 1994</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> United States</td>\n",
" <td> US</td>\n",
" <td> USA</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 41010</td>\n",
" <td> ENVIRONMENTAL POLICY AND ADMIN. MGMT</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1115577</th>\n",
" <td> 27252929</td>\n",
" <td> 2002</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Germany</td>\n",
" <td> DE</td>\n",
" <td> DEU</td>\n",
" <td> NaN</td>\n",
" <td> 200227355</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 99810</td>\n",
" <td> Sectors not specified</td>\n",
" <td> 99810.01</td>\n",
" <td> All other activities when sector is not specified</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 99810</td>\n",
" <td> Sectors not specified</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1116857</th>\n",
" <td> 3006569</td>\n",
" <td> 1998</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> World Bank - International Finance Corporation...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> WORLD BANK</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 32120</td>\n",
" <td> Industrial development</td>\n",
" <td> 32120.14|32120.03</td>\n",
" <td> Basic metal industries, ferrous|Infrastructure</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 32120</td>\n",
" <td> Industrial development</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1129481</th>\n",
" <td> 2402192</td>\n",
" <td> 2002</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> European Bank for Reconstruction &amp; Development...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> EBRD</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 33120</td>\n",
" <td> Trade facilitation</td>\n",
" <td> 24030.02|33120.01</td>\n",
" <td> All formal sector financial intermediaries|Tra...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 33120</td>\n",
" <td> Trade facilitation</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1129516</th>\n",
" <td> 93981685</td>\n",
" <td> 2010</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Slovenia</td>\n",
" <td> SI</td>\n",
" <td> SVN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> 14050</td>\n",
" <td> Waste management/disposal</td>\n",
" <td> 14050.03|14050.01</td>\n",
" <td> Collection, disposal and treatment|Waste manag...</td>\n",
" <td> f</td>\n",
" <td> f</td>\n",
" <td> 14050</td>\n",
" <td> Waste management/disposal</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1129793</th>\n",
" <td> 96548746</td>\n",
" <td> 2010</td>\n",
" <td> NaN</td>\n",
" <td> 2009-01-01 00:00:00</td>\n",
" <td> 2011-12-31 00:00:00</td>\n",
" <td> European Communities (EC)</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> SCR.DEC.020324</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 43010</td>\n",
" <td> Multisector aid</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1148432</th>\n",
" <td> 96548420</td>\n",
" <td> 2010</td>\n",
" <td> NaN</td>\n",
" <td> 2010-01-01 00:00:00</td>\n",
" <td> 2011-12-31 00:00:00</td>\n",
" <td> European Communities (EC)</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> SCR.DEC.022041</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 23010</td>\n",
" <td> Energy policy and admin. management</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1152562</th>\n",
" <td> 96548100</td>\n",
" <td> 2010</td>\n",
" <td> NaN</td>\n",
" <td> 2010-01-01 00:00:00</td>\n",
" <td> 2011-12-31 00:00:00</td>\n",
" <td> European Communities (EC)</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> SCR.DEC.022379</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 15110</td>\n",
" <td> Public sector policy and adm. management</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1158073</th>\n",
" <td> 50046484</td>\n",
" <td> 2009</td>\n",
" <td> NaN</td>\n",
" <td> 2009-01-01 00:00:00</td>\n",
" <td> NaN</td>\n",
" <td> Spain</td>\n",
" <td> ES</td>\n",
" <td> ESP</td>\n",
" <td> NaN</td>\n",
" <td> 2859</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 33110</td>\n",
" <td> Trade policy and admin. management</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1160671</th>\n",
" <td> 96850287</td>\n",
" <td> 2010</td>\n",
" <td> NaN</td>\n",
" <td> 2010-01-01 00:00:00</td>\n",
" <td> 2010-12-31 00:00:00</td>\n",
" <td> United States</td>\n",
" <td> US</td>\n",
" <td> USA</td>\n",
" <td> NaN</td>\n",
" <td> UEJ04273</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 43010</td>\n",
" <td> Multisector aid</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1161036</th>\n",
" <td> 50064676</td>\n",
" <td> 2009</td>\n",
" <td> NaN</td>\n",
" <td> 2009-01-01 00:00:00</td>\n",
" <td> 2009-12-31 00:00:00</td>\n",
" <td> United States</td>\n",
" <td> US</td>\n",
" <td> USA</td>\n",
" <td> NaN</td>\n",
" <td> UEI64639</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 15150</td>\n",
" <td> Democratic participation and civil society</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1161499</th>\n",
" <td> 2414596</td>\n",
" <td> 1993</td>\n",
" <td> 1993-12-08 00:00:00</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Kuwait</td>\n",
" <td> KW</td>\n",
" <td> KWT</td>\n",
" <td> Kuwait</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> f</td>\n",
" <td> 32120</td>\n",
" <td> Industrial development</td>\n",
" <td> 32120.07|32120.02|32120.01|32120.03</td>\n",
" <td> Forest industries|Modernization and rehabilita...</td>\n",
" <td> t</td>\n",
" <td> t</td>\n",
" <td> 32120</td>\n",
" <td> Industrial development</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1161639</th>\n",
" <td> 50143780</td>\n",
" <td> 2006</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Korea</td>\n",
" <td> KR</td>\n",
" <td> KOR</td>\n",
" <td> NaN</td>\n",
" <td> 2.00607E+12</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 15110</td>\n",
" <td> Public sector policy and adm. management</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1162337</th>\n",
" <td> 50004616</td>\n",
" <td> 2009</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Italy</td>\n",
" <td> IT</td>\n",
" <td> ITA</td>\n",
" <td> NaN</td>\n",
" <td> 39</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 12191</td>\n",
" <td> Medical services</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1162846</th>\n",
" <td> 36523876</td>\n",
" <td> 2008</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Sweden</td>\n",
" <td> SE</td>\n",
" <td> SWE</td>\n",
" <td> NaN</td>\n",
" <td> 7600406301</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 15150</td>\n",
" <td> Strengthening civil society</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1163420</th>\n",
" <td> 2427114</td>\n",
" <td> 2001</td>\n",
" <td> 2001-11-11 00:00:00</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> Kuwait</td>\n",
" <td> KW</td>\n",
" <td> KWT</td>\n",
" <td> Kuwait</td>\n",
" <td> NaN</td>\n",
" <td>...</td>\n",
" <td> f</td>\n",
" <td> 23020</td>\n",
" <td> Power generation/non-renewable sources</td>\n",
" <td> 23020.01</td>\n",
" <td> Power generation/non-renewable sources, activi...</td>\n",
" <td> t</td>\n",
" <td> t</td>\n",
" <td> 23020</td>\n",
" <td> Power generation/non-renewable sources</td>\n",
" <td> f</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1165153</th>\n",
" <td> 50045559</td>\n",
" <td> 2009</td>\n",
" <td> NaN</td>\n",
" <td> 2009-08-20 00:00:00</td>\n",
" <td> 2009-09-05 00:00:00</td>\n",
" <td> Greece</td>\n",
" <td> GR</td>\n",
" <td> GRC</td>\n",
" <td> NaN</td>\n",
" <td> Alloi-NOM-UESSAL-D-2009-1</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 16061</td>\n",
" <td> Culture and recreation</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1167151</th>\n",
" <td> 50073360</td>\n",
" <td> 2009</td>\n",
" <td> NaN</td>\n",
" <td> 2008-01-01 00:00:00</td>\n",
" <td> 2009-12-31 00:00:00</td>\n",
" <td> Portugal</td>\n",
" <td> PT</td>\n",
" <td> PRT</td>\n",
" <td> NaN</td>\n",
" <td> 008487</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 11420</td>\n",
" <td> Higher education</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1167723</th>\n",
" <td> 50064668</td>\n",
" <td> 2009</td>\n",
" <td> NaN</td>\n",
" <td> 2009-01-01 00:00:00</td>\n",
" <td> 2009-12-31 00:00:00</td>\n",
" <td> United States</td>\n",
" <td> US</td>\n",
" <td> USA</td>\n",
" <td> NaN</td>\n",
" <td> NED03493</td>\n",
" <td>...</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> NaN</td>\n",
" <td> 15153</td>\n",
" <td> Media and free flow of information</td>\n",
" <td> NaN</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1659 rows \u00d7 99 columns</p>\n",
"</div>"
],
"metadata": {},
"output_type": "pyout",
"prompt_number": 5,
"text": [
" aiddata_id year commitment_date start_date \\\n",
"333 95978951 2010 NaN 2010-01-01 00:00:00 \n",
"640 27398238 2003 NaN NaN \n",
"2164 27292579 2002 NaN NaN \n",
"3019 10461081 1995 NaN NaN \n",
"3051 40889426 2008 NaN NaN \n",
"3151 26941614 1996 NaN NaN \n",
"4035 97591452 2010 NaN NaN \n",
"5082 27465282 2004 NaN NaN \n",
"5143 40887835 2008 NaN NaN \n",
"5263 27231625 2001 NaN NaN \n",
"5476 98613055 2010 NaN 2010-10-01 00:00:00 \n",
"5879 27409403 2004 NaN NaN \n",
"5881 27284789 2002 NaN NaN \n",
"6252 27365190 2003 NaN NaN \n",
"6264 27209784 2001 NaN NaN \n",
"6485 97075657 2010 NaN 2010-01-01 00:00:00 \n",
"6881 27008498 1998 NaN NaN \n",
"7133 40889439 2008 NaN NaN \n",
"7162 41003530 2007 NaN NaN \n",
"9579 50014315 2009 NaN 2009-01-01 00:00:00 \n",
"10391 27025468 1999 NaN NaN \n",
"10941 27299036 2002 NaN NaN \n",
"11297 26977804 1998 NaN NaN \n",
"12314 50014393 2009 NaN 2009-01-01 00:00:00 \n",
"14019 27481402 2004 NaN NaN \n",
"14111 50014312 2009 NaN 2009-12-30 00:00:00 \n",
"14474 50046480 2009 NaN 2009-01-01 00:00:00 \n",
"14875 27221396 2001 NaN NaN \n",
"14950 27328686 2003 NaN NaN \n",
"15034 27418850 2004 NaN NaN \n",
"... ... ... ... ... \n",
"1095825 40888294 2008 NaN NaN \n",
"1097332 10442468 1994 NaN NaN \n",
"1098145 10449254 1994 NaN NaN \n",
"1101009 3003030 2008 NaN NaN \n",
"1108619 40888320 2008 NaN NaN \n",
"1109916 50064652 2009 NaN 2009-01-01 00:00:00 \n",
"1110468 40888138 2008 NaN NaN \n",
"1111321 10442658 1994 NaN NaN \n",
"1113349 10446826 1994 NaN NaN \n",
"1113652 27274483 2002 NaN NaN \n",
"1113655 40923396 2007 NaN NaN \n",
"1115521 10443512 1994 NaN NaN \n",
"1115577 27252929 2002 NaN NaN \n",
"1116857 3006569 1998 NaN NaN \n",
"1129481 2402192 2002 NaN NaN \n",
"1129516 93981685 2010 NaN NaN \n",
"1129793 96548746 2010 NaN 2009-01-01 00:00:00 \n",
"1148432 96548420 2010 NaN 2010-01-01 00:00:00 \n",
"1152562 96548100 2010 NaN 2010-01-01 00:00:00 \n",
"1158073 50046484 2009 NaN 2009-01-01 00:00:00 \n",
"1160671 96850287 2010 NaN 2010-01-01 00:00:00 \n",
"1161036 50064676 2009 NaN 2009-01-01 00:00:00 \n",
"1161499 2414596 1993 1993-12-08 00:00:00 NaN \n",
"1161639 50143780 2006 NaN NaN \n",
"1162337 50004616 2009 NaN NaN \n",
"1162846 36523876 2008 NaN NaN \n",
"1163420 2427114 2001 2001-11-11 00:00:00 NaN \n",
"1165153 50045559 2009 NaN 2009-08-20 00:00:00 \n",
"1167151 50073360 2009 NaN 2008-01-01 00:00:00 \n",
"1167723 50064668 2009 NaN 2009-01-01 00:00:00 \n",
"\n",
" end_date \\\n",
"333 2010-12-31 00:00:00 \n",
"640 NaN \n",
"2164 NaN \n",
"3019 NaN \n",
"3051 NaN \n",
"3151 NaN \n",
"4035 NaN \n",
"5082 NaN \n",
"5143 NaN \n",
"5263 NaN \n",
"5476 2010-11-30 00:00:00 \n",
"5879 NaN \n",
"5881 NaN \n",
"6252 NaN \n",
"6264 NaN \n",
"6485 2010-12-31 00:00:00 \n",
"6881 NaN \n",
"7133 NaN \n",
"7162 NaN \n",
"9579 2009-12-31 00:00:00 \n",
"10391 NaN \n",
"10941 NaN \n",
"11297 NaN \n",
"12314 2009-12-31 00:00:00 \n",
"14019 NaN \n",
"14111 2012-12-29 00:00:00 \n",
"14474 NaN \n",
"14875 NaN \n",
"14950 NaN \n",
"15034 NaN \n",
"... ... \n",
"1095825 NaN \n",
"1097332 NaN \n",
"1098145 NaN \n",
"1101009 NaN \n",
"1108619 NaN \n",
"1109916 2009-12-31 00:00:00 \n",
"1110468 NaN \n",
"1111321 NaN \n",
"1113349 NaN \n",
"1113652 NaN \n",
"1113655 NaN \n",
"1115521 NaN \n",
"1115577 NaN \n",
"1116857 NaN \n",
"1129481 NaN \n",
"1129516 NaN \n",
"1129793 2011-12-31 00:00:00 \n",
"1148432 2011-12-31 00:00:00 \n",
"1152562 2011-12-31 00:00:00 \n",
"1158073 NaN \n",
"1160671 2010-12-31 00:00:00 \n",
"1161036 2009-12-31 00:00:00 \n",
"1161499 NaN \n",
"1161639 NaN \n",
"1162337 NaN \n",
"1162846 NaN \n",
"1163420 NaN \n",
"1165153 2009-09-05 00:00:00 \n",
"1167151 2009-12-31 00:00:00 \n",
"1167723 2009-12-31 00:00:00 \n",
"\n",
" donor donor_iso2 \\\n",
"333 Sweden SE \n",
"640 Switzerland CH \n",
"2164 United States US \n",
"3019 European Communities (EC) NaN \n",
"3051 Lithuania LT \n",
"3151 Sweden SE \n",
"4035 Japan JP \n",
"5082 Switzerland CH \n",
"5143 Lithuania LT \n",
"5263 United States US \n",
"5476 Germany DE \n",
"5879 Switzerland CH \n",
"5881 Germany DE \n",
"6252 United States US \n",
"6264 United States US \n",
"6485 Spain ES \n",
"6881 Canada CA \n",
"7133 Lithuania LT \n",
"7162 Lithuania LT \n",
"9579 Germany DE \n",
"10391 United Nations Development Programme (UNDP) NaN \n",
"10941 Norway NO \n",
"11297 France FR \n",
"12314 Germany DE \n",
"14019 Switzerland CH \n",
"14111 Germany DE \n",
"14474 Spain ES \n",
"14875 Netherlands NL \n",
"14950 Switzerland CH \n",
"15034 Switzerland CH \n",
"... ... ... \n",
"1095825 Lithuania LT \n",
"1097332 United States US \n",
"1098145 United States US \n",
"1101009 Hungary HU \n",
"1108619 Lithuania LT \n",
"1109916 United States US \n",
"1110468 Lithuania LT \n",
"1111321 United States US \n",
"1113349 United States US \n",
"1113652 Germany DE \n",
"1113655 Lithuania LT \n",
"1115521 United States US \n",
"1115577 Germany DE \n",
"1116857 World Bank - International Finance Corporation... NaN \n",
"1129481 European Bank for Reconstruction & Development... NaN \n",
"1129516 Slovenia SI \n",
"1129793 European Communities (EC) NaN \n",
"1148432 European Communities (EC) NaN \n",
"1152562 European Communities (EC) NaN \n",
"1158073 Spain ES \n",
"1160671 United States US \n",
"1161036 United States US \n",
"1161499 Kuwait KW \n",
"1161639 Korea KR \n",
"1162337 Italy IT \n",
"1162846 Sweden SE \n",
"1163420 Kuwait KW \n",
"1165153 Greece GR \n",
"1167151 Portugal PT \n",
"1167723 United States US \n",
"\n",
" donor_iso3 umbrella donor_project_id \\\n",
"333 SWE NaN SI2010-8 \n",
"640 CHE NaN 7F-01654.02.01 \n",
"2164 USA NaN 113021-1093-H \n",
"3019 NaN NaN NaN \n",
"3051 LTU NaN NaN \n",
"3151 SWE NaN 4615530401 \n",
"4035 JPN NaN NaN \n",
"5082 CHE NaN 7F-01764.02.01 \n",
"5143 LTU NaN NaN \n",
"5263 USA NaN 113-0210-NS-EGOT \n",
"5476 DEU NaN 4 \n",
"5879 CHE NaN 7F-01655.02.01 \n",
"5881 DEU NaN 199617689 \n",
"6252 USA NaN 03DCT00031 \n",
"6264 USA NaN 113-ES-HRDF \n",
"6485 ESP NaN 2010-BIL-EELL-31490 \n",
"6881 CAN NaN NaN \n",
"7133 LTU NaN NaN \n",
"7162 LTU NaN NaN \n",
"9579 DEU NaN RUB Bochum04 \n",
"10391 NaN NaN BYE97006 \n",
"10941 NOR NaN 3020160 \n",
"11297 FRA NaN 4A4 \n",
"12314 DEU NaN 6700950 \n",
"14019 CHE NaN 7F-02955.02.01 \n",
"14111 DEU NaN 209810128 \n",
"14474 ESP NaN 5586 \n",
"14875 NLD NaN BY001901 \n",
"14950 CHE NaN 7F-02913.01.01 \n",
"15034 CHE NaN 7F-01544.04.01 \n",
"... ... ... ... \n",
"1095825 LTU NaN NaN \n",
"1097332 USA NaN NaN \n",
"1098145 USA NaN NaN \n",
"1101009 HUN NaN NaN \n",
"1108619 LTU NaN NaN \n",
"1109916 USA NaN UEI64393 \n",
"1110468 LTU NaN NaN \n",
"1111321 USA NaN NaN \n",
"1113349 USA NaN NaN \n",
"1113652 DEU NaN 200201707 \n",
"1113655 LTU NaN NaN \n",
"1115521 USA NaN NaN \n",
"1115577 DEU NaN 200227355 \n",
"1116857 NaN WORLD BANK NaN \n",
"1129481 NaN EBRD NaN \n",
"1129516 SVN NaN NaN \n",
"1129793 NaN NaN SCR.DEC.020324 \n",
"1148432 NaN NaN SCR.DEC.022041 \n",
"1152562 NaN NaN SCR.DEC.022379 \n",
"1158073 ESP NaN 2859 \n",
"1160671 USA NaN UEJ04273 \n",
"1161036 USA NaN UEI64639 \n",
"1161499 KWT Kuwait NaN \n",
"1161639 KOR NaN 2.00607E+12 \n",
"1162337 ITA NaN 39 \n",
"1162846 SWE NaN 7600406301 \n",
"1163420 KWT Kuwait NaN \n",
"1165153 GRC NaN Alloi-NOM-UESSAL-D-2009-1 \n",
"1167151 PRT NaN 008487 \n",
"1167723 USA NaN NED03493 \n",
"\n",
" ... investment_project aiddata_purpose_code \\\n",
"333 ... NaN NaN \n",
"640 ... NaN 72020 \n",
"2164 ... NaN 15150 \n",
"3019 ... NaN 72010 \n",
"3051 ... f 16010 \n",
"3151 ... NaN 15150 \n",
"4035 ... NaN NaN \n",
"5082 ... NaN 72010 \n",
"5143 ... f 15150 \n",
"5263 ... NaN 15150 \n",
"5476 ... NaN NaN \n",
"5879 ... NaN 92005 \n",
"5881 ... NaN 99810 \n",
"6252 ... NaN 15210 \n",
"6264 ... NaN 16020 \n",
"6485 ... NaN NaN \n",
"6881 ... NaN 72010 \n",
"7133 ... f 11420 \n",
"7162 ... f 22030 \n",
"9579 ... NaN NaN \n",
"10391 ... NaN 15150 \n",
"10941 ... NaN 21005 \n",
"11297 ... NaN 15130 \n",
"12314 ... NaN NaN \n",
"14019 ... NaN 12220 \n",
"14111 ... NaN NaN \n",
"14474 ... NaN 15130 \n",
"14875 ... NaN 15150 \n",
"14950 ... NaN 72010 \n",
"15034 ... NaN 72020 \n",
"... ... ... ... \n",
"1095825 ... f 15150 \n",
"1097332 ... NaN NaN \n",
"1098145 ... NaN NaN \n",
"1101009 ... f 15110 \n",
"1108619 ... f 15150 \n",
"1109916 ... NaN NaN \n",
"1110468 ... f 11420 \n",
"1111321 ... NaN 15150 \n",
"1113349 ... NaN 15150 \n",
"1113652 ... NaN 15130 \n",
"1113655 ... f 31220 \n",
"1115521 ... NaN NaN \n",
"1115577 ... NaN 99810 \n",
"1116857 ... NaN 32120 \n",
"1129481 ... NaN 33120 \n",
"1129516 ... NaN 14050 \n",
"1129793 ... NaN NaN \n",
"1148432 ... NaN NaN \n",
"1152562 ... NaN NaN \n",
"1158073 ... NaN NaN \n",
"1160671 ... NaN NaN \n",
"1161036 ... NaN NaN \n",
"1161499 ... f 32120 \n",
"1161639 ... NaN NaN \n",
"1162337 ... NaN NaN \n",
"1162846 ... NaN NaN \n",
"1163420 ... f 23020 \n",
"1165153 ... NaN NaN \n",
"1167151 ... NaN NaN \n",
"1167723 ... NaN NaN \n",
"\n",
" aiddata_purpose_name \\\n",
"333 NaN \n",
"640 Emergency health services/support \n",
"2164 Strengthening civil society \n",
"3019 Material relief assistance and services \n",
"3051 Social/ welfare services \n",
"3151 Strengthening civil society \n",
"4035 NaN \n",
"5082 Material relief assistance and services \n",
"5143 Strengthening civil society \n",
"5263 Strengthening civil society \n",
"5476 NaN \n",
"5879 Support to non-governmental organizations and ... \n",
"5881 Sectors not specified \n",
"6252 Security system management and reform \n",
"6264 Employment policy and administrative management \n",
"6485 NaN \n",
"6881 Material relief assistance and services \n",
"7133 Higher education \n",
"7162 Radio/television/print media \n",
"9579 NaN \n",
"10391 Strengthening civil society \n",
"10941 Transport and Storage, purpose unspecified or ... \n",
"11297 Legal and judicial development \n",
"12314 NaN \n",
"14019 Basic health care \n",
"14111 NaN \n",
"14474 Legal and judicial development \n",
"14875 Strengthening civil society \n",
"14950 Material relief assistance and services \n",
"15034 Emergency health services/support \n",
"... ... \n",
"1095825 Strengthening civil society \n",
"1097332 NaN \n",
"1098145 NaN \n",
"1101009 Economic and development policy/planning \n",
"1108619 Strengthening civil society \n",
"1109916 NaN \n",
"1110468 Higher education \n",
"1111321 Strengthening civil society \n",
"1113349 Strengthening civil society \n",
"1113652 Legal and judicial development \n",
"1113655 Forestry development \n",
"1115521 NaN \n",
"1115577 Sectors not specified \n",
"1116857 Industrial development \n",
"1129481 Trade facilitation \n",
"1129516 Waste management/disposal \n",
"1129793 NaN \n",
"1148432 NaN \n",
"1152562 NaN \n",
"1158073 NaN \n",
"1160671 NaN \n",
"1161036 NaN \n",
"1161499 Industrial development \n",
"1161639 NaN \n",
"1162337 NaN \n",
"1162846 NaN \n",
"1163420 Power generation/non-renewable sources \n",
"1165153 NaN \n",
"1167151 NaN \n",
"1167723 NaN \n",
"\n",
" aiddata_activity_code \\\n",
"333 NaN \n",
"640 72020.01|72050.01 \n",
"2164 15150.02|15150.01 \n",
"3019 72010.01 \n",
"3051 11120.06|16010.07|16010.02 \n",
"3151 15150.08 \n",
"4035 NaN \n",
"5082 72010.01 \n",
"5143 15150.01|15150.08|15110.03 \n",
"5263 15110.01|15150.02|15150.05|31120.01|15140.04|2... \n",
"5476 NaN \n",
"5879 92005.01 \n",
"5881 99810.01 \n",
"6252 15210.01 \n",
"6264 16020.03|15150.07 \n",
"6485 NaN \n",
"6881 72010.01 \n",
"7133 11420.01|15150.01|11120.06|22040.03|16020.03 \n",
"7162 22030.03|16010.05|16010.07 \n",
"9579 NaN \n",
"10391 15150.08 \n",
"10941 21005.01 \n",
"11297 11420.04|15130.04|15130.03 \n",
"12314 NaN \n",
"14019 13020.03|12220.05 \n",
"14111 NaN \n",
"14474 15130.06 \n",
"14875 15150.08|15150.03|92005.01 \n",
"14950 72010.01 \n",
"15034 72020.01|72030.01 \n",
"... ... \n",
"1095825 22030.03|15150.08 \n",
"1097332 NaN \n",
"1098145 NaN \n",
"1101009 15110.03 \n",
"1108619 15150.06 \n",
"1109916 NaN \n",
"1110468 11420.01|11420.02|11420.03 \n",
"1111321 15150.06|15150.05 \n",
"1113349 15150.04 \n",
"1113652 15130.01 \n",
"1113655 31210.03|31220.03 \n",
"1115521 NaN \n",
"1115577 99810.01 \n",
"1116857 32120.14|32120.03 \n",
"1129481 24030.02|33120.01 \n",
"1129516 14050.03|14050.01 \n",
"1129793 NaN \n",
"1148432 NaN \n",
"1152562 NaN \n",
"1158073 NaN \n",
"1160671 NaN \n",
"1161036 NaN \n",
"1161499 32120.07|32120.02|32120.01|32120.03 \n",
"1161639 NaN \n",
"1162337 NaN \n",
"1162846 NaN \n",
"1163420 23020.01 \n",
"1165153 NaN \n",
"1167151 NaN \n",
"1167723 NaN \n",
"\n",
" aiddata_activity_name \\\n",
"333 NaN \n",
"640 All emergency health services/support activiti... \n",
"2164 Community participation and development|Streng... \n",
"3019 All non-food relief items and assistance \n",
"3051 Colloquia, seminars, lectures, etc.|Culture an... \n",
"3151 Free flow of information \n",
"4035 NaN \n",
"5082 All non-food relief items and assistance \n",
"5143 Strengthening civil society, activity unspecif... \n",
"5263 Economic and development policy/planning, acti... \n",
"5476 NaN \n",
"5879 Support to non-governmental organizations and ... \n",
"5881 All other activities when sector is not specified \n",
"6252 Security system management and reform, activit... \n",
"6264 Labor law and labor unions|Human rights \n",
"6485 NaN \n",
"6881 All non-food relief items and assistance \n",
"7133 Post-secondary education, activity unspecified... \n",
"7162 Print media activities|Support for vulnerable ... \n",
"9579 NaN \n",
"10391 Free flow of information \n",
"10941 Transport and Storage, activity unspecified or... \n",
"11297 Formal and non-formal post-secondary education... \n",
"12314 NaN \n",
"14019 Prenatal and postnatal care including delivery... \n",
"14111 NaN \n",
"14474 Law enforcement and crime prevention \n",
"14875 Free flow of information|Cooperatives|Support ... \n",
"14950 All non-food relief items and assistance \n",
"15034 All emergency health services/support activiti... \n",
"... ... \n",
"1095825 Print media activities|Free flow of information \n",
"1097332 NaN \n",
"1098145 NaN \n",
"1101009 Institutional capacity building, Government \n",
"1108619 Elections \n",
"1109916 NaN \n",
"1110468 Post-secondary education, activity unspecified... \n",
"1111321 Elections|Other participatory planning and dec... \n",
"1113349 Grassroots organizations \n",
"1113652 Legal and judicial development, activity unspe... \n",
"1113655 Institution capacity building, Forestry|Exploi... \n",
"1115521 NaN \n",
"1115577 All other activities when sector is not specified \n",
"1116857 Basic metal industries, ferrous|Infrastructure \n",
"1129481 All formal sector financial intermediaries|Tra... \n",
"1129516 Collection, disposal and treatment|Waste manag... \n",
"1129793 NaN \n",
"1148432 NaN \n",
"1152562 NaN \n",
"1158073 NaN \n",
"1160671 NaN \n",
"1161036 NaN \n",
"1161499 Forest industries|Modernization and rehabilita... \n",
"1161639 NaN \n",
"1162337 NaN \n",
"1162846 NaN \n",
"1163420 Power generation/non-renewable sources, activi... \n",
"1165153 NaN \n",
"1167151 NaN \n",
"1167723 NaN \n",
"\n",
" aiddata_feasibility_study aiddata_technical_assistance \\\n",
"333 NaN NaN \n",
"640 f f \n",
"2164 f f \n",
"3019 f f \n",
"3051 f f \n",
"3151 f f \n",
"4035 NaN NaN \n",
"5082 f f \n",
"5143 f f \n",
"5263 f f \n",
"5476 NaN NaN \n",
"5879 f f \n",
"5881 f f \n",
"6252 f f \n",
"6264 f f \n",
"6485 NaN NaN \n",
"6881 f f \n",
"7133 f f \n",
"7162 f f \n",
"9579 NaN NaN \n",
"10391 f f \n",
"10941 f f \n",
"11297 f f \n",
"12314 NaN NaN \n",
"14019 f f \n",
"14111 NaN NaN \n",
"14474 f f \n",
"14875 f f \n",
"14950 f f \n",
"15034 f f \n",
"... ... ... \n",
"1095825 f f \n",
"1097332 NaN NaN \n",
"1098145 NaN NaN \n",
"1101009 f f \n",
"1108619 f f \n",
"1109916 NaN NaN \n",
"1110468 f f \n",
"1111321 f f \n",
"1113349 f f \n",
"1113652 f f \n",
"1113655 f f \n",
"1115521 NaN NaN \n",
"1115577 f f \n",
"1116857 f f \n",
"1129481 f f \n",
"1129516 f f \n",
"1129793 NaN NaN \n",
"1148432 NaN NaN \n",
"1152562 NaN NaN \n",
"1158073 NaN NaN \n",
"1160671 NaN NaN \n",
"1161036 NaN NaN \n",
"1161499 t t \n",
"1161639 NaN NaN \n",
"1162337 NaN NaN \n",
"1162846 NaN NaN \n",
"1163420 t t \n",
"1165153 NaN NaN \n",
"1167151 NaN NaN \n",
"1167723 NaN NaN \n",
"\n",
" coalesced_purpose_code \\\n",
"333 16061 \n",
"640 72020 \n",
"2164 15150 \n",
"3019 72010 \n",
"3051 16010 \n",
"3151 15150 \n",
"4035 32171 \n",
"5082 72010 \n",
"5143 15150 \n",
"5263 15150 \n",
"5476 11430 \n",
"5879 92005 \n",
"5881 99810 \n",
"6252 15210 \n",
"6264 16020 \n",
"6485 93010 \n",
"6881 72010 \n",
"7133 11420 \n",
"7162 22030 \n",
"9579 11430 \n",
"10391 15150 \n",
"10941 21005 \n",
"11297 15130 \n",
"12314 11120 \n",
"14019 12220 \n",
"14111 31130 \n",
"14474 15130 \n",
"14875 15150 \n",
"14950 72010 \n",
"15034 72020 \n",
"... ... \n",
"1095825 15150 \n",
"1097332 11110 \n",
"1098145 12250 \n",
"1101009 15110 \n",
"1108619 15150 \n",
"1109916 15150 \n",
"1110468 11420 \n",
"1111321 15150 \n",
"1113349 15150 \n",
"1113652 15130 \n",
"1113655 31220 \n",
"1115521 41010 \n",
"1115577 99810 \n",
"1116857 32120 \n",
"1129481 33120 \n",
"1129516 14050 \n",
"1129793 43010 \n",
"1148432 23010 \n",
"1152562 15110 \n",
"1158073 33110 \n",
"1160671 43010 \n",
"1161036 15150 \n",
"1161499 32120 \n",
"1161639 15110 \n",
"1162337 12191 \n",
"1162846 15150 \n",
"1163420 23020 \n",
"1165153 16061 \n",
"1167151 11420 \n",
"1167723 15153 \n",
"\n",
" coalesced_purpose_name \\\n",
"333 Culture and recreation \n",
"640 Emergency health services/support \n",
"2164 Strengthening civil society \n",
"3019 Material relief assistance and services \n",
"3051 Social/ welfare services \n",
"3151 Strengthening civil society \n",
"4035 Engineering \n",
"5082 Material relief assistance and services \n",
"5143 Strengthening civil society \n",
"5263 Strengthening civil society \n",
"5476 Advanced tech. & managerial training \n",
"5879 Support to non-governmental organizations and ... \n",
"5881 Sectors not specified \n",
"6252 Security system management and reform \n",
"6264 Employment policy and administrative management \n",
"6485 Refugees in donor countries \n",
"6881 Material relief assistance and services \n",
"7133 Higher education \n",
"7162 Radio/television/print media \n",
"9579 Advanced tech. & managerial training \n",
"10391 Strengthening civil society \n",
"10941 Transport and Storage, purpose unspecified or ... \n",
"11297 Legal and judicial development \n",
"12314 Education facilities and training \n",
"14019 Basic health care \n",
"14111 Agricultural land resources \n",
"14474 Legal and judicial development \n",
"14875 Strengthening civil society \n",
"14950 Material relief assistance and services \n",
"15034 Emergency health services/support \n",
"... ... \n",
"1095825 Strengthening civil society \n",
"1097332 EDUCATION POLICY & ADMIN. MANAGEMENT \n",
"1098145 INFECTIOUS DISEASE CONTROL \n",
"1101009 Economic and development policy/planning \n",
"1108619 Strengthening civil society \n",
"1109916 Democratic participation and civil society \n",
"1110468 Higher education \n",
"1111321 Strengthening civil society \n",
"1113349 Strengthening civil society \n",
"1113652 Legal and judicial development \n",
"1113655 Forestry development \n",
"1115521 ENVIRONMENTAL POLICY AND ADMIN. MGMT \n",
"1115577 Sectors not specified \n",
"1116857 Industrial development \n",
"1129481 Trade facilitation \n",
"1129516 Waste management/disposal \n",
"1129793 Multisector aid \n",
"1148432 Energy policy and admin. management \n",
"1152562 Public sector policy and adm. management \n",
"1158073 Trade policy and admin. management \n",
"1160671 Multisector aid \n",
"1161036 Democratic participation and civil society \n",
"1161499 Industrial development \n",
"1161639 Public sector policy and adm. management \n",
"1162337 Medical services \n",
"1162846 Strengthening civil society \n",
"1163420 Power generation/non-renewable sources \n",
"1165153 Culture and recreation \n",
"1167151 Higher education \n",
"1167723 Media and free flow of information \n",
"\n",
" aiddata_is_conflict \n",
"333 NaN \n",
"640 f \n",
"2164 f \n",
"3019 f \n",
"3051 f \n",
"3151 f \n",
"4035 NaN \n",
"5082 f \n",
"5143 f \n",
"5263 f \n",
"5476 NaN \n",
"5879 f \n",
"5881 f \n",
"6252 f \n",
"6264 f \n",
"6485 NaN \n",
"6881 f \n",
"7133 f \n",
"7162 f \n",
"9579 NaN \n",
"10391 f \n",
"10941 f \n",
"11297 f \n",
"12314 NaN \n",
"14019 f \n",
"14111 NaN \n",
"14474 f \n",
"14875 f \n",
"14950 f \n",
"15034 f \n",
"... ... \n",
"1095825 f \n",
"1097332 NaN \n",
"1098145 NaN \n",
"1101009 f \n",
"1108619 f \n",
"1109916 NaN \n",
"1110468 f \n",
"1111321 f \n",
"1113349 f \n",
"1113652 f \n",
"1113655 f \n",
"1115521 NaN \n",
"1115577 f \n",
"1116857 f \n",
"1129481 f \n",
"1129516 f \n",
"1129793 NaN \n",
"1148432 NaN \n",
"1152562 NaN \n",
"1158073 NaN \n",
"1160671 NaN \n",
"1161036 NaN \n",
"1161499 f \n",
"1161639 NaN \n",
"1162337 NaN \n",
"1162846 NaN \n",
"1163420 f \n",
"1165153 NaN \n",
"1167151 NaN \n",
"1167723 NaN \n",
"\n",
"[1659 rows x 99 columns]"
]
}
],
"prompt_number": 5
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"upload Belarus recipients to file"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"df[df.recipient_iso2 == 'BY'].to_csv(OUTPUT_DATA_FILE)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 6
},
{
"cell_type": "code",
"collapsed": false,
"input": [],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 6
}
],
"metadata": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment