How can I export a matrix as a CSV file?

3,099 次查看（过去 30 天）
Toby Feld
Toby Feld 2016-4-26
编辑： MathWorks Support Team 2024-11-14，5:50
Hi, I have a 320x2 matrix with doubles. I want to save it in a CSV file in the following pattern: 234,2 671,5 735,1 264,2 346,7 ... etc. I googled this problem and found the function "csvwrite". However, when I use that function like this csvwrite('test.txt',a) I get the following: 234,2671,5735,1264,2346,7 What is going on here? How can I solve this issue? Thanks a lot, Toby
  2 个评论
jgg
jgg 2016-4-26
Why do you want to export it like that? It seems really unnatural, and will be annoying to accomplish.
Ian Mclennan
Ian Mclennan 2019-7-15
This thread really helped me, thank you for posting.

请先登录，再进行评论。

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

采纳的回答

MathWorks Support Team
MathWorks Support Team 2024-11-14，0:00
编辑：MathWorks Support Team 2024-11-14，5:50
"csvwrite" is not recommended. Use "writematrix" to export matrix data as a CSV file instead. When writing matrix data to a file, you can specify the file type as part of the file name in the second argument of the function call: m = [234 2;671 5;735 1;264 2;346 7] writematrix(m,'M.csv')
  4 个评论
显示 2更早的评论
Reem
Reem 2022-10-5
After I do that, how can I see the csv file?
Chris
Chris 2022-11-2
Look at your file hierarchy on the left you'll see a file that's been generated with the name you gave it. You can right click and show it in explorer.

请先登录，再进行评论。

更多回答（4 个）

Azzi Abdelmalek
Azzi Abdelmalek 2016-4-26
a=[234,2
671,5
735,1]
csvwrite('file.csv',a)
  4 个评论
显示 2更早的评论
Bill Tubbs
Bill Tubbs 2019-7-13
Being a Python user coming to Matlab I was a bit shocked to find that csvwrite truncates the data output.
csvwrite('u.csv', u)
File contents:
1000,957.6,917,878.13,840.9, ...
Then I happened to check the documentation and found this:
csvwrite is not recommended. Use writematrix instead. For more information, see Compatibility Considerations.
writematrix(u)
File contents:
1000,957.603280698574,917.004043204671,878.12608018665,840.896415253715, ...
Guillaume
Guillaume 2019-7-13
writematrix is fairly new and did not exist when this question was ask.
I was a bit shocked to find that csvwrite truncates the data output.
Any conversion of number to text will truncate the representation of most numbers, in python as well. As documented csvwrite has a precision of 5 digits. For more precision, the alternative at the time was dlmwrite. Interestingly writematrix also doesn't have an option of altering the precision and always use longg (15 digits of precision).

请先登录，再进行评论。

Jos (10584)
Jos (10584) 2016-4-26
You and your computer disagree on what to use as a decimal symbol: a . or a ,
I strongly recommend you to use a decimal point. Probably that means you have to change your locale / regional settings in the operating system.
Sindar
Sindar 2019-3-12
It sounds like all you need to do is print a column vector instead of a row vector. This can be done easily:
csvwrite('test.txt',a.')
The '.' is important only if you have complex data
Toby Feld
Toby Feld 2016-4-26
编辑：Toby Feld 2016-4-26
For some reason the example I used was re-edited by the forum software to let it appear in one line. I cannot figure out how to disable that formatting (seriously, WTF??). So here is how I want the CSV file to look as a png file. I hope the forum does not change graphic files.

类别

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

标签

尚未输入任何标签。

Community Treasure Hunt

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

Start Hunting!

Translated by