Read mix file name from xlsx and saparate mixed files

2 次查看（过去 30 天）
Azmat
Azmat 2022-7-7
编辑： Tejas 2024-12-27
Hi, everyone i am new here. I want to saprate multiple audio files of male & female from one directory. I have one excel file with 2 coulms file name & Label(male/female). I want to saprate male audio into another directory & female audio as well.. Kindly let me know & share script /code to resolve this issue please.
  1 个评论
Azmat
Azmat 2022-7-7
By using excel file name of audio file, i want to filter mixed male audio & female from same directory.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Tejas
Tejas 2024-12-27
编辑：Tejas 2024-12-27
Hello Azmat,
It seems that you have a folder containing audio files, along with an Excel sheet that indicates whether each audio file contains either male or female audio, and the goal is to organize these files into separate directories based on gender.
Here are the steps to accomplish this:
audioDir = 'pathToAudioDir';
excelFile = 'pathToExcelFile';
fileTable = readtable(excelFile);
maleDir = fullfile(audioDir, 'male');
femaleDir = fullfile(audioDir, 'female');
mkdir(maleDir);
mkdir(femaleDir);
for i = 1:height(fileTable)
fileName = fileTable.FileName{i}; % Assuming the column name is 'FileName'
label = fileTable.Label{i}; % Assuming the column name is 'Label'
sourceFile = fullfile(audioDir, fileName);
if strcmpi(label, 'male')
destDir = maleDir;
else
destDir = femaleDir;
end
movefile(sourceFile, destDir);
end

类别

在 Help Center 和 File Exchange 中查找有关 Audio and Video Data 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by