Skip to content
/ zeex Public

Spreadsheet Power Tools GUI - Pandas, PySide, SQLAlchemy

License

Notifications You must be signed in to change notification settings

zbarge/zeex

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

  • Database Main Window basic

  • Project Window

basic

  • File Window

basic

  • Edit Fields Dialog

basic

  • Merge/Purge Dialog

basic

Releases

No releases published

Packages

No packages published

Languages