Metadata-Version: 2.1
Name: pyconju
Version: 0.1.2
Summary: Python package for merging multiple files
Home-page: https://github.com/dyagee/pyconju
Download-URL: https://github.com/dyagee/pyconju/archive/refs/tags/v0.1.2.tar.gz
Author: Agee Aondo
Author-email: ageeaondo45@gmail.com
Project-URL: Bugs, https://github.com/dyagee/pyconju/issues
Project-URL: Docs, https://pyconju.readthedocs.io/
Keywords: python3,excel,xls,csv,xlsx,merge
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Classifier: Natural Language :: English
Classifier: Topic :: Software Development :: Libraries :: Python Modules
Classifier: Intended Audience :: Developers
Classifier: Intended Audience :: Science/Research
Classifier: Intended Audience :: Other Audience
Requires-Python: >=3.7
Description-Content-Type: text/markdown
License-File: LICENSE
Requires-Dist: pandas
Requires-Dist: openpyxl
Requires-Dist: xlrd (==2.0.1)

# PyConju 

A python package for merging multiple files into a single file. File types supported include: .xlsx, .xls, and .csv.

`PDF` support coming soon!


## Installation on Windows
---
### 1. Create a Project folder
```
mkdir project-folder
cd project-folder
```
### 2. Create a virtual environment
```
python -m venv venv
```
### 3. Activate the virtual environment
```
./venv/Scripts/activate
```
### 4. Install package from PyPi
```
pip install pyconju
``` 

### 5. Usage / Examples

### Example 1
```python
from pyconju.xlsx import Excelx
```
```python
# Initialize object
merger = Excelx
path = "path/to/files/to/merge"
fileList = ["file1.xlsx","file2.xlsx","file3.xlsx"]
merger.merge_xlsx(fileList,path)
```

Out of the box you may encounter this error:

```
ImportError: Pandas requires version '2.0.1' or newer of 'xlrd' (version '1.2.0' currently installed).
```
Don't panic, Uninstall the current version of `xlrd`:

```
(.venv) $ pip uninstall xlrd

   Found existing installation: xlrd 1.2.0
   Uninstalling xlrd-1.2.0:


   Proceed (Y/n)? y
   Successfully uninstalled xlrd-1.2.0
```

Install `xlrd` version `2.0.1`:

```
(.venv) $ pip install xlrd==2.0.1
```

**Try the merging process again; it will work**🤩



###  Example 2
```python
from pyconju.xls import Excel
```
```python
# Initialize object
merger = Excel
path = "path/to/files/to/merge"
fileList = ["file1.xls","file2.xls","file3.xls"]
merger.merge_xls(fileList,path)
```

###  Example 3
```python
from pyconju.csv import Csv
```
```python
# Initialize object
merger = Csv
path = "path/to/files/to/merge"
fileList = ["file1.xlsx","file2.xlsx","file3.xlsx"]
merger.merge_csv(fileList,path)
```
## Contributing
You are welcome to contribute to the repo as you like

## Authors and acknowledgment
Agee Aondo

Email: ageeaondo45@gmail.com

Website: https://linktr.ee/dyagee

## License
See LICENSE file
