EMMAWiki/WebDocumentation/HowTos/DatasetBrowserHowTo: Difference between revisions

From BRF-Software
Jump to navigation Jump to search
imported>SebastianJuenemann
No edit summary
imported>SebastianJuenemann
No edit summary
Line 13: Line 13:
== Select Dataset(s) ==
== Select Dataset(s) ==


The following imgage shows the dialog whith three examples of a raw datasets of a current experiment. Each dataset has an unique Identifier, a self explainig Name and if available a short Description. The Cube-Order, #BA-Dim,. #DE-Dim and #QT-Dim gives you information about the size and range of the dataset:
The following image shows the dialog with three examples of a raw datasets of a current experiment. Each dataset has an unique Identifier, a self explaining Name and if available a short description. The Cube-Order, #BA-Dim,. #DE-Dim and #QT-Dim gives you information about the size and range of the dataset:
* Cube-Order: lay down the following order but is at current state always '''BDQ''',
* Cube-Order: lay down the following order but is at current state always '''BDQ''',
* #'''B'''A-Dim: show how many arrays were used from this dataset and is also at current state always one,
* #'''B'''A-Dim: show how many arrays were used from this dataset and is also at current state always one,
* #'''D'''E-Dim: shows how many Designelements were used and stands for the number of rows,
* #'''D'''E-Dim: stands for the number of rows. Shows how many Designelements were used.
* #'''Q'''T-Dim: shows how many Quantitationtypes were used and stands for the number of columns.
* #'''Q'''T-Dim: stands for the number of columns. Shows how many Quantitationtypes were used.


The Quality is an index for the user (ranges from very good to insufficient).
The Quality is an index for the user. It ranges from very good to insufficient.


[[Image:EMMAWiki$$WebDocumentation$$HowTos$$DatasetBrowserHowTo$brows2_dataset_dialog.png]]  
[[Image:EMMAWiki$$WebDocumentation$$HowTos$$DatasetBrowserHowTo$brows2_dataset_dialog.png]]  
Line 27: Line 27:


   === Coincid [[QuantitationType]]-Selection ===
   === Coincid [[QuantitationType]]-Selection ===
   The ''Common Label/Column Selection'' button let you take a preselection of Quantitationtypes which leads in the dialog shown below. Thus you decide for all
   The ''Common Label/Column Selection'' button let you take a preselection of Quantitationtypes which leads to the dialog box (shown below). Thus you can decide which Quantitationtype should be shown for all selected datasets at once. You can get more information about each Quantitationtype by following the link.
  selected dataset at once which Quantitationtype should be shown. You can get more information about each Quantitationtype by following the link.


   [[Image:EMMAWiki$$WebDocumentation$$HowTos$$DatasetBrowserHowTo$browse_dataset_dialog_preselection.png]]
   [[Image:EMMAWiki$$WebDocumentation$$HowTos$$DatasetBrowserHowTo$browse_dataset_dialog_preselection.png]]


   === Individual [[QuantitationType]]-Selection ===
   === Individual [[QuantitationType]]-Selection ===
   A more sensitive preselection occour if you click the ''Individual Label/Column Selection'' button. Thus you decide not for all at once but for every selected
   A more sensitive preselection can be made if you click the ''Individual Label/Column Selection'' button. Here you can select which Quantitationtype you want for each
   dataset individual which Quantitationtype you want. The dialog is almost se same as shown above but as many as selected datasets.
   dataset. The dialog box is almost the same as the one shown above and includes all selected datasets.


<span id="browse_dataset"></span>
<span id="browse_dataset"></span>
== View Dataset(s) ==
== View Dataset(s) ==
The datasets are shown as one table which can be easily browsed with the navigation bar. Each [[DesignElement]] and Quantitationtype is linked for getting detailed information.
The datasets are shown as one table which can be browsed easily with the navigation bar. Each [[DesignElement]] and Quantitationtype is linked for further detailed information.


[[Image:EMMAWiki$$WebDocumentation$$HowTos$$DatasetBrowserHowTo$browse_dataset_de_range.png]]
[[Image:EMMAWiki$$WebDocumentation$$HowTos$$DatasetBrowserHowTo$browse_dataset_de_range.png]]
[[Image:EMMAWiki$$WebDocumentation$$HowTos$$DatasetBrowserHowTo$browse_dataset_table2.png]]
[[Image:EMMAWiki$$WebDocumentation$$HowTos$$DatasetBrowserHowTo$browse_dataset_table2.png]]


   === Range Designelements ===
   === Dimension Range ===
   The first section of this window is for specifying how many [[DesignElements]] are shown each page. Enter a start and end position in the Dimension-Range label to jump to this
   The first section of this window is for specifying how many rows ([[DesignElements]]) are shown in each page. Entering a start and end position in the Dimension-Range field enables you to go to the given position. With this option you can also set the number of Designelements per page. The field named ''Search'' offers you a simple possibility to restrict the Designelements by the Identifier.  
  position and also to commit the number of Designelements per page. The Search label offers you a simple possibility to restrict the Designelements by the Identifier.  


   === Sort by Quantitationtypes ===
   === Sort by Quantitationtypes ===
   The blue arrows in the first row of the table let you sort the dataset ascendending or descendending. Also you can choose to sort only the currently shown page or the whole
   The blue arrows in the first row of the table let you sort the dataset in ascendending or descendending order. Also you can choose between sorting the current shown page or the whole
   dataset(s) by switching the radio buttons above the table between '''Sort only this page''' or '''Sort whole dataset'''. If you decide to sort the whole dataset the  
   dataset(s) by switching the radio button above the table between '''Sort only this page''' or '''Sort whole dataset'''. If you pick the option ''whole dataset'' the  
   assortion remains while browsing the dataset until you click '''Drop Assortment'''.
   assortion remains while browsing the dataset until you click '''Drop Assortment'''.
  of your table.


   === Filter Data ===
   === Filter Data ===
   The button '''filter data''' opens a new window where you are able to filter the dataset. Start to single out the whished Quantitationtype in the first drop-down menu then
   The button '''filter data''' opens a new window where you are able to filter the dataset. Start to single out the whished Quantitationtype in the first drop-down menu then
   select an operator and leave the value for the comparison in the right text field. If you want to filter for more than one Quantitationtype or one Quantitationtype with  
   select an operator and leave the value for the comparison in the right text field. If you want to filter for more than one Quantitationtype or one Quantitationtype with  
   different  operation you have to chose '''AND''' at the first drop-down menu of ervery next line you want to include. The More button leads in as many new lines you want.
   different  operation you have to chose '''AND''' at the first drop-down menu of each next line you want to include. The More button leads in as many new lines you want.
   As by the sorting the filter keeps by as long until '''Drop Assortment'''. You can reactivate the sorting/filtering by pressing the '''Keep Assortment''' button. This way  
   As by the sorting the filter keeps by as long until '''Drop Assortment'''. You can reactivate the sorting/filtering by pressing the '''Keep Assortment''' button. This way  
   you switch between the raw dataset and your last performed sorting/filtering.
   you switch between the raw dataset and your last performed sorting/filtering.

