Effacer les filtres
Effacer les filtres

move data from table to another table

3 vues (au cours des 30 derniers jours)
abdullah al-dulaimi
abdullah al-dulaimi le 30 Oct 2022
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.

Réponse acceptée

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

Plus de réponses (0)

Catégories

En savoir plus sur Tables dans Help Center et File Exchange

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by