# 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
Raw data
{
"_id": null,
"home_page": "https://github.com/dyagee/pyconju",
"name": "pyconju",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.7",
"maintainer_email": "",
"keywords": "python3,excel,xls,csv,xlsx,merge",
"author": "Agee Aondo",
"author_email": "ageeaondo45@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/90/63/809021536414e91395e8aee8604e9a13c8ef03299e407692b30d578a816e/pyconju-0.1.2.tar.gz",
"platform": null,
"description": "# PyConju \r\n\r\nA python package for merging multiple files into a single file. File types supported include: .xlsx, .xls, and .csv.\r\n\r\n`PDF` support coming soon!\r\n\r\n\r\n## Installation on Windows\r\n---\r\n### 1. Create a Project folder\r\n```\r\nmkdir project-folder\r\ncd project-folder\r\n```\r\n### 2. Create a virtual environment\r\n```\r\npython -m venv venv\r\n```\r\n### 3. Activate the virtual environment\r\n```\r\n./venv/Scripts/activate\r\n```\r\n### 4. Install package from PyPi\r\n```\r\npip install pyconju\r\n``` \r\n\r\n### 5. Usage / Examples\r\n\r\n### Example 1\r\n```python\r\nfrom pyconju.xlsx import Excelx\r\n```\r\n```python\r\n# Initialize object\r\nmerger = Excelx\r\npath = \"path/to/files/to/merge\"\r\nfileList = [\"file1.xlsx\",\"file2.xlsx\",\"file3.xlsx\"]\r\nmerger.merge_xlsx(fileList,path)\r\n```\r\n\r\nOut of the box you may encounter this error:\r\n\r\n```\r\nImportError: Pandas requires version '2.0.1' or newer of 'xlrd' (version '1.2.0' currently installed).\r\n```\r\nDon't panic, Uninstall the current version of `xlrd`:\r\n\r\n```\r\n(.venv) $ pip uninstall xlrd\r\n\r\n Found existing installation: xlrd 1.2.0\r\n Uninstalling xlrd-1.2.0:\r\n\r\n\r\n Proceed (Y/n)? y\r\n Successfully uninstalled xlrd-1.2.0\r\n```\r\n\r\nInstall `xlrd` version `2.0.1`:\r\n\r\n```\r\n(.venv) $ pip install xlrd==2.0.1\r\n```\r\n\r\n**Try the merging process again; it will work**\ud83e\udd29\r\n\r\n\r\n\r\n### Example 2\r\n```python\r\nfrom pyconju.xls import Excel\r\n```\r\n```python\r\n# Initialize object\r\nmerger = Excel\r\npath = \"path/to/files/to/merge\"\r\nfileList = [\"file1.xls\",\"file2.xls\",\"file3.xls\"]\r\nmerger.merge_xls(fileList,path)\r\n```\r\n\r\n### Example 3\r\n```python\r\nfrom pyconju.csv import Csv\r\n```\r\n```python\r\n# Initialize object\r\nmerger = Csv\r\npath = \"path/to/files/to/merge\"\r\nfileList = [\"file1.xlsx\",\"file2.xlsx\",\"file3.xlsx\"]\r\nmerger.merge_csv(fileList,path)\r\n```\r\n## Contributing\r\nYou are welcome to contribute to the repo as you like\r\n\r\n## Authors and acknowledgment\r\nAgee Aondo\r\n\r\nEmail: ageeaondo45@gmail.com\r\n\r\nWebsite: https://linktr.ee/dyagee\r\n\r\n## License\r\nSee LICENSE file\r\n",
"bugtrack_url": null,
"license": "",
"summary": "Python package for merging multiple files",
"version": "0.1.2",
"project_urls": {
"Bugs": "https://github.com/dyagee/pyconju/issues",
"Docs": "https://pyconju.readthedocs.io/",
"Download": "https://github.com/dyagee/pyconju/archive/refs/tags/v0.1.2.tar.gz",
"Homepage": "https://github.com/dyagee/pyconju"
},
"split_keywords": [
"python3",
"excel",
"xls",
"csv",
"xlsx",
"merge"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "e0b0900e2e9d83d83a2cb5ba007516f3c5a87e2d9f8c3b3dd96c4d9e4fd4c8d4",
"md5": "b77113fcf9499de27a1286e14bd280c3",
"sha256": "2251fd137568f4de133fce305d77ff3c498fc532cfff0bd33a08a3454a8949b9"
},
"downloads": -1,
"filename": "pyconju-0.1.2-py3-none-any.whl",
"has_sig": false,
"md5_digest": "b77113fcf9499de27a1286e14bd280c3",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.7",
"size": 4664,
"upload_time": "2023-06-23T11:17:36",
"upload_time_iso_8601": "2023-06-23T11:17:36.980274Z",
"url": "https://files.pythonhosted.org/packages/e0/b0/900e2e9d83d83a2cb5ba007516f3c5a87e2d9f8c3b3dd96c4d9e4fd4c8d4/pyconju-0.1.2-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "9063809021536414e91395e8aee8604e9a13c8ef03299e407692b30d578a816e",
"md5": "97613a550395efd44c8640fa46a0c79c",
"sha256": "45ef3662469414a19ec57a26cc8de298d035b93ef3c54a920c16c3b997a17592"
},
"downloads": -1,
"filename": "pyconju-0.1.2.tar.gz",
"has_sig": false,
"md5_digest": "97613a550395efd44c8640fa46a0c79c",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.7",
"size": 4077,
"upload_time": "2023-06-23T11:17:41",
"upload_time_iso_8601": "2023-06-23T11:17:41.898929Z",
"url": "https://files.pythonhosted.org/packages/90/63/809021536414e91395e8aee8604e9a13c8ef03299e407692b30d578a816e/pyconju-0.1.2.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-06-23 11:17:41",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "dyagee",
"github_project": "pyconju",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "pyconju"
}
JSON
