def test_excel(): net_in = create_test_network() net_in.line_geodata.loc[0, "coords"] = [(1.1, 2.2), (3.3, 4.4)] net_in.line_geodata.loc[1, "coords"] = [(5.5, 5.5), (6.6, 6.6), (7.7, 7.7)] pp.to_excel(net_in, "testfile.xlsx") net_out = pp.from_excel("testfile.xlsx") assert_net_equal(net_in, net_out) os.remove('testfile.xlsx')
def mainSaveClicked(self): #filename = QFileDialog.getOpenFileName() filename = QFileDialog.getSaveFileName(self, 'Save net') print(filename[0]) try: pp.to_excel(self.net, filename[0]) self.mainPrintMessage("Saved case to: " + filename[0]) except: self.mainPrintMessage("Case not saved, maybe empty?")
def test_excel(net_in, tempdir): filename = os.path.join(tempdir, "testfile.xlsx") pp.to_excel(net_in, filename) net_out = pp.from_excel(filename) assert_net_equal(net_in, net_out) pp.set_user_pf_options(net_in, tolerance_kva=1e3) pp.to_excel(net_in, filename) net_out = pp.from_excel(filename) assert_net_equal(net_in, net_out) assert net_out.user_pf_options == net_in.user_pf_options
def test_excel(net_in, tmp_path): filename = os.path.abspath(str(tmp_path)) + "testfile.xlsx" pp.to_excel(net_in, filename) net_out = pp.from_excel(filename) assert_net_equal(net_in, net_out) # test in user_pf_options are equal pp.set_user_pf_options(net_in, tolerance_mva=1e3) pp.to_excel(net_in, filename) net_out = pp.from_excel(filename) assert_net_equal(net_in, net_out) assert net_out.user_pf_options == net_in.user_pf_options
def test_excel(net_in, tempdir): filename = os.path.join(tempdir, "testfile.xlsx") pp.to_excel(net_in, filename) net_out = pp.from_excel(filename) assert_net_equal(net_in, net_out)
lc = pplotly.create_line_trace(net,lines=None, color="blue", # infofunc= net.line.name.astype(str) + '<br>' # + '110.0 kV') tc = pplotly.create_trafo_trace(net,net.trafo.index,width=5,color="pink") pplotly.draw_traces(bc + lc + tc, on_map = True, map_style='dark', showlegend=True, aspectratio='auto') #pf_res_plotly(net, on_map=True) pp.to_excel(net, filename="Aachen Net.xlsx", include_results=True) end = time.time() elapsed_time = end - start print('Elapsed time: ' + str(elapsed_time) + ' seconds.')
import pandapower.networks as pn import numpy as np import pandapower.plotting as plot import matplotlib.pyplot as plt from pandapower.plotting.plotly import vlevel_plotly import pandas as pd net = pn.create_cigre_network_lv() net plot.simple_plot(net, show_plot=True) vlevel_plotly(net) #del net.bus_geodata pp.convert_format(net) pp.to_excel(net, "examplecigrelow.xlsx") netcoords = net.bus_geodata netcoords.to_excel('cigrecoords.xlsx') netlv = pp.from_excel("final code/examplecigrelow.xlsx") #lv.bus_geodata #del netlv.bus_geodata netlv plot.simple_plot(netlv, show_plot=True) vlevel_plotly(netlv) #vlevel_plotly(net) netlv net netlv.bus_geodata
pp.create_sgen(net, bus=Zone5Bus, p_mw=Zone5Gen, q_mvar=Zone5Gen * P2Q, name="Zone 5 Gen") pp.create_sgen(net, bus=Zone6Bus, p_mw=Zone6Gen, q_mvar=Zone6Gen * P2Q, name="Zone 6 Gen") pp.create_sgen(net, bus=Zone7Bus, p_mw=Zone7Gen, q_mvar=Zone7Gen * P2Q, name="Zone 7 Gen") pp.create_sgen(net, bus=Zone8Bus, p_mw=Zone8Gen, q_mvar=Zone1Gen * P2Q, name="Zone 8 Gen") pp.runpp(net) pp.to_excel(net, 'This 7thFeb2050_Government_' + str(n) + 'planned_lines.xlsx') # In[25]: print(net.res_line) # In[ ]:
#creating External Grid (Slack Bus) pp.create_ext_grid(net, 0, vm_pu = 1) ############################################## #Creating Grid connections for i in grid.index: pp.create_line(net, from_bus=grid.at[i,"id1"], to_bus=grid.at[i,"id2"], length_km=1, std_type="NAYY 4x50 SE") ############################################## #Creating Transformer #pp.create_transformer_from_parameters(net, hv_bus=0, lv_bus=grid.at[0, "id1"], i0_percent=0.038, pfe_kw=11.6, vkr_percent=0.322, sn_mva=40, vn_lv_kv=20.0, vn_hv_kv=110.0, vk_percent=17.8) pp.create_transformer(net, hv_bus=0, lv_bus=grid.at[0, "id1"], std_type="25 MVA 110/20 kV") ############################################## #Creating Load for i in SS.index: pp.create_load(net, SS.at[i,'id'], p_mw=0.1) pp.runpp(net) print(net.res_bus) #pp.plotting.plotly.geo_data_to_latlong(net, projection='epsg:5858') pp.plotting.plotly.mapbox_plot.set_mapbox_token('pk.eyJ1IjoibmExMjAzMTMyIiwiYSI6ImNrYW9qYThxMzFvb3cyc3A2cWJyaHdhdTMifQ.bfRDDy-DV4-VuVWjDNzodg') simple_plotly(net) pp.plotting.plot_voltage_profile(net) plt.show() pp.to_excel(net, "example2.xlsx")
pp.create_sgen(net, bus=Zone5Bus, p_mw=Zone5Gen, q_mvar=Zone5Gen * P2Q, name="Zone 5 Gen") pp.create_sgen(net, bus=Zone6Bus, p_mw=Zone6Gen, q_mvar=Zone6Gen * P2Q, name="Zone 6 Gen") pp.create_sgen(net, bus=Zone7Bus, p_mw=Zone7Gen, q_mvar=Zone7Gen * P2Q, name="Zone 7 Gen") pp.create_sgen(net, bus=Zone8Bus, p_mw=Zone8Gen, q_mvar=Zone1Gen * P2Q, name="Zone 8 Gen") pp.runpp(net) pp.to_excel(net, '7thFeb2050_Government_' + str(n) + 'nextlevel_lines.xlsx') # In[25]: print(net.res_line) # In[ ]: