Data Analysis

pyspread – spreadsheet with Python expressions in cells

pyspread is a spreadsheet application that takes a different approach to calculations and data manipulation. Instead of providing a dedicated spreadsheet formula language, it allows users to enter Python expressions directly into cells.

Each cell can evaluate an expression and return a Python object, ranging from a simple number or string to a complex data structure. This makes pyspread particularly useful for technical users who want spreadsheet-style interaction combined with the flexibility of a general-purpose programming environment.

The application is suitable for numerical analysis, experimentation, visualization, and working with structured data where conventional spreadsheet formulas may be restrictive.

This is free and open source software.

Key Features

  • Spreadsheet cells evaluate expressions and return objects that can be referenced elsewhere in the workbook.
  • Three-dimensional spreadsheet grid supports rows, columns, and multiple tables.
  • Access to external modules allows integration with numerical and scientific computing functionality.
  • Cells can contain numbers, strings, lists, matrices, and other supported objects.
  • Displays formatted text, images, and graphical output within spreadsheet cells.
  • Matplotlib integration allows charts to be generated directly from spreadsheet data.
  • Chart creation dialog supports common visualization types including line, bar, histogram, box, and pie charts.
  • Additional chart functionality is available through compatible R plotting tools.
  • Imports CSV, SVG, and XLSX data.
  • Exports spreadsheet data and graphical content to CSV, SVG, and PDF.
  • Macro tools assist with inserting charts, images, dates, and frequently used expressions.
  • Supports numerical arrays and operations across ranges of cells.
  • Uses file signatures and an approval mechanism to help protect users from executing untrusted spreadsheet code.
  • Cross-platform support – runs on Linux and Windows.

Website: gitlab.com/pyspread/pyspread
Support:
Developer: Martin Manns and contributors
License: GNU General Public License v3.0

pyspread is written in Python. Learn Python with our recommended free books and free tutorials.


Related Software

Python Data Analysis
pandasHigh-level building block for doing practical, real world data analysis
NumPyCore package for scientific computing with Python
SciPyEcosystem for mathematics, science, and engineering
PolarsDataFrame interface on top of an OLAP Query Engine
statsmodelsStatistical modeling and econometrics in Python
DaskAdvanced parallelism for analytics
OrangeComponent-based framework for machine learning and data mining
ModinDrop-in replacement for pandas
VaexFast visualization of big data
AWS DWExtends the power of pandas library
ytMulti-code Toolkit for Analyzing and Visualizing Volumetric Data
HoloViewsMake Data Analysis and Visualization Seamless
datatableManipulate 2-dimensional tabular data structures
xarrayWork with labelled multi-dimensional arrays and datasets
pyjanitorExtend pandas with readable data-cleaning functions
OptimusAgile Data Preparation Workflows

Read our verdict in the software roundup.


Best Free and Open Source Software LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.

We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more.

Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion.

Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README.
Subscribe

Please read our Comment Policy before commenting.

Notify of
guest
0 Comments
Oldest
Newest Most Voted