32 KiB
Executable File
32 KiB
Executable File
In [1]:
# Import
import pandas as pd
import numpy as np
import plotly.express as px
import plotly.graph_objects as go
from scipy import statsIn [29]:
Nf = 100
p1 = pd.DataFrame({
'L2 (initial)': [0, 0, 0, 0, 0, ],
'L2 (final)': [27.5, 28.5, 27, 25.5, 26.6],
'dL2': [0.5]*5,
'ΔL2 100': [np.nan] * 5,
'λ0': [np.nan] * 5,
'dλ0': [np.nan] * 5,
})
p1['ΔL2 100'] = p1['L2 (final)'] - p1['L2 (initial)']
p1['λ0'] = 2 * p1['ΔL2 100'] / Nf
p1['dλ0'] = p1['λ0'] * (p1['dL2']/p1['ΔL2 100'])
p1Out [29]:
| L2 (initial) | L2 (final) | dL2 | ΔL2 100 | λ0 | dλ0 | |
|---|---|---|---|---|---|---|
| 0 | 0 | 27.5 | 0.5 | 27.5 | 0.550 | 0.01 |
| 1 | 0 | 28.5 | 0.5 | 28.5 | 0.570 | 0.01 |
| 2 | 0 | 27.0 | 0.5 | 27.0 | 0.540 | 0.01 |
| 3 | 0 | 25.5 | 0.5 | 25.5 | 0.510 | 0.01 |
| 4 | 0 | 26.6 | 0.5 | 26.6 | 0.532 | 0.01 |
In [ ]:
print(f'p1["λ0"].mean() np.sqrt(1/5 * sum((p1["λ0"] - p1["λ0"].mean())**2))')np.float64(0.019815145722401322)
In [45]:
# Create DataFrame structure matching your table
# Structure: Nf values (5, 10, 15, 20, 25) with 4 measurements each
# Initialize the data structure
data = []
nf_values = [5, 10, 15, 20, 24]
for nf in nf_values:
for measurement in range(1, 5): # measurements 1-4
data.append({
'Nf': nf,
'#': measurement,
'Pinitial': np.nan, # To be filled with your measurements
'Pfinal': np.nan, # To be filled with your measurements
'Δp(Nf)': np.nan # Will be calculated as Pfinal - Pinitial
})
# Create the DataFrame
interferometry_df = pd.DataFrame(data)
# Set up MultiIndex to match your table structure
interferometry_df = interferometry_df.set_index(['Nf', '#'])
print("Interferometry DataFrame structure:")
print(interferometry_df)
print(f"\nShape: {interferometry_df.shape}")
print(f"Index levels: {interferometry_df.index.names}")Interferometry DataFrame structure:
Pinitial Pfinal Δp(Nf)
Nf #
5 1 NaN NaN NaN
2 NaN NaN NaN
3 NaN NaN NaN
4 NaN NaN NaN
10 1 NaN NaN NaN
2 NaN NaN NaN
3 NaN NaN NaN
4 NaN NaN NaN
15 1 NaN NaN NaN
2 NaN NaN NaN
3 NaN NaN NaN
4 NaN NaN NaN
20 1 NaN NaN NaN
2 NaN NaN NaN
3 NaN NaN NaN
4 NaN NaN NaN
24 1 NaN NaN NaN
2 NaN NaN NaN
3 NaN NaN NaN
4 NaN NaN NaN
Shape: (20, 3)
Index levels: ['Nf', '#']
In [ ]:
# Example: Fill in some sample data to show how to use the structure
# You can replace these with your actual measurements
# Sample data for demonstration
p2 = {
# For Nf = 5
(5, 1): {'Pinitial': 156, 'Pfinal': 332},
(5, 2): {'Pinitial': 147, 'Pfinal': 316},
(5, 3): {'Pinitial': 153, 'Pfinal': 308},
(5, 4): {'Pinitial': 150, 'Pfinal': 312},
# For Nf = 10
(10, 1): {'Pinitial': 156, 'Pfinal': 484},
(10, 2): {'Pinitial': 147, 'Pfinal': 483},
(10, 3): {'Pinitial': 153, 'Pfinal': 474},
(10, 4): {'Pinitial': 150, 'Pfinal': 485},
# For Nf = 15
(15, 1): {'Pinitial': 156, 'Pfinal': 643},
(15, 2): {'Pinitial': 147, 'Pfinal': 655},
(15, 3): {'Pinitial': 153, 'Pfinal': 634},
(15, 4): {'Pinitial': 150, 'Pfinal': 640},
# For Nf = 20
(20, 1): {'Pinitial': 156, 'Pfinal': 812},
(20, 2): {'Pinitial': 147, 'Pfinal': 809},
(20, 3): {'Pinitial': 153, 'Pfinal': 802},
(20, 4): {'Pinitial': 150, 'Pfinal': 811},
# For Nf = 24
(24, 1): {'Pinitial': 156, 'Pfinal': 946},
(24, 2): {'Pinitial': 147, 'Pfinal': 946},
(24, 3): {'Pinitial': 153, 'Pfinal': 936},
(24, 4): {'Pinitial': 150, 'Pfinal': 939},
}
# Fill in the sample data
for (nf, measurement), values in p2.items():
interferometry_df.loc[(nf, measurement), 'Pinitial'] = values['Pinitial']
interferometry_df.loc[(nf, measurement), 'Pfinal'] = values['Pfinal']
# Calculate Δp(Nf)
interferometry_df.loc[(nf, measurement), 'Δp(Nf)'] = values['Pfinal'] - values['Pinitial']
interferometry_df| Pinitial | Pfinal | Δp(Nf) | ||
|---|---|---|---|---|
| Nf | # | |||
| 5 | 1 | 156.0 | 332.0 | 176.0 |
| 2 | 147.0 | 316.0 | 169.0 | |
| 3 | 153.0 | 308.0 | 155.0 | |
| 4 | 150.0 | 312.0 | 162.0 | |
| 10 | 1 | 156.0 | 484.0 | 328.0 |
| 2 | 147.0 | 483.0 | 336.0 | |
| 3 | 153.0 | 474.0 | 321.0 | |
| 4 | 150.0 | 485.0 | 335.0 | |
| 15 | 1 | 156.0 | 643.0 | 487.0 |
| 2 | 147.0 | 655.0 | 508.0 | |
| 3 | 153.0 | 634.0 | 481.0 | |
| 4 | 150.0 | 640.0 | 490.0 | |
| 20 | 1 | 156.0 | 812.0 | 656.0 |
| 2 | 147.0 | 809.0 | 662.0 | |
| 3 | 153.0 | 802.0 | 649.0 | |
| 4 | 150.0 | 811.0 | 661.0 | |
| 24 | 1 | 156.0 | 946.0 | 790.0 |
| 2 | 147.0 | 946.0 | 799.0 | |
| 3 | 153.0 | 936.0 | 783.0 | |
| 4 | 150.0 | 939.0 | 789.0 |
In [50]:
# Calculate averages for each Nf value (like Δp(Nf = 5) =, etc.)
# This matches the right column in your table
def calculate_nf_averages(df):
"""Calculate average Δp for each Nf value"""
averages = {}
for nf in [5, 10, 15, 20, 24]:
try:
nf_data = df.loc[nf]['Δp(Nf)']
# Remove NaN values before calculating mean
valid_data = nf_data.dropna()
if len(valid_data) > 0:
avg = valid_data.mean()
std = valid_data.std()
averages[f'Δp(Nf = {nf})'] = {
'mean': avg,
'std': std,
'count': len(valid_data)
}
else:
averages[f'Δp(Nf = {nf})'] = {
'mean': np.nan,
'std': np.nan,
'count': 0
}
except KeyError:
averages[f'Δp(Nf = {nf})'] = {
'mean': np.nan,
'std': np.nan,
'count': 0
}
return averages
# Calculate averages
averages = calculate_nf_averages(interferometry_df)
print("Average Δp for each Nf:")
for key, value in averages.items():
if not np.isnan(value['mean']):
print(f"{key} = {value['mean']:.6f} ± {0:.6f} (n={value['count']})")
else:
print(f"{key} = No data available")
# You can also create a summary DataFrame
summary_df = pd.DataFrame(averages).T
summary_dfOut [50]:
Average Δp for each Nf: Δp(Nf = 5) = 165.500000 ± 0.000000 (n=4) Δp(Nf = 10) = 330.000000 ± 0.000000 (n=4) Δp(Nf = 15) = 491.500000 ± 0.000000 (n=4) Δp(Nf = 20) = 657.000000 ± 0.000000 (n=4) Δp(Nf = 24) = 790.250000 ± 0.000000 (n=4)
| mean | std | count | |
|---|---|---|---|
| Δp(Nf = 5) | 165.50 | 9.036961 | 4.0 |
| Δp(Nf = 10) | 330.00 | 6.976150 | 4.0 |
| Δp(Nf = 15) | 491.50 | 11.618950 | 4.0 |
| Δp(Nf = 20) | 657.00 | 5.944185 | 4.0 |
| Δp(Nf = 24) | 790.25 | 6.601767 | 4.0 |
In [58]:
print(np.sqrt(1/4 * np.sum((interferometry_df.loc[np.int64(20), :]['Δp(Nf)'] - interferometry_df.loc[np.int64(20), :]['Δp(Nf)'].mean())**2)))5.1478150704935
In [62]:
p_0 = 0.9464
T = 23.8 + 273.15
T_0 = 293.15
L_c = 0.030
p3 = pd.DataFrame({
'Pinitial': [156, 147, 153, 150, 151, 161],
'Pfinal': [946, 946, 936, 939, 942, 946],
'Δp(Nf)': [np.nan]*6,
'Nf': [24]*6,
'Δp1 frange': [np.nan]*6,
})
p3['Δp(Nf)'] = p3['Pfinal'] - p3['Pinitial']
p3['Δp1 frange'] = p3['Δp(Nf)'] / p3['Nf']
p3Out [62]:
| Pinitial | Pfinal | Δp(Nf) | Nf | Δp1 frange | |
|---|---|---|---|---|---|
| 0 | 156 | 946 | 790 | 24 | 32.916667 |
| 1 | 147 | 946 | 799 | 24 | 33.291667 |
| 2 | 153 | 936 | 783 | 24 | 32.625000 |
| 3 | 150 | 939 | 789 | 24 | 32.875000 |
| 4 | 151 | 942 | 791 | 24 | 32.958333 |
| 5 | 161 | 946 | 785 | 24 | 32.708333 |
In [63]:
print(p3['Δp1 frange'].mean(), np.sqrt(1/6 * sum((p3['Δp1 frange'] - p3['Δp1 frange'].mean())**2)))32.895833333333336 0.21211839374029431
In [65]:
print((p1["λ0"].mean()/0.03) * (T/T_0) * (1 / p3['Δp1 frange'].mean()) * (1/1000))0.0005546852585157163
In [66]:
print((p1["λ0"].mean()/0.03) * (T/T_0) * (1 / p3['Δp1 frange'].mean()) * (1/1000) * np.sqrt((0.0198/0.5904)**2 + (0.2121/32.8558)**2))1.8943746499917665e-05
In [ ]: