/** deletes the chosen attributes */
public void deleteAttributes() {
ListSelectorDialog dialog;
ArffSortedTableModel model;
Object[] atts;
int[] indices;
int i;
JList list;
int result;
list = new JList(getAttributes());
dialog = new ListSelectorDialog(null, list);
result = dialog.showDialog();
if (result != ListSelectorDialog.APPROVE_OPTION) return;
atts = list.getSelectedValues();
// really?
if (ComponentHelper.showMessageBox(
getParent(),
"Confirm...",
"Do you really want to delete these " + atts.length + " attributes?",
JOptionPane.YES_NO_OPTION,
JOptionPane.QUESTION_MESSAGE)
!= JOptionPane.YES_OPTION) return;
model = (ArffSortedTableModel) m_TableArff.getModel();
indices = new int[atts.length];
for (i = 0; i < atts.length; i++) indices[i] = model.getAttributeColumn(atts[i].toString());
setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
model.deleteAttributes(indices);
setCursor(Cursor.getPredefinedCursor(Cursor.DEFAULT_CURSOR));
}
/** calculates the mean of the given numeric column */
private void calcMean() {
ArffSortedTableModel model;
int i;
double mean;
// no column selected?
if (m_CurrentCol == -1) return;
model = (ArffSortedTableModel) m_TableArff.getModel();
// not numeric?
if (!model.getAttributeAt(m_CurrentCol).isNumeric()) return;
mean = 0;
for (i = 0; i < model.getRowCount(); i++)
mean += model.getInstances().instance(i).value(m_CurrentCol - 1);
mean = mean / model.getRowCount();
// show result
ComponentHelper.showMessageBox(
getParent(),
"Mean for attribute...",
"Mean for attribute '"
+ m_TableArff.getPlainColumnName(m_CurrentCol)
+ "':\n\t"
+ Utils.doubleToString(mean, 3),
JOptionPane.OK_CANCEL_OPTION,
JOptionPane.PLAIN_MESSAGE);
}
/** deletes the currently selected attribute */
public void deleteAttribute() {
ArffSortedTableModel model;
// no column selected?
if (m_CurrentCol == -1) return;
model = (ArffSortedTableModel) m_TableArff.getModel();
// really an attribute column?
if (model.getAttributeAt(m_CurrentCol) == null) return;
// really?
if (ComponentHelper.showMessageBox(
getParent(),
"Confirm...",
"Do you really want to delete the attribute '"
+ model.getAttributeAt(m_CurrentCol).name()
+ "'?",
JOptionPane.YES_NO_OPTION,
JOptionPane.QUESTION_MESSAGE)
!= JOptionPane.YES_OPTION) return;
setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
model.deleteAttributeAt(m_CurrentCol);
setCursor(Cursor.getPredefinedCursor(Cursor.DEFAULT_CURSOR));
}
/** sets the enabled/disabled state of the menu items */
private void setMenu() {
boolean isNumeric;
boolean hasColumns;
boolean hasRows;
boolean attSelected;
ArffSortedTableModel model;
boolean isNull;
model = (ArffSortedTableModel) m_TableArff.getModel();
isNull = (model.getInstances() == null);
hasColumns = !isNull && (model.getInstances().numAttributes() > 0);
hasRows = !isNull && (model.getInstances().numInstances() > 0);
attSelected = hasColumns && (m_CurrentCol > 0);
isNumeric = attSelected && (model.getAttributeAt(m_CurrentCol).isNumeric());
menuItemUndo.setEnabled(canUndo());
menuItemCopy.setEnabled(true);
menuItemSearch.setEnabled(true);
menuItemClearSearch.setEnabled(true);
menuItemMean.setEnabled(isNumeric);
menuItemSetAllValues.setEnabled(attSelected);
menuItemSetMissingValues.setEnabled(attSelected);
menuItemReplaceValues.setEnabled(attSelected);
menuItemRenameAttribute.setEnabled(attSelected);
menuItemDeleteAttribute.setEnabled(attSelected);
menuItemDeleteAttributes.setEnabled(attSelected);
menuItemSortInstances.setEnabled(hasRows && attSelected);
menuItemDeleteSelectedInstance.setEnabled(hasRows && m_TableArff.getSelectedRow() > -1);
menuItemDeleteAllSelectedInstances.setEnabled(
hasRows && (m_TableArff.getSelectedRows().length > 0));
}
/** sets the relation name */
private void createName() {
ArffSortedTableModel model;
model = (ArffSortedTableModel) m_TableArff.getModel();
if ((model != null) && (model.getInstances() != null))
m_LabelName.setText("Relation: " + model.getInstances().relationName());
else m_LabelName.setText("");
}
/**
* displays the given instances, i.e. creates a tab with the title TAB_INSTANCES. if one already
* exists it closes it.<br>
* if a different instances object is used here, don't forget to clear the undo-history by calling
* <code>clearUndo()</code>
*
* @param data the instances to display
* @see #TAB_INSTANCES
* @see #clearUndo()
*/
public void setInstances(Instances data) {
ArffSortedTableModel model;
m_Filename = TAB_INSTANCES;
createTitle();
model = new ArffSortedTableModel(data);
model.setShowAttributeIndex(m_ShowAttributeIndex);
m_TableArff.setModel(model);
clearUndo();
setChanged(false);
createName();
}
/**
* sets the current attribute as class attribute, i.e. it moves it to the end of the attributes
*/
public void attributeAsClass() {
ArffSortedTableModel model;
// no column selected?
if (m_CurrentCol == -1) return;
model = (ArffSortedTableModel) m_TableArff.getModel();
// really an attribute column?
if (model.getAttributeAt(m_CurrentCol) == null) return;
setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
model.attributeAsClassAt(m_CurrentCol);
setCursor(Cursor.getPredefinedCursor(Cursor.DEFAULT_CURSOR));
}
/**
* loads the specified file into the table
*
* @param filename the file to load
*/
private void loadFile(String filename) {
ArffSortedTableModel model;
this.m_Filename = filename;
createTitle();
if (filename.equals("")) {
model = null;
} else {
model = new ArffSortedTableModel(filename);
model.setShowAttributeIndex(getShowAttributeIndex());
}
m_TableArff.setModel(model);
setChanged(false);
createName();
}
/** renames the current attribute */
public void renameAttribute() {
ArffSortedTableModel model;
String newName;
// no column selected?
if (m_CurrentCol == -1) return;
model = (ArffSortedTableModel) m_TableArff.getModel();
// really an attribute column?
if (model.getAttributeAt(m_CurrentCol) == null) return;
newName =
ComponentHelper.showInputBox(
getParent(),
"Rename attribute...",
"Enter new Attribute name",
model.getAttributeAt(m_CurrentCol).name());
if (newName == null) return;
setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
model.renameAttributeAt(m_CurrentCol, newName);
setCursor(Cursor.getPredefinedCursor(Cursor.DEFAULT_CURSOR));
}
/**
* sets the specified values in a column to a new value
*
* @param o the menu item
*/
private void setValues(Object o) {
String msg;
String title;
String value;
String valueNew;
int i;
ArffSortedTableModel model;
value = "";
valueNew = "";
if (o == menuItemSetMissingValues) {
title = "Replace missing values...";
msg = "New value for MISSING values";
} else if (o == menuItemSetAllValues) {
title = "Set all values...";
msg = "New value for ALL values";
} else if (o == menuItemReplaceValues) {
title = "Replace values...";
msg = "Old value";
} else return;
value = ComponentHelper.showInputBox(m_TableArff.getParent(), title, msg, m_LastSearch);
// cancelled?
if (value == null) return;
m_LastSearch = value;
// replacement
if (o == menuItemReplaceValues) {
valueNew =
ComponentHelper.showInputBox(m_TableArff.getParent(), title, "New value", m_LastReplace);
if (valueNew == null) return;
m_LastReplace = valueNew;
}
model = (ArffSortedTableModel) m_TableArff.getModel();
model.setNotificationEnabled(false);
// undo
addUndoPoint();
model.setUndoEnabled(false);
String valueCopy = value;
// set value
for (i = 0; i < m_TableArff.getRowCount(); i++) {
if (o == menuItemSetAllValues) {
if (valueCopy.equals("NaN") || valueCopy.equals("?")) {
value = null;
}
model.setValueAt(value, i, m_CurrentCol);
} else if ((o == menuItemSetMissingValues) && model.isMissingAt(i, m_CurrentCol))
model.setValueAt(value, i, m_CurrentCol);
else if ((o == menuItemReplaceValues)
&& model.getValueAt(i, m_CurrentCol).toString().equals(value))
model.setValueAt(valueNew, i, m_CurrentCol);
}
model.setUndoEnabled(true);
model.setNotificationEnabled(true);
model.notifyListener(
new TableModelEvent(model, 0, model.getRowCount(), m_CurrentCol, TableModelEvent.UPDATE));
// refresh
m_TableArff.repaint();
}
