{
"cells": [
{
"cell_type": "code",
"execution_count": 2,
"id": "59fefb9a-b2d5-486b-9866-abec8fdeec35",
"metadata": {},
"outputs": [],
"source": [
"import pandapower as pp\n",
"import pandapower.networks as nets\n",
"import os\n",
"import io\n",
"import zipfile"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "0ab964d6-8a82-44b1-a9a1-c4874c679666",
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": 3,
"id": "0eb3828c-6b93-455d-97ae-17b38d244f62",
"metadata": {},
"outputs": [],
"source": [
"def to_csv(net,path):\n",
" \n",
" #the sn_mva and f_hz are not included in csv files!\n",
" net.bus.to_csv(os.path.join(path,\"bus.csv\"),index_label=\"index\")\n",
" net.line.to_csv(os.path.join(path,\"line.csv\"),index=False)\n",
" net.load.to_csv(os.path.join(path,\"load.csv\"),index=False)\n",
" net.gen.to_csv(os.path.join(path,\"gen.csv\"),index=False)\n",
" net.shunt.to_csv(os.path.join(path,\"shunt.csv\"),index=False)\n",
" net.trafo.to_csv(os.path.join(path,\"trafo.csv\"),index=False)\n",
" net.ext_grid.to_csv(os.path.join(path,\"ext_grid.csv\"),index=False)\n",
" net.sgen.to_csv(os.path.join(path,\"sgen.csv\"),index=False)"
]
},
{
"cell_type": "code",
"execution_count": 4,
"id": "9fe13d33-2b55-4649-9d62-cdab58810d0b",
"metadata": {},
"outputs": [],
"source": [
"def to_csv_zip(net,filepath):\n",
" def compress_files_to_zip(files_dict, output_path):\n",
" with zipfile.ZipFile(output_path, 'w', zipfile.ZIP_DEFLATED , allowZip64=True) as zipf:\n",
" for relative_path, file_content in files_dict.items():\n",
" zipf.writestr(relative_path, file_content)\n",
"\n",
"\n",
" file_dict={}\n",
" for name, df in [(\"bus.csv\", net.bus), \n",
" (\"line.csv\", net.line),\n",
" (\"load.csv\", net.load),\n",
" (\"gen.csv\", net.gen),\n",
" (\"shunt.csv\", net.shunt),\n",
" (\"trafo.csv\", net.trafo),\n",
" (\"ext_grid.csv\", net.ext_grid),\n",
" (\"sgen.csv\", net.sgen)]:\n",
" file_dict[name] = df.to_csv(index_label=\"index\" if name == \"bus.csv\" else None, \n",
" index=True if name == \"bus.csv\" else False )\n",
" \n",
" \n",
" compress_files_to_zip(file_dict,filepath)\n",
"\n",
" return "
]
},
{
"cell_type": "code",
"execution_count": 6,
"id": "a4d47f47-fdba-4a03-850a-dc4aebbe5e16",
"metadata": {},
"outputs": [],
"source": [
"net = nets.case118()"
]
},
{
"cell_type": "code",
"execution_count": 64,
"id": "c049a5bc-b905-40e1-862e-e56a811f3ecc",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"12.8 ms ± 0 ns per loop (mean ± std. dev. of 1 run, 10 loops each)\n"
]
}
],
"source": [
"%timeit -n10 -r1 pp.runpp(net)"
]
},
{
"cell_type": "code",
"execution_count": 65,
"id": "4c85a76f-062b-4a8a-a1b5-34104a9843f9",
"metadata": {},
"outputs": [],
"source": [
"\n",
"to_csv_zip(net,\"./IEEE118/data.zip\")"
]
},
{
"cell_type": "code",
"execution_count": 66,
"id": "1a80ae7e-9fcd-4a33-9797-a0667c53be04",
"metadata": {},
"outputs": [],
"source": [
"to_csv(net,\"./IEEE118/\")"
]
},
{
"cell_type": "code",
"execution_count": 168,
"id": "a92e5ebe-919f-448d-b32a-fb74f610d6d2",
"metadata": {},
"outputs": [],
"source": [
"net = nets.case9241pegase()"
]
},
{
"cell_type": "code",
"execution_count": 169,
"id": "6d1e7fb4-0006-4dd5-af98-be3df6b6c9e9",
"metadata": {},
"outputs": [],
"source": [
"to_csv(net,\"./pegase9241/\")"
]
},
{
"cell_type": "code",
"execution_count": 170,
"id": "0dd5d2c5-761d-4613-ac1c-93045aac44af",
"metadata": {},
"outputs": [],
"source": [
"to_csv_zip(net,\"./pegase9241/data.zip\")"
]
},
{
"cell_type": "code",
"execution_count": 173,
"id": "39dcf22d-9f85-499a-a181-ea098205790f",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"3.22 s ± 0 ns per loop (mean ± std. dev. of 1 run, 1 loop each)\n"
]
}
],
"source": [
"%timeit -n1 -r1 pp.runpp(net,trafo_model=\"pi\",check_connectivity=False)"
]
},