Skip to main content

Helper to save Excel formulas from Pandas dataframes

Project description

xlFormulas

Helper class to write Excel-style formula strings to worksheets when saving from a Pandas dataframe.

Default initialization assumes the worksheet will be saved with an index and header row (the first real 'data' cell would be B2) but an index and header parameter are available to ensure alignment.

Pass in mathematical operators with strings, limited support currently for Excel built-in functions. If a value is not a column name in df.columns it is passed in as it is, whether that means it's an operator or builtin function.

The .formula() method returns a list of strings beginning with '=' and containing the row index for the Excel formula

Installation:

pip install xl-formulas

Basic usage:

import pandas as pd
from xlFormulas import ExcelFormulas

df = pd.read_excel('sample_data.xlsx')

# Pass in Pandas dataframe to intialize ExcelFormulas helper
ef = ExcelFormulas(df)

# Returns a column like "=B2+C2" in df['C']
df['C'] = ef.formula('A + B')

# Makes a "=(B2 + C2)/(C2 - D2)" column in df['D']
df['D'] = ef.formula(f'{ef.paren('A + B')} / {ef.paren('B - C')}'

# Use Excel built-in functions (Still pretty buggy)
# This would get a column of "=SUM(B2,C2,5)" in df['E']
df['E'] = ef.formula(ef.builtin('SUM', 'A', 'B', 'C'))

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

xl-formulas-0.0.1.tar.gz (2.7 kB view details)

Uploaded Source

Built Distribution

xl_formulas-0.0.1-py3-none-any.whl (3.9 kB view details)

Uploaded Python 3

File details

Details for the file xl-formulas-0.0.1.tar.gz.

File metadata

  • Download URL: xl-formulas-0.0.1.tar.gz
  • Upload date:
  • Size: 2.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.13.0 pkginfo/1.5.0.1 requests/2.21.0 setuptools/40.8.0 requests-toolbelt/0.9.1 tqdm/4.29.1 CPython/3.7.2

File hashes

Hashes for xl-formulas-0.0.1.tar.gz
Algorithm Hash digest
SHA256 b9551c256bb6bf9c248d3efcc5d965f3b0c72f55de554c47b737463df33731a5
MD5 b2cf1e1a951ce5ed2563bd3ad4dd586d
BLAKE2b-256 98b55b4cc973a68918211f48ab2ee78a1881577261e7e240f2edaa762f5cd1a8

See more details on using hashes here.

File details

Details for the file xl_formulas-0.0.1-py3-none-any.whl.

File metadata

  • Download URL: xl_formulas-0.0.1-py3-none-any.whl
  • Upload date:
  • Size: 3.9 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.13.0 pkginfo/1.5.0.1 requests/2.21.0 setuptools/40.8.0 requests-toolbelt/0.9.1 tqdm/4.29.1 CPython/3.7.2

File hashes

Hashes for xl_formulas-0.0.1-py3-none-any.whl
Algorithm Hash digest
SHA256 a2aea6df1cd4415cfaaed839fede0332041bd79252eea366225f86f7895d953c
MD5 dbf218465fde17a7b3d03255d0e7e945
BLAKE2b-256 ed04ed6f13033d5e4c766f895a27733d6c3bdeaa6be35db2faec81757c5e9725

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page