when I using readtable to read .csv file all variable data get mixed, what are the reason for this and provide proper solution for this
2 次查看(过去 30 天)
显示 更早的评论
data3 = readtable('daily_cloud_free_data.csv');
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1331420/image.jpeg)
2 个评论
采纳的回答
Stephen23
2023-3-21
There is no need to change the file format when you can simply specify the delimiter when importing:
T = readtable('daily_cloud_free_data.csv', 'Delimiter',',')
T = rmmissing(T)
0 个评论
更多回答(1 个)
aakash dewangan
2023-3-21
Try this format, in my work it works well :)
T = readtable('Acceleration with g 2023-03-15 23-30-50.xls');
time = (T(:,1)); % column 1
Acc = (T(:,4)); % column 4
time = table2array(time); % column 1 vector
Acc = table2array(Acc); % column 4 vector
1 个评论
Stephen23
2023-3-21
This code:
time = (T(:,1));
Acc = (T(:,4));
time = table2array(time);
Acc = table2array(Acc);
is simpler using the correct curly-brace indexing:
time = T{:,1};
Acc = T{:,4};
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!