zeex

KO | EN

gitlite — search

#javascript #python #react #form #react-native #kotlin #spring-boot #machine-learning #blockchain #tensorflow #java #ios

★ 13 Open GitHub ↗

Spreadsheet Power Tools GUI - Pandas, PySide, SQLAlchemy

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# zeex

A Python GUI studio with a goal to make common data analysis and standardization tasks simple.
Utilizes PySide, pandas, and SQLAlchemy libraries to provide a flexible toolbox for 
working with rows and columns in many formats.

# Features:
- A light-weight SQL view/query tool using SQLAlchemy:
	- Connect PostgreSQL, SQLite, & MySQL databases
	- Edit, execute, and save SQL queries.
	- Import files to tables
	- Export tables/queries to files

- A template-maker for common tasks like:
    - Renaming & organizing headers
    - Sorting rows
    - Merging/purging other data sets based on common fields
    - Removing duplicate records
    - Splitting to multiple files
    - Text-to-columns
    - Concatenate columns

- Easy data-normalizations
    - Drop/fill missing values
    - Merge or split columns
    - Set case (upper/lower/proper)
    - Parse dates into YYYY-MM-DD format
    - Remove special characters/trim extra spaces

- File analyzer displaying a summary of your data instantly:
    - Minimum/Maximum, Sum, & Median values (of number & date columns)
    - Count of non-NA records (on string columns)

- Manage project files & folders in-app:
    - Renaming
    - Compression
    - DropBox upload/download

- A file reader that guesses the encoding and delimiter of most file formats
    - .csv
    - .txt
    - .xlsx
    - .pickle

- Lightning fast read, process, and write speed.
    - 250MB CSV open time: 7sec (v.s. Excel: 74sec)

- Issues are managed on Github using ZenHub - see upcoming features and feel free to contribute feedback, suggestions, or code.

# Screenshots:

- Home Window

![basic](https://raw.githubusercontent.com/zbarge/zeex/master/images/home.png)

- Database Main Window
![basic](https://raw.githubusercontent.com/zbarge/zeex/master/images/database_query1.png)

- Project Window

![basic](https://raw.githubusercontent.com/zbarge/zeex/master/images/project_open.png)

- File Window

![basic](https://raw.githubusercontent.com/zbarge/zeex/master/images/file_open.png)

- Edit Fields Dialog

![basic](https://raw.githubusercontent.com/zbarge/zeex/master/images/action_edit_fields_set_case.png)

- Merge/Purge Dialog

![basic](https://raw.githubusercontent.com/zbarge/zeex/master/images/action_merge_purge_tab1.png)

zeex

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README