pdappend 0.0.15

Append csv, xlsx, and xls files.

pdappend

Run pdappend from the command line to append csv, xlsx, and xls files.

Installation

pip install pdappend

Using pdappend

Append specific files

pdappend file1.csv file2.csv file3.csv

Append specific file types in your directory

pdappend *.csv

Append all pdappend-compatible files in your directory

pdappend .

Supported file types

• csv
• xls
• xlsx: Not supported in Python 3.6 environments (downgrade to xlrd 1.2.0 or convert to .xls)

For specific sheets in Excel files

Using the command line

Use the flag --sheet-name to add a specific sheet name.

pdappend *.xls --sheet-name="Sheet Name"

Using .pdappend files

In the current working directory add a .pdappend file containing:

SHEET_NAME=Sheet Name

pdappend-gui

Run pdappend-gui at the command line to select files manually. You can use the same flags or .pdappend config for this method as well.

Header row configuration

If the first row of your file is not the column row use the --header-row flag or HEADER_ROW in the .pdappend to add the column row number. The default header row is 0.

Documentation

See the wiki for more on pdappend.

Contributing

Pull requests are welcome!