[PYTHON] Get all xlsx filenames in a folder in a natural sort order list and build an absolute path

Background / premise / specifications

A reminder template for creating tools for working with Excel files.

As a premise of the intended operation, the following states are assumed.

--Create a folder with an arbitrary name (folder_name in the code below) on the desktop, and run it with all the xlsx you want to handle in it.

--Get the list of all xlsx file names in the folder in natural sort order

--Up to the point where the file name list is acquired in order with the for statement and the absolute path of each file is constructed.

What is natural order?

The order when a list such as "file name + number" is arranged in a way that is nice to humans.

For example

["n5", "n1", "n10"]

If you sort the list normally,

["n1", "n10", "n5"]

But in natural order,

["n1", "n5", "n10"]

become.

• The page that was used as a reference [python] I want to sort the output of os.listdir () in numerical order and read them in order with pd.read_csv | teratail

Execution environment

The execution environment and the version of each library are as follows.

• Windows10 pro
• Python 3.7.3
• natsort 7.0.1

Get the names of all xlsx files in the folder in a natural sort order list and build the absolute path.

for_all_xlsx.py

import os
from natsort import natsorted


#Arbitrary folder name created on the desktop

folder_name = "******"


#constant
desktop_path = os.getenv("HOMEDRIVE") + os.getenv("HOMEPATH") + "\\Desktop"
folder_path = os.path.join(desktop_path, folder_name)


#Get Excel file name list in natural order
files = natsorted(os.listdir(folder_path))

#Build the absolute path of each file by turning the file name list with a for statement
for filename in files:
    filepath = os.path.join(folder_path, filename)
'''Describe the content you want to process below'''