psse network data to excel use python
How to program python code let psse network data to csv file & csv data to psse network data ? please give me some example thank very much !
I use psse ver33 & python 2.7
First time here? We are a friendly community of Power Systems Engineers. Check out the FAQ!
How to program python code let psse network data to csv file & csv data to psse network data ? please give me some example thank very much !
I use psse ver33 & python 2.7
There are many API's that let you extract the information of the base case and save them into variables. You can then use the Python native way of creating a *.txt or *.csv file and output the information.
For example, a code that will export all the buses number and name of a certain subsystem to an csv file:
# Import library to manage *.csv files
import csv
# Get the name and path of the base case file
savname, snp = psspy.sfiles()
path = os.path.dirname(savname)
# Create the subsystem you want to work with
psspy.bsys(0, 1, [ 0.0, 500.0], 1, [20], 0, [], 0, [], 0, [])
# Obtain all of subsystem's buses numbers and names
busData_1 = psspy.abusint(0, 2, ["NUMBER"])[1][0]
busData_2 = psspy.abuschar(0, 2, ["NAME"])[1][0]
# Create *.csv file
csv_File = open(path + r"\buses.csv", 'w')
# Write buses number and name
for i, bus in enumerate(busData_1):
csv_File.write("%i, %s\n" %(bus, busData_2[i]))
# File is saved and closed
csv_File.close()
You can check the PSSE documentation for information on all the API's that you can use. A good tool you can use is the recording python tool inside PSSE. You can do a recording to see which API's are used when you modify the parameter of an element, and then modify it yourself through Python.
Asked: 2018-01-22 09:51:39 -0500
Seen: 1,182 times
Last updated: Jan 23 '18
Base Python code for a DC load flow interconnection prospecting study in PSS/e
How to calculate data in PSS/E and export it to Excel?
Capture keyboard interrupt in PSS/E script?
CMLDxxU2 and CMLDxxDGU2 modeling
Data Retrieval aBusTypes, aMachType
Open PSS/E GUI and SAV file from Powershell/cmd?
Return Branch data element in Actual value
Mvar Annotation on diagram view
ValueError: operands could not be broadcast together with shapes (336000) (168000)