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 = 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 mainLoadClicked(self):
file_to_open = ""
file_to_open = QFileDialog.getOpenFileName(filter="*.xlsx, *.p")
if file_to_open[0] != "":
fn = file_to_open[0]
if fn.endswith(".xlsx"):
try:
net = pp.from_excel(file_to_open[0], convert=True)
except:
print("couldn't open %s" % fn)
return
elif file_to_open[0].endswith(".p"):
try:
net = pp.from_pickle(file_to_open[0], convert=True)
except:
print("couldn't open %s" % fn)
return
self.load_network(net)
import pandapower as pp
#import pandapower.networks as pn
import numpy as np
import pandapower.plotting as plot
import matplotlib.pyplot as plt
import pandas as pd
from pandapower.plotting.plotly import simple_plotly
from pandapower.estimation import estimate
%%time
#read overall net from excel file
net = pp.from_excel("final code/circuits/net3.xlsx")
#net
#make some network plots
# plot.simple_plot(net, show_plot=True, trafo_size = 1.25, plot_loads = True, plot_sgens = True)
#
# simple_plotly(net,respect_switches=True )
####INDUSTRIAL FEEDER###########
ind_feeder = pp.from_excel("final code/circuits/ind_feeder.xlsx")
#ind_feeder
#make some network plots
# plot.simple_plot(ind_feeder, show_plot=True, trafo_size = 1.5, plot_loads = True, plot_sgens = True)
#simple_plotly(ind_feeder)
####RESIDENTIAL FEEDER###########
res_feeder = pp.from_excel("final code/circuits/res_feeder.xlsx")
#res_feeder
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)
import pandapower as pp
#import pandapower.networks as pn
import pandas as pd
from pandapower.estimation import estimate
%%time
net = pp.from_excel("final code/circuits/net3.xlsx")
net.measurement = pd.read_excel('final code/measurements/net_m.xlsx')
succes = estimate(net, init='flat')
print(succes)
net.res_line_est
net.res_bus_est
net.res_line_est.to_excel('final code/result/line_simp.xlsx')
net.res_bus_est.to_excel('final code/result/bus_simp.xlsx')
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
