Hi I need some guidance/help on Python – Esp reading a text data file and re-arranging the information in a tabular form (probably in an Excel/CSV file) Please refer to the output of the ”Report.dat” file given below

For each branch, there is a sensitivity list for buses ( the number of buses are not fixed for all contingencies)

I would like to get these information in the following format. Bus, Branch, Sensitivity

Appreciate your help to get this done in a Pythonic way

Ta

Output of the Report.Dat file

TI INTERACTIVE POWER SYSTEM SIMULATOR--PSS(R)E     WED, DEC 29 1814  14:57
SENSITIVITY FACTORS ARE CALCULATED WITH DC NETWORK
SYSTEM SWING BUS(es) IS USED FOR OPPOSING SYSTEM FOR MW POWER DISPATCH

SENSITIVITY FACTORS OF BRANCH FLOW (MW) ON  10000 LA    275.00 TO  20000 NY    275.00 1  GREATER THAN  0.10000

<------- BUS NAME ------>   MW-SENS

 10000 LA    275.00    0.1041

 20000 NY    275.00   -0.7613

 30000 WDC   275.00   -0.2254

 40000 SF    275.00   -0.2254

 50000 AZ    275.00   -0.2144



SENSITIVITY FACTORS OF BRANCH FLOW (MW) ON  40000 SF    275.00 TO  50000 AZ    275.00 1  GREATER THAN  0.10000

<------- BUS NAME ------>   MW-SENS

 20000 NY    275.00    0.7613

 30000 WDC   275.00    0.2254

 40000 SF    275.00    0.2254

 50000 AZ    275.00    0.2144



SENSITIVITY FACTORS OF BRANCH FLOW (MW) ON  40000 SF    275.00 TO  60000 PD    275.00 1  GREATER THAN  0.10000

------- BUS NAME ------>   MW-SENS

 10000 LA    275.00    0.1613

 30000 WDC   275.00    0.3254

 40000 SF    275.00    0.1540

 50000 AZ    275.00    0.3244

Hi Would you please help me with a python code for unzipping a file *.zip and then save the contents of the file to a directory

Thanks

Hi

I wish to read Machine info from a psse case Bus No, Bus Name, Machine Id

Then automatically write a *.con file for all generator contingencies

CONTINGENCY "Bus Name" REMOVE MACHINE "Machine Id" FROM BUS "BUS NUMBER" ... This is repeated for all generators

Really appreciate if you wish to suggest a python code for doing this

Thanking you

Don

Hi

I am wondering whether you have or come across a simple python code to do something like this:

To find out number of capacitor banks (of X MVAr) available at a Substation (Given a PSSE Case) Ans: 1 or 2 or 3 or etc

Eg 1: Number of 50 MVAr (Say) Capacitor Banks at JERVIS WHITLY Substation

EG 2: Number of gen units on line at a Substation

Ta DON

I have been playing with the csv.reader module in reading a column in the following format.

[‘filename1’,
 ‘filename2’,
 ……….. 
]

However, I end up with getting an extra-bracket which I don’t want

[ ( ‘filename1’,
    ‘filename2’, 
   ………….)
]

Just wondering whether you want to suggest me a pythonic way of getting rid of the “ ( “ and “ )”