Files
2026-10-02 11:10:29 +02:00

32 KiB
Executable File

Interferometry

...

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 stats
In [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'])

p1
Out [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_df
Out [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']


p3
Out [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 [ ]: