import os,re, pandas as pd
def readName(path,pathlist,namelist):
for root, dirs, files in os.walk(path, topdown=False):
for name in files:
pathlist.append(root)
namelist.append(name);
def main():
pathlist=[]
namelist=[]
path = “D:\Public\\2019”
readName(path,pathlist,namelist)
df = pd.DataFrame({“path”:pathlist,“file name”:namelist})
df.to_excel("./pathname2019.xlsx",index = False)
main()