134 lines (133 with data), 6.8 kB

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['18_11.jpg', '208.0', '296.0', '258.0', '357.0', '0.2911624610424042']\n",
      "['18_13.jpg', '738.0', '423.0', '795.0', '467.0', '0.2909145653247833']\n",
      "['18_15.jpg', '738.0', '422.0', '795.0', '466.0', '0.29045653343200684']\n",
      "['18_17.jpg', '465.0', '531.0', '528.0', '578.0', '0.2906548082828522']\n",
      "['18_19.jpg', '298.0', '549.0', '353.0', '609.0', '0.29022112488746643']\n",
      "['18_8.jpg', '738.0', '422.0', '795.0', '467.0', '0.2899431884288788']\n",
      "['18_9.jpg', '336.0', '243.0', '385.0', '297.0', '0.2898823022842407']\n",
      "['48_10.jpg', '88.0', '331.0', '130.0', '388.0', '0.2898232340812683']\n",
      "['48_11.jpg', '88.0', '331.0', '130.0', '388.0', '0.2898780405521393']\n",
      "['48_12.jpg', '386.0', '520.0', '435.0', '575.0', '0.2898719906806946']\n",
      "['48_13.jpg', '659.0', '238.0', '719.0', '295.0', '0.28949129581451416']\n",
      "['48_15.jpg', '659.0', '238.0', '717.0', '295.0', '0.28971776366233826']\n",
      "['48_16.jpg', '118.0', '515.0', '169.0', '588.0', '0.2894532382488251']\n",
      "['48_17.jpg', '263.0', '742.0', '298.0', '789.0', '0.29015088081359863']\n",
      "['48_18.jpg', '148.0', '746.0', '203.0', '798.0', '0.29068365693092346']\n",
      "['48_19.jpg', '4.0', '592.0', '72.0', '637.0', '0.2893012464046478']\n",
      "['48_20.jpg', '381.0', '523.0', '431.0', '572.0', '0.2897922992706299']\n",
      "['48_21.jpg', '5.0', '592.0', '72.0', '637.0', '0.29115575551986694']\n",
      "['48_22.jpg', '428.0', '79.0', '494.0', '125.0', '0.29001638293266296']\n",
      "['48_23.jpg', '468.0', '245.0', '518.0', '297.0', '0.2891145646572113']\n",
      "['48_24.jpg', '-2.0', '585.0', '63.0', '632.0', '0.28915515542030334']\n",
      "['48_25.jpg', '152.0', '363.0', '215.0', '409.0', '0.29061159491539']\n",
      "['48_7.jpg', '418.0', '404.0', '448.0', '441.0', '0.290027916431427']\n",
      "['48_8.jpg', '534.0', '134.0', '585.0', '192.0', '0.2905958592891693']\n",
      "['48_9.jpg', '711.0', '697.0', '776.0', '745.0', '0.28961578011512756']\n",
      "['60_14.jpg', '594.0', '284.0', '664.0', '365.0', '0.28947460651397705']\n",
      "['60_16.jpg', '606.0', '337.0', '682.0', '397.0', '0.28926077485084534']\n",
      "['60_18.jpg', '743.0', '611.0', '806.0', '702.0', '0.28901904821395874']\n",
      "['60_28.jpg', '598.0', '780.0', '676.0', '843.0', '0.2902340292930603']\n",
      "['60_30.jpg', '922.0', '879.0', '1004.0', '940.0', '0.28981614112854004']\n",
      "['60_32.jpg', '922.0', '879.0', '1004.0', '940.0', '0.28984081745147705']\n",
      "['60_33.jpg', '320.0', '690.0', '389.0', '740.0', '0.28983402252197266']\n",
      "['18_11.jpg', '208.0', '296.0', '258.0', '357.0', '0.2911624610424042']\n",
      "['18_11.jpg', '466.0', '532.0', '530.0', '579.0', '0.2912897765636444']\n",
      "['18_13.jpg', '466.0', '532.0', '529.0', '579.0', '0.29152265191078186']\n",
      "['18_15.jpg', '465.0', '532.0', '528.0', '578.0', '0.2908957600593567']\n",
      "['18_17.jpg', '398.0', '569.0', '448.0', '622.0', '0.29098832607269287']\n",
      "['18_19.jpg', '465.0', '532.0', '528.0', '579.0', '0.29113078117370605']\n",
      "['18_8.jpg', '461.0', '545.0', '511.0', '598.0', '0.2914581298828125']\n",
      "['18_9.jpg', '461.0', '543.0', '511.0', '599.0', '0.2913969159126282']\n",
      "['48_10.jpg', '5.0', '592.0', '72.0', '637.0', '0.29090407490730286']\n",
      "['48_11.jpg', '5.0', '592.0', '72.0', '637.0', '0.29123061895370483']\n",
      "['48_12.jpg', '5.0', '592.0', '72.0', '637.0', '0.2909379005432129']\n",
      "['48_13.jpg', '5.0', '592.0', '72.0', '637.0', '0.29099398851394653']\n",
      "['48_15.jpg', '733.0', '173.0', '787.0', '228.0', '0.2898068428039551']\n",
      "['48_16.jpg', '732.0', '173.0', '786.0', '227.0', '0.2896701693534851']\n",
      "['48_17.jpg', '454.0', '250.0', '513.0', '291.0', '0.2905231714248657']\n",
      "['48_18.jpg', '453.0', '250.0', '512.0', '291.0', '0.2907674014568329']\n",
      "['48_19.jpg', '454.0', '250.0', '512.0', '291.0', '0.29284656047821045']\n",
      "['48_20.jpg', '454.0', '250.0', '511.0', '292.0', '0.2915771007537842']\n",
      "['48_21.jpg', '454.0', '251.0', '512.0', '291.0', '0.2926853895187378']\n",
      "['48_22.jpg', '454.0', '250.0', '511.0', '292.0', '0.2910589277744293']\n",
      "['48_23.jpg', '642.0', '515.0', '712.0', '563.0', '0.28916531801223755']\n",
      "['48_24.jpg', '154.0', '364.0', '216.0', '410.0', '0.2895817756652832']\n",
      "['48_25.jpg', '4.0', '592.0', '71.0', '637.0', '0.29073914885520935']\n",
      "['48_7.jpg', '376.0', '312.0', '430.0', '376.0', '0.29011330008506775']\n",
      "['48_8.jpg', '6.0', '592.0', '72.0', '637.0', '0.2906933128833771']\n",
      "['48_9.jpg', '5.0', '592.0', '72.0', '637.0', '0.29073986411094666']\n",
      "['60_14.jpg', '638.0', '761.0', '704.0', '827.0', '0.2900906503200531']\n",
      "['60_16.jpg', '416.0', '780.0', '486.0', '855.0', '0.29022786021232605']\n",
      "['60_18.jpg', '422.0', '798.0', '488.0', '864.0', '0.28969600796699524']\n",
      "['60_28.jpg', '728.0', '631.0', '804.0', '688.0', '0.2906843423843384']\n",
      "['60_30.jpg', '599.0', '779.0', '675.0', '846.0', '0.2900954484939575']\n",
      "['60_32.jpg', '551.0', '711.0', '635.0', '790.0', '0.2899249196052551']\n",
      "['60_33.jpg', '726.0', '631.0', '804.0', '689.0', '0.2900634706020355']\n",
      "['18_11.jpg', '466.0', '532.0', '530.0', '579.0', '0.2912897765636444']\n"
     ]
    }
   ],
   "source": [
    "with open('merged_result.csv', 'w') as f:\n",
    "    writer = csv.writer(f)\n",
    "    for i in range(1, 3):\n",
    "        with open('result' + str(i) + '.csv', 'r') as file:\n",
    "            reader = csv.reader(file)\n",
    "            l = list(reader)\n",
    "            for j in range(len(l)):\n",
    "                l[j][0] = l[j][0].split('/')[-1]\n",
    "                print(l[j])\n",
    "                writer.writerow(l[j])\n",
    "                "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}