--- a +++ b/AnalysisCodes/SSD/mergeCsv.ipynb @@ -0,0 +1,133 @@ +{ + "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 +}