search

biolab / orange3

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

Widget save data shuffle the table columns #6180

Closed EGalloni closed 1 year ago

EGalloni commented 2 years ago

Hi I'm just starting using Orange and I realised that the widget "Save Data" when writing the xcel file shuffle the columns.. image

This is how the Save data sees the input table (just the first columns image

This is how it is going on the file

image

What's wrong?

How can we reproduce the problem?

What's your environment?

janezd commented 2 years ago

Ha!

Data tables have three kinds of columns: "attributes", "class(es)" and "meta attributes". The order is defined only within each group. If the data in the file contains a mixture of the three (e.g. meta attributes, class, another meta attribute, attribute, meta attribute ...), this order is lost -- except that columns within each group will maintain their relative order.

This is indeed a discrepancy. The latter was the original order, which was also used by Table, but at some point we changed it. In other words, Save does not change the order, it just uses a different order. :) File widget, on the other hand, just forgets the order.

Thanks for your observation. We definitely need to discuss this.

EGalloni commented 2 years ago

Thank you for the quick response! Got you..it would be nice in future to be able edit how the table is saved, you have fantastic graphic features but sometime also the text needs to have its form :)

Il giorno ven 21 ott 2022 alle ore 15:24 Janez Demšar < @.***> ha scritto:

Ha!

Data tables have three kinds of columns: "attributes", "class(es)" and "meta attributes". The order is defined only within each group. If the data in the file contains a mixture of the three (e.g. meta attributes, class, another meta attribute, attribute, meta attribute ...), this order is lost -- except that columns within each group will maintain their relative order.

  • Table widget always shows class variables, followed by meta attributes, followed by ordinary attributes.
  • Save widget always saves attributes, followed by classes, followed by meta attributes.

This is indeed a discrepancy. The latter was the original order, which was also used by Table, but at some point we changed it. In other words, Save does not change the order, it just uses a different order. :) File widget, on the other hand, just forgets the order.

Thanks for your observation. We definitely need to discuss this.

— Reply to this email directly, view it on GitHub https://github.com/biolab/orange3/issues/6180#issuecomment-1286958169, or unsubscribe https://github.com/notifications/unsubscribe-auth/A3XYXFW2OEYDQDZMCU6XXDLWEKKSJANCNFSM6AAAAAARLFCSCM . You are receiving this because you authored the thread.Message ID: @.***>

janezd commented 1 year ago

Decision: Save data will use the same order as the Table widget.