Skip to content

Instantly share code, notes, and snippets.

@catherinedevlin

catherinedevlin/count_negative_values.ipynb

Created March 31, 2017 19:19
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save catherinedevlin/b4e179b7526c8ce51abea0d739eeac21 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save catherinedevlin/b4e179b7526c8ce51abea0d739eeac21 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
count_negative_values.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 81,
"metadata": {
"collapsed": false,
"deletable": true,
"editable": true,
"slideshow": "slide"
},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": 82,
"metadata": {
"collapsed": false,
"deletable": true,
"editable": true,
"slideshow": "slide"
},
"outputs": [],
"source": [
"tbl_name = 'appropriation_account_balances'\n",
"tbl = pd.read_sql(tbl_name, 'postgresql:///api_datastore')\n",
"float64 = tbl.budget_authority_unobligated_balance_brought_forward_fyb.dtype"
]
},
{
"cell_type": "code",
"execution_count": 87,
"metadata": {
"collapsed": false,
"deletable": true,
"editable": true
},
"outputs": [],
"source": [
"def report_table(tbl_name):\n",
" tbl = pd.read_sql(tbl_name, 'postgresql:///api_datastore')\n",
" result = {'positive': [], 'zero': [], 'negative': []}\n",
" idx = []\n",
" for col_name in sorted(tbl.columns):\n",
" col = tbl[col_name]\n",
" if col.dtype == float64:\n",
" idx.append(col_name)\n",
" result['positive'].append(col[col > 0].count())\n",
" result['zero'].append(col[col < 0].count())\n",
" result['negative'].append(col[col == 0].count())\n",
" return pd.DataFrame(result, index=idx)\n",
"\n"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# File A"
]
},
{
"cell_type": "code",
"execution_count": 88,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>negative</th>\n",
" <th>positive</th>\n",
" <th>zero</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>adjustments_to_unobligated_balance_brought_forward_cpe</th>\n",
" <td>55</td>\n",
" <td>39</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>borrowing_authority_amount_total_cpe</th>\n",
" <td>51</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>budget_authority_appropriated_amount_cpe</th>\n",
" <td>66</td>\n",
" <td>25</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>budget_authority_available_amount_total_cpe</th>\n",
" <td>6</td>\n",
" <td>88</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>budget_authority_unobligated_balance_brought_forward_fyb</th>\n",
" <td>29</td>\n",
" <td>65</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>contract_authority_amount_total_cpe</th>\n",
" <td>53</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>deobligations_recoveries_refunds_by_tas_cpe</th>\n",
" <td>50</td>\n",
" <td>44</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>gross_outlay_amount_by_tas_cpe</th>\n",
" <td>29</td>\n",
" <td>1</td>\n",
" <td>64</td>\n",
" </tr>\n",
" <tr>\n",
" <th>obligations_incurred_total_by_tas_cpe</th>\n",
" <td>44</td>\n",
" <td>50</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>other_budgetary_resources_amount_cpe</th>\n",
" <td>71</td>\n",
" <td>22</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>spending_authority_from_offsetting_collections_amount_cpe</th>\n",
" <td>71</td>\n",
" <td>20</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>status_of_budgetary_resources_total_cpe</th>\n",
" <td>6</td>\n",
" <td>88</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>unobligated_balance_cpe</th>\n",
" <td>9</td>\n",
" <td>85</td>\n",
" <td>0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" negative positive zero\n",
"adjustments_to_unobligated_balance_brought_forw... 55 39 0\n",
"borrowing_authority_amount_total_cpe 51 2 0\n",
"budget_authority_appropriated_amount_cpe 66 25 3\n",
"budget_authority_available_amount_total_cpe 6 88 0\n",
"budget_authority_unobligated_balance_brought_fo... 29 65 0\n",
"contract_authority_amount_total_cpe 53 0 0\n",
"deobligations_recoveries_refunds_by_tas_cpe 50 44 0\n",
"gross_outlay_amount_by_tas_cpe 29 1 64\n",
"obligations_incurred_total_by_tas_cpe 44 50 0\n",
"other_budgetary_resources_amount_cpe 71 22 1\n",
"spending_authority_from_offsetting_collections_... 71 20 3\n",
"status_of_budgetary_resources_total_cpe 6 88 0\n",
"unobligated_balance_cpe 9 85 0"
]
},
"execution_count": 88,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"report_table('appropriation_account_balances')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# File B"
]
},
{
"cell_type": "code",
"execution_count": 89,
"metadata": {
"collapsed": false,
"deletable": true,
"editable": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>negative</th>\n",
" <th>positive</th>\n",
" <th>zero</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>deobligations_recoveries_refund_pri_program_object_class_cpe</th>\n",
" <td>64</td>\n",
" <td>6</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>gross_outlay_amount_by_program_object_class_cpe</th>\n",
" <td>48</td>\n",
" <td>0</td>\n",
" <td>22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>gross_outlay_amount_by_program_object_class_fyb</th>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>gross_outlays_delivered_orders_paid_total_cpe</th>\n",
" <td>48</td>\n",
" <td>0</td>\n",
" <td>22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>gross_outlays_delivered_orders_paid_total_fyb</th>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>gross_outlays_undelivered_orders_prepaid_total_cpe</th>\n",
" <td>69</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>gross_outlays_undelivered_orders_prepaid_total_fyb</th>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>obligations_delivered_orders_unpaid_total_cpe</th>\n",
" <td>52</td>\n",
" <td>1</td>\n",
" <td>17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>obligations_delivered_orders_unpaid_total_fyb</th>\n",
" <td>52</td>\n",
" <td>2</td>\n",
" <td>16</td>\n",
" </tr>\n",
" <tr>\n",
" <th>obligations_incurred_by_program_object_class_cpe</th>\n",
" <td>49</td>\n",
" <td>3</td>\n",
" <td>18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>obligations_undelivered_orders_unpaid_total_cpe</th>\n",
" <td>57</td>\n",
" <td>0</td>\n",
" <td>13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>obligations_undelivered_orders_unpaid_total_fyb</th>\n",
" <td>57</td>\n",
" <td>0</td>\n",
" <td>13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl480100_undelivered_orders_obligations_unpaid_cpe</th>\n",
" <td>57</td>\n",
" <td>1</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl480100_undelivered_orders_obligations_unpaid_fyb</th>\n",
" <td>57</td>\n",
" <td>1</td>\n",
" <td>12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl480200_undelivered_orders_oblig_prepaid_advanced_cpe</th>\n",
" <td>69</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl480200_undelivered_orders_oblig_prepaid_advanced_fyb</th>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl483100_undelivered_orders_oblig_transferred_unpaid_cpe</th>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl483200_undeliv_orders_oblig_transferred_prepaid_adv_cpe</th>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl487100_down_adj_pri_unpaid_undel_orders_oblig_recov_cpe</th>\n",
" <td>64</td>\n",
" <td>6</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl487200_down_adj_pri_ppaid_undel_orders_oblig_refund_cpe</th>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl488100_upward_adjust_pri_undeliv_order_oblig_unpaid_cpe</th>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl488200_up_adjust_pri_undeliv_order_oblig_ppaid_adv_cpe</th>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl490100_delivered_orders_obligations_unpaid_cpe</th>\n",
" <td>52</td>\n",
" <td>1</td>\n",
" <td>17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl490100_delivered_orders_obligations_unpaid_fyb</th>\n",
" <td>52</td>\n",
" <td>2</td>\n",
" <td>16</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl490200_delivered_orders_obligations_paid_cpe</th>\n",
" <td>48</td>\n",
" <td>0</td>\n",
" <td>22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl490800_authority_outlayed_not_yet_disbursed_cpe</th>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl490800_authority_outlayed_not_yet_disbursed_fyb</th>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl493100_delivered_orders_oblig_transferred_unpaid_cpe</th>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl497100_down_adj_pri_unpaid_deliv_orders_oblig_recov_cpe</th>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl497200_down_adj_pri_paid_deliv_orders_oblig_refund_cpe</th>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl498100_upward_adjust_pri_deliv_orders_oblig_unpaid_cpe</th>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl498200_upward_adjust_pri_deliv_orders_oblig_paid_cpe</th>\n",
" <td>70</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" negative positive zero\n",
"deobligations_recoveries_refund_pri_program_obj... 64 6 0\n",
"gross_outlay_amount_by_program_object_class_cpe 48 0 22\n",
"gross_outlay_amount_by_program_object_class_fyb 70 0 0\n",
"gross_outlays_delivered_orders_paid_total_cpe 48 0 22\n",
"gross_outlays_delivered_orders_paid_total_fyb 70 0 0\n",
"gross_outlays_undelivered_orders_prepaid_total_cpe 69 0 1\n",
"gross_outlays_undelivered_orders_prepaid_total_fyb 70 0 0\n",
"obligations_delivered_orders_unpaid_total_cpe 52 1 17\n",
"obligations_delivered_orders_unpaid_total_fyb 52 2 16\n",
"obligations_incurred_by_program_object_class_cpe 49 3 18\n",
"obligations_undelivered_orders_unpaid_total_cpe 57 0 13\n",
"obligations_undelivered_orders_unpaid_total_fyb 57 0 13\n",
"ussgl480100_undelivered_orders_obligations_unpa... 57 1 12\n",
"ussgl480100_undelivered_orders_obligations_unpa... 57 1 12\n",
"ussgl480200_undelivered_orders_oblig_prepaid_ad... 69 0 1\n",
"ussgl480200_undelivered_orders_oblig_prepaid_ad... 70 0 0\n",
"ussgl483100_undelivered_orders_oblig_transferre... 70 0 0\n",
"ussgl483200_undeliv_orders_oblig_transferred_pr... 70 0 0\n",
"ussgl487100_down_adj_pri_unpaid_undel_orders_ob... 64 6 0\n",
"ussgl487200_down_adj_pri_ppaid_undel_orders_obl... 70 0 0\n",
"ussgl488100_upward_adjust_pri_undeliv_order_obl... 70 0 0\n",
"ussgl488200_up_adjust_pri_undeliv_order_oblig_p... 70 0 0\n",
"ussgl490100_delivered_orders_obligations_unpaid... 52 1 17\n",
"ussgl490100_delivered_orders_obligations_unpaid... 52 2 16\n",
"ussgl490200_delivered_orders_obligations_paid_cpe 48 0 22\n",
"ussgl490800_authority_outlayed_not_yet_disburse... 70 0 0\n",
"ussgl490800_authority_outlayed_not_yet_disburse... 70 0 0\n",
"ussgl493100_delivered_orders_oblig_transferred_... 70 0 0\n",
"ussgl497100_down_adj_pri_unpaid_deliv_orders_ob... 70 0 0\n",
"ussgl497200_down_adj_pri_paid_deliv_orders_obli... 70 0 0\n",
"ussgl498100_upward_adjust_pri_deliv_orders_obli... 70 0 0\n",
"ussgl498200_upward_adjust_pri_deliv_orders_obli... 70 0 0"
]
},
"execution_count": 89,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"report_table('financial_accounts_by_program_activity_object_class')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# File C"
]
},
{
"cell_type": "code",
"execution_count": 90,
"metadata": {
"collapsed": false,
"deletable": true,
"editable": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>negative</th>\n",
" <th>positive</th>\n",
" <th>zero</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>awarding_agency_id</th>\n",
" <td>0</td>\n",
" <td>6707</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>funding_agency_id</th>\n",
" <td>0</td>\n",
" <td>6678</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>latest_submission_id</th>\n",
" <td>0</td>\n",
" <td>7404</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>latest_transaction_id</th>\n",
" <td>0</td>\n",
" <td>6707</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>parent_award_id</th>\n",
" <td>0</td>\n",
" <td>3302</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>place_of_performance_id</th>\n",
" <td>0</td>\n",
" <td>6707</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>potential_total_value_of_award</th>\n",
" <td>1616</td>\n",
" <td>4025</td>\n",
" <td>1029</td>\n",
" </tr>\n",
" <tr>\n",
" <th>recipient_id</th>\n",
" <td>0</td>\n",
" <td>6707</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>total_obligation</th>\n",
" <td>1168</td>\n",
" <td>4625</td>\n",
" <td>914</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" negative positive zero\n",
"awarding_agency_id 0 6707 0\n",
"funding_agency_id 0 6678 0\n",
"latest_submission_id 0 7404 0\n",
"latest_transaction_id 0 6707 0\n",
"parent_award_id 0 3302 0\n",
"place_of_performance_id 0 6707 0\n",
"potential_total_value_of_award 1616 4025 1029\n",
"recipient_id 0 6707 0\n",
"total_obligation 1168 4625 914"
]
},
"execution_count": 90,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"report_table('awards')"
]
},
{
"cell_type": "code",
"execution_count": 91,
"metadata": {
"collapsed": false,
"deletable": true,
"editable": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>negative</th>\n",
" <th>positive</th>\n",
" <th>zero</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>deobligations_recoveries_refunds_of_prior_year_by_award_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>gross_outlay_amount_by_award_cpe</th>\n",
" <td>558</td>\n",
" <td>0</td>\n",
" <td>28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>gross_outlay_amount_by_award_fyb</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>gross_outlays_delivered_orders_paid_total_cpe</th>\n",
" <td>558</td>\n",
" <td>0</td>\n",
" <td>28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>gross_outlays_delivered_orders_paid_total_fyb</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>gross_outlays_undelivered_orders_prepaid_total_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>gross_outlays_undelivered_orders_prepaid_total_fyb</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>obligations_delivered_orders_unpaid_total_cpe</th>\n",
" <td>558</td>\n",
" <td>28</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>obligations_delivered_orders_unpaid_total_fyb</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>obligations_incurred_total_by_award_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>obligations_undelivered_orders_unpaid_total_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>obligations_undelivered_orders_unpaid_total_fyb</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>transaction_obligated_amount</th>\n",
" <td>28</td>\n",
" <td>176</td>\n",
" <td>559</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl480100_undelivered_orders_obligations_unpaid_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl480100_undelivered_orders_obligations_unpaid_fyb</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl480200_undelivered_orders_oblig_prepaid_advanced_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl480200_undelivered_orders_oblig_prepaid_advanced_fyb</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl483100_undelivered_orders_oblig_transferred_unpaid_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl483200_undeliv_orders_oblig_transferred_prepaid_adv_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl487100_down_adj_pri_unpaid_undel_orders_oblig_recov_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl487200_down_adj_pri_ppaid_undel_orders_oblig_refund_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl488100_upward_adjust_pri_undeliv_order_oblig_unpaid_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl488200_up_adjust_pri_undeliv_order_oblig_ppaid_adv_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl490100_delivered_orders_obligations_unpaid_cpe</th>\n",
" <td>558</td>\n",
" <td>28</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl490100_delivered_orders_obligations_unpaid_fyb</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl490200_delivered_orders_obligations_paid_cpe</th>\n",
" <td>558</td>\n",
" <td>0</td>\n",
" <td>28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl490800_authority_outlayed_not_yet_disbursed_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl490800_authority_outlayed_not_yet_disbursed_fyb</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl493100_delivered_orders_oblig_transferred_unpaid_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl497100_down_adj_pri_unpaid_deliv_orders_oblig_recov_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl497200_down_adj_pri_paid_deliv_orders_oblig_refund_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl498100_upward_adjust_pri_deliv_orders_oblig_unpaid_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>ussgl498200_upward_adjust_pri_deliv_orders_oblig_paid_cpe</th>\n",
" <td>586</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" negative positive zero\n",
"deobligations_recoveries_refunds_of_prior_year_... 586 0 0\n",
"gross_outlay_amount_by_award_cpe 558 0 28\n",
"gross_outlay_amount_by_award_fyb 586 0 0\n",
"gross_outlays_delivered_orders_paid_total_cpe 558 0 28\n",
"gross_outlays_delivered_orders_paid_total_fyb 586 0 0\n",
"gross_outlays_undelivered_orders_prepaid_total_cpe 586 0 0\n",
"gross_outlays_undelivered_orders_prepaid_total_fyb 586 0 0\n",
"obligations_delivered_orders_unpaid_total_cpe 558 28 0\n",
"obligations_delivered_orders_unpaid_total_fyb 586 0 0\n",
"obligations_incurred_total_by_award_cpe 586 0 0\n",
"obligations_undelivered_orders_unpaid_total_cpe 586 0 0\n",
"obligations_undelivered_orders_unpaid_total_fyb 586 0 0\n",
"transaction_obligated_amount 28 176 559\n",
"ussgl480100_undelivered_orders_obligations_unpa... 586 0 0\n",
"ussgl480100_undelivered_orders_obligations_unpa... 586 0 0\n",
"ussgl480200_undelivered_orders_oblig_prepaid_ad... 586 0 0\n",
"ussgl480200_undelivered_orders_oblig_prepaid_ad... 586 0 0\n",
"ussgl483100_undelivered_orders_oblig_transferre... 586 0 0\n",
"ussgl483200_undeliv_orders_oblig_transferred_pr... 586 0 0\n",
"ussgl487100_down_adj_pri_unpaid_undel_orders_ob... 586 0 0\n",
"ussgl487200_down_adj_pri_ppaid_undel_orders_obl... 586 0 0\n",
"ussgl488100_upward_adjust_pri_undeliv_order_obl... 586 0 0\n",
"ussgl488200_up_adjust_pri_undeliv_order_oblig_p... 586 0 0\n",
"ussgl490100_delivered_orders_obligations_unpaid... 558 28 0\n",
"ussgl490100_delivered_orders_obligations_unpaid... 586 0 0\n",
"ussgl490200_delivered_orders_obligations_paid_cpe 558 0 28\n",
"ussgl490800_authority_outlayed_not_yet_disburse... 586 0 0\n",
"ussgl490800_authority_outlayed_not_yet_disburse... 586 0 0\n",
"ussgl493100_delivered_orders_oblig_transferred_... 586 0 0\n",
"ussgl497100_down_adj_pri_unpaid_deliv_orders_ob... 586 0 0\n",
"ussgl497200_down_adj_pri_paid_deliv_orders_obli... 586 0 0\n",
"ussgl498100_upward_adjust_pri_deliv_orders_obli... 586 0 0\n",
"ussgl498200_upward_adjust_pri_deliv_orders_obli... 586 0 0"
]
},
"execution_count": 91,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"report_table('financial_accounts_by_awards')"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true,
"deletable": true,
"editable": true
},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.5.1"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment