Remove quotes in last column of my table

3 次查看（过去 30 天）
Frank Oosterveld
Frank Oosterveld 2020-4-2
评论： Frank Oosterveld 2020-4-3
Hi,
Atm, I'm reading a big dataset in ML by:
DATA = readtable('data_log_gyro.csv');
Example below
Now I want the third column also in numerical values (so one column split into three columns) instead of in between quotes, I reached out to
opts = detectImportOptions('data_log_gyro.csv');
I tried changing the 'Variable type' to double, but then it's output is NaN
varTypes = {'categorical','datetime','double'};
opts = setvartype(opts,varTypes);
But was unable to find the correct options for this. Anyone who has a clue?

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

采纳的回答

Walter Roberson
Walter Roberson 2020-4-2
You can use the Format option in readtable with a format of
"%{yyyy-MM-dd}D %{dd-MMM-yyyy}D %{hh:mm}T ('%f', '%f', '%f')"
Note that I used double-quotes for the format, so that I would not have to escape the ' characters which are to appear literally.
There are other approaches, using the detected import options and modifying the Prefix and Suffix properties.
  5 个评论
显示 3更早的评论
Walter Roberson
Walter Roberson 2020-4-2
Any follow up ideas on this problem?
Unfortunately, due to social isolation, my sleepless clones have recently not been able to take over for me while I power down for maintenance.
filename = 'Sample.csv';
settings = "%{yyyy-MM-dd}D %{hh:mm:ss}T ""('%f' '%f' '%f')""";
T = readtable(filename, 'Format', settings, 'readVariableNames', false, 'HeaderLines', 0, 'Delimiter',',');
dates = T.Var1 + T.Var2;
num1 = T.Var3;
num2 = T.Var4;
num3 = T.Var5;
Frank Oosterveld
Frank Oosterveld 2020-4-3
This is fantastic, Thanks a lot! Spend a whole day trying to figure this out yesterday.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品


版本

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by