In [1]:
import dependencies
from IPython.display import display, HTML
from scripts import capacitor_bank_analysis as cba
from nummath import graphing

BEREKENING VAN DE CONDENSATORSTROMEN I.F.V. DE GEMETEN MOMENTANE BELASTING EN ANALYSE VAN STROOMOVERSCHRIJDINGEN

In [2]:
all_results = cba.analyze()
In [3]:
all_results
Out[3]:
time combination stage Irms
0 2013-12-14 11:05:00 comb3 I1 18.617042
1 2013-12-14 11:05:00 comb3 I3 37.456828
2 2013-12-14 11:08:00 comb3 I1 17.629368
3 2013-12-14 11:08:00 comb3 I3 35.460620
4 2013-12-14 11:10:00 comb3 I1 16.533581
... ... ... ... ...
1417 2013-12-21 10:48:00 comb3 I3 45.222303
1418 2013-12-21 10:50:00 comb3 I1 21.387132
1419 2013-12-21 10:50:00 comb3 I3 43.053773
1420 2013-12-21 10:52:00 comb3 I1 17.038537
1421 2013-12-21 10:52:00 comb3 I3 34.266882

1422 rows × 4 columns

In [4]:
comb_results = [all_results[all_results['combination'] == comb] 
                for comb in ['comb1', 'comb2', 'comb3', 'comb4', 'comb5', 'comb6']
               ]
for cr in comb_results:
    if not cr.empty:
        print(cr)
                    time combination stage       Irms
0    2013-12-14 11:05:00       comb3    I1  18.617042
1    2013-12-14 11:05:00       comb3    I3  37.456828
2    2013-12-14 11:08:00       comb3    I1  17.629368
3    2013-12-14 11:08:00       comb3    I3  35.460620
4    2013-12-14 11:10:00       comb3    I1  16.533581
...                  ...         ...   ...        ...
1417 2013-12-21 10:48:00       comb3    I3  45.222303
1418 2013-12-21 10:50:00       comb3    I1  21.387132
1419 2013-12-21 10:50:00       comb3    I3  43.053773
1420 2013-12-21 10:52:00       comb3    I1  17.038537
1421 2013-12-21 10:52:00       comb3    I3  34.266882

[1395 rows x 4 columns]
                    time combination stage       Irms
722  2013-12-18 14:33:00       comb4    I1  15.951753
723  2013-12-18 14:33:00       comb4    I2  15.951753
724  2013-12-18 14:33:00       comb4    I3  32.021931
765  2013-12-18 15:47:00       comb4    I1  16.528986
766  2013-12-18 15:47:00       comb4    I2  16.528986
767  2013-12-18 15:47:00       comb4    I3  33.186424
770  2013-12-18 15:49:00       comb4    I1  16.870047
771  2013-12-18 15:49:00       comb4    I2  16.870047
772  2013-12-18 15:49:00       comb4    I3  33.873856
805  2013-12-18 16:42:00       comb4    I1  16.738414
806  2013-12-18 16:42:00       comb4    I2  16.738414
807  2013-12-18 16:42:00       comb4    I3  33.608294
810  2013-12-18 16:44:00       comb4    I1  17.665615
811  2013-12-18 16:44:00       comb4    I2  17.665615
812  2013-12-18 16:44:00       comb4    I3  35.477345
815  2013-12-18 16:47:00       comb4    I1  16.105757
816  2013-12-18 16:47:00       comb4    I2  16.105757
817  2013-12-18 16:47:00       comb4    I3  32.332907
1055 2013-12-19 17:50:00       comb4    I1  16.037439
1056 2013-12-19 17:50:00       comb4    I2  16.037439
1057 2013-12-19 17:50:00       comb4    I3  32.195493
1184 2013-12-20 12:33:00       comb4    I1  16.143317
1185 2013-12-20 12:33:00       comb4    I2  16.143317
1186 2013-12-20 12:33:00       comb4    I3  32.408390
1189 2013-12-20 12:35:00       comb4    I1  19.066534
1190 2013-12-20 12:35:00       comb4    I2  19.066534
1191 2013-12-20 12:35:00       comb4    I3  38.300634
In [5]:
num_results = [len(comb_results[i].index) for i in range(len(comb_results))]

output = f"<ul>"
for i, num in enumerate(num_results):
    output += f"<li>Aantal overschrijdingen met schakelcombinatie nr. {i + 1} = <b>{num}</b></li>"
output += f"</ul>"
display(HTML(output))
  • Aantal overschrijdingen met schakelcombinatie nr. 1 = 0
  • Aantal overschrijdingen met schakelcombinatie nr. 2 = 0
  • Aantal overschrijdingen met schakelcombinatie nr. 3 = 1395
  • Aantal overschrijdingen met schakelcombinatie nr. 4 = 27
  • Aantal overschrijdingen met schakelcombinatie nr. 5 = 0
  • Aantal overschrijdingen met schakelcombinatie nr. 6 = 0
In [6]:
datasets = []
dataset = {
    'name': 'comb3-st1',
    'x': comb_results[2][comb_results[2]['stage'] == 'I1']['time'],
    'y': comb_results[2][comb_results[2]['stage'] == 'I1']['Irms']
}
datasets.append(dataset)
In [7]:
dataset = {
    'name': 'comb3-st3',
    'x': comb_results[2][comb_results[2]['stage'] == 'I3']['time'],
    'y': comb_results[2][comb_results[2]['stage'] == 'I3']['Irms']
}
datasets.append(dataset)
In [8]:
dataset = {
    'name': 'comb4-st1',
    'x': comb_results[3][comb_results[3]['stage'] == 'I1']['time'],
    'y': comb_results[3][comb_results[3]['stage'] == 'I1']['Irms']
}
datasets.append(dataset)
In [9]:
dataset = {
    'name': 'comb4-st2',
    'x': comb_results[3][comb_results[3]['stage'] == 'I2']['time'],
    'y': comb_results[3][comb_results[3]['stage'] == 'I2']['Irms']
}
datasets.append(dataset)
In [10]:
dataset = {
    'name': 'comb4-st3',
    'x': comb_results[3][comb_results[3]['stage'] == 'I3']['time'],
    'y': comb_results[3][comb_results[3]['stage'] == 'I3']['Irms']
}
datasets.append(dataset)
In [14]:
from pandas.plotting import register_matplotlib_converters
register_matplotlib_converters()
    
graph = graphing.Graph(fig_size=[12, 8], dpi=96)
for dataset in datasets:
    graph.add_data_set(name=dataset['name'], x=dataset['x'], y=dataset['y'], marker='o', linestyle='none')
graph.setup_time_axis(date_min=all_results['time'].iloc[0], date_max=all_results['time'].iloc[-1])
graph.add_legend()
graph.set_axis_titles(x_title='time', y_title='Irms [A]')
graph.turn_grid_on()
graph.draw_graph()
graph.show_graph()
In [ ]: