Untitled

 avatar
unknown
plain_text
2 months ago
1.5 kB
2
Indexable
import pandas as pd
import ace_tools as tools

# Creating a DataFrame to format the table neatly
data = {
    "Category": [
        "Salary",
        "Ordinary Loss",
        "Long-term Capital Gain",
        "Less: Long-term Capital Loss",
        "Equals: Net Long-term Capital Loss",
        "Deductible Net Long-term Capital Loss",
        "Net Long-term Capital Loss Carryover",
        "Adjusted Gross Income (AGI)",
        "Next Year's Salary",
        "Next Year's Long-term Capital Gain",
        "Less: Net Long-term Capital Loss Carryover",
        "Equals: Net Long-term Capital Loss (Before Limitation)",
        "Deductible Net Long-term Capital Loss",
        "Next Year's AGI",
        "Total AGI for 2 Years",
    ],
    "Sell All Stock This Year": [
        "$80,000",
        "($50,000)",
        "$8,000",
        "($30,000)",
        "($22,000)",
        "($3,000)",
        "($19,000)",
        "$27,000",
        "$90,000",
        "$10,000",
        "($19,000)",
        "($9,000)",
        "($3,000)",
        "$97,000",
        "$124,000",
    ],
    "Sell Half Stock Each Year": [
        "$80,000",
        "($40,000)",
        "$8,000",
        "0",
        "$8,000",
        "$8,000",
        "0",
        "$48,000",
        "$90,000",
        "$10,000",
        "0",
        "$10,000",
        "$10,000",
        "$60,000",
        "$108,000",
    ],
}

# Convert to DataFrame
df = pd.DataFrame(data)

# Display table for user
tools.display_dataframe_to_user(name="Abby's AGI Comparison Table", dataframe=df)
Editor is loading...
Leave a Comment