semvec/pypi-packages huggingface dataset:
excel-writer 1.0.6
Simple library to write excel files from Python Dictionary or Pandas DataFrame.
License: MIT

Copyright (c) 2023-Present EncoreSky Technologies Pvt. Ltd. All rights reserved.

# Excel Writer

![version](https://img.shields.io/badge/version-1.0.6-blue)

*excel_writer* is a package containing the methods for creating excel file from python dictionary or pandas dataframe.

## Prerequisites

You'll also need the following:

- [Python](https://www.python.org/downloads/release/python-3811/), _excel_writer_ is compatible with version >=3.8.11.

## Installation

To install the package (in either a system-wide or a virtual environment), navigate to the *excel_writer* root folder in a Terminal, and type:

```bash
pip install excel-writer
```

*excel_writer* will be installed as a package in your Python distribution, along with it's dependencies if necessary.

*N.B.* - installing in a virtual environment is recommended.

## Usage

### Input Format

Supported input format for dictionary is as follows:

```bash
{
    <column_name>: [<row_value>, <row_value>, . . . .],
    <column_name>: [<row_value>, <row_value>, . . . .],
    .
    .
    .
    .
}
```

### Write a file using dictionary


```python
from excel_writer import ExcelWriter

input_data = {
    "Name": ["Aarav", "Jayesh", "Vineet", "Rahul", "Mayank", "Deepak"],
    "Age": [24, 28, 27, 25, 28, 35],
    "Emp Id": ["A-001", "A-002", "A-003", "A-004", "A-005", "A-006"],
    "City": ["Indore", "Bhopal", "Gwalior", "Pune", "Kolkata", "Udaipur"],
    "Has Bike": ["Y", "Y", "Y", "Y", "Y", "Y"]
}

excel_writer = ExcelWriter(file_name="test.xlsx", 
                            sheet_name="sheet_1")

excel_writer.write_data(data_dict = input_data)
```

### Write a file using pandas dataframe


```python
import pandas as pd
from excel_writer import ExcelWriter

input_data = {
    "Name": ["Aarav", "Jayesh", "Vineet", "Rahul", "Mayank", "Deepak"],
    "Age": [24, 28, 27, 25, 28, 35],
    "Emp Id": ["A-001", "A-002", "A-003", "A-004", "A-005", "A-006"],
    "City": ["Indore", "Bhopal", "Gwalior", "Pune", "Kolkata", "Udaipur"],
    "Has Bike": ["Y", "Y", "Y", "Y", "Y", "Y"]
}

data_df = pd.DataFrame(input_data)
excel_writer = ExcelWriter(file_name="test.xlsx", 
                            sheet_name="sheet_1")

excel_writer.write_data(data_df = data_df)
```