python 数据处理 - 文件接口相关模块
1.OS
1.1.读取文件夹中的文件相应路径
path = r'D:\'
folders = os.listdir(path)
sort_num_list = []
for folder in folders:
sort_num_list.append(int(folder.split('(')[1].split(')')[0]))
sort_num_list.sort()
sorted_folders = []
for sort_num in sort_num_list:
for folder in folders:
if str(sort_num) == folder.split('(')[1].split(')')[0]:
sorted_folders.append(folder)
print(sorted_folders)
filepath = os.path.join(path, folder)
1.2.创建文件夹路径
if not os.path.exists(temp_dir):
os.mkdir(temp_dir)
2.xlrd
2.1.读取excel文件(pd.read_excel也可以办到)
from tqdm import tqdm
import xlrd
book = xlrd.open_workbook(filepath)
sheetname = book.sheet_names()
sheetname = sheetname[:4]
for i in range(len(sheetname)):
id_list.append(folder + '_' + str(i+1))
sheet = book.sheet_by_name(sheetname[i])
rows = sheet.nrows
car_data = []
for r in range(3, rows):
car_data.append(sheet.row_values(r))
car_data = np.array(car_data)
3.scipy.io
import scipy.io as sio
data = sio.loadmat(filepath)