Reads multiple excel files from a directory
Project description
exceldirreader
It reads multiple excel files in a directory and returns a dataframe with all tables appended
Getting Started
After installing it, import the package:
import exceldirreader
Instantiate an object:
reader = exceldirreader.Reader("your_directory_path")
Read the files by calling the function read_files and passing a dictionary where the keys are the file names and the values are the worksheet names:
my_dict = {
"file1.xlsx":"SheetX",
"file2.xlsx":"SheetY",
"file3.xlsx":"SheetZ"
}
final_dataframe = reader.read_files(my_dict)
Installing
In your virtual environment, in the command line:
pipenv install excelsdirectoryreader
Built With
Author
- Afonso Schulz Albrecht - Initial work - schulzalbrecht
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Filename, size | File type | Python version | Upload date | Hashes |
---|---|---|---|---|
Filename, size exceldirreader-1.1.tar.gz (2.9 kB) | File type Source | Python version None | Upload date | Hashes View |