How do I manipulate,modify excel files using python3 along with searching/sorting algorithms for huge databases?

Question

I am new to python and need to work on a project with the whole database on excel. The database is over 100k entries and has to be periodically modified and searched/sorted often.

Are there any package(s) for this?

Answer 1

As per your title, this is a list of python modules that can perform various operations on Excel worksheets.

1. Pandas (possibly your best option, since it has powerful data management).
2. pyExcelerator (apparently not maintained anymore)
3. xlwt (a fork of pyExcelerator)
4. openpyxl
5. xlrd

As to search/sort, python has builtin features and there are plenty of other packages.

1. https://pypi.python.org/pypi/algorithms