
{
"cell_type": "code",
"execution_count": 7,
"id": "fe2e0389-7552-49e4-b06e-71805fd600c2",
"metadata": {},
"outputs": [],
"source": [
"net = nets.case39()"
]
},
{
"cell_type": "code",
"execution_count": 43,
"id": "0ee9f0b1-6548-4d8d-9dc6-477657e748cb",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>name</th>\n",
" <th>bus</th>\n",
" <th>p_mw</th>\n",
" <th>vm_pu</th>\n",
" <th>sn_mva</th>\n",
" <th>min_q_mvar</th>\n",
" <th>max_q_mvar</th>\n",
" <th>scaling</th>\n",
" <th>slack</th>\n",
" <th>in_service</th>\n",
" <th>slack_weight</th>\n",
" <th>type</th>\n",
" <th>controllable</th>\n",
" <th>max_p_mw</th>\n",
" <th>min_p_mw</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>None</td>\n",
" <td>29</td>\n",
" <td>250.0</td>\n",
" <td>1.0499</td>\n",
" <td>NaN</td>\n",
" <td>140.0</td>\n",
" <td>400.0</td>\n",
" <td>1.0</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" <td>0.0</td>\n",
" <td>None</td>\n",
" <td>True</td>\n",
" <td>1040.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>None</td>\n",
" <td>31</td>\n",
" <td>650.0</td>\n",
" <td>0.9841</td>\n",
" <td>NaN</td>\n",
" <td>150.0</td>\n",
" <td>300.0</td>\n",
" <td>1.0</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" <td>0.0</td>\n",
" <td>None</td>\n",
" <td>True</td>\n",
" <td>725.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>None</td>\n",
" <td>32</td>\n",
" <td>632.0</td>\n",
" <td>0.9972</td>\n",
" <td>NaN</td>\n",
" <td>0.0</td>\n",
" <td>250.0</td>\n",
" <td>1.0</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" <td>0.0</td>\n",
" <td>None</td>\n",
" <td>True</td>\n",
" <td>652.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>None</td>\n",
" <td>33</td>\n",
" <td>508.0</td>\n",
" <td>1.0123</td>\n",
" <td>NaN</td>\n",
" <td>0.0</td>\n",
" <td>167.0</td>\n",
" <td>1.0</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" <td>0.0</td>\n",
" <td>None</td>\n",
" <td>True</td>\n",
" <td>508.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>None</td>\n",
" <td>34</td>\n",
" <td>650.0</td>\n",
" <td>1.0494</td>\n",
" <td>NaN</td>\n",
" <td>-100.0</td>\n",
" <td>300.0</td>\n",
" <td>1.0</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" <td>0.0</td>\n",
" <td>None</td>\n",
" <td>True</td>\n",
" <td>687.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>None</td>\n",
" <td>35</td>\n",
" <td>560.0</td>\n",
" <td>1.0636</td>\n",
" <td>NaN</td>\n",
" <td>0.0</td>\n",
" <td>240.0</td>\n",
" <td>1.0</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" <td>0.0</td>\n",
" <td>None</td>\n",
" <td>True</td>\n",
" <td>580.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>None</td>\n",
" <td>36</td>\n",
" <td>540.0</td>\n",
" <td>1.0275</td>\n",
" <td>NaN</td>\n",
" <td>0.0</td>\n",
" <td>250.0</td>\n",
" <td>1.0</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" <td>0.0</td>\n",
" <td>None</td>\n",
" <td>True</td>\n",
" <td>564.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>None</td>\n",
" <td>37</td>\n",
" <td>830.0</td>\n",
" <td>1.0265</td>\n",
" <td>NaN</td>\n",
" <td>-150.0</td>\n",
" <td>300.0</td>\n",
" <td>1.0</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" <td>0.0</td>\n",
" <td>None</td>\n",
" <td>True</td>\n",
" <td>865.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>None</td>\n",
" <td>38</td>\n",
" <td>1000.0</td>\n",
" <td>1.0300</td>\n",
" <td>NaN</td>\n",
" <td>-100.0</td>\n",
" <td>300.0</td>\n",
" <td>1.0</td>\n",
" <td>False</td>\n",
" <td>True</td>\n",
" <td>0.0</td>\n",
" <td>None</td>\n",
" <td>True</td>\n",
" <td>1100.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" name bus p_mw vm_pu sn_mva min_q_mvar max_q_mvar scaling slack \\\n",
"0 None 29 250.0 1.0499 NaN 140.0 400.0 1.0 False \n",
"1 None 31 650.0 0.9841 NaN 150.0 300.0 1.0 False \n",
"2 None 32 632.0 0.9972 NaN 0.0 250.0 1.0 False \n",
"3 None 33 508.0 1.0123 NaN 0.0 167.0 1.0 False \n",
"4 None 34 650.0 1.0494 NaN -100.0 300.0 1.0 False \n",
"5 None 35 560.0 1.0636 NaN 0.0 240.0 1.0 False \n",
"6 None 36 540.0 1.0275 NaN 0.0 250.0 1.0 False \n",
"7 None 37 830.0 1.0265 NaN -150.0 300.0 1.0 False \n",
"8 None 38 1000.0 1.0300 NaN -100.0 300.0 1.0 False \n",
"\n",
" in_service slack_weight type controllable max_p_mw min_p_mw \n",
"0 True 0.0 None True 1040.0 0.0 \n",
"1 True 0.0 None True 725.0 0.0 \n",
"2 True 0.0 None True 652.0 0.0 \n",
"3 True 0.0 None True 508.0 0.0 \n",
"4 True 0.0 None True 687.0 0.0 \n",
"5 True 0.0 None True 580.0 0.0 \n",
"6 True 0.0 None True 564.0 0.0 \n",
"7 True 0.0 None True 865.0 0.0 \n",
"8 True 0.0 None True 1100.0 0.0 "
]
},
"execution_count": 43,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"net.gen"
]
},