Revision as of 06:30, 3 February 2005

Browse DataSets

This Section describes the use of the Dataset Browser. A description of shared terms can be found in HelpSystem and shortcuts are explained in Ontology.

This Howto is divided in 2 subsections (chronological by menu prompt):

Select Dataset(s)

The following image shows the dialog with three examples of a raw datasets of a current experiment. Each dataset has an unique Identifier, a self explaining Name and if available a short description. The Cube-Order, #BA-Dim,. #DE-Dim and #QT-Dim gives you information about the size and range of the dataset:

  • Cube-Order: lay down the following order but is at current state always BDQ,
  • #BA-Dim: show how many arrays were used from this dataset and is also at current state always one,
  • #DE-Dim: stands for the number of rows. Shows how many Designelements were used.
  • #QT-Dim: stands for the number of columns. Shows how many Quantitationtypes were used.

The Quality is an index for the user. It ranges from very good to insufficient.

File:EMMAWiki$$WebDocumentation$$HowTos$$DatasetBrowserHowTo$brows2 dataset dialog.png 

 === Show ===
 Clicking the Show All button shows the selected dataset(s) in one table as described in View Dataset(s).

 === Coincid QuantitationType-Selection ===
 The Common Label/Column Selection button let you take a preselection of Quantitationtypes which leads to the dialog box (shown below). Thus you can decide which Quantitationtype should be shown for all selected datasets at once. You can get more information about each Quantitationtype by following the link.

 File:EMMAWiki$$WebDocumentation$$HowTos$$DatasetBrowserHowTo$browse dataset dialog preselection.png

 === Individual QuantitationType-Selection ===
 A more sensitive preselection can be made if you click the Individual Label/Column Selection button. Here you can select which Quantitationtype you want for each
 dataset. The dialog box is almost the same as the one shown above and includes all selected datasets.

View Dataset(s)

The datasets are shown as one table which can be browsed easily with the navigation bar. Each DesignElement and Quantitationtype is linked for further detailed information.

File:EMMAWiki$$WebDocumentation$$HowTos$$DatasetBrowserHowTo$browse dataset de range.png File:EMMAWiki$$WebDocumentation$$HowTos$$DatasetBrowserHowTo$browse dataset table2.png 

 === Dimension Range ===
 The first section of this window is for specifying how many rows (DesignElements) are shown in each page. Entering a start and end position in the Dimension-Range field enables you to go to the given position. With this option you can also set the number of Designelements per page. The  field named Search offers you a simple possibility to restrict the Designelements by the Identifier. 

 === Sort by Quantitationtypes ===
 The blue arrows in the first row of the table let you sort the dataset in ascendending or descendending order. Also you can choose between sorting the current shown page or the whole
 dataset(s) by switching the radio button above the table between Sort only this page or Sort whole dataset. If you pick the option whole dataset the 
 assortion remains while browsing the dataset until you click Drop Assortment.

 === Filter Data ===
 The button filter data opens a new window where you are able to filter the dataset. Start to single out the whished Quantitationtype in the first drop-down menu then
 select an operator and leave the value for the comparison in the right text field. If you want to filter for more than one Quantitationtype or one Quantitationtype with 
 different  operation you have to chose AND at the first drop-down menu of each next line you want to include. The More button leads in as many new lines you want.
 As by the sorting the filter keeps by as long until Drop Assortment. You can reactivate the sorting/filtering by pressing the Keep Assortment button. This way 
 you switch between the raw dataset and your last performed sorting/filtering.

 File:EMMAWiki$$WebDocumentation$$HowTos$$DatasetBrowserHowTo$browse dataset filter.png

 The following operators available:
  • > : greater
  • < : less than
  • >=: greater or equal
  • <= : less or equal
  • != : not equal
  • approx value epsilon : get all values approximately equal to value within an range of +/-epsilon (default 0.001). e.g.:
 approx 10 0.1 will return all rows where the selected column value is between 9.9 and 10.1
  • not missing : filter rows where selected column has a good value (not NaN)
  • missing : the opposite, return all rows with missing values
 === Export ===
 It is possible to download the dataset as a tab seperated text file. You can either export the foltered/sorted dataset ore the whole dataset.
Retrieved from "https://wiki.cebitec.uni-bielefeld.de/brf-software/index.php?title=EMMAWiki/WebDocumentation/HowTos/DatasetBrowserHowTo&oldid=2999"