CSVOMATIC version 3:
python CSVOMATIC.py mary.csv
will load the file "mary.csv" from the git repo
----------------------------------MAIN WINDOW----------------------------------
In the menus, each line with "FIND GRID" opens up the CSV editor.
menus:
File, open - opens a file
File, save - saves your file
File, exit - quits program
Row, drop - deletes specified range of lines/rows from data
Row, view - opens viewing/editing window on range of rows in data "FIND GRID"
Options -
Reset - reset the list of selected rows
View - view all selected rows(cols 0-end) "FIND GRID"
Delete - erase selected rows from list
Column, drop - deletes specified column range from data
Column, view - opens viewing/editing for range of columns "FIND GRID"
Options -
Reset - reset the list of selected columns
View - view the selected columns (row 0-end) "FIND GRID"
Delete - erase the selected columns from data
Data, find data - uses regex to view matching data in editor and marks their location "FIND GRID"
Data, import data - imports data from the main window
Data, export data - exports data to the main window
Data, db query - runs postgresql query and imports results
*FEATURE REQUIRES PSYCOPG2(or nothing happens)
Data, Clear Matches - erases all the location marks on the data grid
-----------------------------------FIND GRID---------------------------------------
CSV editor, titled "FIND GRID" can do the following:
When it fires up, it will select the previous selections you had made in the grid before
you clicked the "close" button
Menu:
Find, find data - finds data in the data grid and marks them in red
Find, display matches - lets you scroll through the marked data
Erases marks on data as well if there are no matches
Find, Select Row Matches - selects all rows with marked data
Find, Select Column Matches - selects all columns with marked data
Options, Clear Rows - deselects any selected rows
Options, Clear Columns - deselects columns
Options, Clear Data - removes any marks on data in the grid
Close button remembers the selected cols/rows in the grid and closes the frame
if you didn't select any rows/cols it keeps the old list. The lists can be cleared in the MAIN WINDOW.
RightMouseButton:
Column:
Properties - give data about column shown and mark the largest cell
Delete - delete selected columns or column you clicked on if none are selected
New Col - inserts a new column with the index specified
Append Col - append a new column with the index specified
Row:
Properties - give data about the row shown and mark largest cell
Delete - delete selected rows of data or row you clicked on if none are selected
New Row - insert a new row with the index specified
Append Row - append a new row with the index specified
LeftMouseButton:
Column:
selecting a column will add it into the column "selections", so you can then copy it to clipboard, or paste into the column
key - CTRL-X cut, CTRL-C copy, CTRL-V paste
if you close the grid with a column selected, it will be available for viewing/editing on column options submenu
Row:
selecting a row will add it to the row "selections", then you can copy the row(s) or paste into them.
Same keys as column cut, copy and paste
if you close the grid with a row selected it will be available under row options submenu
*A SINGLE row or SINGLE column can be copied/cut then pasted into either a ROW *or* COLUMN *or* BOTH.
GridMovers:
selecting a row or column and sliding it over another row/column will move the data to that position
Selecting:
select with one click, deselect with one click. shift-click selects a range. All selections are added to the options submenu
when you click "close" button.
you can click in any cell and edit the contents
Also, you can export the data, edit it, then import the data again.
