How to customize Merge Equivalent Rows [message #2207] |
Thu, 23 May 2024 06:44 |
yuan
Messages: 6 Registered: May 2024
|
Junior Member |
|
|
Hi Thomas,
Datawarrior is a very useful open-source cheminformatics tools. Thanks for sharing it.
We wanted to use it organize experiment data by merging different assay results. When we used merge equivalent rows, we found that except for selected column(s) for equivalent check, other columns with the same values were also merged as a single value. Can we keep them individual or modify this function to let user determine whether merging equivalent values?
Many thanks!
Yuan
|
|
|
Re: How to customize Merge Equivalent Rows [message #2209 is a reply to message #2207] |
Thu, 23 May 2024 22:12 |
thomas
Messages: 711 Registered: June 2014
|
Senior Member |
|
|
Hi Yuan,
thanks you for the hint. Of course, your suggestion makes a lot of sense. I have update the source code now to offer three options:
- 'remove duplicates', which is similar to the current handling: if the cells to be merged all contain the same value,
then this value is placed into the merged cell only once. Otherwise we see all entries in original order
- 'keep duplicates', which is your suggested handling: we always see all entries in original order
- 'depend on columns groups', which assumes that related columns, e.g. result columns of one assay, are grouped using
the column grouping feature. Then it checks, whether all cells of the same column group are equal and only then it
removes for all these columns the same entry.
In the next version this will go live...
Thomas
|
|
|
|
Re: How to customize Merge Equivalent Rows [message #2214 is a reply to message #2212] |
Fri, 24 May 2024 15:50 |
thomas
Messages: 711 Registered: June 2014
|
Senior Member |
|
|
I prepared a test file for you. You can download it from https://openmolecules.org/datawarrior/datawarrior_v06.02.02a lpha.jar Then copy it into your datawarrior update folder. On Windows this is C:\\ProgramData\DataWarrior\
The standard procedure to test any non-yet-released functionality would be:
On a Linux or MacOS computer with JDK21/JFX (I suggest Liberica full JDK 21) installed clone the DataWarrior project from Github and build the jar file:
> git clone https://github.com/thsa/datawarrior
> buildDataWarrior
Then rename the built 'datawarrior_all.jar' file to any version newer than the current one, e.g. 'datawarrior_v06.02.02.jar' and put it into your datawarrior update folder, where the other automatic updates are located. This works on any platform (Linux, Mac, or Windows). If you then launch DataWarrior, it will use this version. Don't forget to remove the file after testing it.
[Updated on: Fri, 24 May 2024 15:53] Report message to a moderator
|
|
|
|
|