Skip to main content

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

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for exceldirreader, version 1.1
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 hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page