您正在关注此问题

您将在关注的内容源中看到更新。
您可能会收到电子邮件，具体取决于您的通信预设项。

Writing variables in .csv file and saving it

8 次查看（过去 30 天）

显示更早的评论

Ganesh Kini 2020-6-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it

⋮

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it

编辑： Ameer Hamza 2020-6-10

Hi,

I have a functionality that works perfectly fine. But the output has a set of Numeric value and text strings.

for ex: abc, 1, def,1

def,2, rfg, 1

How can i save the output in a .csv file? do i need to put all my output values of the code to a Matrix then use csvwrite() function?

Please suggest your inputs

回答（1 个）

Ameer Hamza 2020-6-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#answer_447221

⋮

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#answer_447221

在 MATLAB Online 中打开

If you have R2019a or later, you can save the data in a cell array and use writecell()

C = {'abc', 1, 'def' 1; 'def', 2, 'rfg', 1};
writecell(C, 'test.txt')

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886064

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886064

I have 15,000 entries ( as the output for the code) in that case how do i write it down ?

Ameer Hamza 2020-6-6

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886076

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886076

How are you getting the output? In a variable?

Ganesh Kini 2020-6-6

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886079

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886079

Actually i had posted a query earlier, but didnt get any suggestion.

Could you please check this link Example

It would be of great help

Ameer Hamza 2020-6-6

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886094

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886094

It is not clear in which format are you getting the output. Is it just printed on the command window?

Ganesh Kini 2020-6-6

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886097

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886097

Yes, I have specified in fprintf() in the octave code and then i will get that output in the command window.

Please let me know if you need more clarifications

Ameer Hamza 2020-6-6

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886106

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886106

I think instead of printing to the command window, you can print directly to the CSV file. The actual will depend on how the values are saved inside the for-loop.

Ganesh Kini 2020-6-6

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886115

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886115

编辑：Ganesh Kini 2020-6-6

Okay, could do you please suggest what can be done to this?

Do you want the printf statement that i have used?

I am not able to understand how to write it

Ameer Hamza 2020-6-6

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886124

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886124

The current printf statements might not be useful. The actual issue is how all the values are saved? Are they saved in some variables?

Ganesh Kini 2020-6-6

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886130

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886130

yes they are saved in different variables. each value is computed in the for-loop and then we have the value assigned to each of the variable ( both string and floating values ) and then i write everything in fprint() statement

Ameer Hamza 2020-6-6

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886136

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886136

在 MATLAB Online 中打开

If you have all the values if a same filed inside one variable then you may try fprintf like this

fprintf('Place: ')
fprintf('%s,', place_values)

Ganesh Kini 2020-6-6

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886139

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886139

编辑：Ganesh Kini 2020-6-6

Can you please let me know the full flow of the code? so that it would be easy to me to understand after the above what needs to be done and how do we write in that particular format

Is it possible to reply in this link so that it would be easy for others to understand the flow and how the code needs to be written

https://de.mathworks.com/matlabcentral/answers/542873-how-to-write-the-output-of-the-code-to-csv-format-and-save-the-file?s_tid=prof_contriblnk

Ameer Hamza 2020-6-6

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886142

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886142

在 MATLAB Online 中打开

I meant that you can do it for each line. For example,

fprintf('Place: ')
fprintf('%f,', place_values)
fprintf('\n');
fprintf('Repeated Place: t,')
fprintf('f,', ones(1,size(place_values)))
fprintf('\n');
fprintf('Temperature: ')
fprintf('%f,', temperature_values)
fprintf('\n');
..
..
% similarly for other fields.

Ganesh Kini 2020-6-6

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886148

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886148

Okay i will try and how do i save it in .csv file ?

Please suggest me the code for that

Ameer Hamza 2020-6-6

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886154

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886154

在 MATLAB Online 中打开

fprintf() can write to a file as well

fid = fopen('filename.csv');
fprintf(fid, 'Place: ')
fprintf(fid, '%f,', place_values)
fprintf(fid, '\n');
fprintf(fid, 'Repeated Place: t,')
fprintf(fid, 'f,', ones(1,size(place_values)))
fprintf(fid, '\n');
fprintf(fid, 'Temperature: ')
fprintf(fid, '%f,', temperature_values)
fprintf(fid, '\n');
..
..
% similarly for other fields.
fclose(fid)

Ganesh Kini 2020-6-6

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886184

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886184

Okay i will try.

Is it possible to write using csvwrite function?

i wanted to know about that

Ameer Hamza 2020-6-6

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886190

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_886190

csvwrite is used to write a numeric matrix. It is not useful here.

Ganesh Kini 2020-6-7

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_887672

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_887672

在 MATLAB Online 中打开

Hi Ameer,

When i try to run this code

[fid1, msg1]   = fopen('file.csv');
fprintf(fid1, 'temperature ');
fprintf(fid, '%3.0f,', temp );
fprintf(fid, '\n');
fclose(fid);

Error

>> msg1
  msg1 = No such file or directory
>> fid1
  fid1 = -1
  

I should create a csv file and then enter the values. How can we do it ?

Ameer Hamza 2020-6-8

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_888134

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_888134

在 MATLAB Online 中打开

You need to specify that you want to open the file for writing

[fid1, msg1] = fopen('file.csv', 'w');

Ganesh Kini 2020-6-9

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_890279

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_890279

