Skip to main content

pandas nodes for funcnodes

Project description

funcnodes-pandas

funcnodes-pandas is an extension for the Funcnodes framework that allows you to manipulate Pandas DataFrames and Series using FuncNodes' visual node-based system. It provides a collection of nodes for performing typical operations on Pandas data structures, such as conversions, data manipulations, and calculations.

This library enables no-code and low-code workflows for Pandas by providing drag-and-drop functionality in a visual interface. It also supports Python-based scripting to handle more complex operations.

Features

  • DataFrame Conversion:

    • Convert DataFrames to dictionaries and vice versa.
    • Handle CSV and Excel files easily using DataFrame nodes.
  • Data Manipulation:

    • Add, drop, and manipulate rows and columns of a DataFrame.
    • Handle missing data with nodes for fillna, dropna, ffill, and bfill.
    • Perform merges and joins with intuitive nodes for merge, concatenate, and join.
  • Math & Statistical Operations:

    • Perform descriptive statistics like mean, sum, std, var, and corr.
    • Evaluate custom expressions directly on DataFrames using the eval node.
  • Masking & Filtering:

    • Apply masks to filter DataFrame data.
    • Use conditions to filter rows and columns dynamically.
  • Grouping & Aggregation:

    • Group data using groupby and aggregate it with sum, mean, count, etc.
    • Easily convert groups into lists of DataFrames.
  • Series Support:

    • Nodes for converting Series to lists and dictionaries.
    • Access individual elements using iloc and loc.
    • Perform string operations on Series.

Installation

Install the package with:

pip install funcnodes-pandas

Ensure that you have Pandas and FuncNodes installed.

Getting Started

Here's an overview of the basic programmatically usage of funcnodes-pandas.

  1. Convert a DataFrame to a Dictionary
import pandas as pd
import funcnodes_pandas as fnpd

df = pd.DataFrame({"A": [1, 2, 3], "B": [4, 5, 6]})
node = fnpd.to_dict()
node.inputs['df'].value = df
await node
print(node.outputs['dict'].value)

This code converts a DataFrame to a dictionary using the to_dict node.

  1. Filling Missing Data
node = fnpd.fillna()
node.inputs["df"].value = df
node.inputs["value"].value = 0
await node
print(node.outputs["out"].value)

The fillna node fills missing data in a DataFrame.

  1. Group By Operations
node = fnpd.group_by()
node.inputs["df"].value = df
node.inputs["by"].value = "A"
await node
print(node.outputs["grouped"].value)

This groups data based on column A in the DataFrame.

Testing

The repository contains a suite of tests to ensure that the various functionalities of funcnodes-pandas work as expected. The tests are based on unittest and IsolatedAsyncioTestCase. You can run the tests using:

python -m unittest discover

Test cases for operations such as groupby, add_column, dropna, etc., are included.

Contribution

Feel free to contribute to this project by submitting pull requests. You can help by adding new nodes, fixing bugs, or enhancing documentation.

License

This project is licensed under the MIT License.

Contact

For any questions or issues, please open an issue on the GitHub repository.

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

funcnodes_pandas-0.2.11.tar.gz (17.9 kB view details)

Uploaded Source

Built Distribution

funcnodes_pandas-0.2.11-py3-none-any.whl (22.4 kB view details)

Uploaded Python 3

File details

Details for the file funcnodes_pandas-0.2.11.tar.gz.

File metadata

  • Download URL: funcnodes_pandas-0.2.11.tar.gz
  • Upload date:
  • Size: 17.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/5.1.1 CPython/3.12.7

File hashes

Hashes for funcnodes_pandas-0.2.11.tar.gz
Algorithm Hash digest
SHA256 0f4f005a11053c70f9761cd155c12ff113b61db4386f36199cb7e0782dbbc5f9
MD5 a4a0f360232e3cdb8a8bcc9dc459add1
BLAKE2b-256 bf4079f22f06f97d5d19aecc681cde793bb8b9b6f106e384f8b2b1dc7fa417fd

See more details on using hashes here.

Provenance

The following attestation bundles were made for funcnodes_pandas-0.2.11.tar.gz:

Publisher: version_publish_main.yml on Linkdlab/funcnodes_pandas

Attestations:

File details

Details for the file funcnodes_pandas-0.2.11-py3-none-any.whl.

File metadata

File hashes

Hashes for funcnodes_pandas-0.2.11-py3-none-any.whl
Algorithm Hash digest
SHA256 3d90ff3857bc7e6148aacdb8e23401ab6e6096ae4c025d839adf1e0a57b14547
MD5 d1186347491c7ead737fa9eab4ec19be
BLAKE2b-256 f708f01a662c8be53938cd5f4e9abea4a89b2f6c6db849313f7b40ee6ae76004

See more details on using hashes here.

Provenance

The following attestation bundles were made for funcnodes_pandas-0.2.11-py3-none-any.whl:

Publisher: version_publish_main.yml on Linkdlab/funcnodes_pandas

Attestations:

Supported by

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