Menus¶
This page briefly summarizes mapdata’s menu items and their actions.
File Menu¶
- Open CSV
Prompts for a new CSV data file to display, including the names of columns containing geographic coordinates and optionally additional data. The prompt is described in the Open CSV section.
- Open spreadsheet
Prompts for a new spreadsheet file and sheet name to display, including the names of columns containing geographic coordinates and optionally additional data. The prompt is described in the Open spreadsheet section.
- Open database
Prompts for a new database and table to display, including the names of columns containing geographic coordinates and optionally additional data. The prompt is described in the Open database section.
- Import symbol
Prompts for a symbol name and a file with a new bitmap symbol that can be used to mark selected locations on the map. The prompt is described in the Import symbol section.
- Set editor
Prompts for the name of a text editor that may be used to edit a script file when data are loaded from a database.
- Read config
Prompts for the name of a configuration file and imports it. This may result in changes to the available symbols, the basemap, and other defaults.
- Save config
Prompts for the name of a file to which the current configuration values will be saved. The configuration file that is created will contain current configuration specifications, which may have resulted from reading of multiple configuration files on startup, further configuration files read using the File / Read config menu item, and the current selection marker specified using the Map / Settings menu item. The configuration file that is created will not include any configuration settings that correspond to command-line arguments.
- Quit
Exits mapdata.py.
Table Menu¶
- Un-select all
Removes all selection markers from the map and all highlights from the table. This is the same action that is carried out by the “Un-select” button above the map and by the Map / Un-select all menu item.
- Export selected
Prompts for the name of a CSV or ODS (OpenDocumenet Spreadsheet) file, and exports to that file all of the selected rows of the data table. If an existing CSV file is selected, that file will be replaced. If an existing ODS file is selected, a new worksheet will be appended to that file. If the displayed data file has coordinates that are projected into some CRS other than 4326, the data file will have additional columns containing location coordinates in WGS84 (i.e., CRS 4326).
- Data types
Displays a table of the data type for each column, including the number of missing values and the number of unique values in each column. Compilation of these statistics is begun when mapdata.py starts, and is carried out as a background process. If the evaluation of data types is not complete when the table of data types is requested, a notice will be displayed indicating that evalution of data types is still ongoing. When this evaluation is complete, the notice will disappear and the table will appear.
- Hide/show columns
Displays a dialog with checkboxes that allow selection of the columns to be shown in the table below the map. At least one column must be shown.
- Counts by location
Displays a table with one row for each unique combination of latitude and longitude values in the data set. Each row contains a latitude value, a longitude value, and a count of the number of rows in the data set with those coordinates. If there are any text columns in the data set containing values that have a 1:1 relationship with the coordinates (that is, there is a unique value for each unique set of coordinates), those columns will also be included in the table.
- Find candidate keys
Opens a dialog that allow exploration of whether selected columns make up a candidate key, either for the entire data table or for just selected rows.
- Recode data
Opens a dialog that prompts for a column name and an expression, and populates the column with the expression’s value. A new or existing column may be selected, and the expression may be applied only to selected rows or rows where the data value is missing.
- Add unique row IDs
Opens a dialog that prompts for the name of a new column that will contain a unique row ID for each row in the data table.
Map Menu¶
- Zoom selected
Adjusts the displayed map extent to focus on the selected locations. If only a single location is selected, the map will be centered on that location but the zoom level will remain unchanged.
- Zoom full
Adjusts the displayed map extent so that all locations in the data file are shown. This is the same extent that is initially shown when a data file is loaded.
- Center on selection
Adjusts the displayed map extent so that the most recently selected location is in the center of the map.
- Un-select all
Removes all selection markers from the map and all highlights from the table. This is the same action that is carried out by the “Un-select” button above the map and by the Table / Un-select all menu item.
- Change CRS
Prompts for a new coordinate reference system (CRS) to be applied to the map. This prompt is illustrateed in the Change CRS section.
- Export
Prompts for the name of a Postscript, PNG, or JPEG file, and exports the displayed map to that file as an image. If an existing file is selected, that file will be replaced.
- Settings
Opens the Map Settings dialog, which allows the appearance of location markers, selection markers, and count labels to be modified.
Selections Menu¶
- Invert
Inverts, or reverses, all selections on the map and table. All data values that are selected will be un-selected, and all un-selected data values will be selected.
- Un-select all
Removes all selection markers from the map and all highlights from the table. This is the same action that is carried out by the “Un-select” button above the map and by the Table / Un-select all menu item.
- Data query
Prompts for a query expression that will be used to select data values to be highlighted in the table and on the map. Multiple data values may be selected using a query expression, so the map is automatically switched to Multi-select mode if it was in single-select mode.
After a query expression is used to select data values, additional data values may then also be selected by clicking in the table or on the map.
The prompt for the query expression is illustrated and described in the Query Data section.
- Co-located data
Prompts for criteria to select the number of spatially co-located data observations, and then highlights all matching data rows in the table and on the map. The map is automatically switched to Multi-select mode.
Data that are selected can replace already-selected data, or be combined with already-selected data by union, intersection, or difference.
The prompt for selection criteria is illustrate in the Co-located Data Dialog section.
- Random
Prompts for the number of data rows to randomly select. Rows may be selected from the entire data set or from the previously selected subset. The randomly selected subset will replace any currently selected subset.
Plot Menu¶
- New
Opens a new dialog for displaying single data plots such as scatter plots, line charts, and bar charts. The type of plot to produce is selected on that dialog window. The types of plots available are decribed on the Data Plots page. A new plot dialog can also be opened from the main application with the Alt-G keystroke.
- Pair plot
Opens a new dialog to display a matrix of data plots consisting of scatter plots of all pairs of selected variables.
- Close all
Closes all open plot windows.
- Settings
Displays a dialog that allows customization of certain aspects of the appearance of plots. Other plot configuration options can be changed by using hotkeys while a plot is shown.
Statistics Menu¶
- Univariate statistics
Opens a dialog that lists all of the quantitative variables in the data set and displays univariate statistics (e.g., mean, median) for all selected variables.
- Fit univariate distribution
Opens a dialog that prompts for a numeric variable and a type of univariate distribution to be fit to the values of that variable, and then displays a histogram of the data with the fitted distribution and statistics describing the fit.
- Bivariate statistics
Opens a dialog that prompts for two numeric variables and then displays several descriptive statistics about the relationship and a scatter plot with a regression line.
- Correlation matrix
Opens a dialog that prompts for selection of two or more numeric variables, and displays a matrix of Pearson’s r correlation coefficients for all pairs of variables.
- Contingency table
Opens a dialog that prompts for two variables, and criteria to subdivide them into ‘positive’ and ‘negative’ groups, and then display a contingency table for the four variable groups, with statistical tests of independence and conditional probabilities.
- ROC curve
Opens a dialog that prompts for a condition variable and a predictor variable, and displays a Receiver Operating Characteristic (ROC) curve and ROC statistics for a specific threshold value of the predictor variable.
- t-SNE analysis
Opens a dialog that prompts for a set of numeric variables and then carries out a t-Distributed Stochastic Neighbor Embedding (t-SNE) analysis (van der Maaten and Hinton, 2008).
- UMAP analysis
Opens a dialog that prompts for a set of numeric variables and then carries out a Uniform Manifold Approximation and Projection (UMAP) analysis (McInnes et al., 2020).
- Categ. corresp.
Opens a dialog that prompts for two different categorical variables and then displays a table showing all unique combinations of those variables, including missing values, and the number and percentage of data rows associated with each combination. This summary can be produced for all data rows or for only the selected data rows.
Help Menu¶
- Online help
Displays this online help, opening initially to the Home page.
- Config files
Displays a dialog box listing all of the configuration files that were read either on startup or subsequently (i.e., from use of the File / Read config menu item).
- Hotkeys
Displays a dialog box lising all of the hotkeys and their actions.
- About
Displays a dialog box containing the software version number and copyright notice.