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

from pyconju.xlsx import Excelx

# 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

from pyconju.xls import Excel

# Initialize object
merger = Excel
path = "path/to/files/to/merge"
fileList = ["file1.xls","file2.xls","file3.xls"]
merger.merge_xls(fileList,path)

Example 3

from pyconju.csv import Csv

# 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