清空筛选条件
清空筛选条件

replace a numerical with a string within a csv file.

1 次查看（过去 30 天）
karan goyal
karan goyal 2019-2-6
评论： karan goyal 2019-2-7
FUTAvgTradePrice
19000 FUTTotalTradeQty FUTBestBidVol FUTBestBid FUTBestAskVol
26707 18000 3000 26645 3000
26678 9000 3000 26660 3000
26657 6000 6000 26610 3000
26660 3000 6000 26620 3000
26650 6000 6000 26635 3000
26650 0 3000 26630 3000
26660 3000 6000 26635 3000
26639 9000 9000 26610 6000
IN the above csv file i want to replace 19000 in SECOND ROW AND FIRST COLUMN WITH THE string FUTAvgTradePrice Which is present in the FIRST ROW AND FIRST COLUMN.HOW TO DO IT??(also the file is very big having 45000+ rows and 40+ columns).
ALSO I WANT TO DELETE THE FIRST ROW AFTER THIS HAS BEEN DONE.

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

采纳的回答

Gani
Gani 2019-2-6
编辑：Gani 2019-2-6
Use xlsread and xlswrite
Example:
[~,~,raw ]= xlsread('C:\Test.csv');
raw{2,1} ='FUTAvgTradePrice'; % setting value
raw(1, :) = []; % deleting first row
xlswrite('C:\Test.csv', raw); % saving it again

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Cell Arrays 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by