2df_copypaste.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "890d21fc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "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>Frequency (Hz)</th>\n",
       "      <th>Amplitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>73.684211</td>\n",
       "      <td>0.005356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>136.842105</td>\n",
       "      <td>0.004395</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>147.368421</td>\n",
       "      <td>0.102953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>223.684211</td>\n",
       "      <td>0.011307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>297.368421</td>\n",
       "      <td>0.035448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>371.052632</td>\n",
       "      <td>0.005977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>442.105263</td>\n",
       "      <td>0.002880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>447.368421</td>\n",
       "      <td>0.006474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>521.052632</td>\n",
       "      <td>0.011020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>594.736842</td>\n",
       "      <td>0.002818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>818.421053</td>\n",
       "      <td>0.002759</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>894.736842</td>\n",
       "      <td>0.002141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>965.789474</td>\n",
       "      <td>0.002436</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1263.157895</td>\n",
       "      <td>0.002615</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Frequency (Hz)  Amplitude\n",
       "0        73.684211   0.005356\n",
       "1       136.842105   0.004395\n",
       "2       147.368421   0.102953\n",
       "3       223.684211   0.011307\n",
       "4       297.368421   0.035448\n",
       "5       371.052632   0.005977\n",
       "6       442.105263   0.002880\n",
       "7       447.368421   0.006474\n",
       "8       521.052632   0.011020\n",
       "9       594.736842   0.002818\n",
       "10      818.421053   0.002759\n",
       "11      894.736842   0.002141\n",
       "12      965.789474   0.002436\n",
       "13     1263.157895   0.002615"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "#load data from TSV\n",
    "\n",
    "df = pd.read_csv('tsv/cello_single.tsv', delimiter='\\t')\n",
    "\n",
    "display(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "8d7d299f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "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>freq_data1</th>\n",
       "      <th>amp_data1</th>\n",
       "      <th>freq_data2</th>\n",
       "      <th>amp_data2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>73.684211</td>\n",
       "      <td>0.005356</td>\n",
       "      <td>73.684211</td>\n",
       "      <td>0.005356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>136.842105</td>\n",
       "      <td>0.004395</td>\n",
       "      <td>136.842105</td>\n",
       "      <td>0.004395</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>147.368421</td>\n",
       "      <td>0.102953</td>\n",
       "      <td>147.368421</td>\n",
       "      <td>0.102953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>223.684211</td>\n",
       "      <td>0.011307</td>\n",
       "      <td>223.684211</td>\n",
       "      <td>0.011307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>297.368421</td>\n",
       "      <td>0.035448</td>\n",
       "      <td>297.368421</td>\n",
       "      <td>0.035448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>371.052632</td>\n",
       "      <td>0.005977</td>\n",
       "      <td>371.052632</td>\n",
       "      <td>0.005977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>442.105263</td>\n",
       "      <td>0.002880</td>\n",
       "      <td>442.105263</td>\n",
       "      <td>0.002880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>447.368421</td>\n",
       "      <td>0.006474</td>\n",
       "      <td>447.368421</td>\n",
       "      <td>0.006474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>521.052632</td>\n",
       "      <td>0.011020</td>\n",
       "      <td>521.052632</td>\n",
       "      <td>0.011020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>594.736842</td>\n",
       "      <td>0.002818</td>\n",
       "      <td>594.736842</td>\n",
       "      <td>0.002818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>818.421053</td>\n",
       "      <td>0.002759</td>\n",
       "      <td>818.421053</td>\n",
       "      <td>0.002759</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>894.736842</td>\n",
       "      <td>0.002141</td>\n",
       "      <td>894.736842</td>\n",
       "      <td>0.002141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>965.789474</td>\n",
       "      <td>0.002436</td>\n",
       "      <td>965.789474</td>\n",
       "      <td>0.002436</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1263.157895</td>\n",
       "      <td>0.002615</td>\n",
       "      <td>1263.157895</td>\n",
       "      <td>0.002615</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     freq_data1  amp_data1   freq_data2  amp_data2\n",
       "0     73.684211   0.005356    73.684211   0.005356\n",
       "1    136.842105   0.004395   136.842105   0.004395\n",
       "2    147.368421   0.102953   147.368421   0.102953\n",
       "3    223.684211   0.011307   223.684211   0.011307\n",
       "4    297.368421   0.035448   297.368421   0.035448\n",
       "5    371.052632   0.005977   371.052632   0.005977\n",
       "6    442.105263   0.002880   442.105263   0.002880\n",
       "7    447.368421   0.006474   447.368421   0.006474\n",
       "8    521.052632   0.011020   521.052632   0.011020\n",
       "9    594.736842   0.002818   594.736842   0.002818\n",
       "10   818.421053   0.002759   818.421053   0.002759\n",
       "11   894.736842   0.002141   894.736842   0.002141\n",
       "12   965.789474   0.002436   965.789474   0.002436\n",
       "13  1263.157895   0.002615  1263.157895   0.002615"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Duplicate the columns into a new dataframe\n",
    "double_df = pd.DataFrame({\n",
    "    \"freq_data1\": df[\"Frequency (Hz)\"],\n",
    "    \"amp_data1\": df[\"Amplitude\"],\n",
    "    \"freq_data2\": df[\"Frequency (Hz)\"],\n",
    "    \"amp_data2\": df[\"Amplitude\"]\n",
    "})\n",
    "\n",
    "display(double_df)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "c70a259c-4a21-4440-8576-a03d372a32c1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "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>freq_start</th>\n",
       "      <th>freq_stop</th>\n",
       "      <th>time_start</th>\n",
       "      <th>time_stop</th>\n",
       "      <th>amp_min</th>\n",
       "      <th>amp_max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>73.684211</td>\n",
       "      <td>73.684211</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.052027</td>\n",
       "      <td>0.052027</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>136.842105</td>\n",
       "      <td>136.842105</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.042688</td>\n",
       "      <td>0.042688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>147.368421</td>\n",
       "      <td>147.368421</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>223.684211</td>\n",
       "      <td>223.684211</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.109827</td>\n",
       "      <td>0.109827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>297.368421</td>\n",
       "      <td>297.368421</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.344315</td>\n",
       "      <td>0.344315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>371.052632</td>\n",
       "      <td>371.052632</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.058057</td>\n",
       "      <td>0.058057</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>442.105263</td>\n",
       "      <td>442.105263</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.027971</td>\n",
       "      <td>0.027971</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>447.368421</td>\n",
       "      <td>447.368421</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.062887</td>\n",
       "      <td>0.062887</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>521.052632</td>\n",
       "      <td>521.052632</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.107042</td>\n",
       "      <td>0.107042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>594.736842</td>\n",
       "      <td>594.736842</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.027374</td>\n",
       "      <td>0.027374</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>818.421053</td>\n",
       "      <td>818.421053</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.026797</td>\n",
       "      <td>0.026797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>894.736842</td>\n",
       "      <td>894.736842</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.020797</td>\n",
       "      <td>0.020797</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>965.789474</td>\n",
       "      <td>965.789474</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.023658</td>\n",
       "      <td>0.023658</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1263.157895</td>\n",
       "      <td>1263.157895</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.025396</td>\n",
       "      <td>0.025396</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     freq_start    freq_stop  time_start  time_stop   amp_min   amp_max\n",
       "0     73.684211    73.684211         0.0       15.0  0.052027  0.052027\n",
       "1    136.842105   136.842105         0.0       15.0  0.042688  0.042688\n",
       "2    147.368421   147.368421         0.0       15.0  1.000000  1.000000\n",
       "3    223.684211   223.684211         0.0       15.0  0.109827  0.109827\n",
       "4    297.368421   297.368421         0.0       15.0  0.344315  0.344315\n",
       "5    371.052632   371.052632         0.0       15.0  0.058057  0.058057\n",
       "6    442.105263   442.105263         0.0       15.0  0.027971  0.027971\n",
       "7    447.368421   447.368421         0.0       15.0  0.062887  0.062887\n",
       "8    521.052632   521.052632         0.0       15.0  0.107042  0.107042\n",
       "9    594.736842   594.736842         0.0       15.0  0.027374  0.027374\n",
       "10   818.421053   818.421053         0.0       15.0  0.026797  0.026797\n",
       "11   894.736842   894.736842         0.0       15.0  0.020797  0.020797\n",
       "12   965.789474   965.789474         0.0       15.0  0.023658  0.023658\n",
       "13  1263.157895  1263.157895         0.0       15.0  0.025396  0.025396"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "def process_df(input_df, freq_start_col, amp_start_col, freq_stop_col, amp_stop_col, wave_stop_value, override_amp_value=None, scale_amp_value=True):\n",
    "    # Scaling amplitude if required\n",
    "    if scale_amp_value:\n",
    "        amp_start_scaled = input_df[amp_start_col] / input_df[amp_start_col].max()\n",
    "        amp_stop_max = input_df[amp_stop_col] / input_df[amp_stop_col].max()\n",
    "    else:\n",
    "        amp_start_scaled = input_df[amp_start_col]\n",
    "        amp_stop_max = input_df[amp_stop_col]\n",
    "    \n",
    "    # Overriding amplitude values if required\n",
    "    if override_amp_value is not None:\n",
    "        amp_min = [override_amp_value] * len(input_df)\n",
    "        amp_max = [override_amp_value] * len(input_df)\n",
    "    else:\n",
    "        amp_min = amp_start_scaled\n",
    "        amp_max = amp_stop_max\n",
    "\n",
    "    new_data = {\n",
    "        \"freq_start\": input_df[freq_start_col],\n",
    "        \"freq_stop\": input_df[freq_stop_col],\n",
    "        \"time_start\": [0.0] * len(input_df),\n",
    "        \"time_stop\": [wave_stop_value] * len(input_df),\n",
    "        \"amp_min\": amp_min,\n",
    "        \"amp_max\": amp_max\n",
    "    }\n",
    "    \n",
    "    return pd.DataFrame(new_data)\n",
    "\n",
    "wave_stop_value = 15.0\n",
    "override_amp_value = None\n",
    "scale_amp_value = True\n",
    "\n",
    "new_df = process_df(double_df, 'freq_data1', 'amp_data1', 'freq_data2', 'amp_data2', wave_stop_value, override_amp_value, scale_amp_value)\n",
    "display(new_df)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "d57cf741",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Data saved successfully to C:\\Users\\egorp\\Nextcloud\\code\\public_repos\\audiospylt\\tsv\\cello_double.tsv at 2024-06-10 23:12:11.522329.\n"
     ]
    }
   ],
   "source": [
    "import os\n",
    "from datetime import datetime\n",
    "\n",
    "# Define the path for the /tsv subfolder\n",
    "output_directory = 'tsv'\n",
    "\n",
    "# Check if the directory exists; if not, create it\n",
    "if not os.path.exists(output_directory):\n",
    "    os.makedirs(output_directory)\n",
    "\n",
    "# Define the filename path to save inside the /tsv subfolder\n",
    "filename = os.path.join(output_directory, 'cello_double.tsv')\n",
    "\n",
    "try:\n",
    "    new_df.to_csv(filename, sep='\\t', index=False)\n",
    "    print(f\"Data saved successfully to {os.path.abspath(filename)} at {datetime.now()}.\")\n",
    "except:\n",
    "    print(\"Error: data could not be saved.\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c4b60ea5-d7bd-4cc0-b2f3-54291c637264",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.12.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}