I'm using textscan to read in a csv file, but when I check the variable its incorrect

im trying to read in a csv file(attached) using the code below, but then when i click on the variable from the workspace I dont get the correct cell array (i attached a screenshot of what appears when i select the variable from the workspace). I got this code from the internet and im doing it in the same way, but it still doesnt work.

fid = fopen('NaiveBankData.csv');

readNaiveBankData= textscan(fid, '%d %f', 'HeaderLines',1, 'Delimiter', ',');

Answer 1

[Image Analyst]

Can you try importdata(), readmatrix(), or csvread() instead?

[Tariq Hammoudeh]

i tried this code

importdata('NaiveBankData.csv');

info=readmatrix('NaiveBankData.csv');

but then the values 6327.15, 5489.00, and 1245.80 from the attached from my csv file appear as NaN.

Also, how can i extract a column from this matrix and have it as a variable.

[Image Analyst]

You forgot to attach the csv file. No file was attached other than a screenshot.

[Tariq Hammoudeh]

yes, the screenshot shows the table thats in the csv file. there is nothing else in the file.

I also just attached a screenshot of how the matrix is shown

[Image Analyst]

Well it looks like you got it figured out with Star's code. That's good because there was no way I was going to try to guess what was in 'NaiveBankData.csv', which you refused to upload.

[Tariq Hammoudeh]

im sorry about that i didnt realize the screenshot didnt show the entire thing.

I uploaded the csv file, can i please get help with the other part, because i cant fugure out how to make "ismember" work

Answer 2

[Image Analyst]

Try this:

t = readtable('NaiveBankData.csv')
[rows, columns] = size(t);
% Convert Balance column to double
balances = zeros(rows, 1);
for row = 1 : rows
    thisString = t.Balance{row};
    % Get rid of commas and pound symbol.
    thisString = strrep(thisString(2:end), ',', '');
    balances(row) = str2num(thisString);
end
tB = table(balances(:), 'VariableNames',{'dblBalance'});
t = [t, tB]

You'll see

t =

5×3 table

AccountNumber Balance dblBalance

_____________ _____________ __________

105 {'£6,327.15'} 6327.15

234 {'£203.54' } 203.54

576 {'£52.45' } 52.45

594 {'£5,489.00'} 5489

876 {'£1,245.80'} 1245.8