60 KiB
Executable File
60 KiB
Executable File
In [47]:
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
from scipy.stats import linregress
from scipy import constants as constIn [53]:
def cleanDataFrame(df: pd.DataFrame) -> pd.DataFrame:
for col in df.columns:
if col[0] != 'd':
df[f"{col} ± d{col}"] = df[col].astype(str) + " ± " + df[f"d{col}"].astype(str)
df = df.drop(columns=[col, f"d{col}"])
return dfIn [54]:
rho: float = 1.23
drho: float = 0.01
T: float = 21.5
dT: float = 0.1
eta: float = lambda rho, h, l, R, t, DeltaM: ((np.pi * const.g * 1e2 * rho**2) / 8) * (h / l) * (R**4) * (t / DeltaM)
deta: float = lambda rho, drho, h, dh, l, dl, R, dR, t, dt, DeltaM, dDeltaM: np.sqrt(
( ( (np.pi * const.g * 1e2 * 2 * rho) / 8) * (h / l) * (R**4) * (t / DeltaM) * drho )**2 +
( ( (np.pi * const.g * 1e2 * rho**2) / 8) * (1 / l) * (R**4) * (t / DeltaM) * dh )**2 +
( ( (np.pi * const.g * 1e2 * rho**2) / 8) * (-h / l**2) * (R**4) * (t / DeltaM) * dl )**2 +
( ( (np.pi * const.g * 1e2 * rho**2) / 8) * (h / l) * (4 * R**3) * (t / DeltaM) * dR )**2 +
( ( (np.pi * const.g * 1e2 * rho**2) / 8) * (h / l) * (R**4) * (1 / DeltaM) * dt )**2 +
( ( (np.pi * const.g * 1e2 * rho**2) / 8) * (h / l) * (R**4) * (-t / DeltaM**2) * dDeltaM )**2
)
In [55]:
HGL: pd.DataFrame = pd.DataFrame({
r"R": [3e-1/2, 1.6e-1/2],
r"dR": [0.05e-1]*2,
r"l": [435e-1, 430e-1],
r"dl": [1e-1]*2,
r"$M_{before}$": [433.26, 436.31],
r"d$M_{before}$": [0.01]*2,
r"$M_{after}$": [766.35, 500.93],
r"d$M_{after}$": [0.01]*2,
r"$\Delta M$": [np.nan] * 2,
r"d$\Delta M$": [np.nan] * 2,
r"t": [30*60+11, 30*60+1],
r"dt": [1]*2,
r"$h_{1}$": [527e-1, 525e-1],
r"d$h_{1}$": [1e-1]*2,
r"$h_{2}$": [485e-1, 518e-1],
r"d$h_{2}$": [1e-1]*2,
r"$h$": [np.nan] * 2,
r"d$h$": [np.nan] * 2,
r"$\eta$": [np.nan] * 2,
r"d$\eta$": [np.nan] * 2,
})
HGL[r"$\Delta M$"] = HGL[r"$M_{after}$"] - HGL[r"$M_{before}$"]
HGL[r"d$\Delta M$"] = np.sqrt(HGL[r"d$M_{before}$"]**2 + HGL[r"d$M_{after}$"]**2)
HGL[r"$h$"] = (HGL[r"$h_{1}$"] + HGL[r"$h_{2}$"]) / 2
HGL[r"d$h$"] = np.sqrt((HGL[r"d$h_{1}$"]**2 + HGL[r"d$h_{2}$"]**2) / 4)
HGL[r"$\eta$"] = eta(rho, HGL[r"$h$"], HGL[r"l"], HGL[r"R"], HGL[r"t"], HGL[r"$\Delta M$"])
HGL[r"d$\eta$"] = deta(rho, drho, HGL[r"$h$"], HGL[r"d$h$"], HGL[r"l"], HGL[r"dl"], HGL[r"R"], HGL[r"dR"], HGL[r"t"], HGL[r"dt"], HGL[r"$\Delta M$"], HGL[r"d$\Delta M$"])
eta_mean: float = HGL[r"$\eta$"].mean()
deta_mean: float = np.sqrt((HGL[r"d$\eta$"]**2).sum()) / len(HGL)
print(f"Viscosity η = {eta_mean:e} ± {deta_mean:e} Pa·s (Poise)")
HGL = cleanDataFrame(HGL)
HGLOut [55]:
Viscosity η = 1.336028e+00 ± 1.609758e-01 Pa·s (Poise)
| R ± dR | l ± dl | $M_{before}$ ± d$M_{before}$ | $M_{after}$ ± d$M_{after}$ | $\Delta M$ ± d$\Delta M$ | t ± dt | $h_{1}$ ± d$h_{1}$ | $h_{2}$ ± d$h_{2}$ | $h$ ± d$h$ | $\eta$ ± d$\eta$ | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0.15 ± 0.005 | 43.5 ± 0.1 | 433.26 ± 0.01 | 766.35 ± 0.01 | 333.09000000000003 ± 0.01414213562373095 | 1811 ± 1 | 52.7 ± 0.1 | 48.5 ± 0.1 | 50.6 ± 0.07071067811865477 | 1.8654084342380144 ± 0.2506161821585334 |
| 1 | 0.08 ± 0.005 | 43.0 ± 0.1 | 436.31 ± 0.01 | 500.93 ± 0.01 | 64.62 ± 0.01414213562373095 | 1801 ± 1 | 52.5 ± 0.1 | 51.8 ± 0.1 | 52.15 ± 0.07071067811865477 | 0.8066466758632603 ± 0.2021000017651807 |
In [59]:
rhok = 7.87 # g/cm^3
l = 450e-1
dl = 1e-1
rhof: float = 1.23
drhof: float = 0.01
T: float = 21.5
dT: float = 0.1
R = 62.7e-1/2
dR = 0.05e-1
eta_k:float = lambda rhok, rhof, l, r, R, t: ((2 * const.g * 1e2) / 9) * ((rhok - rhof) / l) * ((r**2) / (1 + 2.1 * (r / R))) * t
deta_k:float = lambda rhok, rhof, drhof, l, dl, r, dr, R, dR, t, dt: np.sqrt(
( ( (2 * const.g * 1e2) / 9) * (-1 / l) * ((r**2) / (1 + 2.1 * (r / R))) * t * drhof )**2 +
( ( (2 * const.g * 1e2) / 9) * (-(rhok - rhof) / l**2) * ((r**2) / (1 + 2.1 * (r / R))) * t * dl )**2 +
( ( (2 * const.g * 1e2) / 9) * ((rhok - rhof) / l) * ((r * (2 + 2.1 * r / R)) / (1 + 2.1 * r / R)**2) * t * dr )**2 +
( ( (2 * const.g * 1e2) / 9) * ((rhok - rhof) / l) * ( (-2.1 * (r**2) / (R**2)) / (1 + 2.1 * (r / R))**2 ) * t * dR )**2 +
( ( (2 * const.g * 1e2) / 9) * ((rhok - rhof) / l) * ((r**2) / (1 + 2.1 * (r / R))) * dt )**2
)In [61]:
S1: pd.DataFrame = pd.DataFrame({
r"r": [1.59e-1/2, 1.58e-1/2, 1.59e-1/2],
r"dr": [0.01e-1]*3,
r"t": [8.62, 8.70, 8.28],
r"dt": [0.16]*3,
r"$\eta$": [np.nan] * 3,
r"d$\eta$": [np.nan] * 3,
})
S2: pd.DataFrame = pd.DataFrame({
r"r": [2.39e-1/2, 2.38e-1/2, 2.39e-1/2],
r"dr": [0.01e-1]*3,
r"t": [4.28, 4.31, 4.23],
r"dt": [0.16]*3,
r"$\eta$": [np.nan] * 3,
r"d$\eta$": [np.nan] * 3,
})
S3: pd.DataFrame = pd.DataFrame({
r"r": [3.18e-1/2, 3.17e-1/2, 3.18e-1/2, ],
r"dr": [0.01e-1]*3,
r"t": [2.70, 2.70, 2.75],
r"dt": [0.16]*3,
r"$\eta$": [np.nan] * 3,
r"d$\eta$": [np.nan] * 3,
})
eta: list[float] = []
deta: list[float] = []
for S in [S1, S2, S3]:
S[r"$\eta$"] = eta_k(rhok, rhof, l, S[r"r"], R, S[r"t"])
S[r"d$\eta$"] = deta_k(rhok, rhof, drhof, l, dl, S[r"r"], S[r"dr"], R, dR, S[r"t"], S[r"dt"])
print(f"Viscosity from Stokes' Law η = {S[r'$\eta$'].mean():.4f} ± {np.sqrt((S[r'd$\eta$']**2).sum()) / len(S):.4f} Pa·s")
eta.append(S[r"$\eta$"].mean())
deta.append(np.sqrt((S[r"d$\eta$"]**2).sum()) / len(S))
print
S = cleanDataFrame(S)
print(r"$\eta \pm \delta\eta$:",end='')
print(f"{np.mean(eta):.4f} ± {np.sqrt(np.sum(np.array(deta)**2)) / len(deta):.4f} Pa·s")
print(f"S1:\n{S1}\n")
print(f"S2:\n{S2}\n")
print(f"S3:\n{S3}\n")Viscosity from Stokes' Law η = 1.6397 ± 0.0294 Pa·s
Viscosity from Stokes' Law η = 1.8120 ± 0.0428 Pa·s
Viscosity from Stokes' Law η = 1.9920 ± 0.0692 Pa·s
$\eta \pm \delta\eta$:1.8146 ± 0.0288 Pa·s
S1:
r dr t dt $\eta$ d$\eta$ r ± dr
0 0.0795 0.001 8.62 0.16 1.663307 0.051376 0.0795 ± 0.001
1 0.0790 0.001 8.70 0.16 1.658221 0.051259 0.079 ± 0.001
2 0.0795 0.001 8.28 0.16 1.597701 0.050091 0.0795 ± 0.001
S2:
r dr t dt $\eta$ d$\eta$ r ± dr
0 0.1195 0.001 4.28 0.16 1.819702 0.074261 0.1195 ± 0.001
1 0.1190 0.001 4.31 0.16 1.817718 0.073798 0.119 ± 0.001
2 0.1195 0.001 4.23 0.16 1.798444 0.074122 0.1195 ± 0.001
S3:
r dr t dt $\eta$ d$\eta$ r ± dr
0 0.1590 0.001 2.70 0.16 1.983661 0.120059 0.159 ± 0.001
1 0.1585 0.001 2.70 0.16 1.971802 0.119357 0.1585 ± 0.001
2 0.1590 0.001 2.75 0.16 2.020396 0.120152 0.159 ± 0.001
In [63]:
rhok: float = 7.87 # g/cm^3
Kprime: float = 0.0280
eta = lambda Kprime, rhok, rhof, t: Kprime * (rhok - rhof) * t
deta = lambda Kprime, rhok, rhof, drhof, t, dt: np.sqrt(
( -Kprime * t * drhof )**2 +
( Kprime * (rhok - rhof) * dt )**2
)In [71]:
Visicometer: pd.DataFrame = pd.DataFrame({
'T': [20.1, 25, 30, 35, 40, 45],
'dT': [0.1]*6,
't1 +': [29.32, 21.93, 16.28, 12.26, 9.20, 7.00],
'dt1 +': [0.16] * 6,
't2 +': [28.06, 21.86, 15.51, 11.68, 8.98, 7.14],
'dt2 +': [0.16] * 6,
't3 +': [27.72, 22.04, 15.75, 11.81, 9.18, 7.01],
'dt3 +': [0.16] * 6,
't1 -': [28.12, 21.10, 15.59, 11.53, 8.76, 6.93],
'dt1 -': [0.16] * 6,
't2 -': [29.20, 21.04, 15.24, 11.61, 8.67, 7.07],
'dt2 -': [0.16] * 6,
't3 -': [29.39, 20.76, 15.18, 11.31, 8.67, 6.90],
'dt3 -': [0.16] * 6,
'η(T)': [np.nan] * 6,
'dη(T)': [np.nan] * 6,
'ln(η(T))': [np.nan] * 6,
'dln(η(T))': [np.nan] * 6,
})
Visicometer['η(T)'] = eta(Kprime, rhok, rhof,
(Visicometer['t1 +'] + Visicometer['t2 +'] + Visicometer['t3 +'] +
Visicometer['t1 -'] + Visicometer['t2 -'] + Visicometer['t3 -']) / 6
)
Visicometer['dη(T)'] = deta(Kprime, rhok, rhof, drhof,
(Visicometer['t1 +'] + Visicometer['t2 +'] + Visicometer['t3 +'] +
Visicometer['t1 -'] + Visicometer['t2 -'] + Visicometer['t3 -']) / 6,
np.sqrt(Visicometer['dt1 +']**2 + Visicometer['dt2 +']**2 + Visicometer['dt3 +']**2 +
Visicometer['dt1 -']**2 + Visicometer['dt2 -']**2 + Visicometer['dt3 -']**2) / 6
)
Visicometer['ln(η(T))'] = np.log(Visicometer['η(T)'])
Visicometer['dln(η(T))'] = Visicometer['dη(T)'] / Visicometer['η(T)']
slope, intercept, r_value, p_value, std_err = linregress(Visicometer['T'], Visicometer['ln(η(T))'])
plt.errorbar(Visicometer['T'], Visicometer['ln(η(T))'], yerr=Visicometer['dln(η(T))'], fmt='o', label='Data with error bars')
plt.plot(Visicometer['T'], intercept + slope * Visicometer['T'], 'r', label='Fitted line')
plt.xlabel(r'Temperature $T$ (°C)')
plt.ylabel(r'Logarithm of Viscosity $\ln(\eta)$')
plt.title('Logarithm of Viscosity vs Temperature (°C)')
plt.legend()
plt.text(0.05, 0.05, f'Slope: {slope:.4f} ± {std_err:.4f} °C⁻¹', transform=plt.gca().transAxes, verticalalignment='top')
plt.show()
print(f'Tc: {-1/slope:.4f} ± {std_err/slope**2:.4f} °C')
print(Visicometer)Tc: 17.5194 ± 0.3970 °C
T dT t1 + dt1 + t2 + dt2 + t3 + dt3 + t1 - dt1 - t2 - \
0 20.1 0.1 29.32 0.16 28.06 0.16 27.72 0.16 28.12 0.16 29.20
1 25.0 0.1 21.93 0.16 21.86 0.16 22.04 0.16 21.10 0.16 21.04
2 30.0 0.1 16.28 0.16 15.51 0.16 15.75 0.16 15.59 0.16 15.24
3 35.0 0.1 12.26 0.16 11.68 0.16 11.81 0.16 11.53 0.16 11.61
4 40.0 0.1 9.20 0.16 8.98 0.16 9.18 0.16 8.76 0.16 8.67
5 45.0 0.1 7.00 0.16 7.14 0.16 7.01 0.16 6.93 0.16 7.07
dt2 - t3 - dt3 - η(T) dη(T) ln(η(T)) dln(η(T))
0 0.16 29.39 0.16 5.323819 0.014552 1.672191 0.002733
1 0.16 20.76 0.16 3.988914 0.013549 1.383519 0.003397
2 0.16 15.18 0.16 2.898803 0.012905 1.064298 0.004452
3 0.16 11.31 0.16 2.175264 0.012578 0.777150 0.005782
4 0.16 8.67 0.16 1.656547 0.012398 0.504735 0.007484
5 0.16 6.90 0.16 1.302989 0.012302 0.264661 0.009441