如何动态表名称大量高?

                              d = dir (‘* . csv‘);%假设所有文件一起在相同的文件夹中
                             
                              s =大小(d, 1);
                             
                              为k = 1: s
                             
                              r = readtable (d (k) . name);
                             
                              catnams = r.Properties.VariableNames;
                             
                              为m = 1:长度(catnams)
                             
                              试一试
                             
                              R = readtable ([catnams {m},. csv”]);
                             
                              R = [(: 1); R (:, m)];
                             
                              writetable (R, [catnams {m},“csv”]);%不确定如果你想保存为.mat文件或. csv
                             
                              抓
                             
                              R = R (:, m);
                             
                              writetable (R, [catnams {m},“csv”]);%不确定如果你想保存为.mat文件或. csv
                             
                              结束
                             
                              结束
                             
                              结束

2的评论
显示1年长的评论藏1年长的评论

海莉罗杰斯 2022年11月2日

编辑:海莉罗杰斯 2022年11月2日

@David山 ——我重写代码,这工作我需要什么!谢谢! ! !

cd 历史' D: \ \ CSV \股票期权和股票数据的

opts1 = delimitedTextImportOptions ( “NumVariables” 8);

opts1。DataLines =(2,正);

opts1。分隔符= ”、“ ;

opts1。VariableNames = [ “UnderlyingSymbol” , “DataDate” , “开放” , “高” , “低” , “关闭” , “体积” , “Adj_Close” ];

opts1。VariableTypes = [ “分类” , “datetime” , “单身” , “单身” , “单身” , “单身” , “单身” , “单身” ];

opts1。ExtraColumnsRule = “忽略” ;

opts1。EmptyLineRule = “读” ;

opts1 = setvaropts (opts1, “UnderlyingSymbol” , “EmptyFieldRule” , “汽车” );

opts1 = setvaropts (opts1, “DataDate” , “InputFormat” , “MM / dd / yyyy” );

stock_folder = dir ( ‘* . csv‘ ); %假设所有文件一起在相同的文件夹中

stock_folder_size =大小(stock_folder, 1);

为 k = 1: stock_folder_size

抽搐

table_daily = readtable (stock_folder (k) . name, opts1);

catnames =独特(table_daily (:, “UnderlyingSymbol” ), “排序” );

parfor m = 1:高度(catnames)

table_symbol_rows = (table_daily。UnderlyingSymbol = = catnames {m, 1});

table_symbol_new = table_daily (table_symbol_rows:);

filename_symbol = sprintf ( “% s_raw_stock.csv” catnames {m, 1});

filename_symbol_mat = sprintf ( “% s_raw_stock” catnames {m, 1});

试一试

table_symbol = OVM_Read_Table (filename_symbol opts1);

table_symbol = vertcat (table_symbol table_symbol_new);

OVM_Write_Table (table_symbol filename_symbol);

抓

table_symbol = table_symbol_new;

OVM_Write_Table (table_symbol filename_symbol);

结束

toc

结束

登录置评。

类别

MATLAB 语言基础知识数据类型表

找到更多的在表在帮助中心和文件交换

社区寻宝

找到宝藏在MATLAB中央,发现社区如何帮助你!

开始狩猎!