首先是有一个已知的路径,现在要遍历该路径下的所有文件及文件夹,因此定义了一个列表,用于存放遍历到的文件名。C#代码如下:
string path = "给定的文件夹名称"List<string> nameList = new List<string>()
Director(path,nameList)
public void Director(string dir,List<string> list)
{
DirectoryInfo d = new DirectoryInfo(dir)
FileInfo[] files = d.GetFiles()//文件
DirectoryInfo[] directs = d.GetDirectories()//文件夹
foreach (FileInfo f in files)
{
list.Add(f.Name)//添加文件名到列表中
}
//获取子文件夹内的文件列表,递归遍历
foreach (DirectoryInfo dd in directs)
{
Director(dd.FullName, list)
}
}
import pandas as pdimport os
# 用os.walk遍历文件;用.endswith判断文件后缀
dfs = pd.DataFrame()
for root, dirs, files in os.walk(r'C:\Users\ll\Desktop\pandas\excels'):
for file in files:
if file.endswith('.xlsx'):
# 构建绝对路径
file_name = os.path.join(root, file)
# print(file_name)
df = pd.read_excel(file_name)
# print(df)
dfs = pd.concat([dfs, df])
# print(dfs)
dfs.to_excel(r'C:\Users\ll\Desktop\new.xlsx')
@echo offset "folder=D:\指定文件夹"
for /f "delims=" %%a in ('dir /a-d/b/s "%folder%\"') do ren "%%a" "%%~na后缀%%~xa"
pause
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)