
{
"cell_type": "code",
"execution_count": 52,
"id": "bec760b2-e91a-4709-bdbc-fbd87de3c3b1",
"metadata": {
"scrolled": true
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>p_from_mw</th>\n",
" <th>q_from_mvar</th>\n",
" <th>p_to_mw</th>\n",
" <th>q_to_mvar</th>\n",
" <th>pl_mw</th>\n",
" <th>ql_mvar</th>\n",
" <th>i_from_ka</th>\n",
" <th>i_to_ka</th>\n",
" <th>i_ka</th>\n",
" <th>vm_from_pu</th>\n",
" <th>va_from_degree</th>\n",
" <th>vm_to_pu</th>\n",
" <th>va_to_degree</th>\n",
" <th>loading_percent</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>-173.699968</td>\n",
" <td>-40.307333</td>\n",
" <td>174.677680</td>\n",
" <td>-24.357906</td>\n",
" <td>0.977711</td>\n",
" <td>-64.665239</td>\n",
" <td>0.287100</td>\n",
" <td>0.281497</td>\n",
" <td>0.287100</td>\n",
" <td>1.039384</td>\n",
" <td>-13.536602</td>\n",
" <td>1.048494</td>\n",
" <td>-9.785267</td>\n",
" <td>28.593122</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>76.099968</td>\n",
" <td>-3.892667</td>\n",
" <td>-76.033949</td>\n",
" <td>-74.752542</td>\n",
" <td>0.066019</td>\n",
" <td>-78.645208</td>\n",
" <td>0.122686</td>\n",
" <td>0.173239</td>\n",
" <td>0.173239</td>\n",
" <td>1.039384</td>\n",
" <td>-13.536602</td>\n",
" <td>1.030000</td>\n",
" <td>-14.535256</td>\n",
" <td>10.352039</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>319.914587</td>\n",
" <td>88.586564</td>\n",
" <td>-318.579542</td>\n",
" <td>-100.878939</td>\n",
" <td>1.335045</td>\n",
" <td>-12.292376</td>\n",
" <td>0.529823</td>\n",
" <td>0.542565</td>\n",
" <td>0.542565</td>\n",
" <td>1.048494</td>\n",
" <td>-9.785267</td>\n",
" <td>1.030708</td>\n",
" <td>-12.276384</td>\n",
" <td>64.842795</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>-244.592267</td>\n",
" <td>82.973576</td>\n",
" <td>248.928897</td>\n",
" <td>-93.837355</td>\n",
" <td>4.336630</td>\n",
" <td>-10.863779</td>\n",
" <td>0.412240</td>\n",
" <td>0.420913</td>\n",
" <td>0.420913</td>\n",
" <td>1.048494</td>\n",
" <td>-9.785267</td>\n",
" <td>1.057683</td>\n",
" <td>-8.369235</td>\n",
" <td>50.303984</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>37.339618</td>\n",
" <td>113.064517</td>\n",
" <td>-37.131890</td>\n",
" <td>-132.590249</td>\n",
" <td>0.207728</td>\n",
" <td>-19.525732</td>\n",
" <td>0.193326</td>\n",
" <td>0.229401</td>\n",
" <td>0.229401</td>\n",
" <td>1.030708</td>\n",
" <td>-12.276384</td>\n",
" <td>1.004460</td>\n",
" <td>-12.626734</td>\n",
" <td>27.416027</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>-40.760076</td>\n",
" <td>-14.585578</td>\n",
" <td>40.777386</td>\n",
" <td>-7.937413</td>\n",
" <td>0.017310</td>\n",
" <td>-22.522990</td>\n",
" <td>0.070288</td>\n",
" <td>0.067393</td>\n",
" <td>0.070288</td>\n",
" <td>1.030708</td>\n",
" <td>-12.276384</td>\n",
" <td>1.031573</td>\n",
" <td>-11.986168</td>\n",
" <td>8.400275</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>-197.449493</td>\n",
" <td>-4.089870</td>\n",
" <td>197.758676</td>\n",
" <td>-4.524021</td>\n",
" <td>0.309184</td>\n",
" <td>-8.613891</td>\n",
" <td>0.329031</td>\n",
" <td>0.329055</td>\n",
" <td>0.329055</td>\n",
" <td>1.004460</td>\n",
" <td>-12.626734</td>\n",
" <td>1.006006</td>\n",
" <td>-11.192339</td>\n",
" <td>32.771568</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>-265.418617</td>\n",
" <td>-47.319880</td>\n",
" <td>265.990108</td>\n",
" <td>42.482103</td>\n",
" <td>0.571491</td>\n",
" <td>-4.837777</td>\n",
" <td>0.449173</td>\n",
" <td>0.445285</td>\n",
" <td>0.449173</td>\n",
" <td>1.004460</td>\n",
" <td>-12.626734</td>\n",
" <td>1.012319</td>\n",
" <td>-10.715295</td>\n",
" <td>53.681345</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>-536.936553</td>\n",
" <td>-43.112382</td>\n",
" <td>537.509598</td>\n",
" <td>46.159984</td>\n",
" <td>0.573046</td>\n",
" <td>3.047602</td>\n",
" <td>0.896062</td>\n",
" <td>0.895456</td>\n",
" <td>0.896062</td>\n",
" <td>1.006006</td>\n",
" <td>-11.192339</td>\n",
" <td>1.008226</td>\n",
" <td>-10.408330</td>\n",
" <td>44.620712</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>339.177876</td>\n",
" <td>47.636403</td>\n",
" <td>-338.244496</td>\n",
" <td>-49.386632</td>\n",
" <td>0.933380</td>\n",
" <td>-1.750229</td>\n",
" <td>0.569756</td>\n",
" <td>0.573267</td>\n",
" <td>0.573267</td>\n",
" <td>1.006006</td>\n",
" <td>-11.192339</td>\n",
" <td>0.997872</td>\n",
" <td>-13.335844</td>\n",
" <td>38.062198</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>453.815603</td>\n",
" <td>81.548655</td>\n",
" <td>-452.555016</td>\n",
" <td>-73.594881</td>\n",
" <td>1.260588</td>\n",
" <td>7.953774</td>\n",
" <td>0.765320</td>\n",
" <td>0.768522</td>\n",
" <td>0.768522</td>\n",
" <td>1.008226</td>\n",
" <td>-10.408330</td>\n",
" <td>0.998397</td>\n",
" <td>-12.755626</td>\n",
" <td>51.026225</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>-322.654076</td>\n",
" <td>-38.854733</td>\n",
" <td>323.377935</td>\n",
" <td>33.142325</td>\n",
" <td>0.723859</td>\n",
" <td>-5.712408</td>\n",
" <td>0.539419</td>\n",
" <td>0.536815</td>\n",
" <td>0.539419</td>\n",
" <td>1.008226</td>\n",
" <td>-10.408330</td>\n",
" <td>1.013386</td>\n",
" <td>-8.936966</td>\n",
" <td>67.152867</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>218.755016</td>\n",
" <td>-10.405119</td>\n",
" <td>-218.562815</td>\n",
" <td>4.844495</td>\n",
" <td>0.192201</td>\n",
" <td>-5.560624</td>\n",
" <td>0.367084</td>\n",
" <td>0.366630</td>\n",
" <td>0.367084</td>\n",
" <td>0.998397</td>\n",
" <td>-12.755626</td>\n",
" <td>0.997872</td>\n",
" <td>-13.335844</td>\n",
" <td>24.372655</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>34.807312</td>\n",
" <td>-132.057863</td>\n",
" <td>-34.483766</td>\n",
" <td>97.719009</td>\n",
" <td>0.323545</td>\n",
" <td>-34.338854</td>\n",
" <td>0.229031</td>\n",
" <td>0.167012</td>\n",
" <td>0.229031</td>\n",
" <td>0.997872</td>\n",
" <td>-13.335844</td>\n",
" <td>1.038332</td>\n",
" <td>-14.178442</td>\n",
" <td>15.206581</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>27.983766</td>\n",
" <td>-31.119009</td>\n",
" <td>-27.966051</td>\n",
" <td>-96.780099</td>\n",
" <td>0.017716</td>\n",
" <td>-127.899108</td>\n",
" <td>0.067451</td>\n",
" <td>0.163676</td>\n",
" <td>0.163676</td>\n",
" <td>1.038332</td>\n",
" <td>-14.178442</td>\n",
" <td>1.030000</td>\n",
" <td>-14.535256</td>\n",
" <td>10.867282</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>327.901325</td>\n",
" <td>73.374434</td>\n",
" <td>-327.463213</td>\n",
" <td>-76.184203</td>\n",
" <td>0.438112</td>\n",
" <td>-2.809769</td>\n",
" <td>0.552449</td>\n",
" <td>0.555206</td>\n",
" <td>0.555206</td>\n",
" <td>1.017843</td>\n",
" <td>-8.170875</td>\n",
" <td>1.013386</td>\n",
" <td>-8.936966</td>\n",
" <td>55.294597</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>322.098675</td>\n",
" <td>37.491892</td>\n",
" <td>-321.691531</td>\n",
" <td>-40.645937</td>\n",
" <td>0.407143</td>\n",
" <td>-3.154045</td>\n",
" <td>0.533152</td>\n",
" <td>0.534646</td>\n",
" <td>0.534646</td>\n",
" <td>1.017843</td>\n",
" <td>-8.170875</td>\n",
" <td>1.014923</td>\n",
" <td>-8.929927</td>\n",
" <td>53.246929</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>317.183525</td>\n",
" <td>-6.032722</td>\n",
" <td>-316.304437</td>\n",
" <td>-1.804560</td>\n",
" <td>0.879088</td>\n",
" <td>-7.837281</td>\n",
" <td>0.523090</td>\n",
" <td>0.522896</td>\n",
" <td>0.523090</td>\n",
" <td>1.014923</td>\n",
" <td>-8.929927</td>\n",
" <td>1.012319</td>\n",
" <td>-10.715295</td>\n",
" <td>52.096054</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>50.314329</td>\n",
" <td>-40.677543</td>\n",
" <td>-50.261421</td>\n",
" <td>3.664547</td>\n",
" <td>0.052908</td>\n",
" <td>-37.012996</td>\n",
" <td>0.106958</td>\n",
" <td>0.082991</td>\n",
" <td>0.106958</td>\n",
" <td>1.012319</td>\n",
" <td>-10.715295</td>\n",
" <td>1.016185</td>\n",
" <td>-11.345399</td>\n",
" <td>10.652243</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>-269.738579</td>\n",
" <td>-156.664547</td>\n",
" <td>270.563198</td>\n",
" <td>147.333083</td>\n",
" <td>0.824619</td>\n",
" <td>-9.331464</td>\n",
" <td>0.513700</td>\n",
" <td>0.499322</td>\n",
" <td>0.513700</td>\n",
" <td>1.016185</td>\n",
" <td>-11.345399</td>\n",
" <td>1.032520</td>\n",
" <td>-10.033348</td>\n",
" <td>51.160905</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>224.017064</td>\n",
" <td>-42.539912</td>\n",
" <td>-223.679337</td>\n",
" <td>32.503042</td>\n",
" <td>0.337728</td>\n",
" <td>-10.036870</td>\n",
" <td>0.369569</td>\n",
" <td>0.365733</td>\n",
" <td>0.369569</td>\n",
" <td>1.032520</td>\n",
" <td>-10.033348</td>\n",
" <td>1.034237</td>\n",
" <td>-11.116436</td>\n",
" <td>36.806440</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>-451.298541</td>\n",
" <td>-54.203176</td>\n",
" <td>454.376895</td>\n",
" <td>58.754526</td>\n",
" <td>3.078355</td>\n",
" <td>4.551350</td>\n",
" <td>0.736708</td>\n",
" <td>0.730136</td>\n",
" <td>0.736708</td>\n",
" <td>1.032520</td>\n",
" <td>-10.033348</td>\n",
" <td>1.050107</td>\n",
" <td>-5.410073</td>\n",
" <td>73.370945</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>-329.601665</td>\n",
" <td>14.440022</td>\n",
" <td>330.422772</td>\n",
" <td>-27.742741</td>\n",
" <td>0.821106</td>\n",
" <td>-13.302719</td>\n",
" <td>0.534721</td>\n",
" <td>0.537529</td>\n",
" <td>0.537529</td>\n",
" <td>1.032520</td>\n",
" <td>-10.033348</td>\n",
" <td>1.032319</td>\n",
" <td>-7.628746</td>\n",
" <td>53.534054</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>-42.680056</td>\n",
" <td>-97.330017</td>\n",
" <td>42.709890</td>\n",
" <td>90.628717</td>\n",
" <td>0.029835</td>\n",
" <td>-6.701300</td>\n",
" <td>0.172250</td>\n",
" <td>0.161525</td>\n",
" <td>0.172250</td>\n",
" <td>1.032520</td>\n",
" <td>-10.033348</td>\n",
" <td>1.038001</td>\n",
" <td>-9.913759</td>\n",
" <td>17.154888</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>199.038791</td>\n",
" <td>11.052428</td>\n",
" <td>-198.777386</td>\n",
" <td>-22.062587</td>\n",
" <td>0.261405</td>\n",
" <td>-11.010159</td>\n",
" <td>0.322557</td>\n",
" <td>0.324449</td>\n",
" <td>0.324449</td>\n",
" <td>1.034237</td>\n",
" <td>-11.116436</td>\n",
" <td>1.031573</td>\n",
" <td>-11.986168</td>\n",
" <td>32.312804</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>24.640546</td>\n",
" <td>-43.555470</td>\n",
" <td>-24.624725</td>\n",
" <td>9.229304</td>\n",
" <td>0.015821</td>\n",
" <td>-34.326166</td>\n",
" <td>0.080973</td>\n",
" <td>0.042383</td>\n",
" <td>0.080973</td>\n",
" <td>1.034237</td>\n",
" <td>-11.116436</td>\n",
" <td>1.038345</td>\n",
" <td>-11.362152</td>\n",
" <td>8.064296</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>-604.422772</td>\n",
" <td>-87.257259</td>\n",
" <td>607.205906</td>\n",
" <td>108.151323</td>\n",
" <td>2.783135</td>\n",
" <td>20.894064</td>\n",
" <td>0.989979</td>\n",
" <td>0.982856</td>\n",
" <td>0.989979</td>\n",
" <td>1.032319</td>\n",
" <td>-7.628746</td>\n",
" <td>1.050143</td>\n",
" <td>-3.183120</td>\n",
" <td>65.729964</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>42.794094</td>\n",
" <td>41.884254</td>\n",
" <td>-42.769382</td>\n",
" <td>-61.749908</td>\n",
" <td>0.024711</td>\n",
" <td>-19.865654</td>\n",
" <td>0.095423</td>\n",
" <td>0.120274</td>\n",
" <td>0.120274</td>\n",
" <td>1.050143</td>\n",
" <td>-3.183120</td>\n",
" <td>1.045145</td>\n",
" <td>-3.381276</td>\n",
" <td>11.978409</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>353.838954</td>\n",
" <td>-0.500605</td>\n",
" <td>-351.309890</td>\n",
" <td>1.571283</td>\n",
" <td>2.529064</td>\n",
" <td>1.070677</td>\n",
" <td>0.566565</td>\n",
" <td>0.566392</td>\n",
" <td>0.566565</td>\n",
" <td>1.045145</td>\n",
" <td>-3.381276</td>\n",
" <td>1.038001</td>\n",
" <td>-9.913759</td>\n",
" <td>56.425868</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>-558.569572</td>\n",
" <td>-22.349487</td>\n",
" <td>560.000000</td>\n",
" <td>100.164792</td>\n",
" <td>1.430428</td>\n",
" <td>77.815305</td>\n",
" <td>0.895093</td>\n",
" <td>0.895093</td>\n",
" <td>0.895093</td>\n",
" <td>1.045145</td>\n",
" <td>-3.381276</td>\n",
" <td>1.063600</td>\n",
" <td>4.468437</td>\n",
" <td>59.429976</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>65.413892</td>\n",
" <td>-18.810932</td>\n",
" <td>-65.288100</td>\n",
" <td>-39.035004</td>\n",
" <td>0.125792</td>\n",
" <td>-57.845936</td>\n",
" <td>0.107693</td>\n",
" <td>0.120941</td>\n",
" <td>0.120941</td>\n",
" <td>1.057683</td>\n",
" <td>-8.369235</td>\n",
" <td>1.052561</td>\n",
" <td>-9.438770</td>\n",
" <td>12.044828</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>257.295728</td>\n",
" <td>68.205232</td>\n",
" <td>-256.375275</td>\n",
" <td>-84.729304</td>\n",
" <td>0.920453</td>\n",
" <td>-16.524072</td>\n",
" <td>0.423206</td>\n",
" <td>0.435175</td>\n",
" <td>0.435175</td>\n",
" <td>1.052561</td>\n",
" <td>-9.438770</td>\n",
" <td>1.038345</td>\n",
" <td>-11.362152</td>\n",
" <td>43.340381</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>-140.819246</td>\n",
" <td>-21.209607</td>\n",
" <td>141.607705</td>\n",
" <td>-56.356758</td>\n",
" <td>0.788459</td>\n",
" <td>-77.566365</td>\n",
" <td>0.226415</td>\n",
" <td>0.242823</td>\n",
" <td>0.242823</td>\n",
" <td>1.052561</td>\n",
" <td>-9.438770</td>\n",
" <td>1.050374</td>\n",
" <td>-5.928359</td>\n",
" <td>24.183467</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>-190.188382</td>\n",
" <td>-24.960621</td>\n",
" <td>192.102205</td>\n",
" <td>-67.791212</td>\n",
" <td>1.913823</td>\n",
" <td>-92.751833</td>\n",
" <td>0.304976</td>\n",
" <td>0.324640</td>\n",
" <td>0.324640</td>\n",
" <td>1.052561</td>\n",
" <td>-9.438770</td>\n",
" <td>1.050115</td>\n",
" <td>-3.169874</td>\n",
" <td>32.331827</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>-347.607705</td>\n",
" <td>28.756758</td>\n",
" <td>349.163889</td>\n",
" <td>-39.437225</td>\n",
" <td>1.556184</td>\n",
" <td>-10.680467</td>\n",
" <td>0.555708</td>\n",
" <td>0.559971</td>\n",
" <td>0.559971</td>\n",
" <td>1.050374</td>\n",
" <td>-5.928359</td>\n",
" <td>1.050115</td>\n",
" <td>-3.169874</td>\n",
" <td>55.769135</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" p_from_mw q_from_mvar p_to_mw q_to_mvar pl_mw ql_mvar \\\n",
"0 -173.699968 -40.307333 174.677680 -24.357906 0.977711 -64.665239 \n",
"1 76.099968 -3.892667 -76.033949 -74.752542 0.066019 -78.645208 \n",
"2 319.914587 88.586564 -318.579542 -100.878939 1.335045 -12.292376 \n",
"3 -244.592267 82.973576 248.928897 -93.837355 4.336630 -10.863779 \n",
"4 37.339618 113.064517 -37.131890 -132.590249 0.207728 -19.525732 \n",
"5 -40.760076 -14.585578 40.777386 -7.937413 0.017310 -22.522990 \n",
"6 -197.449493 -4.089870 197.758676 -4.524021 0.309184 -8.613891 \n",
"7 -265.418617 -47.319880 265.990108 42.482103 0.571491 -4.837777 \n",
"8 -536.936553 -43.112382 537.509598 46.159984 0.573046 3.047602 \n",
"9 339.177876 47.636403 -338.244496 -49.386632 0.933380 -1.750229 \n",
"10 453.815603 81.548655 -452.555016 -73.594881 1.260588 7.953774 \n",
"11 -322.654076 -38.854733 323.377935 33.142325 0.723859 -5.712408 \n",
"12 218.755016 -10.405119 -218.562815 4.844495 0.192201 -5.560624 \n",
"13 34.807312 -132.057863 -34.483766 97.719009 0.323545 -34.338854 \n",
"14 27.983766 -31.119009 -27.966051 -96.780099 0.017716 -127.899108 \n",
"15 327.901325 73.374434 -327.463213 -76.184203 0.438112 -2.809769 \n",
"16 322.098675 37.491892 -321.691531 -40.645937 0.407143 -3.154045 \n",
"17 317.183525 -6.032722 -316.304437 -1.804560 0.879088 -7.837281 \n",
"18 50.314329 -40.677543 -50.261421 3.664547 0.052908 -37.012996 \n",
"19 -269.738579 -156.664547 270.563198 147.333083 0.824619 -9.331464 \n",
"20 224.017064 -42.539912 -223.679337 32.503042 0.337728 -10.036870 \n",
"21 -451.298541 -54.203176 454.376895 58.754526 3.078355 4.551350 \n",
"22 -329.601665 14.440022 330.422772 -27.742741 0.821106 -13.302719 \n",
"23 -42.680056 -97.330017 42.709890 90.628717 0.029835 -6.701300 \n",
"24 199.038791 11.052428 -198.777386 -22.062587 0.261405 -11.010159 \n",
"25 24.640546 -43.555470 -24.624725 9.229304 0.015821 -34.326166 \n",
"26 -604.422772 -87.257259 607.205906 108.151323 2.783135 20.894064 \n",
"27 42.794094 41.884254 -42.769382 -61.749908 0.024711 -19.865654 \n",
"28 353.838954 -0.500605 -351.309890 1.571283 2.529064 1.070677 \n",
"29 -558.569572 -22.349487 560.000000 100.164792 1.430428 77.815305 \n",
"30 65.413892 -18.810932 -65.288100 -39.035004 0.125792 -57.845936 \n",
"31 257.295728 68.205232 -256.375275 -84.729304 0.920453 -16.524072 \n",
"32 -140.819246 -21.209607 141.607705 -56.356758 0.788459 -77.566365 \n",
"33 -190.188382 -24.960621 192.102205 -67.791212 1.913823 -92.751833 \n",
"34 -347.607705 28.756758 349.163889 -39.437225 1.556184 -10.680467 \n",
"\n",
" i_from_ka i_to_ka i_ka vm_from_pu va_from_degree vm_to_pu \\\n",
"0 0.287100 0.281497 0.287100 1.039384 -13.536602 1.048494 \n",
"1 0.122686 0.173239 0.173239 1.039384 -13.536602 1.030000 \n",
"2 0.529823 0.542565 0.542565 1.048494 -9.785267 1.030708 \n",
"3 0.412240 0.420913 0.420913 1.048494 -9.785267 1.057683 \n",
"4 0.193326 0.229401 0.229401 1.030708 -12.276384 1.004460 \n",
"5 0.070288 0.067393 0.070288 1.030708 -12.276384 1.031573 \n",
"6 0.329031 0.329055 0.329055 1.004460 -12.626734 1.006006 \n",
"7 0.449173 0.445285 0.449173 1.004460 -12.626734 1.012319 \n",
"8 0.896062 0.895456 0.896062 1.006006 -11.192339 1.008226 \n",
"9 0.569756 0.573267 0.573267 1.006006 -11.192339 0.997872 \n",
"10 0.765320 0.768522 0.768522 1.008226 -10.408330 0.998397 \n",
"11 0.539419 0.536815 0.539419 1.008226 -10.408330 1.013386 \n",
"12 0.367084 0.366630 0.367084 0.998397 -12.755626 0.997872 \n",
"13 0.229031 0.167012 0.229031 0.997872 -13.335844 1.038332 \n",
"14 0.067451 0.163676 0.163676 1.038332 -14.178442 1.030000 \n",
"15 0.552449 0.555206 0.555206 1.017843 -8.170875 1.013386 \n",
"16 0.533152 0.534646 0.534646 1.017843 -8.170875 1.014923 \n",
"17 0.523090 0.522896 0.523090 1.014923 -8.929927 1.012319 \n",
"18 0.106958 0.082991 0.106958 1.012319 -10.715295 1.016185 \n",
"19 0.513700 0.499322 0.513700 1.016185 -11.345399 1.032520 \n",
"20 0.369569 0.365733 0.369569 1.032520 -10.033348 1.034237 \n",
"21 0.736708 0.730136 0.736708 1.032520 -10.033348 1.050107 \n",
"22 0.534721 0.537529 0.537529 1.032520 -10.033348 1.032319 \n",
"23 0.172250 0.161525 0.172250 1.032520 -10.033348 1.038001 \n",
"24 0.322557 0.324449 0.324449 1.034237 -11.116436 1.031573 \n",
"25 0.080973 0.042383 0.080973 1.034237 -11.116436 1.038345 \n",
"26 0.989979 0.982856 0.989979 1.032319 -7.628746 1.050143 \n",
"27 0.095423 0.120274 0.120274 1.050143 -3.183120 1.045145 \n",
"28 0.566565 0.566392 0.566565 1.045145 -3.381276 1.038001 \n",
"29 0.895093 0.895093 0.895093 1.045145 -3.381276 1.063600 \n",
"30 0.107693 0.120941 0.120941 1.057683 -8.369235 1.052561 \n",
"31 0.423206 0.435175 0.435175 1.052561 -9.438770 1.038345 \n",
"32 0.226415 0.242823 0.242823 1.052561 -9.438770 1.050374 \n",
"33 0.304976 0.324640 0.324640 1.052561 -9.438770 1.050115 \n",
"34 0.555708 0.559971 0.559971 1.050374 -5.928359 1.050115 \n",
"\n",
" va_to_degree loading_percent \n",
"0 -9.785267 28.593122 \n",
"1 -14.535256 10.352039 \n",
"2 -12.276384 64.842795 \n",
"3 -8.369235 50.303984 \n",
"4 -12.626734 27.416027 \n",
"5 -11.986168 8.400275 \n",
"6 -11.192339 32.771568 \n",
"7 -10.715295 53.681345 \n",
"8 -10.408330 44.620712 \n",
"9 -13.335844 38.062198 \n",
"10 -12.755626 51.026225 \n",
"11 -8.936966 67.152867 \n",
"12 -13.335844 24.372655 \n",
"13 -14.178442 15.206581 \n",
"14 -14.535256 10.867282 \n",
"15 -8.936966 55.294597 \n",
"16 -8.929927 53.246929 \n",
"17 -10.715295 52.096054 \n",
"18 -11.345399 10.652243 \n",
"19 -10.033348 51.160905 \n",
"20 -11.116436 36.806440 \n",
"21 -5.410073 73.370945 \n",
"22 -7.628746 53.534054 \n",
"23 -9.913759 17.154888 \n",
"24 -11.986168 32.312804 \n",
"25 -11.362152 8.064296 \n",
"26 -3.183120 65.729964 \n",
"27 -3.381276 11.978409 \n",
"28 -9.913759 56.425868 \n",
"29 4.468437 59.429976 \n",
"30 -9.438770 12.044828 \n",
"31 -11.362152 43.340381 \n",
"32 -5.928359 24.183467 \n",
"33 -3.169874 32.331827 \n",
"34 -3.169874 55.769135 "
]
},
"execution_count": 52,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"net.res_line"
]
},
{
"cell_type": "code",
"execution_count": 29,
"id": "ef3d07a3-8e22-44d8-8501-e8141f31372e",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"(-3.7130555077438796-24.557043641695156j)"
]
},
"execution_count": 29,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"import math\n",
"(2.0570568805614-23.80637508316387j)*(1.039384*np.exp(math.radians(-13.536602)*1j))"
]
},
{
"cell_type": "code",
"execution_count": 27,
"id": "3f976ff7-cef1-4094-a18a-fbc086ab5482",
"metadata": {},
"outputs": [],
"source": [
"import numpy as np"
]
},
{
"cell_type": "code",
"execution_count": 38,
"id": "c79a0331-fa2e-4e07-a776-96630cd38107",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"(100.09056243698481-24.097254187187946j)"
]
},
"execution_count": 38,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"0.287100*1.039384*np.exp(math.radians(-13.536602)*1j)*345"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "f5e98ecc-fcb2-4f92-bf9a-98001f802dbd",
"metadata": {},
"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.12.2"
}
},
"nbformat": 4,
"nbformat_minor": 5
}