import pandas as pd

streams_df = pd.DataFrame([
    {
        "id": "8060",
        "phase": "liquid",
        "temperature_K": 324.15,
        "pressure_kPa_abs": 3236.39,
        "molar_flow_kmol_per_hr": 11640,
        "mass_flow_kg_per_hr": 316670,
        "molecular_weight_kg_per_kmol": 27.2,
        "density_kgm3": 1022,
        "viscosity_cP": 2.356,
        "Cp_kcal_kgC": 0.9,
        "sp_enthalpy_kcal_kg": -2605,
        "sp_heat_capacity_kcal_kg_celcius": 0.9,
        "composition": {
            "LEANMDEA": {
                "wt%": 100.0
            }
        }
    },
    {
        "id": "6215",
        "phase": "liquid",
        "temperature_K": 353.15,
        "pressure_kPa_abs": 4123.1,
        "molar_flow_kmol_per_hr": 63,
        "mass_flow_kg_per_hr": 1144,
        "molecular_weight_kg_per_kmol": 18.02,
        "density_kgm3": 973,
        "viscosity_cP": 0.355,
        "Cp_kcal_kgC": 1.0,
        "sp_enthalpy_kcal_kg": -3736,
        "sp_heat_capacity_kcal_kg_celcius": 1.0,
        "composition": {
            "H2O": {
                "wt%": 100.0
            }
        }
    },
    {
        "id": "2250",
        "phase": "vapor",
        "temperature_K": 323.15,
        "pressure_kPa_abs": 3308.12,
        "molar_flow_kmol_per_hr": 6663,
        "mass_flow_kg_per_hr": 57817,
        "molecular_weight_kg_per_kmol": 8.68,
        "density_kgm3": 10.6,
        "viscosity_cP": 0.016,
        "sp_enthalpy_kcal_kg": -29,
        "sp_heat_capacity_kcal_kg_celcius": 0.802,
        "composition": {
            "Ar":     {"wt%": 1.4, "kg/h": 781,  "mol%": 0.29, "kmol/h": 20},
            "CO2":    {"wt%": 0.3, "kg/h": 146,  "mol%": 0.05, "kmol/h": 3},
            "CO":     {"wt%": 1.2, "kg/h": 706,  "mol%": 0.38, "kmol/h": 25},
            "H2":     {"wt%": 17.3,"kg/h": 9974, "mol%": 74.25,"kmol/h": 4947},
            "CH4":    {"wt%": 0.6, "kg/h": 343,  "mol%": 0.32, "kmol/h": 21},
            "N2":     {"wt%": 78.5,"kg/h": 45410,"mol%": 24.33,"kmol/h": 1621},
            "H2O":    {"wt%": 0.8, "kg/h": 458,  "mol%": 0.38, "kmol/h": 25}
        }
    },
    {
       "id": "8045",
        "phase": "liquid",
        "temperature_K": 348.15,  # 75 °C
        "pressure_kPa_abs": 3337.52,  # 33 kg/cm²g + 1.033 atm → 34.033 * 98.0665
        "molar_flow_kmol_per_hr": 60286,
        "mass_flow_kg_per_hr": 1640080,
        "molecular_weight_kg_per_kmol": 27.2,
        "density_kgm3": 1052,
        "viscosity_cP": 1.463,
        "Cp_kcal_kgC": 0.9,
        "sp_enthalpy_kcal_kg": -2586,
        "sp_heat_capacity_kcal_kg_celcius": 0.9,
        "enthalpy_Gcalh": -4241.98,
        "composition": {
            "SEMIMDEA2": {
                "wt%": 100.0
            }
        }
    },
    {
       "id": "2184",
        "phase": "vapor",
        "temperature_K": 328.15,  # 55 °C
        "pressure_kPa_abs": 3337.52,  # 33 + 1.033 atm → 34.033 * 98.0665
        "molar_flow_kmol_per_hr": 8171,
        "mass_flow_kg_per_hr": 122987,
        "molecular_weight_kg_per_kmol": 15.05,
        "density_kgm3": 18.4,
        "viscosity_cP": 0.017,
        "Cp_kcal_kgC": 0.491,
        "sp_enthalpy_kcal_kg": -1141,
        "sp_heat_capacity_kcal_kg_celcius": 0.491,
        "enthalpy_Gcalh": -140.30,
        "composition": {
            "Ar":     {"wt%": 0.6,  "kg/h": 781,   "mol%": 0.24,  "kmol/h": 20},
            "CO2":    {"wt%": 52.8, "kg/h": 64944, "mol%": 18.06, "kmol/h": 1476},
            "CO":     {"wt%": 0.6,  "kg/h": 709,   "mol%": 0.31,  "kmol/h": 25},
            "H2":     {"wt%": 8.1,  "kg/h": 10012, "mol%": 60.78, "kmol/h": 4966},
            "CH4":    {"wt%": 0.3,  "kg/h": 344,   "mol%": 0.26,  "kmol/h": 21},
            "N2":     {"wt%": 37.0, "kg/h": 45497, "mol%": 19.88, "kmol/h": 1624},
            "H2O":    {"wt%": 0.6,  "kg/h": 701,   "mol%": 0.48,  "kmol/h": 39}
        } 
    },
    {
        "id": "8001",
        "phase": "liquid",
        "temperature_K": 355.15,  # 82 °C
        "pressure_kPa_abs": 3337.52,  # (33 + 1.033) * 98.0665
        "molar_flow_kmol_per_hr": 74380,
        "mass_flow_kg_per_hr": 2023500,
        "molecular_weight_kg_per_kmol": 27.20,
        "density_kgm3": 1075,
        "viscosity_cP": 1.392,
        "Cp_kcal_kgC": 0.888,
        "sp_enthalpy_kcal_kg": -2580,
        "sp_heat_capacity_kcal_kg_celcius": 0.888,
        "enthalpy_Gcalh": -5221.15,
        "composition": {
            "RICHMDEA": {
                "wt%": 100.0,
                "kg/h": 2023500,
                "mol%": 100.0,
                "kmol/h": 74380
            }
        } 
    }
])