{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "# !pip install git+https://github.com/compute-tooling/compute-studio-kit.git@filespec\n", "!conda install taxcalc -c pslmodels -y" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "import json\n", "\n", "import fsspec\n", "\n", "from cs_kit.filespec import CSFileSystem" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "{'II_rt1': [{'year': 2019, 'value': 0.25}],\n", " 'II_rt2': [{'year': 2019, 'value': 0.25}],\n", " 'II_rt3': [{'year': 2019, 'value': 0.25}],\n", " 'II_rt4': [{'year': 2019, 'value': 0.25}],\n", " 'II_rt5': [{'year': 2019, 'value': 0.25}],\n", " 'II_rt6': [{'year': 2019, 'value': 0.25}],\n", " 'II_rt7': [{'year': 2019, 'value': 0.7}],\n", " 'II_brk6': [{'MARS': 'widow', 'year': 2019, 'value': 2000000},\n", " {'MARS': 'headhh', 'year': 2019, 'value': 2000000},\n", " {'MARS': 'mseparate', 'year': 2019, 'value': 2000000},\n", " {'MARS': 'mjoint', 'year': 2019, 'value': 2000000},\n", " {'MARS': 'single', 'year': 2019, 'value': 2000000}]}" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "with fsspec.open(\"cs://PSLmodels:Tax-Brain@47410/inputs/adjustment/policy/\", \"r\") as f:\n", " data = json.loads(f.read())\n", "data" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "OrderedDict([('II_rt1', [{'year': 2019, 'value': 0.25}]),\n", " ('II_rt2', [{'year': 2019, 'value': 0.25}]),\n", " ('II_rt3', [{'year': 2019, 'value': 0.25}]),\n", " ('II_rt4', [{'year': 2019, 'value': 0.25}]),\n", " ('II_rt5', [{'year': 2019, 'value': 0.25}]),\n", " ('II_rt6', [{'year': 2019, 'value': 0.25}]),\n", " ('II_brk6',\n", " [{'year': 2019, 'value': 2000000.0, 'MARS': 'widow'},\n", " {'year': 2019, 'value': 2000000.0, 'MARS': 'headhh'},\n", " {'year': 2019, 'value': 2000000.0, 'MARS': 'mseparate'},\n", " {'year': 2019, 'value': 2000000.0, 'MARS': 'mjoint'},\n", " {'year': 2019, 'value': 2000000.0, 'MARS': 'single'}]),\n", " ('II_rt7', [{'year': 2019, 'value': 0.7}])])" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import taxcalc\n", "\n", "pol = taxcalc.Policy()\n", "pol.adjust(\"cs://PSLmodels:Tax-Brain@47410/inputs/adjustment/policy\")" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [], "source": [ "import io\n", "\n", "import pandas as pd\n", "import paramtools\n", "\n", "data = paramtools.read_json(\"cs://PSLmodels:Tax-Brain@47410/outputs\")\n", "\n", "results = []\n", "for output in data:\n", " results.append(\n", " pd.read_csv(io.StringIO(output[\"data\"]))\n", " )" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | Unnamed: 0 | \n", "2019 | \n", "2020 | \n", "2021 | \n", "2022 | \n", "2023 | \n", "2024 | \n", "2025 | \n", "2026 | \n", "2027 | \n", "2028 | \n", "2029 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Individual Income Tax Liability Change | \n", "$651.31 | \n", "$677.74 | \n", "$707.50 | \n", "$735.71 | \n", "$764.94 | \n", "$793.97 | \n", "$824.71 | \n", "$609.33 | \n", "$631.98 | \n", "$654.94 | \n", "$678.08 | \n", "
1 | \n", "Payroll Tax Liability Change | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "
2 | \n", "Combined Payroll and Individual Income Tax Lia... | \n", "$651.31 | \n", "$677.74 | \n", "$707.50 | \n", "$735.71 | \n", "$764.94 | \n", "$793.97 | \n", "$824.71 | \n", "$609.33 | \n", "$631.98 | \n", "$654.94 | \n", "$678.08 | \n", "