search

biolab / orange3

🍊 :bar_chart: :bulb: Orange: Interactive data analysis
https://orangedatamining.com
Other
4.85k stars 1.01k forks source link

Merge more than one table source through "merge widget" #5511

Closed FD81 closed 3 years ago

FD81 commented 3 years ago

What's your use case?

I want to merge several tables into one, right now it seems like one max two tables can be merged. The reason is that I have my data organized in 15 separate tables (one per year of data) and now I want a table which brings together all year and merge the variables that have the same name while appending variables that are not available in all tables.

What's your proposed solution? Make the merge widget more flexible, when adding extra data allow for multiple tables to be connected to the merge widget.

Are there any alternative solutions?

I think right now something similar can be done with "concatenate" but it's not as direct and there does not seem to be a good reason to prevent "merge" from merging multiple data sources.

janezd commented 3 years ago

I think that Merge could do this in principle, but it would require writing it from scratch. Its entire code is written with just two tables in mind (and is already complicated as it is).

But if I understand correctly, what you try to do is exactly Concatenate, isn't it? You'd like to put data from different years into a single table, like pasting it together vertically? Can you provide more details about why Concatenate doesn't help?

FD81 commented 3 years ago

Thanks for your answer, if you see the screenshot, I am trying to merge a number of tables into one, vertically as you say, and overlapping variables should appear only once in the output. Concatenate seems a bit elaborate as a method for doing this, Merge appeared to be more direct and transparent as a method. Also, Concatenate requires me to transpose the table to do things, I am not sure it would be the same with Merge. Any thought much appreciated, thanks. Screenshot (49)_LI

janezd commented 3 years ago

I am sorry to disappoint you, but Merge data will not be extended to merge more than two tables; this would require a complete rewrite and also rethinking its functionality and interface. This would, basically, be a new widget. I understand your frustration with having to transpose every table separately, but there's not much we can reasonably do here.

FD81 commented 3 years ago

Thanks anyway! FD

On Fri, Oct 22, 2021 at 2:37 PM Janez Demšar @.***> wrote:

I am sorry to disappoint you, but Merge data will not be extended to merge more than two tables; this would require a complete rewrite and also rethinking its functionality and interface. This would, basically, be a new widget. I understand your frustration with having to transpose every table separately, but there's not much we can reasonably do here.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/biolab/orange3/issues/5511#issuecomment-949592140, or unsubscribe https://github.com/notifications/unsubscribe-auth/AUUUMTRRBR2QIKNNLP4737DUIFLIDANCNFSM47WVBEBA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.