在 MATLAB Online 中打开

Hi I was running this code

[fid, msg] = fopen ( 'file1.csv' , 'wt' );
assert (fid> = 3, msg)
fprintf (fid, '% s \ t% s \ t% s \ n' , 'Temperature' , 'Value_n' , 'Value_p' );
for 
    for 
        for 
            ...
            fprintf (fid, '% 3.0f \ t% 1.1f \ t% 1.1f \ n' , temp, vnw, vpw);
        end 
    end 
end
fclose (fid);

Output of the code

Temperature Value_n Value_p ,-40 0.2 0.1 20 0.1 0.4 120 0.5 4.5

where as i should get

Temperature, -40 20 120
Value_n, 0.2 0.1 0.5
Value_p, 0.1 0.4 4.5

How can i change to get the above output?

Ameer Hamza 2020-6-9

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_890417

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_890417

在 MATLAB Online 中打开

Try to write it seperately

[fid, msg] = fopen ( 'file1.csv' , 'wt' );
assert (fid> = 3, msg)
fprintf (fid, '% s \t' , 'Temperature');
for 
    for 
        for 
            ...
            fprintf (fid, '% 3.0f \t' , temp);
        end 
    end 
end
fprintf (fid, '\n' , temp);
for 
    for 
        for 
            ...
            fprintf (fid, '% 3.0f \t' , vnw);
        end 
    end 
end
fprintf (fid, '\n' , temp);
% same for vpw
fclose (fid);

Ganesh Kini 2020-6-9

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_890450

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_890450

Yes that would work but i can not use for loop like that, because i have 10 variables

10*3 -- 30 for loops will not be feasible.

Is there any alternate way?

Ameer Hamza 2020-6-9

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_890459

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_890459

在 MATLAB Online 中打开

Something like this

[fid, msg] = fopen ( 'file1.csv' , 'wt' );
assert (fid> = 3, msg)
labels = {'Temperature', 'Value_n', 'Value_p'};
vars = {temp, vnw, vpw}
for i=1:numel(labels)
    fprintf (fid, '% s \t' , labels{i});
    for 
        for 
            for 
                ...
                fprintf (fid, '% 3.0f \t' , vars{i});
            end 
        end 
    end
    fprintf (fid, '\n' , temp);
end
fclose (fid);

Ganesh Kini 2020-6-9

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_890768

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_890768

编辑：Ganesh Kini 2020-6-9

Hi Ameer,

Tried your method, it didn't work as expected

Temperature t 60 60 60 60 60 60 60 60 60 60 60 60

Value_n t 1 1 1 1 1 1 1 1 1 1 1 1

Value_p t -2 -2 -2 -2 -2 -2 -2 -2 -2 -2 -2 -2

Could you please tell me where i can change this?

The value needs to change after one complete execution, but it is not doing that

Ganesh Kini 2020-6-9

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_891128

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_891128

在 MATLAB Online 中打开

size(backend_full)

Output 
  ans =
     12    7

But when i write the above code for repeated values

fprintf (fid2, '\nEnable,t,');

fprintf (fid2, 'f,', ones(1,size(backend_full)));

Output on the csv file
  
  Enable,t,f, 

Please let me know

Ameer Hamza 2020-6-10

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_891638

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/543392-writing-variables-in-csv-file-and-saving-it#comment_891638

编辑：Ameer Hamza 2020-6-10

在 MATLAB Online 中打开

Are all the variables calculated before this line?

vars = {temp, vnw, vpw}

or are they calculated inside for-loop?

请先登录，再进行评论。

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

另请参阅

类别

AI, Data Science, and Statistics Text Analytics Toolbox Modeling and Prediction

在 Help Center 和 File Exchange 中查找有关 Modeling and Prediction 的更多信息

Community Treasure Hunt

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

Start Hunting!

发生错误

由于页面发生更改，无法完成操作。请重新加载页面以查看其更新后的状态。

Translated by

选择网站

选择网站以获取翻译的可用内容，以及查看当地活动和优惠。根据您的位置，我们建议您选择：。

(English)
(Deutsch)
(Français)

（简体中文）
(English)

您也可以从以下列表中选择网站：

如何获得最佳网站性能

选择中国网站（中文或英文）以获得最佳网站性能。其他 MathWorks 国家/地区网站并未针对您所在位置的访问进行优化。

美洲

América Latina (Español)
Canada (English)
United States (English)

欧洲

Belgium (English)
Denmark (English)
Deutschland (Deutsch)
España (Español)
Finland (English)
France (Français)
Ireland (English)
Italia (Italiano)
Luxembourg (English)

Netherlands (English)
Norway (English)
Österreich (Deutsch)
Portugal (English)
Sweden (English)
Switzerland
United Kingdom (English)

亚太

Australia (English)
India (English)
New Zealand (English)
中国
- 简体中文Chinese
- English
日本Japanese (日本語)
한국Korean (한국어)

联系您当地的办事处

Writing variables in .csv file and saving it

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

回答（1 个）

25 个评论
显示 23更早的评论隐藏 23更早的评论

另请参阅

类别

标签

Community Treasure Hunt

Writing variables in .csv file and saving it

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

回答（1 个）

25 个评论 显示 23更早的评论隐藏 23更早的评论

另请参阅

类别

标签

Community Treasure Hunt

WeChat

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

25 个评论
显示 23更早的评论隐藏 23更早的评论