move data from table to another table

table A

imageFilename xmin ymin xmax ymax

________________________________________________________ ____ ____ ____ ____

<undefined> NaN NaN NaN NaN

Japan_001164_jpg.rf.c02ee7802c701e228f23a4033eb236c2.jpg 384 383 415 406

Japan_001164_jpg.rf.c02ee7802c701e228f23a4033eb236c2.jpg 0 356 24 370

Japan_000464_jpg.rf.c044f7911ab9d249c6c8a76960df4a16.jpg 167 250 194 276

Japan_000464_jpg.rf.c044f7911ab9d249c6c8a76960df4a16.jpg 8 216 192 303

: : : : :

<undefined> NaN NaN NaN NaN

Japan_002633_jpg.rf.ffc57474b16a7473f4fb529a1756e6d4.jpg 2 359 415 400

Japan_000702_jpg.rf.ffd55face76a5c9777e2c932040bd76e.jpg 155 237 415 407

Japan_001245_jpg.rf.ffdbc74f289404b5a1a0a85ef129b099.jpg 138 350 186 415

Japan_002971_jpg.rf.fffb1b54fa6ac85f713f260ddf55d2bf.jpg 326 327 412 398

table B

imageFilename Damage

____________________________________________________________________________________________ ____________

{'C:\Users\msi-pc\Desktop\Training\New folder (2)\train\Japan_000001_jpg.rf.7b3ecaac169c998a18815a31934dbbea.jpg'} {0×0 cell }

{'C:\Users\msi-pc\Desktop\Training\New folder (2)\train\Japan_000002_jpg.rf.8b2f18385d91f7f153ec3b2cef9919fe.jpg'} {0×0 double}

{'C:\Users\msi-pc\Desktop\Training\New folder (2)\train\Japan_000003_jpg.rf.f3c31ddc4b9cbb2318bbe627c8216f5c.jpg'} {0×0 double}

{'C:\Users\msi-pc\Desktop\Training\New folder (2)\train\Japan_000004_jpg.rf.04ab477207524f235d83273d209f72dc.jpg'} {0×0 double}

{'C:\Users\msi-pc\Desktop\Training\New folder (2)\train\Japan_000005_jpg.rf.e30a687561478bc9ae4b02b44a320f09.jpg'} {0×0 double}

: :

{'C:\Users\msi-pc\Desktop\Training\New folder (2)\train\Japan_003518_jpg.rf.9c7ab431be1378f18227090af1404005.jpg'} {0×0 double}

{'C:\Users\msi-pc\Desktop\Training\New folder (2)\train\Japan_003520_jpg.rf.8c04817cf1546876d44740e8af566183.jpg'} {0×0 double}

{'C:\Users\msi-pc\Desktop\Training\New folder (2)\train\Japan_003521_jpg.rf.8b4431e1e7f2195ee5c8bbc96b549239.jpg'} {0×0 double}

{'C:\Users\msi-pc\Desktop\Training\New folder (2)\train\Japan_003522_jpg.rf.9f321c4ce55db3cd9ec8de0de07e02dc.jpg'} {0×0 double}

{'C:\Users\msi-pc\Desktop\Training\New folder (2)\train\Japan_003525_jpg.rf.5667c6c7dcd5c83636faa66db429712b.jpg'} {0×0 double}

I want to move data of table A (xmin ymin xmax ymax) to damage in table B that have a same imageFilename, as you can see Japan_002633_jpg.rf.ffc57474b16a7473f4fb529a1756e6d4.jpg have 4 raws in Table A but have 1 raw in table B.

at last i have many raws so i want want to move all this raws automatically.

Answer 1

[Image Analyst]

Try outerjoin to add columns from a table A to an existing table B.