1247 lines
32 KiB
Plaintext
Executable File
1247 lines
32 KiB
Plaintext
Executable File
{
|
|
"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": [
|
|
"<div>\n",
|
|
"<style scoped>\n",
|
|
" .dataframe tbody tr th:only-of-type {\n",
|
|
" vertical-align: middle;\n",
|
|
" }\n",
|
|
"\n",
|
|
" .dataframe tbody tr th {\n",
|
|
" vertical-align: top;\n",
|
|
" }\n",
|
|
"\n",
|
|
" .dataframe thead th {\n",
|
|
" text-align: right;\n",
|
|
" }\n",
|
|
"</style>\n",
|
|
"<table border=\"1\" class=\"dataframe\">\n",
|
|
" <thead>\n",
|
|
" <tr style=\"text-align: right;\">\n",
|
|
" <th></th>\n",
|
|
" <th>L2 (initial)</th>\n",
|
|
" <th>L2 (final)</th>\n",
|
|
" <th>dL2</th>\n",
|
|
" <th>ΔL2 100</th>\n",
|
|
" <th>λ0</th>\n",
|
|
" <th>dλ0</th>\n",
|
|
" </tr>\n",
|
|
" </thead>\n",
|
|
" <tbody>\n",
|
|
" <tr>\n",
|
|
" <th>0</th>\n",
|
|
" <td>0</td>\n",
|
|
" <td>27.5</td>\n",
|
|
" <td>0.5</td>\n",
|
|
" <td>27.5</td>\n",
|
|
" <td>0.550</td>\n",
|
|
" <td>0.01</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>1</th>\n",
|
|
" <td>0</td>\n",
|
|
" <td>28.5</td>\n",
|
|
" <td>0.5</td>\n",
|
|
" <td>28.5</td>\n",
|
|
" <td>0.570</td>\n",
|
|
" <td>0.01</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>2</th>\n",
|
|
" <td>0</td>\n",
|
|
" <td>27.0</td>\n",
|
|
" <td>0.5</td>\n",
|
|
" <td>27.0</td>\n",
|
|
" <td>0.540</td>\n",
|
|
" <td>0.01</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>3</th>\n",
|
|
" <td>0</td>\n",
|
|
" <td>25.5</td>\n",
|
|
" <td>0.5</td>\n",
|
|
" <td>25.5</td>\n",
|
|
" <td>0.510</td>\n",
|
|
" <td>0.01</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>4</th>\n",
|
|
" <td>0</td>\n",
|
|
" <td>26.6</td>\n",
|
|
" <td>0.5</td>\n",
|
|
" <td>26.6</td>\n",
|
|
" <td>0.532</td>\n",
|
|
" <td>0.01</td>\n",
|
|
" </tr>\n",
|
|
" </tbody>\n",
|
|
"</table>\n",
|
|
"</div>"
|
|
],
|
|
"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": [
|
|
"<div>\n",
|
|
"<style scoped>\n",
|
|
" .dataframe tbody tr th:only-of-type {\n",
|
|
" vertical-align: middle;\n",
|
|
" }\n",
|
|
"\n",
|
|
" .dataframe tbody tr th {\n",
|
|
" vertical-align: top;\n",
|
|
" }\n",
|
|
"\n",
|
|
" .dataframe thead th {\n",
|
|
" text-align: right;\n",
|
|
" }\n",
|
|
"</style>\n",
|
|
"<table border=\"1\" class=\"dataframe\">\n",
|
|
" <thead>\n",
|
|
" <tr style=\"text-align: right;\">\n",
|
|
" <th></th>\n",
|
|
" <th></th>\n",
|
|
" <th>Pinitial</th>\n",
|
|
" <th>Pfinal</th>\n",
|
|
" <th>Δp(Nf)</th>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>Nf</th>\n",
|
|
" <th>#</th>\n",
|
|
" <th></th>\n",
|
|
" <th></th>\n",
|
|
" <th></th>\n",
|
|
" </tr>\n",
|
|
" </thead>\n",
|
|
" <tbody>\n",
|
|
" <tr>\n",
|
|
" <th rowspan=\"4\" valign=\"top\">5</th>\n",
|
|
" <th>1</th>\n",
|
|
" <td>156.0</td>\n",
|
|
" <td>332.0</td>\n",
|
|
" <td>176.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>2</th>\n",
|
|
" <td>147.0</td>\n",
|
|
" <td>316.0</td>\n",
|
|
" <td>169.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>3</th>\n",
|
|
" <td>153.0</td>\n",
|
|
" <td>308.0</td>\n",
|
|
" <td>155.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>4</th>\n",
|
|
" <td>150.0</td>\n",
|
|
" <td>312.0</td>\n",
|
|
" <td>162.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th rowspan=\"4\" valign=\"top\">10</th>\n",
|
|
" <th>1</th>\n",
|
|
" <td>156.0</td>\n",
|
|
" <td>484.0</td>\n",
|
|
" <td>328.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>2</th>\n",
|
|
" <td>147.0</td>\n",
|
|
" <td>483.0</td>\n",
|
|
" <td>336.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>3</th>\n",
|
|
" <td>153.0</td>\n",
|
|
" <td>474.0</td>\n",
|
|
" <td>321.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>4</th>\n",
|
|
" <td>150.0</td>\n",
|
|
" <td>485.0</td>\n",
|
|
" <td>335.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th rowspan=\"4\" valign=\"top\">15</th>\n",
|
|
" <th>1</th>\n",
|
|
" <td>156.0</td>\n",
|
|
" <td>643.0</td>\n",
|
|
" <td>487.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>2</th>\n",
|
|
" <td>147.0</td>\n",
|
|
" <td>655.0</td>\n",
|
|
" <td>508.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>3</th>\n",
|
|
" <td>153.0</td>\n",
|
|
" <td>634.0</td>\n",
|
|
" <td>481.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>4</th>\n",
|
|
" <td>150.0</td>\n",
|
|
" <td>640.0</td>\n",
|
|
" <td>490.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th rowspan=\"4\" valign=\"top\">20</th>\n",
|
|
" <th>1</th>\n",
|
|
" <td>156.0</td>\n",
|
|
" <td>812.0</td>\n",
|
|
" <td>656.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>2</th>\n",
|
|
" <td>147.0</td>\n",
|
|
" <td>809.0</td>\n",
|
|
" <td>662.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>3</th>\n",
|
|
" <td>153.0</td>\n",
|
|
" <td>802.0</td>\n",
|
|
" <td>649.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>4</th>\n",
|
|
" <td>150.0</td>\n",
|
|
" <td>811.0</td>\n",
|
|
" <td>661.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th rowspan=\"4\" valign=\"top\">24</th>\n",
|
|
" <th>1</th>\n",
|
|
" <td>156.0</td>\n",
|
|
" <td>946.0</td>\n",
|
|
" <td>790.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>2</th>\n",
|
|
" <td>147.0</td>\n",
|
|
" <td>946.0</td>\n",
|
|
" <td>799.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>3</th>\n",
|
|
" <td>153.0</td>\n",
|
|
" <td>936.0</td>\n",
|
|
" <td>783.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>4</th>\n",
|
|
" <td>150.0</td>\n",
|
|
" <td>939.0</td>\n",
|
|
" <td>789.0</td>\n",
|
|
" </tr>\n",
|
|
" </tbody>\n",
|
|
"</table>\n",
|
|
"</div>"
|
|
],
|
|
"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": [
|
|
"<div>\n",
|
|
"<style scoped>\n",
|
|
" .dataframe tbody tr th:only-of-type {\n",
|
|
" vertical-align: middle;\n",
|
|
" }\n",
|
|
"\n",
|
|
" .dataframe tbody tr th {\n",
|
|
" vertical-align: top;\n",
|
|
" }\n",
|
|
"\n",
|
|
" .dataframe thead th {\n",
|
|
" text-align: right;\n",
|
|
" }\n",
|
|
"</style>\n",
|
|
"<table border=\"1\" class=\"dataframe\">\n",
|
|
" <thead>\n",
|
|
" <tr style=\"text-align: right;\">\n",
|
|
" <th></th>\n",
|
|
" <th>mean</th>\n",
|
|
" <th>std</th>\n",
|
|
" <th>count</th>\n",
|
|
" </tr>\n",
|
|
" </thead>\n",
|
|
" <tbody>\n",
|
|
" <tr>\n",
|
|
" <th>Δp(Nf = 5)</th>\n",
|
|
" <td>165.50</td>\n",
|
|
" <td>9.036961</td>\n",
|
|
" <td>4.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>Δp(Nf = 10)</th>\n",
|
|
" <td>330.00</td>\n",
|
|
" <td>6.976150</td>\n",
|
|
" <td>4.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>Δp(Nf = 15)</th>\n",
|
|
" <td>491.50</td>\n",
|
|
" <td>11.618950</td>\n",
|
|
" <td>4.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>Δp(Nf = 20)</th>\n",
|
|
" <td>657.00</td>\n",
|
|
" <td>5.944185</td>\n",
|
|
" <td>4.0</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>Δp(Nf = 24)</th>\n",
|
|
" <td>790.25</td>\n",
|
|
" <td>6.601767</td>\n",
|
|
" <td>4.0</td>\n",
|
|
" </tr>\n",
|
|
" </tbody>\n",
|
|
"</table>\n",
|
|
"</div>"
|
|
],
|
|
"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": [
|
|
"<div>\n",
|
|
"<style scoped>\n",
|
|
" .dataframe tbody tr th:only-of-type {\n",
|
|
" vertical-align: middle;\n",
|
|
" }\n",
|
|
"\n",
|
|
" .dataframe tbody tr th {\n",
|
|
" vertical-align: top;\n",
|
|
" }\n",
|
|
"\n",
|
|
" .dataframe thead th {\n",
|
|
" text-align: right;\n",
|
|
" }\n",
|
|
"</style>\n",
|
|
"<table border=\"1\" class=\"dataframe\">\n",
|
|
" <thead>\n",
|
|
" <tr style=\"text-align: right;\">\n",
|
|
" <th></th>\n",
|
|
" <th>Pinitial</th>\n",
|
|
" <th>Pfinal</th>\n",
|
|
" <th>Δp(Nf)</th>\n",
|
|
" <th>Nf</th>\n",
|
|
" <th>Δp1 frange</th>\n",
|
|
" </tr>\n",
|
|
" </thead>\n",
|
|
" <tbody>\n",
|
|
" <tr>\n",
|
|
" <th>0</th>\n",
|
|
" <td>156</td>\n",
|
|
" <td>946</td>\n",
|
|
" <td>790</td>\n",
|
|
" <td>24</td>\n",
|
|
" <td>32.916667</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>1</th>\n",
|
|
" <td>147</td>\n",
|
|
" <td>946</td>\n",
|
|
" <td>799</td>\n",
|
|
" <td>24</td>\n",
|
|
" <td>33.291667</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>2</th>\n",
|
|
" <td>153</td>\n",
|
|
" <td>936</td>\n",
|
|
" <td>783</td>\n",
|
|
" <td>24</td>\n",
|
|
" <td>32.625000</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>3</th>\n",
|
|
" <td>150</td>\n",
|
|
" <td>939</td>\n",
|
|
" <td>789</td>\n",
|
|
" <td>24</td>\n",
|
|
" <td>32.875000</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>4</th>\n",
|
|
" <td>151</td>\n",
|
|
" <td>942</td>\n",
|
|
" <td>791</td>\n",
|
|
" <td>24</td>\n",
|
|
" <td>32.958333</td>\n",
|
|
" </tr>\n",
|
|
" <tr>\n",
|
|
" <th>5</th>\n",
|
|
" <td>161</td>\n",
|
|
" <td>946</td>\n",
|
|
" <td>785</td>\n",
|
|
" <td>24</td>\n",
|
|
" <td>32.708333</td>\n",
|
|
" </tr>\n",
|
|
" </tbody>\n",
|
|
"</table>\n",
|
|
"</div>"
|
|
],
|
|
"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
|
|
}
|