Revision history [back]
 | 1 | initial version |
Reading PSSE output files (*.dat) and saving in a useful format (CSV)
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
PTI 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
| | 2 | No.2 Revision |
Reading PSSE output files (*.dat) and saving in a useful format (CSV)
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
PTI INTERACTIVE POWER SYSTEM SIMULATOR--PSS(R)E file
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(Attached)
| | 3 | No.3 Revision |
Reading PSSE output files (*.dat) and saving in a useful format (CSV)
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 (Attached)
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
| | 4 | No.4 Revision |
Reading PSSE output files (*.dat) and saving in a useful format (CSV)
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 (Attached)
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
MW-SENS
10000 LA 275.00 0.1041
0.1041
20000 NY 275.00 -0.7613
-0.7613
30000 WDC 275.00 -0.2254
-0.2254
40000 SF 275.00 -0.2254
-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
MW-SENS
20000 NY 275.00 0.7613
0.7613
30000 WDC 275.00 0.2254
40000 SF 275.00 0.2254
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
0.3254
40000 SF 275.00 0.1540
0.1540
50000 AZ 275.00 0.3244
| | 5 | No.5 Revision |
Reading PSSE output files (*.dat) and saving in a useful format (CSV)
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 (Attached)
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
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
| | 6 | No.6 Revision |
Reading PSSE output files (*.dat) and saving in a useful format (CSV)
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
