Importing data without using read functions
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
I have heterogenous data (see textfile) and I am trying to modify my code such that it gives the same output as readtable('kimetsu.txt') and then finally readcell('kimetsu.txt'). I need help modifying it
Text = 'kimetsu.txt';
request = fopen(Text);
clear t
while ~feof(request)
line = string(fgetl(request));
line = line.split(",")';
line = array2table(line);
if exist("t","var")
t = [t; line];
else
t = line;
end
end
for j = 1:width(t) %this is the crucial part (I think) when it comes to modifying the code
t.(j) = str2double(t{:,j});
end
desired output without using readcell
ans =
5×5 cell array
{'Corps members'} {'Names' } {'Nichirins'} {'Lcs'} {'Sw'}
{[ 1]} {'Shenobu'} {[ 99]} {[ 23]} {[67]}
{[ 2]} {'Rengoku'} {[ 78]} {[ 10]} {[23]}
{[ 3]} {'Tanjiro'} {[ 10]} {[ 21]} {[98]}
{[ 4]} {'Akaza' } {[ 500]} {[ 89]} {[11]}
0 Kommentare
Antworten (1)
Jan
am 14 Jul. 2022
Bearbeitet: Jan
am 14 Jul. 2022
T = fileread(Text);
C = strsplit(T, newline);
Head = strsplit(C{1}, ',');
Body = reshape(split(C(2:end), ','), numel(C) - 1, []);
Num = str2double(Body);
Body(~isnan(Num)) = num2cell(Num(~isnan(Num)));
Result = [Head; Body]
2 Kommentare
Jan
am 15 Jul. 2022
This does not happen for me, if I use the input you have provided. If you use another input, please post it.
Maybe your file contains blank lines ate the end? Then:
T = fileread(Text);
C = strsplit(T, newline);
C(cellfun('isempty', C)) = []; % Inserted line
Siehe auch
Kategorien
Mehr zu Text Files finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!