How to read and print text cell by cell in csv file ?

firstly See my csv file (test.csv)

Now see code i am using,

InputPython= [csvread('test1.csv',1,0)];
for i = 1:rows(InputPython)
Name = InputPython(i,2)
Length = InputPython(i,3);
width = InputPython(i,4)
D = InputPython(i,5);
Fck = InputPython(i,6);
end_condition = InputPython(i,7)

endfor

output

Name = 0
width =  2
end_condition =  1
Name = 0
width =  2
end_condition =  2
Name = 0
width =  2
end_condition =  3
Name = 0
width =  2
end_condition =  4

Every thing is ok expect Name =0

Name (column 2) have data (S1-101) which is not read by my program because csvread only read numeric.

i tried textscan, importdata, textread they all print full sheet data, but i want result of one by one cell.

Thank you.

i want output like this

Name = S1-101
width =  2
end_condition =  1
Name = S2-102
width =  2
end_condition =  2

[dpb]

readtable

[Jan]

endfor is not Matlab, but Octave. You should mention such details.

textscan can solve the problem. So please post the code you have tried.

[TANDEEP SINGH]

i had posted both code and input (test.csv) files, see my first msg for detail.

output which i get is also posted and output what i want is also suggested.

[TADA]

It seems to me that your code doesn't read the values one by one either, so you can import that CSV file in any of the above mentioned methods and use that same loop to iteratively print (or any calculation you're trying to do) row by row and cell by cell

[TANDEEP SINGH]

my loop is working and it is reading one by one , just problem is that it is not reading Name coiumn as it is mix of text and numeric.

Answer 1

[Guillaume]

The brackets around csvread are useless clutter.

rows is not a valid matlab function.

endfor is not a valid matlab statement.

If your question concerns octave, you're in the wrong forum.

csvread can only read numerical data and will return a matrix of numbers. You cannot use csvread to read your file. To read that file properly in matlab, as has been suggested, the simplest way is to use readtable.

InputPython = readtable('test1.csv');  %all done, will correctly use the header to name the table variables.

[per isakson]

Answer by TANDEEP SINGH ungefär 2 timmar ago converted to a comment

Read Table is not giving right output.

i know my problem can only be solved by textscan so tell me how to use it in this program and i am working on both Matlab and octave and this code belong to octave.

[per isakson]

On Win10 and R2018b

>> T = readtable( 'test1.csv' )
Warning: Variable names were modified to make them valid MATLAB identifiers. 
The original names are saved in the VariableDescriptions property. 
T =
  4×7 table
    Sr_No      Name      Length    Width     D      Fck    end_cond
    _____    ________    ______    _____    ____    ___    ________
      1      'S1-101'      3         2      0.15    25        1    
      2      'S2-102'      4         3       0.1    25        2    
      3      'S3-103'      3         2       0.2    25        3    
      4      'S4-104'      6         4       0.2    25        4    
>> 

Isn't this the "right output" ?

[TANDEEP SINGH]

you have just printed csv file in table form .

This can also be done by textscan, THIS IS WRONG OUTPUT.

I need output of NAME column to be stored in varibale, for example

OUTPUT MUST BE: Method 1

NAME1 S1-101

NAME2 S2-102

NAME3 S3-103

NAME4 S4-104

OUTPUT MUST BE: Method 2

using loop we can get it as

NAME S1-101

NAME S2-102

NAME S3-103

NAME S4-104

Thank you

[per isakson]

I strongly recommend that you first read Access Data in a Table then try

>> T = readtable( 'test1.csv' );
>> stored_in_cell_array = T.Name
stored_in_cell_array =
  4×1 cell array
    {'S1-101'}
    {'S2-102'}
    {'S3-103'}
    {'S4-104'}

and

>> stored_in_string = convertCharsToStrings( T.Name )
stored_in_string = 
  4×1 string array
    "S1-101"
    "S2-102"
    "S3-103"
    "S4-104"    

and

>> NAME3 = T.Name{3}
NAME3 =
    'S3-103'
    

The read TUTORIAL: Why Variables Should Not Be Named Dynamically (eval)

[TANDEEP SINGH]

GOOD WORK THANK YOU

Can we also try this using textscan function