Tag Archives: Python

Use Python to merge multiple csv / xls / xlsx files

For the record, this article does not use the openpyx package. The xlrd and xlwt packages are used. Although the functions of these two libraries cannot be compared with openpyx, they can operate the old version of excel with the extension like xls which openpyx does not support. The general idea is as follows. Traverse to get all… Read More »

Use depth-first and breadth-first search to find dead links

The following script is to catch dead links (return 404 HTTP status code) under a domain name. Depth-first Search (DFS) After getting the root path, first, take out all the sub-paths, and use urllib to verify these paths. If the verification fails, record them, otherwise use the sub-path as the root path to traverse its sub-paths. Breadth-First Search… Read More »