semvec/pypi-packages huggingface dataset:
sc-exam-checker 0.0.2
python project
License: MIT
Requires Python: >=3.6
Keywords: python

.. image:: https://badge.fury.io/py/sc-exam-checker.svg
    :target: https://badge.fury.io/py/sc-exam-checker
.. image:: https://img.shields.io/pypi/pyversions/sc-exam-checker
    :alt: PyPI - Python Version

A simple Python project
========================================

This is a simple python project.


Installation
------------

It is possible to install the tool with `pip`::

    pip install sc-exam-checker

Configuration
-------------

Configuration files reading in this order, the first is the top most priority:

#. production.xml in current directory,
#. production.xml in <project_name> directory under User directory,
#. production.xml in <project_name> directory under /var/opt/sc/ directory,
#. default.xml in <project_name> directory under /var/opt/sc/ directory.

The default configuration file looks like this::

    dev:
      # whether this program is running is development mode
      dev_mode: False

License
-------

The script is released under the MIT License.  The MIT License is registered
with and approved by the Open Source Initiative [1]_.

.. [1] https://opensource.org/licenses/MIT
excel-dependency-graph 0.1.1
A library to parse Excel formulas and create a dependency graph for cells.
License: MIT
Requires Python: <4.0,>=3.6


# Excel Dependency Graph

## Installation

You can install the package from PyPI using the following command:

```bash
pip install excel-dependency-graph==0.1.0
```

## Overview

This Python script reads an Excel file and builds a dependency graph of cell formulas using the `networkx` library. Each cell that contains a formula referencing other cells is represented as a directed graph node, with edges representing the dependencies. The dependency graph can be visualized and analyzed to understand how different cells are interrelated.

## Features

- Parses formulas in Excel sheets to identify cell dependencies.
- Builds a directed dependency graph using `networkx`.
- Visualizes the dependency graph with `matplotlib`.
- Allows retrieval of dependencies and dependents of specific cells.
- Saves the dependency graph in GML format.

## Requirements

This script requires the following Python libraries:

- `openpyxl` for reading Excel files
- `networkx` for creating and handling the dependency graph
- `matplotlib` for graph visualization

Install these libraries using `pip`:

```bash
pip install openpyxl networkx matplotlib
```

## Usage

1. **Initialize the Graph**: Instantiate the `ExcelDependencyGraph` class with the path to the Excel file.
2. **Build the Dependency Graph**: Call the `build_dependency_graph()` method to parse the file and build the graph.
3. **Visualize the Graph**: Use `visualize_graph()` to display the dependency graph.
4. **Retrieve Dependencies and Dependents**:
   - `get_dependencies(cell)` returns cells a given cell depends on.
   - `get_dependents(cell)` returns cells that depend on a given cell.
5. **Save the Graph**: Save the graph structure in GML format using `save_graph(output_path)`.



# Example usage
```
graph = ExcelDependencyGraph("example/example.xlsx")
graph.build_dependency_graph()
graph.visualize_graph()
print(graph.get_dependencies("Sheet1!A1"))
print(graph.get_dependents("Sheet1!A1"))
graph.save_graph("dependency_graph.gml")
```

# Sample Output

![image](https://github.com/user-attachments/assets/149da8f0-2b75-480d-bb64-f23e25d7ccd0)