rewrite_csv.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "22f0958b-24dc-4550-839b-501125ed5c41",
   "metadata": {},
   "outputs": [],
   "source": [
    "import csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "fe0d55f8-8655-4b5e-b26f-1f0e1e230adc",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 読み込み\n",
    "def read_csv(filename):\n",
    "    f = open(filename, \"r\")\n",
    "    csv_data = csv.reader(f)\n",
    "    list = [ e for e in csv_data]\n",
    "    f.close()\n",
    "    return list\n",
    "\n",
    "# リストの更新\n",
    "def update_list2d(list, data):\n",
    "    list[0] = data\n",
    "    return list\n",
    "\n",
    "# 書き込み\n",
    "def write_csv(filename, list):\n",
    "   with open(filename, 'w', newline='') as f:\n",
    "        writer = csv.writer(f)\n",
    "        writer.writerows(list)   \n",
    "\n",
    "   f.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "9dd4e049-fb27-419b-acad-4d9b8e0802b4",
   "metadata": {},
   "outputs": [],
   "source": [
    "def main():\n",
    "    for i in range(180, 264, 1):\n",
    "        word = list(str(i))\n",
    "        word.insert(2, \".\")\n",
    "        start_freq = float(\"\".join(word))\n",
    "        print(start_freq)\n",
    "        \n",
    "        initial = int(start_freq * 1.e+6 - 250)\n",
    "        final = int(initial + 1.e+5)\n",
    "\n",
    "        for i in range(initial, final, 2000):\n",
    "            word = list(str(i))\n",
    "            word.insert(2, \".\")\n",
    "            start = \"\".join(word)\n",
    "            #print(start)\n",
    "            \n",
    "            # CSVファイルのパス\n",
    "            csv_path = \"/data/ms2840a/result_data/signal_12_data/start_{}GHz.csv\".format(start)\n",
    "\n",
    "            # CSVファイルのロード\n",
    "            csv_data = read_csv(csv_path)\n",
    "\n",
    "            # リストを更新\n",
    "            data = [\"freq\",\"W_0\",\"W_1\",\"W_2\",\"W_3\",\"W_4\",\"W_5\",\"W_6\",\"W_7\",\"W_8\",\"W_9\",\"W_10\",\"W_11\"]\n",
    "            csv_data2 = update_list2d(csv_data, data)\n",
    "\n",
    "            # 更新後のリストを書き込み\n",
    "            write_csv(csv_path, csv_data2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "65ea4a53-0343-497a-9478-6933c6fedbfd",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "18.0\n",
      "18.1\n",
      "18.2\n",
      "18.3\n",
      "18.4\n",
      "18.5\n",
      "18.6\n",
      "18.7\n",
      "18.8\n",
      "18.9\n",
      "19.0\n",
      "19.1\n",
      "19.2\n",
      "19.3\n",
      "19.4\n",
      "19.5\n",
      "19.6\n",
      "19.7\n",
      "19.8\n",
      "19.9\n",
      "20.0\n",
      "20.1\n",
      "20.2\n",
      "20.3\n",
      "20.4\n",
      "20.5\n",
      "20.6\n",
      "20.7\n",
      "20.8\n",
      "20.9\n",
      "21.0\n",
      "21.1\n",
      "21.2\n",
      "21.3\n",
      "21.4\n",
      "21.5\n",
      "21.6\n",
      "21.7\n",
      "21.8\n",
      "21.9\n",
      "22.0\n",
      "22.1\n",
      "22.2\n",
      "22.3\n",
      "22.4\n",
      "22.5\n",
      "22.6\n",
      "22.7\n",
      "22.8\n",
      "22.9\n",
      "23.0\n",
      "23.1\n",
      "23.2\n",
      "23.3\n",
      "23.4\n",
      "23.5\n",
      "23.6\n",
      "23.7\n",
      "23.8\n",
      "23.9\n",
      "24.0\n",
      "24.1\n",
      "24.2\n",
      "24.3\n",
      "24.4\n",
      "24.5\n",
      "24.6\n",
      "24.7\n",
      "24.8\n",
      "24.9\n",
      "25.0\n",
      "25.1\n",
      "25.2\n",
      "25.3\n",
      "25.4\n",
      "25.5\n",
      "25.6\n",
      "25.7\n",
      "25.8\n",
      "25.9\n",
      "26.0\n",
      "26.1\n",
      "26.2\n",
      "26.3\n"
     ]
    }
   ],
   "source": [
    "if __name__=='__main__':\n",
    "    main()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5f2d9546-b40b-484c-9007-3d20f0a438d3",
   "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.8.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}