Skip to content

V0.29 - PandasGUI, Architecture & Functional Enhancements ⚙️

Choose a tag to compare

@Ariel4545 Ariel4545 released this 07 Jan 15:15
· 8 commits to main since this release
8ec3814

🐼 PandasGui Update Patch Notes


🔖 Version Comparison

Feature 🏛️ Previous Version (V0.25) 🚀 Updated Version (v0.29)
UI Framework Basic customtkinter (Single Window) Enhanced Single Window (Refined Layout)
Data View Basic Treeview Optimized Treeview with Dark/Light Theme Support
Performance Lags with large files Lazy Loading (Preview first 1k rows)
Safety Prone to crashes on bad data Unified Error Handling & Type Safety

✨ Key Changes

🎨 1. User Interface Refinements

The application retains its familiar layout but with significant under-the-hood improvements.

  • 🗂️ Layout: The core button grid layout remains, ensuring familiarity for existing users.
  • 🌗 Adaptive Theming: The data table (Treeview) now adapts to Dark and Light modes, ensuring text is always readable.
  • 🚦 Status Feedback: Operations now provide clearer feedback via popups.

🛠️ 2. Architecture & Stability

  • 🛡️ Unified Operation Pipeline: A new internal engine (_apply_op) handles all data modifications. This means:
    • No more crashes if you click a button without loading a file.
    • Automatic UI updates after every change.
    • Graceful error messages instead of console tracebacks.
  • 🔢 Numeric Safety: Arithmetic operations (Sum, Mean, Pow) now automatically filter for numeric columns only, preventing errors when trying to calculate the "mean" of text columns.

🚀 3. Functional Enhancements

⚡ Transformations (Mutate Data)

These operations now modify your dataset in real-time:

  • Abs: Converts numbers to absolute values.
  • Cumsum: Calculates cumulative sums.
  • Pow: Raises numbers to a power (includes a smart dialog for exponents).
  • Cleaning: Instant removal of empty rows or duplicates.
  • Mode & Nunique: Now update the dataframe directly (broadcasted values) instead of just showing a popup.

📝 Summaries (View Only)

Safe, read-only insights into your data:

  • Stats: Sum, Min, Max, Mean, Median.
  • Info: formatted output in a scrollable window.

🐛 Bug Fixes & Polish

  • Scrollbars: Added horizontal and vertical scrolling to the data view.
  • Type Inference: The "Replace" tool now smartly detects if you are typing a number or text.
  • Memory: Large files no longer freeze the UI upon loading.