move data from table to another table

3 次查看（过去 30 天）
abdullah al-dulaimi
abdullah al-dulaimi 2022-10-30
回答： Image Analyst 2022-10-30
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.

请先登录，再回答此问题。

采纳的回答

Image Analyst
Image Analyst 2022-10-30
Try outerjoin to add columns from a table A to an existing table B.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by