{ "cells": [ { "cell_type": "markdown", "id": "66345cd5", "metadata": {}, "source": [ "# Interferometry\n", "..." ] }, { "cell_type": "code", "execution_count": 1, "id": "c9d7bbf4", "metadata": {}, "outputs": [], "source": [ "# Import\n", "import pandas as pd\n", "import numpy as np\n", "import plotly.express as px\n", "import plotly.graph_objects as go\n", "from scipy import stats" ] }, { "cell_type": "code", "execution_count": 29, "id": "006457ea", "metadata": {}, "outputs": [ { "data": { "application/vnd.microsoft.datawrangler.viewer.v0+json": { "columns": [ { "name": "index", "rawType": "int64", "type": "integer" }, { "name": "L2 (initial)", "rawType": "int64", "type": "integer" }, { "name": "L2 (final)", "rawType": "float64", "type": "float" }, { "name": "dL2", "rawType": "float64", "type": "float" }, { "name": "ΔL2 100", "rawType": "float64", "type": "float" }, { "name": "λ0", "rawType": "float64", "type": "float" }, { "name": "dλ0", "rawType": "float64", "type": "float" } ], "ref": "2d8fb0dc-51d8-4133-a088-84b36272266d", "rows": [ [ "0", "0", "27.5", "0.5", "27.5", "0.55", "0.01" ], [ "1", "0", "28.5", "0.5", "28.5", "0.57", "0.009999999999999998" ], [ "2", "0", "27.0", "0.5", "27.0", "0.54", "0.01" ], [ "3", "0", "25.5", "0.5", "25.5", "0.51", "0.01" ], [ "4", "0", "26.6", "0.5", "26.6", "0.532", "0.01" ] ], "shape": { "columns": 6, "rows": 5 } }, "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
L2 (initial)L2 (final)dL2ΔL2 100λ0dλ0
0027.50.527.50.5500.01
1028.50.528.50.5700.01
2027.00.527.00.5400.01
3025.50.525.50.5100.01
4026.60.526.60.5320.01
\n", "
" ], "text/plain": [ " L2 (initial) L2 (final) dL2 ΔL2 100 λ0 dλ0\n", "0 0 27.5 0.5 27.5 0.550 0.01\n", "1 0 28.5 0.5 28.5 0.570 0.01\n", "2 0 27.0 0.5 27.0 0.540 0.01\n", "3 0 25.5 0.5 25.5 0.510 0.01\n", "4 0 26.6 0.5 26.6 0.532 0.01" ] }, "execution_count": 29, "metadata": {}, "output_type": "execute_result" } ], "source": [ "Nf = 100\n", "\n", "p1 = pd.DataFrame({\n", " 'L2 (initial)': [0, 0, 0, 0, 0, ],\n", " 'L2 (final)': [27.5, 28.5, 27, 25.5, 26.6],\n", " 'dL2': [0.5]*5,\n", " 'ΔL2 100': [np.nan] * 5,\n", " 'λ0': [np.nan] * 5,\n", " 'dλ0': [np.nan] * 5,\n", "})\n", "\n", "p1['ΔL2 100'] = p1['L2 (final)'] - p1['L2 (initial)']\n", "p1['λ0'] = 2 * p1['ΔL2 100'] / Nf\n", "p1['dλ0'] = p1['λ0'] * (p1['dL2']/p1['ΔL2 100'])\n", "\n", "p1" ] }, { "cell_type": "code", "execution_count": null, "id": "d56a476d", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "np.float64(0.019815145722401322)" ] }, "execution_count": 43, "metadata": {}, "output_type": "execute_result" } ], "source": [ "print(f'p1[\"λ0\"].mean() np.sqrt(1/5 * sum((p1[\"λ0\"] - p1[\"λ0\"].mean())**2))')" ] }, { "cell_type": "code", "execution_count": 45, "id": "bc50ee92", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Interferometry DataFrame structure:\n", " Pinitial Pfinal Δp(Nf)\n", "Nf # \n", "5 1 NaN NaN NaN\n", " 2 NaN NaN NaN\n", " 3 NaN NaN NaN\n", " 4 NaN NaN NaN\n", "10 1 NaN NaN NaN\n", " 2 NaN NaN NaN\n", " 3 NaN NaN NaN\n", " 4 NaN NaN NaN\n", "15 1 NaN NaN NaN\n", " 2 NaN NaN NaN\n", " 3 NaN NaN NaN\n", " 4 NaN NaN NaN\n", "20 1 NaN NaN NaN\n", " 2 NaN NaN NaN\n", " 3 NaN NaN NaN\n", " 4 NaN NaN NaN\n", "24 1 NaN NaN NaN\n", " 2 NaN NaN NaN\n", " 3 NaN NaN NaN\n", " 4 NaN NaN NaN\n", "\n", "Shape: (20, 3)\n", "Index levels: ['Nf', '#']\n" ] } ], "source": [ "# Create DataFrame structure matching your table\n", "# Structure: Nf values (5, 10, 15, 20, 25) with 4 measurements each\n", "\n", "# Initialize the data structure\n", "data = []\n", "nf_values = [5, 10, 15, 20, 24]\n", "\n", "for nf in nf_values:\n", " for measurement in range(1, 5): # measurements 1-4\n", " data.append({\n", " 'Nf': nf,\n", " '#': measurement,\n", " 'Pinitial': np.nan, # To be filled with your measurements\n", " 'Pfinal': np.nan, # To be filled with your measurements\n", " 'Δp(Nf)': np.nan # Will be calculated as Pfinal - Pinitial\n", " })\n", "\n", "# Create the DataFrame\n", "interferometry_df = pd.DataFrame(data)\n", "\n", "# Set up MultiIndex to match your table structure\n", "interferometry_df = interferometry_df.set_index(['Nf', '#'])\n", "\n", "print(\"Interferometry DataFrame structure:\")\n", "print(interferometry_df)\n", "print(f\"\\nShape: {interferometry_df.shape}\")\n", "print(f\"Index levels: {interferometry_df.index.names}\")" ] }, { "cell_type": "code", "execution_count": null, "id": "70d644b6", "metadata": {}, "outputs": [ { "data": { "application/vnd.microsoft.datawrangler.viewer.v0+json": { "columns": [ { "name": "('Nf', '#')", "rawType": "object", "type": "unknown" }, { "name": "Pinitial", "rawType": "float64", "type": "float" }, { "name": "Pfinal", "rawType": "float64", "type": "float" }, { "name": "Δp(Nf)", "rawType": "float64", "type": "float" } ], "ref": "e725fb5d-3ac1-45ea-90cd-9689bddd360e", "rows": [ [ "(np.int64(5), np.int64(1))", "156.0", "332.0", "176.0" ], [ "(np.int64(5), np.int64(2))", "147.0", "316.0", "169.0" ], [ "(np.int64(5), np.int64(3))", "153.0", "308.0", "155.0" ], [ "(np.int64(5), np.int64(4))", "150.0", "312.0", "162.0" ], [ "(np.int64(10), np.int64(1))", "156.0", "484.0", "328.0" ], [ "(np.int64(10), np.int64(2))", "147.0", "483.0", "336.0" ], [ "(np.int64(10), np.int64(3))", "153.0", "474.0", "321.0" ], [ "(np.int64(10), np.int64(4))", "150.0", "485.0", "335.0" ], [ "(np.int64(15), np.int64(1))", "156.0", "643.0", "487.0" ], [ "(np.int64(15), np.int64(2))", "147.0", "655.0", "508.0" ], [ "(np.int64(15), np.int64(3))", "153.0", "634.0", "481.0" ], [ "(np.int64(15), np.int64(4))", "150.0", "640.0", "490.0" ], [ "(np.int64(20), np.int64(1))", "156.0", "812.0", "656.0" ], [ "(np.int64(20), np.int64(2))", "147.0", "809.0", "662.0" ], [ "(np.int64(20), np.int64(3))", "153.0", "802.0", "649.0" ], [ "(np.int64(20), np.int64(4))", "150.0", "811.0", "661.0" ], [ "(np.int64(24), np.int64(1))", "156.0", "946.0", "790.0" ], [ "(np.int64(24), np.int64(2))", "147.0", "946.0", "799.0" ], [ "(np.int64(24), np.int64(3))", "153.0", "936.0", "783.0" ], [ "(np.int64(24), np.int64(4))", "150.0", "939.0", "789.0" ] ], "shape": { "columns": 3, "rows": 20 } }, "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
PinitialPfinalΔp(Nf)
Nf#
51156.0332.0176.0
2147.0316.0169.0
3153.0308.0155.0
4150.0312.0162.0
101156.0484.0328.0
2147.0483.0336.0
3153.0474.0321.0
4150.0485.0335.0
151156.0643.0487.0
2147.0655.0508.0
3153.0634.0481.0
4150.0640.0490.0
201156.0812.0656.0
2147.0809.0662.0
3153.0802.0649.0
4150.0811.0661.0
241156.0946.0790.0
2147.0946.0799.0
3153.0936.0783.0
4150.0939.0789.0
\n", "
" ], "text/plain": [ " Pinitial Pfinal Δp(Nf)\n", "Nf # \n", "5 1 156.0 332.0 176.0\n", " 2 147.0 316.0 169.0\n", " 3 153.0 308.0 155.0\n", " 4 150.0 312.0 162.0\n", "10 1 156.0 484.0 328.0\n", " 2 147.0 483.0 336.0\n", " 3 153.0 474.0 321.0\n", " 4 150.0 485.0 335.0\n", "15 1 156.0 643.0 487.0\n", " 2 147.0 655.0 508.0\n", " 3 153.0 634.0 481.0\n", " 4 150.0 640.0 490.0\n", "20 1 156.0 812.0 656.0\n", " 2 147.0 809.0 662.0\n", " 3 153.0 802.0 649.0\n", " 4 150.0 811.0 661.0\n", "24 1 156.0 946.0 790.0\n", " 2 147.0 946.0 799.0\n", " 3 153.0 936.0 783.0\n", " 4 150.0 939.0 789.0" ] }, "execution_count": 46, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Example: Fill in some sample data to show how to use the structure\n", "# You can replace these with your actual measurements\n", "\n", "# Sample data for demonstration\n", "p2 = {\n", " # For Nf = 5\n", " (5, 1): {'Pinitial': 156, 'Pfinal': 332},\n", " (5, 2): {'Pinitial': 147, 'Pfinal': 316},\n", " (5, 3): {'Pinitial': 153, 'Pfinal': 308},\n", " (5, 4): {'Pinitial': 150, 'Pfinal': 312},\n", " \n", " # For Nf = 10\n", " (10, 1): {'Pinitial': 156, 'Pfinal': 484},\n", " (10, 2): {'Pinitial': 147, 'Pfinal': 483},\n", " (10, 3): {'Pinitial': 153, 'Pfinal': 474},\n", " (10, 4): {'Pinitial': 150, 'Pfinal': 485},\n", "\n", " # For Nf = 15\n", "\n", " (15, 1): {'Pinitial': 156, 'Pfinal': 643},\n", " (15, 2): {'Pinitial': 147, 'Pfinal': 655},\n", " (15, 3): {'Pinitial': 153, 'Pfinal': 634},\n", " (15, 4): {'Pinitial': 150, 'Pfinal': 640},\n", "\n", " # For Nf = 20\n", " (20, 1): {'Pinitial': 156, 'Pfinal': 812},\n", " (20, 2): {'Pinitial': 147, 'Pfinal': 809}, \n", " (20, 3): {'Pinitial': 153, 'Pfinal': 802},\n", " (20, 4): {'Pinitial': 150, 'Pfinal': 811},\n", "\n", " # For Nf = 24\n", " (24, 1): {'Pinitial': 156, 'Pfinal': 946},\n", " (24, 2): {'Pinitial': 147, 'Pfinal': 946},\n", " (24, 3): {'Pinitial': 153, 'Pfinal': 936},\n", " (24, 4): {'Pinitial': 150, 'Pfinal': 939},\n", "}\n", "\n", "# Fill in the sample data\n", "for (nf, measurement), values in p2.items():\n", " interferometry_df.loc[(nf, measurement), 'Pinitial'] = values['Pinitial']\n", " interferometry_df.loc[(nf, measurement), 'Pfinal'] = values['Pfinal']\n", " # Calculate Δp(Nf)\n", " interferometry_df.loc[(nf, measurement), 'Δp(Nf)'] = values['Pfinal'] - values['Pinitial']\n", "\n", "\n", "interferometry_df" ] }, { "cell_type": "code", "execution_count": 50, "id": "e1514bd6", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Average Δp for each Nf:\n", "Δp(Nf = 5) = 165.500000 ± 0.000000 (n=4)\n", "Δp(Nf = 10) = 330.000000 ± 0.000000 (n=4)\n", "Δp(Nf = 15) = 491.500000 ± 0.000000 (n=4)\n", "Δp(Nf = 20) = 657.000000 ± 0.000000 (n=4)\n", "Δp(Nf = 24) = 790.250000 ± 0.000000 (n=4)\n" ] }, { "data": { "application/vnd.microsoft.datawrangler.viewer.v0+json": { "columns": [ { "name": "index", "rawType": "object", "type": "string" }, { "name": "mean", "rawType": "float64", "type": "float" }, { "name": "std", "rawType": "float64", "type": "float" }, { "name": "count", "rawType": "float64", "type": "float" } ], "ref": "663659f3-66d9-4132-b8e1-6516f79edce0", "rows": [ [ "Δp(Nf = 5)", "165.5", "9.03696114115064", "4.0" ], [ "Δp(Nf = 10)", "330.0", "6.97614984548545", "4.0" ], [ "Δp(Nf = 15)", "491.5", "11.61895003862225", "4.0" ], [ "Δp(Nf = 20)", "657.0", "5.94418483337567", "4.0" ], [ "Δp(Nf = 24)", "790.25", "6.601767440112787", "4.0" ] ], "shape": { "columns": 3, "rows": 5 } }, "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
meanstdcount
Δp(Nf = 5)165.509.0369614.0
Δp(Nf = 10)330.006.9761504.0
Δp(Nf = 15)491.5011.6189504.0
Δp(Nf = 20)657.005.9441854.0
Δp(Nf = 24)790.256.6017674.0
\n", "
" ], "text/plain": [ " mean std count\n", "Δp(Nf = 5) 165.50 9.036961 4.0\n", "Δp(Nf = 10) 330.00 6.976150 4.0\n", "Δp(Nf = 15) 491.50 11.618950 4.0\n", "Δp(Nf = 20) 657.00 5.944185 4.0\n", "Δp(Nf = 24) 790.25 6.601767 4.0" ] }, "execution_count": 50, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Calculate averages for each Nf value (like Δp(Nf = 5) =, etc.)\n", "# This matches the right column in your table\n", "\n", "def calculate_nf_averages(df):\n", " \"\"\"Calculate average Δp for each Nf value\"\"\"\n", " averages = {}\n", "\n", " for nf in [5, 10, 15, 20, 24]:\n", " try:\n", " nf_data = df.loc[nf]['Δp(Nf)']\n", " # Remove NaN values before calculating mean\n", " valid_data = nf_data.dropna()\n", " if len(valid_data) > 0:\n", " avg = valid_data.mean()\n", " std = valid_data.std()\n", " averages[f'Δp(Nf = {nf})'] = {\n", " 'mean': avg,\n", " 'std': std,\n", " 'count': len(valid_data)\n", " }\n", " else:\n", " averages[f'Δp(Nf = {nf})'] = {\n", " 'mean': np.nan,\n", " 'std': np.nan,\n", " 'count': 0\n", " }\n", " except KeyError:\n", " averages[f'Δp(Nf = {nf})'] = {\n", " 'mean': np.nan,\n", " 'std': np.nan,\n", " 'count': 0\n", " }\n", " \n", " return averages\n", "\n", "# Calculate averages\n", "averages = calculate_nf_averages(interferometry_df)\n", "\n", "print(\"Average Δp for each Nf:\")\n", "for key, value in averages.items():\n", " if not np.isnan(value['mean']):\n", " print(f\"{key} = {value['mean']:.6f} ± {0:.6f} (n={value['count']})\")\n", " else:\n", " print(f\"{key} = No data available\")\n", "\n", "# You can also create a summary DataFrame\n", "summary_df = pd.DataFrame(averages).T\n", "\n", "summary_df" ] }, { "cell_type": "code", "execution_count": 58, "id": "893a73f0", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "5.1478150704935\n" ] } ], "source": [ "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)))" ] }, { "cell_type": "code", "execution_count": 62, "id": "785aceac", "metadata": {}, "outputs": [ { "data": { "application/vnd.microsoft.datawrangler.viewer.v0+json": { "columns": [ { "name": "index", "rawType": "int64", "type": "integer" }, { "name": "Pinitial", "rawType": "int64", "type": "integer" }, { "name": "Pfinal", "rawType": "int64", "type": "integer" }, { "name": "Δp(Nf)", "rawType": "int64", "type": "integer" }, { "name": "Nf", "rawType": "int64", "type": "integer" }, { "name": "Δp1 frange", "rawType": "float64", "type": "float" } ], "ref": "aec3bdf2-f345-491b-9333-ee819664748d", "rows": [ [ "0", "156", "946", "790", "24", "32.916666666666664" ], [ "1", "147", "946", "799", "24", "33.291666666666664" ], [ "2", "153", "936", "783", "24", "32.625" ], [ "3", "150", "939", "789", "24", "32.875" ], [ "4", "151", "942", "791", "24", "32.958333333333336" ], [ "5", "161", "946", "785", "24", "32.708333333333336" ] ], "shape": { "columns": 5, "rows": 6 } }, "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
PinitialPfinalΔp(Nf)NfΔp1 frange
01569467902432.916667
11479467992433.291667
21539367832432.625000
31509397892432.875000
41519427912432.958333
51619467852432.708333
\n", "
" ], "text/plain": [ " Pinitial Pfinal Δp(Nf) Nf Δp1 frange\n", "0 156 946 790 24 32.916667\n", "1 147 946 799 24 33.291667\n", "2 153 936 783 24 32.625000\n", "3 150 939 789 24 32.875000\n", "4 151 942 791 24 32.958333\n", "5 161 946 785 24 32.708333" ] }, "execution_count": 62, "metadata": {}, "output_type": "execute_result" } ], "source": [ "p_0 = 0.9464\n", "T = 23.8 + 273.15\n", "T_0 = 293.15\n", "L_c = 0.030\n", "\n", "p3 = pd.DataFrame({\n", " 'Pinitial': [156, 147, 153, 150, 151, 161],\n", " 'Pfinal': [946, 946, 936, 939, 942, 946],\n", " 'Δp(Nf)': [np.nan]*6,\n", " 'Nf': [24]*6,\n", " 'Δp1 frange': [np.nan]*6,\n", "})\n", "\n", "p3['Δp(Nf)'] = p3['Pfinal'] - p3['Pinitial']\n", "p3['Δp1 frange'] = p3['Δp(Nf)'] / p3['Nf']\n", "\n", "\n", "p3" ] }, { "cell_type": "code", "execution_count": 63, "id": "db35c2af", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "32.895833333333336 0.21211839374029431\n" ] } ], "source": [ "print(p3['Δp1 frange'].mean(), np.sqrt(1/6 * sum((p3['Δp1 frange'] - p3['Δp1 frange'].mean())**2)))" ] }, { "cell_type": "code", "execution_count": 65, "id": "b5063392", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "0.0005546852585157163\n" ] } ], "source": [ "print((p1[\"λ0\"].mean()/0.03) * (T/T_0) * (1 / p3['Δp1 frange'].mean()) * (1/1000))" ] }, { "cell_type": "code", "execution_count": 66, "id": "a8eb6961", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "1.8943746499917665e-05\n" ] } ], "source": [ "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))" ] }, { "cell_type": "code", "execution_count": null, "id": "1bcb0514", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python313", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.13.2" } }, "nbformat": 4, "nbformat_minor": 5 }