{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "6a43b622",
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from datetime import datetime, timedelta"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "b4461157",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-01\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-02\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-03\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-04\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-05\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-06\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-07\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-08\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-09\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-10\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-11\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-12\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-13\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-14\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-14\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-15\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-15\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-16\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-16\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-17\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-17\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-18\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-19\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-19\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-20\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-20\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-21\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-21\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-22\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-22\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-23\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-23\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-24\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-24\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-25\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-25\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-26\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-26\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-27\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-27\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-28\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-28\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-29\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-29\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-30\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-03\\2024-03-31\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-01\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-02\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-03\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-04\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-04\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-05\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-05\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-06\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-06\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-07\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-07\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-08\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-08\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-09\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-09\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-10\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-10\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-11\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-11\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-12\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-12\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-13\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-13\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-14\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-14\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-15\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-15\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-16\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-16\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-17\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-17\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-18\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-18\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-19\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-19\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-20\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-20\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-21\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-21\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-22\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-22\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-23\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-24\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-25\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-26\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-27\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-28\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-29\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-04\\2024-04-30\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-01\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-01\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-02\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-02\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-03\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-03\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-04\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-04\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-05\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-05\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-06\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-06\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-07\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-07\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-08\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-08\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-09\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-09\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-10\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-10\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-11\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-11\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-12\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-12\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-13\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-13\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-14\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-14\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-15\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-15\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-16\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-16\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-17\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-17\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-18\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-18\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-19\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-19\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-20\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-20\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-21\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-21\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-22\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-22\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-23\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-23\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-24\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-24\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-25\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-25\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-26\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-26\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-27\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-27\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-28\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-28\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-29\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-29\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-30\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-30\\merged_data_10min.csv\n",
      "Checking C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-31\n",
      "Updated: C:\\Users\\magda\\Master_Thesis\\Sonic\\2024-05\\2024-05-31\\merged_data_10min.csv\n"
     ]
    }
   ],
   "source": [
    "base_dir = 'C:\\\\Users\\\\magda\\\\Master_Thesis\\\\Sonic'\n",
    "months = ['2024-03', '2024-04', '2024-05']\n",
    "theta_deg = 116\n",
    "theta_rad = np.deg2rad(theta_deg)\n",
    "\n",
    "for month_str in months:\n",
    "    month_dt = datetime.strptime(month_str, '%Y-%m')\n",
    "    for day in range(1, 32):\n",
    "        try:\n",
    "            date_dt = month_dt.replace(day=day)\n",
    "            date_str = date_dt.strftime('%Y-%m-%d')  # '2024-05-01\n",
    "\n",
    "        except ValueError:\n",
    "            continue  # skip invalid dates\n",
    "\n",
    "        data_dir = os.path.join(base_dir, month_str, date_str)\n",
    "        \n",
    "        merged_file_path = os.path.join(data_dir, 'merged_data_10min.csv')\n",
    "        print(f\"Checking {data_dir}\")\n",
    "\n",
    "        if not os.path.exists(merged_file_path):\n",
    "            continue\n",
    "\n",
    "        if not any(fname.endswith('.dat') for fname in os.listdir(data_dir)):\n",
    "            continue\n",
    "\n",
    "        timestamps_10min = []\n",
    "        uw_flux_10min_corr = []\n",
    "        vw_flux_10min_corr = []\n",
    "        uv_flux_10min_corr = []\n",
    "\n",
    "        for filename in os.listdir(data_dir):\n",
    "            if filename.endswith('.dat'):\n",
    "                file_path = os.path.join(data_dir, filename)\n",
    "                data = pd.read_csv(file_path, skiprows=1, delimiter=',', encoding='latin1', low_memory=False)\n",
    "                data.dropna(inplace=True)\n",
    "\n",
    "                data['TIMESTAMP'] = pd.to_datetime(data['TIMESTAMP'], errors='coerce')\n",
    "                for var in ['Ux', 'Uy', 'Uz']:\n",
    "                    data[var] = pd.to_numeric(data[var], errors='coerce')\n",
    "\n",
    "                data['Ux_corrected'] = data['Ux'] * np.cos(theta_rad) + data['Uy'] * np.sin(theta_rad)\n",
    "                data['Uy_corrected'] = -data['Ux'] * np.sin(theta_rad) + data['Uy'] * np.cos(theta_rad)\n",
    "\n",
    "                for i in range(0, len(data), 12000):\n",
    "                    chunk = data.iloc[i:i+12000]\n",
    "                    if chunk.empty:\n",
    "                        continue\n",
    "\n",
    "                    u_mean = chunk['Ux_corrected'].mean()\n",
    "                    v_mean = chunk['Uy_corrected'].mean()\n",
    "                    w_mean = chunk['Uz'].mean()\n",
    "\n",
    "                    u_prime = chunk['Ux_corrected'] - u_mean\n",
    "                    v_prime = chunk['Uy_corrected'] - v_mean\n",
    "                    w_prime = chunk['Uz'] - w_mean\n",
    "\n",
    "                    uw_flux_corr = (u_prime * w_prime).mean()\n",
    "                    vw_flux_corr = (v_prime * w_prime).mean()\n",
    "                    uv_flux_corr = (u_prime * v_prime).mean()\n",
    "\n",
    "                    timestamps_10min.append(chunk['TIMESTAMP'].iloc[0].floor('10T'))\n",
    "                    uw_flux_10min_corr.append(uw_flux_corr)\n",
    "                    vw_flux_10min_corr.append(vw_flux_corr)\n",
    "                    uv_flux_10min_corr.append(uv_flux_corr)\n",
    "\n",
    "        if not timestamps_10min:\n",
    "            continue\n",
    "\n",
    "        flux_df = pd.DataFrame({\n",
    "            'TIMESTAMP': timestamps_10min,\n",
    "            'uw_flux_corr': uw_flux_10min_corr,\n",
    "            'vw_flux_corr': vw_flux_10min_corr,\n",
    "            'uv_flux_corr': uv_flux_10min_corr,\n",
    "        })\n",
    "\n",
    "        try:\n",
    "            merged_df = pd.read_csv(merged_file_path, parse_dates=['TIMESTAMP'])\n",
    "            merged_df = pd.merge(merged_df, flux_df, on='TIMESTAMP', how='left')\n",
    "\n",
    "            # Compute corrected stress components\n",
    "            merged_df['tau_xz_corr'] = -merged_df['rho_air_Tv'] * merged_df['uw_flux_corr']\n",
    "            merged_df['tau_yz_corr'] = -merged_df['rho_air_Tv'] * merged_df['vw_flux_corr']\n",
    "            merged_df['tau_xy_corr'] = -merged_df['rho_air_Tv'] * merged_df['uv_flux_corr']\n",
    "\n",
    "            merged_df.to_csv(merged_file_path, index=False)\n",
    "            print(f'Updated: {merged_file_path}')\n",
    "        except Exception as e:\n",
    "            print(f\"Error processing {merged_file_path}: {e}\")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.11.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}