data_excel

In [1]:
import numpy as np
import matplotlib.pyplot as plt
import pandas as pd
In [2]:
%matplotlib widget

Načtení dat z excelu pomocí pandas

In [3]:
df = pd.read_excel('TR01_03.xlsx', skiprows=10, usecols='B:G')
df
Out[3]:
čas Fv T1 T2 st pr
0 0.00000 -0.02452 0.40000 0.12500 -0.00011 0.00023
1 0.10000 -0.01328 0.41250 0.14583 -0.00016 0.00013
2 0.20000 -0.01124 0.42083 0.18750 -0.00016 0.00036
3 0.30000 -0.01124 0.40417 0.17083 -0.00016 -0.00003
4 0.40000 0.00102 0.43333 0.09583 -0.00015 0.00026
... ... ... ... ... ... ...
4332 433.20002 0.71736 34951.55182 -10529.50888 -5.52251 -70.64916
4333 433.30002 0.72553 34951.55182 -10528.87138 -5.51328 -70.63858
4334 433.40002 0.72962 34951.55182 -10528.28388 -5.50396 -70.63073
4335 433.50002 0.73779 34951.55182 -10527.65472 -5.49448 -70.62110
4336 433.60002 0.74290 34951.55182 -10527.08805 -5.48511 -70.60853

4337 rows × 6 columns

In [4]:
fig, ax = plt.subplots()

force = -df['Fv']
ax.plot(-df['pr'], force)
ax.plot(-df['st'], force, label='st')

force_max_idx = np.argmax(force)
force_max = force.iloc[force_max_idx]
pr_force_max = -df['pr'].iloc[force_max_idx]
ax.plot(pr_force_max, force_max, 'ro')
ax.annotate(f'[{pr_force_max:.3f}, {force_max:.3f}]', (pr_force_max + 1, force_max + 10), color='red')
    
ax.set_xlabel('průhyb')
ax.set_ylabel('síla');

Canvas(toolbar=Toolbar(toolitems=[('Home', 'Reset original view', 'home', 'home'), ('Back', 'Back to previous …
In [5]:
fig, ax = plt.subplots()

ax.plot(df['T1'], -df['Fv'], label='T1')
ax.plot(df['T2'], -df['Fv'], label='T2')
    
ax.set_xlabel('přetvoření')
ax.set_ylabel('síla')
ax.legend(loc='best');

Canvas(toolbar=Toolbar(toolitems=[('Home', 'Reset original view', 'home', 'home'), ('Back', 'Back to previous …
In [ ]: