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

csv file split error ","

3 次查看（过去 30 天）
Srtm
Srtm 2021-10-28
评论： Srtm 2023-1-21
I have a csv file with 1.7 million rows and 37 columns. I want to split it into 2 csv files, 850k rows each.Please give me your advice.After the code I wrote, All appear in one column. Where am I doing wrong?
  6 个评论
显示 4更早的评论
Rik
Rik 2023-1-21
I wrote that when I restored your edits on another thread.
Next time, please think before posting what parts you do not wish to share publicly. Since you published it, I'm still legally allowed to share the original post. Just remember next time that the internet doesn't easily forget.
Srtm
Srtm 2023-1-21
Thank you Rik and sorry again

请先登录，再进行评论。

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

采纳的回答

Cris LaPierre
Cris LaPierre 2021-10-28
It looks to me like the issue is that your column offset is 37.
  • The column offset indicates the number of columns to skip before writing the numeric data. col is zero-based, so that col = 0 instructs MATLAB to begin writing in the first column of the destination file. Skipped columns are separated by commas.
By telling it to skip 37 columns, you get 37 commas with nothing between, and it starts writing the 38th column. However, you only have 37 columns of data, so the result is a csv file with nothing but commas. See here.
Try this instead
csvwrite('test.csv',stampstsextport,850000,0)
Also note that csvwrite is not recommended. Consider using writematrix instead.
writematrix(stampstsexport(850000:end,:),'test.csv')
Also note that both of these examples will give you a single file. You would need to have code to create the file of the first 850k rows.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Interactive Control and Callbacks 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by